Storage monitor sets up weird storage ids

Bug #950983 reported by Seif Lotfy
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Zeitgeist Framework
Fix Released
High
Unassigned

Bug Description

Seems like the storage monitor is giving out random ids or something that are not respected by the event
I have several entries in my event table with storage_id 863 which however does not exist.

Related branches

Michal Hruby (mhr3)
Changed in zeitgeist:
milestone: none → 0.9.0
status: New → Confirmed
Revision history for this message
Seif Lotfy (seif) wrote :

Please run this script you will find something bogus there.
I think it has something to do with the storage-monitor extension

http://pastebin.com/sPLu78G5

Revision history for this message
Seif Lotfy (seif) wrote :

http://paste.ubuntu.com/889295/ can some1 please confirm by running this script ?

Revision history for this message
Seif Lotfy (seif) wrote :

So after playing around a bit i found out that the storage id of "net" is incremented everytime i restart zeitgeist... still looking for more clues but it is a hint that it might be

When a UNIQUE constraint violation occurs, the REPLACE algorithm deletes pre-existing rows that are causing the constraint violation prior to inserting or updating the current row and the command continues executing normally.

Which means we should use use 2 statements instead of "INSERT OR REPLACE"

Changed in zeitgeist:
status: Confirmed → Triaged
importance: Undecided → High
Seif Lotfy (seif)
Changed in zeitgeist:
status: Triaged → In Progress
Seif Lotfy (seif)
Changed in zeitgeist:
status: In Progress → Fix Committed
Seif Lotfy (seif)
Changed in zeitgeist:
status: Fix Committed → Fix Released
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.