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.

The service “mysql” appears to be down.

Discussion in 'Database Discussions' started by Dhruvhat, Sep 2, 2016.

  1. Dhruvhat

    Dhruvhat Registered

    Joined:
    Aug 28, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi guys,
    I am getting this error
    Code:
    160825 15:22:09 mysqld_safe mysqld from pid file /var/lib/mysql/vps.example.in.pid ended
    2016-08-25 15:22:09 4168 [Note] /usr/sbin/mysqld: Shutdown complete
    2016-08-25 15:22:08 4168 [Warning] /usr/sbin/mysqld: Forcing close of thread 74 user: 'leechprotect'
    2016-08-25 15:22:06 4168 [Note] /usr/sbin/mysqld: Normal shutdown
    160825 15:03:26 mysqld_safe A mysqld process already exists
    2016-08-25 15:03:14 4168 [Note] /usr/sbin/mysqld: ready for connections.
    160825 15:03:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    
    
    Please help me how to solve this issue.
    Thanks
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,474
    Likes Received:
    202
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Looks like you restarted MySQL. Are you having some sort of issue?
     
  3. Dhruvhat

    Dhruvhat Registered

    Joined:
    Aug 28, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    I didn't restart it, I am getting this error in my mail and then my site goes down for 10 minutes.. after 10 minutes another mail comes with mysql recovered message,,, What should I do to solve this issue?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you review /var/lib/mysql/$hostname.err and let us know of any additional output during the times this happens?

    Thank you.
     
  5. Dhruvhat

    Dhruvhat Registered

    Joined:
    Aug 28, 2016
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Root Administrator
    This is in hostname.err,, Can you please tell me what is the issue and how to solve it?

    Code:
    160825 15:03:14 mysqld_safe Starting mysqld daemon with databases from
    
    /var/lib/                                                                    
    
                      mysql
    2016-08-25 15:03:14 0 [Warning] TIMESTAMP with implicit DEFAULT value is
    
    depreca                                                                      
    
                    ted. Please use --explicit_defaults_for_timestamp server
    
    option (see documentati                                                      
    
                                    on for more details).
    2016-08-25 15:03:14 0 [Note] /usr/sbin/mysqld (mysqld 5.6.31) starting as
    
    proces                                                                      
    
                   s 4168 ...
    2016-08-25 15:03:14 4168 [Note] Plugin 'FEDERATED' is disabled.
    2016-08-25 15:03:14 4168 [Note] InnoDB: Using atomics to ref count buffer pool
    
    p                                                                            
    
              ages
    2016-08-25 15:03:14 4168 [Note] InnoDB: The InnoDB memory heap is disabled
    2016-08-25 15:03:14 4168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic
    
    buil                                                                        
    
                 tins
    2016-08-25 15:03:14 4168 [Note] InnoDB: Memory barrier is not used
    2016-08-25 15:03:14 4168 [Note] InnoDB: Compressed tables use zlib 1.2.3
    2016-08-25 15:03:14 4168 [Note] InnoDB: Using Linux native AIO
    2016-08-25 15:03:14 4168 [Note] InnoDB: Using CPU crc32 instructions
    2016-08-25 15:03:14 4168 [Note] InnoDB: Initializing buffer pool, size =
    
    128.0M
    2016-08-25 15:03:14 4168 [Note] InnoDB: Completed initialization of buffer
    
    pool
    2016-08-25 15:03:14 4168 [Note] InnoDB: Highest supported file format is
    
    Barracu                                                                      
    
                    da.
    2016-08-25 15:03:14 4168 [Note] InnoDB: 128 rollback segment(s) are active.
    2016-08-25 15:03:14 4168 [Note] InnoDB: Waiting for purge to start
    2016-08-25 15:03:14 4168 [Note] InnoDB: 5.6.31 started; log sequence number
    
    1625                                                                        
    
                 987
    2016-08-25 15:03:14 4168 [Warning] No existing UUID has been found, so we
    
    assume                                                                      
    
                    that this is the first time that this server has been started.
    
    Generating a new                                                            
    
                              UUID: 84fec652-6ab3-11e6-8aa4-28a6c7f26832.
    2016-08-25 15:03:14 4168 [Note] Server hostname (bind-address): '*'; port:
    
    3306
    2016-08-25 15:03:14 4168 [Note] IPv6 is available.
    2016-08-25 15:03:14 4168 [Note]   - '::' resolves to '::';
    2016-08-25 15:03:14 4168 [Note] Server socket created on IP: '::'.
    2016-08-25 15:03:14 4168 [Note] Event Scheduler: Loaded 0 events
    2016-08-25 15:03:14 4168 [Note] /usr/sbin/mysqld: ready for connections.
    Version: '5.6.31'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL
    
    Commun                                                                      
    
                   ity Server (GPL)
    160825 15:03:26 mysqld_safe A mysqld process already exists
    2016-08-25 15:22:06 4168 [Note] /usr/sbin/mysqld: Normal shutdown
    
    2016-08-25 15:22:06 4168 [Note] Giving 1 client threads a chance to die
    
    graceful                                                                    
    
                     ly
    2016-08-25 15:22:06 4168 [Note] Event Scheduler: Purging the queue. 0 events
    2016-08-25 15:22:06 4168 [Note] Shutting down slave threads
    2016-08-25 15:22:08 4168 [Note] Forcefully disconnecting 1 remaining clients
    2016-08-25 15:22:08 4168 [Warning] /usr/sbin/mysqld: Forcing close of thread
    
    74                                                                          
    
                 user: 'leechprotect'
    
    2016-08-25 15:22:08 4168 [Note] Binlog end
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'partition'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'ARCHIVE'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_FT_DELETED'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin
    
    'INNODB_FT_DEFAULT_STOPWORD                                                  
    
                                        '
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_METRICS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin
    
    'INNODB_BUFFER_POOL_STATS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin
    
    'INNODB_CMP_PER_INDEX_RESET                                                  
    
                                        '
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_CMPMEM'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_CMP_RESET'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_CMP'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_LOCKS'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'INNODB_TRX'
    2016-08-25 15:22:08 4168 [Note] Shutting down plugin 'InnoDB'
    2016-08-25 15:22:08 4168 [Note] InnoDB: FTS optimize thread exiting.
    2016-08-25 15:22:08 4168 [Note] InnoDB: Starting shutdown...
    2016-08-25 15:22:09 4168 [Note] InnoDB: Shutdown completed; log sequence
    
    number                                                                      
    
                    1763729
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'BLACKHOLE'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'MRG_MYISAM'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'CSV'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'MEMORY'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'MyISAM'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'sha256_password'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'mysql_old_password'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'mysql_native_password'
    2016-08-25 15:22:09 4168 [Note] Shutting down plugin 'binlog'
    2016-08-25 15:22:09 4168 [Note] /usr/sbin/mysqld: Shutdown complete
    
    160825 15:22:09 mysqld_safe mysqld from pid file
    
    /var/lib/mysql/vps.example.i                                              
    
                                            n.pid ended
    
     
    #5 Dhruvhat, Sep 4, 2016
    Last edited by a moderator: Sep 4, 2016
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello,

    The output does not indicate a reason for the MySQL failure. Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page