[Bug 287834] New: mysql query error: deadlock found

[Milian Wolff]

https://bugs.kde.org/show_bug.cgi?id=287834

           Summary: mysql query error: deadlock found
           Product: Akonadi
           Version: unspecified
          Platform: Unlisted Binaries
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: NOR
         Component: general
        AssignedTo: kdepim-bugs at kde.org
        ReportedBy: mail at milianw.de


Version:           unspecified
OS:                Linux

I just saw this message on the cli, it was not even a warning:

Error during executing query "UPDATE PimItemTable, CollectionTable SET atime =
:0 WHERE ( PimItemTable.remoteId = ( :1 ) AND CollectionTable.resourceId = :2
AND ( PimItemTable.collectionId = CollectionTable.id ) )" :  "Deadlock found
when trying to get lock; try restarting transaction QMYSQL3: Unable to execute
statement" 
Unable to update item access time 

Personally I think such issues should shown, if not to the user, then at least
in a debug build to the developer...

I have no idea what triggered it though, here is some more lines of the cli
log.

posting retrieval request for item 60239  there are  1  queues and  0  items in
mine 
request for item 60239 still pending - waiting 
processing retrieval request for item 60239  parts: ("ENVELOPE")  of resource:
"akonadi_imap_resource_2" 
akonadi_imap_resource_2(19265)/libakonadi Akonadi::ResourceBase::itemRetrieved:
Item does not provide part "ENVELOPE" 
continuing 
request for item 60239 succeeded 
posting retrieval request for item 60241  there are  1  queues and  0  items in
mine 
request for item 60241 still pending - waiting 
processing retrieval request for item 60241  parts: ("ENVELOPE")  of resource:
"akonadi_imap_resource_2" 
akonadi_imap_resource_2(19265)/libakonadi Akonadi::ResourceBase::itemRetrieved:
Item does not provide part "ENVELOPE" 
continuing 
request for item 60241 succeeded 
posting retrieval request for item 60242  there are  1  queues and  0  items in
mine 
request for item 60242 still pending - waiting 
processing retrieval request for item 60242  parts: ("ENVELOPE")  of resource:
"akonadi_imap_resource_2" 
akonadi_imap_resource_2(19265)/libakonadi Akonadi::ResourceBase::itemRetrieved:
Item does not provide part "ENVELOPE" 
continuing 
request for item 60242 succeeded 
posting retrieval request for item 60160  there are  1  queues and  0  items in
mine 
processing retrieval request for item 60160  parts: ("ENVELOPE")  of resource:
"akonadi_imap_resource_2" 
request for item 60160 still pending - waiting 
akonadi_imap_resource_2(19265)/libakonadi Akonadi::ResourceBase::itemRetrieved:
Item does not provide part "ENVELOPE" 
continuing 
request for item 60160 succeeded 
kmail2(19205) MessageList::Core::ModelPrivate::findMessageParent: Circular
In-Reply-To reference loop detected in the message tree 
kmail2(19205) MessageViewer::Util::fileNameForMimetype: unknown mimetype "" 
void Nepomuk::Query::QueryServiceClient::close() 
void Nepomuk::Query::QueryServiceClient::close() 
kmail2(19205) MessageViewer::Util::fileNameForMimetype: unknown mimetype "" 
37994 FLAGS ($ATTACHMENT \Seen)
37994 FLAGS ($ATTACHMENT \Seen $JUNK)
37994 +FLAGS (\Deleted)
void Nepomuk::Query::QueryServiceClient::close() 
akonadi_pop3_resource_0(19273)/kio (KIOJob) KIO::TransferJob::slotData:
mimeType() not emitted when sending first data!; job URL =
KUrl("pop3://mail%40milianw.de at pop3.milianw.de:110/index") data size = 8 
akonadi_pop3_resource_0(19273)/kio (KIOJob) KIO::TransferJob::slotData:
mimeType() not emitted when sending first data!; job URL =
KUrl("pop3://mail%40milianw.de at pop3.milianw.de:110/uidl") data size = 20 
found 2 item parts to expire in collection "spam" 
akonadi_nepomuk_feeder(19271) ItemQueue::jobResult:
"http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel has a max
cardinality of 1. Provided 2 values - "quanta-owner at mail.kde.org",
"quanta-owner at mail.kde.org"" 
40041 +FLAGS (\Deleted)
40042 +FLAGS (\Deleted)
akonadi_nepomuk_feeder(19271) ItemQueue::jobResult:
"http://www.semanticdesktop.org/ontologies/2007/03/22/nco#emailAddress has a
max cardinality of 1. Provided 2 values -
"all-owner at physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>,
"all-owner at physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>" 
40044 +FLAGS (\Deleted)
akonadi_nepomuk_feeder(19271) ItemQueue::jobResult:
"http://www.semanticdesktop.org/ontologies/2007/03/22/nco#emailAddress has a
max cardinality of 1. Provided 2 values -
"all-owner at physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>,
"all-owner at physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>" 
kmail2(19205)
MessageList::Core::ModelInvariantRowMapperPrivate::modelIndexRowToModelInvariantIndexInternal:
Requested invariant for storage row index  7646  not found in history 
kmail2(19205)
MessageList::Core::ModelInvariantRowMapperPrivate::modelIndexRowToModelInvariantIndexInternal:
Requested invariant for storage row index  7647  not found in history 
akonadi_nepomuk_feeder(19271) ItemQueue::jobResult:
"http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel has a max
cardinality of 1. Provided 2 values - "David Faure", "David Faure"" 
akonadi_mailfilter_agent(19268): Error while moving items.  103 "Unknown error.
(No items found)"  to destinationCollection.id() : 71 
akonadi_nepomuk_feeder(19271) ItemQueue::jobResult:
"http://www.semanticdesktop.org/ontologies/2007/08/15/nao#prefLabel has a max
cardinality of 1. Provided 2 values - "quanta-owner at mail.kde.org",
"quanta-owner at mail.kde.org"" 
void Nepomuk::Query::QueryServiceClient::close() 
38007 FLAGS (\Seen)
kmail2(19205)
MessageList::Core::ModelInvariantRowMapperPrivate::modelIndexRowToModelInvariantIndexInternal:
Requested invariant for storage row index  7657  not found in history 
kmail2(19205)
MessageList::Core::ModelInvariantRowMapperPrivate::modelIndexRowToModelInvariantIndexInternal:
Requested invariant for storage row index  7658  not found in history 
kmail2(19205)
MessageList::Core::ModelInvariantRowMapperPrivate::modelIndexRowToModelInvariantIndexInternal:
Requested invariant for storage row index  7659  not found in history 
Error during executing query "UPDATE PimItemTable, CollectionTable SET atime =
:0 WHERE ( PimItemTable.remoteId = ( :1 ) AND CollectionTable.resourceId = :2
AND ( PimItemTable.collectionId = CollectionTable.id ) )" :  "Deadlock found
when trying to get lock; try restarting transaction QMYSQL3: Unable to execute
statement" 
Unable to update item access time 


Reproducible: Didn't try

Steps to Reproduce:
not sure, I started kmail2 from the cli which in turn started up akonadi

Actual Results:  
above query error

Expected Results:  
no query error

-- 
Configure bugmail: https://bugs.kde.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.