database disk image is malformed

[POIRIER David]

Binary package hint: evolution

hello,

my system: ubuntu studio 9.04 64 bits
evolution
impossible to read and see all the mail in my box recpetion and in an other file.

ERROR MESSAGE :
error during the generation of the list of messages
database disk image is malformed

thanks for the answer

David

ProblemType: Bug
Architecture: amd64
DistroRelease: Ubuntu 9.04
ExecutablePath: /usr/bin/evolution
NonfreeKernelModules: nvidia
Package: evolution 2.26.1-0ubuntu1
ProcEnviron:
 LANG=fr_FR.UTF-8
 SHELL=/bin/bash
SourcePackage: evolution
Uname: Linux 2.6.28-3-rt x86_64

[runout (office-runout)]

this might be related to Bug 381144. i posted there the following:

May 28 13:50:11 XXXXX kernel: [ 4062.810791] evolution[23173]: segfault at 0 ip
00007fd19de5cfce sp 00007fd1831e3d48 error 4 in libc-2.9.so[7fd19ddd9000+168000]

also i get the message "error while generating message list" in the
status line on the bottom of the application window and on clicking the
message i get in a dialogbox: "database image is malformed".

i did not have this problem until 22.may (i did not read emails for some
days)

after reading/deleting some messages by hand (webmail) evolution stopped crashing but does not generate a message list for some of the imap folders

[yareckon (yareckon)]

I have the same issue on i386, also appeared in the last 2 weeks.

[runout (office-runout)]

i just found a workaround which caused my evolution to rebuild all the message lists after i deleted the folders.db of an account.
example:

rm ~/.evolution/mail/imap/XXXX@YYYYY@ZZZZZ/folders.db

