The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Too many ROS Container

Hi,

can somebody help in the below error we are getting in, actullay we have done mergeout moveout multiple time but currently there are huge number of transaction we need to be catered and insert in to the table, is any best practices to optimized ROS for table projection,.

java.lang.RuntimeException: process: throws SQLException[Vertica]VJDBC ERROR: Too many ROS containers exist for the following projections:
FAS.TMP_OC_ACTIVE_ALARMS_COUNTERS_b1 (limit = 45664, ROS files = 45656, DV files = 0, new files = 13)
at com.hp.ossa.batch.batchlet.OssaBatchlet.onStepError(OssaBatchlet.java:460)
at com.hp.ossa.batch.batchlet.jdbc.SqlBatchlet.processStep(SqlBatchlet.java:117)
at com.hp.ossa.batch.batchlet.jdbc.SqlCDCBatchlet.processStep(SqlCDCBatchlet.java:247)
at com.hp.ossa.batch.batchlet.OssaBatchlet.process(OssaBatchlet.java:150)
at org.jberet.runtime.runner.BatchletRunner.run(BatchletRunner.java:72)
at org.jberet.runtime.runner.StepExecutionRunner.runBatchletOrChunk(StepExecutionRunner.java:229)
at org.jberet.runtime.runner.StepExecutionRunner.run(StepExecutionRunner.java:147)
at org.jberet.runtime.runner.CompositeExecutionRunner.runStep(CompositeExecutionRunner.java:164)
at org.jberet.runtime.runner.CompositeExecutionRunner.runFromHeadOrRestartPoint(CompositeExecutionRunner.java:88)
at org.jberet.runtime.runner.JobExecutionRunner.run(JobExecutionRunner.java:60)
at org.wildfly.extension.batch.jberet.impl.BatchEnvironmentService$WildFlyBatchEnvironment$1.run(BatchEnvironmentService.java:243)
at org.wildfly.extension.requestcontroller.RequestController$QueuedTask$1.run(RequestController.java:497)
at org.jberet.spi.JobExecutor$3.run(JobExecutor.java:161)
at org.jberet.spi.JobExecutor$1.run(JobExecutor.java:99)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)

also i have found the below link to troubleshoot ROS, how can i increase the ROS limit for specific projections.

Br,

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.