org.kde.pim.maildispatcher: Failed to get outbox folder. Giving up Could not create collection outbox, resourceId: 5"

Sérgio Basto sergio at serjux.com
Tue Apr 30 16:48:26 BST 2019 

Well , 
after 6 bug reports and emails we got 0 (zero) replies thank you 

#akonadictl restart
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
Settings(0x55e1d5a50930)
QIODevice::read (QLocalSocket): device not open
QIODevice::read (QLocalSocket): device not open
org.kde.pim.akonadicontrol: ProcessControl: Application
"/usr/bin/akonadi_indexing_agent" stopped unexpectedly ( "Process
crashed" )
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_indexing_agent' crashed. No restart!
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_unifiedmailbox_agent' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_akonotes_resource' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_pop3_resource' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_mailfilter_agent' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_newmailnotifier_agent' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_archivemail_agent' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_maildispatcher_agent' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_maildir_resource' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_followupreminder_agent' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_migration_agent' exited normally...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_notes_agent'
exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_contacts_resource' exited normally...
org.kde.pim.akonadicontrol: Application
'/usr/bin/akonadi_sendlater_agent' exited normally...
org.kde.pim.akonadicontrol: Application 'akonadiserver' exited
normally...
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
sergio at segulix:~#akonadi.collectionattributetable                   OK
akonadi.collectionmimetyperelation                 OK
akonadi.collectionpimitemrelation                  OK
akonadi.collectiontable                            OK
akonadi.flagtable                                  OK
akonadi.mimetypetable                              OK
akonadi.parttable                                  OK
akonadi.parttypetable                              OK
akonadi.pimitemflagrelation                        OK
akonadi.pimitemtable                               OK
akonadi.pimitemtagrelation                         OK
akonadi.relationtable                              OK
akonadi.relationtypetable                          OK
akonadi.resourcetable                              OK
akonadi.schemaversiontable                         OK
akonadi.tagattributetable                          OK
akonadi.tagremoteidresourcerelationtable           OK
akonadi.tagtable                                   OK
akonadi.tagtypetable                               OK
Connecting to deprecated signal
QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '7-outbox' for
key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '7-outbox'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString,
""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11",
QVariant(int, -1))(":12", QVariant(bool, false))(":13",
QVariant(QString, ""))(":14", QVariant(bool, false))(":2",
QVariant(QString, "outbox"))(":3", QVariant(qlonglong, 7))(":4",
QVariant(qlonglong, 5))(":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 '7-outbox' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadicore: Failed
SpecialCollectionsRequestJob::slotResult "Could not create collection
outbox, resourceId: 5"
org.kde.pim.maildispatcher: Failed to get outbox folder. Retrying
in:  5000
org.kde.pim.akonadicore: Failed CollectionCreateJob. "Could not create
collection outbox, resourceId: 5"
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '7-outbox' for
key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '7-outbox'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString,
""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11",
QVariant(int, -1))(":12", QVariant(bool, false))(":13",
QVariant(QString, ""))(":14", QVariant(bool, false))(":2",
QVariant(QString, "outbox"))(":3", QVariant(qlonglong, 7))(":4",
QVariant(qlonglong, 5))(":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 '7-outbox' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadicore: Failed
SpecialCollectionsRequestJob::slotResult "Could not create collection
outbox, resourceId: 5"
org.kde.pim.maildispatcher: Failed to get outbox folder. Retrying
in:  10000
org.kde.pim.akonadicore: Failed CollectionCreateJob. "Could not create
collection outbox, resourceId: 5"
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '7-outbox' for
key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '7-outbox'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString,
""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11",
QVariant(int, -1))(":12", QVariant(bool, false))(":13",
QVariant(QString, ""))(":14", QVariant(bool, false))(":2",
QVariant(QString, "outbox"))(":3", QVariant(qlonglong, 7))(":4",
QVariant(qlonglong, 5))(":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 '7-outbox' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadicore: Failed
SpecialCollectionsRequestJob::slotResult "Could not create collection
outbox, resourceId: 5"
org.kde.pim.maildispatcher: Failed to get outbox folder. Retrying
in:  15000
org.kde.pim.akonadicore: Failed CollectionCreateJob. "Could not create
collection outbox, resourceId: 5"
org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '7-outbox' for
key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '7-outbox'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString,
""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11",
QVariant(int, -1))(":12", QVariant(bool, false))(":13",
QVariant(QString, ""))(":14", QVariant(bool, false))(":2",
QVariant(QString, "outbox"))(":3", QVariant(qlonglong, 7))(":4",
QVariant(qlonglong, 5))(":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 '7-outbox' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadicore: Failed
SpecialCollectionsRequestJob::slotResult "Could not create collection
outbox, resourceId: 5"
org.kde.pim.maildispatcher: Failed to get outbox folder. Giving up.
org.kde.pim.akonadicore: Failed CollectionCreateJob. "Could not create
collection outbox, resourceId: 5"

sergio at segulix:~#org.kde.pim.akonadiserver: DATABASE ERROR:
org.kde.pim.akonadiserver:   Error code: "1062"
org.kde.pim.akonadiserver:   DB error:  "Duplicate entry '7-outbox' for
key 'CollectionTable_parentAndNameIndex'"
org.kde.pim.akonadiserver:   Error text: "Duplicate entry '7-outbox'
for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadiserver:   Values: QMap((":0", QVariant(QString,
""))(":1", QVariant(QString, ""))(":10", QVariant(int, -1))(":11",
QVariant(int, -1))(":12", QVariant(bool, false))(":13",
QVariant(QString, ""))(":14", QVariant(bool, false))(":2",
QVariant(QString, "outbox"))(":3", QVariant(qlonglong, 7))(":4",
QVariant(qlonglong, 5))(":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 '7-outbox' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute
statement"
org.kde.pim.akonadicore: Failed
SpecialCollectionsRequestJob::slotResult "Could not create collection
outbox, resourceId: 5"
org.kde.pim.maildispatcher: Failed to get outbox folder. Giving up.
org.kde.pim.akonadicore: Failed CollectionCreateJob. "Could not create
collection outbox, resourceId: 5"

On Wed, 2019-04-24 at 04:24 +0100, Sérgio Basto wrote:
> Hi,
> 
> Can someone try help me how fix "Duplicate entry in CollectionTable"
> erros , we have a lot of reports [1] , the logs are quite clear for
> my
> case [2] mysql is trying insert one row but we have a constraint that
> don't let insert the row . 
> What I can do in SQL ? 
> 
> 
> [1] 
> https://bugs.kde.org/show_bug.cgi?id=402258
> https://bugs.kde.org/show_bug.cgi?id=375244
> https://bugs.kde.org/show_bug.cgi?id=371570
> https://bugs.kde.org/show_bug.cgi?id=323844
> https://bugs.kde.org/show_bug.cgi?id=375244
> 
> [2]
> https://bugs.kde.org/show_bug.cgi?id=402258#c4
-- 
Sérgio M. B.

More information about the kdepim-users mailing list