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

[Ryan Schmidt]

On Feb 27, 2021, at 05:39, Pierre Tardy wrote:

> 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

I understand of course that if the buildmaster is idle and there are no pending builds, then I can stop buildmaster, delete the state.sqlite file entirely, and have buildmaster create a new one. But stopping buildmaster is a time-consuming manual process when there are builds that are running, and usually there are pending builds that I don't want to lose.

What I was hoping for was a set of SQL statements (like "DELETE FROM sometable WHERE status=finished") that I could run from the command line (or daily from cron) while buildmaster is still running that would clear out unneeded data about builds that have already happened while not touching the data about builds that are still pending.