[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
** Branch linked: lp:~zeitgeist-packagers/zeitgeist/debian -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Fix Committed 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
** Changed in: zeitgeist Status: Fix Committed = Fix Released -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Fix Released 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
Thanks for the reviews, I addressed them in my last commits to this branch, I still need to test if the TEMP triggers are working properly. -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
I looked at Markus' branch and I think it makes sense - provided that we're still confident that the cache gives us a boost :-) And we're bumpting the schema version anayway... A quick pre-review of Markus' branch: - there seems to be missing a commit() after the DELETE statement? - _fix_cache should be pruned when we're done with cleaning the memory cache? - The INTRGER thing Siegfried noted -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
Also! _fix_cache can be a temp table or something right? sqlite has something akin to a memory backed table that is lost when the process dies. We might as well use that? -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
Since Mikkel hasn't commented yet, let's leave this for 0.8. ** Changed in: zeitgeist Milestone: 0.7.1 = 0.8.0 -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
** Changed in: zeitgeist Milestone: 0.8.0 = 0.7.1 -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
** Branch linked: lp:~thekorn/zeitgeist/fix-598666-remove_cache_entry -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
I've added a prototype of my idea as described in my last comment, if we want to do it this way, we have to bump the sql-schema-version, I guess. I'm not completely sure if this is the way to go, but given the fact that the number of entries in the _fix_cache table should be *very* low over time this should not be a big performance issue, and works well. Comments welcome. -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
Hey Markus, Nice to hear from you again. What you're proposing sounds better than adding a C binding file for update_hook (unless we decide we want to start adding more C stuff, but I can't think of what that'd be right now). I guess it's the best we can do. If we're going to do this it should be merged with lp:~zeitgeist/zeitgeist/dbschema4/. I'd like to finish the cache benchmarking first, though. By the way: cursor.execute(CREATE TABLE IF NOT EXISTS _fix_cache (t VARCHAR, id INTRGER) You've got a typo in there (INTRGER - INTEGER). -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
Re: [Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
I don't have any clever solution off the top of my head - I just want to give Siegfried some props for the cool detective work! Nice job! Now. To thinking. ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
Oh yeah, of course. Indeed, good work Siegfried. While reading the last few comments one possible fix came into my mind: Let's maintain a (temporary) helper table called '_fix_cache' with (table_name VARCHAR, id INTEGER) and create a 'BEFORE DELETE' trigger on each cached table (interpretation, manifestation, mimetype, ...) which inserts the table name and the deleted id in _fix_cache once a row in the related table got deleted. All we now have to do is run a 'SELECT * FROM _fix_cache' after deleting the events. If some rows in manifestation/interpretation/... got deleted while deleting events we get back the the ids of the cached values which we then can delete from the caches. I know that's not optimal, but looks like the only solution to me. This should not be a *big* performance issue, since the number of rows in the helper table should be very low. I'll hack on a prototype tomorrow, and see how it works. -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
I'm re-opening this since I've finally found the cause of this problem! When events are deleted, interpretations/manifestations/mimetypes/etc. which are no longer used are automatically removed from the database. However, the cache isn't informed about this and until Zeitgeist is restarted it'll continue using the IDs of the deleted rows for new events. (I'm setting the importance down since a workaround for the problem is already deployed). ** Changed in: zeitgeist Importance: High = Medium ** Changed in: zeitgeist Status: Fix Released = Triaged -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
The last release added a workaround for this. Since we currently aren't able to reproduce this issue, I'm just going to close this bug now. Please re-open it if you can provide a test case to reproduce the problem. ** Changed in: zeitgeist Status: Triaged = Fix Released ** Changed in: zeitgeist Assignee: Siegfried Gevatter (rainct) = (unassigned) -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Fix Released 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
Seif sent me an activity.log which he managed to create by [...] randomly clicking in GAJ and synapse[...]. This log is broken and results in the above mentioned KeyError. The db has a few broken entries: http://paste.ubuntu.com/553188/ -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
So I just added a little temporary fix that I would like to see with the next release. Instead of zeitgeist returning nothing when requesting a time-period with a broken event, zeitgeist now can ignore the broken event and return a list with healthy events. The broken events can be seen in the log under Error ** Branch linked: lp:~seif/zeitgeist/catch_cache_error -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
** Summary changed: - Error when trying to fetch items + Invalid cache access (was: Error when trying to fetch items) -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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
[Zeitgeist] [Bug 598666] Re: Invalid cache access (was: Error when trying to fetch items)
** Changed in: zeitgeist Milestone: None = 0.7.0 -- You received this bug notification because you are a member of Zeitgeist Framework Team, which is subscribed to Zeitgeist Framework. https://bugs.launchpad.net/bugs/598666 Title: Invalid cache access (was: Error when trying to fetch items) Status in Zeitgeist Framework: Triaged 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