[Bug 241464] New: 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

           Summary: Error with the postgres backend: "The value of a
                    duplicated key breaks the unique constraint
                    collectiontable_parentandnameindex"
           Product: Akonadi
           Version: unspecified
          Platform: Unlisted Binaries
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: NOR
         Component: server
        AssignedTo: vkrause at kde.org
        ReportedBy: cgiboudeaux at gmail.com
                CC: kdepim-bugs at kde.org


Using trunk (akonadiserver rev. 1136839) + Qt 4.6.3 and postgresql 8.4.3

The message is displayed after each interval check:

[/d/kde/inst/kdepim-runtime/bin/akonadi_imap_resource]
akonadi_imap_resource_0(8312)/kdepimlibs (kimap) ImapResource::onSelectDone:
All fine, asking for all message flags looking for changes
[akonadiserver] interval checking  collection  8 ( "accnt1 - gmail" )
[akonadiserver] interval checking  collection  9 ( "INBOX" )
[akonadiserver] interval checking  collection  12 ( "folder1" )
[akonadiserver] interval checking  collection  13 ( "folder2" )
[akonadiserver] interval checking  collection  20 ( "folder3" )
[akonadiserver] interval checking  collection  10 ( "[Gmail]" )
[akonadiserver] interval checking  collection  14 ( "Brouillons" )
[akonadiserver] interval checking  collection  15 ( "Corbeille" )
[akonadiserver] interval checking  collection  16 ( "Messages envoyés" )
[akonadiserver] interval checking  collection  17 ( "Spam" )
[akonadiserver] interval checking  collection  18 ( "Suivis" )
[akonadiserver] interval checking  collection  11 ( "folder4" )
[/d/kde/inst/kdepim-runtime/bin/akonadi_imap_resource]
akonadi_imap_resource_0(8312)/kdecore (KConfigSkeleton)
KCoreConfigSkeleton::writeConfig:
[akonadiserver] Error during executing query "INSERT INTO CollectionTable
(remoteId, remoteRevision, name, parentId, resourceId, cachePolicyInherit)
VALUES (:0, :1, :2, :3, :4, :5) RETURNING id" :  "ERREUR:  la valeur d'une clé
dupliquée rompt la contrainte unique « collectiontable_parentandnameindex »
[akonadiserver] QPSQL: Unable to create query"
[akonadiserver] Error during insertion into table "CollectionTable" "ERREUR: 
la valeur d'une clé dupliquée rompt la contrainte unique «
collectiontable_parentandnameindex »
[akonadiserver] QPSQL: Unable to create query"
[akonadiserver] Unable to free statement: ERREUR:  la transaction est annulée,
les commandes sont ignorées jusqu'à la fin du bloc
[akonadiserver] de la transaction
[akonadiserver] 
[/d/kde/inst/kdepim-runtime/bin/akonadi_imap_resource]
akonadi_imap_resource_0(8312)/kdepimlibs (kimap) ImapResource::retrieveItems:
"/INBOX"
[/d/kde/inst/kdepim-runtime/bin/akonadi_imap_resource]
akonadi_imap_resource_0(8312)/kdepimlibs (kimap) ImapResource::triggerExpunge:
"INBOX"
[/d/kde/inst/kdepim-runtime/bin/akonadi_imap_resource]
akonadi_imap_resource_0(8312)/kdepimlibs (kimap) ImapResource::onSelectDone:
integrity:  "INBOX"  should be:  485  current:  485


Translations (I guess we should change the backend settings to avoid having
localized messages): 

"ERREUR:  la valeur d'une clé dupliquée rompt la contrainte unique «
collectiontable_parentandnameindex »
-> The value of a duplicated key breaks the unique constraint «
collectiontable_parentandnameindex »

ERREUR:  la transaction est annulée, les commandes sont ignorées jusqu'à la fin
du bloc
-> The transaction is canceled, commands will be ignored until the end of the
transaction bloc

-- 
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.