Bug 199808 - Akonadi IMAP Resource shows nothing - Duplicate entry in MySQL table
Summary: Akonadi IMAP Resource shows nothing - Duplicate entry in MySQL table
Status: RESOLVED DUPLICATE of bug 202623
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: IMAP resource (other bugs)
Version First Reported In: 4.2
Platform: Gentoo Packages Linux
: NOR normal
Target Milestone: ---
Assignee: Kevin Ottens
URL:
Keywords:
: 197361 (view as bug list)
Depends on:
Blocks:
 
Reported: 2009-07-11 21:46 UTC by Dennis Schridde
Modified: 2009-10-17 15:14 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Schridde 2009-07-11 21:46:02 UTC 
Version:            (using KDE 4.2.96)
Compiler:          gcc 4.4.0 Gentoo 4.4.0 p1.1
OS:                Linux
Installed from:    Gentoo Packages

Adding an IMAP Resource to Akonadi will not show any email folders (or anything else at all) in the Browser. (And the Akonadi Kolab Proxy Resource does not show anything at all either, which may be related.)

$ akonadictl restart
Starting Akonadi Server...              
   done.                                
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()                                               
[akonadiserver] checking table  "SchemaVersionTable"                               
[akonadiserver] checking table  "ResourceTable"                                    
[akonadiserver] checking table  "CollectionTable"                                  
[akonadiserver] checking table  "MimeTypeTable"                                    
[akonadiserver] checking table  "PimItemTable"                                     
[akonadiserver] checking table  "FlagTable"                                        
[akonadiserver] checking table  "PartTable"                                        
[akonadiserver] checking table  "CollectionAttributeTable"                         
[akonadiserver] checking relation  "PimItemFlagRelation"                           
[akonadiserver] checking relation  "CollectionMimeTypeRelation"                    
[akonadiserver] checking relation  "CollectionPimItemRelation"                     
[akonadiserver] DbInitializer::run() done                                          
[akonadiserver] skipping update 2                                                  
[akonadiserver] skipping update 3                                                  
[akonadiserver] skipping update 4                                                  
[akonadiserver] skipping update 8                                                  
[akonadiserver] skipping update 10                                                 
[akonadiserver] skipping update 12                                                 
[akonadiserver] Nepomuk QueryServer interface not available!                       
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                    
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                    
PLUGINS:  "/usr/share/akonadi/agents"                                              
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")                                                                                                                       
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource", "Unique")                                                                                                                                           
PLUGINS inserting:  "akonadi_distlist_resource" 0 ("Resource")                                                                                                                                                      
PLUGINS inserting:  "akonadi_ical_resource" 3 ("Resource")                                                                                                                                                          
PLUGINS inserting:  "akonadi_imap_resource" 0 ("Resource")                                                                                                                                                          
PLUGINS inserting:  "akonadi_kabc_resource" 0 ("Resource")                                                                                                                                                          
PLUGINS inserting:  "akonadi_kcal_resource" 0 ("Resource")                                                                                                                                                          
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig")
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 3 ("Resource")
PLUGINS:  "/usr/share/akonadi/agents"
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Attribute "ENTITYDISPLAY" already exists for collection 5
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '7219100208648643950-8749137744256658711' for key 2 QMYSQL3: Unable to execute statement"
[akonadiserver] Attribute "AccessRights" already exists for collection 6
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '8246199088285969247-7594301998597103899' for key 2 QMYSQL3: Unable to execute statement"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '7219100208648643950-8749137744256658711' for key 2 QMYSQL3: Unable to execute statement"


And akonadiconsole logs:
0x151b6b0 16 BEGIN 
0x151b6b0 16 OK Begin completed 
0x151b6b0 17 X-AKLSUB 0 INF (RESOURCE "akonadi_imap_resource_0") 
0x151b6b0 17 OK List completed 
0x151b6b0 18 CREATE "host/user" 0 (MIMETYPE (inode/directory) REMOTEID "imap://user@host/" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND true LOCALPARTS ())) 
0x151b6b0 18 NO Could not create collection 
0x151b6b0 19 ROLLBACK 
0x151b6b0 19 OK Rollback completed 


As well as:
AgentBase(akonadi_imap_resource_0): Unknown error. (Could not create collection)
Comment 1 Dennis Schridde 2009-07-11 21:48:19 UTC 
Clarification: "the Browser" refers to the "Browser" tab of akonadiconsole.
Comment 2 Dennis Schridde 2009-07-23 00:40:45 UTC 
The issue persists in 4.2.98.
Comment 3 Dennis Schridde 2009-07-30 09:45:58 UTC 
Addition:
The "traditional" resources neither work, mostly due to "could not create collection", but the first time also with something similar to: "could not append mimetype".

AgentBase(akonadi_kabc_resource_0): Unknown error. (Could not create collection)
AgentBase(akonadi_kcal_resource_0): Unknown error. (Could not create collection)


0xed5380 6 BEGIN 
0xed5380 6 OK Begin completed 
0xed5380 7 X-AKLSUB 0 INF (RESOURCE "akonadi_kabc_resource_0") 
0xed5380 7 OK List completed 
0xed5380 8 CREATE "Adressbuch" 0 (MIMETYPE (text/directory application/x-vnd.kde.contactgroup inode/directory) REMOTEID "yuSsDXQiFs" ENTITYDISPLAY "(\"Adressbuch\" \"office-address-book\")" AccessRights "wcd" CACHEPOLICY (INHERIT true)) 
0xed5380 8 NO Could not create collection 
0xed5380 9 ROLLBACK 
0xed5380 9 OK Rollback completed 
0xf91b60 10 BEGIN 
0xf91b60 10 OK Begin completed 
0xf91b60 11 X-AKLSUB 0 INF (RESOURCE "akonadi_kcal_resource_0") 
0xf91b60 11 OK List completed 
0xf91b60 12 CREATE "Kalender" 0 (MIMETYPE (text/calendar application/x-vnd.akonadi.calendar.event application/x-vnd.akonadi.calendar.todo application/x-vnd.akonadi.calendar.journal application/x-vnd.akonadi.calendar.freebusy inode/directory) REMOTEID "neXF46NEVw" ENTITYDISPLAY "(\"Kalender\" \"office-calendar\")" AccessRights "a" CACHEPOLICY (INHERIT true)) 
0xf91b60 12 NO Could not create collection 
0xf91b60 13 ROLLBACK 
0xf91b60 13 OK Rollback completed
Comment 4 Dennis Schridde 2009-07-30 10:06:05 UTC 
I switched to an internal database for akonadi and am now getting this in the akonadiconsole debugger:

0xadbfb0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0xb38540 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0xadb030 0 LOGIN "akonadiconsole-CollectionModel-719950939" 
0xadb030 0 OK User logged in 
0xb38540 0 LOGIN "akonadiconsole-ItemModel-1223389481" 
0xb38540 0 OK User logged in 
0xadb030 1 X-AKLSUB 0 INF () (STATISTICS true) 
0xadb030 * 1 0 (NAME "Search" MIMETYPE () REMOTEID "" RESOURCE "akonadi_search_resource" MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS (ALL)) ) 
0xadb030 1 OK List completed 
0x7fb5bc001f10 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc001f10 0 LOGIN "kontact-603408820" 
0x7fb5bc001f10 0 OK User logged in 
0x7fb5bc012ba0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc012f80 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc012f80 0 LOGIN "akonadiconsole-CollectionModel-719950939" 
0x7fb5bc013640 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc012f80 0 OK User logged in 
0x7fb5bc023cb0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc023cb0 0 LOGIN "akonadi_kolabproxy_resource" 
0x7fb5bc023cb0 0 OK User logged in 
0x7fb5bc023cb0 1 RESSELECT "akonadi_kolabproxy_resource" 2 X-AKLSUB 0 INF () 
0x7fb5bc023cb0 1 NO akonadi_kolabproxy_resource is not a valid resource identifier 
0x7fb5bc023cb0 2 X-AKLSUB 0 INF () 
0x7fb5bc023cb0 * 1 0 (NAME "Search" MIMETYPE () REMOTEID "" RESOURCE "akonadi_search_resource" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS (ALL)) ) 
0x7fb5bc023cb0 2 OK List completed 
0x7fb5bc023cb0 3 BEGIN 
0x7fb5bc023cb0 3 OK Begin completed 
0x7fb5bc023cb0 4 X-AKLSUB 0 INF (RESOURCE "akonadi_kolabproxy_resource") 
0x7fb5bc023cb0 4 NO Unknown resource 
0x7fb5bc023cb0 5 ROLLBACK 
0x7fb5bc023cb0 5 OK Rollback completed 
0x7fb5bc013640 0 LOGIN "akonadiconsole-ItemModel-1223389481" 
0x15c1ba0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc013640 0 OK User logged in 
0x7fb5bc012ba0 0 LOGIN "akonadi_birthdays_resource" 
0x15c1ba0 0 LOGIN "akonadi_imap_resource_1" 
0x7fb5bc012ba0 0 OK User logged in 
0x15c1ba0 0 OK User logged in 
0x15c1ba0 1 RESSELECT "akonadi_imap_resource_1" 
0x7fb5bc012ba0 1 RESSELECT "akonadi_birthdays_resource" 
0x7fb5bc012ba0 1 NO akonadi_birthdays_resource is not a valid resource identifier 
0x15c1ba0 1 NO akonadi_imap_resource_1 is not a valid resource identifier 
0x15c1ba0 2 BEGIN 
0x15c1ba0 2 OK Begin completed 
0x15c1ba0 3 X-AKLSUB 0 INF (RESOURCE "akonadi_imap_resource_1") 
0x15c1ba0 3 NO Unknown resource 
0x15c1ba0 4 ROLLBACK 
0x15c1ba0 4 OK Rollback completed 


AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/birthdaysresource.desktop' from file 'akonadi_birthdays_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/distlistresource.desktop' from file 'akonadi_distlist_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/icalresource.desktop' from file 'akonadi_ical_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/imapresource.desktop' from file 'akonadi_imap_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/kabcresource.desktop' from file 'akonadi_kabc_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/kcalresource.desktop' from file 'akonadi_kcal_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/knutresource.desktop' from file 'akonadi_knut_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/kolabproxyresource.desktop' from file 'akonadi_kolabproxy_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/localbookmarksresource.desktop' from file 'akonadi_localbookmarks_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/maildirresource.desktop' from file 'akonadi_maildir_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/microblog.desktop' from file 'akonadi_microblog_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/nepomukcontactfeeder.desktop' from file 'akonadi_nepomuk_contact_feeder'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/nepomukemailfeeder.desktop' from file 'akonadi_nepomuk_email_feeder'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/nepomuktagresource.desktop' from file 'akonadi_nepomuktag_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/nntpresource.desktop' from file 'akonadi_nntp_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/notesresource.desktop' from file 'akonadi_notes_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/strigifeeder.desktop' from file 'akonadi_strigi_feeder'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/vcarddirresource.desktop' from file 'akonadi_vcarddir_resource'
AgentManager::updatePluginInfos: Duplicated agent identifier '/usr/share/akonadi/agents/vcardresource.desktop' from file 'akonadi_vcard_resource'
AgentBase(akonadi_kolabproxy_resource): Unknown error. (Unknown resource)
AgentBase(akonadi_imap_resource_1): Unknown error. (Unknown resource)
Comment 5 Dennis Schridde 2009-07-30 10:13:36 UTC 
Even more error messages! :)

Current state: internal db, imap+kolab resources configured.
Removed imap+kolab resources, and then added them back.
Additional info: /contrib is a folder in my imap account.

