Bug 417663 - No Mails of Office 365 account accessible because of DB CollectionTable Insert error: "Duplicate entry"
Summary: No Mails of Office 365 account accessible because of DB CollectionTable Inser...
Status: REPORTED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: EWS Resource (show other bugs)
Version: unspecified
Platform: Kubuntu Linux
: NOR major
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-14 19:51 UTC by dev
Modified: 2020-08-23 09:38 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description dev 2020-02-14 19:51:18 UTC
SUMMARY


STEPS TO REPRODUCE
1. Setup an EWS resources with an Office 365 Account (user/password auth)
2. Workaround the password not saved in KWallet bug

OBSERVED RESULT
* The EWS resources shows as "Bereit" (ready in englisch?)
* No Mail, contacts and calender root nodes are visible in Kmail/Contacts/Korganizer
* This makes the connector completely unusable for me :'(

EXPECTED RESULT
* The EWS resources shows as "Bereit" (ready in englisch?)
* Mails, contacts and calendar entries are visible.

SOFTWARE/OS VERSIONS
Linux/KDE Plasma: Kubuntu focal
(available in About System)
KDE Plasma Version: 
KDE Frameworks Version: 5.67.0
Qt Version: 5.12.5

ADDITIONAL INFORMATION
Synchronize All /Synchronize Collection Tree doesn't help. It produces the exception log below.

The following is in the Logs. I've censored some IDs and keys where I don't know if they contain sensitive data. If they are expected to be the same between log statements they probably where but no longer are.


org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "CreateHierarchy>true</t:CreateHierarchy><t:Delete>true</t:Delete><t:Modify>true</t:Modify><t:Read>true</t:Read></t:EffectiveRights><t:UnreadCount>0</t:UnreadCount></t:Folder></t:Create><t:Create><t:Folder><t:FolderId Id=\"LONGLONGLONGLONGLONGLLONGLONGLOLONGLONGID\" ChangeKey=\"SOMESOMESOMESOMESOME+KEY"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "\"/><t:ParentFolderId Id=\"LONGLONGLONGLONGLONGLLONGLONGLOLONGLONGID\" ChangeKey=\"AQAAAA==\"/><t:DisplayName>Inbound</t:DisplayName><t:TotalCount>0</t:TotalCount><t:ChildFolderCount>0</t:ChildFolderCount><t:ExtendedProperty><t:ExtendedFieldURI PropertyTag=\"0x3613\" PropertyType=\"String\"/><t:Value>IPF</t:Value></t:ExtendedProperty><t:EffectiveRights><t:CreateAssociated>true</t:Create"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "Associated><t:CreateContents>true</t:"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "CreateContents><t:CreateHierarchy>true</t:CreateHierarchy><t:Delete>true</t:Delete><t:Modify>true</t:Modify><t:Read>true</t:Read></t:EffectiveRights><t:UnreadCount>0</t:UnreadCount></t:Folder></t:Create><t:Create><t:Folder><t:FolderId Id=\"LONGLONGLONGLONGLONGLLONGLONGLOLONGLONGID\" ChangeKey=\"SOMESOMESOMESOMESOME+KEY"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "\"/><t:ParentFolderId Id=\"LONGLONGLONGLONGLONGLLONGLONGLOLONGLONGID\" ChangeKey=\"AQAAAA==\"/><t:DisplayName>Outbound</t:DisplayName><t:TotalCount>0</t:TotalCount><t:ChildFolderCount>0</t:ChildFolderCount><t:ExtendedProperty><t:ExtendedFieldURI PropertyTag=\"0x3613\" PropertyType=\"String\"/><t:Value>IPF</t:Value></t:ExtendedProperty><t:EffectiveRights><t:CreateAssociated"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) ">true</t:CreateAssociated><t:CreateContents>true</t:CreateContents><t:CreateHierarchy>true</t:CreateHierarchy><t:Delete>true</t:Delete><t:Modify>true</t:Modify><t:Read>true</t:Read></t:EffectiveRights><t:UnreadCount>0</t:UnreadCount></t:Folder></t:Create></m:Changes></m:SyncFolderHierarchyResponseMessage></m:ResponseMessage"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "s></m:SyncFolderHierarchyResponse></s:Body></s:Envel"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) "ope>"
org.kde.pim.ews.client.proto: data KIO::TransferJob(0x55847e8d8ec0) ""
org.kde.pim.ews.client.proto: response dumped to "/tmp/akonadi-ews-DWrjdtB/ews_xmldump_plJvoxu.xml"
org.kde.pim.ews.client.request: Got SyncFolderHierarchy response (48 changes, state: 179gnms)
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '385-Aufgezeichnete Unterhaltungen' for key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '385-Aufgezeichnete Unterhaltungen' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Der Befehl konnte nicht ausgeführt werden"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString, "LONGLONGLONGLONGLONGLLONGLONGLOLONGLONGID="))(":1", QVariant(QString, "SOMESOMESOMESOMESOME+KEY))(":10", QVariant(int, -1))(":11", QVariant(int, -1))(":12", QVariant(bool, false))(":13", QVariant(QString, ""))(":14", QVariant(bool, false))(":2", QVariant(QString, "Aufgezeichnete Unterhaltungen"))(":3", QVariant(qlonglong, 385))(":4", QVariant(qlonglong, 13))(":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 '385-Aufgezeichnete Unterhaltungen' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Der Befehl konnte nicht ausgeführt werden"
org.kde.pim.akonadiserver: Failed to append Collection "Aufgezeichnete Unterhaltungen" in resource "akonadi_ews_resource_1"
org.kde.pim.akonadiserver: Error while handling command CreateCollection on connection akonadi_ews_resource_1 (0x5599800098f0)
Comment 1 Ahmad Samir 2020-08-23 09:38:15 UTC
Looks like a database error:
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '385-Aufgezeichnete Unterhaltungen' for key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '385-Aufgezeichnete Unterhaltungen' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Der Befehl konnte nicht ausgeführt werden"