we get error [ERROR] Rolling back MB: [Vertica][VJDBC](2245) ERROR: Attempted to create too many ROS

torenoxx

Hello.
We deployed Investigate and vertica db.
After deployed Vertica, events come to vertica. But after one day we get this error
[ERROR] Rolling back MB: [Vertica]VJDBC ERROR: Attempted to create too many ROS containers for projection investigation.events_txtidx_super

Why this happen?
How i can fix this error?

Jim_Knicely

Check out these blog posts:

https://www.vertica.com/kb/TroubleshootingROSPushback/Content/BestPractices/TroubleshootingROSPushback.htm

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

https://www.vertica.com/kb/Understanding-Vertica-Epochs/Content/BestPractices/Understanding-Vertica-Epochs.htm