Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

it caused by your batch size too small, which lead to a lot of ROS Containers created and reach the limitation(1024 default). you should do defragment using TupleMover task(mergeout) before the error raised.
To do troubleshooting:
  1. ROS Containers viewed from the projections.
select * from STORAGE_CONTAINERS where projection_name like '%DATASET_TABLE%';
  1. check ContainersPerProjectionLimit settings Views
SELECT *
FROM CONFIGURATION_PARAMETERS
WHERE parameter_name = 'ContainersPerProjectionLimit' ;
  1. ROS Container Number Lookup
select count(*) from STORAGE_CONTAINERS where projection_name like '%DATASET_TABLE%';
  1. Solutions
-- change ContainersPerProjectionLimit settings
SELECT SET_CONFIG_PARAMETER('ContainersPerProjectionLimit', 2048);
or
-- change mergeout frequency
SELECT SET_CONFIG_PARAMETER('MergeOutInterval', 30);
or
-- Do TupleMover Task manually
select do_tm_task('mergeout','projection_name')

Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Database startup / shutdown /restart

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?