[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"

[Christophe Giboudeaux]

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





--- Comment #4 from Christophe Giboudeaux <cgiboudeaux gmail com>  2010-06-25 00:05:42 ---
Looks like it's not postgres specific:
from bug 242698:

[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738) setCurrentAuthMode: selected auth mode: "Clear
text"
[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738) SetupServer::slotSafetyChanged: serverTest null
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738)/kdepimlibs (kimap) ImapResource::retrieveItems:
".maxtorhof"
[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738)/kdepimlibs (kimap) ImapResource::triggerExpunge:
"INBOX.lists.maxtorhof"
[akonadiserver] Error during executing query "INSERT INTO CollectionTable
(remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit)
VALUES (:0, :1, :2, :3, :4, :5)" :  "Duplicate entry '112-trash' for key
'CollectionTable_parentAndNameIndex' QMYSQL3: Unable to execute statement"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate
entry '112-trash' for key 'CollectionTable_parentAndNameIndex' QMYSQL3: Unable
to execute statement"
[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738)/libakonadi
Akonadi::SpecialCollectionsRequestJobPrivate::collectionCreateResult: Failed
CollectionCreateJob. "Unknown error. (Could not create collection)"
[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738)/kdepimlibs (kimap)
KIMAP::ExpungeJob::handleResponse: Unhandled response:  * 2815 EXISTS
[/space/kde/installs/trunk/bin/akonadi_imap_resource]
akonadi_imap_resource_0(7738)/kdepimlibs (kimap)

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.