MySQL is not running

YasIT

• May 06, 2014 14:44

Hello. root@server [/var/lib/mysql]# service mysql status MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED] root@server [/var/lib/mysql]# root@server [/var/lib/mysql]# tail -f hostname.err InnoDB: line 1. please help. [COLOR="silver">- - - Updated - - - root@server [/var/lib/mysql]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

• 

  cPanelMichael

  • May 06, 2014 20:01

  Hello :) The following message in your MySQL error log is the source of this issue: [QUOTE]Table './mysql/db' is marked as crashed and should be repaired
  Try using this command to repair it: myisamchk /var/lib/mysql/mysql/db.MYI
  Thank you.

  0
• 

  YasIT

  • May 07, 2014 00:30

  root@server [~]# myisamchk /var/lib/mysql/mysql/db.MYI Checking MyISAM file: /var/lib/mysql/mysql/db.MYI Data records: 26734 Deleted blocks: 0 - check file-size - check record delete-chain - check key delete-chain - check index reference - check data record references index: 1 - check data record references index: 2 root@server [~]# service mysql start Starting MySQL......The server quit without updating PID file (/var/lib/mysql/hostname.pid). [FAILED] root@server [~]# root@bazdid [/var/lib/mysql]# tail -f hostname.err /usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x48)[0x5a60d8] /usr/sbin/mysqld[0x6e3771] /usr/sbin/mysqld(_Z11plugin_initPiPPci+0xbc6)[0x6e72b6] /usr/sbin/mysqld[0x59902d] /usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x415)[0x59dfe5] /lib64/libc.so.6(__libc_start_main+0xfd)[0x3c9181ed1d] /usr/sbin/mysqld[0x5905ed] The manual page at [url=http://dev.mysql.com/doc/mysql/en/crashing.html]MySQL :: MySQL 5.6 Reference Manual :: C.5.4.2 What to Do If MySQL Keeps Crashing contains information that should help you find out what is causing the crash. 140507 04:57:39 mysqld_safe mysqld from pid file /var/lib/mysql/hostname.pid ended

  0
• 

  cPanelPeter cPanel Staff

  • May 07, 2014 13:51

  Hello, The myisamchk program has an additional flag for repair. Try: # myisamchk -r /var/lib/mysql/mysql/db.MYI
  Without the -r flag, it's just a check and won't actually repair the file.

  0
• 

  YasIT

  • May 08, 2014 18:19

  Thanks you, my problem fix with : [url=http://linuxadministrator.pro/blog/?p=225]MySQL Restart Failed : The server quit without updating PID file | ::: | Welcome to LinuxAdministrator.Pro | ::: Regards.:D

  0
• 

  cPanelMichael

  • May 08, 2014 18:27

  I am happy to see you were able to resolve the issue. Thank you for updating us with the outcome. Note that removing the ib_logfile files is not necessarily a step everyone should take. Administrators should investigate and ensure it won't result in potential data loss. Thank you.

  0

Please sign in to leave a comment.