[Evolution] Bug#519206: Bug#519206: evolution: Inbox mail is all gone with sqlite transition

Paul Menzel pm.debian at googlemail.com
Wed Mar 11 10:21:32 UTC 2009


Dear everyone,


I reply to my own mail. Sorry for breaking the flow.


Am Mittwoch, den 11.03.2009, 09:19 +0100 schrieb Paul Menzel:

> Am Mittwoch, den 11.03.2009, 07:33 +0100 schrieb Yves-Alexis Perez:
> > On mar, 2009-03-10 at 19:17 -0400, José Alburquerque wrote:
> > > Very bad what's happening.  I recently imported all my folders from
> > > icedove to evolution (removing old ones to save disk space).  After
> > > today's upgrade, evolution mentioned that it migrated folders to sqlite.
> > > I don't know if it went well, but all of the mail in my Inbox (years of
> > > mail) is no longer visible in the Inbox folder.  I'm hoping that it's a
> > > bug and the mails are there, but I'm terrified because the size of the
> > > mbox Inbox file in .evolution/mail/local is zero.  Someone please tell
> > > me that my mail is sitll available!
> > 
> > Maybe first try evolution --force-shutdown and re-run evolution, just to
> > be sure.
> 
> This is what helped me.
> 
> I had Evolution running while it was being upgraded. Working with it it
> crashed. (Since it did not find the files, which had been deleted during
> the upgrade.) 
> 
>         (evolution:4057): Bonobo-WARNING **: Can't find '/usr/share/evolution/2.22/ui/evolution-calendar.xml' to load ui from
>         
>         (evolution:4057): Bonobo-WARNING **: Can't find '/usr/lib/evolution/2.22/plugins/org-gnome-exchange-cal-subscription.xml' to load ui from
>         
>         (evolution:4057): Bonobo-WARNING **: Can't find '/usr/lib/evolution/2.22/plugins/org-gnome-folder-permissions.xml' to load ui from
>         
>         (evolution:4057): Bonobo-WARNING **: Can't find '/usr/lib/evolution/2.22/plugins/org-gnome-publish-calendar.xml' to load ui from
>         
>         (evolution:4057): Bonobo-WARNING **: Can't find '/usr/share/evolution/2.22/ui/evolution-editor.xml' to load ui from
>         
>         (evolution:4057): Bonobo-WARNING **: Can't find '/usr/share/evolution/2.22/ui/evolution-event-editor.xml' to load ui from
>         
>         (evolution:4057): libglade-WARNING **: could not find glade file '/usr/share/evolution/2.22/glade/event-page.glade'
>         calendar-gui-Message: event_page_construct(): Could not load the Glade XML file!
>         
>         (evolution:4057): Gtk-WARNING **: A floating object was finalized. This means that someone
>         called g_object_unref() on an object that had only a floating
>         reference; the initial floating reference is not owned by anyone
>         and must be removed with g_object_ref_sink().
>         
>         (evolution:4057): GLib-GObject-CRITICAL **: g_object_ref_sink: assertion `G_IS_OBJECT (object)' failed
>         
>         (evolution:4057): calendar-gui-CRITICAL **: comp_editor_append_page: assertion `page != NULL' failed
>         
>         (evolution:4057): GLib-GObject-WARNING **: invalid (NULL) pointer instance
>         
>         (evolution:4057): GLib-GObject-CRITICAL **: g_signal_connect_data: assertion `G_TYPE_CHECK_INSTANCE (instance)' failed
>         
>         (evolution:4057): libglade-WARNING **: could not find glade file '/usr/share/evolution/2.22/glade/recurrence-page.glade'
>         calendar-gui-Message: recurrence_page_construct(): Could not load the Glade XML file!
>         Cannot access memory at address 0x61422072
>         /home/x/4057: No such file or directory.
>         No stack.
>         /usr/share/bug-buddy/gdb-cmd:3: Error in sourced command file:
>         No registers.
> 
> 
> Simply restarting evolution also did not show my old e-mail (only POP,
> IMAP mails were displayed correctly).
> 
>         $ evolution &
>         [2] 22030
>         $
>         (evolution:22030): camel-WARNING **: camel_exception_get_id called with NULL parameter.
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         em-migrate.c:3012:migrate_to_db: failed to get folder infos 
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Alle Nachrichten
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Entwürfe
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Gesendet
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Markiert
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Papierkorb
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Spam
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/hal
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Drafts
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Saved Mail
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: SavedIMs
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Sent
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Spam
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Trash
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: VOICEMAIL
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Drafts
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Saved Mail
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Sent
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Spam
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Trash
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: VOICEMAIL
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Drafts
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Saved Mail
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Sent
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Spam
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Trash
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: VOICEMAIL
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Drafts
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Sent
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Trash
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Alle Nachrichten
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Entwürfe
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Gesendet
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Markiert
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Papierkorb
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: [Google Mail]/Spam
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): Gtk-CRITICAL **: gtk_progress_set_percentage: assertion `percentage >= 0 && percentage <= 1.0' failed
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Aufgaben
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Entwürfe
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Gelöschte Objekte
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Gesendete Objekte
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: INBOX
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Journal
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Junk-E-Mail
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Kalender
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Kontakte
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Notizen
>         
>         
>         (evolution:22030): camel-imap-provider-WARNING **: Unable to load summary no such table: Postausgang
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         
>         (evolution:22030): camel-WARNING **: No summary path set. Unable to migrate
>         
>         addressbook_migrate (2.22.0)
>         
> Looking at those error messages, it seems they are only thrown for IMAP boxes.
> 
> Then I quit Evolution and did evolution --force-shutdown and all old
> messages were there. But wanting to read messages in the folder, which
> was being selected before Evolution crashed, they are not displayed. It
> says, the Inbox (path) seems to be destroyed irreparable (just
> translated to Englisch from German). Wanting to copy the message string
> no messages are displayed in the folder (again) although it shows unread
> messages.

