7 messages in com.mysql.lists.bugsRE: weird safe_mysqld startup error| From | Sent On | Attachments |
|---|---|---|
| Tobias Wiersch | 28 Jan 2002 02:20 | |
| BICHOT Guilhem 172613 | 28 Jan 2002 06:30 | |
| Spencer Pickett | 28 Jan 2002 07:03 | |
| Michael Widenius | 28 Jan 2002 18:30 | |
| Tobias Wiersch | 29 Jan 2002 02:36 | |
| Michael Widenius | 29 Jan 2002 05:01 | |
| Tobias Wiersch | 29 Jan 2002 07:19 |
| Subject: | RE: weird safe_mysqld startup error |
|---|---|
| From: | BICHOT Guilhem 172613 (guil...@ipsn.fr) |
| Date: | 01/28/2002 06:30:39 AM |
| List: | com.mysql.lists.bugs |
Hi !
I put your piece of code in a shell script in /etc/cron.hourly (machine : Linux Mandrake 8.1, MySQL 4.0.0alpha) : #!/bin/sh apachectl stop && /bin/sleep 3 /etc/init.d/mysql stop && /bin/sleep 3 /etc/init.d/mysql start && /bin/sleep 3 apachectl stop && /bin/sleep 3 pstree >> /home/bichot2/rapport
crond ran it at 13:01, 14:01, 15:01 today, and the result of pstree (in the file "rapport") was always |-mysqld_safe---mysqld-max---mysqld-max---2*[mysqld-max] which is normal (I also get it when I start and stop manually). So it looks like your problem is not easy to reproduce (is it that in your system the "night" root is not really root ? that would be odd but I see no other possible reason). So good luck, Guilhem
-----Message d'origine----- De : Tobias Wiersch [mailto:swi...@fanpro.com] Envoye : lundi 28 janvier 2002 11:21 A : bu...@lists.mysql.com Objet : weird safe_mysqld startup error
Hi there!
Every night, when the service-routines of my server start (cron as root-user), I shutdown all main web-services with: /etc/init.d/apache stop && /bin/sleep 3 /etc/init.d/mysql stop && /bin/sleep 3 [...service...] /etc/init.d/mysql start && /bin/sleep 3 /etc/init.d/apache start
But in the morning, when I check the server, often all scripts can't connect to MySQL!? When I check "pstree", I will get this line: |-safe_mysqld---mysqld But normally this line should read: |-safe_mysqld---mysqld---mysqld---mysqld
This problem happens in approx. 70% of the cases. When I log in as root and do another mysql stop and mysql start, all is working fine.
I tried to put the above script-snippet (apache stop, mysql stop, mysql start, apache start) in a new script and started it 10 times. MySQL starts always correctly then.
Why does this error happens in the night in the service-script and not when I start it manually? Is there something I made wrong? Thanks for your help ...
Greetings ... T.Wiersch from germany
How-To-Repeat: I don't know if this bug only happens @ my system but you can try to run my example-script in a cron-job ...
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail bugs...@lists.mysql.com To unsubscribe, e-mail <bugs...@lists.mysql.com>