Support Questions
Find answers, ask questions, and share your expertise

MySQL getting stopped and restart automatically

MySQL getting stopped and restart automatically

Explorer

161026 21:39:59 [Note] Event Scheduler: Purging the queue. 0 events 161026 21:40:01 InnoDB: Starting shutdown... 161026 21:40:02 InnoDB: Shutdown completed; log sequence number 0 2372512280 161026 21:40:02 [Note] /usr/libexec/mysqld: Shutdown complete 161026 21:40:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 161026 21:40:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 161026 21:40:03 InnoDB: Initializing buffer pool, size = 8.0M 161026 21:40:03 InnoDB: Completed initialization of buffer pool 161026 21:40:03 InnoDB: Started; log sequence number 0 2372512280 161026 21:40:03 [Note] Event Scheduler: Loaded 0 events 161026 21:40:03 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution 161117 0:53:53 [Note] /usr/libexec/mysqld: Normal shutdown 161117 0:53:53 [Note] Event Scheduler: Purging the queue. 0 events 161117 0:53:55 InnoDB: Starting shutdown... 161117 0:53:56 InnoDB: Shutdown completed; log sequence number 0 2558552819 161117 0:53:56 [Note] /usr/libexec/mysqld: Shutdown complete 161117 00:53:56 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 161117 00:53:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 161117 0:53:57 InnoDB: Initializing buffer pool, size = 8.0M 161117 0:53:57 InnoDB: Completed initialization of buffer pool 161117 0:53:57 InnoDB: Started; log sequence number 0 2558552819 161117 0:53:57 [Note] Event Scheduler: Loaded 0 events 161117 0:53:57 [Note] /usr/libexec/mysqld: ready for connections. Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

HDP version:2.3.4

Ambari version: 2.2.1

Results from

rpm -qa |grep mysql

mysql-libs-5.1.73-5.el6_6.x86_64 mysql-5.1.73-5.el6_6.x86_64

mysql-connector-java-5.1.17-6.el6.noarch

mysql-server-5.1.73-5.el6_6.x86_64