[Akonadi] [Bug 340813] sometimes two copies of mysqld are running with Akonadi

Martin Steigerwald ms at teamix.de
Thu Mar 5 09:12:08 GMT 2015


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

--- Comment #7 from Martin Steigerwald <ms at teamix.de> ---
Okay, I think I got a hint today on why it might not finished MySQL properly.
Today I got connection losses with Exchange again (its seems quite easy to
trigger these, I am at the moment using archivemail to reduce amount of mails
on the server to see whether it may help). And to bring things back up I
stopped Akonadi with the intention to start it again. Yet on stopping I got:

ms at merkaba:~> tail -f ~/.xsession-errors
Executing search "kmail2-1312955980-SearchSession" 
Search done "kmail2-1312955980-SearchSession" (without remote search) 
        Result: 0 matches 
posting retrieval request for item 1890571  there are  1  queues and  0  items
in mine 
request for item 1890571 still pending - waiting 
processing retrieval request for item 1890571  parts: ("RFC822")  of resource:
"akonadi_imap_resource_0" 
QFileSystemWatcher: failed to add paths:
/home/ms/.kde/share/config/activitymanager-pluginsrc
konsole(3229) Konsole::Session::run: Attempted to re-run an already running
session. 
konsole(3229) Konsole::Session::run: Attempted to re-run an already running
session. 
akonadi_imap_resource_0(3221) ChangeItemsFlagsTask::onSelectDone: Select
failed:  "Die Verbindung zum Server ist abgebrochen." 

This is up to the connection loss I think. "Die Verbindung zum Server ist
abgebrochen" means "the connection to the server aborted"

Then I stop akonadi with akonadictl stop and get:

X Error: BadWindow (invalid Window parameter) 3
  Major opcode: 2 (X_ChangeWindowAttributes)
  Resource id:  0x221afce
