SQLite changed runtime behaviour on a minor release, filling my system logs with stuff like this: May 01 08:20:02 saga.alfsgard.dk tracker-extract[334226]: Task for 'file://<redacted>' finished with error: Error when getting information for file “<redacted>“ May 01 08:20:02 saga.alfsgard.dk tracker-extract[334226]: Failed to update ignored file '<redacted>': ambiguous column name: ROWID And running one core continously at ~50% See tracker upstream bug report in URL. arch bug report at https://gitlab.archlinux.org/archlinux/packaging/packages/tracker3/-/issues/2 Reproducible: Always
Upstream fix available at: https://gitlab.gnome.org/GNOME/tracker/-/merge_requests/665
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=785116472a3975dff6bc6d9337099bf58f698759 commit 785116472a3975dff6bc6d9337099bf58f698759 Author: Mart Raudsepp <leio@gentoo.org> AuthorDate: 2024-05-03 20:25:33 +0000 Commit: Mart Raudsepp <leio@gentoo.org> CommitDate: 2024-05-03 20:34:40 +0000 app-misc/tracker: fix regression from sqlite-3.45.3 behaviour change Straight to stable because sqlite-3.45.3 was already stabilized early and thus tracker was broken on stable. Closes: https://bugs.gentoo.org/931015 Signed-off-by: Mart Raudsepp <leio@gentoo.org> .../tracker/files/3.6.0-sqlite-3.45.3-compat.patch | 44 ++++++++++++++++++++++ ...racker-3.6.0.ebuild => tracker-3.6.0-r1.ebuild} | 1 + 2 files changed, 45 insertions(+)
After pushing I peeked at tracker-3.6 branch, and there's unreleased fixes on that branch for further sqlite problems, albeit these don't seem as serious as sqlite-3.44 already triggered the issues those fix. https://gitlab.gnome.org/GNOME/tracker/-/issues/418 Please open a new bug if they are serious though, otherwise too annoyed to deal with it and hopefully can concentrate on getting tracker-3.7 in that much sooner instead.
