[Kde-pim] two mysqld processes running

[Martin Steigerwald]

Am Montag, 10. November 2014, 10:33:11 schrieb Martin Steigerwald:
> I suppose I should never ever see this:
> 
> ms at mango:~> ps aux | grep mysql
> 
> ms 2391 97.2 5.2 3640268 638488 ? Sl 09:50 15:05 /usr/sbin/mysqld
> --defaults- file=/home/ms/.local/share/akonadi/mysql.conf --
> datadir=/home/ms/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-
> ms.1pzYYX/mysql.socket
> 
> ms 4435 0.2 3.0 1598552 372952 ? Sl 10:04 0:00 /usr/sbin/mysqld
> --defaults- file=/home/ms/.local/share/akonadi/mysql.conf --
> datadir=/home/ms/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-
> ms.1pzYYX/mysql.socket
> 
> 
> Happened several times already, but so far I just killed these manually
> and was done with it. I didn't see any inconsistencies so far.
> 
> 
> https://bugs.kde.org/340813

I saw this again and now have a basic idea what *might* happen. See:

Bug 340813 - sometimes two copies of mysqld are running with Akonadi 
https://bugs.kde.org/show_bug.cgi?id=340813#c7

I think akonadiserver may crash on exit, before even telling the mysqld 
process to quit.

I added some content of ~/.xsession-errors to the bug report.

Right now I have lots of other things to do, but I may look into the order 
akonadiserver tries to quit things. I bet it would first try to get rid of 
Akonadi processes, and *then* quit MySQL. And well… if it crashes on the 
attempt of getting rid of Akonadi processes, it won´t quit MySQL.

But even then an akonadictl start may *never* *ever* start a *second* copy 
of MySQL on the same database. Please just don´t do it. I bet there is 
some protection in MySQL itself regarding that, but I won´t rely on it for 
data consistency. I do think I lost the complete mysql database at least 
once due to this.


-- 
Martin Steigerwald  | Consultant / Trainer

teamix GmbH
Südwestpark 43
90449 Nürnberg

Tel.:  +49 911 30999 55 | Fax: +49 911 30999 99
mail: martin.steigerwald at teamix.de | web:  http://www.teamix.de | blog: http://blog.teamix.de

Amtsgericht Nürnberg, HRB 18320 | Geschäftsführer: Oliver Kügow, Richard Müller


***Nicht verpassen: Wissenstag - Software defined Datacenter (SDDC)***
10.03. Nürnberg | 11.03. Mainz | 24.03. Bayreuth | 25.03. München
Jetzt anmelden unter: www.teamix.de/wissenstag

_______________________________________________
KDE PIM mailing list kde-pim at kde.org
https://mail.kde.org/mailman/listinfo/kde-pim
KDE PIM home page at http://pim.kde.org/