search

timgit / pg-boss

Queueing jobs in Postgres from Node.js like a boss
MIT License
2.12k stars 158 forks source link

Rows arnt automatically deleted #258

Closed Grigsuv closed 3 years ago

Grigsuv commented 3 years ago

There are many this that I have seen old jobs in the job table that arent deleted after expires and keep until have passed, This is how config looks like

newJobCheckInterval: 10000, expireCheckIntervalMinutes: 1, archiveCompletedAfterSeconds: 262800, // 73 Hours eleteAfterMinutes: 15, maintenanceIntervalMinutes: 60

Version: ^5.2.0

There are no logs or other things that I can find, how can I find out the reason and fix this? Maybe update to lastest version will solve this ?

timgit commented 3 years ago

I recommend updating to the latest version

Grigsuv commented 3 years ago

@timgit are there any breaking changes? How can I find something like 'migration guide'?

timgit commented 3 years ago

see the changelog

Grigsuv commented 3 years ago

@timgit ok thanks, I will try to update it, one last question, can you provide some good examples of configuration? For example, should we use maintenance, what options can be helpful, etc...

timgit commented 3 years ago

No problem at all. I would recommend using the default options unless it produces an issue with your use cases.