QFileSystemWatcher: failed to add paths:
/home/ms/.kde/share/config/activitymanager-pluginsrc
QFileSystemWatcher: failed to add paths:
/home/ms/.kde/share/config/activitymanager-pluginsrc
QFileSystemWatcher: failed to add paths:
/home/ms/.kde/share/config/activitymanager-pluginsrc
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_contacts_resource_0" , discarding
cached interface 
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_akonotes_resource_0" , discarding
cached interface 
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_akonotes_resource_1" , discarding
cached interface 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "AkonadiAgentServer_3218_fhsA1R" now serving: () 
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_icaldir_resource_0" , discarding
cached interface 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "AkonadiAgentServer_3214_GN8Sxx" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_maildispatcher_agent_3225_ScB4Dq" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_maildispatcher_agent_3225_B0L8JT" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_maildispatcher_agent_3225_ietFlF" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_migration_agent_3227_ndcikE" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "AkonadiAgentServer_3215_D1kzHt" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_icaldir_resource_0_3220_eX2EKU" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_followupreminder_agent_3219_2ncps7" now serving:
() 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_notes_agent_3230_1JJLlc" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_notes_agent_3230_OLDXpN" now serving: () 
Application '/usr/bin/akonadi_sendlater_agent' exited normally...
Application '/usr/local/bin/akonadi_agent_launcher' exited normally...
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_sendlater_agent_3231_VHVu4n" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "AkonadiAgentServer_3223_mmVsO9" now serving: () 
Unregistering search instance "akonadi_imap_resource_1" 
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_maildir_resource_0" , discarding
cached interface 
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_imap_resource_1" , discarding cached
interface 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_imap_resource_1_3222_X2bKII" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_mailfilter_agent_3226_Wh4lFI" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_mailfilter_agent_3226_bbfMOe" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_mailfilter_agent_3226_wkptgo" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_mailfilter_agent_3226_ukXz5K" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_newmailnotifier_agent_3228_6sBmRQ" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_newmailnotifier_agent_3228_0WUgjM" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_archivemail_agent_3216_SLxcKa" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_archivemail_agent_3216_3uG0RH" now serving: () 
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_archivemail_agent_3216_bbIJIP" now serving: () 
Application '/usr/bin/akonadi_baloo_indexer' exited normally...
Application '/usr/bin/akonadi_followupreminder_agent' exited normally...
Application '/usr/local/bin/akonadi_agent_launcher' exited normally...
Application '/usr/local/bin/akonadi_maildispatcher_agent' exited normally...
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_baloo_indexer_3217_8C5pnp" now serving: () 
ProcessControl: Application /usr/local/bin/akonadi_imap_resource stopped
unexpectedly ( "Process crashed" )
Application '/usr/local/bin/akonadi_imap_resource' crashed. No restart!
Application '/usr/local/bin/akonadi_agent_launcher' exited normally...
Lost connection to resource
"org.freedesktop.Akonadi.Resource.akonadi_imap_resource_0" , discarding cached
interface 
Unregistering search instance "akonadi_imap_resource_0" 
Application '/usr/local/bin/akonadi_imap_resource' exited normally...
continuing 
request for item 1890571 "59316" failed: "Unable to retrieve item from
resource: Message did not receive a reply (timeout by message bus)" 
Application '/usr/bin/akonadi_mailfilter_agent' exited normally...
Application '/usr/bin/akonadi_archivemail_agent' exited normally...
void Akonadi::Server::NotificationSource::serviceUnregistered(const QString&)
Notification source "akonadi_imap_resource_0_3221_Q97d5S" now serving: () 
Application '/usr/local/bin/akonadi_icaldir_resource' exited normally...
Application '/usr/local/bin/akonadi_migration_agent' exited normally...
Application '/usr/local/bin/akonadi_newmailnotifier_agent' exited normally...
Application '/usr/local/bin/akonadi_agent_launcher' exited normally...
Application '/usr/bin/akonadi_notes_agent' exited normally...
terminating service threads 
ItemRetrieverException :  Unable to retrieve item from resource: Message did
not receive a reply (timeout by message bus)
terminating connection threads 
plasma-desktop(3121)/libakonadi Akonadi::SessionPrivate::socketError: Socket
error occurred: "QLocalSocket: Remote closed" 
ktp-contactlist(3330)/libakonadi Akonadi::SessionPrivate::socketError: Socket
error occurred: "QLocalSocket: Remote closed" 
plasma-desktop(3121)/libakonadi Akonadi::SessionPrivate::socketError: Socket
error occurred: "QLocalSocket: Remote closed" 
kontact(3474)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
krunner(3212)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
kontact(3474)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
korgac(3514)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
korgac(3514)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
kmail2(3544)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
"[
0: akonadiserver(_Z11akBacktracev+0x36) [0x4d677c]
1: akonadiserver() [0x4d69c8]
2: /lib/x86_64-linux-gnu/libc.so.6(+0x35180) [0x7f7494d98180]
3:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN14QReadWriteLock12lockForWriteEv+0x1d)
[0x7f74968cc3cd]
4:
akonadiserver(_ZN7Akonadi6Server20ItemRetrievalManager19requestItemDeliveryEPNS0_20ItemRetrievalRequestE+0x31)
[0x5680cd]
5: akonadiserver(_ZN7Akonadi6Server13ItemRetriever4execEv+0x664) [0x5f2342]
6:
akonadiserver(_ZN7Akonadi6Server11FetchHelper10fetchItemsERK10QByteArray+0x176)
[0x5bd68a]
7: akonadiserver(_ZN7Akonadi6Server5Fetch11parseStreamEv+0x192) [0x5bab74]
8: akonadiserver(_ZN7Akonadi6Server10Connection11slotNewDataEv+0x3a3)
[0x5aa075]
9: akonadiserver() [0x5a2d4a]
10:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QMetaObject8activateEP7QObjectPKS_iPPv+0x32c)
[0x7f74969eff4c]
11:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN11QMetaObject8activateEP7QObjectPKS_iPPv+0x32c)
[0x7f74969eff4c]
12: /usr/lib/x86_64-linux-gnu/libQtNetwork.so.4(+0xc836e) [0x7f74965cc36e]
13: /usr/lib/x86_64-linux-gnu/libQtNetwork.so.4(+0xd2f6d) [0x7f74965d6f6d]
14:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN16QCoreApplication14notifyInternalEP7QObjectP6QEvent+0x8d)
[0x7f74969daf8d]
15: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x1b5b50) [0x7f7496a0ab50]
16: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_dispatch+0x24d)
[0x7f7494461c5d]
17: /lib/x86_64-linux-gnu/libglib-2.0.so.0(+0x49f48) [0x7f7494461f48]
18: /lib/x86_64-linux-gnu/libglib-2.0.so.0(g_main_context_iteration+0x2c)
[0x7f7494461ffc]
19:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN20QEventDispatcherGlib13processEventsE6QFlagsIN10QEventLoop17ProcessEventsFlagEE+0x77)
[0x7f7496a0a507]
20:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop13processEventsE6QFlagsINS_17ProcessEventsFlagEE+0x41)
[0x7f74969d9ae1]
21:
/usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN10QEventLoop4execE6QFlagsINS_17ProcessEventsFlagEE+0x1a5)
[0x7f74969d9e45]
22: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(_ZN7QThread4execEv+0x109)
[0x7f74968ceb89]
23: akonadiserver(_ZN7Akonadi6Server16ConnectionThread3runEv+0x69) [0x4ddfd9]
24: /usr/lib/x86_64-linux-gnu/libQtCore.so.4(+0x7c3ef) [0x7f74968d13ef]
25: /lib/x86_64-linux-gnu/libpthread.so.0(+0x80a4) [0x7f7494b4e0a4]
26: /lib/x86_64-linux-gnu/libc.so.6(clone+0x6d) [0x7f7494e4904d]
]
"
ProcessControl: Application 'akonadiserver' returned with exit code 255
(Unknown error)
kmail2(3544)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
kmail2(3544)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 
kmail2(3544)/libakonadi Akonadi::SessionPrivate::socketError: Socket error
occurred: "QLocalSocket: Remote closed" 


