Public bug reported:
**Summary**
Tracker 3.7.1 on Ubuntu 24.04 produces thousands of errors with the
message `ambiguous column name: ROWID`. The `tracker-extract-3` process
also causes sustained CPU usage, even when indexing is reported as
complete.
**Steps to reproduce / Observed behavior**
1. Tracker reports that indexing is complete but lists 29,494 extraction
failures.
2. Many failures initially involve WAV files, but the error `ambiguous column
name: ROWID` also occurs for unrelated files and directories.
3. The `tracker-extract-3` process continues consuming approximately 30% CPU
for an extended period.
4. Killing the process does not resolve the issue, as it is automatically
restarted.
5. Resetting the Tracker database with `tracker3 reset -s` and excluding a
large sample directory from indexing does not resolve the underlying problem.
6. After reindexing, Tracker reports 7,901 failures, including `ambiguous
column name: ROWID` for `/home/fox`.
**Installed versions**
- Ubuntu 24.04
- tracker-extract: 3.7.1-1ubuntu0.1
- tracker-miner-fs: 3.7.1-1ubuntu0.1
- libtracker-sparql-3.0-0: 3.7.1-1build1
- libsqlite3-0: 3.45.1-1ubuntu2.9
**Expected behavior**
Tracker should index files without SQL errors and terminate or become
idle after indexing has completed.
**Possible cause**
This may be related to a known incompatibility involving SQLite's
handling of `ROWID` and older Tracker SPARQL versions. A corresponding
fix was introduced in Tracker SPARQL 3.7.3, while Ubuntu 24.04 currently
uses version 3.7.1.
It is not yet confirmed whether the same incompatibility is responsible
for this issue.
**Workaround**
Disabling the filesystem miner with:
`systemctl --user mask --now tracker-miner-fs-3.service`
stops the excessive CPU activity, but also disables automatic file
indexing.
A fix or backport for Ubuntu 24.04 would be appreciated.
ProblemType: Bug
DistroRelease: Ubuntu 24.04
Package: tracker 3.7.1-1build1
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: pass
CurrentDesktop: ubuntu:GNOME
Date: Sat Nov 7 21:39:30 2026
InstallationDate: Installed on 2024-09-17 (781 days ago)
InstallationMedia: Ubuntu 24.04.1 LTS "Noble Numbat" - Release amd64
(20240827.1)
ProcEnviron:
LANG=de_DE.UTF-8
PATH=(custom, no user)
SHELL=/bin/bash
TERM=xterm-kitty
XDG_RUNTIME_DIR=<set>
SourcePackage: tracker
UpgradeStatus: No upgrade log present (probably fresh install)
modified.conffile..etc.default.apport:
# set this to 0 to disable apport, or to 1 to enable it
# you can temporarily override this with
# sudo service apport start force_start=1
enabled=0
mtime.conffile..etc.default.apport: 2025-03-01T18:47:40.472887
** Affects: tracker (Ubuntu)
Importance: Undecided
Status: New
** Tags: amd64 apport-bug noble third-party-packages wayland-session
--
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/2173648
Title:
Tracker 3.7.1 on Ubuntu 24.04 produces thousands of errors with the
message ambiguous column name
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/tracker/+bug/2173648/+subscriptions
--
desktop-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/desktop-bugs
