[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 vkra...@kde.org changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #11 from Volker Krause vkra...@kde.org --- 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 cgiboudeaux gmx com 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 Christophe Giboudeaux cgiboude...@gmx.com changed: What|Removed |Added Status|NEEDSINFO |NEW Resolution|WAITINGFORINFO | --- Comment #7 from Christophe Giboudeaux cgiboudeaux gmx com 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 #8 from Christophe Giboudeaux cgiboudeaux gmx com 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 --- Comment #9 from Christophe Giboudeaux cgiboudeaux gmx com 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 #6 from Christophe Giboudeaux cgiboudeaux gmail com 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 to...@kde.org changed: What|Removed |Added Status|NEW |NEEDSINFO CC||to...@kde.org Resolution||WAITINGFORINFO --- Comment #5 from Tobias Koenig tokoe kde org 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 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. ___ 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 cgiboudeaux gmail com 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 #1 from Christophe Giboudeaux cgiboudeaux gmail com 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
[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 cgiboudeaux gmail com 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
