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