The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysql server fail to start

Discussion in 'Database Discussions' started by satchstrat, Nov 24, 2015.

  1. satchstrat

    satchstrat Registered

    Joined:
    Nov 24, 2015
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    ktm
    cPanel Access Level:
    Root Administrator
    cpanel mysql server fails to start , below is the log any idea how to resolve it ?

    Code:
    [/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
    
    
     
    #1 satchstrat, Nov 24, 2015
    Last edited by a moderator: Nov 24, 2015
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,762
    Likes Received:
    662
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page