Summary: | 'QMYSQL3: Unable to execute statement' errors | ||
---|---|---|---|
Product: | [Frameworks and Libraries] Akonadi | Reporter: | Sérgio Basto <sergio> |
Component: | general | Assignee: | kdepim bugs <kdepim-bugs> |
Status: | RESOLVED FIXED | ||
Severity: | major | CC: | dvratil, montel, rdieter, sven.burmeister |
Priority: | NOR | ||
Version: | 4.7 | ||
Target Milestone: | --- | ||
Platform: | Fedora RPMs | ||
OS: | Linux | ||
Latest Commit: | Version Fixed In: | ||
Sentry Crash Report: |
Description
Sérgio Basto
2011-11-14 09:18:15 UTC
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. |