[users at bb.net] Deleting old buildmasters

[Linus Arver]

On Fri, May 19, 2017 at 03:21:36PM +0000, Pierre Tardy wrote:
> Hi Linus,
> 
> There is not yet official way to cleanup old masters.
> Buildbot 0.9.7 introduced the Janitor for that purpose, which for now only
> clean's up old logs.
> The idea is that we should implement cleanup for the other data over time.

Good to hear.

> Any help will be greatly appreciated to implement the remaining bits.

FWIW, I found a workaround. I realized that the hostname of the
container could be set directly by passing `--hostname foo' to my
`docker run' invocation. Then the hostname remains static between
container deletions/restarts.

Linus
> 
> Pierre
> 
> 
> On Thu, May 18, 2017 at 12:01 AM Linus Arver <linusarver at gmail.com> wrote:
> 
> > Hello list,
> >
> > I am running buildbot 0.9.6 in a Docker container, where it talks to a
> > persistent Postgres instance that runs directly on the host. Each time I
> > recreate and restart the container (thus getting a new container id,
> > which is also the hostname of thet container), I get a new entry in the
> > `masters' table in Postgres, like this
> >
> >     bb=> select * from masters;
> >      id |              name              |                name_hash
> >          | active | last_active
> >
> > ----+--------------------------------+------------------------------------------+--------+-------------
> >       3 | 8ca58cb394eb:/var/lib/buildbot |
> > e9be010d83a1ba038d7588f827c45596cadc30f0 |      1 |  1495054677
> >       1 | 79a58211314a:/var/lib/buildbot |
> > 82957e4bd1448caeec776b9f1627e4e17727ff11 |      0 |           0
> >       2 | bf927d013d62:/var/lib/buildbot |
> > a9c43dc195ada6bd95ee5a46f04f54c743a647c5 |      0 |           0
> >     (3 rows)
> >
> > . In the web interface these obsolete buildmasters show up as having
> > been active 47 years ago (because the UNIX timestamp is 0 for these).
> >
> > Is there a way to delete these old buildmasters, without manually going
> > into Postgres (with `delete from masters where last_active = 0;')? I
> > just find it annoying that the web interface displays these old
> > buildmasters with no way to delete them.
> >
> > Best,
> > Linus
> > _______________________________________________
> > users mailing list
> > users at buildbot.net
> > https://lists.buildbot.net/mailman/listinfo/users
> >