How to recover/reset the database
Hi,
I am getting crash reports on Fedora since a couple of months and have finally decided to investigate the issue. Here is the output of
journalctl --user --unit=tracker-miner-fs-3.service --unit=tracker-extract-3.service --priority=7
-- Reboot --
Jan 12 09:06:38 renato-desktop systemd[1689]: Starting Tracker file system data miner...
Jan 12 09:06:38 renato-desktop tracker-miner-f[4497]: tracker-miner-fs-3 running as org.freedesktop.Tracker3.Miner.Files
Jan 12 09:06:38 renato-desktop tracker-miner-f[4497]: SQLite error: database disk image is malformed (errno: No such file or directory)
Jan 12 09:06:38 renato-desktop tracker-miner-f[4497]: database disk image is malformed
Jan 12 09:06:38 renato-desktop tracker-miner-f[4497]: SQLite error: database disk image is malformed (errno: Bad file descriptor)
Jan 12 09:06:38 renato-desktop systemd-coredump[4506]: Process 4497 (tracker-miner-f) of user 1000 dumped core.
Stack trace of thread 4497:
#0 0x00007fafc3b339c3 setup_interface_cb (libtracker-sparql-3.0.so.0 + 0x389c3)
#1 0x00007fafc3bcae2a g_closure_invoke (libgobject-2.0.so.0 + 0x13e2a)
#2 0x00007fafc3bf4273 signal_emit_unlocked_R.isra.0 (libgobject-2.0.so.0 + 0x3d273)
#3 0x00007fafc3be7f82 g_signal_emit_valist (libgobject-2.0.so.0 + 0x30f82)
#4 0x00007fafc3be81a3 g_signal_emit (libgobject-2.0.so.0 + 0x311a3)
#5 0x00007fafc3b68497 tracker_sparql_execute_cursor (libtracker-sparql-3.0.so.0 + 0x6d497)
#6 0x00007fafc3b33e58 tracker_data_query_sparql_cursor (libtracker-sparql-3.0.so.0 + 0x38e58)
#7 0x00007fafc3b34c34 load_ontology_file (libtracker-sparql-3.0.so.0 + 0x39c34)
#8 0x00007fafc3b37f79 tracker_data_manager_initable_init (libtracker-sparql-3.0.so.0 + 0x3cf79)
#9 0x00007fafc3b2ef6c tracker_direct_connection_initable_init (libtracker-sparql-3.0.so.0 + 0x33f6c)
#10 0x00007fafc3b19a71 tracker_sparql_connection_new (libtracker-sparql-3.0.so.0 + 0x1ea71)
#11 0x000055d82e701210 main (tracker-miner-fs-3 + 0xb210)
#12 0x00007fafc392a1e2 __libc_start_main (libc.so.6 + 0x281e2)
#13 0x000055d82e7017ee _start (tracker-miner-fs-3 + 0xb7ee)
Stack trace of thread 4498:
#0 0x00007fafc39f880f __poll (libc.so.6 + 0xf680f)
#1 0x00007fafc3e836f6 g_main_context_iterate.constprop.0 (libglib-2.0.so.0 + 0xa56f6)
#2 0x00007fafc3e2ed43 g_main_context_iteration (libglib-2.0.so.0 + 0x50d43)
#3 0x00007fafc3e30961 glib_worker_main (libglib-2.0.so.0 + 0x52961)
#4 0x00007fafc3e5f2b2 g_thread_proxy (libglib-2.0.so.0 + 0x812b2)
#5 0x00007fafc36463f9 start_thread (libpthread.so.0 + 0x93f9)
#6 0x00007fafc3a03903 __clone (libc.so.6 + 0x101903)
Stack trace of thread 4499:
#0 0x00007fafc39f880f __poll (libc.so.6 + 0xf680f)
#1 0x00007fafc3e836f6 g_main_context_iterate.constprop.0 (libglib-2.0.so.0 + 0xa56f6)
#2 0x00007fafc3e31033 g_main_loop_run (libglib-2.0.so.0 + 0x53033)
#3 0x00007fafc3d20d1a gdbus_shared_thread_func.lto_priv.0 (libgio-2.0.so.0 + 0x10fd1a)
#4 0x00007fafc3e5f2b2 g_thread_proxy (libglib-2.0.so.0 + 0x812b2)
#5 0x00007fafc36463f9 start_thread (libpthread.so.0 + 0x93f9)
#6 0x00007fafc3a03903 __clone (libc.so.6 + 0x101903)
Stack trace of thread 4500:
#0 0x00007fafc39f880f __poll (libc.so.6 + 0xf680f)
#1 0x00007fafc3e836f6 g_main_context_iterate.constprop.0 (libglib-2.0.so.0 + 0xa56f6)
#2 0x00007fafc3e2ed43 g_main_context_iteration (libglib-2.0.so.0 + 0x50d43)
#3 0x00007fafb1b8464d dconf_gdbus_worker_thread (libdconfsettings.so + 0x664d)
#4 0x00007fafc3e5f2b2 g_thread_proxy (libglib-2.0.so.0 + 0x812b2)
#5 0x00007fafc36463f9 start_thread (libpthread.so.0 + 0x93f9)
#6 0x00007fafc3a03903 __clone (libc.so.6 + 0x101903)
Stack trace of thread 4501:
#0 0x00007fafc39fe30d syscall (libc.so.6 + 0xfc30d)
#1 0x00007fafc3e7ddf3 g_cond_wait (libglib-2.0.so.0 + 0x9fdf3)
#2 0x00007fafc3e023db g_async_queue_pop_intern_unlocked (libglib-2.0.so.0 + 0x243db)
#3 0x00007fafc3e61e27 g_thread_pool_thread_proxy.lto_priv.0 (libglib-2.0.so.0 + 0x83e27)
#4 0x00007fafc3e5f2b2 g_thread_proxy (libglib-2.0.so.0 + 0x812b2)
#5 0x00007fafc36463f9 start_thread (libpthread.so.0 + 0x93f9)
#6 0x00007fafc3a03903 __clone (libc.so.6 + 0x101903)
Jan 12 09:06:38 renato-desktop systemd[1689]: tracker-miner-fs-3.service: Main process exited, code=dumped, status=11/SEGV
Jan 12 09:06:38 renato-desktop systemd[1689]: tracker-miner-fs-3.service: Failed with result 'core-dump'.
Jan 12 09:06:38 renato-desktop systemd[1689]: Failed to start Tracker file system data miner.
How can I recover the database, or rebuild it?