[Akonadi] [Bug 397316] New: akonadi loses connection with IMAP server after suspend (but not only, DB error too)

[bugzilla_noreply at kde.org]

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-bugs at kde.org
          Reporter: yves.caniou at 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 the assignee for the bug.