0x7fb5bc014070 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc014070 0 LOGIN "akonadi_imap_resource_2" 
0x7fb5bc014070 0 OK User logged in 
0x7fb5bc014070 1 RESSELECT "akonadi_imap_resource_2" 
0x7fb5bc014070 1 OK akonadi_imap_resource_2 selected 
0x7fb5bc014070 2 X-AKLSUB 0 1 (RESOURCE "akonadi_imap_resource_2") 
0x7fb5bc014070 2 OK List completed 
0x7fb5bc014070 3 BEGIN 
0x7fb5bc014070 3 OK Begin completed 
0x7fb5bc014070 4 X-AKLSUB 0 INF (RESOURCE "akonadi_imap_resource_2") 
0x7fb5bc014070 4 OK List completed 
0x7fb5bc014070 5 CREATE "<server>/<user>" 0 (MIMETYPE (inode/directory) REMOTEID "imap://<user>@<server>/" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND true LOCALPARTS ())) 
0x7fb5bc014070 * 2 0 (NAME "<server>/<user>" MIMETYPE () REMOTEID "imap://<user>@<server>/" RESOURCE "akonadi_imap_resource_2" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND true LOCALPARTS ()) ) 
0x7fb5bc014070 5 OK CREATE completed 
0x7fb5bc014070 6 CREATE "contrib" 2 (MIMETYPE (message/rfc822 inode/directory) REMOTEID "imap://<user>@<server>/contrib" AccessRights "a" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND true LOCALPARTS ())) 
0x7fb5bc014070 6 NO Parent collection not found 
0x7fb5bc014070 7 ROLLBACK 
0x7fb5bc014070 7 OK Rollback completed 
0x7fb5bc0130e0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc0130e0 0 LOGIN "akonadi_kolabproxy_resource" 
0x7fb5bc0130e0 0 OK User logged in 
0x7fb5bc0130e0 1 RESSELECT "akonadi_kolabproxy_resource" 2 X-AKLSUB 0 INF () 
0x7fb5bc0130e0 1 OK akonadi_kolabproxy_resource selected 
0x7fb5bc0130e0 2 X-AKLSUB 0 INF () 
0x7fb5bc0130e0 * 1 0 (NAME "Search" MIMETYPE () REMOTEID "" RESOURCE "akonadi_search_resource" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS (ALL)) ) 
0x7fb5bc0130e0 2 OK List completed 
0x7fb5bc0130e0 3 BEGIN 
0x7fb5bc0130e0 3 OK Begin completed 
0x7fb5bc0130e0 4 X-AKLSUB 0 INF (RESOURCE "akonadi_kolabproxy_resource") 
0x7fb5bc0130e0 4 OK List completed 
0x7fb5bc0130e0 5 CREATE "akonadi_kolabproxy_resource" 0 (MIMETYPE (inode/directory) REMOTEID "akonadi_kolabproxy_resource" ENTITYDISPLAY "(\"Kolab\" \"kolab\")" CACHEPOLICY (INHERIT true)) 
0x7fb5bc0130e0 * 3 0 (NAME "akonadi_kolabproxy_resource" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "akonadi_kolabproxy_resource" CACHEPOLICY (INHERIT true INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS (ALL)) ) 
0x7fb5bc0130e0 5 OK CREATE completed 
0x7fb5bc0130e0 6 COMMIT 
0x7fb5bc0130e0 6 OK Commit completed 
0x7fb5bc0130e0 7 X-AKLSUB 3 0 () 
0x7fb5bc0130e0 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc0130e0 7 OK List completed 
0x7fb5bc0579d0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc0130e0 8 X-AKLSUB 3 0 () 
0x7fb5bc0130e0 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc0130e0 8 OK List completed 
0x15c00e0 * OK Akonadi Almost IMAP Server [PROTOCOL 15] 
0x7fb5bc001f10 2 X-AKLSUB 3 0 () 
0x7fb5bc0579d0 0 LOGIN "korgac-636708761" 
0x7fb5bc001f10 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc001f10 2 OK List completed 
0x7fb5bc001f10 3 X-AKLSUB 0 0 () 
0x7fb5bc001f10 3 OK List completed 
0x7fb5bc001f10 4 X-AKLSUB 3 0 () 
0x7fb5bc0579d0 0 OK User logged in 
0x7fb5bc0579d0 1 X-AKLSUB 3 0 () 
0x7fb5bc001f10 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc001f10 4 OK List completed 
0x7fb5bc0579d0 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc0579d0 1 OK List completed 
0x7fb5bc0579d0 2 X-AKLSUB 0 0 () 
0x7fb5bc0579d0 2 OK List completed 
0x7fb5bc0579d0 3 X-AKLSUB 3 0 () 
0x15c00e0 0 LOGIN "akonadiconsole-132692233" 
0x15c00e0 0 OK User logged in 
0x7fb5bc0579d0 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc0579d0 3 OK List completed 
0x15c00e0 1 X-AKLSUB 3 0 () 
0x15c00e0 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x15c00e0 1 OK List completed 
0x15c00e0 2 X-AKLSUB 0 0 () 
0x15c00e0 2 OK List completed 
0x15c00e0 3 X-AKLSUB 3 0 () 
0x15c00e0 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x15c00e0 3 OK List completed 
0x7fb5bc012f80 2 X-AKLSUB 3 0 () (STATISTICS true) 
0x7fb5bc012f80 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc012f80 2 OK List completed 
0x7fb5bc012f80 3 X-AKLSUB 3 0 () (STATISTICS true) 
0x7fb5bc012f80 * 3 8246199088285969247 (NAME "7594301998597103899" MIMETYPE () REMOTEID "akonadi_kolabproxy_resource" RESOURCE "" MESSAGES 0 UNSEEN 0 SIZE 0 CACHEPOLICY (INHERIT false INTERVAL -1 CACHETIMEOUT -1 SYNCONDEMAND false LOCALPARTS ()) ) 
0x7fb5bc012f80 3 OK List completed 


AgentBase(akonadi_imap_resource_2): Unknown error. (Parent collection not found)
NotificationManager::notify ( Collection (3, akonadi_kolabproxy_resource) in collection 0 added )
NotificationManager::notify ( Collection (3, akonadi_kolabproxy_resource) in collection 0 modified parts (ENTITYDISPLAY) )
Comment 6 Dennis Schridde 2009-07-30 10:24:31 UTC 
More logs, restarting akonadi from the console, using the last mentioned configuration (internal db, imap+kolab resources), while getting the above mentioned errors in akonadiconsole:

