hamster-service fails to start with: sqlite3.OperationalError: index idx_facts_start_end already exists

[Jens Askengren]

Binary package hint: hamster-applet

After an upgrade from Ubuntu 10.04 to 10.10 I can no longer start the hamster applet.

Starting hamster-time-tracker gives the following error:

{{{
$ hamster-time-tracker
ERROR:dbus.proxies:Introspect error on :1.317:/org/gnome/Hamster: dbus.exceptions.DBusException: org.freedesktop.DBus.Error.NoReply: Message did not receive a reply (timeout by message bus)
Traceback (most recent call last):
  File "/usr/bin/hamster-time-tracker", line 530, in <module>
    getattr(WindowServer(), window)()
  File "/usr/bin/hamster-time-tracker", line 459, in main
    self.app = ProjectHamster()
  File "/usr/bin/hamster-time-tracker", line 37, in __init__
    self.new_name = widgets.ActivityEntry()
  File "/usr/lib/pymodules/python2.6/hamster/widgets/activityentry.py", line 102, in __init__
    self.populate_suggestions()
  File "/usr/lib/pymodules/python2.6/hamster/widgets/activityentry.py", line 225, in populate_suggestions
    self.activities = runtime.storage.get_activities(input_activity.activity_name)
  File "/usr/lib/pymodules/python2.6/hamster/client.py", line 135, in get_activities
    return self._to_dict(('name', 'category'), self.conn.GetActivities(search))
  File "/usr/lib/pymodules/python2.6/dbus/proxies.py", line 68, in __call__
    return self._proxy_method(*args, **keywords)
  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.317 was not provided by any .service files
}}}

Starting the service manually gives the following error:

{{{
$ hamster-service
hamster-service up
Traceback (most recent call last):
  File "/usr/bin/hamster-service", line 22, in <module>
    storage = db.Storage(loop)
  File "/usr/lib/pymodules/python2.6/hamster/db.py", line 82, in __init__
    self.run_fixtures()
  File "/usr/lib/pymodules/python2.6/hamster/db.py", line 1137, in run_fixtures
    self.execute("CREATE INDEX idx_facts_start_end ON facts(start_time, end_time)")
  File "/usr/lib/pymodules/python2.6/hamster/db.py", line 921, in execute
    cur.execute(state, param)
sqlite3.OperationalError: index idx_facts_start_end already exists
}}}

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: hamster-applet 2.31.92-0ubuntu2
ProcVersionSignature: Ubuntu 2.6.35-22.34-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
NonfreeKernelModules: nvidia
Architecture: i386
Date: Tue Oct 19 15:14:37 2010
EcryptfsInUse: Yes
ProcEnviron:
 PATH=(custom, no user)
 LANG=sv_SE.utf8
 SHELL=/bin/bash
SourcePackage: hamster-applet