I added a little script tools/zeitgeist-integrity-checker.py that allows us to debug for DB errors . The solution that I would suggest for now is: 1. Allow the query to continue and return the healthy events and ignore the broken ones instead of just failing. 2. Look into how the broken events get in.
-- Error when trying to fetch items https://bugs.launchpad.net/bugs/598666 You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. Status in Zeitgeist Framework: Incomplete Bug description: When i try to fetch all items in one query i get Error from Zeitgeist engine: org.freedesktop.DBus.Python.KeyError: Traceback (most recent call last): File "/usr/lib/pymodules/python2.6/dbus/service.py", line 702, in _message_cb retval = candidate_method(self, *args, **keywords) File "/usr/local/share/zeitgeist/_zeitgeist/engine/remote.py", line 254, in FindEvents event_templates, storage_state, num_events, result_type, sender)) File "/usr/local/share/zeitgeist/_zeitgeist/engine/main.py", line 378, in find_events return self._find_events(1, *args) File "/usr/local/share/zeitgeist/_zeitgeist/engine/main.py", line 366, in _find_events return self.get_events(rows=result, sender=sender) File "/usr/local/share/zeitgeist/_zeitgeist/engine/main.py", line 188, in get_events events[event.id].append_subject(self._get_subject_from_row(row)) File "/usr/local/share/zeitgeist/_zeitgeist/engine/main.py", line 160, in _get_subject_from_row getattr(self, "_" + field).value(row["subj_" + field])) File "/usr/local/share/zeitgeist/_zeitgeist/engine/sql.py", line 422, in value return self._inv_dict[id] KeyError: 138 This looks serious _______________________________________________ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp