[kmail2] [Bug 339214] Starting KMail gives message "Could not create collection trash resourceId: 3 [MailCommon::Kernel::createDefaultCollectionDone, MailCommon::Kernel::emergencyExit]

[Knut Hildebrandt]

https://bugs.kde.org/show_bug.cgi?id=339214

--- Comment #49 from Knut Hildebrandt <post at knut-hildebrandt.de> ---
(In reply to Fabian Vogt from comment #48)
> Resetting state to REPORTED, this clearly was not fixed.
> 
> (In reply to Knut Hildebrandt from comment #47)
> > (In reply to Fabian Vogt from comment #44)
> > > Here's how to manually fix the weirdness in the database without folder
> > > remaining:
> > > 
> > > 1. Start akonadiconsole
> > > 2. In the browser tab, right click on "Local Folders" -> "Trash"
> > > 3. Open the Folder properties window
> > > 4. In the "Attributes" tab, make sure it has "SpecialCollectionAttribute"
> > > set to "trash". If necessary, change or create it.
> > > 5. Start kmail again
> > > 
> > > This also applies if the error message is about drafts or other special
> > > folder, just set the attribute on the matching folder instead.
> > 
> > Today I ran into that problem again, but can't solve it by either deleting
> > the trash folder or following what these instructions. Thus I'm not sure, if
> > it is caused by the same bug. 
> > 
> > Two things I did today. In an IMAP-Account I had set deleting trash after
> > two weeks. I had done this before a while, but it was unset. And I upgraded
> > the system and thus Kmail from 24.05.2 to 24.08.1 today.
> > 
> > BTW, when I set SpecialCollectionAttribute it is not persistent. After
> > closing and reopening Akonadoconsole the had disappeared.
> 
> That's probably the issue, it needs to be properly saved. Any warnings or
> errors in the journal?

Well, after starting Kmail - actually Kontact - I found this in Akonadi.error:

[CRITICAL] org.kde.pim.akonadiserver: DATABASE ERROR:
[CRITICAL] org.kde.pim.akonadiserver:   Error code: "1062"
[CRITICAL] org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '6-trash'
for key 'CollectionTable_parentAndNameIndex'"
[CRITICAL] org.kde.pim.akonadiserver:   Error text: "Duplicate entry '6-trash'
for key 'CollectionTable_parentAndNameIndex' QMYSQL: Der Befehl konnte nicht
ausgeführt werden"

That suggested that something with the database was wrong, thus I stopped
Akonadi and renamed it. After restarting Akonadi the database was rebuild and I
could start Kmail - actually Kontact - with the drawback, that all my settings
were lost ;-( Since this is unaccaptable I got back to the old database looking
for another solution. Any idea? A suggestion how to fix the database?

-- 
You are receiving this mail because:
You are the assignee for the bug.