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

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

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)

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

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?

@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.