How to clean ProgressQueueTask

0
Why are only 1.000 ProgressQueueTask records being deleted when "ProcessedTasksCleanupBatchSize" is set to 10.000. And where can I set the interval? I have a database with 19 million records. That ius to much for a S21 container.
asked
3 answers
0

What Mendix version are you using?

 

com.mendix.core.ProcessedTasksCleanupBatchSize  

This setting specifies how many System.ProcessedQueueTask objects will be removed from the database each time the ProcessedTask cleanup action runs. See Task Queue for more details.

This setting was introduced in Mendix version 10.9.0

 

Not bad, 800.000 records are deleted But the database has 19 miljoen records ... so wait till the new year.

 

Alternatively you can build you own flow for the delete.

answered
0

Can be set in runtime settings 

https://docs.mendix.com/refguide/custom-settings/

 

image.png

answered
0

Hi Andries,

Thx, my settings are:

  • TaskQueue.ShutdownGracePeriod = 10.000
  • com.mendix.core.ProcessedTasksCleanupAge = 1.000.000
  • com.mendix.core.ProcessedTasksCleanupBatchSize = 10.000

But with this settings only 1000 records will be deleted (why nog 10.000) every 5 minutes.

Today about 800.000 records are deleted But the database has 19 miljoen records. The production database became to big for backup / restore.  

 

 

answered