Ok, it also happened to a second folder. To clarify these are real
folder were message get moved to by a filter. But other folders work ok.

So the folders are empty but next to the folder name in brackets the
number of unread messages is noted. If a new message filtered/moved to
this folder is received the message and all the messages (sender,
subject, date) which had been in that folder before are shown.

The content of the new message is displayed alright but selecting
another one, shows

Nachricht 12030 konnte nicht aus
Ordner /home/x/.evolution/mail/local/Inbox.sbd/xorg abgerufen werden
Nachricht existiert nicht

Translation: Message 12030 could not be retrieved from folder …. Message
does not exist.

$ du ~/.evolution/mail/local/Inbox.sbd/xorg
12	.evolution/mail/local/Inbox.sbd/xorg

Looking at the file, there are only two messages in there, although
there should be over 400. :(

If I delete the newly received message or select one of the old messages
the overview is updated and only those two are shown.

So it looks like they are gone for good. :( If anyone finds a solution
to get the messages back (without backup :)) or a reason how those mbox
files could have been deleted, that would be nice.

> I do not know why this has not yet been reported or fixed upstream. That
> really scares someone to death, thinking all his/her mail is gone.
> 
> So I request two things.
> 
> 1. A user should be forced to quit Evolution while it is being updated.
> 2. It should be made 100 % sure, that no mail can be lost during this
> process. Even those warnings should disappear, having been checked for
> example if they are IMAP boxes (if my assumption is true). And the user
> user should be given an option before the transition to SQLite to make a
> backup of her/his data.

The NEWS.Debian you wrote about in your other reply file should mention
this as soon as possible. Even better, put in a break in the upgrade
process displaying a big fat warning to give users not reading
NEWS.Debian before or not taking this seriously a chance to make a
backup.

Thanks,

Paul
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Dies ist ein digital signierter Nachrichtenteil
Url : http://lists.alioth.debian.org/pipermail/pkg-evolution-maintainers/attachments/20090311/e0d66653/attachment-0001.pgp 


More information about the Pkg-evolution-maintainers mailing list