WARNING: sometimes two copies of mysqld are running after stopping and starting Akonadi

Martin Steigerwald <[email protected]>
Newsgroups gmane.comp.kde.users.pim
Message-ID <1798664.9pe9IDlA5H@merkaba>
Hi!

I read quite some times that people do

akonadictl restart

to work around and fix up issues with Akonadi temporily.

I recommend: Don´t.

Do

- akonadictl stop,
- then check that the mysqlq process is really gone
- if it doesn´t quit after a while send it a TERM signal (please only the 
friendly TERM which kill sends if you do not specify a signal)
- only after you are sure that there is no mysqld is running to akonadictl 
start again


I think I completely lost the mysql database of my private Akonadi setup 
due to this as I tried out the SizeThreshold=32768 thing I mentioned a 
post ago. MySQL maybe would have been able to rebuild the db, but after 
writing excessively for 150-300 MiB/s for minutes to go with an write 
amount of easily tens of times of the whole size of the database I gave up 
on it.


Also see:

Bug 340813 - sometimes two copies of mysqld are running with Akonadi
https://bugs.kde.org/340813


If you also see that akonadictl does not terminate all database processes, 
please comment to:

[Akonadi] [Bug 248287] 'akonadictl stop' takes very long + doesn't 
terminate all 'mysqld' processes

Also if you dare to start akonadi with a mysqld process still running and 
have then two mysqld processes running, comment to 340813. But I 
recommend: Don´t. Unless you have an IMAP account and are willing to have 
Akonadi rebuild the database from scratch in case the database is 
corrupted due to this.


I think MySQL is trying to prevent data loss even in that case. It seems 
to lock ibdata file at least. But I am not sure whether this protection is 
complete and failure proof. It seems to me that it is not. So my 
recommendation is: Better do not risk it :).

Ciao,
-- 
Martin 'Helios' Steigerwald - http://www.Lichtvoll.de
GPG: 03B0 0D6C 0040 0710 4AFA  B82F 991B EAAC A599 84C7
_______________________________________________
KDE PIM users mailing list
Subscription management: https://mail.kde.org/mailman/listinfo/kdepim-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.