Version: 1.5.3 (using KDE 4.6.2) OS: Linux Since testing the new KDEPIM package at beta5 (currently using rc1), I'm unable to properly retrieve emails the one of my accounts using a POP3 server with SSL. I use Akonadi with an external MySQL 5.5.12 server, KDE 4.6.3 and Qt 4.7.3. When starting kmail2 on the console, I get the following output: Known subscriber "kmail2" subscribes again Known subscriber "kmail2" subscribes again Database "akonadi" opened using driver "QMYSQL" Database "akonadi" opened using driver "QMYSQL" Known subscriber "kmail2" subscribes again Known subscriber "kmail2" subscribes again akonadi_imap_resource_2(30884)/kdecore (KConfigSkeleton) KCoreConfigSkeleton::writeConfig: akonadi_pop3_resource_3(30890)/kio (KIOJob) KIO::TransferJob::slotData: mimeType() not emitted when sending first data!; job URL = KUrl("pop3s://****.****%40***-***.de@sslmailpool.ispgateway.de:995/uidl:995/index") data size = 11 akonadi_pop3_resource_3(30890)/kio (KIOJob) KIO::TransferJob::slotData: mimeType() not emitted when sending first data!; job URL = KUrl("pop3s://****.****%40***-***.de@sslmailpool.ispgateway.de:995/uidl") data size = 59 Error during executing query "INSERT INTO PartTable (pimItemId, name, data, datasize, version, external) VALUES (:0, :1, :2, :3, :4, :5)" : "Lost connection to MySQL server during query QMYSQL3: Unable to execute statement" Error during insertion into table "PartTable" "Lost connection to MySQL server during query QMYSQL3: Unable to execute statement" Database error: DataStore::rollbackTransaction Last driver error: "QMYSQL: Unable to rollback transaction" Last database error: "MySQL server has gone away" akonadi_pop3_resource_3(30890)/akonadiresource (pop3) POP3Resource::cancelSync: ============== ERROR DURING POP3 SYNC ========================== akonadi_pop3_resource_3(30890)/akonadiresource (pop3) POP3Resource::cancelSync: "Unable to store downloaded mails. Unknown error. (Append failed)" I tried debugging the problem, but only got so far to notice that the job instance in POP3Resource::itemCreateJobResult resulted in an error. I can recompile kdelibs with debugging support, if it helps diagnosing the problem. Reproducible: Always
can you run akonadictl restart and paste the output please
Created attachment 60131 [details] logfile of akonadictl restart Attached as requested is the logfile created by capturing akonadictl's output after a restart.
Another update of what I found out, when trying to download emails: The first email has a few images being in sum ca. 1.4 MB. If I choose synchronise for my POP3 ressource in the Akonadi Console programm, I can see the total of emails being downloaded and the KB counter rises. When it reaches 1.4 MB it just stops and prints the above mentioned warning. So I guess, it must have something to do with downloading emails having attachments.
do you have a 'ExternalPayload=false' in ~/.config/akonadi/akonadiserverrc ? if you do, stop the akonadi server, remove this line and restart it
Yep, I had this line in my ~/.config/akonadi/akonadiserverrc. After following your instructions, everything works fine. So, was this a leftover from an older version?
I had the same problem with Akonadi and POP3 mail and removing 'ExternalPayload=false' from ~/.config/akonadi/akonadiserverrc seems to have fixed it for me as well.
Ah, I see, that was a bug in akonadi server which has recently been fixed, see http://commits.kde.org/akonadi/defb52abc51ba60544257c91895fc29ff9af8dff. Removing 'ExternalPayload=false' is a good workaround.