[Kde-pim] Database error when syncing collections from KMail

[Kevin Krammer]

I am getting a weird database timeout error when syncing collections due to 
clicking on folders in KMail.

[akonadiserver] Error during executing query "UPDATE PimItemTable SET atime = 
:0 WHERE ( ( PimItemTable.id >= :1 ) AND collectionId = :2 )" :  "Lock wait 
timeout exceeded; try restarting transaction QMYSQL3: Unable to execute 
statement"
[akonadiserver] Unable to update item access time

See attached log for the full sequence, annotated with what I did between 
different output sections.

When not syncing with Akonadiconsole first, i.e. doing the initial item sync 
from KMail, the timeout message is a bit different.
The Jobtracker says that the ItemSync's ItemModifyJob timed out.

Cheers,
Kevin

-- 
Kevin Krammer, KDE developer, xdg-utils developer
KDE user support, developer mentoring
-------------- next part --------------
Clicking on outbox folder in Akonadi console

 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItems: job= 0x92c49c8 collection= "outbox"
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MaildirContext::readIndexData: Maildir "new" directory newer than the index: cur modified at QDateTime("Do. Jul 15 10:54:40 2010") , index modified at QDateTime("Mi. Jul 14 18:47:59 2010")
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: job= 0x92c49c8 error= 0
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: calling itemsRetrieved with 1 items
[/dvl/kde/branches/4.5/install/bin/akonadi_maildispatcher_agent] akonadi_maildispatcher_agent(18101)/kdecore (KSycoca) KSycocaPrivate::openDatabase: Trying to open ksycoca from  "/home/kevin/.test45branch/.kde/cache-artemis/ksycoca4"
[/dvl/kde/branches/4.5/install/bin/akonadi_nepomuk_contact_feeder] akonadi_nepomuk_contact_feeder(18102)/kdecore (KSycoca) KSycocaPrivate::openDatabase: Trying to open ksycoca from  "/home/kevin/.test45branch/.kde/cache-artemis/ksycoca4"
[akonadiserver] posting retrieval request for item 3  there are  1  queues and  0  items in mine
[akonadiserver] checking if request for item 3 has been processed...
[akonadiserver] request for item 3 still pending - waiting
[akonadiserver] processing retrieval request for item 3  parts: ("RFC822")  of resource: "akonadi_mixedmaildir_resource_7"
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItem: job= 0x8d47cd0 item= 3 collection= "outbox"
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemResult: job= 0x8d47cd0 error= 0
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemResult: calling itemRetrieved with item 3
[akonadiserver] continuing
[akonadiserver] checking if request for item 3 has been processed...
[akonadiserver] request for item 3 processed, error: ""

Starting KMail

[akonadiserver] Database "akonadi" opened using driver "QMYSQL"
[akonadiserver] Database "akonadi" opened using driver "QMYSQL"

Clicking on outbox folder in KMail (it is being synchronized twice?)

 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItems: job= 0x9029f38 collection= "outbox"
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: job= 0x9029f38 error= 0
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: calling itemsRetrieved with 1 items
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItems: job= 0x8b69ce8 collection= "outbox"
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: job= 0x8b69ce8 error= 0
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir)
 MixedMaildirResource::retrieveItemsResult: calling itemsRetrieved with 1 items

[akonadiserver] Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id >= :1 ) AND collectionId = :2 )" :  "Lock wait timeout exceeded; try restarting transaction QMYSQL3: Unable to execute statement"
[akonadiserver] Unable to update item access time

Then, after some time, synchronizing again.

 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItems: job= 0x92e91d0 collection= "outbox"
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: job= 0x92e91d0 error= 0
 akonadi_mixedmaildir_resource_7(18122)/akonadiresource (maildir) MixedMaildirResource::retrieveItemsResult: calling itemsRetrieved with 1 items
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 190 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kde-pim/attachments/20100715/0edf9e25/attachment.sig>
-------------- next part --------------
_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/