[Zeitgeist] [Bug 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
Marking as fixed in unity because of the ZG fix. ** Changed in: unity-lens-files Status: Incomplete => Fix Released ** Changed in: unity Status: Incomplete => 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Fix Released Status in Unity Files Lens: Fix Released Status in Zeitgeist Framework: Fix Released Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
** 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: Fix Released Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
** Changed in: zeitgeist Status: In Progress => Fix Committed -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: Fix Committed Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
** Branch linked: lp:~rainct/zeitgeist/961974 -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: In Progress Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
Basically yea, it's a question of way the DB is corrupted, if there's some misbehaving dataprovider that corrupts it (yes there'd had to be some vulnerability in our code and sqlite) we could end up just retiring the DB all the time. That said my concern was more because some requests might be queued up which might not fail, but that could be solved by firing a low prio timer to retire the DB and quit. -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: In Progress Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
2012/3/30 Michal Hruby : > perhaps mark the DB tainted and retire it on next startup? > The question then is if the tainted flag will survive in the corrupted > DB. Thought about doing it this way, but really what does it get us? We can just rename the file (retire_database()) and quit, so the next start will see it's gone and re-cerate it. -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: In Progress Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
> b) PRAGMA quick_check: not sure if it'll catch everything? also, in my quick testing it scaled super-linearly (0.08s for 8MB DB, 0.16 for 13MB DB) That's pretty slow considering we use dbus-activation a lot and need a reply asap. I'd say that if the initial opening of DB doesn't fail (+the get_last_id) we could assume that the DB is fine. If we then get SQLITE_CORRUPT during one of the regular queries, we should do something about that - perhaps mark the DB tainted and retire it on next startup? The question then is if the tainted flag will survive in the corrupted DB. -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: In Progress Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
[Development discussion, bug reporters feel free to ignore this] OK, so the plan is to improve Zeitgeist's database corruption recovery. The log provided in this bug report is for the get_last_id() query. I don't know how many cases that'll cover, but if we want to be comprehensive it won't be enough. I'd prefer doing the checking at startup time, but I don't see any good way: a) PRAGMA integrity_check: way too slow b) PRAGMA quick_check: not sure if it'll catch everything? also, in my quick testing it scaled super-linearly (0.08s for 8MB DB, 0.16 for 13MB DB) c) SELECT from all tables: also likely not comprehensive enough. The alternative would be checking all (?) queries we do for SQLITE_CORRUPT and in that case calling Utils.retire_database. (We may want some constraint though, to avoid ending up with 50 databases if there's some serious file system problem with a system). Comments? -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: In Progress Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ 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 961974] Re: Recover from Zeitgeist database corruption (detected at query time)
** Summary changed: - dash (or file lens) doesn't find file + Recover from Zeitgeist database corruption (detected at query time) -- 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/961974 Title: Recover from Zeitgeist database corruption (detected at query time) Status in Unity: Incomplete Status in Unity Files Lens: Incomplete Status in Zeitgeist Framework: In Progress Bug description: This is based on the checkbox test: 1. Start gedit. 2. Save a file named "foo" in your home folder. 1. Tap super to open the dash 2. Enter "f" -> The results should contain at least the "foo" file and "Firefox" 3. Click on the cross next to "f", in the textentry -> The "f" search should be canceled, bringing you back to the generic "Search" entry with the default elements I slightly modified it and instead of file called foo I have a "hello_world_file" (as foo returned far too many other results). Actual result: The file can not be found via dash (or file lens). ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: unity 5.6.0+bzr2156ubuntu0+670 [origin: LP-PPA-unity-team-staging] ProcVersionSignature: Ubuntu 3.2.0-19.31-generic-pae 3.2.12 Uname: Linux 3.2.0-19-generic-pae i686 ApportVersion: 1.94.1-0ubuntu2 Architecture: i386 CompizPlugins: [core,composite,opengl,compiztoolbox,decor,vpswitch,snap,mousepoll,resize,place,move,wall,grid,regex,imgpng,session,gnomecompat,animation,fade,unitymtgrabhandles,workarounds,scale,expo,ezoom,unityshell] CrashDB: unity Date: Thu Mar 22 10:00:40 2012 InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release i386 (20111012) SourcePackage: unity UpgradeStatus: Upgraded to precise on 2012-02-17 (33 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/unity/+bug/961974/+subscriptions ___ Mailing list: https://launchpad.net/~zeitgeist Post to : zeitgeist@lists.launchpad.net Unsubscribe : https://launchpad.net/~zeitgeist More help : https://help.launchpad.net/ListHelp