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 Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart

7 Steps to configure BDR replication in postgresql

Top 20 Highest Paying URL Shortener Companies - Best URL Shorteners To Earn Fast