[Nix-dev] Hydra upgrade

[Marco Maggesi]

It works.
Thank you.
M.

2013/4/12 Rob Vermaas <rob.vermaas at gmail.com>:
> 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 <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