HY000 5065 ERROR 5065: Too many ROS containers exist for the following projections

Quicker21

I'm using odbc on Linux to run an R program against one of my schemas.  I can read without issue, but saving the data back gives me this error:

 

Error in sqlSave(con, dat = final_expected, tablename = "ra_exp_cost") :
  [vRODBC] Failed exec in Update
HY000 5065 ERROR 5065:  Too many ROS containers exist for the following projections:
ra_exp_cost_super (limit = 91136, ROS files = 91136, DV files = 0, new files = 89)
HINT:  Please wait for the tuple mover to catch up.  Use 'select * from v_monitor.tuple_mover_operations;' to monitor
Execution halted
Warning message:
closing unused vRODBC handle 1

 

If I try this same program using JDBC it just hangs on the save.  This exact same program works without issue in our MySQL installation, but we are trying to migrate off MySQL into Vertica.

 

Also, this exact same program works in one of our customer's local Vertica installation, so I know this program works, just can't figure out why MY Vertica install is having issues.

SruthiA

Hi,

 

      Please perform a mergeout on the table 'ra_exp_cost' and then try executing your R program again

 

select do_tm_task('mergeout', 'ra_exp_cost');

 

 

Sruthi

Quicker21

I'm just getting into Vertica, so this is new.

 

I get this error when doing the mergout

 

select do_tm_task('mergeout', 'ra_exp_cost');
WARNING 4098:  No projections found
   do_tm_task    
-----------------
 Task: mergeout

(1 row)

 

 

SruthiA

Hi,

 

     Where is this table present? Try by appending the schema sname (schema.table). If you still get the error, then get the list of associated projections for that table and do a mergerout. You can get the list of projections associated with that table from PROJECTIONS system table

 

select * from projections where ANCHOR_TABLE_NAME ilike '%ra_exp_cost%';

 

For more information on how to use DO_TM_TASK, visit the following URL

 

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/SQLReferenceManual/Functions/VerticaFunctions/DO_TM_TASK.htm?Highlight=DO_TM_TASK

 

Sruthi

AnitaM77

Hi Sruthi,
The mergeout worked for once but again it failed with same error.
Too many ROS containers exist for the following projections:
Any pointers?

Jim_Knicely

@AnitaM77

Please check out this post:

https://www.vertica.com/kb/Tuple-Mover-Best-Practices/Content/BestPractices/Tuple-Mover-Best-Practices.htm

Let us know what specific issues you are having and we can help.