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

[Philip Van Hoof <philip codeminded be>]

Hi there,

If you shut down tracker cleanly, it doesn't do this. 

There's unfortunately no (other) way to know that the DB is still fine
if you don't shut Tracker down cleanly. That's because we have
synchronous = off for the SQLite database (in default configuration).

Regards,

Philip

On Wed, 2012-02-08 at 10:00 +0100, Mildred Ki'Lya wrote:
> 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)
> _______________________________________________
> tracker-list mailing list
> tracker-list gnome org
> http://mail.gnome.org/mailman/listinfo/tracker-list

-- 


Philip Van Hoof
Software developer
Codeminded BVBA - http://codeminded.be