[Akonadi] [Bug 371570] New: Duplicate entry in CollectionTable when creating database in a new installation

[Antonio Larrosa via KDE Bugzilla]

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-bugs at kde.org
          Reporter: larrosa at 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 the assignee for the bug.