Public bug reported:
DESCRIPTION:
After libsqlite3-0 was updated from 3.45.1-1ubuntu2.8 to 3.45.1-1ubuntu2.9,
tracker-miner-fs-3 fails every database write with:
Tracker-WARNING: Failed to update ignored file
'file:///home/<user>/<name>.tmp.<pi
Tracker-WARNING: Could not get mimetype ... No such file or directory
Each short-lived temp file in the home directory (atomic-write temp files,
LaTeX build files, editor swap files) triggers the error, and the miner
keeps retrying. /var/log/syslog grew to 34 GB and filled the root
filesystem (a rotated copy from two days earlier was 125 MB). Only
masking tracker-miner-fs-3 stopped it.
CAUSE (from changelogs, not bisected):
sqlite3 3.45.1-1ubuntu2.9 changelog:
"Fix a segfault in sqlite3MatchEName() ... caused by the
SQLITE_ALLOW_ROWID_IN_VIEW build option (LP: #2087772)
- lp2087772-rowid-in-view-nested-join.patch: backport upstream
check-in 7a3d0027f8 from 3.45.3 ..."
Upstream SQLite 3.45.3 changed implicit ROWID handling in views, which
broke tracker's unqualified ROWID references. Upstream tracker fixed this in
https://gitlab.gnome.org/GNOME/tracker/-/merge_requests/665
(see also Arch:
https://gitlab.archlinux.org/archlinux/packaging/packages/tracker3/-/issues/2).
Noble's tracker 3.7.1-1build1 (March 2024) predates that fix and has no
newer version in noble/updates.
EXPECTED: tracker keeps working after the sqlite3 security/bugfix update.
ACTUAL: every index update fails and is logged in a tight retry loop.
REPRODUCE (not independently reproduced on a clean system):
1. Ubuntu 24.04 with tracker-miner-fs 3.7.1-1ubuntu0.1, libsqlite3-0
3.45.1-1ubuntu2.9
2. Log in with tracker-miner-fs-3 enabled (default with nautilus)
3. Create and delete temp files in $HOME; watch `journalctl -f` /
/var/log/syslog
PROPOSED FIX: backport GNOME tracker MR 665 into noble's tracker source
package (libtracker-sparql). (Debian may already carry an equivalent
patch; I have not verified this.)
IMPACT: availability only. Unbounded log growth can fill /. This is a
local self-inflicted log flood, not a remote or privilege issue, so I would
file it as a normal public bug rather than a security one.
ENV: Ubuntu 24.04 (noble), kernel 7.0.0-42-generic, apt versions above.
** Affects: tracker (Ubuntu)
Importance: Undecided
Status: New
--
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/2173879
Title:
tracker-miner-fs-3 floods syslog with "ambiguous column name: ROWID"
after sqlite3 3.45.1-1ubuntu2.9 (noble).
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/tracker/+bug/2173879/+subscriptions
--
desktop-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/desktop-bugs
