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

Reply via email to