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