Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL keeps failing

Discussion in 'Database Discussion' started by drp, Apr 13, 2015.

  1. drp

    drp Member

    Joined:
    Sep 4, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi,

    The sites on my server keep going down and I have to restart the server. It seems to be related to a problem with MySQL. The error message that visitors see is:

    CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown storage engine 'InnoDB']

    I don't know what triggers it. Any ideas? It's happened enough now that I need to do something about it. I'm currently running MySQL 5.5 so could upgrade to 5.6?

    Thanks,
    Clive
     
    #1 drp, Apr 13, 2015
  2. madmanmachines

    madmanmachines Well-Known Member

    Joined:
    Nov 28, 2014
    Messages:
    94
    Likes Received:
    4
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Hi,

    Have you checked your MySQL error log at '/var/lib/mysql/' ? Could you paste your MySQL configuration?:
    Code:
     cat /etc/my.cnf
    You may try simply moving the MySQL configuration out of the way and using an empty configuration:
    Code:
    mv /etc/my.cnf /etc/my.cnf.bak
touch /etc/my.cnf
/scripts/restartsrv_mysql
    Thanks,
     
    #2 madmanmachines, Apr 13, 2015
  3. drp

    drp Member

    Joined:
    Sep 4, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Here's the config:
    Code:
    [mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456
open_files_limit=10000
    And here's the contents of the error file:
    Code:
    141031 10:27:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141031 10:27:50 [Note] Plugin 'FEDERATED' is disabled.
141031 10:27:50 InnoDB: The InnoDB memory heap is disabled
141031 10:27:50 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141031 10:27:50 InnoDB: Compressed tables use zlib 1.2.3
141031 10:27:50 InnoDB: Using Linux native AIO
141031 10:27:50 InnoDB: Initializing buffer pool, size = 128.0M
141031 10:27:50 InnoDB: Completed initialization of buffer pool
141031 10:27:50 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141031 10:27:50  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
141031 10:27:51  InnoDB: Waiting for the background threads to start
141031 10:27:52 InnoDB: 5.5.37 started; log sequence number 27839648
141031 10:27:52 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141031 10:27:52 [Note]  - '0.0.0.0' resolves to '0.0.0.0';
141031 10:27:52 [Note] Server socket created on IP: '0.0.0.0'.
141031 10:27:52 [Note] Event Scheduler: Loaded 0 events
"#######################.err" 1174L, 86063C
    Though, the dates look wrong to me.
     
    #3 drp, Apr 13, 2015
    Last edited: Apr 13, 2015
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,791
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Have you tried reviewing the last few lines of the MySQL error log? EX:

    Code:
    tail -500 /var/lib/mysql/$hostname.err
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Apr 15, 2015
  5. drp

    drp Member

    Joined:
    Sep 4, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I see. Thanks. Here's everything from that day:

    Code:
    150413 10:36:34 mysqld_safe Number of processes running now: 0
150413 10:36:34 mysqld_safe mysqld restarted
150413 10:36:36 [Note] Plugin 'FEDERATED' is disabled.
150413 10:36:39 InnoDB: The InnoDB memory heap is disabled
150413 10:36:39 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150413 10:36:39 InnoDB: Compressed tables use zlib 1.2.3
150413 10:36:39 InnoDB: Using Linux native AIO
150413 10:36:41 InnoDB: Initializing buffer pool, size = 128.0M
InnoDB: mmap(137363456 bytes) failed; errno 12
150413 10:36:41 InnoDB: Completed initialization of buffer pool
150413 10:36:41 InnoDB: Fatal error: cannot allocate memory for the buffer pool
150413 10:36:41 [ERROR] Plugin 'InnoDB' init function returned error.
150413 10:36:41 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150413 10:36:41 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150413 10:36:41 [Note]  - '0.0.0.0' resolves to '0.0.0.0';
150413 10:36:41 [Note] Server socket created on IP: '0.0.0.0'.
150413 10:36:42 [Note] Event Scheduler: Loaded 0 events
150413 10:36:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.42-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150413 10:43:45 [Note] /usr/sbin/mysqld: Normal shutdown

150413 10:43:45 [Note] Event Scheduler: Purging the queue. 0 events
150413 10:43:45 [Note] /usr/sbin/mysqld: Shutdown complete

150413 10:43:45 mysqld_safe mysqld from pid file /var/lib/mysql/#########.#########.###.pid ended
150413 10:44:04 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150413 10:44:04 [Note] Plugin 'FEDERATED' is disabled.
150413 10:44:04 InnoDB: The InnoDB memory heap is disabled
150413 10:44:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150413 10:44:04 InnoDB: Compressed tables use zlib 1.2.3
150413 10:44:04 InnoDB: Using Linux native AIO
150413 10:44:04 InnoDB: Initializing buffer pool, size = 128.0M
150413 10:44:04 InnoDB: Completed initialization of buffer pool
150413 10:44:04 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
150413 10:44:04  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
150413 10:44:05  InnoDB: Waiting for the background threads to start
150413 10:44:06 InnoDB: 5.5.42 started; log sequence number 111673446
150413 10:44:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
150413 10:44:06 [Note]  - '0.0.0.0' resolves to '0.0.0.0';
150413 10:44:06 [Note] Server socket created on IP: '0.0.0.0'.
150413 10:44:06 [Note] Event Scheduler: Loaded 0 events
150413 10:44:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.42-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
150413 11:07:30 [Warning] IP address '############' could not be resolved: Name or service not known
150413 12:26:54 [Warning] IP address '############' could not be resolved: Name or service not known
150413 20:12:06 [Warning] IP address '############' could not be resolved: Name or service not know
     
    #5 drp, Apr 20, 2015
  6. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,789
    Likes Received:
    83
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    I think your are getting this issues due to insufficient memory installed on your server. I will suggest Please check /var/log/messages and monitor your memory usages.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 24x7server, Apr 20, 2015
  7. drp

    drp Member

    Joined:
    Sep 4, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    #7 drp, Apr 20, 2015
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,791
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    You are welcome to try that solution before adding more memory to your system to see if it works.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 cPanelMichael, Apr 21, 2015
  9. gadalf

    gadalf Well-Known Member

    Joined:
    Jun 8, 2014
    Messages:
    50
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I get no such file or directory when run this comand
     
    #9 gadalf, May 26, 2015
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,791
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    You must replace "$hostname" with the actual hostname of your server.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #10 cPanelMichael, May 27, 2015
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL keeps failing
  1. gseven

    MySQL Keeps Crashing

    gseven, Mar 25, 2017, in forum: Database Discussion
    Replies:
    7
    Views:
    1,444
    ssfred
    Mar 29, 2017
  2. Larry Braziel

    SOLVED MySQL Keeps Stopping - Now Using MariaDB

    Larry Braziel, Dec 14, 2016, in forum: Database Discussion
    Replies:
    1
    Views:
    836
    cPanelMichael
    Dec 15, 2016
  3. RobNH

    MySQLi - Too Many Connections Error due to Amazon AWS

    RobNH, Jun 21, 2018 at 7:47 AM, in forum: Database Discussion
    Replies:
    5
    Views:
    34
    Infopro
    Jun 21, 2018 at 10:03 AM
  4. geekbaaz

    Multiple cPanel servers with a common MySQL server?

    geekbaaz, Jun 21, 2018 at 3:24 AM, in forum: Database Discussion
    Replies:
    2
    Views:
    53
    cPanelMichael
    Jun 21, 2018 at 11:32 AM
  5. cosmin

    MySQL InnoDB errors after upgrade to 5.7

    cosmin, Jun 20, 2018 at 11:46 PM, in forum: Database Discussion
    Replies:
    2
    Views:
    39
    cPanelMichael
    Jun 21, 2018 at 10:31 AM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice