https://bugs.kde.org/show_bug.cgi?id=397316
Bug ID: 397316 Summary: akonadi loses connection with IMAP server after suspend (but not only, DB error too) Product: Akonadi Version: unspecified Platform: Gentoo Packages OS: Linux Status: UNCONFIRMED Severity: normal Priority: NOR Component: IMAP resource Assignee: kdepim-b...@kde.org Reporter: yves.can...@ens-lyon.fr Target Milestone: --- Hi, I have redundant problems with kmail/akonadi, see: https://bugs.gentoo.org/661856 kmail shows it contacts IMAPS server (progression bar), but actually does not or does not show newer mails. And access to mails (even local) can be [too] long (minutes): I have to make many akonadictl fsck/restart, and each time, konsole reports a lot of errors. Many errors such as: Cleaning up missing external file: /home/ycaniou/.local/share/akonadi/file_db_data/47/794047_r0 for item: 218189 on part: 794047 org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "" org.kde.pim.akonadicore: "" org.kde.pim.akonadicore: Creating/updating items from the akonadi database failed: "Multiple merge candidates, aborting" org.kde.pim.akonadicore: Error during ItemSync: "Multiple merge candidates, aborting" org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1205" org.kde.pim.akonadiserver: DB error: "Lock wait timeout exceeded; try restarting transaction" org.kde.pim.akonadiserver: Error text: "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" org.kde.pim.akonadiserver: Query: "UPDATE PimItemTable SET atime = ? WHERE ( ( PimItemTable.id = ? ) )" org.kde.pim.akonadiserver: Unable to update item access time org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1205" org.kde.pim.akonadiserver: DB error: "Lock wait timeout exceeded; try restarting transaction" org.kde.pim.akonadiserver: Error text: "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" org.kde.pim.akonadiserver: Query: "UPDATE PimItemTable SET rev = ?, remoteId = ?, remoteRevision = ?, gid = ?, collectionId = ?, mimeTypeId = ?, datetime = ?, atime = ?, dirty = ?, size = ? WHERE ( id = ? )" org.kde.pim.akonadiserver: Error during updating record with id 218741 in table "PimItemTable" "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" org.kde.pim.akonadiserver: Error during updating record with id 794048 in table "PartTable" "Driver not loaded Driver not loaded" Cleaning up missing external file: /home/ycaniou/.local/share/akonadi/file_db_data/50/794050_r0 for item: 218190 on part: 794050 org.kde.pim.akonadiserver: Error during updating record with id 794050 in table "PartTable" "Driver not loaded Driver not loaded" Cleaning up missing external file: /home/ycaniou/.local/share/akonadi/file_db_data/51/794051_r0 for item: 218190 on part: 794051 Found duplicates 60 org.kde.pim.akonadiserver: DATABASE ERROR: org.kde.pim.akonadiserver: Error code: "1064" org.kde.pim.akonadiserver: DB error: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1" org.kde.pim.akonadiserver: Error text: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND PartTable.storage = 1 )' at line 1 QMYSQL: Unable to execute query" org.kde.pim.akonadiserver: Query: "SELECT PartTable.id, PartTable.pimItemId, PartTable.partTypeId, PartTable.data, PartTable.datasize, PartTable.version, PartTable.storage FROM PartTable WHERE ( PartTable.pimItemId IN ( ) AND PartTable.storage = :0 )" Error while deleting duplicates Driver not loaded Driver not loaded Let me know what I can do to help. -- You are receiving this mail because: You are watching all bug changes.