cleanup_delete_non_assigned_kb causes the server's RAM to explode

esberard · May 19, 2026 - 08:49

Good morning,

We are experiencing an issue with the "cleanup_delete_non_assigned_kb" function of WUA which is run every night around 3am and is overloading our server.

We get the same effect if we use the "Clear unaffected updates" button in the console.

Our KB database represents 183GB and our server is relatively robust nonetheless.

We are on version 2.6.1.17705, but I have not seen a fix for this problem in later versions.

: WAPT-OOM.png (134 KB) Viewed 6626 times

May 19, 2026 - 09:22

Hi Rémi,

there is indeed an issue with the way the SQL cleanup query is written. I'm opening an internal ticket; we'll look into it quickly.

Best regards,

Denis

esberard · May 19, 2026 - 10:02

dcardon wrote: ↑May 19, 2026 - 09:22 Hi Rémi,

there is indeed an issue with the way the SQL cleanup query is written. I'm opening an internal ticket; we'll look into it quickly.

Best regards,

Denis

Thank you Denis, I await your feedback on the fix.

esberard · May 20, 2026 - 08:22

Hello Denis,

We really need a quick fix, or at the very least, to be told how to disable this purging function every night at 3am because we end up with a server down almost every other morning.

: WAPT-OOM2.png (134.75 KB) Viewed 6510 times

esberard · May 26, 2026 - 11:12

Hello,

do you have any idea when this patch will be released?

Thank you very much,

Rémy

May 27, 2026 - 5:08 PM

Hi Rémi,

it's been fixed in master/2.7 (the next major release is coming soon

). We still need to backport it to 2.6.1, and that will be in the next release.

We'll keep you posted.

Denis

esberard · May 28, 2026 - 08:54

Hello Denis,

Thank you for the feedback, I'm eagerly awaiting the release.