Tuesday, September 29, 2009

Error While Generating message list

Evolution simply fsck me yesterday morning.
Had to re-generate the DBs in order to continue using... Have to say that this was a first for me, even tho Tango had quite a few lockups, specially when it was running EXT 4, never had any issue with Evolution after a crash. But, yesterday out of the blue, and after a night open receiving emails, something I do all the time with Tango, it crapped on me.

After a minute or so Googling, found the answer:

Evolution unable to generate folder list


This is what I did:

sudo aptitude install sqlite3

Execute this:

cd ~/.evolution/mail ; for i in `find . -name folders.db`; do echo "Rebuilding Table $i"; sqlite3 $i "pragma integrity_check;"; done

Spitted this:

tango:~$ cd ~/.evolution/mail ; for i in `find . -name folders.db`; do echo "Rebuilding Table $i"; sqlite3 $i "pragma integrity_check;"; done
Rebuilding Table ./imap/whatever@xxxx.xxxxx.xxx/folders.db
*** in database main ***
Page 26986 is never used
Page 26988 is never used
Page 27311 is never used
Page 27336 is never used
Page 27375 is never used
Page 27382 is never used
Page 27400 is never used
Page 27480 is never used
SQL error: database disk image is malformed
Rebuilding Table ./local/folders.db
ok
Rebuilding Table ./vfolder/folders.db
ok
tango:~/.evolution/mail$

After that:

tango:~/.evolution/mail$ killall evolution-alarm-notify evolution-data-server-2.26

And then deleted:

rm ./imap/whatever@xxxx.xxxxx.xxx/folders.db

Problem gone... Downloaded my emails form the IMAP server, and everything was kosher once again with me and my Evolution.

Labels: , , , , , ,

4 Comments:

Anonymous Anonymous said...

This comment has been removed by a blog administrator.

3:10 PM  
Anonymous johannes said...

thanks man!

this fixed the same problem for me in ext4 ubuntu9.10 system w/ evolution2.28

cheers!!!

3:17 AM  
Blogger hictio said...

I'm glad it was useful ;)

9:56 AM  
Anonymous Anonymous said...

This comment has been removed by a blog administrator.

7:51 PM  

Post a Comment

<< Home