Public bug reported:
Release: Ubuntu 24.04 LTS (noble), amd64
Packages:
libtracker-sparql-3.0-0 3.7.1-1build1
tracker-miner-fs 3.7.1-1ubuntu0.1
libsqlite3-0 3.45.1-1ubuntu2.9 (from noble-updates)
No other SQLite library on the system (ldconfig shows only
/lib/x86_64-linux-gnu/libsqlite3.so.0).
Problem:
tracker-miner-fs indexes nothing. After a full reset
(tracker3 reset -s -r) and a complete indexing run, tracker3 status reports:
Currently indexed: 0 files, 0 folders
All data miners are idle, indexing complete
2965 recorded failures
Every failure has the same message, e.g.:
Message: ambiguous column name: ROWID
SPARQL: DELETE WHERE {
GRAPH <http://tracker.api.gnome.org/ontology/v3/tracker#Documents> {
<file:///home/<user>/<file>> nie:dataSource ?nie_dataSource } };
Analysis:
This is the incompatibility that upstream SQLite 3.45.3 introduced
(SQLITE_ALLOW_ROWID_IN_VIEW behaviour change), fixed in tracker by
https://gitlab.gnome.org/GNOME/tracker/-/merge_requests/665
(and the database version bump in MR !668), released in tracker 3.7.3.
It appears that the change was backported into one of the recent
noble libsqlite3 security/updates builds:
2026-09-17 3.45.1-1ubuntu2.7 -> 3.45.1-1ubuntu2.8
2026-11-05 3.45.1-1ubuntu2.8 -> 3.45.1-1ubuntu2.9
while tracker in noble is still 3.7.1 without the fix.
Suggested fix:
Backport tracker MR !665 (+ !668) to noble's tracker 3.7.1, or update
to tracker 3.7.3.
Workaround:
Disable file indexing (Settings > Search > Files off).
ProblemType: Bug
DistroRelease: Ubuntu 24.04
Package: libtracker-sparql-3.0-0 3.7.1-1build1
ProcVersionSignature: Ubuntu 6.8.0-146.146-generic 6.8.12
Uname: Linux 6.8.0-146-generic x86_64
NonfreeKernelModules: socwatch2_16 vtsspp sep5 pax
ApportVersion: 2.28.3-0ubuntu0.1
Architecture: amd64
CasperMD5CheckResult: unknown
CurrentDesktop: ubuntu:GNOME
Date: Wed Nov 18 01:55:04 2026
InstallationDate: Installed on 2019-09-03 (2632 days ago)
InstallationMedia: Ubuntu 18.04.3 LTS "Bionic Beaver" - Release amd64 (20190805)
SourcePackage: tracker
UpgradeStatus: No upgrade log present (probably fresh install)
** Affects: tracker (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug noble
--
You received this bug notification because you are a member of Ubuntu
Desktop Bugs, which is subscribed to tracker in Ubuntu.
https://bugs.launchpad.net/bugs/2174789
Title:
tracker 3.7.1: "ambiguous column name: ROWID" with libsqlite3-0
3.45.1-1ubuntu2.9 – file indexing completely broken
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/tracker/+bug/2174789/+subscriptions
--
desktop-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/desktop-bugs