[users at bb.net] state.sqlite keeps growing in Buildbot eight

[Pierre Tardy]

In eight, the only state that is important to keep is the changes.
It also keeps the pending buildrequest queuem which is not currently
building.
Probably most of the tables can be safely cleared as long as you stop an
idle master

Pierre


Le sam. 27 févr. 2021 à 06:16, Ryan Schmidt <buildbot at ryandesign.com> a
écrit :

> Are there any SQL statements that I can run manually from time to time to
> remove obsolete data? Or is the information about which data is obsolete
> not stored in the database?
>
>
> On Feb 26, 2021, at 04:10, Pierre Tardy wrote:
>
> > Indeed, this is a problem of buildbot eight, that we tackle in buildbot
> 1.0+.
> > Those new version have the concept of Janitor which will clean some of
> the data in the DB.
> > Regards
> > Pierre
> >
> >
> > Le ven. 26 févr. 2021 à 09:24, Ryan Schmidt a écrit :
> >> As I understand it, in Buildbot eight the state.sqlite file only stores
> information about builds that are scheduled. Information about builds that
> have already been completed is not stored there. Why then does the size of
> the state.sqlite file seem only to increase, never to decrease? Isn't it
> bad for the wear and tear of my disk to be constantly rewriting a
> several-hundred-megabyte-and-growing file containing mostly obsolete
> information?
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.buildbot.net/pipermail/users/attachments/20210227/f51e47ee/attachment.html>