Comment 9 for bug 660307

To replicate this
1) Backup the activity.sqlite DB
2) restart the daemon
3) while its saying "DEBUG:zeitgeist.sql:Updating sql schema" kill the
daemon

On Fri, Nov 12, 2010 at 8:13 PM, Seif Lotfy <email address hidden>wrote:

> I manged to replicate this manually creating an invalid structure. Thank
> you for the bug. We are on it.
>
> ** Changed in: zeitgeist
> Status: Incomplete => Confirmed
>
> ** Changed in: zeitgeist
> Assignee: (unassigned) => Seif Lotfy (seif)
>
> ** Changed in: zeitgeist
> Milestone: None => 0.7.0
>
> ** Changed in: zeitgeist
> Status: Confirmed => Triaged
>
> ** Changed in: zeitgeist
> Importance: Undecided => Low
>
> ** Changed in: zeitgeist (Ubuntu)
> Assignee: (unassigned) => Seif Lotfy (seif)
>
> ** Changed in: zeitgeist (Ubuntu)
> Status: New => Confirmed
>
> --
> zeitgeist fails to run if its database structure is not complete
> https://bugs.launchpad.net/bugs/660307
> You received this bug notification because you are a bug assignee.
>
> Status in Zeitgeist Framework: Triaged
> Status in “zeitgeist” package in Ubuntu: Confirmed
>
> Bug description:
> Binary package hint: zeitgeist
>
> If zeitgeist's database (~/.local/share/zeitgeist/activity.sqlite) is
> incomplete, eg missing the events table, zeitgeist fails to run. And because
> the GUI does not report that zeitgeist faiiled to run, applications that
> rely on zeitgeist simply fail to work without any relevant reason given.
>
> I ran into this problem on upgrading an installation from Ubuntu 10.04 to
> 10.10. After the upgrade, the dockbarx applet failed to run. The error
> message from gnome-panel just said it had failed to run, and
> .xsession-errors said the child process did not report any specific error.
> Running in debug mode (ie with the command "dockbarx-factory.py
> run-in-window") gave:
>
> ERROR:dbus.proxies:Introspect error on
> :1.134:/org/gnome/zeitgeist/log/activity: dbus.exceptions.DBusException:
> org.freedesktop.DBus.Error.NoReply: Message did not receive a reply (timeout
> by message bus)
> DEBUG:dbus.proxies:Executing introspect queue due to error
> Traceback (most recent call last):
> File "/usr/bin/dockbarx_factory.py", line 26, in <module>
> import dockbarx.dockbar
> ...
> File "/usr/lib/pymodules/python2.6/dbus/proxies.py", line 140, in __call__
> **keywords)
> File "/usr/lib/pymodules/python2.6/dbus/connection.py", line 620, in
> call_blocking
> message, timeout)
> dbus.exceptions.DBusException: org.freedesktop.DBus.Error.ServiceUnknown:
> The name :1.134 was not provided by any .service files
>
> The error appeared to be a dbus error, but in fact was a problem with
> zeitgeist, which was failing to run because its database apparently was
> corrupted during the upgrade. I fixed the problem (eventually) by deleting
> the zeitgeist database file and restarting the zeitgeist-daemon manually.
>
>
> What I would expect to happen is:
>
> 1) The GUI should report that zeitgeist has failed to run.
>
> 2) Better yet, zeitgeist could create the necessary tables if its database
> is invalid or perhaps backup the old database and create a new one so it can
> run properly.
>
> It would of course be nice if dockbarx reported better error information,
> but since there are other applications that depend on zeitgeist, it would be
> good if zeitgeist could recover from this situation.
>
> ProblemType: Bug
> DistroRelease: Ubuntu 10.10
> Package: zeitgeist 0.5.2-0ubuntu1
> ProcVersionSignature: Ubuntu 2.6.35-22.34-generic 2.6.35.4
> Uname: Linux 2.6.35-22-generic i686
> Architecture: i386
> Date: Thu Oct 14 11:52:41 2010
> InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Alpha i386
> (20100602.2)
> PackageArchitecture: all
> ProcEnviron:
> PATH=(custom, no user)
> LANG=en_AU.UTF-8
> SHELL=/bin/bash
> SourcePackage: zeitgeist
>
>
>

--
This is me doing some advertisement for my blog http://seilo.geekyogre.com