Loading...
Loading...
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 < 1000; 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]
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.
PRB1322974
Click on a version to see all relevant bugs
ServiceNow Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.