[Akonadi] [Bug 417663] New: No Mails of Office 365 account accessible because of DB CollectionTable Insert error: "Duplicate entry"

[bugzilla_noreply at kde.org]

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

            Bug ID: 417663
           Summary: No Mails of Office 365 account accessible because of
                    DB CollectionTable Insert error: "Duplicate entry"
           Product: Akonadi
           Version: unspecified
          Platform: Kubuntu Packages
                OS: Linux
            Status: REPORTED
          Severity: major
          Priority: NOR
         Component: EWS Resource
          Assignee: kdepim-bugs at kde.org
          Reporter: jinto at ymail.com
                CC: krissn at op.pl
  Target Milestone: ---

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)

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