May it be that akonadiserver crashed here before triggering a MySQL shutdown?

The MySQL server is still happily running:

ms at merkaba:~/Backup#2> ps aux  |grep "[m]ysql" | grep "^ms"
ms        3162  2.9  3.9 2817028 643416 ?      Sl   09:06   1:47
/usr/sbin/mysqld --defaults-file=/home/ms/.local/share/akonadi/mysql.conf
--datadir=/home/ms/.local/share/akonadi/db_data/
--socket=/tmp/akonadi-ms.eMC6wS/mysql.socket

while akonadictl stop tells:

ms at merkaba:~#130> akonadictl stop
Akonadi is not running. 
ms at merkaba:~#4> akonadictl status
Akonadi Control: stopped
Akonadi Server: stopped
search paths:  ("/usr/local/lib/kde4", "/home/ms/.kde/lib/kde4/plugins/",
"/usr/local/lib/kde4/plugins/", "/usr/lib/kde4/plugins/",
"/usr/local/lib/plugins/", "/usr/lib/x86_64-linux-gnu/qt4/plugins",
"/usr/local/bin", "/usr/local/lib/kde4/plugins", "/usr/lib/kde4/plugins",
"/usr/local/lib/plugins", "/home/ms/.kde/lib/kde4/", "/usr/local/lib/kde4/",
"/usr/lib/kde4/") 
Akonadi Server Search Support: available (Remote Search, Akonadi Baloo Search
Plugin)
Available Agent Types: akonadi_airsyncdownload_resource,
akonadi_akonotes_resource, akonadi_archivemail_agent, akonadi_baloo_indexer,
akonadi_birthdays_resource, akonadi_contacts_resource,
akonadi_davgroupware_resource, akonadi_folderarchive_agent,
akonadi_followupreminder_agent, akonadi_googlecalendar_resource,
akonadi_googlecontacts_resource, akonadi_ical_resource,
akonadi_icaldir_resource, akonadi_imap_resource, akonadi_invitations_agent,
akonadi_kabc_resource, akonadi_kalarm_dir_resource, akonadi_kalarm_resource,
akonadi_kcal_resource, akonadi_kdeaccounts_resource, akonadi_knut_resource,
akonadi_kolab_resource, akonadi_kolabproxy_resource,
akonadi_localbookmarks_resource, akonadi_maildir_resource,
akonadi_maildispatcher_agent, akonadi_mailfilter_agent,
akonadi_mailtransport_dummy_resource, akonadi_mbox_resource,
akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_nepomuk_feeder,
akonadi_newmailnotifier_agent, akonadi_nntp_resource, akonadi_notes_agent,
akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource,
akonadi_sendlater_agent, akonadi_vcard_resource, akonadi_vcarddir_resource


I bet Akonadi didnĀ“t even tell the MySQL to quit yet. Can this be logged?
"About to quit MySQL process <pid>" maybe?

A graceful SIGTERM to the mysqld process just ended it within two seconds, so I
bet its not MySQL refusing to exit here, but Akonadi not even trying to stop it
due to above crash on exit. Maybe a shell script to stop Akonadi would be more
robust than a C++ application that crashes on attempting to shut down Akonadi.


And I pretty much bet akonadictl start would start a second copy of mysqld
again, which again, in my eyes is a big, huge, no-go. Never *ever* do this.

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


More information about the Kdepim-bugs mailing list