[Tracker] tracker-store: PRAGMA integrity_check(1) takes too long

["Mildred Ki'Lya" <mildred593+ml tracker gmail com>]

Hi,

tracker-store takes too long to complete the PRAGMA integrity_check(1) at startup. This causes tracker-control to timeout on startup and following status queries.
Perhaps it could be imagined to have this run in background so tracker-store could still answers basic status queries. If tracker-store is asked a query or and update, it should respond with a tempoary error.

I found that while debugging my tracker installation ... when I search something, i get a DBus timeout. I'd much rather prefer to have a meaningful error telling me for example "Tracker is starting and running integrity checks. It is not available at the moment. Please try again later"

Here is  the log of tracker-store up to now:

08 Feb 2012, 03:49:12: Tracker: tracker-store 0.10.25
08 Feb 2012, 03:49:12: Tracker: General options:
08 Feb 2012, 03:49:12: Tracker:   Verbosity  ............................  3
08 Feb 2012, 03:49:12: Tracker: Store options:
08 Feb 2012, 03:49:12: Tracker:   Readonly mode  ........................  no
08 Feb 2012, 03:49:12: Tracker: Log verbosity is set to 3, enabling D-Bus client lookup
08 Feb 2012, 03:49:12: Tracker: Registering D-Bus object...
08 Feb 2012, 03:49:12: Tracker:   Path:'/org/freedesktop/Tracker1/Status'
08 Feb 2012, 03:49:12: Tracker:   Type:'TrackerStatus'
08 Feb 2012, 03:49:12: Tracker: Registering D-Bus object...
08 Feb 2012, 03:49:12: Tracker:   Path:'/org/freedesktop/Tracker1/Statistics'
08 Feb 2012, 03:49:12: Tracker:   Type:'TrackerStatistics'
08 Feb 2012, 03:49:12: Tracker: Registering D-Bus object...
08 Feb 2012, 03:49:12: Tracker:   Path:'/org/freedesktop/Tracker1/Resources'
08 Feb 2012, 03:49:12: Tracker:   Type:'TrackerResources'
08 Feb 2012, 03:49:12: Tracker: Registering D-Bus object...
08 Feb 2012, 03:49:12: Tracker:   Path:'/org/freedesktop/Tracker1/Steroids'
08 Feb 2012, 03:49:12: Tracker:   Type:'TrackerSteroids'
08 Feb 2012, 03:49:12: Tracker: Registering D-Bus object...
08 Feb 2012, 03:49:12: Tracker:   Path:'/org/freedesktop/Tracker1/Backup'
08 Feb 2012, 03:49:12: Tracker:   Type:'TrackerBackup'
08 Feb 2012, 03:49:12: Tracker: Registering D-Bus service...
  Name:'org.freedesktop.Tracker1'
08 Feb 2012, 03:49:12: Tracker: Locale 'TRACKER_LOCALE_LANGUAGE' was set to 'en_US.UTF-8'
08 Feb 2012, 03:49:12: Tracker: Locale 'TRACKER_LOCALE_TIME' was set to 'en_US.UTF-8'
08 Feb 2012, 03:49:12: Tracker: Locale 'TRACKER_LOCALE_COLLATE' was set to 'en_US.UTF-8'
08 Feb 2012, 03:49:12: Tracker: Locale 'TRACKER_LOCALE_NUMERIC' was set to 'en_US.UTF-8'
08 Feb 2012, 03:49:12: Tracker: Locale 'TRACKER_LOCALE_MONETARY' was set to 'en_US.UTF-8'
08 Feb 2012, 03:49:12: Tracker: Setting database locations
08 Feb 2012, 03:49:12: Tracker: Checking database directories exist
08 Feb 2012, 03:49:12: Tracker: Checking database version
08 Feb 2012, 03:49:12: Tracker: Checking database files exist
08 Feb 2012, 03:49:12: Tracker: Loading databases files...
08 Feb 2012, 03:49:12: Tracker: Didn't shut down cleanly last time, doing integrity checks
08 Feb 2012, 03:49:12: Tracker: Loading database... '/home/tracker/tracker/tracker-home/.cache/tracker/meta.db' (metadata)
08 Feb 2012, 03:49:12: Tracker: Opened sqlite3 database:'/home/tracker/tracker/tracker-home/.cache/tracker/meta.db'
08 Feb 2012, 03:49:12: Tracker: Resetting collator in db interface 0xe8c8b0
08 Feb 2012, 03:49:12: Tracker: [libunistring collation] Initializing collator for locale 'en_US.UTF-8'
08 Feb 2012, 03:49:13: Tracker: Preparing query: 'PRAGMA journal_mode = WAL;'
08 Feb 2012, 03:49:13: Tracker:   Setting page size to 8192
08 Feb 2012, 03:49:13: Tracker:   Setting cache size to 250
08 Feb 2012, 03:49:13: Tracker: Preparing query: 'PRAGMA integrity_check(1)'
... (it has been running for 10 minutes now)