Bug 1222949

Looks like a tracker and SQLite version problem:

https://gitlab.archlinux.org/archlinux/packaging/packages/tracker3/-/issues/1
https://gitlab.gnome.org/GNOME/tracker/-/issues/418

I'll backport the fix.

I manually re-write the patch because tracker changed it's code structure between 3.2 and 3.6, please try package from <https://download.opensuse.org/repositories/home:/AZhou:/branches:/GNOME:/STABLE:/41/openSUSE_Leap_15.4/> to see whether it fixes this.

Thanks Alynx help fixing this issue.

I tried the packages from the repo you provided. (tracker, libtracker-sparql-3_0-0, tracker-data-files, tracker-data-files and typelib-1_0-Tracker-3_0 were updated)

The bijiben can be started for the first time now.

But if we start the bijiben from terminal, we still can see lots of errors 
"(bijiben:973): Tracker-CRITICAL **: 10:59:47.084: SQLite error: database disk image is malformed (errno: No such file or directory)"

One more thing I observed is that: if I use the gnome-terminal to start the application bijiben, the bijiben window will be shown behind the gnome-terminal window. That's to say, if my gnome-terminal is in full screen mode, then I am not able to see the bijiben window directly unless I switch to it specifically.

I don't think this is right.

Could you try `tracker3 reset -rs` first to remove the current on disk database and see whether the error disappears?

(In reply to Alynx Zhou from comment #5)
> Could you try `tracker3 reset -rs` first to remove the current on disk
> database and see whether the error disappears?

The error "(bijiben:17287): Tracker-CRITICAL **: 14:43:02.910: SQLite error: database disk image is malformed (errno: No such file or directory)" still appears after doing "tracker3 reset -rs"

Is this happen without the patch? What if you remove `~/.local/share/tracker/data/` ?

(In reply to Alynx Zhou from comment #7)
> Is this happen without the patch? What if you remove
> `~/.local/share/tracker/data/` ?

No, as I wrote in the #c0, the errors are there without your patch.

Remove `~/.local/share/tracker/data/` and the errors still appear.

OK, I think it is another problem, it should be fixed if we can find the corrupted database and clear it. But I don't know where the database is.

Let's submit the fix first.

(In reply to Alynx Zhou from comment #9)
> OK, I think it is another problem, it should be fixed if we can find the
> corrupted database and clear it. But I don't know where the database is.
> 
> Let's submit the fix first.

Thanks. 
bsc#1223121 was filed to track the SQLite error issue.

Patch merged and let's close this.

SUSE-RU-2024:1467-1: An update that has one fix can now be installed.

Category: recommended (moderate)
Bug References: 1222949
Maintenance Incident: [SUSE:Maintenance:33568](https://smelt.suse.de/incident/33568/)
Sources used:
SUSE Manager Server 4.3 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Linux Enterprise Workstation Extension 15 SP5 (src):
 tracker-3.2.1-150400.3.6.2
openSUSE Leap 15.4 (src):
 tracker-3.2.1-150400.3.6.2
openSUSE Leap 15.5 (src):
 tracker-3.2.1-150400.3.6.2
Basesystem Module 15-SP5 (src):
 tracker-3.2.1-150400.3.6.2
Desktop Applications Module 15-SP5 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Linux Enterprise Server for SAP Applications 15 SP4 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Manager Proxy 4.3 (src):
 tracker-3.2.1-150400.3.6.2
SUSE Manager Retail Branch Server 4.3 (src):
 tracker-3.2.1-150400.3.6.2

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.