Get rid of very old ProcessedQueueTask with Status=Retrying

0
Hi. We have a number of ProcessedQueueTask objects that are 19 months old. We didn't assign any value to com.mendix.core.ProcessedTasksCleanupAge.   select "t_id", "id", "sequence", "status", "queueid", "queuename", "contexttype", "contextdata", "microflowname", "useractionname", "xasid", "threadid", "created", "startat", "started", "finished", "duration", "retried", length("errormessage") as errormessagelen, "scheduledeventname", "system$owner" from ( select t."id" as "t_id", p.* FROM "system$processedqueuetask" p left join "system$queuedtask" t on t."sequence" = p."sequence" ) t order by "started" limit 10 _ _ t_id id sequence status queueid queuename contexttype contextdata microflowname useractionname xasid threadid created startat started finished duration retried errormessagelen scheduledeventname system$owner 17451448644724807 675133 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process 0f0b1389-4d46-4c75-98a2-fed95b384afd 66 2023-12-13 10:09:29.115 2023-12-13 10:24:37.338 2023-12-13 10:24:47.33 9992 0 7043 562949953421539 17451448644730392 675133 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process bce99403-435a-41d6-9b5c-495a0f6138e6 64 2023-12-13 10:09:29.115 2023-12-13 10:27:47.346 2023-12-13 10:27:52.097 2023-12-13 10:27:58.629 6532 1 7043 562949953421539 17451448644735065 675303 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process bce99403-435a-41d6-9b5c-495a0f6138e6 64 2023-12-13 10:09:29.575 2023-12-13 10:31:33.92 2023-12-13 10:31:59.433 25513 0 7043 562949953421539 17451448644737193 675133 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process bce99403-435a-41d6-9b5c-495a0f6138e6 64 2023-12-13 10:09:29.115 2023-12-13 10:33:58.632 2023-12-13 10:34:03.738 2023-12-13 10:34:10.889 7151 2 7043 562949953421539 17451448644760541 675303 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process 0f0b1389-4d46-4c75-98a2-fed95b384afd 66 2023-12-13 10:09:29.575 2023-12-13 10:34:59.435 2023-12-13 10:35:00.357 2023-12-13 10:35:26.305 25948 1 7043 562949953421539 17451448644791938 675303 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process 0f0b1389-4d46-4c75-98a2-fed95b384afd 66 2023-12-13 10:09:29.575 2023-12-13 10:41:26.307 2023-12-13 10:41:26.582 2023-12-13 10:41:50.871 24289 2 7043 562949953421539 17451448644794524 675133 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process 0f0b1389-4d46-4c75-98a2-fed95b384afd 66 2023-12-13 10:09:29.115 2023-12-13 10:46:10.891 2023-12-13 10:46:11.382 2023-12-13 10:46:14.703 3321 3 7043 562949953421539 17451448644772196 675303 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process bce99403-435a-41d6-9b5c-495a0f6138e6 64 2023-12-13 10:09:29.575 2023-12-13 10:53:50.873 2023-12-13 10:53:50.937 2023-12-13 10:53:57.788 6851 3 7043 562949953421539 17451448644772825 675133 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process bce99403-435a-41d6-9b5c-495a0f6138e6 64 2023-12-13 10:09:29.115 2023-12-13 11:10:14.705 2023-12-13 11:10:14.825 2023-12-13 11:10:18.251 3426 4 7043 562949953421539 17451448644797612 675303 Retrying df8d8fa4-75da-44ca-8f81-179e221eb6a6 BpeMain.Batch3Threads User AuditTrailProcessor.SUB_GenericXmlExportBatch_Process 0f0b1389-4d46-4c75-98a2-fed95b384afd 66 2023-12-13 10:09:29.575 2023-12-13 11:17:57.79 2023-12-13 11:17:58.22 2023-12-13 11:18:05.49 7270 4 7043 562949953421539 _
asked
1 answers
0

I don't know how many tasks you create in your system and how often the Mendix cleanup runs, but maybe this one's causing issues?

 

"com.mendix.core.ProcessedTasksCleanupBatchSize

10000

Specifies how many System.ProcessedQueueTask objects will be removed from the database each time the ProcessedTask cleanup action runs."

 

If you have significantly more than 10.000 expired tasks at any time, it could be that it never gets around to cleaning up the rest.

 

Alternatively, maybe it doesn't clean up the old tasks at all becaues they're set to retrying instead of processed? If you're not getting any new ones in your system that are saved too long, I would consider maybe doing a one-time manual delete of these really old ones. It's not really best practice, but it might solve the issue.

answered