mysql server fail to start

satchstrat

• November 24, 2015 00:54

cpanel mysql server fails to start, below is the log any idea how to resolve it ?
[/var/lib/mysql]# tail -n 40 server.example.com.err 15112210:22:23[Note] InnoDB: Compressed tables use zlib 1.2.3 15112210:22:23[Note] InnoDB: Using Linux native AIO 15112210:22:23[Note] InnoDB: Using CPU crc32 instructions 15112210:22:23[Note] InnoDB: Initializing buffer pool, size = 128.0M 15112210:22:23[Note] InnoDB: Completed initialization of buffer pool 15112210:22:23[Note] InnoDB: Highest supported file format is Barracuda. 15112210:22:23[Note] InnoDB: Log scan progressed past the checkpoint lsn 1119074391 15112210:22:23[Note] InnoDB: Database was not shutdown normally! 15112210:22:23[Note] InnoDB: Starting crash recovery. 15112210:22:23[Note] InnoDB: Reading tablespace information from the .ibd files... 15112210:22:23[ERROR] InnoDB: Tried to read 16384 bytes at offset 0. Was only able to read 1134. 2015-11-22 10:22:23 7fe50b9b4820 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 15112210:22:23[ERROR] InnoDB: File (unknown): 'read' returned OS error 71. Cannot continue operation 15112210:22:23mysqld_safe mysqld from pid file /var/lib/mysql/server.example.com.pid ended 15112210:26:04mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 15112210:26:04[Note] /usr/sbin/mysqld (mysqld 10.0.22-MariaDB) starting as process 20515 ... 15112210:26:05[Note] InnoDB: Using mutexes to ref count buffer pool pages 15112210:26:05[Note] InnoDB: The InnoDB memory heap is disabled 15112210:26:05[Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 15112210:26:05[Note] InnoDB: Memory barrier is not used 15112210:26:05[Note] InnoDB: Compressed tables use zlib 1.2.3 15112210:26:05[Note] InnoDB: Using Linux native AIO 15112210:26:05[Note] InnoDB: Using CPU crc32 instructions 15112210:26:05[Note] InnoDB: Initializing buffer pool, size = 128.0M 15112210:26:05[Note] InnoDB: Completed initialization of buffer pool 15112210:26:05[Note] InnoDB: Highest supported file format is Barracuda. 15112210:26:05[Note] InnoDB: Log scan progressed past the checkpoint lsn 1119074391 15112210:26:05[Note] InnoDB: Database was not shutdown normally! 15112210:26:05[Note] InnoDB: Starting crash recovery. 15112210:26:05[Note] InnoDB: Reading tablespace information from the .ibd files... 15112210:26:05[ERROR] InnoDB: Tried to read 16384 bytes at offset 0. Was only able to read 1134. 2015-11-22 10:26:05 7f45f1363820 InnoDB: Operating system error number 2 in a file operation. InnoDB: The error means the system cannot find the path specified. InnoDB: If you are installing InnoDB, remember that you must create InnoDB: directories yourself, InnoDB does not create them. 15112210:26:05[ERROR] InnoDB: File (unknown): 'read' returned OS error 71. Cannot continue operation 15112210:26:05mysqld_safe mysqld from pid file /var/lib/mysql/server.example.com.pid ended

• 

  24x7server

  • November 24, 2015 10:29

  Hello :), It looks like there may be InnoDB corruption. The following document may be helpful to you: InnoDB Corruption Repair Guide

  0
• 

  cPanelMichael

  • November 24, 2015 18:08

  Hello :) Yes, as mentioned, please review the InnoDB repair guide for help with repairing InnoDB on your system. Thank you.

  0

Please sign in to leave a comment.