[Nix-dev] Hydra upgrade

[Rob Vermaas]

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 <maggesi at math.unifi.it>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
> nix-dev at lists.science.uu.nl
> http://lists.science.uu.nl/mailman/listinfo/nix-dev
>



-- 
Rob Vermaas

[email] rob.vermaas at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.science.uu.nl/pipermail/nix-dev/attachments/20130412/6832f27b/attachment.html