Results 1 to 4 of 4
  1. #1

    kill -8 and db becomes inaccessible

    hi, i saw a mysql process using lots of cpu, so i "kill -8" the PID. Now the I cant access the db for the specific domain. It returns:

    mySQL error: Can't open file: 'ibf_sessions.MYI'. (errno: 145)
    mySQL error code:

    Weird thing is i am able to access it via phpmyadmin. I've tried restarting mysql, but it doesn't work. Any help? thanks.
    Last edited by expert_21; 05-04-2004 at 10:30 AM.

  2. #2

    Some suggestions:

    1. Check out the man pages for kill as there are different signals you can send (i.e. the -8 is a signal).

    I've found -5 works the best in most cases as it allows a service to terminate gracefully (if it can).

    2. You may have corrupted the indicies (MYI is an index).

    You may want to read up on the mySQL documention; there is a command to rebuild / repair corrupted indecies.

    Thank you.
    Peter M. Abraham
    LinkedIn Profile

  3. #3
    Join Date
    Apr 2003
    out of interest, why did you send SIGFPE (signal 8) ? was this a mistake for 9 (sigkill)?

    sigterm is a more graceful kill..

  4. #4
    out of interest, why did you send SIGFPE (signal 8) ? was this a mistake for 9 (sigkill)?
    it was a mistake
    anyway I've repaired the db as suggested by dynamicnet, and everything is working good. Thanks everyone
    Mobile phone news blog + free downloads (wallpapers, ringtones & themes): Mobile Phone Portal - mobile9

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts