the email program encountered a fatal error and will terminate now.
The error was:
Could not create collection trash resourceId: 3

this error shows every time I try to start the program and promptly closes, giving no opportunity to find or correct the error (probably a link to trash from an account.
I am set up with 5 different IMAP accounts.
all was working fine until today. I would prefer not to have to reinstall it after purging my settings as I have so many accounts and kmail is definitely not the easiest for setting them up. I would like to use kmail preferably because its native kde and integrates well.

KDE is version 4.12

Please open Akonadi Console, go to "DB Console" tab, execute the query below and paste it's output here (should be one row with four columns). Then we can try to figure out what's wrong

Code: Select all

SELECT CollectionTable.id, CollectionTable.name, CollectionTable.remoteId, ResourceTable.name FROM CollectionTable LEFT JOIN ResourceTable ON CollectionTable.resourceId = ResourceTable.id WHERE CollectionTable.resourceId = 3 AND CollectionTable.parentId IS NULL;

progdan wrote:Please open Akonadi Console, go to "DB Console" tab, execute the query below and paste it's output here (should be one row with four columns). Then we can try to figure out what's wrong

Code: Select all

SELECT CollectionTable.id, CollectionTable.name, CollectionTable.remoteId, ResourceTable.name FROM CollectionTable LEFT JOIN ResourceTable ON CollectionTable.resourceId = ResourceTable.id WHERE CollectionTable.resourceId = 3 AND CollectionTable.parentId IS NULL;

I got akonadi resources configuration, akonadi server configuration and that's about it.... don't know any akonadi console where do I find this?

There's a dedicated application called "Akonadi Console". You can execute it from terminal via akonadiconsole command. It's usually part of kdepim package, but maybe your distribution ships it in a separate package.

joshaughnessy wrote:

progdan wrote:Please open Akonadi Console, go to "DB Console" tab, execute the query below and paste it's output here (should be one row with four columns). Then we can try to figure out what's wrong

Code: Select all

SELECT CollectionTable.id, CollectionTable.name, CollectionTable.remoteId, ResourceTable.name FROM CollectionTable LEFT JOIN ResourceTable ON CollectionTable.resourceId = ResourceTable.id WHERE CollectionTable.resourceId = 3 AND CollectionTable.parentId IS NULL;

I got akonadi resources configuration, akonadi server configuration and that's about it.... don't know any akonadi console where do I find this?

OK I found the akonadiconsole, pasted the query in the DB console, hit enter and then:
nothing happened
when I open the akonadiconsole I get the following error

Failed to connect to database: Can't connect to local MySQL server through socket '/tmp/akonadi-root.dtP3l9/mysql.socket' (2) QMYSQL: Unable to connect

joshaughnessy wrote:

joshaughnessy wrote:

progdan wrote:Please open Akonadi Console, go to "DB Console" tab, execute the query below and paste it's output here (should be one row with four columns). Then we can try to figure out what's wrong

Code: Select all

SELECT CollectionTable.id, CollectionTable.name, CollectionTable.remoteId, ResourceTable.name FROM CollectionTable LEFT JOIN ResourceTable ON CollectionTable.resourceId = ResourceTable.id WHERE CollectionTable.resourceId = 3 AND CollectionTable.parentId IS NULL;

I got akonadi resources configuration, akonadi server configuration and that's about it.... don't know any akonadi console where do I find this?

OK I found the akonadiconsole, pasted the query in the DB console, hit enter and then:
nothing happened
when I open the akonadiconsole I get the following error

Failed to connect to database: Can't connect to local MySQL server through socket '/tmp/akonadi-root.dtP3l9/mysql.socket' (2) QMYSQL: Unable to connect

tried again executing the query and only got this:
akonadi_maildir_resource_0
then this:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CollectionTable.id, CollectionTable.name, CollectionTable.remoteId, ResourceTabl' at line 1 QMYSQL: Unable to execute query

This is very weird. If the query returns only the fourth column (akonadi_maildir_resource_0), then something is wrong with maildir resource ("Local Folders"). You can try in the first "Agents" tab to remove the "Local Folders" agent, then restart Akonadi and then start KMail. KMail will try to create it again on start.

progdan wrote:This is very weird. If the query returns only the fourth column (akonadi_maildir_resource_0), then something is wrong with maildir resource ("Local Folders"). You can try in the first "Agents" tab to remove the "Local Folders" agent, then restart Akonadi and then start KMail. KMail will try to create it again on start.

Weird indeed! god only knows how it got that way......
I removed the local folders agent. logged out and logged back in, started kontact and it all appears to work again as normal..

what happened?
I just quit and restarted again... Yes everything appears to be working fine and all the correct folders for each account are working, all 5 IMAP accounts and identities and outgoing mail too

Just to say thank you.

Deleting the 'local folders' account and then restarting worked for me also.

I think this problem came about because I had recently changed all my other email accounts 'trash' folders to be pointing to their own trash folder rather than the local folders trash folder.

Thanks again.
Barry

For me it was sufficient to remove the local trash folder:
rm -rf .local/share/local-mail/trash/

Kmail recreates it and everything's fine.

Thanks, deleting the 'local folders' agent in akonadi server, then restarting akonadi worked for me too, solve the problem.

In my case I renamed ~/.local/share/akonadi_maildir_resource_0/trash

bege78 wrote:For me it was sufficient to remove the local trash folder:
rm -rf .local/share/local-mail/trash/

Kmail recreates it and everything's fine.

I also did this to fix the issue. Also I got hit by this bug after pointing all trashes away from the local trash.

Is there a bug report on this already?

bege78 wrote:For me it was sufficient to remove the local trash folder:
rm -rf .local/share/local-mail/trash/

Kmail recreates it and everything's fine.

Hi, for me was not sufficient to delete '.local/share/local-mail/trash', instead the solution from progdan worked well -thanks-.

I also tried to renew attention to bugs
https://bugs.kde.org/show_bug.cgi?id=339214 ,
https://bugs.kde.org/show_bug.cgi?id=366388 and
https://bugs.kde.org/show_bug.cgi?id=362339
that are substantially equivalent but surprisingly yet in "unconfirmed" state.

This bug is particularly annoying because stops KMail immediately after execution and discourages non-skilled users, furthermore the workaround can not be readily found.

+1 to progdan's solution: viewtopic.php?t=120777#p308518

I also ran into this problem after changing all the other email accounts 'bin' folders to be pointing to their own trash folder rather than the Local Folders' wastebin folder.