On Sat, Aug 14, 2021 at 11:20:47AM +0100, Adam D. Barratt wrote: > ullmann.debian.org, the host for udd.d.o, filled its PostgreSQL > partition overnight. DSA added another 5GB of space, but within a few > hours around 3GB of that had already been used. Uh. > Looking at the PostgreSQL logs, it appears that auto-cleanup of deleted > records in some of the tables hasn't been working correctly for a > while, which may be adding to the space usage. I see (also through the #debian-admin logs) that the space got under control after a few runs of the autovacuum. > For the moment, I've disabled all of the "udd" user's crontab, to try > and stop the rate of disk increase, and allow the auto-cleanup a chance > to run and hopefully free some more space. I hadn't had a chance to investiage anything, so I'm not re-enabling rudd. But I've re-cronned some bits that I'm positive should not cause any trouble. -- regards, Mattia Rizzolo GPG Key: 66AE 2B4A FCCF 3F52 DA18 4D18 4B04 3FCD B944 4540 .''`. More about me: https://mapreri.org : :' : Launchpad user: https://launchpad.net/~mapreri `. `'` Debian QA page: https://qa.debian.org/developer.php?login=mattia `-
Attachment:
signature.asc
Description: PGP signature