SQLite isn't properly supported by Hydra for a few years now[1], but Hydra still depends on it. Apart from a slightly bigger closure this can cause confusion by users since Hydra picks up SQLite rather than PostgreSQL by default if HYDRA_DBI isn't configured properly[2]
[1] 78974abb6943533c3d94c7bd3282bf738b7be61c [2] https://logs.nix.samueldr.com/nixos-dev/2020-04-10#3297342;
75BCCX2TABRXQFYV73D6QU3VCT7LZUZEOWUK4X5USPWWTBTVJTLQC
3K3YNRYU5OURTAPYER4N4Z3LD7AKIGK2DKDTRT3PBYHZZ3NQWATAC
H4KMCXGUC5MA7AZUN33GQQWCP66UP7T6IYGJB6HY5AUSKVS32YZAC
3HRBFWGK2JHMIV76HEF52DEJPMXFW6W6LL3ISFVPREPOW7AYHX3QC
TOLUNFACYKO3KHNZBULYO37LYJB7DB7JEY7NMCZCCDJF3EU6TVFQC
FZR7ET5DMHNNGB24QVFVVTGT3F6OKGG4PX7HW2YLJPBAUDVNJJHQC
UCTIA3HC36RDRYUATLEUBJM6O6ZULGH323NJGFG5AULQ7YLFYIZAC
AJSFZ2YNCPFRMJ3I6MTWKQLJYQ4DATD67Q3Z3RMZUAONKZ6WMPEQC
RWNXH3H26EQHKJNMP4DUJCJKUYQBMV347234ZLE26SIFTVLSUWXQC
GBCPEGYCLFC5FUNAK2BV47G3EGQ26TPXSFCKVCY23QYET7A5A5YAC
4HPT4SDDNU24OX2P4FDP2KXKINDCJLZEBN2VIEEKWFEVT4TNWXZAC
UUGBVEGYV3FUNL7D3ECA2DIMFHE2S5UQF4ACSLESX3M3NRYYE57AC
PKE6I67S7TDGKEFCKIQZOZ5PSDZXCSPOQGSKDAE5NST3NOOLRUXAC
3PNG7NIBQQURUUPRVQXYL342OT7JUUYOMY2JJNP6YDX7SYJDZMYAC
TJK27WSBFOM6LKVCSA7LTTCWUGB4O2AL22PNIDQXS4BFOFCISH2QC
J5UVLXOK6EDIL5I7VKWH4V2QDS4DPD7FHRK6XBWSXFRQS4JKXFZQC
AMFMXR52JXHUOWWG4VZ5DHQGLF4F7H7XSJRLX5XNEXOCCWYLDQOAC
32MXC7NNZKN5KFZNMS6J22LHLL4WQJFKTWHBKAJVDM6NBORIKAEAC
KN3VYE5P2RJB3KZ355LA5C2T2D5S2IR3QZFE53AJIWUVMETEEYDAC
N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC
BXHG3HYLCKXL35S2MCIBTXTP6UO55NASYE7XCLQP4PXPSVDMUIAQC
ACBS7C6QGXAMPLQ336WAQMMGLZXBDNNYPE26ZBPUQ24GL4BF643AC
4YCF3KBGI4VYKHJXAREJLCJLY3UWB2FX447CJ4XQWFRKRFKG5WCQC
L2E6EVE2RVFVDCUNRJ4CZYSQNS2DZUA5DTBETHBDUQUV2KQQRAOQC
RVHBV3B3RA3QTPQFCTICFFG5QGRUZ7EGXZNR4W2MOM2HPBHPZV7AC
WE5Q2NVIIK4R2DUUZYLJFQVYK5O26EDEJRPK3CPGWHU3SEAC2DQAC
67P45PY4GTWQXZRCMR734D5YYN2OERZM57NBB2CZXEULQT2GRFNAC
RFE6T5LGBFFNEPHZOPF4UNMFC2L4CGD5TPAMOXDLRPH3TZJ43UBAC
ZWCTAZGLJZQNTYWTC2XQUKMILJF6JGDL5IND6QNYWK4FIGMLRFXAC
RYTQLATYOZ6ODIKYVJ63TC4OIQBXHSCV3NA2YD4NFP7443GQVSRQC
FANTYCR7X2TYLJKGO3E5CU4PVXPSOMQZELEFQCZ6E7GEJOPYXQUAC
4MBKR4XMMBQLYXZ7DN2MF7P7DIJCFOOHEDTRUGHCQFAV4TE2YCLAC
SMCOU72FKTPFNCDXFJAILVUWFE4DY33CJJE4436H5POKENFFDFFAC
6COLDXKSOIZXICAUY2MUKSW6ZKXLV6MBIJ3ENAU74SUQDRFGPPEQC
2KLEQJTGFS4G4FSUMF6XMJ4N5OSVQ2S5A4GMA7YO7MS3BV5PMH3QC
LAJHRL6OZJYTGRO2X4XBGOYWM2NJ3OFDVDN3HQQUCJBTE4ZOBJNQC
G2ZB6464XGPBIMSZIPSB24EIXSCCGV4XWC3IWPS2CXYPDSUZSU5QC
3VRZBVFXHS5W4UWQIMDBTSI2EI3N4AJOAW2Z5ZO3M26WJGCC3CXQC
NQPGIRXXVS356MRCPVTV4LCCMUEOVHGCQGXJNPJTSK6HGLYZJKEQC
ZHBEOOUQS46RWOJUV4AFCKI7JDASDNGT7KVSHPJK7DRBXW7SSROAC
I3TU2UJQITUMLMVLLC5SZ3VSSO3XUXGUFV5FLHO6T663WHOF5QYAC
7RO7CINMZYA7TMACQEERL6MIQO7LZRKHVVW7FTQIS4TMJPYYLOHAC
V2ALOFRRXCDVWOED74BORKDSVVIQHLWOC7FMUTPHORGFB6XRURMQC
WHS5RMPOJIHWRANRNCI2PQQQ5FXF3OOYN7BC23EBPY5QIU74KK6AC
HX4QYOYAKKFKK4KF6SZ6FQCM5ZF7ZFDTQUR4GS5WPPTYZASYZZUAC
7VQ4ALFYKJBFR46T3WZDMGOXNRR3QNJEJQVBYJM4HSJUOOUD6WBQC
A43SLRSH6OIIEZWLRKLMERX7HOMBICKG7WHELCZYLOJWZ3JFRV2AC
GAZHOBWEXOSWFNJYOYXASH3LCOLREWB3DZXELIAP2Q6L2X2ZSI4QC
VOBFCHIXMHWXLRA2EBJVKGIIYDGMVYOVQAUTKCHWRSUHV34XS57AC
tests/jobs/config.nix
$ sqlite3 hydra.sqlite "insert into Users(userName, emailAddress, password) values('root', 'e.dolstra@tudelft.nl', '$(echo -n foobar | sha1sum | cut -c1-40)');"
$ hydra-create-user root --email-address 'e.dolstra@tudelft.nl' \
--password-hash "$(echo -n foobar | sha1sum | cut -c1-40)"
<screen>
I'm very sorry, but an error occurred:
DBIx::Class::ResultSet::create(): DBI Exception: DBD::SQLite::st execute failed: column name is not unique(19) at dbdimp.c line 402
</screen>
So try to create the project after entering just the general
information to figure out if you have chosen a unique name.
Job sets can be added once the project has been created.
So try to create the project after entering just the general
information to figure out if you have chosen a unique name.
Job sets can be added once the project has been created.
my $db = $ENV{"HYDRA_DBI"};
return $db if defined $db;
my $path = getHydraPath . '/hydra.sqlite';
#warn "The Hydra database ($path) does not exist!\n" unless -f $path;
return "dbi:SQLite:$path";
return $ENV{"HYDRA_DBI"} || "dbi:Pg:dbname=hydra;";
db.sqlite: $(top_srcdir)/src/sql/hydra-sqlite.sql
$(TESTS_ENVIRONMENT) $(top_srcdir)/src/script/hydra-init