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.

I noticed it because gnome-music was unusable with an error message that it could not connect to Tracker. Running `localsearch reset -s` fixed it and got gnome-music working again too.

Hello,
I also have the same issue on the familys computers running GNOME that I
upgraded from bookworm to trixie.

I intentionally waited so long (until Point-Release .3) in hope that
such  bugs who affect "just-users" were fixed or mentioned in the
documents (releasenotes, known bugs ..)

I noticed it because my family complains that natilus-search didn't find
all what was expected.

Lokking into the issue i found the above-mentioned message "Failed to
start localsearch-3.service - Tracker file system data miner" and so i
found this bug report and then i looked for the "Could not create store:
ambiguous column name: ROWID" log-entry, which was also present.

Running `localsearch reset -s` fixed it and got the natilus-search
results to please may family again :-)
but i had to argue against the strong "use-other-os" parties in my family.

I suggest to change this bug to serious because it crashes an essential
function for "just-users" or to mention it in the release-notes and to
thank aleksej to describe the solution and marley for confirming it.

sincerely
Steve

Hello,
please find attached the above problem description in english by
google-translate with a comment to the added screenshots 1,2 and 3.


Dear Maintainer,

*** Reporter, please consider answering these questions, where
appropriate ***

    * What led up to the situation?

Since Debian Buster, I've been using Synaptic with the quick search and
the apian index.

This no longer works under Trixie, and even after point release .3, the
status is still unclear.

Therefore, I also installed packagesearch after the upgrade form
bookworm to trixie to be able to quickly search for installed packages
without having to scroll in a long list every time, as is the case with
the current trixie-Synaptic.

Unfortunately, I've noticed that in packagesearch, for reasons unknown
to me, the indicator under "i" and the information about the installed
version are not consistent with the information from apt or Synaptic.
Packages that are installed are not highlighted.

* What exactly did you do (or not do) that was effective (or ineffective)?

Start Packagesearch normally and enter the package name under "Nach
Zeichenkette suchen" ("Search by string").

* What was the outcome of this action?

In this specific case, after upgrading to Trixie, I searched for the
packages that the autoremove suggested for removal, in this case using
the term "libpoppler-cpp".

This yielded three results (see screenshots). Two packages were not
marked as installed, and one was. However, only one of the three was
actually not installed!

* What outcome did you expect instead?

I would have expected the status to be displayed correctly. Currently,
the installation status can only be determined by the information about
the installed files in the "Files" tab on the right side of the search
results. While this doesn't make Packagesearch completely useless, it's
not as desired.

***Additional comment to screenshots (not in the german description above)

in all screenshots synaptic is visible in background, window of
packagesearch in foreground.

screenshot1 shows "libpoppler-cpp0v5" marked as installed in synaptic
(which is correct) and not marked in packagesearch under "installed
version". it also shows "libpoppler-dev" as not installed both in
synaptic and packagesearch (which is correct).

screenshot2 shows "libpoppler-cpp0v5" as not marked as installed in
packagesearch while there is a listing of installed files (*without*
loading them separately via click on the button "Anzeigen" in the tab
"Daten").

screenshot3 shows the expected message of the real not installed package
"libpoppler-dev" in the tab "Daten".

i can't give additional infos of the package-state in this particular
case because in the meantime i had to finish the
bookworm-to-trixie-update of that machine and to "autoremove --purge"
the packages which where suggested to be autoremoved.

sincerely
Steve

i used wrong bug number for additional info - pls remove my answer from
Thu, 15 Jan 2026 11:02:53 +0100 from this bug 1110744

thanks and sorry for the mess
Steve