[Sebastien Bacher (seb128)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. Please answer these questions:

 * Is this reproducible?
 * If so, what specific steps should we take to recreate this bug?

 This will help us to find and resolve the problem.

[runout (office-runout)]

maybe an option (menu) to create the folders.db from scratch would help.
or this could be offered if evolution comes up with this error message.

for me, this bug could have been caused by an update which did something with the database image but i do not have any ideas what it was.
or a poblem of the harddisk, unclean shutdown,...

[POIRIER David (poirier-david2)]

Hello,

for help you if you are, i'm french

i dont' no if tis bug is reproductible and when it exactly appears

sorry i'm simply user of ubuntu ,

if you want i send to you perhaps all files or all mail which are in my
recept box
or if you' r french and if you want go to my home to see evolution on my
pc it's possible for help you

i solved it after delete all files which names was Folders.db
in /home/my user/.evolution i make backup before.

now it's impossible to delete all mail which in trash (evolution) are.

i mean that i receveid a mail who's be spam ( no detec bogofilter) in my
recept box.

i suspect this mail to have make the first bug, so after i put it in the
trash
and now the second bug appears:

If you want i send you this mail, i can it

David 62700 FR

Le lundi 01 juin 2009 à 13:30 +0000, Sebastien Bacher a écrit :
> Thank you for taking the time to report this bug and helping to make Ubuntu better. Please answer these questions:
>
> * Is this reproducible?
> * If so, what specific steps should we take to recreate this bug?
>
> This will help us to find and resolve the problem.
>
> ** Changed in: evolution (Ubuntu)
> Importance: Undecided => Low
>
> ** Changed in: evolution (Ubuntu)
> Status: New => Incomplete
>
> ** Changed in: evolution (Ubuntu)
> Assignee: (unassigned) => Ubuntu Desktop Bugs (desktop-bugs)
>

[POIRIER David (poirier-david2)]

Hello,

for help you if you are, i'm french

i dont' no if tis bug is reproductible and when it exactly appears

sorry i'm simply user of ubuntu ,

if you want i send to you perhaps all files or all mail which are in my
recept box
or if you' r french and if you want go to my home to see evolution on my
pc it's possible for help you

i solved it after delete all files which names was Folders.db
in /home/my user/.evolution i make backup before.

now it's impossible to delete all mail which in trash (evolution) are.

i mean that i receveid a mail who's be spam ( no detec bogofilter) in my
recept box.

i suspect this mail to have make the first bug, so after i put it in the
trash
and now the second bug appears:

If you want i send you this mail, i can it

David 62700 FR

Le lundi 01 juin 2009 à 13:30 +0000, Sebastien Bacher a écrit :

> Thank you for taking the time to report this bug and helping to make Ubuntu better. Please answer these questions:
>
> * Is this reproducible?
> * If so, what specific steps should we take to recreate this bug?
>
> This will help us to find and resolve the problem.
>
> ** Changed in: evolution (Ubuntu)
> Importance: Undecided => Low
>
> ** Changed in: evolution (Ubuntu)
> Status: New => Incomplete
>
> ** Changed in: evolution (Ubuntu)
> Assignee: (unassigned) => Ubuntu Desktop Bugs (desktop-bugs)
>

[Sebastien Bacher (seb128)]

do you have an easy way to trigger the bug or an example?

[POIRIER David (poirier-david2)]

Hello,

for help you

evolution on my pc ubuntu studio 64 bits 9.04 low latence kernel

After i have install evolution

at the first time
i have restore an archive of evolution create under intrepid ibex studio
64 bits low latence kernel

  So when i was under studio intrepid i have make the same ( restore an
archive of intrepid ibex i386 32 bits ( i change my pc)

For explain you some of files and mails are coming from evolution
intrepid ibex i386

 i have 10 files (create ) in my recept box

It's difficult to remenber what's hapen when the bug appears.

if have recept an mail which was spam .( no detec by bogo filter)

i have this mail delete and after restore and put it in the files
pourriels ( badmail)

In this time i have some other mail put in other files and restore or
delete

David

Le jeudi 04 juin 2009 à 09:38 +0000, Sebastien Bacher a écrit :

> do you have an easy way to trigger the bug or an example?
>

[Valentin Neacsu (valentin.neacsu)]

This also happened to me and one of my colleagues. The steps to reproduce is to click one of the folders in your inbox (the same one always).

[Kow (kow)]

I just encountered this bug for the first time. I was doing a lot of disk read/writes on an ext4 fs which so happened to be the same fs with the evolution db. I'm not saying this is necessarily related to ext4.

[buster (ses-snoke)]

have this bug since tomorrow, too.
One IMAP folder can't be displayed, in the bottom it says "error while generating"
and "database image is malformed".
What i did? Nothing, was the first thing that happened when i opened evolution today.

[Nikolaj Sheller (nikolajsheller)]

I'm running on a standard Ubuntu 9.04 64 bit machine with ext4.

I've recently started to see problems with Evolution where listing a certain folder with mails generates the message:
"Error while Generating message list.

database disk image is malformed"

I currently have two folders that yield this message, and list none of the mails present in the folder (which is bad, since I want access to them)

I have used Evolution for 3-4 years now, and I have not seen this message before.
I am not using IMAP.

The cause of the error is unknown to me. SQLlite?

Running Evolution from a terminal does not provide any additional information.

[Nikolaj Sheller (nikolajsheller)]

It seems that Evolution uses SQLite databases.
I think it is odd that several people have seen this issue relatively recently on Evolution...
Perhaps the importance of this issue can be bumped?

[Nikolaj Sheller (nikolajsheller)]

Deleting folders.db and letting evolution rebuild mail lists,as described by runout in comment 4, worked for me.

[runout (office-runout)]

today i had this problem again and the workaround fixed it again.

maybe this time the problem was caused by a dying harddisk in my notebook.

[Olivier Berger (olivierberger)]

Maybe this can help exhibit which file is damaged :
 cd ~/.evolution/mail/ ; for i in `find . -name folders.db`; do echo "Rebuilding Table $i"; sqlite3 $i "pragma integrity_check;"; done

Just my 2 cents,

[Dan (daniel-myre-gmail)]

Here what I get with the commande from Olivier Berger #18 comment: Still not working after that..
------------------------------------------------------------------------------------
Rebuilding Table ./local/folders.db
*** in database main ***
Main freelist: freelist leaf count too big on page 4340
On tree page 4 cell 2: Child page depth differs
Page 3800: sqlite3BtreeInitPage() returns error code 11
On tree page 4 cell 5: Child page depth differs
On tree page 4 cell 6: Child page depth differs
On tree page 4 cell 8: Child page depth differs
On tree page 4287 cell 6: 2nd reference to page 4083
On tree page 4287 cell 6: Child page depth differs
On tree page 4287 cell 7: Child page depth differs
Page 58: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 38: Child page depth differs
On tree page 4287 cell 39: Child page depth differs
Page 487: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 41: Child page depth differs
Page 1372: sqlite3BtreeInitPage() returns error code 11
Page 4039: sqlite3BtreeInitPage() returns error code 11
Page 4198: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 45: Child page depth differs
Page 1355: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 46: Child page depth differs
Page 3405: sqlite3BtreeInitPage() returns error code 11
Page 3696: sqlite3BtreeInitPage() returns error code 11
Page 1646: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 50: Child page depth differs
Page 635: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 51: Child page depth differs
On tree page 4287 cell 52: Child page depth differs
Page 1890: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 55: Child page depth differs
Page 557: sqlite3BtreeInitPage() returns error code 11
Page 914: sqlite3BtreeInitPage() returns error code 11
Page 2783: sqlite3BtreeInitPage() returns error code 11
Page 1133: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 60: Child page depth differs
Page 1165: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 61: Child page depth differs
Page 274: sqlite3BtreeInitPage() returns error code 11
Page 3606: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 64: Child page depth differs
Page 406: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 67: Child page depth differs
Page 1555: sqlite3BtreeInitPage() returns error code 11
Page 3640: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 70: Child page depth differs
Page 1608: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 71: Child page depth differs
On tree page 4287 cell 72: Child page depth differs
Page 152: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 73: Child page depth differs
Page 1800: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 75: Child page depth differs
Page 1717: sqlite3BtreeInitPage() returns error code 11
On tree page 4287 cell 76: Child page depth differs
On tree page 3420 cell 3: 2nd reference to page 1717
On tree page 4287 cell 77: Child page depth differs
Page 1049: sq...

[Jason Wagner (jcw5002)]

I ran into this error after doing an unclean shutdown on my Thinkpad T400 running ubuntu 9.04. After restarting my machine, I was seeing errors in evolution and it was unable to load my inbox. The error was:

"Error while opening store spooldir://var/spool/mail -- database disk image is malformed."

To solve this problem, I closed Evolution and I ran the command from Olivier Berger in comment #18. After installing sqlite3, the command ran and told me that I had issues with my spool directory (duh). This helped me find the location of that folders.db file.

/home/jason/.evolution/mail/spooldir/var/spool/mail/folders.db

I first backed up this file to my desktop and then did a rm folders.db. After restarting Evolution a few times, my mail was back and everything works again.

Thanks!

[sbasurto (sbasurtoj)]

I read the evolution faq for the question
     Why do I get an error "Summary and folder mismatch, even after a sync"?
also I recieved the message
    database disk image is malformed

But I delete all .ibex.index files but it does not work, the problem stills until I also did what runout wrote.

The work around for me was
stop evolution
evolution --force.shutdown
and
delete ibex.index files plus folders.db under directory ~/.evolution/mail/local/
restart evolution

And now I am happily working again without problems.

I hope this helps.

Regards

[sbasurto (sbasurtoj)]

Sorry the I mispell the command is not
evolution --force.shutdown
the correct one is
evolution --force-shutdown

Regards

[Dario Panico (dariopnc-)]

this happened to me too, when I was using ext4 it was way more frequent.
Now that I'm using ext3, it happened again.
I removed all ibex.index files and folders.db in ~/.evolution/mail/local and the index was rebuilt and evolution now goes fine.
I made an evolution backup when my evolution was broken, maybe it could contain some useful infos about how to reproduce the bug. Tell me..

[Adrian A. Biondi (adrian-biondi)]

As Dario Panico, I removed all ibex.index files and folders.db in ~/.evolution/mail/local and the index was rebuilt and evolution now goes fine.

Thank you a lot for your shared experience.

[Duncan McGreggor (oubiwann)]

I'm running Xubuntu in a VM. I'd installed Xubuntu Lucid from an ISO a few days ago; today I upgraded to Maverick, and I got this error on one of 5 IMAP accounts which I managed in Evolution. Evolution was running perfectly (better than it ever has, in fact) prior to the upgrade. After the upgrade, however, it is slow, crashes randomly, and gives me various alerts about folder refreshes, listings, and saves -- all of which end up being the same error message: database disk image is malformed.

To work around this problem, I did the following:
 * put evolution into off-line mode
 * quit evolution
 * removed the folders.db file in the offending IMAP directory in ~/.evolution/mail/imap
 * started evolution
 * put evolution back into on-line mode
 * clicked on the folders of the offending IMAP account that hadn't been displaying the messages

At that point, I was able to see all the messages in my various folders and no longer got the alerts and error messages about malformed disk images.

I agree with other users that have made similar comments: if the root cause for this cannot be discovered, it would be very good for Evolution to provide a nice quick UI-accessible means of purging and rebuilding corrupt database files.

[Omer Akram (om26er)]

seems it was marked fix committed mistakenly

[Pedro Villavicencio (pedro)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. The issue that you reported is one that should be reproducible with the live environment of the Desktop CD of the development release - Oneiric Ocelot. It would help us greatly if you could test with it so we can work on getting it fixed in the next release of Ubuntu. You can find out more about the development release at http://www.ubuntu.com/testing/ . Thanks again and we appreciate your help.

[Launchpad Janitor (janitor)]

[Expired for evolution (Ubuntu) because there has been no activity for 60 days.]

[auric (cm-nd31)]

Solved: I didn't have to use the command line or remove any ibex.index files. I was able to fix it by using the GUI. I use Evolution as an imap client.

Steps:
Close Evolution
Click the "Places" menu item and select "Home Folder"
Click the "View" menu item and select "Show Hidden Files."
Open the "imap" folder located under .evolution/mail.
Locate and open the folder for the mail account having the problem and delete the "folders.db" file inside of it. (Screenprint: http://ubuntuone.com/2GJY8lJulShlCCzZkDnNK0)
Start Evolution application
The "folders.db" file will be automatically re-generated.
Error message gone.

Ubuntu Release 10.04 (lucid)
Kernel Linux 2.6.32-35-generic
GNOME 2.30.2

[Barbara Lanthier (bblanthier)]

In my evolution mail program I keep getting the message "database disk image is malformed" or "rebuilding messages" in many of my mail folders. How can I stop these messages. Every time I want to delete a message from my inbox the database message keeps coming up and I have to actually close the program to get rid of the messages. Help. Thank you.