Doesn't work when python-pysqlite2 is installed (IntegrityError: PRIMARY KEY must be unique)

Bug #399434 reported by René Brandenburger
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Zeitgeist Framework
Fix Released
Low
Siegfried Gevatter

Bug Description

after starting zeitgeist-daemon, i get the following integrity errors,
using latest from launchpad (Tree is up to date at revision 1028.)

zeitgeist$ ./zeitgeist-daemon
INFO:zeitgeist.engine.base:Creating database: sqlite:/home/myhome/.local/share/zeitgeist/database.sqlite
DEBUG:root:Checking for another running instance...
DEBUG:root:No other instances found.
INFO:root:Starting Zeitgeist service...
DEBUG:zeitgeist.logger.datasources.firefox:Monitoring Firefox's history: /home/myhome/.mozilla/firefox/hbdfnfz7.default/places.sqlite
DEBUG:zeitgeist.logger.datasources.evolution:Monitoring Evolution: /home/myhome/.evolution/mail/local/folders.db
DEBUG:zeitgeist.logger.database.tomboy:Watching for Tomboy notes in "/home/myhome/.tomboy".
DEBUG:root:Updating database with new Firefox History items
ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Firefox History": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

DEBUG:root:Updating database with new Evolution items
ERROR:root:Error logging item from "Evolution": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

ERROR:root:Error logging item from "Evolution": org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError
Traceback (most recent call last):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../zeitgeist-datahub", line 131, in _insert_events
    self._client.InsertEvents(events)
  File "/var/lib/python-support/python2.6/dbus/proxies.py", line 140, in __call__
    **keywords)
  File "/var/lib/python-support/python2.6/dbus/connection.py", line 622, in call_blocking
    message, timeout)
DBusException: org.freedesktop.DBus.Python.pysqlite2.dbapi2.IntegrityError: Traceback (most recent call last):
  File "/var/lib/python-support/python2.6/dbus/service.py", line 702, in _message_cb
    retval = candidate_method(self, *args, **keywords)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/remote.py", line 198, in InsertEvents
    result = _engine.insert_events(event_list)
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 217, in insert_events
    if self.insert_event(item, commit=False):
  File "/home/myhome/software/lp/zeitgeist/zeitgeist/../_zeitgeist/engine/engine.py", line 187, in insert_event
    (app_uri_id, unicode(ritem["app"])), noresult=True)
  File "/usr/lib/python2.6/dist-packages/storm/store.py", line 104, in execute
    return self._connection.execute(statement, params, noresult)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 203, in execute
    raw_cursor = self.raw_execute(statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/databases/sqlite.py", line 153, in raw_execute
    return Connection.raw_execute(self, statement, params)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 284, in raw_execute
    self._check_disconnect(raw_cursor.execute, *args)
  File "/usr/lib/python2.6/dist-packages/storm/database.py", line 325, in _check_disconnect
    return function(*args, **kwargs)
IntegrityError: PRIMARY KEY must be unique

Related branches

Revision history for this message
Siegfried Gevatter (rainct) wrote : Re: [Bug 399434] [NEW] IntegrityError: PRIMARY KEY must be unique

Zeitgeist does currently not work when python-pysqlite2 is installed;
this will be fixed once we get ride of Storm.

--
Siegfried-Angel Gevatter Pujals (RainCT)
Ubuntu Developer. Debian Contributor.

Revision history for this message
Siegfried Gevatter (rainct) wrote : Re: IntegrityError: PRIMARY KEY must be unique

I've workarounded this for now.

Changed in zeitgeist:
importance: Undecided → Medium
importance: Medium → Low
assignee: nobody → Siegfried Gevatter (rainct)
milestone: none → 0.2
status: New → Fix Released
summary: - IntegrityError: PRIMARY KEY must be unique
+ Doesn't work when python-pysqlite2 is installed (IntegrityError: PRIMARY
+ KEY must be unique)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.