[Zeitgeist] [Bug 966896] Re: zeitgeist-daemon fails to start - gives SQL error
I'd say yes, we are hitting also failed upgrades, although a proper fix for that it to implement the upgrade. -- 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/966896 Title: zeitgeist-daemon fails to start - gives SQL error Status in Zeitgeist Framework: New Status in “zeitgeist” package in Ubuntu: New Bug description: I noticed that Unity was not giving me file suggestions. After checking I saw that zeitgeist-datahub was running, but not zeitgeist- daemon. When I tried to start the daemon I got this SQL error. $ zeitgeist-daemon [07:31:33.943617 WARNING] zeitgeist-daemon.vala:473: Can't create database: 1, table event has no column named origin Unable to execute SQL: CREATE INDEX IF NOT EXISTS event_origin ON event(origin) FYI, this was a direct LTS upgrade from 10.04, and I have not been using zeitgeist before. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: zeitgeist 0.8.99~beta1-1 ProcVersionSignature: Ubuntu 3.2.0-20.33-generic 3.2.12 Uname: Linux 3.2.0-20-generic i686 ApportVersion: 1.95-0ubuntu1 Architecture: i386 Date: Wed Mar 28 20:29:01 2012 PackageArchitecture: all ProcEnviron: TERM=xterm PATH=(custom, user) LANG=en_NZ.UTF-8 SHELL=/bin/bash SourcePackage: zeitgeist UpgradeStatus: Upgraded to precise on 2012-03-19 (8 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/zeitgeist/+bug/966896/+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 966896] Re: zeitgeist-daemon fails to start - gives SQL error
@ James Mitchel: Weird, that error doesn't really make sense. Anyway, you can fix it by deleting the file ~/.local/share/zeitgeist/activity.sqlite. @ Zeitgeist devs: We currently have the following code to handle errors in schema creation: if (err is EngineError.DATABASE_CORRUPT && retry) rc = Sqlite.CORRUPT; else if (err is EngineError.DATABASE_CANTOPEN) rc = Sqlite.CANTOPEN; else if (err is EngineError.DATABASE_BUSY) rc = Sqlite.BUSY; else throw err; Do we want to change the else to also retire the DB? ** Also affects: zeitgeist Importance: Undecided Status: New -- 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/966896 Title: zeitgeist-daemon fails to start - gives SQL error Status in Zeitgeist Framework: New Status in “zeitgeist” package in Ubuntu: New Bug description: I noticed that Unity was not giving me file suggestions. After checking I saw that zeitgeist-datahub was running, but not zeitgeist- daemon. When I tried to start the daemon I got this SQL error. $ zeitgeist-daemon [07:31:33.943617 WARNING] zeitgeist-daemon.vala:473: Can't create database: 1, table event has no column named origin Unable to execute SQL: CREATE INDEX IF NOT EXISTS event_origin ON event(origin) FYI, this was a direct LTS upgrade from 10.04, and I have not been using zeitgeist before. ProblemType: Bug DistroRelease: Ubuntu 12.04 Package: zeitgeist 0.8.99~beta1-1 ProcVersionSignature: Ubuntu 3.2.0-20.33-generic 3.2.12 Uname: Linux 3.2.0-20-generic i686 ApportVersion: 1.95-0ubuntu1 Architecture: i386 Date: Wed Mar 28 20:29:01 2012 PackageArchitecture: all ProcEnviron: TERM=xterm PATH=(custom, user) LANG=en_NZ.UTF-8 SHELL=/bin/bash SourcePackage: zeitgeist UpgradeStatus: Upgraded to precise on 2012-03-19 (8 days ago) To manage notifications about this bug go to: https://bugs.launchpad.net/zeitgeist/+bug/966896/+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