Public bug reported:
After upgrading libsqlite3-0 from 3.45.1-1ubuntu2.8 to 3.45.1-1ubuntu2.9
(the SRU for LP: #2087772), the GNOME file indexer in Ubuntu 24.04 can
no longer write to its database. Every update fails with "ambiguous
column name: ROWID", tracker-miner-fs-3 retries forever using close to
one full CPU core, and the user journal fills with tracker-extract
warnings (about 30,000 lines every five minutes here, enough to push all
older entries out of a 4 GB journal in two or three days). The search
index stops updating.
Package versions: libsqlite3-0 3.45.1-1ubuntu2.9, tracker / libtracker-
sparql-3.0-0 3.7.1-1build1, tracker-miner-fs and tracker-extract
3.7.1-1ubuntu0.1. Ubuntu 24.04.5 LTS, GNOME on Wayland.
Cause: the 2.9 changelog says it backports upstream check-in 7a3d0027f8
from SQLite 3.45.3. Tracker 3.7.1 creates a view fts_view in each of its
databases that aliases "rdfs:Resource".ID as rowid and ends in GROUP BY
ROWID. With the 3.45.3 semantics that reference is ambiguous. Upstream
tracker fixed exactly this in 2024: 3.7.2 ("Fix runtime issue introduced
by SQLite 3.45.3",
https://gitlab.gnome.org/GNOME/tracker/-/merge_requests/665, a one-line
change to GROUP BY "rdfs:Resource".ID) and 3.7.3 ("Bump database version
to fix SQLite 3.45.3 issues in existing databases"). Noble ships tracker
3.7.1 without those changes, which was harmless until this SRU.
The first "ambiguous column name: ROWID" report in
~/.cache/tracker3/files/errors/ appeared five minutes after the
libsqlite3-0 upgrade; there were none in the previous twenty months.
Minimal reproducer (no tracker needed). Save as repro.sql:
CREATE TABLE "rdfs:Resource" (ID INTEGER PRIMARY KEY);
CREATE TABLE "nie:InformationElement" (ID INTEGER PRIMARY KEY, "nie:title"
TEXT);
INSERT INTO "rdfs:Resource" VALUES (1);
INSERT INTO "nie:InformationElement" VALUES (1, 'hello');
CREATE VIEW fts_view AS SELECT "rdfs:Resource".ID as rowid,
"nie:InformationElement"."nie:title" AS "nie:title" FROM "rdfs:Resource" LEFT
OUTER JOIN "nie:InformationElement" ON "rdfs:Resource".ID =
"nie:InformationElement".ID WHERE COALESCE("nie:title", NULL) IS NOT NULL GROUP
BY ROWID;
SELECT * FROM fts_view;
Then run: sqlite3 :memory: < repro.sql
With libsqlite3-0 3.45.1-1ubuntu2.8 the output is "1|hello". With
3.45.1-1ubuntu2.9 it is "Parse error near line 6: ambiguous column name:
ROWID". With GROUP BY "rdfs:Resource".ID instead of GROUP BY ROWID it
works on both.
Expected: existing noble packages keep working after the sqlite3 SRU.
Possible fixes: backport the tracker 3.7.2 and 3.7.3 changes to tracker
in noble (3.7.3 is needed so that existing user databases get their
views recreated), or adjust the sqlite3 backport so that this query
keeps its previous behaviour.
Workaround that worked here: stop tracker-miner-fs-3, back up
~/.cache/tracker3/files, and in each of the seven databases (meta.db and
one per graph) replace the stored fts_view with the same definition
ending in GROUP BY "rdfs:Resource".ID. After restarting, CPU use dropped
from about 97% of a core to 0%, no new errors were logged, and new and
deleted files were picked up again by tracker3 search. Masking the
service (systemctl --user mask tracker-miner-fs-3.service) also stops
the loop, at the cost of disabling file search.
ProblemType: Bug
DistroRelease: Ubuntu 24.04
Package: sqlite3 3.45.1-1ubuntu2.9
ProcVersionSignature: Ubuntu 7.0.0-43.43~24.04.1-generic 7.0.14
Uname: Linux 7.0.0-43-generic x86_64
NonfreeKernelModules: nvidia_modeset nvidia
ApportVersion: 2.28.3-0ubuntu0.1
Architecture: amd64
CasperMD5CheckResult: pass
CurrentDesktop: ubuntu:GNOME
Date: Thu Nov 19 00:12:16 2026
InstallationDate: Installed on 2025-02-09 (647 days ago)
InstallationMedia: Ubuntu 24.04.1 LTS "Noble Numbat" - Release amd64
(20240827.1)
SourcePackage: sqlite3
UpgradeStatus: No upgrade log present (probably fresh install)
** Affects: sqlite3 (Ubuntu)
Importance: Undecided
Status: New
** Affects: tracker (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug noble regression-update wayland-session
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/2174958
Title:
sqlite3 3.45.1-1ubuntu2.9 breaks tracker 3.7.1 in noble: "ambiguous
column name: ROWID", file indexer loops at full CPU
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/sqlite3/+bug/2174958/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs