[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-pim
Subject:    [Kde-pim] Database error when syncing collections from KMail
From:       Kevin Krammer <kevin.krammer () gmx ! at>
Date:       2010-07-15 10:57:59
Message-ID: 201007151258.04952.kevin.krammer () gmx ! at
[Download RAW message or body]

[Attachment #2 (multipart/signed)]

[Attachment #4 (multipart/mixed)]


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

["log.txt" (text/plain)]

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


["signature.asc" (application/pgp-signature)]

_______________________________________________
KDE PIM mailing list kde-pim@kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/

[prev in list] [next in list] [prev in thread] [next in thread]