The hydra manual at http://hydra.nixos.org/job/hydra/trunk/tarball/latest/download-by-type/doc/manualsays in 2.5:
.... If you're upgrading Hydra from a previous version, you should do the following to perform any necessary database schema migrations: $ hydra-init ... Hope that helps, Cheers, Rob On Fri, Apr 12, 2013 at 4:49 PM, Marco Maggesi <[email protected]>wrote: > Hi, > > I'm trying to upgrade my hydra server from an old version (3/4 months). > I successfully migrated the nix configuration but it seems that I need > to upgrade the database schema. > > Can you suggest what I have to do in detail? > > Here is the error I get > > DBIx::Class::ResultSet::search(): DBI Exception: DBD::Pg::st execute > failed: ERROR: column me.triggertime does not exist LINE 1: ...h, > me.errormsg, me.errortime, me.lastcheckedtime, me.trigger... ^ [for > Statement "SELECT me.name, me.project, me.description, > me.nixexprinput, me.nixexprpath, me.errormsg, me.errortime, > me.lastcheckedtime, me.triggertime, me.enabled, me.enableemail, > me.hidden, me.emailoverride, me.keepnr, (select count(*) from Builds > as a where a.finished = 0 and me.project = a.project and me.name = > a.jobset and a.isCurrent = 1), (select count(*) from Builds as a where > a.finished = 1 and me.project = a.project and me.name = a.jobset and > buildstatus <> 0 and a.isCurrent = 1), (select count(*) from Builds as > a where a.finished = 1 and me.project = a.project and me.name = > a.jobset and buildstatus = 0 and a.isCurrent = 1), (select count(*) > from Builds as a where me.project = a.project and me.name = a.jobset > and a.isCurrent = 1) FROM Jobsets me WHERE ( ( hidden = ? AND > me.project = ? ) ) ORDER BY name" with ParamValues: 1='0', 2='udini'] > at > /nix/store/chdvwyw98yj1w2nny3mgh40c37x5cp2k-hydra-0.1pre1271-9f027b2/libexec/hydra/lib/Hydra/Helper/Nix.pm > line 170 > > Thanks in advance. > Marco > _______________________________________________ > nix-dev mailing list > [email protected] > http://lists.science.uu.nl/mailman/listinfo/nix-dev > -- Rob Vermaas [email] [email protected]
_______________________________________________ nix-dev mailing list [email protected] http://lists.science.uu.nl/mailman/listinfo/nix-dev
