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!

The service “mysql” appears to be down.

Discussion in 'Database Discussion' started by jamescurl, Nov 6, 2017.

  1. jamescurl

    jamescurl Registered

    Joined:
    Jun 12, 2009
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    I am having a nightmare! All of my clients who have a database can't access their website.
    I have received so many of the following emails saying that the MYSQL failed to start.

    This is what I get.
    Any suggestions?
    Code:
    
    Notification The service “mysql” appears to be down.
    Service Check Method The system’s command to check or to restart this service failed.
    Number of Restart Attempts 37
    Service Check Raw Output
    The subprocess “/usr/local/cpanel/scripts/restartsrv_mysql” reported error number 9 when it ended.
    Startup Log Nov 06 15:16:18  systemd[1]: Started MySQL Server.
    Nov 06 15:16:18  systemd[1]: Starting MySQL Server...
    Nov 06 15:16:18  mysqld_safe[16550]: 171106 15:16:18 mysqld_safe Logging to '/var/lib/mysql/.err'.
    Nov 06 15:16:18  mysqld_safe[16550]: 171106 15:16:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    Log Messages 171106 15:16:18 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
    InnoDB: To fix the problem and start mysqld:
    171106 15:16:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    171106 15:16:18 mysqld_safe Logging to '/var/lib/mysql/'.
    171106 15:11:09 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
    InnoDB: To fix the problem and start mysqld:
    171106 15:11:09 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    171106 15:11:09 mysqld_safe Logging to '/var/lib/mysql/.err'.
    171106 15:05:56 mysqld_safe mysqld from pid file /var/lib/mysql/.pid ended
    InnoDB: To fix the problem and start mysqld:
    Memory Information
    Used 1.53 GB
    Available 21.84 GB
    Installed 23.38 GB
    Load Information 0.01 0.02 0.05
    Uptime 3 hours, 7 minutes, and 26 seconds
    IOStat Information avg-cpu: %user %nice %system %iowait %steal %idle 0.30 0.08 0.09 0.12 0.00 99.41 Device: tps kB_read/s kB_wrtn/s kB_read kB_wrtn sda 13.90 222.72 140.85 2504606 1584000
    Top Processes
    PID Owner CPU % Memory % Command
    17807 root 17.78 0.06 /usr/local/cpanel/scripts/restartsrv_mailman --check --notconfigured-ok
    17614 epecho 6.23 0.43 spamd child
    1805 root 1.15 0.41 /usr/local/cpanel/3rdparty/perl/524/bin/perl -T -w /usr/local/cpanel/3rdparty/bin/spamd --allowed-ips=127.0.0.1,::1 --max-children=5 --pidfile=/var/run/spamd.pid --listen=5 --listen=6
    17587 root 0.93 0.11 tailwatchd - chkservd - mailman check
    1963 named 0.33 0.29 /usr/sbin/named -u named -c /etc/named.conf
    
    
     
    #1 jamescurl, Nov 6, 2017
    Last edited by a moderator: Nov 6, 2017
  2. Haym

    Haym Active Member

    Joined:
    May 12, 2017
    Messages:
    39
    Likes Received:
    5
    Trophy Points:
    8
    Location:
    UK
    cPanel Access Level:
    Root Administrator
    What does /var/lib/mysql/.err contain?
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,856
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you let us know the output from the MySQL error log (/var/lib/mysql/$hostname.err) when attempting to start MySQL?

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Ishank

    Ishank Registered

    Joined:
    Apr 18, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Allahabad
    cPanel Access Level:
    Root Administrator
    It contains the below info


    Code:
    
    =========================
    
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size:2048 Pages to analyze:32
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size: 2048, Possible space_id count:0
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size:4096 Pages to analyze:16
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size: 4096, Possible space_id count:0
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size:8192 Pages to analyze:8
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size: 8192, Possible space_id count:0
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size:16384 Pages to analyze:4
    2018-06-09 09:05:03 3785 [Note] InnoDB: Page size: 16384, Possible space_id count:0
    2018-06-09 09:05:03 7f6b68d01740 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.
    InnoDB: Error: could not open single-table tablespace file ./visualwe_whmc322/tblticketpredefinedcats.ibd
    InnoDB: We do not continue the crash recovery, because the table may become
    InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
    InnoDB: To fix the problem and start mysqld:
    InnoDB: 1) If there is a permission problem in the file and mysqld cannot
    InnoDB: open the file, you should modify the permissions.
    InnoDB: 2) If the table is not needed, or you can restore it from a backup,
    InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
    InnoDB: crash recovery and ignore that table.
    InnoDB: 3) If the file system or the disk is broken, and you cannot remove
    InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
    InnoDB: and force InnoDB to continue crash recovery here.
    180609 09:05:03 mysqld_safe mysqld from pid file /var/lib/mysql/srv11.example.com.pid ended
    180609 09:10:06 mysqld_safe Logging to '/var/lib/mysql/srv11.example.com.err'.
    180609 09:10:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    2018-06-09 09:10:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2018-06-09 09:10:06 0 [Warning] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path.
    2018-06-09 09:10:06 0 [Note] /usr/sbin/mysqld (mysqld 5.6.38) starting as process 4414 ...
    2018-06-09 09:10:06 4414 [Note] Plugin 'FEDERATED' is disabled.
    2018-06-09 09:10:06 4414 [Note] InnoDB: Using atomics to ref count buffer pool pages
    2018-06-09 09:10:06 4414 [Note] InnoDB: The InnoDB memory heap is disabled
    2018-06-09 09:10:06 4414 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
    2018-06-09 09:10:06 4414 [Note] InnoDB: Memory barrier is not used
    2018-06-09 09:10:06 4414 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2018-06-09 09:10:06 4414 [Note] InnoDB: Using Linux native AIO
    2018-06-09 09:10:06 4414 [Note] InnoDB: Not using CPU crc32 instructions
    2018-06-09 09:10:06 4414 [Note] InnoDB: Initializing buffer pool, size = 128.0M
    2018-06-09 09:10:06 4414 [Note] InnoDB: Completed initialization of buffer pool
    2018-06-09 09:10:06 4414 [Note] InnoDB: Highest supported file format is Barracuda.
    2018-06-09 09:10:06 4414 [Note] InnoDB: Log scan progressed past the checkpoint lsn 756093223
    2018-06-09 09:10:06 4414 [Note] InnoDB: Database was not shutdown normally!
    2018-06-09 09:10:06 4414 [Note] InnoDB: Starting crash recovery.
    2018-06-09 09:10:06 4414 [Note] InnoDB: Reading tablespace information from the .ibd files...
    2018-06-09 09:10:06 4414 [ERROR] InnoDB: space header page consists of zero bytes in tablespace ./visualwe_whmc322/tblticketpredefinedcats.ibd (table visualwe_whmc322/tblticketpredefinedcats)
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size:1024 Pages to analyze:64
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size: 1024, Possible space_id count:0
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size:2048 Pages to analyze:32
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size: 2048, Possible space_id count:0
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size:4096 Pages to analyze:16
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size: 4096, Possible space_id count:0
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size:8192 Pages to analyze:8
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size: 8192, Possible space_id count:0
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size:16384 Pages to analyze:4
    2018-06-09 09:10:06 4414 [Note] InnoDB: Page size: 16384, Possible space_id count:0
    2018-06-09 09:10:06 7f98e4ced740 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.
    InnoDB: Error: could not open single-table tablespace file ./visualwe_whmc322/tblticketpredefinedcats.ibd
    InnoDB: We do not continue the crash recovery, because the table may become
    InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
    InnoDB: To fix the problem and start mysqld:
    InnoDB: 1) If there is a permission problem in the file and mysqld cannot
    InnoDB: open the file, you should modify the permissions.
    InnoDB: 2) If the table is not needed, or you can restore it from a backup,
    InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
    InnoDB: crash recovery and ignore that table.
    InnoDB: 3) If the file system or the disk is broken, and you cannot remove
    InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
    InnoDB: and force InnoDB to continue crash recovery here.
    180609 09:10:06 mysqld_safe mysqld from pid file /var/lib/mysql/srv11.example.com.pid ended
    
    ===============================
    
    
     
    #4 Ishank, Jun 8, 2018
    Last edited by a moderator: Jun 9, 2018
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,856
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice