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@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@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@mail.kde.org", "quanta-owner@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@physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>, "all-owner@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@physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>, "all-owner@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@mail.kde.org", "quanta-owner@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