MySQL DBA - Tips and Techniques Magazine

13 Nov 2014

‘mysqld got signal 11’

 

It is not clear what caused this, but this is how it was fixed – eventually!  The main issue that resulted from the failure was that the database would not restart and there were 1000's of relay log files in the $DATADIR

 

  • Killed all mysql processes and mysqld processes – had to use kill -9 for mysqld process

 

  • Removed all relay bin logs from $DATADIR

 

  • Restarted mysql using /usr/local/mysql/bin/mysqld_safe &

 

  • Stopped slave

 

  • Systems team stop mail

 

  • Recreated slave from master (oook)

 

  • Connect to database and issue 'flush logs'

 

  • Set master log file and llog file position

 

  • Restart slave

 

Everything should be working now!

1 comment:

  1. Details of the crash can be found in the error log.
    See also http://dev.mysql.com/doc/refman/5.6/en/crashing.html

    ReplyDelete