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@kde.org ReportedBy: m...@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...@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...@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-ow...@mail.kde.org", "quanta-ow...@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-ow...@physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>, "all-ow...@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-ow...@physik.fu-berlin.de"^^<http://www.w3.org/2001/XMLSchema#string>, "all-ow...@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-ow...@mail.kde.org", "quanta-ow...@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. _______________________________________________ Kdepim-bugs mailing list Kdepim-bugs@kde.org https://mail.kde.org/mailman/listinfo/kdepim-bugs