Public bug reported: NOTE: This bug/issue found by AI when I was taking its help to fix a slow load of Home issue.
Ubuntu 24.04 LTS (upgraded from 22.04), GNOME Files (nautilus) 46.4. tracker-miner-fs-3 repeatedly fails with the following error in the user journal, and appears to index nothing: tracker-miner-f[PID]: Could not execute sparql: ambiguous column name: ROWID tracker-miner-fs-3[PID]: (tracker-extract-3:PID): GLib-GIO-WARNING **: Error creating IO channel for /proc/self/mountinfo: Invalid argument (g-io-error-quark, 13) The ROWID error recurs every 10-60 seconds while the miner is running. A new tracker-extract-3 process is started each time. Package versions: tracker-miner-fs 3.7.1-1ubuntu0.1 tracker 3.7.1-1build1 libtracker-sparql-3.0-0 3.7.1-1build1 libsqlite3-0 3.45.1-1ubuntu2.9 (apt shows no newer versions of any of these.) What I tried: tracker3 reset --filesystem systemctl --user stop tracker-miner-fs-3; rm -rf ~/.cache/tracker3/files; systemctl --user start tracker-miner-fs-3 The error still returns on the rebuilt index, so it is not caused by an old or damaged database. This looks like the known incompatibility between Tracker 3.7.1 and newer SQLite behaviour, where a bare "ROWID" reference in Tracker's view is treated as ambiguous. Similar reports: https://gitlab.archlinux.org/archlinux/packaging/packages/tracker3/-/issues/2 Debian packaging fix: https://salsa.debian.org/gnome-team/tracker/compare/ab11042...2e54209 Request: please backport the upstream Tracker fix for the ambiguous ROWID reference to the 24.04 package (tracker 3.7.x), or confirm whether it is already planned. Impact: file indexing and indexed search in Files/GNOME do not work. ProblemType: Bug DistroRelease: Ubuntu 24.04 Package: tracker-miner-fs 3.7.1-1ubuntu0.1 ProcVersionSignature: Ubuntu 7.0.0-42.42~24.04.1-generic 7.0.14 Uname: Linux 7.0.0-42-generic x86_64 ApportVersion: 2.28.3-0ubuntu0.1 Architecture: amd64 CasperMD5CheckResult: unknown CurrentDesktop: ubuntu:GNOME Date: Mon Nov 9 17:21:52 2026 InstallationDate: Installed on 2023-05-27 (1262 days ago) InstallationMedia: Ubuntu 20.04.3 LTS "Focal Fossa" - Release amd64 (20210819) SourcePackage: tracker-miners UpgradeStatus: Upgraded to noble on 2026-09-25 (45 days ago) ** Affects: tracker-miners (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-miners in Ubuntu. https://bugs.launchpad.net/bugs/2173746 Title: tracker-miner-fs-3 3.7.1 fails to index any file: "Could not execute sparql: ambiguous column name: ROWID" To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/tracker-miners/+bug/2173746/+subscriptions -- desktop-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/desktop-bugs