$ akonadictl restart
Starting Akonadi Server...            
   done.                              
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] DbInitializer::run()                                               
[akonadiserver] checking table  "SchemaVersionTable"                               
[akonadiserver] checking table  "ResourceTable"                                    
[akonadiserver] checking table  "CollectionTable"                                  
[akonadiserver] checking table  "MimeTypeTable"                                    
[akonadiserver] checking table  "PimItemTable"                                     
[akonadiserver] checking table  "FlagTable"                                        
[akonadiserver] checking table  "PartTable"                                        
[akonadiserver] checking table  "CollectionAttributeTable"                         
[akonadiserver] checking relation  "PimItemFlagRelation"                           
[akonadiserver] checking relation  "CollectionMimeTypeRelation"                    
[akonadiserver] checking relation  "CollectionPimItemRelation"                     
[akonadiserver] DbInitializer::run() done                                          
[akonadiserver] skipping update 2                                                  
[akonadiserver] skipping update 3                                                  
[akonadiserver] skipping update 4                                                  
[akonadiserver] skipping update 8                                                  
[akonadiserver] skipping update 10                                                 
[akonadiserver] skipping update 12                                                 
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"                    
[akonadiserver] Nepomuk QueryServer interface not available!                       
PLUGINS:  "/usr/share/akonadi/agents"                                              
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
PLUGINS inserting:  "akonadi_birthdays_resource" 0 ("Resource", "Unique")
PLUGINS inserting:  "akonadi_distlist_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_ical_resource" 3 ("Resource")
PLUGINS inserting:  "akonadi_imap_resource" 3 ("Resource")
PLUGINS inserting:  "akonadi_kabc_resource" 1 ("Resource")
PLUGINS inserting:  "akonadi_kcal_resource" 1 ("Resource")
PLUGINS inserting:  "akonadi_knut_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_kolabproxy_resource" 0 ("Resource", "Unique", "NoConfig")
PLUGINS inserting:  "akonadi_localbookmarks_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_maildir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_microblog_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nepomuk_contact_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuk_email_feeder" 0 ("Unique", "NoConfig")
PLUGINS inserting:  "akonadi_nepomuktag_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_nntp_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_notes_resource" 0 ("Resource")
QFileSystemWatcher: failed to add paths: /usr/bin/akonadi_ical_resource
PLUGINS inserting:  "akonadi_strigi_feeder" 0 ("Unique")
PLUGINS inserting:  "akonadi_vcarddir_resource" 0 ("Resource")
PLUGINS inserting:  "akonadi_vcard_resource" 3 ("Resource")
PLUGINS:  "/usr/share/akonadi/agents"
PLUGINS:  ("birthdaysresource.desktop", "distlistresource.desktop", "icalresource.desktop", "imapresource.desktop", "kabcresource.desktop", "kcalresource.desktop", "knutresource.desktop", "kolabproxyresource.desktop", "localbookmarksresource.desktop", "maildirresource.desktop", "microblog.desktop", "nepomukcontactfeeder.desktop", "nepomukemailfeeder.desktop", "nepomuktagresource.desktop", "nntpresource.desktop", "notesresource.desktop", "strigifeeder.desktop", "vcarddirresource.desktop", "vcardresource.desktop")
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Error during insertion into table "CollectionTable" "Duplicate entry '8246199088285969247-7594301998597103899' for key 2 QMYSQL3: Unable to execute statement"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
Comment 7 Dennis Schridde 2009-08-05 08:46:17 UTC 
Splitting the parent-collection-not-found error (comment 5, comment 6) into a seperate bug 202582. (Just ignore the comments here.)
Comment 8 Dennis Schridde 2009-08-05 08:53:10 UTC 
Splitting the resource-not-found-after-database-loss error (comment 4) into a separate bug 202583. (Just ignore the comments here.)
Comment 9 Dennis Schridde 2009-08-05 09:41:20 UTC 
mysql version: 5.0.83
The issue happens after wiping the database (akonadictl stop, rm -r .local/share/akonadi, rm -r .config/akonadi, akonadictl start) and recreating everything, too.
Comment 10 Dennis Schridde 2009-08-05 10:16:49 UTC 
server is running dovecot 1.2.1.
Comment 11 Dennis Schridde 2009-08-07 11:17:01 UTC 
*** Bug 197361 has been marked as a duplicate of this bug. ***
Comment 12 Kevin Ottens 2009-10-17 15:14:58 UTC 
Seems to be the already reported Gentoo related assertion:
http://userbase.kde.org/Akonadi#The_so-called_.22Gentoo-Assert.22

Closing as duplicate.

*** This bug has been marked as a duplicate of bug 202623 ***