DB compaction fails when there is a table with more than 2,147,483,647 number of rows - Known Error

DB compaction fails when there is a table with more than 2,147,483,647 number of rows Description The compaction job runs nightly to compact eligible fragmented tables, reclaiming unused allocated database storage space and improving query performance.

However, the compaction job fails if any table has a record count greater than 2,147,483,647. As a result, Glide is unable to compact any eligible tables. This issue prevents the reclamation of unused allocated database storage space, potentially leading to degraded query performance over time.

Affected Version - Yokohama and Zurich

Steps to Reproduce

Insert more than 2,147,483,647 rows into a table. Navigate to the sys_trigger table and run the 'DB compaction' job. The DB compaction job fails with the following error: 'CompactionQualificationJob SEVERE *** ERROR *** Compaction qualification failed: java.sql.SQLException: Out of range value for column 'table_rows': value 7854795901 is not in class java.lang.Integer range'." Workaround Customers can compact specific tables using the following script in 'Scripts Background':

new GlideTableCompactor().compact('the_table_you_want_to_compact'); This will schedule a compaction job for the specified table, and the job execution will be recorded in the sys_compaction_run table.

Note : For tables with more than 2,147,483,647 rows, this compaction API will still fail. In such cases, please involve the DB team to perform table compaction manually.