Your message dated Tue, 16 Mar 2021 21:49:15 +0000 with message-id <[email protected]> and subject line Bug#985124: fixed in fossil 1:2.15~rc1-1 has caused the Debian Bug report #985124, regarding fossil: fails to update schema for older repositories 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.) -- 985124: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=985124 Debian Bug Tracking System Contact [email protected] with problems
--- Begin Message ---Package: fossil Version: 1:2.14-1 Severity: grave Tags: upstream fixed-upstream Dear Maintainer, After updating the fossil package to 1:2.14-1, I've found that it fails to open repositories created a while ago. It emits the following error message: SQLITE_ERROR(1): table sqlite_master may not be modified in "UPDATE repository.sqlite_schema SET sql='CREATE TABLE blob( rid INTEGER PRIMARY KEY, rcvid INTEGER, size INTEGER, uuid TEXT UNIQUE NOT NULL, content BLOB, Database error: table sqlite_master may not be modified: {UPDATE repository.sqlite_schema SET sql='CREATE TABLE blob( rid INTEGER PRIMARY KEY, rcvid INTEGER, size INTEGER, uuid TEXT UNIQUE NOT NULL, content BLOB, CHECK( length(uuid)>=40 AND rid>0 ) )' WHERE name LIKE 'blob';PRAGMA writable_schema=OFF;} The message indicates that the repository Sqlite DB is in defencive mode, and its schema can't be modified using UPDATE. As far as I can see, this bug is fixed upstream in the following commit: https://www2.fossil-scm.org/fossil/info/d4041437b6f40d0cc62f22d2973498d596af325b1d18fed2dd7584aef733df7a which is a part of the 2.15 release. Please, apply the fix to the fossil package in Debian, as it is now, fossil is not very usable. I'm sure, the bug is serious enough to grant a freeze exception. To reproduce the bug, just create an empty repository using fossil binary from stretch (1:1.37-1), and try to connect to it using fossil 1:2.14-1: fossil-1.37 new test.fossil fossil-2.14 info -R test.fossil Cheers! -- System Information: Debian Release: bullseye/sid APT prefers testing APT policy: (500, 'testing'), (500, 'stable'), (1, 'unstable') Architecture: amd64 (x86_64) Foreign Architectures: i386 Kernel: Linux 5.10.0-4-amd64 (SMP w/4 CPU threads) Kernel taint flags: TAINT_FIRMWARE_WORKAROUND Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en Shell: /bin/sh linked to /bin/dash Init: systemd (via /run/systemd/system) Versions of packages fossil depends on: ii libc6 2.31-9 ii libfuse2 2.9.9-5 ii libsqlite3-0 3.34.1-3 ii libssl1.1 1.1.1j-1 ii libtcl8.6 [libtcl] 8.6.11+dfsg-1 ii zlib1g 1:1.2.11.dfsg-2 fossil recommends no packages. Versions of packages fossil suggests: ii gnupg 2.2.27-1 -- no debconf information -- Sergei Golovan
--- End Message ---
--- Begin Message ---Source: fossil Source-Version: 1:2.15~rc1-1 Done: Barak A. Pearlmutter <[email protected]> We believe that the bug you reported is fixed in the latest version of fossil, 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. Barak A. Pearlmutter <[email protected]> (supplier of updated fossil 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: Tue, 16 Mar 2021 21:13:47 +0000 Source: fossil Architecture: source Version: 1:2.15~rc1-1 Distribution: unstable Urgency: medium Maintainer: Barak A. Pearlmutter <[email protected]> Changed-By: Barak A. Pearlmutter <[email protected]> Closes: 961772 985124 Changes: fossil (1:2.15~rc1-1) unstable; urgency=medium . * New upstream version - fixes problem updating schemas on older repositories (closes: #985124) - does not run host tool on cross build (closes: #961772) * Use new ./configure --print-minimum-sqlite-version option Checksums-Sha1: df77d7342ed2f5d28ec466e685e213a7e743da46 1887 fossil_2.15~rc1-1.dsc 0133c82f3d378cec9ca231bb99dcaaa486a52513 4336684 fossil_2.15~rc1.orig.tar.xz 9f214e25ee861dd320405e2e3b49f5455606afa9 45460 fossil_2.15~rc1-1.debian.tar.xz 857299f03d83f0282d454c41e58e724e9e630ca8 6982 fossil_2.15~rc1-1_source.buildinfo Checksums-Sha256: f59f31e1b044925fc4f2f6902d50a38b38ebe869e0b07fba2eed92b09695ce53 1887 fossil_2.15~rc1-1.dsc e1992421d6e19ba6ebb7c0f2278ffc7fc7e30fdad7a3557806045fa123c60fa0 4336684 fossil_2.15~rc1.orig.tar.xz 0fa8bc1f5f8d7f19ccf9900b938b4815c85a5a3ee80224c49ce1419ea04b3986 45460 fossil_2.15~rc1-1.debian.tar.xz 112cf115fea70327fd93b9524074e708051543b0e942ea3b54696a6775eba247 6982 fossil_2.15~rc1-1_source.buildinfo Files: b3d11d1b854deef90f3b3815038a0a57 1887 vcs optional fossil_2.15~rc1-1.dsc 8e0bc5a29afebff59ce14b6c35447cd0 4336684 vcs optional fossil_2.15~rc1.orig.tar.xz e28634e1d2404ba16ead8b8ed82d1f83 45460 vcs optional fossil_2.15~rc1-1.debian.tar.xz 40ec3ccd982984c129b6b7bc06de781f 6982 vcs optional fossil_2.15~rc1-1_source.buildinfo -----BEGIN PGP SIGNATURE----- iQJDBAEBCgAtFiEE+nZaz+JE7Dn2AefCmesepNIze4gFAmBRIVYPHGJhcEBkZWJp YW4ub3JnAAoJEJnrHqTSM3uI54gP/3CZOjgarm5QRuntnvTnxCTn9nQNO0uCN3N5 EzdZb0VLMItWp/ljAa5mdXomstvic+WJfMUXANtoY20DTHMphcFjjHSNRupHCGz9 iGZ5H3oCZkZqcceRPqQ0kv46CXHmMQbJxYjvgsFESKAWdEELNVSUcd/gyiRdjq7Q LFI7lvPCYE+IhNdaBpJSoUTj2jQC9b5u2WikVhnrBvVvYzIEa6ur9jXGYFMuHx1m 8r2ogvAw77bDN1O5YOTO8rxIky07T9hu6H6HFw/h8U83lJaUwaxX+3S9AvJYyPTv twpvM/p0cxdglNjo92LelpCvVkBXFsrSNLk86NvVWEougN6i/DaDDgru+7K5AOcu gnM+0MgtSMi1Z+zuoUxaQv0LfS/6EmWmK5jxnP9MWL2Ob9CAduTc517XPfvfFb4p gPx9saMKdcwxdtPSwtY08pffiPOyVElpELadfLGJDvp9D49KiECdiMytAKl4aNAT KpOW0D0EFyir8KSr6281SjVmQdw1E7fdmKA3THPw2+fAJufyx4AHdSPw2Dxc9YIU UwXG8dbYf8wtqIisi8v3WfVI4+7+bqfTi3lRsf2uHcp2LY2V8P3yYBdb3Rg+Z+Qk KNSH+lOhr+S0N2Nmjb5MJPaei5wyE6g2TSIkXHBNZpzZ/gn7nSwuNoHM3nzX6pcQ vX3bqfe8 =Weg6 -----END PGP SIGNATURE-----
--- End Message ---
