-- 5.7.22 - build details cat docs/INFO_SRC commit: fc04cf3c6e54933e8720cd9754bef9acf9f36ccd date: 2018-03-04 14:35:40 +0100 build-date: 2018-03-04 14:40:53 +0100 short: fc04cf3 branch: mysql-5.7.22-release MySQL source 5.7.22 rm -rf 94383 bin/mysqld --initialize-insecure --basedir=$PWD --datadir=$PWD/94383 --log-error-verbosity=3 bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/94383 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/94383/log.err --log-error-verbosity=3 2>&1 & - create schema/table bin/mysql -uroot -S /tmp/mysql_ushastry.sock --prompt='mysql5722>' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.22 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql5722>create database test; Query OK, 1 row affected (0.00 sec) mysql5722>use test Database changed mysql5722>create table test_varchar(i int primary key, v varchar(40), key (v)); Query OK, 0 rows affected (0.01 sec) mysql5722>show create table test_varchar\G *************************** 1. row *************************** Table: test_varchar Create Table: CREATE TABLE `test_varchar` ( `i` int(11) NOT NULL, `v` varchar(40) DEFAULT NULL, PRIMARY KEY (`i`), KEY `v` (`v`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.01 sec) mysql5722> bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [1]+ Done bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/94383 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=$PWD/94383/log.err --log-error-verbosity=3 2>&1 - Shutdown and upgrade to 5.7.25 (apply full dainostic patch from the report) export LD_LIBRARY_PATH=/export/umesh/utils/GCC-7.3.0/lib64 export CC=/export/umesh/utils/GCC-7.3.0/bin/gcc export CPP=/export/umesh/utils/GCC-7.3.0/bin/cpp export CXX=/export/umesh/utils/GCC-7.3.0/bin/c++ mkdir bld && cd bld cmake .. -DBUILD_CONFIG=mysql_release -DINSTALL_LAYOUT=STANDALONE -DWITH_INNODB_MEMCACHED=1 -DWITH_SSL=system -DCMAKE_BUILD_TYPE=RelWithDebInfo '-DCOMPILATION_COMMENT=MySQL Community - GPL' '-DCOMPILATION_COMMENT_SERVER=MySQL Community Server - GPL' -DFEATURE_SET=community -DWITH_CURL=system -DPLATFORM=el7 -DREPRODUCIBLE_BUILD=ON -DWITH_BOOST=../boost -DCMAKE_INSTALL_PREFIX=/export/umesh/server/source/bugs/src_build/fb_builds/94383/mysql-5.7.25/bld make -j32 make install cat docs/INFO_SRC commit: b15f075d6ab0ca08be51a9dbf3113fc551f327e4 date: 2018-12-21 16:01:17 +0530 build-date: 2018-12-21 11:39:54 +0100 short: b15f075 branch: mysql-5.7.25-release MySQL source 5.7.25 - in place upgrade - Bring up 5.7.25 with 5.7.22 datadir, upgrade -> shutdown -> bring up bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383/log.err --log-error-verbosity=3 2>&1 & bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.25 MySQL Community - GPL Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> \q Bye [umshastr@hod03]/export/umesh/server/source/bugs/src_build/fb_builds/94383/mysql-5.7.25/bld: bin/mysql_upgrade -uroot -S /tmp/mysql_ushastry.sock --force Checking server version. Running queries to upgrade MySQL server. mysql_upgrade: [ERROR] 2013: Lost connection to MySQL server during query mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away Checking system database. Failed to run query "SET SQL_LOG_BIN=0" Error: MySQL server has gone away Failed to run query "SET SQL_LOG_BIN=0" Error: MySQL server has gone away Upgrading the sys schema. mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away mysql_upgrade: [ERROR] 2006: MySQL server has gone away Error occurred: Cannot select mysql database. [1]+ Aborted (core dumped) bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383/log.err --log-error-verbosity=3 2>&1 ## again started 5.7.25(mysql_upgrade crashing Server, skipped to see ALTER...) : bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.7.25 MySQL Community - GPL Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> alter table test_varchar comment 'test-5.7.25'; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> \q Bye [1]+ Aborted (core dumped) bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383 --core-file --socket=/tmp/mysql_ushastry.sock --port=3333 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383/log.err --log-error-verbosity=3 2>&1 - ALTER triggered core bt (gdb) bt #0 0x00007f52a7468771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000e6d1f7 in my_write_core (sig=) at ../../mysys/stacktrace.c:249 #2 0x00000000007708d5 in handle_fatal_signal (sig=6) at ../../sql/signal_handler.cc:220 #3 #4 0x00007f52a558a5d7 in raise () from /lib64/libc.so.6 #5 0x00007f52a558bcc8 in abort () from /lib64/libc.so.6 #6 0x00000000007475b8 in ut_dbg_assertion_failed (expr=expr@entry=0x1535784 "!\"BUG25\"", file=file@entry=0x15350f8 "../../../storage/innobase/row/row0merge.cc", line=line@entry=4437) at ../../../storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000000f7fdf3 in row_merge_build_indexes (trx=, old_table=old_table@entry=0x7f5250011f58, new_table=new_table@entry=0x7f5250010198, online=, indexes=, key_numbers=, n_indexes=, table=, add_cols=, col_map=, add_autoinc=, sequence=..., skip_pk_sort=, stage=, add_v=, eval_table=) at ../../../storage/innobase/row/row0merge.cc:4437 #8 0x0000000000ecc70f in ha_innobase::inplace_alter_table (this=0x7f5250011af0, altered_table=0x7f525001a860, ha_alter_info=0x7f52882a8fb0) at ../../../storage/innobase/handler/handler0alter.cc:6338 #9 0x0000000000ca5ee5 in ha_inplace_alter_table (ha_alter_info=0x7f52882a8fb0, altered_table=0x7f525001a860, this=) at ../../sql/handler.h:3434 #10 mysql_inplace_alter_table (target_mdl_request=0x7f52882a85a0, alter_ctx=0x7f52882a9530, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, ha_alter_info=0x7f52882a8fb0, altered_table=0x7f525001a860, table=, table_list=0x7f5250006010, thd=0x7f5250000ae0) at ../../sql/sql_table.cc:7586 #11 mysql_alter_table (thd=thd@entry=0x7f5250000ae0, new_db=, new_name=, create_info=create_info@entry=0x7f52882aa100, table_list=, table_list@entry=0x7f5250006010, alter_info=alter_info@entry=0x7f52882aa050) at ../../sql/sql_table.cc:9805 #12 0x0000000000d9ed6c in Sql_cmd_alter_table::execute (this=, thd=0x7f5250000ae0) at ../../sql/sql_alter.cc:326 #13 0x0000000000c3652e in mysql_execute_command (thd=thd@entry=0x7f5250000ae0, first_level=first_level@entry=true) at ../../sql/sql_parse.cc:4835 #14 0x0000000000c3b385 in mysql_parse (thd=thd@entry=0x7f5250000ae0, parser_state=parser_state@entry=0x7f52882ab660) at ../../sql/sql_parse.cc:5570 #15 0x0000000000c3c2c7 in dispatch_command (thd=thd@entry=0x7f5250000ae0, com_data=com_data@entry=0x7f52882abcc0, command=COM_QUERY) at ../../sql/sql_parse.cc:1484 #16 0x0000000000c3d950 in do_command (thd=thd@entry=0x7f5250000ae0) at ../../sql/sql_parse.cc:1025 #17 0x0000000000cfc2e0 in handle_connection (arg=arg@entry=0x44fe220) at ../../sql/conn_handler/connection_handler_per_thread.cc:306 #18 0x00000000011c79b4 in pfs_spawn_thread (arg=0x445de80) at ../../../storage/perfschema/pfs.cc:2190 #19 0x00007f52a7463df5 in start_thread () from /lib64/libpthread.so.0 #20 0x00007f52a564b60d in clone () from /lib64/libc.so.6 (gdb) -- mysql_upgrade triggered core bt (gdb) bt #0 0x00007f8148a45771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000e6d1f7 in my_write_core (sig=) at ../../mysys/stacktrace.c:249 #2 0x00000000007708d5 in handle_fatal_signal (sig=6) at ../../sql/signal_handler.cc:220 #3 #4 0x00007f8146b675d7 in raise () from /lib64/libc.so.6 #5 0x00007f8146b68cc8 in abort () from /lib64/libc.so.6 #6 0x00000000007475b8 in ut_dbg_assertion_failed (expr=expr@entry=0x1535784 "!\"BUG25\"", file=file@entry=0x15350f8 "../../../storage/innobase/row/row0merge.cc", line=line@entry=4437) at ../../../storage/innobase/ut/ut0dbg.cc:67 #7 0x0000000000f7fdf3 in row_merge_build_indexes (trx=, old_table=old_table@entry=0x3d9a068, new_table=new_table@entry=0x7f80f8268698, online=, indexes=, key_numbers=, n_indexes=, table=, add_cols=, col_map=, add_autoinc=, sequence=..., skip_pk_sort=, stage=, add_v=, eval_table=) at ../../../storage/innobase/row/row0merge.cc:4437 #8 0x0000000000ecc70f in ha_innobase::inplace_alter_table (this=0x7f80f8032aa0, altered_table=0x7f80f8024560, ha_alter_info=0x7f8128483fb0) at ../../../storage/innobase/handler/handler0alter.cc:6338 #9 0x0000000000ca5ee5 in ha_inplace_alter_table (ha_alter_info=0x7f8128483fb0, altered_table=0x7f80f8024560, this=) at ../../sql/handler.h:3434 #10 mysql_inplace_alter_table (target_mdl_request=0x7f81284835a0, alter_ctx=0x7f8128484530, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, ha_alter_info=0x7f8128483fb0, altered_table=0x7f80f8024560, table=, table_list=0x7f80f8014470, thd=0x7f80f800ed00) at ../../sql/sql_table.cc:7586 #11 mysql_alter_table (thd=thd@entry=0x7f80f800ed00, new_db=, new_name=, create_info=create_info@entry=0x7f8128485100, table_list=, table_list@entry=0x7f80f8014470, alter_info=alter_info@entry=0x7f8128485050) at ../../sql/sql_table.cc:9805 #12 0x0000000000d9ed6c in Sql_cmd_alter_table::execute (this=, thd=0x7f80f800ed00) at ../../sql/sql_alter.cc:326 #13 0x0000000000c3652e in mysql_execute_command (thd=thd@entry=0x7f80f800ed00, first_level=first_level@entry=true) at ../../sql/sql_parse.cc:4835 #14 0x0000000000c3b385 in mysql_parse (thd=thd@entry=0x7f80f800ed00, parser_state=parser_state@entry=0x7f8128486660) at ../../sql/sql_parse.cc:5570 #15 0x0000000000c3c2c7 in dispatch_command (thd=thd@entry=0x7f80f800ed00, com_data=com_data@entry=0x7f8128486cc0, command=COM_QUERY) at ../../sql/sql_parse.cc:1484 #16 0x0000000000c3d950 in do_command (thd=thd@entry=0x7f80f800ed00) at ../../sql/sql_parse.cc:1025 #17 0x0000000000cfc2e0 in handle_connection (arg=arg@entry=0x3685ee0) at ../../sql/conn_handler/connection_handler_per_thread.cc:306 #18 0x00000000011c79b4 in pfs_spawn_thread (arg=0x3e6f2c0) at ../../../storage/perfschema/pfs.cc:2190 #19 0x00007f8148a40df5 in start_thread () from /lib64/libpthread.so.0 #20 0x00007f8146c2860d in clone () from /lib64/libc.so.6 (gdb) -- extract from error log 2019-02-19T05:52:38.826603Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190219 6:52:38 2019-02-19T05:52:38.830418Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2019-02-19T05:52:38.830464Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2019-02-19T05:52:39.534982Z 0 [Note] Auto generated SSL certificates are placed in data directory. 2019-02-19T05:52:39.542673Z 0 [Warning] CA certificate ca.pem is self signed. 2019-02-19T05:52:39.648296Z 0 [Note] Auto generated RSA key files are placed in data directory. 2019-02-19T05:52:39.648500Z 0 [Note] Server hostname (bind-address): '*'; port: 3333 2019-02-19T05:52:39.648556Z 0 [Note] IPv6 is available. 2019-02-19T05:52:39.648574Z 0 [Note] - '::' resolves to '::'; 2019-02-19T05:52:39.648600Z 0 [Note] Server socket created on IP: '::'. 2019-02-19T05:52:39.657206Z 0 [Note] Event Scheduler: Loaded 0 events 2019-02-19T05:52:39.657377Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.25' socket: '/tmp/mysql_ushastry.sock' port: 3333 MySQL Community - GPL #debug 25 in has_index_def_changed 1 ret True for PRIMARY #debug 25 in has_index_def_changed alg 0 vs 0 #debug 25 in has_index_def_changed parts 1 vs 1 #debug 25 in has_index_def_changed flags 33 vs 1 and mask 11699 #debug 25 in fill_alter_inplace_info need modify key PRIMARY to PRIMARY #debug BUG25-enter-ha_innobase::inplace_alter_table #debug BUG25-p0-ha_innobase::inplace_alter_table flags 17301554 and 412334097589, expect not 2019-02-19 06:53:07 0x7f8128487700 InnoDB: Assertion failure in thread 140192703346432 in file row0merge.cc line 4437 InnoDB: Failing assertion: !"BUG25" InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. BUG25-enter-row_merge_build_indexes #debug 25 n_indexes is now 1 #debug 25 finds 1 indexes 05:53:07 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68196 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f80f800ed00 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f8128486d40 thread_stack 0x40000 bin/mysqld(my_print_stacktrace+0x2c)[0xe6de4c] bin/mysqld(handle_fatal_signal+0x47b)[0x77096b] /lib64/libpthread.so.0(+0xf130)[0x7f8148a48130] /lib64/libc.so.6(gsignal+0x37)[0x7f8146b675d7] /lib64/libc.so.6(abort+0x148)[0x7f8146b68cc8] bin/mysqld[0x7475b8] bin/mysqld(_Z23row_merge_build_indexesP5trx_tP12dict_table_tS2_bPP12dict_index_tPKmmP5TABLEPK8dtuple_tS7_mR13ib_sequence_tbP16ut_stage_alter_tPK16dict_add_v_col_tS9_+0x413)[0xf7fdf3] bin/mysqld(_ZN11ha_innobase19inplace_alter_tableEP5TABLEP18Alter_inplace_info+0x25f)[0xecc70f] bin/mysqld(_Z17mysql_alter_tableP3THDPKcS2_P24st_ha_create_informationP10TABLE_LISTP10Alter_info+0x3bf5)[0xca5ee5] bin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x4bc)[0xd9ed6c] bin/mysqld(_Z21mysql_execute_commandP3THDb+0x1e3e)[0xc3652e] bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3a5)[0xc3b385] bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xe17)[0xc3c2c7] bin/mysqld(_Z10do_commandP3THD+0x200)[0xc3d950] bin/mysqld(handle_connection+0x290)[0xcfc2e0] bin/mysqld(pfs_spawn_thread+0x154)[0x11c79b4] /lib64/libpthread.so.0(+0x7df5)[0x7f8148a40df5] /lib64/libc.so.6(clone+0x6d)[0x7f8146c2860d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f80f8013960): ALTER TABLE plugin MODIFY name varchar(64) COLLATE utf8_general_ci NOT NULL DEFAULT '', MODIFY dl varchar(128) COLLATE utf8_general_ci NOT NULL DEFAULT '', CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci Connection ID (thread ID): 3 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file 2019-02-19T05:53:50.659557Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-02-19T05:53:50.659731Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2019-02-19T05:53:50.659790Z 0 [Note] bin/mysqld (mysqld 5.7.25) starting as process 3644 ... 2019-02-19T05:53:50.665844Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-02-19T05:53:50.665886Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-02-19T05:53:50.665902Z 0 [Note] InnoDB: Uses event mutexes 2019-02-19T05:53:50.665911Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-02-19T05:53:50.665918Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2019-02-19T05:53:50.665924Z 0 [Note] InnoDB: Using Linux native AIO 2019-02-19T05:53:50.666251Z 0 [Note] InnoDB: Number of pools: 1 2019-02-19T05:53:50.666370Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-02-19T05:53:50.668171Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-02-19T05:53:50.677804Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-02-19T05:53:50.680260Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-02-19T05:53:50.693029Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-02-19T05:53:50.694779Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2595370 2019-02-19T05:53:50.694811Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2598786 2019-02-19T05:53:50.695069Z 0 [Note] InnoDB: Database was not shutdown normally! 2019-02-19T05:53:50.695077Z 0 [Note] InnoDB: Starting crash recovery. 2019-02-19T05:53:50.700626Z 0 [Note] InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percent: 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 2019-02-19T05:53:51.203821Z 0 [Note] InnoDB: Apply batch completed 2019-02-19T05:53:51.309564Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2019-02-19T05:53:51.309598Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-02-19T05:53:51.309686Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-02-19T05:53:51.329644Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-02-19T05:53:51.330507Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-02-19T05:53:51.330523Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-02-19T05:53:51.330914Z 0 [Note] InnoDB: Waiting for purge to start 2019-02-19T05:53:51.381044Z 0 [Note] InnoDB: 5.7.25 started; log sequence number 2598786 2019-02-19T05:53:51.381237Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.22/94383/ib_buffer_pool 2019-02-19T05:53:51.381420Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-02-19T05:53:51.383264Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190219 6:53:51 2019-02-19T05:53:51.387270Z 0 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2019-02-19T05:53:51.387315Z 0 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2019-02-19T05:53:51.389157Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-02-19T05:53:51.389172Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-02-19T05:53:51.395650Z 0 [Warning] CA certificate ca.pem is self signed. 2019-02-19T05:53:51.395715Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2019-02-19T05:53:51.395850Z 0 [Note] Server hostname (bind-address): '*'; port: 3333 2019-02-19T05:53:51.395904Z 0 [Note] IPv6 is available. 2019-02-19T05:53:51.395917Z 0 [Note] - '::' resolves to '::'; 2019-02-19T05:53:51.395935Z 0 [Note] Server socket created on IP: '::'. 2019-02-19T05:53:51.405532Z 0 [Note] Event Scheduler: Loaded 0 events 2019-02-19T05:53:51.405674Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.25' socket: '/tmp/mysql_ushastry.sock' port: 3333 MySQL Community - GPL 2019-02-19T05:53:58.051668Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name. Please run mysql_upgrade 2019-02-19T05:53:58.051696Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade #debug 25 in has_index_def_changed 1 ret True for v #debug 25 in has_index_def_changed alg 0 vs 0 #debug 25 in has_index_def_changed parts 1 vs 1 #debug 25 in has_index_def_changed flags 32 vs 0 and mask 11699 #debug 25 in fill_alter_inplace_info need modify key v to v #debug 25 drop fill_alter_inplace_info non unique v index BUG #debug BUG25-enter-ha_innobase::inplace_alter_table #debug BUG25-p0-ha_innobase::inplace_alter_table flags 16777219 and 412334097589, expect not 2019-02-19 06:54:12 0x7f52882ac700 InnoDB: Assertion failure in thread 139992448550656 in file row0merge.cc line 4437 InnoDB: Failing assertion: !"BUG25" InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. BUG25-enter-row_merge_build_indexes #debug 25 n_indexes is now 2 #debug 25 finds 2 indexes 05:54:12 UTC - mysqld got signal 6 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=1 max_threads=151 thread_count=1 connection_count=1 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 68196 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7f5250000ae0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f52882abd40 thread_stack 0x40000 bin/mysqld(my_print_stacktrace+0x2c)[0xe6de4c] bin/mysqld(handle_fatal_signal+0x47b)[0x77096b] /lib64/libpthread.so.0(+0xf130)[0x7f52a746b130] /lib64/libc.so.6(gsignal+0x37)[0x7f52a558a5d7] /lib64/libc.so.6(abort+0x148)[0x7f52a558bcc8] bin/mysqld[0x7475b8] bin/mysqld(_Z23row_merge_build_indexesP5trx_tP12dict_table_tS2_bPP12dict_index_tPKmmP5TABLEPK8dtuple_tS7_mR13ib_sequence_tbP16ut_stage_alter_tPK16dict_add_v_col_tS9_+0x413)[0xf7fdf3] bin/mysqld(_ZN11ha_innobase19inplace_alter_tableEP5TABLEP18Alter_inplace_info+0x25f)[0xecc70f] bin/mysqld(_Z17mysql_alter_tableP3THDPKcS2_P24st_ha_create_informationP10TABLE_LISTP10Alter_info+0x3bf5)[0xca5ee5] bin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x4bc)[0xd9ed6c] bin/mysqld(_Z21mysql_execute_commandP3THDb+0x1e3e)[0xc3652e] bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3a5)[0xc3b385] bin/mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xe17)[0xc3c2c7] bin/mysqld(_Z10do_commandP3THD+0x200)[0xc3d950] bin/mysqld(handle_connection+0x290)[0xcfc2e0] bin/mysqld(pfs_spawn_thread+0x154)[0x11c79b4] /lib64/libpthread.so.0(+0x7df5)[0x7f52a7463df5] /lib64/libc.so.6(clone+0x6d)[0x7f52a564b60d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f5250005640): alter table test_varchar comment 'test-5.7.25' Connection ID (thread ID): 2 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file