`tracker` is broken after `sqlite` update to`3.45.3`
Description:
tracker3 doesn't add any files to index, this log message is repeated for any attempt to index a file:
tracker-miner-f[54358]: Could not execute sparql: ambiguous column name: ROWID
Additional info:
- package version(s):
- tracker3 3.7.1-2
- sqlite 3.45.3-1
- config and/or log files: N/A
- link to upstream bug report, if any:
Steps to reproduce:
run
systemctl mask --user --now tracker-miner-fs-3.service
tracker3 reset --filesystem
systemctl unmask --user --now tracker-miner-fs-3.service
and wait for it to index the files. After some minutes make a check and it will show that no files are indexed:
% tracker3 status | head -n 1
Currently indexed: 0 files, 0 folders
Fix available:
Upstream fix: https://gitlab.gnome.org/GNOME/tracker/-/merge_requests/665
Backporting the patch fixes the issue: files are being indexed again, the error message above disappears.
Edited by Stanislav T