[Bug 273445] New: Unable to add downloaded emails from POP3 server to MySQL storage

[Christoph Berg]

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

           Summary: Unable to add downloaded emails from POP3 server to
                    MySQL storage
           Product: Akonadi
           Version: 1.5.3
          Platform: Unlisted Binaries
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: NOR
         Component: POP3 Resource
        AssignedTo: mcguire at kde.org
        ReportedBy: Christoph.Berg at kpm-sport.de
                CC: vkrause at kde.org, kdepim-bugs at kde.org


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

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