######## Conf files used [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: cat my.cnf ../mysql-advanced-5.7.13/my.cnf ../mysql-advanced-5.6.21/my.cnf [client] port = 3306 socket = /tmp/mysql_ushastry.sock [mysqld] port = 3306 socket = /tmp/mysql_ushastry.sock pid-file = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/system/s2mysqld.pid basedir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14 datadir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ tmpdir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/temp log-error = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/data/log.err skip-external-locking key_buffer_size = 16M max_allowed_packet = 20M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M max_connections = 200 explicit_defaults_for_timestamp = true character-sets-dir=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/share/charsets max_binlog_size = 134217728 binlog_format = MIXED plugin-load = authentication_pam.so;audit_log.so audit-log = on audit_log_file = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14/audit/s2mysqllog.aud audit_log_policy = logins secure_file_priv = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14 ft_min_word_len = 3 log-bin=mysql-bin server-id = 300 innodb_data_home_dir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ innodb_file_per_table = 1 innodb_log_group_home_dir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ innodb_log_file_size = 256M innodb_log_files_in_group = 4 innodb_log_buffer_size = 128M [client] port = 3306 socket = /tmp/mysql_ushastry.sock [mysqld] port = 3306 socket = /tmp/mysql_ushastry.sock pid-file = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13/system/s2mysqld.pid basedir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13 datadir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ tmpdir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13/temp log-error = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13/data/log.err skip-external-locking key_buffer_size = 16M max_allowed_packet = 20M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M max_connections = 200 explicit_defaults_for_timestamp = true character-sets-dir=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13/share/charsets max_binlog_size = 134217728 binlog_format = MIXED plugin-load = authentication_pam.so;audit_log.so audit-log = on audit_log_file = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13/audit/s2mysqllog.aud audit_log_policy = logins secure_file_priv = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13 ft_min_word_len = 3 log-bin=mysql-bin server-id = 300 innodb_data_home_dir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ innodb_file_per_table = 1 innodb_log_group_home_dir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ innodb_log_file_size = 256M innodb_log_files_in_group = 4 innodb_log_buffer_size = 128M [client] port = 3306 socket = /tmp/mysql_ushastry.sock [mysqld] port = 3306 socket = /tmp/mysql_ushastry.sock pid-file = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/system/s2mysqld.pid basedir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21 datadir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ tmpdir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/temp log-error = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/log.err skip-external-locking key_buffer_size = 16M max_allowed_packet = 20M table_open_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M max_connections = 200 explicit_defaults_for_timestamp = true character-sets-dir=/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/share/charsets max_binlog_size = 134217728 binlog_format = MIXED plugin-load = authentication_pam.so;audit_log.so audit-log = on audit_log_file = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/audit/s2mysqllog.aud audit_log_policy = logins secure_file_priv = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21 ft_min_word_len = 3 log-bin=mysql-bin server-id = 300 innodb_data_home_dir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ innodb_file_per_table = 1 innodb_log_group_home_dir = /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ innodb_log_file_size = 256M innodb_log_files_in_group = 4 innodb_log_buffer_size = 128M 5.6.21 - set up 5.6.21 instance ====== scripts/mysql_install_db --defaults-file=./my.cnf [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21: bin/mysqld --defaults-file=./my.cnf & [2] 3403 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21: 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.6.21-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2014, 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-advanced-5.6.21: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [2]- Done bin/mysqld --defaults-file=./my.cnf [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21: cd ../mysql-advanced-5.7.13 5.7.13 - perform in place upgrade from 5.6.21 to 5.7.13 ====== bin/mysqld --defaults-file=./my.cnf & [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: 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.13-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2016, 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-advanced-5.7.13: bin/mysql_upgrade -uroot -S /tmp/mysql_ushastry.sock --force Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info 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 Upgrading the sys schema. Checking databases. sys.sys_config OK Upgrade process completed successfully. Checking if update is needed. [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: [2]- Done bin/mysqld --defaults-file=./my.cnf [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: cat data/log.err 2016-08-01T12:39:51.342445Z 0 [Warning] Insecure configuration for --secure-file-priv: Plugin directory is accessible through --secure-file-priv. Consider choosing a different directory. 2016-08-01T12:39:51.342541Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2016-08-01T12:39:51.342581Z 0 [Note] bin/mysqld (mysqld 5.7.13-enterprise-commercial-advanced-log) starting as process 3767 ... 2016-08-01T12:39:51.347702Z 0 [Note] InnoDB: PUNCH HOLE support not available 2016-08-01T12:39:51.347737Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-08-01T12:39:51.347743Z 0 [Note] InnoDB: Uses event mutexes 2016-08-01T12:39:51.347748Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2016-08-01T12:39:51.347752Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-01T12:39:51.347758Z 0 [Note] InnoDB: Using Linux native AIO 2016-08-01T12:39:51.348057Z 0 [Note] InnoDB: Number of pools: 1 2016-08-01T12:39:51.348179Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-08-01T12:39:51.349843Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-01T12:39:51.360055Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-01T12:39:51.362540Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-08-01T12:39:51.374830Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-01T12:39:51.386213Z 0 [Warning] InnoDB: Upgrading redo log: 4*16384 pages, LSN=1625997 2016-08-01T12:39:51.486749Z 0 [Warning] InnoDB: Starting to delete and rewrite log files. 2016-08-01T12:39:51.680846Z 0 [Note] InnoDB: Setting log file /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_logfile101 size to 256 MB 2016-08-01T12:39:51.681043Z 0 [Note] InnoDB: Progress in MB: 100 200 2016-08-01T12:39:52.164733Z 0 [Note] InnoDB: Setting log file /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_logfile1 size to 256 MB 2016-08-01T12:39:52.164968Z 0 [Note] InnoDB: Progress in MB: 100 200 2016-08-01T12:39:52.846420Z 0 [Note] InnoDB: Setting log file /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_logfile2 size to 256 MB 2016-08-01T12:39:52.846657Z 0 [Note] InnoDB: Progress in MB: 100 200 2016-08-01T12:39:53.517007Z 0 [Note] InnoDB: Setting log file /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_logfile3 size to 256 MB 2016-08-01T12:39:53.517246Z 0 [Note] InnoDB: Progress in MB: 100 200 2016-08-01T12:39:54.225433Z 0 [Note] InnoDB: Renaming log file /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_logfile101 to /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_logfile0 2016-08-01T12:39:54.225555Z 0 [Warning] InnoDB: New log files created, LSN=1625997 2016-08-01T12:39:54.225988Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-01T12:39:54.226079Z 0 [Note] InnoDB: Setting file '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-01T12:39:54.241084Z 0 [Note] InnoDB: File '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size is now 12 MB. 2016-08-01T12:39:54.242240Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-01T12:39:54.242257Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-01T12:39:54.242464Z 0 [Note] InnoDB: Creating sys_virtual system tables. 2016-08-01T12:39:54.243249Z 0 [Note] InnoDB: sys_virtual table created 2016-08-01T12:39:54.243440Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-01T12:39:54.293568Z 0 [Note] InnoDB: 5.7.13 started; log sequence number 0 2016-08-01T12:39:54.293773Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:39:54.293821Z 0 [ERROR] InnoDB: Cannot open '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool' for reading: No such file or directory 2016-08-01T12:39:54.294006Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-01T12:39:54.295464Z 0 [Warning] System table 'plugin' is expected to be transactional. 2016-08-01T12:39:54.295899Z 0 [Warning] Plugin audit_log reported: 'Audit Log plugin supports a filtering, which has not been installed yet. Audit Log plugin will run in the legacy mode, which will be disabled in the next release.' 2016-08-01T12:39:54.297696Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2016-08-01T12:39:55.943247Z 0 [Note] Auto generated SSL certificates are placed in data directory. 2016-08-01T12:39:55.943757Z 0 [Warning] CA certificate ca.pem is self signed. 2016-08-01T12:39:56.156018Z 0 [Note] Auto generated RSA key files are placed in data directory. 2016-08-01T12:39:56.156136Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-01T12:39:56.156177Z 0 [Note] IPv6 is available. 2016-08-01T12:39:56.156188Z 0 [Note] - '::' resolves to '::'; 2016-08-01T12:39:56.156209Z 0 [Note] Server socket created on IP: '::'. 2016-08-01T12:39:56.156711Z 0 [Warning] Failed to open optimizer cost constant tables 2016-08-01T12:39:56.157831Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional. 2016-08-01T12:39:56.157844Z 0 [Warning] System table 'time_zone_name' is expected to be transactional. 2016-08-01T12:39:56.157848Z 0 [Warning] System table 'time_zone' is expected to be transactional. 2016-08-01T12:39:56.157850Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional. 2016-08-01T12:39:56.157852Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional. 2016-08-01T12:39:56.158353Z 0 [Warning] System table 'servers' is expected to be transactional. 2016-08-01T12:39:56.159514Z 0 [Warning] Info table is not ready to be used. Table 'mysql.slave_master_info' cannot be opened. 2016-08-01T12:39:56.159966Z 0 [Warning] Info table is not ready to be used. Table 'mysql.slave_relay_log_info' cannot be opened. 2016-08-01T12:39:56.160185Z 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'). 2016-08-01T12:39:56.160257Z 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'). 2016-08-01T12:39:56.160328Z 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'). 2016-08-01T12:39:56.160566Z 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). 2016-08-01T12:39:56.160638Z 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). 2016-08-01T12:39:56.161207Z 0 [ERROR] Column count of performance_schema.setup_actors is wrong. Expected 5, found 3. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.161383Z 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'). 2016-08-01T12:39:56.161779Z 0 [ERROR] Column count of performance_schema.table_lock_waits_summary_by_table is wrong. Expected 68, found 73. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.161855Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 14. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.161920Z 0 [ERROR] Column count of performance_schema.events_stages_current is wrong. Expected 12, found 10. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.161975Z 0 [ERROR] Column count of performance_schema.events_stages_history is wrong. Expected 12, found 10. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.162039Z 0 [ERROR] Column count of performance_schema.events_stages_history_long is wrong. Expected 12, found 10. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.162153Z 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). 2016-08-01T12:39:56.162215Z 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). 2016-08-01T12:39:56.162431Z 0 [ERROR] Column count of performance_schema.events_statements_current is wrong. Expected 41, found 40. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.162535Z 0 [ERROR] Column count of performance_schema.events_statements_history is wrong. Expected 41, found 40. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.162634Z 0 [ERROR] Column count of performance_schema.events_statements_history_long is wrong. Expected 41, found 40. Created with MySQL 50621, now running 50713. Please use mysql_upgrade to fix this error. 2016-08-01T12:39:56.162799Z 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). 2016-08-01T12:39:56.162875Z 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). 2016-08-01T12:39:56.163129Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure 2016-08-01T12:39:56.163161Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure 2016-08-01T12:39:56.163191Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure 2016-08-01T12:39:56.163219Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure 2016-08-01T12:39:56.163253Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure 2016-08-01T12:39:56.163281Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure 2016-08-01T12:39:56.163312Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure 2016-08-01T12:39:56.163345Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure 2016-08-01T12:39:56.163387Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure 2016-08-01T12:39:56.163453Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure 2016-08-01T12:39:56.163517Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure 2016-08-01T12:39:56.163571Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure 2016-08-01T12:39:56.163631Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure 2016-08-01T12:39:56.163694Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure 2016-08-01T12:39:56.163782Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure 2016-08-01T12:39:56.163847Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure 2016-08-01T12:39:56.163913Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure 2016-08-01T12:39:56.163952Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure 2016-08-01T12:39:56.163981Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure 2016-08-01T12:39:56.164010Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure 2016-08-01T12:39:56.164039Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure 2016-08-01T12:39:56.164070Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure 2016-08-01T12:39:56.164100Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure 2016-08-01T12:39:56.164130Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure 2016-08-01T12:39:56.164160Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure 2016-08-01T12:39:56.164193Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure 2016-08-01T12:39:56.164221Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure 2016-08-01T12:39:56.164254Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure 2016-08-01T12:39:56.164282Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure 2016-08-01T12:39:56.164315Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure 2016-08-01T12:39:56.164344Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure 2016-08-01T12:39:56.164385Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure 2016-08-01T12:39:56.164419Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure 2016-08-01T12:39:56.164453Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure 2016-08-01T12:39:56.164481Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure 2016-08-01T12:39:56.164512Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure 2016-08-01T12:39:56.164542Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure 2016-08-01T12:39:56.164571Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure 2016-08-01T12:39:56.164600Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure 2016-08-01T12:39:56.164627Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure 2016-08-01T12:39:56.164656Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure 2016-08-01T12:39:56.164690Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure 2016-08-01T12:39:56.164734Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure 2016-08-01T12:39:56.164883Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16). 2016-08-01T12:39:56.164959Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28 2016-08-01T12:39:56.165132Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 2016-08-01T12:39:56.165292Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.13-enterprise-commercial-advanced-log' socket: '/tmp/mysql_ushastry.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) 2016-08-01T12:40:18.165881Z 3 [Warning] System table 'servers' is expected to be transactional. 2016-08-01T12:40:27.211280Z 0 [Note] Giving 0 client threads a chance to die gracefully 2016-08-01T12:40:27.211302Z 0 [Note] Shutting down slave threads 2016-08-01T12:40:27.211307Z 0 [Note] Forcefully disconnecting 0 remaining clients 2016-08-01T12:40:27.211453Z 0 [Note] Binlog end 2016-08-01T12:40:27.212320Z 0 [Note] Shutting down plugin 'audit_log' 2016-08-01T12:40:27.212460Z 0 [Note] Shutting down plugin 'authentication_pam' 2016-08-01T12:40:27.212471Z 0 [Note] Shutting down plugin 'ngram' 2016-08-01T12:40:27.212474Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-08-01T12:40:27.212477Z 0 [Note] Shutting down plugin 'partition' 2016-08-01T12:40:27.212481Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-08-01T12:40:27.212485Z 0 [Note] Shutting down plugin 'CSV' 2016-08-01T12:40:27.212490Z 0 [Note] Shutting down plugin 'MEMORY' 2016-08-01T12:40:27.212494Z 0 [Note] Shutting down plugin 'MyISAM' 2016-08-01T12:40:27.212504Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-08-01T12:40:27.212508Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-08-01T12:40:27.212547Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-08-01T12:40:27.212551Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-08-01T12:40:27.212553Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-08-01T12:40:27.212556Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-08-01T12:40:27.212559Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-08-01T12:40:27.212561Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-08-01T12:40:27.212564Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-08-01T12:40:27.212566Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-08-01T12:40:27.212569Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-08-01T12:40:27.212571Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-08-01T12:40:27.212574Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-08-01T12:40:27.212576Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-08-01T12:40:27.212578Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-08-01T12:40:27.212580Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-08-01T12:40:27.212582Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-08-01T12:40:27.212584Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-08-01T12:40:27.212587Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-08-01T12:40:27.212589Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-08-01T12:40:27.212591Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-08-01T12:40:27.212594Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-08-01T12:40:27.212596Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-08-01T12:40:27.212598Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-08-01T12:40:27.212600Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-08-01T12:40:27.212603Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-08-01T12:40:27.212605Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-08-01T12:40:27.212607Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-08-01T12:40:27.212609Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-08-01T12:40:27.212612Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-08-01T12:40:27.212614Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-08-01T12:40:27.212616Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-08-01T12:40:27.212619Z 0 [Note] Shutting down plugin 'InnoDB' 2016-08-01T12:40:27.212729Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-08-01T12:40:27.212815Z 0 [Note] InnoDB: Starting shutdown... 2016-08-01T12:40:27.313055Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:40:27.313248Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160801 14:40:27 2016-08-01T12:40:28.220756Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2764595 2016-08-01T12:40:28.223143Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-08-01T12:40:28.223158Z 0 [Note] Shutting down plugin 'sha256_password' 2016-08-01T12:40:28.223162Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-08-01T12:40:28.223447Z 0 [Note] Shutting down plugin 'binlog' 2016-08-01T12:40:28.224491Z 0 [Note] bin/mysqld: Shutdown complete [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: rm -rf data/log.err [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.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-advanced-5.7.13: bin/mysqld --defaults-file=./my.cnf & [2] 3816 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: 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.13-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2016, 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-advanced-5.7.13: cat data/log.err 2016-08-01T12:41:16.912842Z 0 [Warning] Insecure configuration for --secure-file-priv: Plugin directory is accessible through --secure-file-priv. Consider choosing a different directory. 2016-08-01T12:41:16.912926Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2016-08-01T12:41:16.912965Z 0 [Note] bin/mysqld (mysqld 5.7.13-enterprise-commercial-advanced-log) starting as process 3816 ... 2016-08-01T12:41:16.918031Z 0 [Note] InnoDB: PUNCH HOLE support not available 2016-08-01T12:41:16.918066Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-08-01T12:41:16.918072Z 0 [Note] InnoDB: Uses event mutexes 2016-08-01T12:41:16.918077Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2016-08-01T12:41:16.918081Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-01T12:41:16.918087Z 0 [Note] InnoDB: Using Linux native AIO 2016-08-01T12:41:16.918398Z 0 [Note] InnoDB: Number of pools: 1 2016-08-01T12:41:16.918521Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-08-01T12:41:16.920171Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-01T12:41:16.930187Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-01T12:41:16.932683Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-08-01T12:41:16.944697Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-01T12:41:16.957179Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-01T12:41:16.957251Z 0 [Note] InnoDB: Setting file '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-01T12:41:16.972215Z 0 [Note] InnoDB: File '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size is now 12 MB. 2016-08-01T12:41:16.973330Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-01T12:41:16.973346Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-01T12:41:16.973763Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-01T12:41:17.023889Z 0 [Note] InnoDB: 5.7.13 started; log sequence number 2764595 2016-08-01T12:41:17.024072Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:41:17.024337Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-01T12:41:17.025748Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160801 14:41:17 2016-08-01T12:41:17.026185Z 0 [Warning] Plugin audit_log reported: 'Audit Log plugin supports a filtering, which has not been installed yet. Audit Log plugin will run in the legacy mode, which will be disabled in the next release.' 2016-08-01T12:41:17.030716Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2016-08-01T12:41:17.030737Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2016-08-01T12:41:17.031399Z 0 [Warning] CA certificate ca.pem is self signed. 2016-08-01T12:41:17.031460Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2016-08-01T12:41:17.031592Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-01T12:41:17.031645Z 0 [Note] IPv6 is available. 2016-08-01T12:41:17.031660Z 0 [Note] - '::' resolves to '::'; 2016-08-01T12:41:17.031680Z 0 [Note] Server socket created on IP: '::'. 2016-08-01T12:41:17.042917Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-01T12:41:17.043176Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.13-enterprise-commercial-advanced-log' socket: '/tmp/mysql_ushastry.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [2]- Done bin/mysqld --defaults-file=./my.cnf [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: 5.7.14 - perform in place upgrade from 5.7.13 to 5.7.14 ====== [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.13: cd ../mysql-advanced-5.7.14/ [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: rm -rf data/log.err [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: bin/mysqld --defaults-file=./my.cnf & [2] 3858 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: 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.14-enterprise-commercial-advanced-log MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2016, 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-advanced-5.7.14: bin/mysql_upgrade -uroot -S /tmp/mysql_ushastry.sock --force Checking server version. Running queries to upgrade MySQL server. Checking system database. mysql.columns_priv OK mysql.db OK mysql.engine_cost OK mysql.event OK mysql.func OK mysql.general_log OK mysql.gtid_executed OK mysql.help_category OK mysql.help_keyword OK mysql.help_relation OK mysql.help_topic OK mysql.innodb_index_stats OK mysql.innodb_table_stats OK mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc OK mysql.procs_priv OK mysql.proxies_priv OK mysql.server_cost OK mysql.servers OK mysql.slave_master_info OK mysql.slave_relay_log_info OK mysql.slave_worker_info 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 Found outdated sys schema version 1.5.0. Upgrading the sys schema. Checking databases. sys.sys_config OK Upgrade process completed successfully. Checking if update is needed. [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: cat data/log.err 2016-08-01T12:42:24.533347Z 0 [Warning] Insecure configuration for --secure-file-priv: Plugin directory is accessible through --secure-file-priv. Consider choosing a different directory. 2016-08-01T12:42:24.533433Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2016-08-01T12:42:24.533474Z 0 [Note] bin/mysqld (mysqld 5.7.14-enterprise-commercial-advanced-log) starting as process 3858 ... 2016-08-01T12:42:24.538969Z 0 [Note] InnoDB: PUNCH HOLE support not available 2016-08-01T12:42:24.539004Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-08-01T12:42:24.539009Z 0 [Note] InnoDB: Uses event mutexes 2016-08-01T12:42:24.539014Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2016-08-01T12:42:24.539018Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-01T12:42:24.539022Z 0 [Note] InnoDB: Using Linux native AIO 2016-08-01T12:42:24.539322Z 0 [Note] InnoDB: Number of pools: 1 2016-08-01T12:42:24.539458Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-08-01T12:42:24.541090Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-01T12:42:24.550017Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-01T12:42:24.552481Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-08-01T12:42:24.564626Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-01T12:42:24.577502Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-01T12:42:24.577575Z 0 [Note] InnoDB: Setting file '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-01T12:42:24.592126Z 0 [Note] InnoDB: File '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size is now 12 MB. 2016-08-01T12:42:24.593175Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-01T12:42:24.593189Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-01T12:42:24.593613Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-01T12:42:24.643790Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2764623 2016-08-01T12:42:24.643946Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:42:24.644203Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-01T12:42:24.645853Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160801 14:42:24 2016-08-01T12:42:24.650288Z 0 [Warning] Plugin audit_log reported: 'Audit Log plugin supports a filtering, which has not been installed yet. Audit Log plugin will run in the legacy mode, which will be disabled in the next release.' 2016-08-01T12:42:24.654865Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2016-08-01T12:42:24.654886Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2016-08-01T12:42:24.655565Z 0 [Warning] CA certificate ca.pem is self signed. 2016-08-01T12:42:24.655621Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2016-08-01T12:42:24.655724Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-01T12:42:24.655779Z 0 [Note] IPv6 is available. 2016-08-01T12:42:24.655793Z 0 [Note] - '::' resolves to '::'; 2016-08-01T12:42:24.655812Z 0 [Note] Server socket created on IP: '::'. 2016-08-01T12:42:24.659271Z 0 [ERROR] Info table has a problem with its key field(s). Table 'mysql.slave_master_info' expected field #23 to be 'Channel_name' but found 'Tls_version' instead. 2016-08-01T12:42:24.664525Z 0 [ERROR] Incorrect definition of table performance_schema.replication_connection_status: expected column 'RECEIVED_TRANSACTION_SET' at position 7 to have type longtext, found type text. 2016-08-01T12:42:24.664858Z 0 [ERROR] Incorrect definition of table performance_schema.replication_group_member_stats: expected column 'COUNT_TRANSACTIONS_ROWS_VALIDATING' at position 6, found 'COUNT_TRANSACTIONS_VALIDATING'. 2016-08-01T12:42:24.665961Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-01T12:42:24.666221Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.14-enterprise-commercial-advanced-log' socket: '/tmp/mysql_ushastry.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: bin/mysqladmin -uroot -S /tmp/mysql_ushastry.sock shutdown [2]- Done bin/mysqld --defaults-file=./my.cnf [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: bin/mysqld --defaults-file=./my.cnf & [2] 3899 [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: cat data/log.err 2016-08-01T12:42:24.533347Z 0 [Warning] Insecure configuration for --secure-file-priv: Plugin directory is accessible through --secure-file-priv. Consider choosing a different directory. 2016-08-01T12:42:24.533433Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2016-08-01T12:42:24.533474Z 0 [Note] bin/mysqld (mysqld 5.7.14-enterprise-commercial-advanced-log) starting as process 3858 ... 2016-08-01T12:42:24.538969Z 0 [Note] InnoDB: PUNCH HOLE support not available 2016-08-01T12:42:24.539004Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-08-01T12:42:24.539009Z 0 [Note] InnoDB: Uses event mutexes 2016-08-01T12:42:24.539014Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2016-08-01T12:42:24.539018Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-01T12:42:24.539022Z 0 [Note] InnoDB: Using Linux native AIO 2016-08-01T12:42:24.539322Z 0 [Note] InnoDB: Number of pools: 1 2016-08-01T12:42:24.539458Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-08-01T12:42:24.541090Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-01T12:42:24.550017Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-01T12:42:24.552481Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-08-01T12:42:24.564626Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-01T12:42:24.577502Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-01T12:42:24.577575Z 0 [Note] InnoDB: Setting file '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-01T12:42:24.592126Z 0 [Note] InnoDB: File '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size is now 12 MB. 2016-08-01T12:42:24.593175Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-01T12:42:24.593189Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-01T12:42:24.593613Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-01T12:42:24.643790Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2764623 2016-08-01T12:42:24.643946Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:42:24.644203Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-01T12:42:24.645853Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160801 14:42:24 2016-08-01T12:42:24.650288Z 0 [Warning] Plugin audit_log reported: 'Audit Log plugin supports a filtering, which has not been installed yet. Audit Log plugin will run in the legacy mode, which will be disabled in the next release.' 2016-08-01T12:42:24.654865Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2016-08-01T12:42:24.654886Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2016-08-01T12:42:24.655565Z 0 [Warning] CA certificate ca.pem is self signed. 2016-08-01T12:42:24.655621Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2016-08-01T12:42:24.655724Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-01T12:42:24.655779Z 0 [Note] IPv6 is available. 2016-08-01T12:42:24.655793Z 0 [Note] - '::' resolves to '::'; 2016-08-01T12:42:24.655812Z 0 [Note] Server socket created on IP: '::'. 2016-08-01T12:42:24.659271Z 0 [ERROR] Info table has a problem with its key field(s). Table 'mysql.slave_master_info' expected field #23 to be 'Channel_name' but found 'Tls_version' instead. 2016-08-01T12:42:24.664525Z 0 [ERROR] Incorrect definition of table performance_schema.replication_connection_status: expected column 'RECEIVED_TRANSACTION_SET' at position 7 to have type longtext, found type text. 2016-08-01T12:42:24.664858Z 0 [ERROR] Incorrect definition of table performance_schema.replication_group_member_stats: expected column 'COUNT_TRANSACTIONS_ROWS_VALIDATING' at position 6, found 'COUNT_TRANSACTIONS_VALIDATING'. 2016-08-01T12:42:24.665961Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-01T12:42:24.666221Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.14-enterprise-commercial-advanced-log' socket: '/tmp/mysql_ushastry.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) 2016-08-01T12:43:12.611754Z 0 [Note] Giving 0 client threads a chance to die gracefully 2016-08-01T12:43:12.611780Z 0 [Note] Shutting down slave threads 2016-08-01T12:43:12.611790Z 0 [Note] Forcefully disconnecting 0 remaining clients 2016-08-01T12:43:12.611798Z 0 [Note] Event Scheduler: Purging the queue. 0 events 2016-08-01T12:43:12.611906Z 0 [Note] Binlog end 2016-08-01T12:43:12.612636Z 0 [Note] Shutting down plugin 'audit_log' 2016-08-01T12:43:12.612783Z 0 [Note] Shutting down plugin 'authentication_pam' 2016-08-01T12:43:12.612790Z 0 [Note] Shutting down plugin 'ngram' 2016-08-01T12:43:12.612792Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-08-01T12:43:12.612795Z 0 [Note] Shutting down plugin 'partition' 2016-08-01T12:43:12.612798Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-08-01T12:43:12.612802Z 0 [Note] Shutting down plugin 'CSV' 2016-08-01T12:43:12.612806Z 0 [Note] Shutting down plugin 'MEMORY' 2016-08-01T12:43:12.612810Z 0 [Note] Shutting down plugin 'MyISAM' 2016-08-01T12:43:12.612819Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-08-01T12:43:12.612824Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-08-01T12:43:12.612851Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-08-01T12:43:12.612855Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-08-01T12:43:12.612858Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-08-01T12:43:12.612860Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-08-01T12:43:12.612862Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-08-01T12:43:12.612865Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-08-01T12:43:12.612867Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-08-01T12:43:12.612869Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-08-01T12:43:12.612871Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-08-01T12:43:12.612874Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-08-01T12:43:12.612876Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-08-01T12:43:12.612878Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-08-01T12:43:12.612881Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-08-01T12:43:12.612883Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-08-01T12:43:12.612885Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-08-01T12:43:12.612887Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-08-01T12:43:12.612889Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-08-01T12:43:12.612891Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-08-01T12:43:12.612893Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-08-01T12:43:12.612896Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-08-01T12:43:12.612898Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-08-01T12:43:12.612900Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-08-01T12:43:12.612902Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-08-01T12:43:12.612904Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-08-01T12:43:12.612907Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-08-01T12:43:12.612909Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-08-01T12:43:12.612911Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-08-01T12:43:12.612913Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-08-01T12:43:12.612915Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-08-01T12:43:12.612917Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-08-01T12:43:12.612919Z 0 [Note] Shutting down plugin 'InnoDB' 2016-08-01T12:43:12.613011Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-08-01T12:43:12.613133Z 0 [Note] InnoDB: Starting shutdown... 2016-08-01T12:43:12.713333Z 0 [Note] InnoDB: Dumping buffer pool(s) to /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:43:12.713631Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160801 14:43:12 2016-08-01T12:43:14.422595Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2873373 2016-08-01T12:43:14.424883Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-08-01T12:43:14.424899Z 0 [Note] Shutting down plugin 'sha256_password' 2016-08-01T12:43:14.424904Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-08-01T12:43:14.425165Z 0 [Note] Shutting down plugin 'binlog' 2016-08-01T12:43:14.426166Z 0 [Note] bin/mysqld: Shutdown complete 2016-08-01T12:43:21.504751Z 0 [Warning] Insecure configuration for --secure-file-priv: Plugin directory is accessible through --secure-file-priv. Consider choosing a different directory. 2016-08-01T12:43:21.504833Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2016-08-01T12:43:21.504875Z 0 [Note] bin/mysqld (mysqld 5.7.14-enterprise-commercial-advanced-log) starting as process 3899 ... 2016-08-01T12:43:21.509930Z 0 [Note] InnoDB: PUNCH HOLE support not available 2016-08-01T12:43:21.509966Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-08-01T12:43:21.509972Z 0 [Note] InnoDB: Uses event mutexes 2016-08-01T12:43:21.509976Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2016-08-01T12:43:21.509981Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-08-01T12:43:21.509985Z 0 [Note] InnoDB: Using Linux native AIO 2016-08-01T12:43:21.510292Z 0 [Note] InnoDB: Number of pools: 1 2016-08-01T12:43:21.510423Z 0 [Note] InnoDB: Using CPU crc32 instructions 2016-08-01T12:43:21.512081Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-08-01T12:43:21.521164Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-08-01T12:43:21.523701Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-08-01T12:43:21.535873Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-08-01T12:43:21.549077Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-08-01T12:43:21.549157Z 0 [Note] InnoDB: Setting file '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-08-01T12:43:21.563845Z 0 [Note] InnoDB: File '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ibtmp1' size is now 12 MB. 2016-08-01T12:43:21.564893Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-08-01T12:43:21.564908Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-08-01T12:43:21.565269Z 0 [Note] InnoDB: Waiting for purge to start 2016-08-01T12:43:21.615401Z 0 [Note] InnoDB: 5.7.14 started; log sequence number 2873373 2016-08-01T12:43:21.615560Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-advanced-5.6.21/data/ib_buffer_pool 2016-08-01T12:43:21.615790Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-08-01T12:43:21.617734Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160801 14:43:21 2016-08-01T12:43:21.622047Z 0 [Warning] Plugin audit_log reported: 'Audit Log plugin supports a filtering, which has not been installed yet. Audit Log plugin will run in the legacy mode, which will be disabled in the next release.' 2016-08-01T12:43:21.626258Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2016-08-01T12:43:21.626281Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2016-08-01T12:43:21.626928Z 0 [Warning] CA certificate ca.pem is self signed. 2016-08-01T12:43:21.626993Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2016-08-01T12:43:21.627102Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2016-08-01T12:43:21.627150Z 0 [Note] IPv6 is available. 2016-08-01T12:43:21.627161Z 0 [Note] - '::' resolves to '::'; 2016-08-01T12:43:21.627180Z 0 [Note] Server socket created on IP: '::'. 2016-08-01T12:43:21.630865Z 0 [ERROR] Info table has a problem with its key field(s). Table 'mysql.slave_master_info' expected field #23 to be 'Channel_name' but found 'Tls_version' instead. 2016-08-01T12:43:21.637790Z 0 [Note] Event Scheduler: Loaded 0 events 2016-08-01T12:43:21.638005Z 0 [Note] bin/mysqld: ready for connections. Version: '5.7.14-enterprise-commercial-advanced-log' socket: '/tmp/mysql_ushastry.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial) [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.14: