[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 Volker Krause changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #11 from Volker Krause --- Fixed in kdepimlibs commit 662bfe163c486146c9e408d0add6fd5fcc415b83. -- You are receiving this mail because: You are on the CC list for the bug. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #10 from Christophe Giboudeaux 2011-09-14 10:07:05 --- (In reply to comment #9) > and the kmail error I didn't notice before: > > kmail2(29009) KMKernel::instanceError: instance : > "akonadi_maildir_resource_0" > was got an error : "Maildir '' for collection '' is invalid." from the akonadi side: AkonadiAgentServer(18886) MaildirResource::maildirForCollection: Got incomplete ancestor chain: Collection ID: 7remote ID: "" name: "trash" url: KUrl("akonadi:?collection=7") parent: 2 "/home/krop/.local/share/local-mail" resource: "akonadi_maildir_resource_0" rights: QFlags(0x1|0x2|0x4|0x8|0x10|0x20) contents mime type: ("message/rfc822", "inode/directory") CachePolicy: inherit: true interval: -1 timeout: 1 sync on demand: true local parts: ("ENVELOPE") CollectionStatistics: count: -1 unread count: -1 size: -1 -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #9 from Christophe Giboudeaux 2011-09-13 11:29:48 --- and the kmail error I didn't notice before: kmail2(29009) KMKernel::instanceError: instance : "akonadi_maildir_resource_0" was got an error : "Maildir '' for collection '' is invalid." -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #8 from Christophe Giboudeaux 2011-09-13 09:54:24 --- and the query causing that is : Executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1, :2, :3, :4, :5) RETURNING id" ":0" QVariant(QString, "trash") ":1" QVariant(QString, "") ":2" QVariant(QString, "trash") ":3" QVariant(qlonglong, 2) ":4" QVariant(qlonglong, 2) ":5" QVariant(bool, true) the resource with id=2 is the maildir one and SELECT * FROM collectiontable WHERE name='trash' AND resourceId=2 already returns a row : id=7 remoteid="" remoterevision="" name=trash parentid=2 resourceid=2 [...] cachepolicyinherit=true -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 Christophe Giboudeaux changed: What|Removed |Added Status|NEEDSINFO |NEW Resolution|WAITINGFORINFO | --- Comment #7 from Christophe Giboudeaux 2011-09-13 09:33:53 --- Bah, after switching again to postgres, I see a similar error again Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1, :2, :3, :4, :5) RETURNING id" : "ERROR: duplicate key value violates unique constraint "collectiontable_parentandnameindex" DÉTAIL : Key (parentid, name)=(2, \x7472617368) already exists. QPSQL: Unable to create query" Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint "collectiontable_parentandnameindex" DÉTAIL : Key (parentid, name)=(2, \x7472617368) already exists. QPSQL: Unable to create query" -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #6 from Christophe Giboudeaux 2010-08-28 12:01:37 --- Hi Tobias, Well, I see it when creating the DB at least, from the creation log file: 2010-08-27 15:53:41 CEST akonadi krop ERROR: duplicate key value violates unique constraint "mimetypetable_name_key" 2010-08-27 15:53:41 CEST akonadi krop STATEMENT: EXECUTE qpsqlpstmt_10 ('application/x-vnd.akonadi.calendar.journal') (the error and the statement are probably unrelated). I need to check if this still happens after manually fetching messages. -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 Tobias Koenig changed: What|Removed |Added Status|NEW |NEEDSINFO CC||to...@kde.org Resolution||WAITINGFORINFO --- Comment #5 from Tobias Koenig 2010-08-02 21:24:06 --- Hej Christophe, can you still reproduce this bug with a current version? Ciao, Tobias -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #4 from Christophe Giboudeaux 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #3 from Christophe Giboudeaux 2010-06-20 23:48:46 --- Here's the full query that the server is running: [akonadiserver] Executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1, :2, :3, :4, :5) RETURNING id" [akonadiserver] ":0" QVariant(QString, "/Junk") [akonadiserver] ":1" QVariant(QString, "") [akonadiserver] ":2" QVariant(QString, "Junk") [akonadiserver] ":3" QVariant(qlonglong, 5) [akonadiserver] ":4" QVariant(qlonglong, 3) [akonadiserver] ":5" QVariant(bool, true) [akonadiserver] Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1, :2, :3, :4, :5) RETURNING id" : "ERROR: duplicate key value violates unique constraint "collectiontable_parentandnameindex" [akonadiserver] QPSQL: Unable to create query" [akonadiserver] Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint "collectiontable_parentandnameindex" [akonadiserver] QPSQL: Unable to create query" [akonadiserver] Unable to free statement: ERROR: current transaction is aborted, commands ignored until end of transaction block [akonadiserver] -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #2 from Christophe Giboudeaux 2010-06-17 22:48:17 --- Better translation for the error: [akonadiserver] Error during executing query "INSERT INTO CollectionTable (remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit) VALUES (:0, :1, :2, :3, :4, :5) RETURNING id" : "ERROR: duplicate key value violates unique constraint "collectiontable_parentandnameindex" [akonadiserver] QPSQL: Unable to create query" [akonadiserver] Error during insertion into table "CollectionTable" "ERROR: duplicate key value violates unique constraint "collectiontable_parentandnameindex" [akonadiserver] QPSQL: Unable to create query" [akonadiserver] Unable to free statement: ERROR: current transaction is aborted, commands ignored until end of transaction block [akonadiserver] which may be what is described there: http://railspikes.com/2009/3/6/duplicate-key-violates-unique-constraint -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs
[Bug 241464] Error with the postgres backend: "The value of a duplicated key breaks the unique constraint collectiontable_parentandnameindex"
https://bugs.kde.org/show_bug.cgi?id=241464 --- Comment #1 from Christophe Giboudeaux 2010-06-17 19:10:36 --- Looks like the message is also displayed when trying to manually download messages in kmail2 (check mail / account) -- 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. ___ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs