List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:July 3 1999 1:08am
Subject:mysql hanging help please
View as plain text  
>>>>> "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
Thread
mysql hanging help pleaseRoy F. Cabaniss2 Jul
  • mysql hanging help pleaseMichael Widenius3 Jul