[Akonadi] [Bug 452958] akonadi's mysql locked with an extraneous SELECT query after resuming from sleep

[Ricardo J. Barberis]

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

--- Comment #2 from Ricardo J. Barberis <ricardo.barberis at gmail.com> ---
Trying to stop akonadi:

$ akonadictl stop

$ akonadictl status
Akonadi Control: running
Akonadi Server: running
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent,
akonadi_birthdays_resource, akonadi_contacts_resource,
akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource,
akonadi_followupreminder_agent, akonadi_google_resource, akonadi_ical_resource,
akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent,
akonadi_knut_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent,
akonadi_mailfilter_agent, akonadi_mailmerge_agent, akonadi_mbox_resource,
akonadi_migration_agent, akonadi_mixedmaildir_resource,
akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource,
akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent,
akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent,
akonadi_vcard_resource, akonadi_vcarddir_resource

$ akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_archivemail_agent,
akonadi_birthdays_resource, akonadi_contacts_resource,
akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource,
akonadi_followupreminder_agent, akonadi_google_resource, akonadi_ical_resource,
akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent,
akonadi_knut_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent,
akonadi_mailfilter_agent, akonadi_mailmerge_agent, akonadi_mbox_resource,
akonadi_migration_agent, akonadi_mixedmaildir_resource,
akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource,
akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_sendlater_agent,
akonadi_tomboynotes_resource, akonadi_unifiedmailbox_agent,
akonadi_vcard_resource, akonadi_vcarddir_resource

$ mysqladmin --socket=/run/user/1000/akonadi/mysql.socket processlist -v
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local server through socket
'/run/user/1000/akonadi/mysql.socket' (2)'
Check that mariadbd is running and that the socket:
'/run/user/1000/akonadi/mysql.socket' exists!

$ ps faxu | grep -v grep | grep akonadi
<MY_USER>    2518  0.9  1.3 4192940 217156 ?      Sl   abr24  10:07
/usr/libexec/mysqld
--defaults-file=/home/<MY_USER>/.local/share/akonadi/mysql.conf
--datadir=/home/<MY_USER>/.local/share/akonadi/db_data/
--socket=/run/user/1000/akonadi/mysql.socket
--pid-file=/run/user/1000/akonadi/mysql.pid

$ kill -9 2518

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