[Akonadi] [Bug 399167] Akonadi enters deadlock state which makes it completely unuseable

[Milian Wolff]

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

--- Comment #12 from Milian Wolff <mail at milianw.de> ---
ok, that cleanup didn't help for long... First I got spammed by hundreds of
lines of:

  1281.968 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:152]:
Error:  "No such file or directory"
  1281.970 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:151]:
Payload file  "/home/milian/.local/share/akonadi/file_db_data/94/1670294_r1" 
could not be open for reading!
  1281.970 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:152]:
Error:  "No such file or directory"
  1281.971 warning:
org.kde.pim.akonadiprivate/Akonadi::ExternalPartStorage::replayTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/private/externalpartstorage.cpp:326]:
Warning: failed to remove
"/home/milian/.local/share/akonadi/file_db_data/93/1670293_r1" while committing
a transaction
  1281.971 warning:
org.kde.pim.akonadiprivate/Akonadi::ExternalPartStorage::replayTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/private/externalpartstorage.cpp:326]:
Warning: failed to remove
"/home/milian/.local/share/akonadi/file_db_data/94/1670294_r1" while committing
a transaction
  1281.979 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:151]:
Payload file  "/home/milian/.local/share/akonadi/file_db_data/96/1670296_r1" 
could not be open for reading!
  1281.979 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:152]:
Error:  "No such file or directory"
  1281.981 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:151]:
Payload file  "/home/milian/.local/share/akonadi/file_db_data/97/1670297_r1" 
could not be open for reading!
  1281.981 critical:
org.kde.pim.akonadiserver/Akonadi::Server::PartHelper::translateData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/parthelper.cpp:152]:
Error:  "No such file or directory"
  1281.982 warning:
org.kde.pim.akonadiprivate/Akonadi::ExternalPartStorage::replayTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/private/externalpartstorage.cpp:326]:
Warning: failed to remove
"/home/milian/.local/share/akonadi/file_db_data/96/1670296_r1" while committing
a transaction
  1281.982 warning:
org.kde.pim.akonadiprivate/Akonadi::ExternalPartStorage::replayTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/private/externalpartstorage.cpp:326]:
Warning: failed to remove
"/home/milian/.local/share/akonadi/file_db_data/97/1670297_r1" while committing
a transaction

and finally I reached:

  1331.367 warning:
org.kde.pim.akonadiserver/Akonadi::Server::QueryBuilder::exec[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/querybuilder.cpp:435]:
"Deadlock found when trying to get lock; try restarting transaction QMYSQL3:
Unable to store statement results"
  1331.515 critical:
org.kde.pim.akonadiserver/Akonadi::Server::DataStore::retryLastTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/datastore.cpp:1426]:
DATABASE ERROR when retrying transaction
  1331.515 critical:
org.kde.pim.akonadiserver/Akonadi::Server::DataStore::retryLastTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/datastore.cpp:1427]:
  Error code: "1062"
  1331.515 critical:
org.kde.pim.akonadiserver/Akonadi::Server::DataStore::retryLastTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/datastore.cpp:1428]:
  DB error:  "Duplicate entry '615495-5' for key
'PartTable_pimItemIdTypeIndex'"
  1331.515 critical:
org.kde.pim.akonadiserver/Akonadi::Server::DataStore::retryLastTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/datastore.cpp:1429]:
  Error text: "Duplicate entry '615495-5' for key
'PartTable_pimItemIdTypeIndex' QMYSQL3: Unable to execute statement"
  1331.516 critical:
org.kde.pim.akonadiserver/Akonadi::Server::DataStore::retryLastTransaction[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/storage/datastore.cpp:1430]:
  Query: "INSERT INTO PartTable (pimItemId, partTypeId, data, datasize,
version, storage) VALUES (?, ?, ?, ?, ?, ?)"
  1331.516 warning:
org.kde.pim.akonadiserver/Akonadi::Server::Connection::handleIncomingData[/home/milian/projects/kf5/src/kde/pim/akonadi/src/server/connection.cpp:283]:
Error while handling command CreateItem on connection akonadi_imap_resource_3
(0x557ffe691720)
  1205.189 warning:
org.kde.pim.akonadicore/Akonadi::ItemSyncPrivate::slotLocalChangeDone[/home/milian/projects/kf5/src/kde/pim/akonadi/src/core/itemsync.cpp:443]:
Creating/updating items from the akonadi database failed: "Failed to query
database for item"
  1205.189 warning:
org.kde.pim.akonadicore/Akonadi::ItemSync::slotResult[/home/milian/projects/kf5/src/kde/pim/akonadi/src/core/itemsync.cpp:499]:
Error during ItemSync:  "Failed to query database for item"
  1205.280 warning:
org.kde.pim.imapresource/RetrieveItemsTask::prepareRetrieval[/home/milian/projects/kf5/src/kde/pim/kdepim-runtime/resources/imap/retrieveitemstask.cpp:474]:
Detected inconsistency in local cache, we're missing some messages. Server: 
4014  Local:  3935
  1205.281 warning:
org.kde.pim.imapresource/RetrieveItemsTask::prepareRetrieval[/home/milian/projects/kf5/src/kde/pim/kdepim-runtime/resources/imap/retrieveitemstask.cpp:475]:
Refetching complete mailbox.

looking at the item table, I once again have 46 items without a part in them...
So I seem to be able to trigger this quite reliably, I'm afraid :(

-- 
You are receiving this mail because:
You are the assignee for the bug.