[Akonadi] [Bug 323844] Adding foldert to imap-account gives "Duplicate entry" sql error

Mon Aug 26 18:40:14 BST 2013

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

--- Comment #5 from Johannes Hirte <johannes.hirte at fem.tu-ilmenau.de> ---
(In reply to comment #4)
> @Johannes, can you please check in Akonadi Console -> Db Browser ->
> collectiontable that no collection with the name you are trying to create
> exists there, then try to create it and check again. If a new record with
> the name and remoteId filled is there, then there's some weird bug that
> KMail or the IMAP resource is trying to create the collections twice.  Make
> sure you have "Debugger" enabled when creating the collection. If you get
> the error again, please provide entire output of the "Debugger" tab. Thanks

output from the "Debugger" tab:

kmail2-2005480717 (0x24c4e50) 11 CREATE "debugkmail" 46 ( REMOTEID ""
REMOTEREVISION "" VIRTUAL 0 CACHEPOLICY (INHERIT true)) 
kmail2-2005480717 (0x24c4e50) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ) 
kmail2-2005480717 (0x24c4e50) 11 OK CREATE completed 
MailFilter Kernel ETM (0x24c5230) 14 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
Archive Mail Kernel ETM (0x24b4bb0) 14 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
MailFilter Kernel ETM (0x24c5230) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
MailFilter Kernel ETM (0x24c5230) 14 OK List completed 
Archive Mail Kernel ETM (0x24b4bb0) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
Archive Mail Kernel ETM (0x24b4bb0) 14 OK List completed 
akonadi_newmailnotifier_agent (0x23e1680) 9 LSUB 58 0 () (ANCESTORS INF) 
akonadi_nepomuk_feeder (0x23de2d0) 9 LSUB 58 0 () () 
akonadi_newmailnotifier_agent (0x23e1680) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
akonadi_newmailnotifier_agent (0x23e1680) 9 OK List completed 
akonadi_nepomuk_feeder (0x23de2d0) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ) 
akonadi_nepomuk_feeder (0x23de2d0) 9 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 51 LSUB 46 0 () (STATISTICS true ANCESTORS
INF) 
akonadi_imap_resource_5 (0x23e03b0) * 46 0 (NAME "kmailtest" MIMETYPE
(inode/directory) REMOTEID "imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/"
REMOTEREVISION "" RESOURCE "akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0
UNSEEN 0 SIZE 0 CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT 60
SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((0 "")) noselect "1") 
akonadi_imap_resource_5 (0x23e03b0) 51 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 52 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
akonadi_imap_resource_5 (0x23e03b0) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
akonadi_imap_resource_5 (0x23e03b0) 52 OK List completed 
ETMCalendar (0x23d8cb0) 13 LSUB 58 0 () (ANCESTORS INF) 
ETMCalendar (0x23d8cb0) * 58 46 (NAME "debugkmail" MIMETYPE (inode/directory)
REMOTEID "" REMOTEREVISION "" RESOURCE "akonadi_imap_resource_5" VIRTUAL 0
CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true
LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
ETMCalendar (0x23d8cb0) 13 OK List completed 
ETMCalendar (0x2407660) 13 LSUB 58 0 () (ANCESTORS INF) 
ETMCalendar (0x2407660) * 58 46 (NAME "debugkmail" MIMETYPE (inode/directory)
REMOTEID "" REMOTEREVISION "" RESOURCE "akonadi_imap_resource_5" VIRTUAL 0
CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true
LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
ETMCalendar (0x2407660) 13 OK List completed 
KMail Kernel ETM (0x23ecc80) 21 LSUB 58 0 () (STATISTICS true ANCESTORS INF) 
KMail Kernel ETM (0x23ecc80) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
KMail Kernel ETM (0x23ecc80) 21 OK List completed 
AkonadiConsole Browser Widget (0x2438620) 9 LSUB 58 0 () (ANCESTORS INF) 
AkonadiConsole Browser Widget (0x2438620) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
AkonadiConsole Browser Widget (0x2438620) 9 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 53 UID MODIFY 58 PARENT 46 NAME
"debugkmail" REMOTEID "/debugkmail" REMOTEREVISION "" 
akonadi_imap_resource_5 (0x23e03b0) 53 OK MODIFY done 
MailFilter Kernel ETM (0x24c5230) 15 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
akonadi_nepomuk_feeder (0x23de2d0) 10 LSUB 58 0 () () 
Archive Mail Kernel ETM (0x24b4bb0) 15 LSUB 58 0 () (STATISTICS true ANCESTORS
INF) 
akonadi_newmailnotifier_agent (0x23e1680) 10 LSUB 58 0 () (ANCESTORS INF) 
KMail Kernel ETM (0x23ecc80) 22 LSUB 58 0 () (STATISTICS true ANCESTORS INF) 
ETMCalendar (0x2407660) 14 LSUB 58 0 () (ANCESTORS INF) 
ETMCalendar (0x2407660) * 58 46 (NAME "debugkmail" MIMETYPE (inode/directory)
REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE "akonadi_imap_resource_5"
VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND
true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
ETMCalendar (0x2407660) 14 OK List completed 
akonadi_nepomuk_feeder (0x23de2d0) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ) 
akonadi_nepomuk_feeder (0x23de2d0) 10 OK List completed 
akonadi_newmailnotifier_agent (0x23e1680) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
akonadi_newmailnotifier_agent (0x23e1680) 10 OK List completed 
Archive Mail Kernel ETM (0x24b4bb0) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
Archive Mail Kernel ETM (0x24b4bb0) 15 OK List completed 
KMail Kernel ETM (0x23ecc80) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
KMail Kernel ETM (0x23ecc80) 22 OK List completed 
ETMCalendar (0x23d8cb0) 14 LSUB 58 0 () (ANCESTORS INF) 
ETMCalendar (0x23d8cb0) * 58 46 (NAME "debugkmail" MIMETYPE (inode/directory)
REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE "akonadi_imap_resource_5"
VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND
true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
ETMCalendar (0x23d8cb0) 14 OK List completed 
MailFilter Kernel ETM (0x24c5230) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY
(INHERIT true INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
MailFilter Kernel ETM (0x24c5230) 15 OK List completed 
AkonadiConsole Browser Widget (0x2438620) 10 LSUB 58 0 () (ANCESTORS INF) 
AkonadiConsole Browser Widget (0x2438620) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) ) 
AkonadiConsole Browser Widget (0x2438620) 10 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 54 BEGIN 
akonadi_imap_resource_5 (0x23e03b0) 54 OK Begin completed 
akonadi_imap_resource_5 (0x23e03b0) 55 LIST 0 INF (RESOURCE
akonadi_imap_resource_5) (ANCESTORS 1) 
akonadi_imap_resource_5 (0x23e03b0) * 51 46 (NAME "Drafts" MIMETYPE
(message/rfc822 inode/directory) REMOTEID ".Drafts" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) timestamp "1377170263"
uidnext "1" collectionflags "\\Answered \\Flagged \\Deleted \\Seen \\Draft \\*"
uidvalidity "1377170199") 
akonadi_imap_resource_5 (0x23e03b0) * 49 46 (NAME "INBOX" MIMETYPE
(message/rfc822 inode/directory) REMOTEID ".INBOX" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) ENTITYDISPLAY
"(\"Inbox\" \"mail-folder-inbox\" \"\" ())" timestamp "1377170263" uidnext "2"
collectionflags "\\Answered \\Flagged \\Deleted \\Seen \\Draft \\*" uidvalidity
"1377170198") 
akonadi_imap_resource_5 (0x23e03b0) * 47 46 (NAME "Junk" MIMETYPE
(message/rfc822 inode/directory) REMOTEID ".Junk" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) timestamp "1377170262"
uidnext "1" collectionflags "\\Answered \\Flagged \\Deleted \\Seen \\Draft \\*"
uidvalidity "1377170200") 
akonadi_imap_resource_5 (0x23e03b0) * 48 46 (NAME "Sent" MIMETYPE
(message/rfc822 inode/directory) REMOTEID ".Sent" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) timestamp "1377170263") 
akonadi_imap_resource_5 (0x23e03b0) * 50 46 (NAME "Trash" MIMETYPE
(message/rfc822 inode/directory) REMOTEID ".Trash" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) timestamp "1377170263") 
akonadi_imap_resource_5 (0x23e03b0) * 58 46 (NAME "debugkmail" MIMETYPE
(inode/directory) REMOTEID "/debugkmail" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) ) 
akonadi_imap_resource_5 (0x23e03b0) * 56 46 (NAME "kmailfolder" MIMETYPE
(inode/directory) REMOTEID "/kmailfolder" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) ) 
akonadi_imap_resource_5 (0x23e03b0) * 52 46 (NAME "newfolder" MIMETYPE
(inode/directory) REMOTEID "/newfolder" REMOTEREVISION "" RESOURCE
"akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY (INHERIT true INTERVAL -1
CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD)) ANCESTORS ((46
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/")) ) 
akonadi_imap_resource_5 (0x23e03b0) * 46 0 (NAME "kmailtest" MIMETYPE
(inode/directory) REMOTEID "imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/"
REMOTEREVISION "" RESOURCE "akonadi_imap_resource_5" VIRTUAL 0 CACHEPOLICY
(INHERIT false INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS
(ENVELOPE HEAD)) ANCESTORS ((0 "")) noselect "1") 
akonadi_imap_resource_5 (0x23e03b0) 55 OK List completed 
akonadi_imap_resource_5 (0x23e03b0) 56 UID MODIFY 46 MIMETYPE (inode/directory)
PARENT 0 NAME "kmailtest" REMOTEID
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/" CACHEPOLICY (INHERIT false
INTERVAL -1 CACHETIMEOUT 60 SYNCONDEMAND true LOCALPARTS (ENVELOPE HEAD))
noselect "1" 
akonadi_imap_resource_5 (0x23e03b0) 56 OK MODIFY done 
akonadi_imap_resource_5 (0x23e03b0) 57 UID MODIFY 47 MIMETYPE (message/rfc822
inode/directory) PARENT 46 NAME "Junk" REMOTEID ".Junk" -noselect 
akonadi_imap_resource_5 (0x23e03b0) 57 OK MODIFY done 
akonadi_imap_resource_5 (0x23e03b0) 58 UID MODIFY 48 MIMETYPE (message/rfc822
inode/directory) PARENT 46 NAME "Sent" REMOTEID ".Sent" -noselect 
akonadi_imap_resource_5 (0x23e03b0) 58 OK MODIFY done 
akonadi_imap_resource_5 (0x23e03b0) 59 UID MODIFY 49 MIMETYPE (message/rfc822
inode/directory) PARENT 46 NAME "INBOX" REMOTEID ".INBOX" ENTITYDISPLAY
"(\"Inbox\" \"mail-folder-inbox\" \"\" ())" -noselect 
akonadi_imap_resource_5 (0x23e03b0) 59 OK MODIFY done 
akonadi_imap_resource_5 (0x23e03b0) 60 UID MODIFY 50 MIMETYPE (message/rfc822
inode/directory) PARENT 46 NAME "Trash" REMOTEID ".Trash" -noselect 
akonadi_imap_resource_5 (0x23e03b0) 60 OK MODIFY done 
akonadi_imap_resource_5 (0x23e03b0) 61 UID MODIFY 51 MIMETYPE (message/rfc822
inode/directory) PARENT 46 NAME "Drafts" REMOTEID ".Drafts" -noselect 
akonadi_imap_resource_5 (0x23e03b0) 61 OK MODIFY done 
akonadi_imap_resource_5 (0x23e03b0) 62 CREATE "debugkmail" 46 (MIMETYPE
(message/rfc822 inode/directory) REMOTEID ".debugkmail" REMOTEREVISION ""
VIRTUAL 0 CACHEPOLICY (INHERIT true)) 
akonadi_imap_resource_5 (0x23e03b0) 62 NO Could not create collection
debugkmail resourceId: 5 
akonadi_imap_resource_5 (0x23e03b0) 63 ROLLBACK 
akonadi_imap_resource_5 (0x23e03b0) 63 OK Rollback completed 
akonadi_imap_resource_5 (0x23e03b0) 64 HRID MODIFY ((-236 ".debugkmail") (-234
"imap://kmailtest@datenkhaos.de@mail.datenkhaos.de/") (0 "")) MIMETYPE
(message/rfc822 inode/directory) NAME "debugkmail" REMOTEID ".debugkmail"
timestamp "1377538574" -noselect 
akonadi_imap_resource_5 (0x23e03b0) 64 NO Hierarchical RID does not specify a
unique collection

-- 
You are receiving this mail because:
You are the assignee for the bug.