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

[Pierre Tardy]

As buildbot eight is so old, I am afraid, we only vaguely remember what are
the gotcha.

If you are desperate to restart your master, I would  suggest to just start
from empty DB.

You will still keep the old build state and results, but you will lost the
mapping with changes.
So console/waterfall will start from scratch.

Regards
Pierre


Le sam. 27 févr. 2021 à 10:53, Dr. Mark Asbach <mark.asbach at pixolus.de> a
écrit :

> Hi Ryan,
>
> This surprises me because for all of its faults I was under the impression
> that Time Machine does at least back up file contents correctly. But I
> don't know whether an sqlite database is in a consistent state on disk
> while it is being used e.g. by Buildbot.
>
>
> Unfortunately, unless you lock your database before a backup,
> copying/backing up an open Sqlite database file will not work. See
> https://sqlite.org/backup.html.
>
> Is there any other better way to recover data from a malformed sqlite
> database or to determine in what way it is malformed?
>
>
> Not that I know of any unsupervised way to sanitise a broken buildbot
> database. But you could have a look at the database yourself and see if
> there is anything that looks broken and remove those records manually. As
> you’re on a mac, have a look at Liya
> https://apps.apple.com/de/app/liya/id455484422?mt=12.
>
> Best,
> Mark
> _______________________________________________
> users mailing list
> users at buildbot.net
> https://lists.buildbot.net/mailman/listinfo/users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.buildbot.net/pipermail/users/attachments/20210227/16930bb6/attachment.html>