Many SystemCommand Records being inserted to ECC queue table for all MID servers when a sys_user_group record is deleted - Known Error

Many SystemCommand Records being inserted to ECC queue table for all MID servers when a sys_user_group record is deleted Description Deleting a group (sys_user_group) causes multiple SystemCommand Records being inserted to ECC queue table.

When deleting mass amounts of groups, it will cause instance performance issues and slowness.

It can also cause performance issues to MID servers - e.g. probes are taking long time to process / eventually getting timed out.

Steps to Reproduce

delete any sys_user_group from UI, or use background script below to delete a group:

var gr=new GlideRecord('sys_user_group'); gr.addQuery('sys_id','fffff42adb4230182ffe132968961960');gr.setWorkflow(false); gr.query(); if(gr.next()){ gr.deleteRecord();}

Review the ecc queue records created with topic SystemCommand.

Workaround Currently ecc_queue records are only generated once per 10 minutes.

E.g. Once there's a deletion, SystemCommand ecc_queue records are generated. Then in the next 10 minutes, further deletions are not triggering ecc_queue records.

Try to plan a window to proceed with delete actions and complete within 10 minutes, this way only one batch of SystemCommand is inserted.

Try not to delete sys_user_group randomly and frequently over the day.