| Summary: | mysql query error: deadlock found | ||
|---|---|---|---|
| Product: | [Frameworks and Libraries] Akonadi | Reporter: | Milian Wolff <mail> |
| Component: | general | Assignee: | kdepim bugs <kdepim-bugs> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | CC: | blagozlatev, dvratil, myriam |
| Priority: | NOR | Keywords: | triaged |
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Unlisted Binaries | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
I couldn't reproduce the bug and I weren't able to find a duplicate of it. SHOW ENGINE INNODB STATUS could give hint of what causes the deadlock if you see that again Does this problem still happen with recent versions of Akonadi and KDE PIM? Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 15 days. Please provide the requested information as soon as possible and set the bug status as REPORTED. Due to regular bug tracker maintenance, if the bug is still in NEEDSINFO status with no change in 30 days, the bug will be closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging If you have already provided the requested information, please set the bug status as REPORTED so that the KDE team knows that the bug is ready to be confirmed. Thank you for helping us make KDE software even better for everyone! Dear Bug Submitter, This bug has been in NEEDSINFO status with no change for at least 30 days. The bug is now closed as RESOLVED > WORKSFORME due to lack of needed information. For more information about our bug triaging procedures please read the wiki located here: https://community.kde.org/Guidelines_and_HOWTOs/Bug_triaging Thank you for helping us make KDE software even better for everyone! |
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