It works. Thank you. M.
2013/4/12 Rob Vermaas <[email protected]>: > The hydra manual at > http://hydra.nixos.org/job/hydra/trunk/tarball/latest/download-by-type/doc/manual > says 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
