Re: [Evolution] Unable to retrieve message

[Patrick O'Callaghan <poc usb ve>]

On Fri, 2009-11-06 at 23:56 +0100, Felix Koop wrote:
> On Fri, 2009-11-06 at 17:44 -0430, Patrick O'Callaghan wrote:
> > On Fri, 2009-11-06 at 22:36 +0100, Felix Koop wrote:
> > > Hello,
> > >
> > > I have one message in the listing of messages in my Inbox that I cannot
> > > get to or delete. If I try to open that message, I get the error:
> > >
> > > Unable to retrieve message
> > > Cannot get message 134185 from folder /..../.evolution/mail/local/Inbox
> > > No such message
> > >
> > > How can I get rid of this dead message? 
> >
> > Sounds like a broken index. See an earlier thread from yesterday and
> > today on how to fix this.
> >
> > poc
>
> Thanks Patrick, but deleting all index files didn't help. The message in
> question is still there.

You could try vacuuming the SQL database files (shutting down Evo first
of course):

#!/bin/sh

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

If that doesn't work, I'm out of ideas.

poc