[Vertica][VJDBC](5065) ERROR: Too many ROS containers exist for the following projections
I am doing some tests on a datamart whose data is loaded through Pentaho.
Loading is done through inserts with commit every 10.000 rows.
Loading always crashes with this error:
Caused by: java.sql.SQLTransientException: [Vertica]VJDBC ERROR: Too many ROS containers exist for the following projections:
2020/10/07 17:19:30 - dm_esenzioni.SOGGETTO_super (limit = 18432, ROS files = 18432, DV files = 0, new files = 9)
To remedy this error I applied some tips found on the vertica forum,but the problem is still there :
i increased the server memory
-I modified the vertica parameters like this :
SELECT SET_CONFIG_PARAMETER('MergeOutInterval', 30);
SELECT SET_CONFIG_PARAMETER('ContainersPerProjectionLimit', 10240);
ALTER RESOURCE POOL general PLANNEDCONCURRENCY 5;
I have recalculated the statistics of all the tables in the datamart
Vertica is on a single node.
I use Pentaho5, are there compatibility issues with vertica 10?
How can I solve the problem?
if you can, give me some solution.
Thank you so much for your help.