Package: crowdsec Version: 1.4.2-1 Severity: important Hi,
This report is the counterpart of #1033029 (old crowdsec can't work with newer libsqlite3-0 due to now-invalid assumptions in the Ent stack): new crowdsec embeds a newer Ent stack that relies on features introduced in sqlite3 3.35.0, which is between bullseye's and bookworm's versions: https://www.sqlite.org/lang_returning.html This was found when checking the upgrade path between bullseye and bookworm, crowdsec 1.4.x vs. libsqlite3-0 3.34.1-3 triggers this: Setting up crowdsec (1.4.6-1+b1) ... I: Registering to LAPI (/etc/crowdsec/local_api_credentials.yaml) WARN[0000] CreateMachine : near "RETURNING": syntax error FATA[17-03-2023 23:01:45] unable to create machine: creating machine 'fae6c46c0fba4f11992f09676aa9d748': unable to insert row dpkg: error processing package crowdsec (--install): installed crowdsec package post-installation script subprocess returned error exit status 1 Errors were encountered while processing: crowdsec The dependency on libsqlite3-0 is one of the few dependencies obtained by linking against system libraries: Depends: ca-certificates, libc6 (>= 2.34), libsqlite3-0 (>= 3.12.0) The next step for me is to check whether hardcoding a dependency on libsqlite3-0 (>= 3.35.0) results in a suitable upgrade path from bullseye. Cheers, -- Cyril Brulebois -- Debian Consultant @ DEBAMAX -- https://debamax.com/
