[Nix-dev] hydra sql errors

[Eelco Dolstra]

Hi,

On 01/06/13 12:36, Peter Simons wrote:

> the following error shows up in may logfiles every few seconds from
> Hydra 0.1pre1331-4b1a838:
> 
>   [4-1] ERROR:  column me.active does not exist at character 40
>   [4-2] STATEMENT:  SELECT me.project, me.jobset, me.name, me.active, me.errormsg, me.firstevaltime, me.lastevaltime FROM Jobs me WHERE ( ( me.jobset = $1 AND me.name = $2 AND me.project = $3 ) )
> 
> Is it possible that the database updating procedure doesn't work as
> expected?

The "Jobs.active" column was removed in revision 7b5e928.  I guess you ran
hydra-init from a newer revision but are running hydra-server from an older
revision?

> I tried updating to the latest version of Hydra, but that version won't
> even start:
> 
>   hydra-server[1539]: Duplicate specification "host|h=s" for option "h"
>   hydra-server[1539]: Use of uninitialized value in list assignment at /nix/store/2d7kv57cnkzb1qqj8cb7a14zabkdqk0x-hydra-perl-deps/lib/perl5/site_perl/5.16.2/MooseX/Getopt/Basic.pm line 135.
>   hydra-server[1539]: Unable to handle files with the extension 'conf' at /nix/store/2d7kv57cnkzb1qqj8cb7a14zabkdqk0x-hydra-perl-deps/lib/perl5/site_perl/5.16.2/Catalyst/Plugin/ConfigLoader.pm line 141.

This should be fixed now (revision 66c695e1c30122477a485f9fc79077684b866ddd).

-- 
Eelco Dolstra | LogicBlox, Inc. | http://nixos.org/~eelco/