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

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 Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

Migrating From Oracle to PostgreSQL using ora2pg open source tools

PostgreSQL Pgbadger Installation On Linux