Bug 339214

I got the same error while trying to configure KConfig/KMail. I have 4 IMAP accounts, of which 2 have a large number of messages, one which a small number of folders and the other with quite a lot of folders. Initially things went OK, but during retrieval of the message, the network connection went down or was not performing very well, so before retrieving all messages, KMail was stopped. Restarting it now gives the mentioned message and pressing OK ends Kontact/Kmail. So I am stuck. Starting KMail in a konsole gives the added attachment.

Created attachment 89134 [details]
output from "kmail >kmailoutput.txt 2>&1"

output from "kmail >kmailoutput.txt 2>&1" blocks of 18 lines which are equal are removed

Testing Utopic (Kubuntu) Live session and got this error window. Unfortunately, I cannot reproduce -- restarting kontact works and the trash folder is there.

I found a solution: remove folder ~/.local/share/local-mail/trash/
Solved my problem. There are more elaborated solutions when you google for the error message.

(In reply to Freek de Kruijf from comment #4)
> I found a solution: remove folder ~/.local/share/local-mail/trash/

I confirm, this workaround works.

*** Bug 345399 has been marked as a duplicate of this bug. ***

(In reply to Freek de Kruijf from comment #4)
> I found a solution: remove folder ~/.local/share/local-mail/trash/
> Solved my problem. There are more elaborated solutions when you google for
> the error message.

Unfortunately this didn't work for me. I had to start 'akonadiconsole', remove the 'Local Folder' agent from the agent's list and then click on the 'Restart' button.

After that it was possible to restart KMail that worked normally.

I achieved that only after a considerably amount of time searching the Internet for a solution ( https://forum.kde.org/viewtopic.php?f=215&t=120777&hilit=trash ) and I'm a good skilled Linux user.

This bug SHOULD be taken into proper consideration since it is not resolved from a long time and causes problems to users. We cannot expect normal users to browse through bug reports in order to be able to use their software, and this bug is a show stopper since it prevents people from starting the software.

*** Bug 362339 has been marked as a duplicate of this bug. ***

*** Bug 366388 has been marked as a duplicate of this bug. ***

*** Bug 350841 has been marked as a duplicate of this bug. ***

*** Bug 351213 has been marked as a duplicate of this bug. ***

*** Bug 345895 has been marked as a duplicate of this bug. ***

*** Bug 354804 has been marked as a duplicate of this bug. ***

*** Bug 358650 has been marked as a duplicate of this bug. ***

*** Bug 359461 has been marked as a duplicate of this bug. ***

*** Bug 349085 has been marked as a duplicate of this bug. ***

*** Bug 358145 has been marked as a duplicate of this bug. ***

createDefaultCollectionDone() calls emergencyExit() on any error, causing a crash because of unexpected destroying of global objects.

Relevant part of the backtrace:

Thread 1 (Thread 0x7f7d948587c0 (LWP 3548)):
[KCrash Handler]
#15 0x00007f7d913f1b39 in __run_exit_handlers () at /lib64/libc.so.6
#16 0x00007f7d913f1b85 in  () at /lib64/libc.so.6
#17 0x00007f7d19436063 in MailCommon::Kernel::emergencyExit(QString const&) () at /usr/lib64/libKF5MailCommon.so.5
#18 0x00007f7d1943664a in MailCommon::Kernel::createDefaultCollectionDone(KJob*) () at /usr/lib64/libKF5MailCommon.so.5
#19 0x00007f7d91fb373f in QMetaObject::activate(QObject*, int, int, void**) () at /usr/lib64/libQt5Core.so.5
#20 0x00007f7d936135e2 in KJob::result(KJob*, KJob::QPrivateSignal) () at /usr/lib64/libKF5CoreAddons.so.5
#21 0x00007f7d93613e4f in KJob::finishJob(bool) () at /usr/lib64/libKF5CoreAddons.so.5
#22 0x00007f7d90ab8bce in  () at /usr/lib64/libKF5AkonadiCore.so.5
#23 0x00007f7d90abba28 in  () at /usr/lib64/libKF5AkonadiCore.so.5

Confirmed by "popular reporting". It was reported for 5.1.3 in Bug 362339.

I've 12 imap account each setup to move deleted message to their own trash folder.

Long ago, I was getting crash and background running kmail. To by pass this problem I've used the setting to not empty trash folder on exit, and after kmail never crashed again on exit.

Recently the trash folder to remove is no longer ~/.local/share/local-mail/trash/ but ~/.local/share/akonadi_maildir_resource_0/trash/
You can also set it aside.

(In reply to Freek de Kruijf from comment #21)
> Recently the trash folder to remove is no longer
> ~/.local/share/local-mail/trash/ but
> ~/.local/share/akonadi_maildir_resource_0/trash/
> You can also set it aside.

Thanks for the update.

I ran into this situation again this morning (I have not restart/shutdown my laptop for a long time). The kmail is recovered after I followed the instruction in Comment #7 "to start 'akonadiconsole', remove the 'Local Folder' agent from the agent's list and then click on the 'Restart' button".

I have not tried to remove the folder `~/.local/share/akonadi_maildir_resource_0/trash/`.

This still happens on KMail 5.10.2 / Frameworks 5.55.0

Hi, look likes https://forum.kde.org/viewtopic.php?t=120777

cd ~/.kde/share/apps/kmail/mail

and remove trash folder for example with :

mv trash/ ~

This still happens in kmail 5.11.3, KDE Frameworks 5.64.0.

Deleting the local folder agent in aconadiconsole solves the problem.

Just ran into this again using:
* KMail 5.13.3 (19.12.3)
* KDE Frameworks 5.67.0
* Qt 5.14.1 (built against 5.14.1)

This bug is still alive and kicking. Happens reliably every time when creating a mailbox and changing its trash folder from the local folders one to the account's IMAP folder.

Same problem here. I believe this Akonadi log lines have to do something with it:

org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '6-trash' for key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '6-trash' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, ""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11", QVariant(int, -1))(":12", QVariant(bool, false))(":13", QVariant(QString, ""))(":14", QVariant(bool, false))(":2", QVariant(QString, "trash"))(":3", QVariant(qlonglong, 6))(":4", QVariant(qlonglong, 4))(":5", QVariant(bool, true))(":6", QVariant(int, 2))(":7", QVariant(int, 2))(":8", QVariant(int, 2))(":9", QVariant(bool, true)))
org.kde.pim.akonadiserver:   Query: "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, enabled, syncPref, displayPref, indexPref, cachePolicyInherit, cachePolicyCheckInterval, cachePolicyCacheTimeout, cachePolicySyncOnDemand, cachePolicyLocalParts, isVirtual) VALUES (:0, :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14)"
org.kde.pim.akonadiserver: Error during insertion into table "CollectionTable" "Duplicate entry '6-trash'

have you tried solution on https://bugs.kde.org/show_bug.cgi?id=339214#c24 ?

(In reply to Sérgio Basto from comment #29)
> have you tried solution on https://bugs.kde.org/show_bug.cgi?id=339214#c24 ?

That's not a solution, that's a workaround at best.

Created attachment 136981 [details]
Crash log

Hi, I got the same problem. For me the solution of CnZhx  2017-12-01 11:02:44 UTC worked: "start 'akonadiconsole', remove the 'Local Folder' agent from the agent's list"

Please change this misleading error message. Especially I hate alert-messages with only one "accept"-button and modal windows in general. If there's a broken e-mail account kmail2 should start anyway complaining later. Nobody understands why a "collection trash" is that important the program doesn't starts at all.

Instead of akonadiconsole kmail2 should cure this problem from within.

I have just run into this bug just by pointing my trashes off the local trash to respective IMAP located trash folders.
There are many people affected, several bug duplicates, and the status is still only "REPORTED" ... since 2014?

My Akonadi suddenly (no config changes) developed the same issue. KMail refuses to start because of "Could not create collection 'drafts'". The issue appears to be that the "drafts" collection had the "SpecialCollectionAttribute" set to "trash", with a matching icon, while "trash" also had that. As it couldn't find a proper "drafts" collection it tried to create "drafts" again. Using akonadiconsole I could fix the "SpecialCollectionAttribute" of the collection and KMail works for me again. Question is why the attribute changed.

Can reproduce on my machine, with a fresh new user profile, and KMail configured with one IMAP profile (which worked the first time).
"Could not create collection drafts, resourceId 4"
KMail 5.20.3 (22.04.3)
Akonadi 22.04.3
MariaDB 10.5.10
KF 5.96.0
Qt 5.15.5
Void Linux

check my comment #24 https://bugs.kde.org/show_bug.cgi?id=339214#c24

I added a new IMAP account and also added the trash folder to IMAP-account/trash. Since than I received 
"Could not create collection trash, resourceId 4"

Also at my side on removing of "~/.local/share/local-mail/trash/" fixes the issue

kmail -v
kmail2 5.21.1 (22.08.1)

Operating System: openSUSE Tumbleweed 20220930
KDE Plasma Version: 5.25.5
KDE Frameworks Version: 5.98.0
Qt Version: 5.15.6
Kernel Version: 5.19.12-1-default (64-bit)
Graphics Platform: X11

Is anyone interested in baking a cake or throwing a party for this bug's upcoming 9th or 10th birthday? It spent its entire life without a caretaker, and I am sure it would enjoy spending some time with friendly people.

(In reply to Daniel Ziltener from comment #38)
> Is anyone interested in baking a cake or throwing a party for this bug's
> upcoming 9th or 10th birthday? It spent its entire life without a caretaker,
> and I am sure it would enjoy spending some time with friendly people.

🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

I'm very so sorry, but I suspect kmail doesn't have developers that love it.
Not only are there bugs like this, but also untreated regressions like delivery confirmation request. ;-(

(In reply to Freek de Kruijf from comment #21)
> Recently the trash folder to remove is no longer
> ~/.local/share/local-mail/trash/ but
> ~/.local/share/akonadi_maildir_resource_0/trash/
> You can also set it aside.

You have saved my day! 

I have just started to change from Windows to Linux (Nobara Linux = Fedora with With KDE Plasma and optimizations for Gaming).
I have about 30 Years IT experience with Windows and I am a professional software developer writing applications in c#. So it might be a big step to switch the operating system on my private PC. 

The first steps with KMail are not easy. I wonder why everything was working on local folders and it took some time to sent my first e-mail from kmail into the world. So I made the set up with 3 IMAP Accounts and the last part to do was to configure kmail to put the deleted e-Mails into the IMAP Trash bucket. I don't want to handle all deleted e-mails in the local Trash folder.

And what happens next... Yes Kmail crashed on start up with a message I don't understand: 
"Could not create collection trash resourceId: 14"

Can you imagine how frustrating such an experience is? Searching for this error shows a lot of tipps but renaming or deleting the local trash folder was not helpful because I didn't know that it was moved into "akonadi_maildir_resource_4". This information was part of this Bug report and it is not nice to read about the 10th aniversary of this bug.

Changing the configuration from local Trash to IMAP Trash is not an unusual use case. So this should not happen. The normal user is lost if the mail system breaks down because of this error. 

After removing the trash folder in "~\.local\share\akonadi_maildir_resource_4\" kmail is starting again. 

I hope somebody could take a look on this issue. I am not ready to do this now. I need some time to learn more about the kde system, before I can change the code.

Kind regards 
Christof