[11.04→12.04 upgrade] zeitgeist-daemon crashes with "zeitgeist-daemon.vala:473: Unable to upgrade from schema version 3"

Bug #986928 reported by Sabin Iacob
14
This bug affects 3 people
Affects Status Importance Assigned to Milestone
zeitgeist (Ubuntu)
Triaged
High
Canonical Desktop Team
Precise
Triaged
High
Canonical Desktop Team
Quantal
Triaged
High
Mikkel Kamstrup Erlandsen

Bug Description

The end result is that none of the search options in dash work

The issue is solvable by removing $HOME/.local/share/zeitgeist, but it's pretty hard to diagnose for the casual user; to find this out I had to:

* kill unity-applications-daemon
* start it in a terminal, see it complains about zeitgeist-daemon
* start zeitgeist-daemon, see the error message in the subject, fumble around on the internets for half an hour, attempt to purge/reinstall zeitgeist
* finally start zeitgeist-daemon --log-level=DEBUG, see this:

[16:45:33.549992 DEBUG] utils.vala:59: DATA_PATH = $HOME/.local/share/zeitgeist
[16:45:33.550419 DEBUG] utils.vala:78: DATABASE_FILE_PATH = $HOME/.local/share/zeitgeist/activity.sqlite
[16:45:33.554772 DEBUG] sql-schema.vala:135: schema_version is 3
[16:45:33.555311 WARNING] zeitgeist-daemon.vala:473: Unable to upgrade from schema version 3

... and guess it doesn't like the database, remove the whole thing just to be sure

At least an informative message would be in order, if removing some obscure data automatically is not an option.

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: zeitgeist-core 0.9.0-1
ProcVersionSignature: Ubuntu 3.2.0-23.36-generic 3.2.14
Uname: Linux 3.2.0-23-generic x86_64
NonfreeKernelModules: wl
ApportVersion: 2.0.1-0ubuntu5
Architecture: amd64
Date: Sun Apr 22 19:47:10 2012
InstallationMedia: Ubuntu 11.04 "Natty Narwhal" - Release amd64 (20110427.1)
ProcEnviron:
 LANGUAGE=en_US:en
 TERM=xterm
 PATH=(custom, user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: zeitgeist
UpgradeStatus: Upgraded to precise on 2012-04-21 (1 days ago)

Revision history for this message
Sabin Iacob (iacobs) wrote :
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in zeitgeist (Ubuntu):
status: New → Confirmed
Revision history for this message
Christian Reis (kiko) wrote :

Affects at least anyone upgrading from 11.04 -- this hit me today and left me exasperated.

Revision history for this message
Steve Langasek (vorlon) wrote :

I understand that zeitgeist crashing makes the dash unusable, so this should be a high priority for fixing in 12.04.

Changed in zeitgeist (Ubuntu):
importance: Undecided → High
status: Confirmed → Triaged
Changed in zeitgeist (Ubuntu Quantal):
status: New → Triaged
importance: Undecided → High
Changed in zeitgeist (Ubuntu Precise):
assignee: nobody → Canonical Desktop Team (canonical-desktop-team)
tags: added: rls-mgr-p-tracking
Changed in zeitgeist (Ubuntu Quantal):
assignee: nobody → Canonical Desktop Team (canonical-desktop-team)
Changed in zeitgeist (Ubuntu Precise):
importance: High → Critical
Changed in zeitgeist (Ubuntu Quantal):
importance: High → Critical
Revision history for this message
Martin Pitt (pitti) wrote :

Seif kindly agreed to look into this.

If the DB upgrade cannot be done in-place, I propose to delete or move it aside when the new version starts. It's better to start with blank DB after a major upgrade than not starting at all.

Thanks!

Changed in zeitgeist (Ubuntu Quantal):
assignee: Canonical Desktop Team (canonical-desktop-team) → Seif Lotfy (seif)
Revision history for this message
Mikkel Kamstrup Erlandsen (kamstrup) wrote :

Looked a bit into this. Zeitgeist-0.9.0 does not support upgrading from schema version 3 to 6. Only from 4 to 6. The relevant revision in lp:zeitgeist is:

revno: 478
committer: Siegfried-Angel Gevatter Pujals <email address hidden>
timestamp: Sun 2012-04-22 21:32:14 +0200
message:
  Add support for upgrading from schema version 3

  This schema version featured new columns in the `storage' and
  `event' tables.
modified:
  src/sql-schema.vala

Revision history for this message
Mikkel Kamstrup Erlandsen (kamstrup) wrote :

Useful info on schema versions:

 Natty, zeitgeist 0.7.1, schema version 3
 Oneiric, zeitgeist 0.8.2, schema version 4
 Precise , zeitgeist 0.9.0, schema version 6

Revision history for this message
Martin Pitt (pitti) wrote :

Didier says Mikkel already fixed this in trunk.

Changed in zeitgeist (Ubuntu Quantal):
assignee: Seif Lotfy (seif) → Mikkel Kamstrup Erlandsen (kamstrup)
Revision history for this message
Martin Pitt (pitti) wrote :

didrocks | pitti: so, it seems that only natty -> precise upgrade is broken
didrocks | not natty -> oneiric -> precise
didrocks | (and lucid -> precise doesn't have zg)

We don't support direct natty -> precise upgrades, so lowering severity a bit. Would still be nice to fix, of course.

Changed in zeitgeist (Ubuntu Quantal):
importance: Critical → High
Changed in zeitgeist (Ubuntu Precise):
importance: Critical → High
summary: - zeitgeist-daemon crashes with "zeitgeist-daemon.vala:473: Unable to
- upgrade from schema version 3"
+ [11.04->12.04 upgrade] zeitgeist-daemon crashes with "zeitgeist-
+ daemon.vala:473: Unable to upgrade from schema version 3"
summary: - [11.04->12.04 upgrade] zeitgeist-daemon crashes with "zeitgeist-
+ [11.04→12.04 upgrade] zeitgeist-daemon crashes with "zeitgeist-
daemon.vala:473: Unable to upgrade from schema version 3"
Revision history for this message
Didier Roche-Tolomelli (didrocks) wrote :

@kiko: you did upgrade from 11.04 to 12.04 directly? without upgrading to 11.10 first and rebooting? (this upgrade path is not support)

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.