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

Sérgio Basto <[email protected]>
Newsgroups gmane.comp.kde.users.pim
Message-ID <[email protected]> 
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@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@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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.