Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Mark Tully writes: From: Mark Tully [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4) Description: Downloaded source archive, compiled as of instructions. The mySQLd server is started as root and it switches down to the mysql user. It can be started using the mysql.server start command or by safe_mysqld --user=mysql and it appears to work fine. However it just won't die! cut Sinisa Looks like a thread - related problem to me. Sinisa Simply signals are not wroking ... Mac OS X has a bug that it the thread library doesn't send signals properly to other threads. We are talking with Apple to get hold of an Mac OS X box of our own to be able to solve this properly. Regards, Monty - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
on 8/1/01 5:30 AM, Mark Tully at [EMAIL PROTECTED] wrote: Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4) hey mark, i just saw this thread. just to confirm your suspicion, all the macosx sites i visit regularly have mentioned this. you can't shutdown mysql in the normal manner. sudo kill -KILL pid -- mike cullerton - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Mark Tully writes: Hi Sinisa, The server functions fine, I can run queries on it and I've lot it linked into a bulletin board through php and apache and that works like a dream. But it still won't die! mysqladmin -uroot -psql shutdown Returns without any complaint but the tasks are still going. If I stick a sudo before the above command it hangs and I have to kill that off as well (although kill works for that - phew). The only way of killing them seems to be kill -KILL or it's synonym kill -9. I've not had any other thread related problems with my install. Any other pointers? Mark Can you check with mysqladmin proc in which state were connections after shutdown ?? Sometimes it takes time for all threads to be killed ... I know that older Darwin versions did not require any thread libs, but may be this one does ?? Can you check it out with http://www.prnet.de/RegEx/mysql.html ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Can you check with mysqladmin proc in which state were connections after shutdown ?? mark@localhost:/usr/local/mysql/bin mysqladmin -uroot -psql proc ++--+---+--+-+--+---+--- ---+ | Id | User | Host | db | Command | Time | State | Info | ++--+---+--+-+--+---+--- ---+ | 1 | root | localhost | database | Sleep | 4638 | | | | 2 | root | localhost | database | Sleep | 4632 | | | | 3 | root | localhost | database | Sleep | 4630 | | | | 12 | root | localhost | | Query | 0| | show processlist | ++--+---+--+-+--+---+--- ---+ mark@localhost:/usr/local/mysql/bin mysqladmin -uroot -psql shutdown mark@localhost:/usr/local/mysql/bin mysqladmin -uroot -psql proc ++--+---+--+-+--+---+--- ---+ | Id | User | Host | db | Command | Time | State | Info | ++--+---+--+-+--+---+--- ---+ | 1 | root | localhost | database | Sleep | 4650 | | | | 2 | root | localhost | database | Sleep | 4644 | | | | 3 | root | localhost | database | Sleep | 4642 | | | | 14 | root | localhost | | Query | 0| | show processlist | ++--+---+--+-+--+---+--- ---+ I tried waiting for a couple of minutes and did it again, still no joy, the only difference was the time columns had increased and the id for the query was different. I know that older Darwin versions did not require any thread libs, but may be this one does ?? Can you check it out with http://www.prnet.de/RegEx/mysql.html ?? That page reports it compiles fine without any threads libs. I've seen a couple of tutorials about making mySQL under Mac OS X and they've all said pthreads for Mac OS X Server only (OS X Server is a bit different from Mac OS X, eventually they'll merge). I've asked the author of the page you mentioned for confirmation and will let you know what he says. Mark - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mySQLd won't die under Darwin (Mac OS X 10.0.4)
From: Mark Tully [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4) Description: Downloaded source archive, compiled as of instructions. The mySQLd server is started as root and it switches down to the mysql user. It can be started using the mysql.server start command or by safe_mysqld --user=mysql and it appears to work fine. However it just won't die! kill doesn't work on either the mysql process or the script, the mysqladmin -u root shutdown command similarly fails and the mysql.server stop command times out. The only way I can stop it is by manually killing off the script and then the server with kill -KILL. The pid is recorded correctly and retrieved correctly by the mysql.server stop command, but kill is just completely ineffectual. How-To-Repeat: sudo mysql.server start sudo mysql.server stop Killing mysqld with pid 386 Wait for mysqld to exit\c .\c .\c .\c . . . gave up waiting! Fix: sudo kill -KILL pid of script sudo kill -KILL pid of daemon Submitter-Id: Originator: Mark Tully Organization: University of Durham, UK MySQL support: none Synopsis:mySQLd won't die under Darwin Severity:non-critical Priority:medium Category:mysql Class:sw-bug Release:mysql-3.23.40 (Source distribution) Server: ../client/mysqladmin Ver 8.21 Distrib 3.23.40, for apple-darwin1.3.7 on powerpc Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version3.23.40 Protocol version10 ConnectionLocalhost via UNIX socket UNIX socket/tmp/mysql.sock Uptime:43 min 30 sec Threads: 1 Questions: 7 Slow queries: 0 Opens: 5 Flush tables: 1 Open tables: 0 Queries per second avg: 0.003 Environment: machine, os, target, libraries (multiple lines) System: Darwin localhost 1.3.7 Darwin Kernel Version 1.3.7: Sat Jun 9 11:12:48 PDT 2001; root:xnu/xnu-124.13.obj~1/RELEASE_PPC Power Macintosh powerpc Some paths: /usr/bin/perl /usr/bin/make /usr/bin/cc Compilation info: CC='cc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxr-xr-x 1 root wheel 15 Feb 16 21:39 /usr/lib/libc.dylib - libSystem.dylib Configure command: ./configure --prefix=/usr/local/mysql - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
Mark Tully writes: From: Mark Tully [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mySQLd won't die under Darwin (Mac OS X 10.0.4) Description: Downloaded source archive, compiled as of instructions. The mySQLd server is started as root and it switches down to the mysql user. It can be started using the mysql.server start command or by safe_mysqld --user=mysql and it appears to work fine. However it just won't die! kill doesn't work on either the mysql process or the script, the mysqladmin -u root shutdown command similarly fails and the mysql.server stop command times out. The only way I can stop it is by manually killing off the script and then the server with kill -KILL. The pid is recorded correctly and retrieved correctly by the mysql.server stop command, but kill is just completely ineffectual. How-To-Repeat: sudo mysql.server start sudo mysql.server stop Killing mysqld with pid 386 Wait for mysqld to exit\c .\c .\c .\c . . . gave up waiting! Fix: sudo kill -KILL pid of script sudo kill -KILL pid of daemon Looks like a thread - related problem to me. Simply signals are not wroking ... Try this : Start MySQL server then try connecting to it and running some simple queries. If it works, then mysqladmin shutdown MUST work, provided user has ROOT privileges. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQLd won't die under Darwin (Mac OS X 10.0.4)
At 12:30 PM +0100 8/1/01, Mark Tully wrote: However it just won't die! kill doesn't work on either the mysql process or the script, the mysqladmin -u root shutdown command similarly fails and the mysql.server stop command times out. The only way I can stop it is by manually killing off the script and then the server with kill -KILL. Use: # kill -9 123 # kill -9 126 where 123 is the Process ID of safe_mysql and 126 is that of mysqld (make sure to do in this order). The -9 option is the signal number to use when a process will not terminate with a usual kill command. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com - 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 [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php