[users at bb.net] state.sqlite database disk image is malformed

[Dr. Mark Asbach]

Hi Ryan,

> Builds starting at 1 again is not a problem in Buildbot eight. Certainly once I upgrade our Buildbot setup past eight then it will become a problem, and I will certainly use Postgres at that time, and will have to investigate how to do Postgres backups then as well.

Just a short feedback on this: Postgres does allow non-blocking dumps, so you can replace that Sqlite „vacuum“ with a pg_dump:

https://www.postgresql.org/docs/current/backup-dump.html

> Dumps created by pg_dump are internally consistent, meaning, the dump represents a snapshot of the database at the time pg_dump began running. pg_dump does not block other operations on the database while it is working. (Exceptions are those operations that need to operate with an exclusive lock, such as most forms of ALTER TABLE.)

Best,
Mark
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4652 bytes
Desc: not available
URL: <http://lists.buildbot.net/pipermail/users/attachments/20210301/2537e2c9/attachment.bin>