[Nix-dev] Hydra upgrade

[Marco Maggesi]

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