Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] /usr/sbin/mysqld: Normal shutdown Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569831168 [Note] Slave SQL thread exiting, replication stopped in log 'node100-bin.005425' at position 316493939 Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] Event Scheduler: Purging the queue. 0 events Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676570097408 [ERROR] Error reading packet from server: Lost connection to MySQL server during query ( server_errno=2013) Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676570097408 [Note] Slave I/O thread exiting, read up to log 'node100-bin.005436', position 601224429 Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139509970724608 [Note] InnoDB: FTS optimize thread exiting. Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139676569564928 [Note] InnoDB: Starting shutdown... Sep 1 12:36:39 node438 mysqld[2057]: 2016-09-01 12:36:39 139509987510016 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool Sep 1 12:36:42 node438 mysqld[2057]: 2016-09-01 12:36:42 139509987510016 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:36:42 Sep 1 12:37:43 node438 mysqld[2057]: 2016-09-01 12:37:43 139676569564928 [Note] InnoDB: Shutdown completed; log sequence number 392840234947 Sep 1 12:37:50 node438 mysqld[2057]: 2016-09-01 12:37:50 139676569564928 [Note] /usr/sbin/mysqld: Shutdown complete Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] /usr/sbin/mysqld (mysqld 10.1.17-MariaDB-1~jessie) starting as process 44714 ... Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using mutexes to ref count buffer pool pages Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: The InnoDB memory heap is disabled Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Compressed tables use zlib 1.2.8 Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using Linux native AIO Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Using SSE crc32 instructions Sep 1 12:41:01 node438 mysqld_safe[44689]: 2016-09-01 12:41:01 140538167474112 [Note] InnoDB: Initializing buffer pool, size = 141.0G Sep 1 12:41:06 node438 mysqld_safe[44689]: 2016-09-01 12:41:06 140538167474112 [Note] InnoDB: Completed initialization of buffer pool Sep 1 12:41:07 node438 mysqld_safe[44689]: 2016-09-01 12:41:07 140538167474112 [Note] InnoDB: Highest supported file format is Barracuda. Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: 128 rollback segment(s) are active. Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: Waiting for purge to start Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 392840234947 Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Note] InnoDB: Dumping buffer pool(s) not yet started Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 7faacb7f8700 InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool Sep 1 12:41:10 node438 mysqld_safe[44689]: ERROR: 1136 Column count doesn't match value count at row 1 Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140538167474112 [ERROR] Aborting Sep 1 12:41:10 node438 mysqld_safe[44689]: Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 7faacb7f8700 InnoDB: Buffer pool(s) load completed at 160901 12:41:10 (/data/mysql/data/ib_buffer_pool was empty) Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool Sep 1 12:41:10 node438 mysqld_safe[44689]: 2016-09-01 12:41:10 140371535300352 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:41:10 Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: Installation of system tables failed! Examine the logs in Sep 1 12:41:17 node438 mysqld_safe[44689]: /data/mysql/data for more information. Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: The problem could be conflicting information in an external Sep 1 12:41:17 node438 mysqld_safe[44689]: my.cnf files. You can ignore these by doing: Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: You can also try to start the mysqld daemon with: Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: shell> /usr/sbin/mysqld --skip-grant --general-log & Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: and use the command line tool /usr/bin/mysql Sep 1 12:41:17 node438 mysqld_safe[44689]: to connect to the mysql database and look at the grant tables: Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: shell> /usr/bin/mysql -u root mysql Sep 1 12:41:17 node438 mysqld_safe[44689]: mysql> show tables; Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: Try 'mysqld --help' if you have problems with paths. Using Sep 1 12:41:17 node438 mysqld_safe[44689]: --general-log gives you a log in /data/mysql/data that may be helpful. Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: The latest information about mysql_install_db is available at Sep 1 12:41:17 node438 mysqld_safe[44689]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db Sep 1 12:41:17 node438 mysqld_safe[44689]: MariaDB is hosted on launchpad; You can find the latest source and Sep 1 12:41:17 node438 mysqld_safe[44689]: email lists at http://launchpad.net/maria Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:17 node438 mysqld_safe[44689]: Please check all of the above before submitting a bug report Sep 1 12:41:17 node438 mysqld_safe[44689]: at http://mariadb.org/jira Sep 1 12:41:17 node438 mysqld_safe[44689]: Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] /usr/sbin/mysqld (mysqld 10.1.17-MariaDB-1~jessie) starting as process 45049 ... Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using mutexes to ref count buffer pool pages Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: The InnoDB memory heap is disabled Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Compressed tables use zlib 1.2.8 Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using Linux native AIO Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Using SSE crc32 instructions Sep 1 12:41:18 node438 mysqld_safe[45024]: 2016-09-01 12:41:18 139747651045312 [Note] InnoDB: Initializing buffer pool, size = 141.0G Sep 1 12:41:23 node438 mysqld_safe[45024]: 2016-09-01 12:41:23 139747651045312 [Note] InnoDB: Completed initialization of buffer pool Sep 1 12:41:24 node438 mysqld_safe[45024]: 2016-09-01 12:41:24 139747651045312 [Note] InnoDB: Highest supported file format is Barracuda. Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: 128 rollback segment(s) are active. Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: Waiting for purge to start Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.31-77.0 started; log sequence number 392840236947 Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Note] InnoDB: Dumping buffer pool(s) not yet started Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 7ef2bcff8700 InnoDB: Loading buffer pool(s) from /data/mysql/data/ib_buffer_pool Sep 1 12:41:27 node438 mysqld_safe[45024]: ERROR: 1136 Column count doesn't match value count at row 1 Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139747651045312 [ERROR] Aborting Sep 1 12:41:27 node438 mysqld_safe[45024]: Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 7ef2bcff8700 InnoDB: Buffer pool(s) load completed at 160901 12:41:27 Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Warning] InnoDB: Dumping buffer pool(s) to /data/mysql/data/ib_buffer_pool Sep 1 12:41:27 node438 mysqld_safe[45024]: 2016-09-01 12:41:27 139581018048256 [Warning] InnoDB: Buffer pool(s) dump completed at 160901 12:41:27 Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: Installation of system tables failed! Examine the logs in Sep 1 12:41:35 node438 mysqld_safe[45024]: /data/mysql/data for more information. Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: The problem could be conflicting information in an external Sep 1 12:41:35 node438 mysqld_safe[45024]: my.cnf files. You can ignore these by doing: Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: shell> /usr/bin/scripts/mysql_install_db --defaults-file=~/.my.cnf Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: You can also try to start the mysqld daemon with: Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: shell> /usr/sbin/mysqld --skip-grant --general-log & Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: and use the command line tool /usr/bin/mysql Sep 1 12:41:35 node438 mysqld_safe[45024]: to connect to the mysql database and look at the grant tables: Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: shell> /usr/bin/mysql -u root mysql Sep 1 12:41:35 node438 mysqld_safe[45024]: mysql> show tables; Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: Try 'mysqld --help' if you have problems with paths. Using Sep 1 12:41:35 node438 mysqld_safe[45024]: --general-log gives you a log in /data/mysql/data that may be helpful. Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: The latest information about mysql_install_db is available at Sep 1 12:41:35 node438 mysqld_safe[45024]: https://mariadb.com/kb/en/installing-system-tables-mysql_install_db Sep 1 12:41:35 node438 mysqld_safe[45024]: MariaDB is hosted on launchpad; You can find the latest source and Sep 1 12:41:35 node438 mysqld_safe[45024]: email lists at http://launchpad.net/maria Sep 1 12:41:35 node438 mysqld_safe[45024]: Sep 1 12:41:35 node438 mysqld_safe[45024]: Please check all of the above before submitting a bug report Sep 1 12:41:35 node438 mysqld_safe[45024]: at http://mariadb.org/jira Sep 1 12:41:35 node438 mysqld_safe[45024]: