>>>>> "Roy" == Roy F Cabaniss <rcaban@stripped> writes:
Roy> this is the error message i get when I try to start safe_mysqld
Roy> but there is NOTHING in the process that says mysql is running
Roy> Number of processes running now: 2
Roy> mysqld proces hanging, pid 25005 - killed
Roy> /usr/bin/safe_mysqld: kill: (25005) - No such pid
Roy> mysqld restarted on Thu Jul 1 12:50:10 CDT 1999
Roy> /usr/bin/safe_mysqld: line 146: 25029 Segmentation fault nohup
Roy> $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --skip-locking
>>> $err_log 2>&1
Roy> Number of processes running now: 2
Roy> mysqld proces hanging, pid 25032 - killed
Roy> /usr/bin/safe_mysqld: kill: (25032) - No such pid
Roy> mysqld restarted on Thu Jul 1 12:50:11 CDT 1999
Roy> /usr/bin/safe_mysqld: line 146: 25056 Segmentation fault nohup
Roy> $ledir/mysqld --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR --skip-locking
>>> $err_log 2>&1
Hi!
Note that it may be 'nohup' that doesn't work and not mysqld!
Try the following:
- Kill first all running mysqld processes with 'mysql-zap mysqld'
- Check that you don't have any process that takes up all your memory.
- Check all tables with isamchk:
isamchk -s mysql-database-directory/*/*.ISM
If you get any errors, repair it with
isamchk -r table.ISM
- Try then to start safe_mysqld:
/usr/bin/safe_mysqld &
If this doesn't work, try to start mysqld directly:
/usr/sbin/mysqld &
If you still have problems, try with run mysqld under strace to find
out why it dies!
strace -o/tmp/trace /usr/sbin/mysqld &
Regards,
Monty
