Bug#1110744: localsearch-3.service fails after upgrade to trixie

[Алексей Шилин]

Package: tracker-extract
Version: 3.8.2-4+b1
Severity: important
Justification: supposedly affects all GNOME users upgrading to trixie

Hi,

After upgrading to trixie new localsearch-3.service fails with:

авг 10 00:14:42 lenovo localsearch-3[2852]: Could not create store:
ambiguous column name: ROWID
авг 10 00:14:42 lenovo systemd[2134]: localsearch-3.service: Main
process exited, code=exited, status=1/FAILURE
авг 10 00:14:42 lenovo systemd[2134]: localsearch-3.service: Failed
with result 'exit-code'.
авг 10 00:14:42 lenovo systemd[2134]: Failed to start localsearch-
3.service - Tracker file system data miner.

I was able to reproduce this with a clean VM install of bookworm,
logging in once (so that it does initial indexing) and then upgrading
to trixie.

It seems like the issue is that new service version is incompatible
with database created by the old version, and the only way to fix this
is to purge the database by running `localsearch reset -s`, then it
starts and operates as expected.