Your message dated Thu, 16 Mar 2023 19:36:02 +0000
with message-id <[email protected]>
and subject line Bug#1033029: fixed in sqlite3 3.40.1-2
has caused the Debian Bug report #1033029,
regarding libsqlite3-0: please declare a Breaks against old crowdsec versions
to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)
--
1033029: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1033029
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
Package: libsqlite3-0
Version: 3.34.1-3
Severity: important
Tags: patch
X-Debbugs-Cc: [email protected]
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 <[email protected]> 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
--- End Message ---
--- Begin Message ---
Source: sqlite3
Source-Version: 3.40.1-2
Done: Laszlo Boszormenyi (GCS) <[email protected]>
We believe that the bug you reported is fixed in the latest version of
sqlite3, which is due to be installed in the Debian FTP archive.
A summary of the changes between this version and the previous one is
attached.
Thank you for reporting the bug, which will now be closed. If you
have further comments please address them to [email protected],
and the maintainer will reopen the bug report if appropriate.
Debian distribution maintenance software
pp.
Laszlo Boszormenyi (GCS) <[email protected]> (supplier of updated sqlite3 package)
(This message was generated automatically at their request; if you
believe that there is a problem with it please contact the archive
administrators by mailing [email protected])
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512
Format: 1.8
Date: Thu, 16 Mar 2023 19:54:28 +0100
Source: sqlite3
Architecture: source
Version: 3.40.1-2
Distribution: unstable
Urgency: medium
Maintainer: Laszlo Boszormenyi (GCS) <[email protected]>
Changed-By: Laszlo Boszormenyi (GCS) <[email protected]>
Closes: 1033029
Changes:
sqlite3 (3.40.1-2) unstable; urgency=medium
.
[ Cyril Brulebois <[email protected]> ]
* 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
(closes: #1033029).
Checksums-Sha1:
b424ddf274bf39546882e5f9ed82863af986521f 2487 sqlite3_3.40.1-2.dsc
f7d2d31ca37cb65699fac8cf7a132ed2378a709d 29944 sqlite3_3.40.1-2.debian.tar.xz
Checksums-Sha256:
0b22fb1ddca1da2fd0db3f41841da5e17e4c36f160c2fc310737436ec638c2e2 2487
sqlite3_3.40.1-2.dsc
98939c2e98748fe13d1d2243ebde68bfe3f071000455ae1815d802e44bc2d039 29944
sqlite3_3.40.1-2.debian.tar.xz
Files:
3dec16fd385d6a050600eaa38e85230e 2487 devel optional sqlite3_3.40.1-2.dsc
1d7fea2ec25134ae416c1bd3ee813a90 29944 devel optional
sqlite3_3.40.1-2.debian.tar.xz
-----BEGIN PGP SIGNATURE-----
iQIyBAEBCgAdFiEEfYh9yLp7u6e4NeO63OMQ54ZMyL8FAmQTa1YACgkQ3OMQ54ZM
yL/dhg/41Ilv+8Vo7ZCMnKFRA2eLsygdxOgIGGmAgaq40XnyCF0ihQToyhNPyyYA
BQXZ02qy90nJdm215nHMEIaZQ9AKF9Xn5wHe9cYqZU+FZbE4l1DWoZao+ypDXkEL
D+sPpxlvOxuBtv37mkwW+owDbXU8tI6J4/rFsR+UlEQ4wRq4XbB3kvYI5oRIRnay
WliU+zsZzIXaFOScVRZ3gOYDXwcxuYyS/dBJqIdH9tMKEEeRT/NcMNTtCSrNBTwg
TEDKCglgRJavyCwn0xlur1nFekOhwsFz5ZLVElUe4O8sUXB0Unr5zcMxNGRfo1QL
q22t6nH4wfpBxzR8OwtyMijMe/J6Yi10en+iqGP89VNW88j8ei30Js78bktP0Ltd
2+QfFCUyBpD6uPLchsYwzfD7yWXmWwJJkGmcJQhY5r4KA4ARs3oIe2t8olliSPZf
0Q7sCC7UG8LyrtvyBCWIRIxwHDPlYZ7xQyZL8MQiQVdpq0zS4G/ZqQ2K/I4z1XjA
1/WoaS36DmVW88nA9PGQWN7xDPjNEmhXKSua+Xhc2mcypmS8ob/JGLRvDa7onMO5
25K6mjTdt56YIYUN+AgEGwIO2TmBYT4tZwmwV5HVEYqf7jkZfkyq1eh7ue3zI+yY
n9QJinbsnM9FG3ZkKtxUG9rNfmDH5H4Mz4Ag0Xy3frrwsUqhEQ==
=DlX8
-----END PGP SIGNATURE-----
--- End Message ---
