sys_flow_context_inputs_chunk can balloon to 1+ TB - Known Error

sys_flow_context_inputs_chunk can balloon to 1+ TB Description Input chunks can balloon to 1+ TB

Steps to Reproduce

In some cases, we saw sys_flow_context_input_chunks ballooned to more than 4TB

Workaround Run the script to add index on sys_created_on, update the reference_cascade_rule and add a new sys_auto_flush record

var index = new IndexCreator("sys_flow_context_inputs_chunk", "sys_created_on", false, null, "sys_created_on"); index.execute();

// update the reference_cascade_rule from delete to none var dic = new GlideRecord("sys_dictionary"); dic.addQuery("name", "sys_flow_context_inputs_chunk"); dic.addQuery("element", "document_id"); dic.query(); if (dic.next()) { gs.info("reference_cascade_rule before change is " + dic.getValue("reference_cascade_rule")); dic.setValue("reference_cascade_rule", "none"); dic.setWorkflow(false); dic.update(); gs.info("reference_cascade_rule after change is none ? -> " + dic.getValue("reference_cascade_rule").equals("none")); } // create a new sys_auto_flush record // check if it has original_inputs column var gr = new GlideRecord("sys_dictionary"); gr.addQuery("name", "sys_flow_context_inputs_chunk"); gr.addQuery("element", "original_inputs"); gr.query(); var hasOriginalInputsCol = gr.hasNext();

var autoFlush = new GlideRecord("sys_auto_flush"); autoFlush.initialize(); autoFlush.setValue("tablename", "sys_flow_context_inputs_chunk"); autoFlush.setValue("age", "3628800"); // 42 days autoFlush.setValue("matchfield", "sys_created_on"); if (hasOriginalInputsCol) { autoFlush.setValue("conditions", "original_inputs=false"); } autoFlush.setWorkflow(false); autoFlush.insert(); last step - make sure the "disableTableCleaner" attribute on sys_flow_context_inputs_chunk table is false go to sys_dictionary, find the table sys_flow_context_inputs_chunk, and then select the record whose type is collection, then go to the attributes part, change the disable table cleaner to false Related Problem: PRB1717537