Version: 4.7 (using KDE 4.7.3) OS: Linux after upgrade Fedora from 15 to 16 which upgrade kde from 4.6 to 4.7, my email is a totally mess. I read http://userbase.kde.org/Akonadi_4.4/Troubleshooting which suggest clean ~/.local/share/akonadi/db_data or ~/.local/share/akonadi/ when I do it any emails shows up. with my old db_data, I got Error during executing query "UPDATE PimItemTable, CollectionTable SET atime = :0 WHERE ( PimItemTable.remoteId = ( :1 ) AND CollectionTable.resourceId = :2 AND ( PimItemTable.collectionId = CollectionTable.id ) )" : "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" Unable to update item access time Error during executing query "UPDATE PimItemTable, CollectionTable SET atime = :0 WHERE ( PimItemTable.remoteId = ( :1 ) AND CollectionTable.resourceId = :2 AND ( PimItemTable.collectionId = CollectionTable.id ) )" : "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" Unable to update item access time mail synchronize stuck , Retrieving Folder Contents Please wait . . . mysql seems out of date, mysql.err: [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure Reproducible: Always Steps to Reproduce: open kontact Actual Results: no mail Expected Results: have mail
after Unable to update item access time: I got request for item 35009 "1254935989.2633.aYYHK" failed: "Unable to retrieve item from resource: Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken." ItemRetrieverException : Unable to retrieve item from resource: Did not receive a reply. Possible causes include: the remote application did not send a reply, the message bus security policy blocked the reply, the reply timeout expired, or the network connection was broken.
to get rid of mysql.err: [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure I have stop akonadi and move mv .local/share/akonadi/ ak_back/ and appears this message: Error during updating record with id 39 in table "PimItemTable" "Deadlock found when trying to get lock; try restarting transaction QMYSQL3: Unable to execute statement"
I put old .local/share/akonadi/ and after restart akonadi I do : mysql_upgrade --socket=/home/$USER/.local/share/akonadi/socket-$host/mysql.socket which end up: Running 'mysql_fix_privilege_tables'... OK and fix "wrong structure" mysql.err: [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure the mail almost all appears, but still see: Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id = :1 OR PimItemTable.id = :2 OR ( PimItemTable.id >= :3 AND PimItemTable.id <= :4 ) ) )" : "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" . which to me seems to be the problem .
other: Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE ( collectionId = :1 )" : "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement" Unable to update item access time system mysql is : mysql-5.5.16-3.fc16.x86_64
ok , I found the problem , and the problem on migration, is not kmail maildir, is a local Folder, when I switch local folder to ~/.kde/share/apps/kmail/mail, instead have a ~/.local/share/local-mail and a resource kmail folder with ~/.kde/share/apps/kmail/mail. - fix your local filters, if you had any I have 30 and folder expired , none of the filters was correct and expired folder expired others folders than that should, I lose some mails that I don't want to, but hope that was nothing important. So, backup your mail folders (~/.kde/share/apps/kmail/mail) before change it to local folders. backup (or move) ~/.config/akonadi/ and ~/.kde/share/config/akonadi* and build akanodi resources again. 4 days without mail, and to find out that local folders are where are my emails via POP3.
(In reply to comment #5) > ok , I found the problem , and the problem on migration, is not kmail maildir, > is a local Folder, when I switch local folder to ~/.kde/share/apps/kmail/mail, > instead have a ~/.local/share/local-mail > and a resource kmail folder with ~/.kde/share/apps/kmail/mail. Could you please write that again. I do not understand what the problem was.
(In reply to comment #6) > (In reply to comment #5) > > ok , I found the problem , and the problem on migration, is not kmail maildir, > > is a local Folder, when I switch local folder to ~/.kde/share/apps/kmail/mail, > > instead have a ~/.local/share/local-mail > > and a resource kmail folder with ~/.kde/share/apps/kmail/mail. > > Could you please write that again. I do not understand what the problem was. Migration puts my mail in a resource "kmail folder", but the resource should be "local Folder" . so delete resource "kmail folder" and change resource "local Folder" to have your email. after backup email, of course .
*** This bug has been marked as a duplicate of bug 286711 ***
(Sorry, this is not a duplicate, I clicked a wrong tab)
Hi, I Close this bug since , with fix in Current release since ages don't see this bug ?
Hi, can I Close this bug ? with fix in Current release, since ages don't see this bug ?
Closed. Please reopen if you hit the problem in future again.