The service “mysql” appears to be down.

Dhruvhat

Registered
Aug 28, 2016
3
0
1
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
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?
Hello,

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

Thank you.
 

Dhruvhat

Registered
Aug 28, 2016
3
0
1
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
Hello,

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

Thank you.
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
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.