## Used binary tarball(s), fetched from internal repository
## 5.5.61

rm -rf 93101/
scripts/mysql_install_db --basedir=$PWD --datadir=$PWD/93101 -v
bin/mysqld --no-defaults --basedir=$PWD --datadir=$PWD/93101 --core-file --socket=/tmp/mysql_ushastry.sock   --port=9999 --log-error=$PWD/93101/log.err 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.5.61: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.61 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.

mysql> use test
Database changed
mysql> CREATE DATABASE d1; CREATE TABLE d1.t1 (num int, val varchar(32), dt DATETIME); INSERT INTO d1.t1 VALUES (1, 'one', NOW());
Query OK, 1 row affected (0.00 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected (0.01 sec)

mysql> SHOW CREATE TABLE d1.t1\G SELECT * FROM d1.t1
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `num` int(11) DEFAULT NULL,
  `val` varchar(32) DEFAULT NULL,
  `dt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.01 sec)

    -> \G
*************************** 1. row ***************************
num: 1
val: one
 dt: 2018-11-08 06:38:24
1 row in set (0.00 sec)

mysql>

### In place Upgrade to 5.6.42

bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock   --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1 &

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.6.42_old: cd ../mysql-advanced-5.6.42/
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock   --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1 &
[1] 31122
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: 2018-11-08 06:40:25 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-08 06:40:25 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-11-08 06:40:25 0 [Note] bin/mysqld (mysqld 5.6.42-enterprise-commercial-advanced) starting as process 31122 ...

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysql_upgrade -uroot -S /tmp/mysql_ushastry.sock
Looking for 'mysql' as: bin/mysql
Looking for 'mysqlcheck' as: bin/mysqlcheck
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql_8012.sock' '--port=9999' '--socket=/tmp/mysql_ushastry.sock'
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql_8012.sock' '--port=9999' '--socket=/tmp/mysql_ushastry.sock'
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.proxies_priv                                 OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
Running 'mysql_fix_privilege_tables'...
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql_8012.sock' '--port=9999' '--socket=/tmp/mysql_ushastry.sock'
Running 'mysqlcheck' with connection arguments: '--socket=/tmp/mysql_8012.sock' '--port=9999' '--socket=/tmp/mysql_ushastry.sock'
d1.t1                                              OK
OK
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock   --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1 &
[1] 31173
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: 2018-11-08 06:41:41 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-08 06:41:41 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-11-08 06:41:41 0 [Note] bin/mysqld (mysqld 5.6.42-enterprise-commercial-a
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "SHOW CREATE TABLE d1.t1\G SELECT * FROM d1.t1"
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `num` int(11) DEFAULT NULL,
  `val` varchar(32) DEFAULT NULL,
  `dt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
+------+------+---------------------+
| num  | val  | dt                  |
+------+------+---------------------+
|    1 | one  | 2018-11-08 06:38:24 |
+------+------+---------------------+
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42:

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1

### Upgrade 5.7 (without user-tables by `--upgrade-system-tables` )


[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.42: cd ../mysql-5.7.24
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock   --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1 &
[1] 31899
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql_upgrade -uroot -S /tmp/mysql_ushastry.sock --upgrade-system-tables                                          The --upgrade-system-tables option was used, databases won't be touched.
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Upgrading the sys schema.
Upgrade process completed successfully.
Checking if update is needed.
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24:
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock   --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1 &
[1] 31936
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "SHOW CREATE TABLE d1.t1\G SELECT * FROM d1.t1"
*************************** 1. row ***************************
       Table: t1
Create Table: CREATE TABLE `t1` (
  `num` int(11) DEFAULT NULL,
  `val` varchar(32) DEFAULT NULL,
  `dt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
+------+------+---------------------+
| num  | val  | dt                  |
+------+------+---------------------+
|    1 | one  | 2018-11-08 06:38:24 |
+------+------+---------------------+
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.24 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.


mysql> \q
Bye
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.24: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown
[1]+  Done                    bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1

### Upgrade 8.0 fails

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: bin/mysqld --no-defaults --basedir=$PWD --datadir=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101 --core-file --socket=/tmp/mysql_ushastry.sock --port=9999 --log-error=/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err 2>&1
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13:
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql_ushastry.sock' (2)
[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13:

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-8.0.13: cat /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/log.err
181108  6:38:01 [Note] Plugin 'FEDERATED' is disabled.
181108  6:38:01 InnoDB: The InnoDB memory heap is disabled
181108  6:38:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
181108  6:38:01 InnoDB: Compressed tables use zlib 1.2.3
181108  6:38:01 InnoDB: Using Linux native AIO
181108  6:38:01 InnoDB: Initializing buffer pool, size = 128.0M
181108  6:38:01 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
181108  6:38:01  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
181108  6:38:01  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
181108  6:38:01  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
181108  6:38:01  InnoDB: Waiting for the background threads to start
181108  6:38:02 InnoDB: 5.5.61 started; log sequence number 0
181108  6:38:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 9999
181108  6:38:02 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
181108  6:38:02 [Note] Server socket created on IP: '0.0.0.0'.
181108  6:38:02 [Note] Event Scheduler: Loaded 0 events
181108  6:38:02 [Note] bin/mysqld: ready for connections.
Version: '5.5.61'  socket: '/tmp/mysql_ushastry.sock'  port: 9999  MySQL Community Server (GPL)
181108  6:39:19 [Note] bin/mysqld: Normal shutdown

181108  6:39:19 [Note] Event Scheduler: Purging the queue. 0 events
181108  6:39:19  InnoDB: Starting shutdown...
181108  6:39:20  InnoDB: Shutdown completed; log sequence number 1599087
181108  6:39:20 [Note] bin/mysqld: Shutdown complete

2018-11-08 06:40:25 31122 [Note] Plugin 'FEDERATED' is disabled.
2018-11-08 06:40:25 31122 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-11-08 06:40:25 31122 [Note] InnoDB: The InnoDB memory heap is disabled
2018-11-08 06:40:25 31122 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-08 06:40:25 31122 [Note] InnoDB: Memory barrier is not used
2018-11-08 06:40:25 31122 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-08 06:40:25 31122 [Note] InnoDB: Using Linux native AIO
2018-11-08 06:40:25 31122 [Note] InnoDB: Using CPU crc32 instructions
2018-11-08 06:40:25 31122 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-11-08 06:40:25 31122 [Note] InnoDB: Completed initialization of buffer pool
2018-11-08 06:40:25 31122 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-08 06:40:25 31122 [Warning] InnoDB: Resizing redo log from 2*320 to 2*3072 pages, LSN=1599087
2018-11-08 06:40:25 31122 [Warning] InnoDB: Starting to delete and rewrite log files.
2018-11-08 06:40:25 31122 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-11-08 06:40:25 31122 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-11-08 06:40:25 31122 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-11-08 06:40:25 31122 [Warning] InnoDB: New log files created, LSN=1599087
2018-11-08 06:40:25 31122 [Note] InnoDB: 128 rollback segment(s) are active.
2018-11-08 06:40:25 31122 [Note] InnoDB: Creating tablespace and datafile system tables.
2018-11-08 06:40:25 31122 [Note] InnoDB: Tablespace and datafile system tables created.
2018-11-08 06:40:25 31122 [Note] InnoDB: Waiting for purge to start
2018-11-08 06:40:25 31122 [Note] InnoDB: 5.6.42 started; log sequence number 1599087
2018-11-08 06:40:25 31122 [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: cadd5856-e318-11e8-a662-0010e05f3e06.
2018-11-08 06:40:25 31122 [Note] RSA private key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101//private_key.pem. Some authentication plugins will not work.
2018-11-08 06:40:25 31122 [Note] RSA public key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101//public_key.pem. Some authentication plugins will not work.
2018-11-08 06:40:25 31122 [Note] Server hostname (bind-address): '*'; port: 9999
2018-11-08 06:40:25 31122 [Note] IPv6 is available.
2018-11-08 06:40:25 31122 [Note]   - '::' resolves to '::';
2018-11-08 06:40:25 31122 [Note] Server socket created on IP: '::'.
2018-11-08 06:40:25 31122 [ERROR] Column count of mysql.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50561, now running 50642. Please use mysql_upgrade to fix this error.
2018-11-08 06:40:25 31122 [ERROR] Column count of mysql.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50561, now running 50642. Please use mysql_upgrade to fix this error.
2018-11-08 06:40:25 31122 [ERROR] Column count of mysql.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50561, now running 50642. Please use mysql_upgrade to fix this error.
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Column count of mysql.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50561, now running 50642. Please use mysql_upgrade to fix this error.
2018-11-08 06:40:25 31122 [ERROR] Column count of mysql.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50561, now running 50642. Please use mysql_upgrade to fix this error.
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Column count of mysql.threads is wrong. Expected 14, found 3. Created with MySQL 50561, now running 50642. Please use mysql_upgrade to fix this error.
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2018-11-08 06:40:25 31122 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2018-11-08 06:40:25 31122 [Note] Event Scheduler: Loaded 0 events
2018-11-08 06:40:25 31122 [Note] bin/mysqld: ready for connections.
Version: '5.6.42-enterprise-commercial-advanced'  socket: '/tmp/mysql_ushastry.sock'  port: 9999  MySQL Enterprise Server - Advanced Edition (Commercial)
2018-11-08 06:41:35 31122 [Note] bin/mysqld: Normal shutdown

2018-11-08 06:41:35 31122 [Note] Giving 0 client threads a chance to die gracefully
2018-11-08 06:41:35 31122 [Note] Event Scheduler: Purging the queue. 0 events
2018-11-08 06:41:35 31122 [Note] Shutting down slave threads
2018-11-08 06:41:35 31122 [Note] Forcefully disconnecting 0 remaining clients
2018-11-08 06:41:35 31122 [Note] Binlog end
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'partition'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_METRICS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_CMP'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'INNODB_TRX'
2018-11-08 06:41:35 31122 [Note] Shutting down plugin 'InnoDB'
2018-11-08 06:41:35 31122 [Note] InnoDB: FTS optimize thread exiting.
2018-11-08 06:41:35 31122 [Note] InnoDB: Starting shutdown...
2018-11-08 06:41:37 31122 [Note] InnoDB: Shutdown completed; log sequence number 1629972
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'BLACKHOLE'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'ARCHIVE'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'MEMORY'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'MRG_MYISAM'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'MyISAM'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'CSV'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'sha256_password'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'mysql_old_password'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'mysql_native_password'
2018-11-08 06:41:37 31122 [Note] Shutting down plugin 'binlog'
2018-11-08 06:41:37 31122 [Note] bin/mysqld: Shutdown complete

2018-11-08 06:41:41 31173 [Note] Plugin 'FEDERATED' is disabled.
2018-11-08 06:41:41 31173 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-11-08 06:41:41 31173 [Note] InnoDB: The InnoDB memory heap is disabled
2018-11-08 06:41:41 31173 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-08 06:41:41 31173 [Note] InnoDB: Memory barrier is not used
2018-11-08 06:41:41 31173 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-08 06:41:41 31173 [Note] InnoDB: Using Linux native AIO
2018-11-08 06:41:41 31173 [Note] InnoDB: Using CPU crc32 instructions
2018-11-08 06:41:41 31173 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-11-08 06:41:41 31173 [Note] InnoDB: Completed initialization of buffer pool
2018-11-08 06:41:41 31173 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-08 06:41:41 31173 [Note] InnoDB: 128 rollback segment(s) are active.
2018-11-08 06:41:41 31173 [Note] InnoDB: Waiting for purge to start
2018-11-08 06:41:41 31173 [Note] InnoDB: 5.6.42 started; log sequence number 1629972
2018-11-08 06:41:41 31173 [Note] RSA private key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101//private_key.pem. Some authentication plugins will not work.
2018-11-08 06:41:41 31173 [Note] RSA public key file not found: /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101//public_key.pem. Some authentication plugins will not work.
2018-11-08 06:41:41 31173 [Note] Server hostname (bind-address): '*'; port: 9999
2018-11-08 06:41:41 31173 [Note] IPv6 is available.
2018-11-08 06:41:41 31173 [Note]   - '::' resolves to '::';
2018-11-08 06:41:41 31173 [Note] Server socket created on IP: '::'.
2018-11-08 06:41:41 31173 [Note] Event Scheduler: Loaded 0 events
2018-11-08 06:41:41 31173 [Note] bin/mysqld: ready for connections.
Version: '5.6.42-enterprise-commercial-advanced'  socket: '/tmp/mysql_ushastry.sock'  port: 9999  MySQL Enterprise Server - Advanced Edition (Commercial)
2018-11-08 06:50:22 31173 [Note] bin/mysqld: Normal shutdown

2018-11-08 06:50:22 31173 [Note] Giving 0 client threads a chance to die gracefully
2018-11-08 06:50:22 31173 [Note] Event Scheduler: Purging the queue. 0 events
2018-11-08 06:50:22 31173 [Note] Shutting down slave threads
2018-11-08 06:50:22 31173 [Note] Forcefully disconnecting 0 remaining clients
2018-11-08 06:50:22 31173 [Note] Binlog end
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'partition'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_METRICS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_CMP'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'INNODB_TRX'
2018-11-08 06:50:22 31173 [Note] Shutting down plugin 'InnoDB'
2018-11-08 06:50:22 31173 [Note] InnoDB: FTS optimize thread exiting.
2018-11-08 06:50:22 31173 [Note] InnoDB: Starting shutdown...
2018-11-08 06:50:24 31173 [Note] InnoDB: Shutdown completed; log sequence number 1629982
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'BLACKHOLE'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'ARCHIVE'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'MEMORY'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'MRG_MYISAM'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'MyISAM'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'CSV'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'sha256_password'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'mysql_old_password'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'mysql_native_password'
2018-11-08 06:50:24 31173 [Note] Shutting down plugin 'binlog'
2018-11-08 06:50:24 31173 [Note] bin/mysqld: Shutdown complete

2018-11-08T05:51:18.481686Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-08T05:51:18.481855Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-11-08T05:51:18.481893Z 0 [Note] bin/mysqld (mysqld 5.7.24) starting as process 31899 ...
2018-11-08T05:51:18.488004Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-11-08T05:51:18.488037Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-08T05:51:18.488045Z 0 [Note] InnoDB: Uses event mutexes
2018-11-08T05:51:18.488050Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-11-08T05:51:18.488054Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-08T05:51:18.488058Z 0 [Note] InnoDB: Using Linux native AIO
2018-11-08T05:51:18.488364Z 0 [Note] InnoDB: Number of pools: 1
2018-11-08T05:51:18.488486Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-11-08T05:51:18.490310Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-08T05:51:18.499874Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-08T05:51:18.502481Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-08T05:51:18.514707Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-08T05:51:18.526312Z 0 [Warning] InnoDB: Upgrading redo log: 2*3072 pages, LSN=1629982
2018-11-08T05:51:18.626812Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2018-11-08T05:51:18.645960Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2018-11-08T05:51:18.704337Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2018-11-08T05:51:18.903199Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2018-11-08T05:51:18.903307Z 0 [Warning] InnoDB: New log files created, LSN=1629982
2018-11-08T05:51:18.903719Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-11-08T05:51:18.903808Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-11-08T05:51:18.918473Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-11-08T05:51:18.919558Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-11-08T05:51:18.919572Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-11-08T05:51:18.919767Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2018-11-08T05:51:18.920503Z 0 [Note] InnoDB: sys_virtual table created
2018-11-08T05:51:18.920755Z 0 [Note] InnoDB: Waiting for purge to start
2018-11-08T05:51:18.970828Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 0
2018-11-08T05:51:18.971038Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/ib_buffer_pool
2018-11-08T05:51:18.971079Z 0 [ERROR] InnoDB: Cannot open '/export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/ib_buffer_pool' for reading: No such file or directory
2018-11-08T05:51:18.971208Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-11-08T05:51:18.976520Z 0 [Warning] System table 'plugin' is expected to be transactional.
2018-11-08T05:51:18.977164Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-11-08T05:51:18.977261Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-11-08T05:51:18.977273Z 0 [Note] Server hostname (bind-address): '*'; port: 9999
2018-11-08T05:51:18.977312Z 0 [Note] IPv6 is available.
2018-11-08T05:51:18.977331Z 0 [Note]   - '::' resolves to '::';
2018-11-08T05:51:18.977345Z 0 [Note] Server socket created on IP: '::'.
2018-11-08T05:51:18.977916Z 0 [Warning] Failed to open optimizer cost constant tables

2018-11-08T05:51:18.979007Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2018-11-08T05:51:18.979027Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2018-11-08T05:51:18.979031Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2018-11-08T05:51:18.979033Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2018-11-08T05:51:18.979035Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2018-11-08T05:51:18.979544Z 0 [Warning] System table 'servers' is expected to be transactional.
2018-11-08T05:51:18.979937Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_current: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2018-11-08T05:51:18.980009Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2018-11-08T05:51:18.980073Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_history_long: expected column 'NESTING_EVENT_TYPE' at position 15 to have type enum('TRANSACTION','STATEMENT','STAGE','WAIT', found type enum('STATEMENT','STAGE','WAIT').
2018-11-08T05:51:18.980313Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.980373Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.980898Z 0 [ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.981062Z 0 [ERROR] Incorrect definition of table performance_schema.setup_objects: expected column 'OBJECT_TYPE' at position 0 to have type enum('EVENT','FUNCTION','PROCEDURE','TABLE','TRIGGER', found type enum('TABLE').
2018-11-08T05:51:18.981396Z 0 [ERROR] Column count of performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68, found 73. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.981458Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.981514Z 0 [ERROR] Column count of performance_schema.events_stages_current is wrong. Expected 12, found 10. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.981576Z 0 [ERROR] Column count of performance_schema.events_stages_history is wrong. Expected 12, found 10. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.981645Z 0 [ERROR] Column count of performance_schema.events_stages_history_long is wrong. Expected 12, found 10. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.981777Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.981852Z 0 [ERROR] Incorrect definition of table performance_schema.events_stages_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.982062Z 0 [ERROR] Column count of performance_schema.events_statements_current is wrong. Expected 41, found 40. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.982154Z 0 [ERROR] Column count of performance_schema.events_statements_history is wrong. Expected 41, found 40. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.982250Z 0 [ERROR] Column count of performance_schema.events_statements_history_long is wrong. Expected 41, found 40. Created with MySQL 50642, now running 50724. Please use mysql_upgrade to fix this error.
2018-11-08T05:51:18.982403Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_account_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.982480Z 0 [ERROR] Incorrect definition of table performance_schema.events_statements_summary_by_user_by_event_name: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.982767Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
2018-11-08T05:51:18.982806Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
2018-11-08T05:51:18.982835Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
2018-11-08T05:51:18.982866Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
2018-11-08T05:51:18.982902Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
2018-11-08T05:51:18.982936Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
2018-11-08T05:51:18.982968Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
2018-11-08T05:51:18.982997Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
2018-11-08T05:51:18.983028Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
2018-11-08T05:51:18.983087Z 0 [ERROR] Incorrect definition of table performance_schema.users: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.983146Z 0 [ERROR] Incorrect definition of table performance_schema.accounts: expected column 'USER' at position 0 to have type char(32), found type char(16).
2018-11-08T05:51:18.983538Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
2018-11-08T05:51:18.983572Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
2018-11-08T05:51:18.983604Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
2018-11-08T05:51:18.983636Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
2018-11-08T05:51:18.983666Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
2018-11-08T05:51:18.983706Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
2018-11-08T05:51:18.983740Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
2018-11-08T05:51:18.983778Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
2018-11-08T05:51:18.983811Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
2018-11-08T05:51:18.983846Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
2018-11-08T05:51:18.983874Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
2018-11-08T05:51:18.983903Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
2018-11-08T05:51:18.983932Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
2018-11-08T05:51:18.983976Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
2018-11-08T05:51:18.984007Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
2018-11-08T05:51:18.984035Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
2018-11-08T05:51:18.984066Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
2018-11-08T05:51:18.984095Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
2018-11-08T05:51:18.984123Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
2018-11-08T05:51:18.984154Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2018-11-08T05:51:18.984182Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2018-11-08T05:51:18.984210Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2018-11-08T05:51:18.984237Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2018-11-08T05:51:18.984267Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2018-11-08T05:51:18.984298Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2018-11-08T05:51:18.984326Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2018-11-08T05:51:18.984419Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16).
2018-11-08T05:51:18.984435Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
2018-11-08T05:51:18.984588Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2018-11-08T05:51:18.984800Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.24'  socket: '/tmp/mysql_ushastry.sock'  port: 9999  MySQL Community Server (GPL)
2018-11-08T05:51:54.852185Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852234Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852252Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852259Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852503Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852512Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852621Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852630Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852673Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852681Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852719Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:54.852727Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:55.864309Z 2 [Warning] System table 'servers' is expected to be transactional.
2018-11-08T05:51:55.871983Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:55.872011Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.022192Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.022230Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.022282Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.022291Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.028443Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.028463Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.028507Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.028516Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.040453Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.040474Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.040518Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.040527Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.053577Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.053600Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.053643Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.053653Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.057414Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.057433Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.057477Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.057489Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.061399Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.061420Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.061466Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.061475Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.065438Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.065469Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.065512Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.065521Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.068992Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.069013Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.069056Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.069065Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.072297Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.072324Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.072371Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.072379Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.075684Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.075708Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.075759Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.075773Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.079281Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.079301Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.079345Z 2 [Warning] InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:51:56.079353Z 2 [Warning] InnoDB: Table mysql/innodb_index_stats has length mismatch in the column name table_name.  Please run mysql_upgrade
2018-11-08T05:52:01.620202Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-11-08T05:52:01.620231Z 0 [Note] Shutting down slave threads
2018-11-08T05:52:01.620238Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-11-08T05:52:01.620294Z 0 [Note] Binlog end
2018-11-08T05:52:01.621439Z 0 [Note] Shutting down plugin 'ngram'
2018-11-08T05:52:01.621454Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-11-08T05:52:01.621459Z 0 [Note] Shutting down plugin 'partition'
2018-11-08T05:52:01.621461Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-11-08T05:52:01.621465Z 0 [Note] Shutting down plugin 'MyISAM'
2018-11-08T05:52:01.621473Z 0 [Note] Shutting down plugin 'CSV'
2018-11-08T05:52:01.621477Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-11-08T05:52:01.621480Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-11-08T05:52:01.621482Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-11-08T05:52:01.621485Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-11-08T05:52:01.621487Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-11-08T05:52:01.621496Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-11-08T05:52:01.621498Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-11-08T05:52:01.621500Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-11-08T05:52:01.621503Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-11-08T05:52:01.621505Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-11-08T05:52:01.621507Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-11-08T05:52:01.621510Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-11-08T05:52:01.621512Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-11-08T05:52:01.621514Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-11-08T05:52:01.621516Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-11-08T05:52:01.621519Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-11-08T05:52:01.621521Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-11-08T05:52:01.621523Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-11-08T05:52:01.621525Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-11-08T05:52:01.621528Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-11-08T05:52:01.621530Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-11-08T05:52:01.621532Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-11-08T05:52:01.621534Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-11-08T05:52:01.621536Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-11-08T05:52:01.621538Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-11-08T05:52:01.621541Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-11-08T05:52:01.621543Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-11-08T05:52:01.621545Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-11-08T05:52:01.621547Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-11-08T05:52:01.621549Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-11-08T05:52:01.621551Z 0 [Note] Shutting down plugin 'InnoDB'
2018-11-08T05:52:01.621652Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-11-08T05:52:01.621750Z 0 [Note] InnoDB: Starting shutdown...
2018-11-08T05:52:01.721942Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/ib_buffer_pool
2018-11-08T05:52:01.722175Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181108  6:52:01
2018-11-08T05:52:03.129312Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2779721
2018-11-08T05:52:03.131948Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-11-08T05:52:03.131965Z 0 [Note] Shutting down plugin 'MEMORY'
2018-11-08T05:52:03.131971Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-11-08T05:52:03.131975Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-11-08T05:52:03.132003Z 0 [Note] Shutting down plugin 'sha256_password'
2018-11-08T05:52:03.132006Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-11-08T05:52:03.132170Z 0 [Note] Shutting down plugin 'binlog'
2018-11-08T05:52:03.132717Z 0 [Note] bin/mysqld: Shutdown complete

2018-11-08T05:52:11.865943Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-11-08T05:52:11.866114Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2018-11-08T05:52:11.866149Z 0 [Note] bin/mysqld (mysqld 5.7.24) starting as process 31936 ...
2018-11-08T05:52:11.872399Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-11-08T05:52:11.872430Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-08T05:52:11.872437Z 0 [Note] InnoDB: Uses event mutexes
2018-11-08T05:52:11.872442Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier
2018-11-08T05:52:11.872447Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-08T05:52:11.872451Z 0 [Note] InnoDB: Using Linux native AIO
2018-11-08T05:52:11.872787Z 0 [Note] InnoDB: Number of pools: 1
2018-11-08T05:52:11.872927Z 0 [Note] InnoDB: Using CPU crc32 instructions
2018-11-08T05:52:11.874676Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-11-08T05:52:11.884294Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-11-08T05:52:11.886888Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-11-08T05:52:11.899094Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-08T05:52:11.912337Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-11-08T05:52:11.912416Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-11-08T05:52:11.927622Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-11-08T05:52:11.928639Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-11-08T05:52:11.928652Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-11-08T05:52:11.929004Z 0 [Note] InnoDB: Waiting for purge to start
2018-11-08T05:52:11.979175Z 0 [Note] InnoDB: 5.7.24 started; log sequence number 2779721
2018-11-08T05:52:11.979392Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/ib_buffer_pool
2018-11-08T05:52:11.979608Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-11-08T05:52:11.981196Z 0 [Note] InnoDB: Buffer pool(s) load completed at 181108  6:52:11
2018-11-08T05:52:11.985799Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-11-08T05:52:11.985822Z 0 [Note] Server hostname (bind-address): '*'; port: 9999
2018-11-08T05:52:11.985869Z 0 [Note] IPv6 is available.
2018-11-08T05:52:11.985884Z 0 [Note]   - '::' resolves to '::';
2018-11-08T05:52:11.985896Z 0 [Note] Server socket created on IP: '::'.
2018-11-08T05:52:11.995397Z 0 [Note] Event Scheduler: Loaded 0 events
2018-11-08T05:52:11.995610Z 0 [Note] bin/mysqld: ready for connections.
Version: '5.7.24'  socket: '/tmp/mysql_ushastry.sock'  port: 9999  MySQL Community Server (GPL)
2018-11-08T06:00:37.247486Z 3 [Note] Plugin mysqlx reported: 'Scheduler "work" started.'
2018-11-08T06:00:37.247556Z 3 [Note] Plugin mysqlx reported: 'Scheduler "network" started.'
2018-11-08T06:00:37.248177Z 0 [Note] Plugin mysqlx reported: 'Neither MySQL Server nor Mysqlx Plugin has valid SSL configuration'
2018-11-08T06:00:37.248239Z 0 [Warning] Plugin mysqlx reported: 'Failed at SSL configuration: "SSL context is not usable without certificate and private key"'
2018-11-08T06:00:37.248245Z 0 [Note] Plugin mysqlx reported: 'For more information, please see the Using Secure Connections with X Plugin section in the MySQL documentation.'
2018-11-08T06:00:37.248295Z 0 [Note] Plugin mysqlx reported: 'IPv6 is available'
2018-11-08T06:00:37.248348Z 0 [Note] Plugin mysqlx reported: 'Retrying `bind()` on TCP/IP port 33060'
2018-11-08T06:00:38.248453Z 0 [ERROR] Plugin mysqlx reported: 'Preparation of I/O interfaces failed, X Protocol won't be accessible'
2018-11-08T06:00:38.248484Z 0 [ERROR] Plugin mysqlx reported: 'Setup of TCP (bind-address:'*', port:33060) failed, `bind()` failed with error: Address already in use (98). Do you already have another mysqld server running with Mysqlx ?'
2018-11-08T06:00:38.248496Z 0 [Note] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_port','mysqlx_bind_address' system variables to fix the error'
2018-11-08T06:00:38.248501Z 0 [ERROR] Plugin mysqlx reported: 'Setup of UNIX socket (/tmp/mysqlx.sock) failed, can't open lock file /tmp/mysqlx.sock.lock'
2018-11-08T06:00:38.248506Z 0 [Note] Plugin mysqlx reported: 'Please see the MySQL documentation for 'mysqlx_socket' system variables to fix the error'
2018-11-08T06:01:12.943547Z 5 [Note] Got packets out of order
2018-11-08T06:01:38.290148Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-11-08T06:01:38.290183Z 0 [Note] Shutting down slave threads
2018-11-08T06:01:38.290208Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-11-08T06:01:38.290216Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-11-08T06:01:38.290306Z 0 [Note] Binlog end
2018-11-08T06:01:38.290986Z 0 [Note] Shutting down plugin 'mysqlx'
2018-11-08T06:01:38.291031Z 0 [Note] Plugin mysqlx reported: 'Exiting'
2018-11-08T06:01:38.291102Z 0 [Note] Plugin mysqlx reported: 'Scheduler "work" stopped.'
2018-11-08T06:01:38.291137Z 0 [Note] Plugin mysqlx reported: 'Scheduler "network" stopped.'
2018-11-08T06:01:38.291204Z 0 [Note] Plugin mysqlx reported: 'Exit done'
2018-11-08T06:01:38.291209Z 0 [Note] Shutting down plugin 'ngram'
2018-11-08T06:01:38.291212Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-11-08T06:01:38.291217Z 0 [Note] Shutting down plugin 'partition'
2018-11-08T06:01:38.291219Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-11-08T06:01:38.291222Z 0 [Note] Shutting down plugin 'MyISAM'
2018-11-08T06:01:38.291232Z 0 [Note] Shutting down plugin 'CSV'
2018-11-08T06:01:38.291237Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-11-08T06:01:38.291240Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-11-08T06:01:38.291243Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-11-08T06:01:38.291245Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-11-08T06:01:38.291248Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-11-08T06:01:38.291251Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-11-08T06:01:38.291254Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-11-08T06:01:38.291256Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-11-08T06:01:38.291258Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-11-08T06:01:38.291261Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-11-08T06:01:38.291263Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-11-08T06:01:38.291265Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-11-08T06:01:38.291267Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-11-08T06:01:38.291269Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-11-08T06:01:38.291272Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-11-08T06:01:38.291274Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-11-08T06:01:38.291276Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-11-08T06:01:38.291279Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-11-08T06:01:38.291281Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-11-08T06:01:38.291284Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-11-08T06:01:38.291286Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-11-08T06:01:38.291289Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-11-08T06:01:38.291293Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-11-08T06:01:38.291295Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-11-08T06:01:38.291298Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-11-08T06:01:38.291301Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-11-08T06:01:38.291303Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-11-08T06:01:38.291305Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-11-08T06:01:38.291308Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-11-08T06:01:38.291310Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-11-08T06:01:38.291312Z 0 [Note] Shutting down plugin 'InnoDB'
2018-11-08T06:01:38.291409Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-11-08T06:01:38.291485Z 0 [Note] InnoDB: Starting shutdown...
2018-11-08T06:01:38.391636Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-5.5.61/93101/ib_buffer_pool
2018-11-08T06:01:38.391983Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 181108  7:01:38
2018-11-08T06:01:39.798991Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2779929
2018-11-08T06:01:39.801646Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-11-08T06:01:39.801664Z 0 [Note] Shutting down plugin 'MEMORY'
2018-11-08T06:01:39.801692Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-11-08T06:01:39.801696Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-11-08T06:01:39.801724Z 0 [Note] Shutting down plugin 'sha256_password'
2018-11-08T06:01:39.801727Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-11-08T06:01:39.801925Z 0 [Note] Shutting down plugin 'binlog'
2018-11-08T06:01:39.802447Z 0 [Note] bin/mysqld: Shutdown complete

2018-11-08T06:02:59.873216Z 0 [System] [MY-010116] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.13/bin/mysqld (mysqld 8.0.13) starting as process 690
2018-11-08T06:03:01.113929Z 0 [ERROR] [MY-013180] [Server] Function 'mysqlx' already exists.
2018-11-08T06:03:01.113963Z 0 [Warning] [MY-010736] [Server] Couldn't load plugin named 'mysqlx' with soname 'mysqlx.so'.
2018-11-08T06:03:01.115678Z 2 [ERROR] [MY-010923] [Server] Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it!
2018-11-08T06:03:01.281781Z 2 [Warning] [MY-010772] [Server] db.opt file not found for test database. Using default Character set.
2018-11-08T06:03:01.427849Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables.
2018-11-08T06:03:01.427881Z 0 [ERROR] [MY-010119] [Server] Aborting
2018-11-08T06:03:03.055430Z 0 [System] [MY-010910] [Server] /export/umesh/server/binaries/GABuilds/mysql-8.0.13/bin/mysqld: Shutdown complete (mysqld 8.0.13)  MySQL Community Server - GPL.

## Before upgrading to 8.0.13, checked with upgrade checker utility and it pointed the issue though

[umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-shell-8.0.13: bin/mysqlsh root:@localhost:9999 -e "util.checkForServerUpgrade();"
mysqlsh: [Warning] Using a password on the command line interface can be insecure.
The MySQL server at localhost:9999 will now be checked for compatibility issues for upgrade to MySQL 8.0.13...
MySQL version: 5.7.24 - MySQL Community Server (GPL)

1) Usage of old temporal type
  No issues found

2) Usage of db objects with names conflicting with reserved keywords in 8.0
  No issues found

3) Usage of utf8mb3 charset
  No issues found

4) Table names in the mysql schema conflicting with new tables in 8.0
  No issues found

5) Foreign key constraint names longer than 64 characters
  No issues found

6) Usage of obsolete MAXDB sql_mode flag
  No issues found

7) Usage of obsolete sql_mode flags
  No issues found

8) ENUM/SET column definitions containing elements longer than 255 characters
  No issues found

9) Usage of partitioned tables in shared tablespaces
  No issues found

10) Usage of removed functions
  No issues found

11) Usage of removed GROUP BY ASC/DESC syntax
  No issues found

12) Issues reported by 'check table x for upgrade' command
  Error   : Table (d1.t1) - Table rebuild required. Please do "ALTER TABLE `t1` FORCE" or dump/reload to fix it!

Errors:   1
Warnings: 0
Notices:  0

1 errors were found. Please correct these issues before upgrading to avoid compatibility issues.