Re: [Buildd-tools-devel] RFC: Creation of a PostgreSQL database schema for wanna-build data
On Tue, Jan 27, 2009 at 11:58:55AM +0100, Adeodato Simó wrote:
> * Marc Brockschmidt [Mon, 26 Jan 2009 19:25:08 +0100]:
> > >> I'd also like to store the build time and space statistics (currently
> > >> stored by sbuild in a GDBM database) stored here along with the logs.
> > > Ok, I added those as well, but without a NOT NULL restriction, otherwise
> > > it'll be impossible to import old logs. If somebody cares enough, once
> > > we have this DB up and the old logs imported we can run a daily job to
> > > slowly fill in that information, if it's easily retrievable from the log
> > > itself (which I think it is).
> > tail -n 1 on any build log will yield
> > | Build needed $time, $sizek disk space
> > This could (and should) be imported when the old build logs are
> > imported.
> Oh, btw, would it make sense to store the name of the buildd that
> produced the log?
I think so. Ideally, I'd like this coupled to the built/failed state
in the state table, which already has the buildd user as the builder
making the change. However, doing this for old logs might be
difficult (but not impossible--all the info is in the log).
.''`. Roger Leigh
: :' : Debian GNU/Linux http://people.debian.org/~rleigh/
`. `' Printing on GNU/Linux? http://gutenprint.sourceforge.net/
`- GPG Public Key: 0x25BFB848 Please GPG sign your mail.