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

[Ryan Schmidt]

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?