Ever seen this happen when you start safe_mysqld?  Google shows some 
hits, but no concrete answers to fix it.  

Number of processes running now: 1
mysqld process hanging, pid 9039 - killed
021101 09:17:59  mysqld restarted
/opt/mysql/bin/safe_mysqld: line 273:  9059 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 9062 - killed
021101 09:17:59  mysqld restarted
/opt/mysql/bin/safe_mysqld: line 273:  9082 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 9085 - killed
021101 09:18:00  mysqld restarted
/opt/mysql/bin/safe_mysqld: line 273:  9105 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 9108 - killed
021101 09:18:00  mysqld restarted
/opt/mysql/bin/safe_mysqld: line 273:  9128 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 9131 - killed
021101 09:18:00  mysqld restarted
/opt/mysql/bin/safe_mysqld: line 273:  9151 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

It goes on, ad infinium, but you get the idea.  So far, I've reinstalled 
a clean binary (3.23.52-log), tried skipping grants, and verified that 
all db files are clean (myisamchk -o */*.MYI).  This system has been 
running clean for quite a while, but seems to have taken a nosedive at 
midnight last night.

The segfault seems to come at a test to see if a thread is hanging,
though I can't see why it would fail.  Nothing has changed from what I
can see.  Any tips?

-- 
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

Reply via email to