Table Cleaner compacts the parent table (CMDB TPP migration) when a child table gets cleaned - Known Error

Table Cleaner compacts the parent table (CMDB TPP migration) when a child table gets cleaned Description Due to the CMDB TPP migration, a child table like for example [dscy_route_interface] does not exist physically when extended from a CMDB (main or child) table. As a result, whenever the table cleaner deletes over a certain percentage of records from that table, an online alter is triggered for the partner table, in that case CMDB.

Steps to Reproduce

1. Create a number of records in the table [dscy_route_interface] using a script similar to this one below: var gr = new GlideRecord('dscy_route_interface'); var i; for(i=0; i { gr.initialize(); gr.dest_ip_network = 'test'+i; gr.insert(); }

2. Browse to table cleanup [sys_auto_flush] and open the record for [dscy_route_interface]. 3. Reduce 'Age in Seconds' to a value of 30 or lower, and remove any filter condition to simplify the test. 4. Browse to [sys_trigger] and run the "Execute Now" of the Table Cleaner job.

The following log output is produced: worker.1 worker.1 txid=b665eaa97343 [0:00:00.493] TableCleaner DELETED approximately 229 old records from dscy_route_interface via chunk worker.1 worker.1 txid=b665eaa97343 [0:00:44.774] TableCleaner DELETED approximately 12229 old records from dscy_route_interface via bulk operations worker.1 worker.1 txid=b665eaa97343 Compacting table since 100% of all rows were deleted worker.1 worker.1 txid=b665eaa97343 Creating table: CREATE TABLE tmp_c1754279749b LIKE cmdb worker.1 worker.1 txid=b665eaa97343 [TableChunkCopier] Starting [online_alter] operations worker.1 worker.1 txid=b665eaa97343 [0:00:00.159] Copied chunk 1 of 3 to tmp_c1754279749b[cmdb]

Workaround This problem is under review. To receive notifications when more information becomes available, subscribe to this Known Error article by clicking the Subscribe button at the top right of this form.

As a workaround, add the ' no_optimize ' attribute to the table for which the cleaner is configured. Note that adding it to the root table (CMDB) does not stop the alter.