Package: libsqlite3-0
Version: 3.34.1-3
Severity: important
Tags: patch
X-Debbugs-Cc: debian...@lists.debian.org
Hi,
With my crowdsec maintainer hat on: while preparing the final crowdsec
upload(s) for bookworm, I've spotted that the crowdsec package from
bullseye doesn't start on a bookworm system:
time="16-03-2023 00:19:45" level=fatal msg="api server init: unable to run
local API: unable to init database client: failed creating schema resources:
sql/schema: invalid type \"INTEGER\" for column \"events_count\""
While crowdsec is a Go package, relying on the Ent package to deal with
SQLite, the latter leverages golang-github-mattn-go-sqlite3-dev, which
ends up building against the system SQLite library.
That's how crowdsec 1.0.9-2(+b4) in bullseye ends up depending on
libsqlite3-0 (>= 3.7.15).
The service starts fine with all libsqlite3-0 versions between 3.34.1-3
and 3.36.0-2, and no longer starts with 3.37.0-1 and later. While I was
contemplating the documented changes for 3.37.0 (and finding nothing
relevant), my very kind upstream found this Ent issue:
https://github.com/ent/ent/issues/2209
In short, Ent's expectations are no longer fulfilled, and crowdsec no
longer starts with newer versions.
To support partial upgrades from bullseye to bookworm, it would be best
if libsqlite3-0 would break old crowdsec versions, so that we don't run
into this issue (either because admins are performing partial upgrades
on purpose, or because apt broke down the upgrade into smaller chunks
with a combination of crowdsec/libsqlite3-0 packages that cannot work).
Patch attached, thanks for considering!
Cheers,
--
Cyril Brulebois -- Debian Consultant @ DEBAMAX -- https://debamax.com/
diff -Nru sqlite3-3.40.1/debian/changelog sqlite3-3.40.1/debian/changelog
--- sqlite3-3.40.1/debian/changelog 2022-12-31 09:41:40.000000000 +0100
+++ sqlite3-3.40.1/debian/changelog 2023-03-16 00:51:04.000000000 +0100
@@ -1,3 +1,10 @@
+sqlite3 (3.40.1-2) UNRELEASED; urgency=medium
+
+ * Add Breaks against crowdsec as found in bullseye, as it relies on a
+ particular table_info format, which changes between 3.36.0 and 3.37.0.
+
+ -- Cyril Brulebois <cy...@debamax.com> Wed, 15 Mar 2023 23:51:04 +0000
+
sqlite3 (3.40.1-1) unstable; urgency=medium
* New upstream release.
diff -Nru sqlite3-3.40.1/debian/control sqlite3-3.40.1/debian/control
--- sqlite3-3.40.1/debian/control 2022-12-31 09:41:40.000000000 +0100
+++ sqlite3-3.40.1/debian/control 2023-03-16 00:50:52.000000000 +0100
@@ -52,7 +52,7 @@
Section: libs
Architecture: any
Depends: ${shlibs:Depends}, ${misc:Depends}
-Breaks: python-migrate (<< 0.11.0-4~), python3-migrate (<< 0.11.0-4~)
+Breaks: python-migrate (<< 0.11.0-4~), python3-migrate (<< 0.11.0-4~),
crowdsec (<< 1.4)
Multi-Arch: same
Pre-Depends: ${misc:Pre-Depends}
Description: SQLite 3 shared library
