https://bugs.kde.org/show_bug.cgi?id=371570
Bug ID: 371570
Summary: Duplicate entry in CollectionTable when creating
database in a new installation
Product: Akonadi
Version: 5.3.0
Platform: Other
OS: Linux
Status: UNCONFIRMED
Severity: crash
Priority: NOR
Component: server
Assignee: kdepim-b...@kde.org
Reporter: larr...@kde.org
On a clean openSUSE Leap 42.2 RC1 system (with kmail 5.3.0 and akonadi-server
16.08.2), I run kmail for the first time. It shows a "Starting Akonadi server"
message for some seconds, then a dialog appears to "Provide personal data"
(full name, email and password), and practically at the same time I get an
error box from kmail that says:
"The Email program encountered a fatal error and will terminate now.
The error was:
Could not create collection inbox, resourceId: 3"
I ran kmail with full logs as dvratil suggested and got the attached output.
That gave lots of information, and the directed to the real problem:
----
log_akonadiserver: DATABASE ERROR:
log_akonadiserver: Error code: 1062
log_akonadiserver: DB error: "Duplicate entry '4-inbox' for key
'CollectionTable_parentAndNameIndex'"
log_akonadiserver: Error text: "Duplicate entry '4-inbox' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
log_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)"
log_akonadiserver: Error during insertion into table "CollectionTable"
"Duplicate entry '4-inbox' for key 'CollectionTable_parentAndNameIndex'
QMYSQL3: Unable to execute statement"
log_akonadicore: Failed SpecialCollectionsRequestJob::slotResult "Could not
create collection inbox, resourceId: 3"
log_mailcommon: "The Email program encountered a fatal error and will terminate
now.\nThe error was:\nCould not create collection inbox, resourceId: 3"
----
I can reproduce the problem every time, by removing the config files for the
user and starting kmail again. Btw, note that if instead of starting kmail, I
run akonadictl start and then kmail once akonadi is started, then there's no
problem.
Reproducible: Always
--
You are receiving this mail because:
You are watching all bug changes.
