I tried to send this Friday, but was a bit frazzled and probably didn't give enough information. So, I'll try again and see if anyone can help.
My RedHat 7.3 system running MySQL 3.23.52 crashed. On reboot, everything came up normally except MySQL. When safe_mysqld is run, I get the following error: Number of processes running now: 1 mysqld process hanging, pid 15139 - killed 021101 16:01:41 mysqld restarted /opt/mysql/bin/safe_mysqld: line 273: 15159 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 Number of processes running now: 1 mysqld process hanging, pid 15162 - killed 021101 16:01:42 mysqld restarted /opt/mysql/bin/safe_mysqld: line 273: 15182 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 Number of processes running now: 1 mysqld process hanging, pid 15185 - killed 021101 16:01:42 mysqld restarted /opt/mysql/bin/safe_mysqld: line 273: 15205 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 This continues until the safe_mysqld process is manually killed. Looking at the script, it appears that the threads are being tested to make sure they aren't hanging. For some reason, the daemon is killing every thread as if it was hung. It looks to me as if this is a comparison against the pid but haven't wrapped my head around the code enough to figure it out completely. I moved all the databases out of the data directory to ensure it wasn't a massively corrupted table causing the issue. Even with no dbs, the problem exists. I've also tried --skip-grant-tables and a completely new compile and install. No errors are written and the bin log contains: # at 4 #021101 16:33:50 server id 1 Start: binlog v 1, server v 3.23.52-log created 021101 16:33:50 Google didn't produce any helpful tips and the list archives seem pretty quiet on this problem. Anyone have a clue? -- Kip Turk, RHCE [EMAIL PROTECTED] Systems Administrator/Killer of Spam/Writer of Code/Penguin Proponent West Central Net - tel: 915.234.5678 / 800.695.9016 fax: 915.656.0071 -.-. --- -.. . / -- --- -. -.- . -.-- --..-- / .... .- -.-. -.- . .-. --------------------------------------------------------------------- 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
