--source include/master-slave.inc --connection master set sql_mode=''; use test; CREATE TABLE `test_partition` ( `currenttime` datetime NOT NULL, `ddid` varchar(200) NOT NULL, `publishtime` varchar(128) DEFAULT NULL, `link` text, `type` text, `title` text, `taskname` text, `isupdate` int(2) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (TO_DAYS(currenttime)) (PARTITION p2016 VALUES LESS THAN (736695) ENGINE = InnoDB, PARTITION p2017 VALUES LESS THAN (737060) ENGINE = InnoDB, PARTITION p201801 VALUES LESS THAN (737091) ENGINE = InnoDB, PARTITION p201802 VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION p201803 VALUES LESS THAN (737150) ENGINE = InnoDB, PARTITION p201804 VALUES LESS THAN (737180) ENGINE = InnoDB, PARTITION p201805 VALUES LESS THAN (737211) ENGINE = InnoDB, PARTITION p201806 VALUES LESS THAN (737241) ENGINE = InnoDB, PARTITION p201807 VALUES LESS THAN (737272) ENGINE = InnoDB, PARTITION p201808 VALUES LESS THAN (737303) ENGINE = InnoDB, PARTITION p201809 VALUES LESS THAN (737333) ENGINE = InnoDB, PARTITION p201810 VALUES LESS THAN (737364) ENGINE = InnoDB, PARTITION p201811 VALUES LESS THAN (737394) ENGINE = InnoDB, PARTITION p201812 VALUES LESS THAN (737425) ENGINE = InnoDB, PARTITION p201901 VALUES LESS THAN (737456) ENGINE = InnoDB, PARTITION p201902 VALUES LESS THAN (737484) ENGINE = InnoDB, PARTITION p201903 VALUES LESS THAN (737515) ENGINE = InnoDB, PARTITION p201904 VALUES LESS THAN (737545) ENGINE = InnoDB, PARTITION p201905 VALUES LESS THAN (737576) ENGINE = InnoDB, PARTITION p201906 VALUES LESS THAN (737606) ENGINE = InnoDB, PARTITION p201907 VALUES LESS THAN (737637) ENGINE = InnoDB, PARTITION p201908 VALUES LESS THAN (737668) ENGINE = InnoDB, PARTITION p201909 VALUES LESS THAN (737698) ENGINE = InnoDB, PARTITION p201910 VALUES LESS THAN (737729) ENGINE = InnoDB, PARTITION p201911 VALUES LESS THAN (737759) ENGINE = InnoDB, PARTITION p201912 VALUES LESS THAN (737790) ENGINE = InnoDB, PARTITION p2020 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; insert into test_partition select '2017-01-01' ,uuid(),'20170101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-08-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-09-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-10-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-11-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-12-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; ALTER TABLE `test_partition` MODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST , MODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`, ADD PRIMARY KEY (`currenttime`, `ddid`), ADD UNIQUE INDEX `currenttime` (`currenttime`) USING BTREE; --sync_slave_with_master --connection slave use test; desc test_partition; -- 5.7.17 affected [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/mysql-test: ./mtr rpl_bug89506 Logging: ./mtr rpl_bug89506 MySQL Version 5.7.17 Too long tmpdir path '/export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/mysql-test/var/tmp' creating a shorter one... - using tmpdir: '/tmp/T3dz8KlWFg' Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] set sql_mode=''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. use test; CREATE TABLE `test_partition` ( `currenttime` datetime NOT NULL, `ddid` varchar(200) NOT NULL, `publishtime` varchar(128) DEFAULT NULL, `link` text, `type` text, `title` text, `taskname` text, `isupdate` int(2) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (TO_DAYS(currenttime)) (PARTITION p2016 VALUES LESS THAN (736695) ENGINE = InnoDB, PARTITION p2017 VALUES LESS THAN (737060) ENGINE = InnoDB, PARTITION p201801 VALUES LESS THAN (737091) ENGINE = InnoDB, PARTITION p201802 VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION p201803 VALUES LESS THAN (737150) ENGINE = InnoDB, PARTITION p201804 VALUES LESS THAN (737180) ENGINE = InnoDB, PARTITION p201805 VALUES LESS THAN (737211) ENGINE = InnoDB, PARTITION p201806 VALUES LESS THAN (737241) ENGINE = InnoDB, PARTITION p201807 VALUES LESS THAN (737272) ENGINE = InnoDB, PARTITION p201808 VALUES LESS THAN (737303) ENGINE = InnoDB, PARTITION p201809 VALUES LESS THAN (737333) ENGINE = InnoDB, PARTITION p201810 VALUES LESS THAN (737364) ENGINE = InnoDB, PARTITION p201811 VALUES LESS THAN (737394) ENGINE = InnoDB, PARTITION p201812 VALUES LESS THAN (737425) ENGINE = InnoDB, PARTITION p201901 VALUES LESS THAN (737456) ENGINE = InnoDB, PARTITION p201902 VALUES LESS THAN (737484) ENGINE = InnoDB, PARTITION p201903 VALUES LESS THAN (737515) ENGINE = InnoDB, PARTITION p201904 VALUES LESS THAN (737545) ENGINE = InnoDB, PARTITION p201905 VALUES LESS THAN (737576) ENGINE = InnoDB, PARTITION p201906 VALUES LESS THAN (737606) ENGINE = InnoDB, PARTITION p201907 VALUES LESS THAN (737637) ENGINE = InnoDB, PARTITION p201908 VALUES LESS THAN (737668) ENGINE = InnoDB, PARTITION p201909 VALUES LESS THAN (737698) ENGINE = InnoDB, PARTITION p201910 VALUES LESS THAN (737729) ENGINE = InnoDB, PARTITION p201911 VALUES LESS THAN (737759) ENGINE = InnoDB, PARTITION p201912 VALUES LESS THAN (737790) ENGINE = InnoDB, PARTITION p2020 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; insert into test_partition select '2017-01-01' ,uuid(),'20170101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-08-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-09-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-10-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-11-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-12-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; ALTER TABLE `test_partition` MODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST , MODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`, ADD PRIMARY KEY (`currenttime`, `ddid`), ADD UNIQUE INDEX `currenttime` (`currenttime`) USING BTREE; main.rpl_bug89506 [ fail ] Test ended at 2018-02-02 08:48:25 CURRENT_TEST: main.rpl_bug89506 mysqltest: At line 72: failed in 'select master_pos_wait('master-bin.000001', 12400, 300)': 2013: Lost connection to MySQL server during query safe_process[21803]: Child process: 21804, exit: 1 Server [mysqld.2 - pid: 21747, winpid: 21747, exit: 256] failed during test run Server log from this test: ----------SERVER LOG START----------- 2018-02-02T07:48:23.163257Z 0 [Warning] The syntax '--master-retry-count' is deprecated and will be removed in a future release. Please use 'CHANGE MASTER TO master_retry_count = ' instead. 2018-02-02T07:48:23.163410Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2018-02-02T07:48:23.165476Z 0 [Warning] Insecure configuration for --secure-file-priv: Data directory is accessible through --secure-file-priv. Consider choosing a different directory. 2018-02-02T07:48:23.165488Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory. 2018-02-02T07:48:23.165524Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld (mysqld 5.7.17-log) starting as process 21748 ... 2018-02-02T07:48:23.169094Z 0 [Note] InnoDB: PUNCH HOLE support not available 2018-02-02T07:48:23.169129Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-02-02T07:48:23.169136Z 0 [Note] InnoDB: Uses event mutexes 2018-02-02T07:48:23.169141Z 0 [Note] InnoDB: GCC builtin __sync_synchronize() is used for memory barrier 2018-02-02T07:48:23.169145Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 2018-02-02T07:48:23.169149Z 0 [Note] InnoDB: Using Linux native AIO 2018-02-02T07:48:23.169449Z 0 [Note] InnoDB: Number of pools: 1 2018-02-02T07:48:23.169570Z 0 [Note] InnoDB: Using CPU crc32 instructions 2018-02-02T07:48:23.170953Z 0 [Note] InnoDB: Initializing buffer pool, total size = 24M, instances = 1, chunk size = 24M 2018-02-02T07:48:23.173217Z 0 [Note] InnoDB: Completed initialization of buffer pool 2018-02-02T07:48:23.173886Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-02-02T07:48:23.186017Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2018-02-02T07:48:23.195095Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-02-02T07:48:23.195158Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-02-02T07:48:23.209178Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-02-02T07:48:23.210272Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2018-02-02T07:48:23.210287Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2018-02-02T07:48:23.210663Z 0 [Note] InnoDB: Waiting for purge to start 2018-02-02T07:48:23.260798Z 0 [Note] InnoDB: 5.7.17 started; log sequence number 1350521 2018-02-02T07:48:23.260955Z 0 [Note] InnoDB: Loading buffer pool(s) from /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/mysql-test/var/mysqld.2/data/ib_buffer_pool 2018-02-02T07:48:23.261151Z 0 [Note] Plugin 'FEDERATED' is disabled. 2018-02-02T07:48:23.262316Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180202 10:48:23 2018-02-02T07:48:23.263028Z 0 [Warning] unknown variable 'loose-mysqlx-port=13010' 2018-02-02T07:48:23.263045Z 0 [Warning] unknown variable 'loose-mysqlx-socket=/tmp/T3dz8KlWFg/mysqlx.2.sock' 2018-02-02T07:48:23.263049Z 0 [Warning] unknown variable 'loose-sha256_password_auto_generate_rsa_keys=0' 2018-02-02T07:48:23.263052Z 0 [Warning] unknown variable 'loose-debug-sync-timeout=600' 2018-02-02T07:48:23.264887Z 0 [Note] Salting uuid generator variables, current_pid: 21748, server_start_time: 1517557703, bytes_sent: 0, 2018-02-02T07:48:23.264940Z 0 [Note] Generated uuid: '71cc2a9a-07ed-11e8-a362-0010e05f3e06', server_start_time: 6121517795020926139, bytes_sent: 39927984 2018-02-02T07:48:23.264956Z 0 [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: 71cc2a9a-07ed-11e8-a362-0010e05f3e06. 2018-02-02T07:48:23.266104Z 0 [Warning] CA certificate /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/mysql-test/std_data/cacert.pem is self signed. 2018-02-02T07:48:23.267705Z 0 [Note] Server hostname (bind-address): '*'; port: 13001 2018-02-02T07:48:23.267753Z 0 [Note] IPv6 is available. 2018-02-02T07:48:23.267769Z 0 [Note] - '::' resolves to '::'; 2018-02-02T07:48:23.267815Z 0 [Note] Server socket created on IP: '::'. 2018-02-02T07:48:23.280719Z 0 [Note] Event Scheduler: Loaded 0 events 2018-02-02T07:48:23.280827Z 0 [Note] Executing 'SELECT * FROM INFORMATION_SCHEMA.TABLES;' to get a list of tables using the deprecated partition engine. You may use the startup option '--disable-partition-engine-check' to skip this check. 2018-02-02T07:48:23.280839Z 0 [Note] Beginning of list of non-natively partitioned tables 2018-02-02T07:48:23.292983Z 0 [Note] End of list of non-natively partitioned tables 2018-02-02T07:48:23.293075Z 0 [Note] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld: ready for connections. Version: '5.7.17-log' socket: '/tmp/T3dz8KlWFg/mysqld.2.sock' port: 13001 MySQL Community Server (GPL) 2018-02-02T07:48:23.421805Z 4 [Note] 'CHANGE MASTER TO FOR CHANNEL '' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='127.0.0.1', master_port= 13000, master_log_file='', master_log_pos= 4, master_bind=''. 2018-02-02T07:48:23.428294Z 6 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2018-02-02T07:48:23.428591Z 7 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 2018-02-02T07:48:23.428623Z 7 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'FIRST' at position 0, relay log './slave-relay-bin.000001' position: 4 2018-02-02T07:48:23.428713Z 6 [Note] Slave I/O thread for channel '': connected to master 'root@127.0.0.1:13000',replication started in log 'FIRST' at position 4 07:48:25 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail. key_buffer_size=1048576 read_buffer_size=131072 max_used_connections=4 max_threads=151 thread_count=6 connection_count=4 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 61022 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Thread pointer: 0x7fc8e40008c0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fc921783ea0 thread_stack 0x40000 /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(my_print_stacktrace+0x35)[0xf21bb5] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(handle_fatal_signal+0x4a4)[0x79e354] /lib64/libpthread.so.0(+0xf130)[0x7fc929594130] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld[0x105c297] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z24mem_heap_free_block_freeP16mem_block_info_t+0x21)[0x105cb11] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z33row_mysql_prebuilt_free_blob_heapP14row_prebuilt_t+0x30)[0x10c3860] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z17row_prebuilt_freeP14row_prebuilt_tm+0xc9)[0x10c3af9] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_ZN11ha_innobase26commit_inplace_alter_tableEP5TABLEP18Alter_inplace_infob+0x219e)[0x101d49e] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_ZN11ha_innopart26commit_inplace_alter_tableEP5TABLEP18Alter_inplace_infob+0x177)[0x101f227] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld[0xd5f575] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z17mysql_alter_tableP3THDPKcS2_P24st_ha_create_informationP10TABLE_LISTP10Alter_info+0x39cd)[0xd631bd] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_ZN19Sql_cmd_alter_table7executeEP3THD+0x4c3)[0xe65373] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z21mysql_execute_commandP3THDb+0xdb8)[0xcf4e58] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z11mysql_parseP3THDP12Parser_state+0x3a5)[0xcf9415] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_ZN15Query_log_event14do_apply_eventEPK14Relay_log_infoPKcm+0x7c3)[0xeaf003] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_ZN9Log_event11apply_eventEP14Relay_log_info+0x68)[0xeac978] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(_Z26apply_event_and_update_posPP9Log_eventP3THDP14Relay_log_info+0x1c6)[0xee7046] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld[0xef08f9] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(handle_slave_sql+0xff1)[0xef27f1] /export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld(pfs_spawn_thread+0x174)[0xf7df44] /lib64/libpthread.so.0(+0x7df5)[0x7fc92958cdf5] /lib64/libc.so.6(clone+0x6d)[0x7fc92825860d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7fc8e40227a9): ALTER TABLE `test_partition` MODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST , MODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`, ADD PRIMARY KEY (`currenttime`, `ddid`), ADD UNIQUE INDEX `currenttime` (`currenttime`) USING BTREE Connection ID (thread ID): 7 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file safe_process[21747]: Child process: 21748, killed by signal: 11 ----------SERVER LOG END------------- - the logfile can be found in '/export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/mysql-test/var/log/main.rpl_bug89506/rpl_bug89506.log' - found 'core.21748' (0/5) Trying 'dbx' to get a backtrace Trying 'gdb' to get a backtrace Guessing that core was generated by '/export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/mysqld' Output from gdb follows. The first stack trace is from the failing thread. The following stack traces are from all threads (so the failing one is duplicated). -------------------------- [New LWP 21809] [New LWP 21814] [New LWP 21813] [New LWP 21768] [New LWP 21793] [New LWP 21805] [New LWP 21797] [New LWP 21773] [New LWP 21748] [New LWP 21781] [New LWP 21791] [New LWP 21779] [New LWP 21792] [New LWP 21808] [New LWP 21802] [New LWP 21794] [New LWP 21772] [New LWP 21769] [New LWP 21770] [New LWP 21767] [New LWP 21778] [New LWP 21771] [New LWP 21790] [New LWP 21777] [New LWP 21776] [New LWP 21766] [New LWP 21782] [New LWP 21780] [New LWP 21775] [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib64/libthread_db.so.1". Core was generated by `/export/umesh/server/binaries/GABuilds/mysql-5.7.17-linux-glibc2.5-x86_64/bin/m'. Program terminated with signal 11, Segmentation fault. #0 0x00007fc929591771 in pthread_kill () from /lib64/libpthread.so.0 #0 0x00007fc929591771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000079e2b4 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/signal_handler.cc:220 #2 #3 buf_pool_from_bpage (bpage=0x9d) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/buf0buf.ic:97 #4 buf_block_free (block=0x9d) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/buf0buf.ic:799 #5 0x000000000105cb11 in mem_heap_free_block_free (heap=0x7fc8e40b7118) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/mem/mem0mem.cc:475 #6 0x00000000010c3860 in mem_heap_free (heap=0x7fc8e40b7118) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/mem0mem.ic:529 #7 row_mysql_prebuilt_free_blob_heap (prebuilt=0x7fc8e40b3168) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0mysql.cc:176 #8 0x00000000010c3af9 in row_prebuilt_free (prebuilt=0x7fc8e40b3168, dict_locked=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0mysql.cc:1034 #9 0x000000000101d49e in ha_innobase::commit_inplace_alter_table (this=0x7fc8e400e830, altered_table=0x7fc8e40a98c0, ha_alter_info=0x7fc921781050, commit=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/handler/handler0alter.cc:8726 #10 0x000000000101f227 in ha_innopart::commit_inplace_alter_table (this=0x7fc8e400e830, altered_table=0x7fc8e40a98c0, ha_alter_info=0x7fc921781050, commit=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/handler/handler0alter.cc:9120 #11 0x0000000000d5f575 in mysql_inplace_alter_table (thd=0x7fc8e40008c0, table_list=0x7fc8e4006890, table=0x7fc8e4019970, altered_table=0x7fc8e40a98c0, ha_alter_info=0x7fc921781050, inplace_supported=, target_mdl_request=0x7fc921781810, alter_ctx=0x7fc92177fab0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_table.cc:7545 #12 0x0000000000d631bd in mysql_alter_table (thd=0x7fc8e40008c0, new_db=0x7fc8e40a98c0 "(\242\n\344\310\177", new_name=0x7fc921781050 "0\"x!\311\177", create_info=0x7fc921781050, table_list=0x7fc8e4006890, alter_info=0x7fc921782330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_table.cc:9686 #13 0x0000000000e65373 in Sql_cmd_alter_table::execute (this=, thd=0x7fc8e40008c0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_alter.cc:316 #14 0x0000000000cf4e58 in mysql_execute_command (thd=0x7fc8e40008c0, first_level=true) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:4893 #15 0x0000000000cf9415 in mysql_parse (thd=0x7fc8e40008c0, parser_state=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:5611 #16 0x0000000000eaf003 in Query_log_event::do_apply_event (this=0x7fc8e40a0a50, rli=0x29b1230, query_arg=0x7fc8e40227a9 "ALTER TABLE `test_partition`\nMODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST ,\nMODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`,\nADD PRIMARY KEY"..., q_len_arg=140500795401504) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/log_event.cc:4595 #17 0x0000000000eac978 in Log_event::apply_event (this=0x7fc8e40a0a50, rli=0x29b1230) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/log_event.cc:3242 #18 0x0000000000ee7046 in apply_event_and_update_pos (ptr_ev=0x7fc921783718, thd=0x7fc8e40008c0, rli=0x29b1230) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:4702 #19 0x0000000000ef08f9 in exec_relay_log_event (thd=0x7fc8e40008c0, rli=0x29b1230) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:5212 #20 0x0000000000ef27f1 in handle_slave_sql (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:7320 #21 0x0000000000f7df44 in pfs_spawn_thread (arg=0x7fc8f8163330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #22 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #23 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 29 (Thread 0x7fc91cdf8700 (LWP 21775)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107159e in os_event::timed_wait (this=, abstime=0x7fc91cdf7df0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:285 #2 0x00000000010718be in os_event::wait_time_low (this=0x2578558, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:412 #3 0x0000000001047c74 in lock_wait_timeout_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/lock/lock0wait.cc:501 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 28 (Thread 0x7fc9157fb700 (LWP 21780)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107148b in wait (this=0x25b01a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x25b01a8, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:335 #3 0x000000000111b2c9 in sync_array_wait_event (arr=0x20e9058, cell=@0x7fc9157fac28: 0x7fc9237f70a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0arr.cc:475 #4 0x000000000111cf16 in rw_lock_s_lock_spin (lock=0x2637218, pass=, file_name=0x15f7320 "/export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc", line=861) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0rw.cc:425 #5 0x00000000010ddd9d in rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:433 #6 pfs_rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:796 #7 row_purge_parse_undo_rec (thr=0x2673b48, updated_extern=0x7fc9157fad7f, undo_rec=0x7fc910011238 "7v\016\200\322\001", node=0x2673c10) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:861 #8 row_purge (thr=0x2673b48, undo_rec=0x7fc910011238 "7v\016\200\322\001", node=0x2673c10) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1028 #9 row_purge_step (thr=0x2673b48) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1110 #10 0x0000000001091f2f in que_thr_step (thr=0x2673b48) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1056 #11 que_run_threads_low (thr=0x2673b48) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1118 #12 que_run_threads (thr=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1158 #13 0x000000000110f8d8 in srv_task_execute () at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2458 #14 srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2508 #15 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #16 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 27 (Thread 0x7fc90bfff700 (LWP 21782)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107148b in wait (this=0x25b01a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x25b01a8, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:335 #3 0x000000000111b2c9 in sync_array_wait_event (arr=0x20e9058, cell=@0x7fc90bffec28: 0x7fc9237f70e8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0arr.cc:475 #4 0x000000000111cf16 in rw_lock_s_lock_spin (lock=0x2637218, pass=, file_name=0x15f7320 "/export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc", line=861) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0rw.cc:425 #5 0x00000000010ddd9d in rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:433 #6 pfs_rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:796 #7 row_purge_parse_undo_rec (thr=0x2673db0, updated_extern=0x7fc90bffed7f, undo_rec=0x7fc9100131f8 "5\r\016\200\310\001", node=0x2674238) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:861 #8 row_purge (thr=0x2673db0, undo_rec=0x7fc9100131f8 "5\r\016\200\310\001", node=0x2674238) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1028 #9 row_purge_step (thr=0x2673db0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1110 #10 0x0000000001091f2f in que_thr_step (thr=0x2673db0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1056 #11 que_run_threads_low (thr=0x2673db0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1118 #12 que_run_threads (thr=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1158 #13 0x000000000110f8d8 in srv_task_execute () at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2458 #14 srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2508 #15 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #16 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 26 (Thread 0x7fc924417700 (LWP 21766)): #0 0x00007fc9281987da in sigwaitinfo () from /lib64/libc.so.6 #1 0x0000000000f28e1b in timer_notify_thread_func (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/mysys/posix_timers.c:77 #2 0x0000000000f7df44 in pfs_spawn_thread (arg=0x20971e0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #3 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 25 (Thread 0x7fc917fff700 (LWP 21776)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107159e in os_event::timed_wait (this=, abstime=0x7fc917ffeb00) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:285 #2 0x00000000010718be in os_event::wait_time_low (this=0x21005b8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:412 #3 0x000000000110eea5 in srv_error_monitor_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:1737 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 24 (Thread 0x7fc9175fe700 (LWP 21777)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107159e in os_event::timed_wait (this=, abstime=0x7fc9175fde70) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:285 #2 0x00000000010718be in os_event::wait_time_low (this=0x2100648, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:412 #3 0x000000000110df44 in srv_monitor_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:1571 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 23 (Thread 0x7fc90b5fe700 (LWP 21790)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107148b in wait (this=0x21006d8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x21006d8, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:335 #3 0x00000000011b2ec4 in buf_dump_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/buf/buf0dump.cc:781 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 22 (Thread 0x7fc91ee21700 (LWP 21771)): #0 0x00007fc929383644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001068944 in LinuxAIOHandler::collect (this=0x7fc91ee20df0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2492 #2 0x000000000106ab84 in LinuxAIOHandler::poll (this=0x7fc91ee20df0, m1=0x7fc91ee20ec8, m2=0x7fc91ee20ec0, request=0x7fc91ee20e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2638 #3 0x000000000106cf97 in os_aio_linux_handler (request=0x7fc91ee20e90, m2=0x7fc91ee20ec0, m1=0x7fc91ee20ec8, global_segment=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2694 #4 os_aio_handler (segment=4, m1=0x7fc91ee20ec8, m2=0x7fc91ee20ec0, request=0x7fc91ee20e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:6246 #5 0x0000000001204678 in fil_aio_wait (segment=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fil/fil0fil.cc:5817 #6 0x00000000011115c0 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0start.cc:308 #7 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 21 (Thread 0x7fc916bfd700 (LWP 21778)): #0 0x00007fc92959399d in nanosleep () from /lib64/libpthread.so.0 #1 0x0000000001071b50 in os_thread_sleep (tm=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0thread.cc:279 #2 0x000000000110e56b in srv_master_sleep () at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2316 #3 srv_master_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2363 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 20 (Thread 0x7fc921625700 (LWP 21767)): #0 0x00007fc929383644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001068944 in LinuxAIOHandler::collect (this=0x7fc921624df0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2492 #2 0x000000000106ab84 in LinuxAIOHandler::poll (this=0x7fc921624df0, m1=0x7fc921624ec8, m2=0x7fc921624ec0, request=0x7fc921624e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2638 #3 0x000000000106cf97 in os_aio_linux_handler (request=0x7fc921624e90, m2=0x7fc921624ec0, m1=0x7fc921624ec8, global_segment=0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2694 #4 os_aio_handler (segment=0, m1=0x7fc921624ec8, m2=0x7fc921624ec0, request=0x7fc921624e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:6246 #5 0x0000000001204678 in fil_aio_wait (segment=0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fil/fil0fil.cc:5817 #6 0x00000000011115c0 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0start.cc:308 #7 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 19 (Thread 0x7fc91f822700 (LWP 21770)): #0 0x00007fc929383644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001068944 in LinuxAIOHandler::collect (this=0x7fc91f821df0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2492 #2 0x000000000106ab84 in LinuxAIOHandler::poll (this=0x7fc91f821df0, m1=0x7fc91f821ec8, m2=0x7fc91f821ec0, request=0x7fc91f821e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2638 #3 0x000000000106cf97 in os_aio_linux_handler (request=0x7fc91f821e90, m2=0x7fc91f821ec0, m1=0x7fc91f821ec8, global_segment=3) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2694 #4 os_aio_handler (segment=3, m1=0x7fc91f821ec8, m2=0x7fc91f821ec0, request=0x7fc91f821e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:6246 #5 0x0000000001204678 in fil_aio_wait (segment=3) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fil/fil0fil.cc:5817 #6 0x00000000011115c0 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0start.cc:308 #7 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 18 (Thread 0x7fc920223700 (LWP 21769)): #0 0x00007fc929383644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001068944 in LinuxAIOHandler::collect (this=0x7fc920222df0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2492 #2 0x000000000106ab84 in LinuxAIOHandler::poll (this=0x7fc920222df0, m1=0x7fc920222ec8, m2=0x7fc920222ec0, request=0x7fc920222e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2638 #3 0x000000000106cf97 in os_aio_linux_handler (request=0x7fc920222e90, m2=0x7fc920222ec0, m1=0x7fc920222ec8, global_segment=2) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2694 #4 os_aio_handler (segment=2, m1=0x7fc920222ec8, m2=0x7fc920222ec0, request=0x7fc920222e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:6246 #5 0x0000000001204678 in fil_aio_wait (segment=2) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fil/fil0fil.cc:5817 #6 0x00000000011115c0 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0start.cc:308 #7 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 17 (Thread 0x7fc91e420700 (LWP 21772)): #0 0x00007fc929383644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001068944 in LinuxAIOHandler::collect (this=0x7fc91e41fdf0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2492 #2 0x000000000106ab84 in LinuxAIOHandler::poll (this=0x7fc91e41fdf0, m1=0x7fc91e41fec8, m2=0x7fc91e41fec0, request=0x7fc91e41fe90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2638 #3 0x000000000106cf97 in os_aio_linux_handler (request=0x7fc91e41fe90, m2=0x7fc91e41fec0, m1=0x7fc91e41fec8, global_segment=5) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2694 #4 os_aio_handler (segment=5, m1=0x7fc91e41fec8, m2=0x7fc91e41fec0, request=0x7fc91e41fe90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:6246 #5 0x0000000001204678 in fil_aio_wait (segment=5) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fil/fil0fil.cc:5817 #6 0x00000000011115c0 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0start.cc:308 #7 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 16 (Thread 0x7fc921888700 (LWP 21794)): #0 0x00007fc929593ec1 in sigwait () from /lib64/libpthread.so.0 #1 0x000000000079362b in signal_hand (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/mysqld.cc:2101 #2 0x0000000000f7df44 in pfs_spawn_thread (arg=0x2614590) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #3 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #4 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 15 (Thread 0x7fc921847700 (LWP 21802)): #0 0x00007fc92824e00d in poll () from /lib64/libc.so.6 #1 0x00000000012a64ff in vio_io_wait (vio=, event=, timeout=28800000) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:786 #2 0x00000000012a65f3 in vio_socket_io_wait (vio=, event=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:77 #3 0x00000000012a6c28 in vio_read (vio=0x7fc8f815ca30, buf=0x7fc8f80903d0 "\001", size=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:132 #4 0x0000000000c4de13 in net_read_raw_loop (net=0x7fc8f8026330, count=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:672 #5 0x0000000000c4e6ab in net_read_packet_header (net=0x7fc8f8026330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:756 #6 net_read_packet (net=, complen=0x7fc921846d38) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:822 #7 0x0000000000c4e95c in my_net_read (net=0x7fc8f8026330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:899 #8 0x0000000000c5c14c in Protocol_classic::read_packet (this=0x7fc8f8025be0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/protocol_classic.cc:808 #9 0x0000000000c5af52 in Protocol_classic::get_command (this=0x7fc8f8025be0, com_data=0x7fc921846de0, cmd=0x7fc921846e0c) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/protocol_classic.cc:965 #10 0x0000000000cfb3c7 in do_command (thd=0x7fc8f8024b90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:938 #11 0x0000000000dc858c in handle_connection (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/connection_handler_per_thread.cc:300 #12 0x0000000000f7df44 in pfs_spawn_thread (arg=0x29d0ff0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #13 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 14 (Thread 0x7fc9217c5700 (LWP 21808)): #0 0x00007fc92824e00d in poll () from /lib64/libc.so.6 #1 0x00000000012a64ff in vio_io_wait (vio=, event=, timeout=120000) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:786 #2 0x00000000012a65f3 in vio_socket_io_wait (vio=, event=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:77 #3 0x00000000012a6c28 in vio_read (vio=0x7fc8f0010a20, buf=0x7fc8f0010c40 "B", size=16384) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:132 #4 0x00000000012a6cd2 in vio_read_buff (vio=0x7fc8f0010a20, buf=0x7fc8f0014c70 "", size=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:166 #5 0x0000000000c4de13 in net_read_raw_loop (net=0x7fc8f000dea0, count=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:672 #6 0x0000000000c4e7d8 in net_read_packet_header (net=0x7fc8f000dea0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:762 #7 net_read_packet (net=0x7fc8f000dea0, complen=0x7fc9217c4ab8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:822 #8 0x0000000000c4e95c in my_net_read (net=0x7fc8f000dea0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:899 #9 0x0000000000dbf2ff in cli_safe_read_with_ok (mysql=0x7fc8f000dea0, parse_ok=0 '\000', is_data_packet=0x0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql-common/client.c:1040 #10 0x0000000000eed19f in read_event (suppress_warnings=0x7fc9217c4eaf, mi=0x20d05b0, mysql=0x7fc8f000dea0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:4455 #11 handle_slave_io (arg=0x20d05b0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:5698 #12 0x0000000000f7df44 in pfs_spawn_thread (arg=0x7fc8f8163330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #13 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 13 (Thread 0x7fc90a1fc700 (LWP 21792)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107159e in os_event::timed_wait (this=, abstime=0x7fc90a1fb990) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:285 #2 0x00000000010718be in os_event::wait_time_low (this=0x2602818, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:412 #3 0x0000000001163ab7 in ib_wqueue_timedwait (wq=0x25da628, wait_in_usecs=5000000) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/ut/ut0wqueue.cc:160 #4 0x000000000124b36a in fts_optimize_thread (arg=0x25da628) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fts/fts0opt.cc:3040 #5 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 12 (Thread 0x7fc9161fc700 (LWP 21779)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107148b in wait (this=0x25b01a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x25b01a8, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:335 #3 0x000000000111b2c9 in sync_array_wait_event (arr=0x20e9058, cell=@0x7fc9161fbb38: 0x7fc9237f7028) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0arr.cc:475 #4 0x000000000111cf16 in rw_lock_s_lock_spin (lock=0x2637218, pass=, file_name=0x15f7320 "/export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc", line=861) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0rw.cc:425 #5 0x00000000010ddd9d in rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:433 #6 pfs_rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:796 #7 row_purge_parse_undo_rec (thr=0x26743d8, updated_extern=0x7fc9161fbc8f, undo_rec=0x7fc910015170 "5d\016\200\312\001", node=0x26744a0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:861 #8 row_purge (thr=0x26743d8, undo_rec=0x7fc910015170 "5d\016\200\312\001", node=0x26744a0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1028 #9 row_purge_step (thr=0x26743d8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1110 #10 0x0000000001091f2f in que_thr_step (thr=0x26743d8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1056 #11 que_run_threads_low (thr=0x26743d8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1118 #12 que_run_threads (thr=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1158 #13 0x000000000112e469 in trx_purge (n_purge_threads=4, batch_size=300, truncate=false) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/trx/trx0purge.cc:1867 #14 0x0000000001110939 in srv_do_purge (n_total_purged=, n_threads=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2617 #15 srv_purge_coordinator_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2789 #16 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #17 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 11 (Thread 0x7fc90abfd700 (LWP 21791)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107159e in os_event::timed_wait (this=, abstime=0x7fc90abfce10) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:285 #2 0x00000000010718be in os_event::wait_time_low (this=0x25a9eb8, time_in_usec=, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:412 #3 0x00000000011ffbca in dict_stats_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/dict/dict0stats_bg.cc:421 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 10 (Thread 0x7fc914dfa700 (LWP 21781)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107148b in wait (this=0x25b01a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x25b01a8, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:335 #3 0x000000000111b2c9 in sync_array_wait_event (arr=0x20e9058, cell=@0x7fc914df9c28: 0x7fc9237f7068) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0arr.cc:475 #4 0x000000000111cf16 in rw_lock_s_lock_spin (lock=0x2637218, pass=, file_name=0x15f7320 "/export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc", line=861) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/sync/sync0rw.cc:425 #5 0x00000000010ddd9d in rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:433 #6 pfs_rw_lock_s_lock_func (line=861, lock=0x2637218, pass=, file_name=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/sync0rw.ic:796 #7 row_purge_parse_undo_rec (thr=0x26737e8, updated_extern=0x7fc914df9d7f, undo_rec=0x7fc91000f2c8 "7\037\016\200\320\001", node=0x26739a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:861 #8 row_purge (thr=0x26737e8, undo_rec=0x7fc91000f2c8 "7\037\016\200\320\001", node=0x26739a8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1028 #9 row_purge_step (thr=0x26737e8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0purge.cc:1110 #10 0x0000000001091f2f in que_thr_step (thr=0x26737e8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1056 #11 que_run_threads_low (thr=0x26737e8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1118 #12 que_run_threads (thr=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/que/que0que.cc:1158 #13 0x000000000110f8d8 in srv_task_execute () at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2458 #14 srv_worker_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0srv.cc:2508 #15 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #16 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 9 (Thread 0x7fc929999740 (LWP 21748)): #0 0x00007fc92824e00d in poll () from /lib64/libc.so.6 #1 0x0000000000dc98d9 in Mysqld_socket_listener::listen_for_connection_event (this=0x25feb90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/socket_connection.cc:845 #2 0x0000000000798ada in connection_event_loop (this=0x20d55c0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/connection_acceptor.h:66 #3 mysqld_main (argc=99, argv=0x1f87a78) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/mysqld.cc:5043 #4 0x00007fc928183af5 in __libc_start_main () from /lib64/libc.so.6 #5 0x000000000078e649 in _start () Thread 8 (Thread 0x7fc91da1f700 (LWP 21773)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107159e in os_event::timed_wait (this=, abstime=0x7fc91da1e9e0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:285 #2 0x00000000010718be in os_event::wait_time_low (this=0x2100768, time_in_usec=, reset_sig_count=2) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:412 #3 0x00000000011b9e33 in pc_sleep_if_needed (sig_count=2, next_loop_time=1517557705173) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/buf/buf0flu.cc:2690 #4 buf_flush_page_cleaner_coordinator (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/buf/buf0flu.cc:3191 #5 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #6 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 7 (Thread 0x7fc908dfa700 (LWP 21797)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000e984d5 in native_cond_wait (mutex=, cond=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/include/thr_cond.h:140 #2 my_cond_wait (mp=, cond=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/include/thr_cond.h:195 #3 inline_mysql_cond_wait (src_line=852, src_file=0x15c1d60 "/export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_gtid_persist.cc", mutex=, that=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/include/mysql/psi/mysql_thread.h:1184 #4 compress_gtid_table (p_thd=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_gtid_persist.cc:852 #5 0x0000000000f7df44 in pfs_spawn_thread (arg=0x29d0ff0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #6 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #7 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 6 (Thread 0x7fc921806700 (LWP 21805)): #0 0x00007fc92824e00d in poll () from /lib64/libc.so.6 #1 0x00000000012a64ff in vio_io_wait (vio=, event=, timeout=28800000) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:786 #2 0x00000000012a65f3 in vio_socket_io_wait (vio=, event=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:77 #3 0x00000000012a6c28 in vio_read (vio=0x7fc8ec0008e0, buf=0x7fc8ec00a090 "\001", size=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:132 #4 0x0000000000c4de13 in net_read_raw_loop (net=0x7fc8ec002280, count=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:672 #5 0x0000000000c4e6ab in net_read_packet_header (net=0x7fc8ec002280) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:756 #6 net_read_packet (net=, complen=0x7fc921805d38) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:822 #7 0x0000000000c4e95c in my_net_read (net=0x7fc8ec002280) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:899 #8 0x0000000000c5c14c in Protocol_classic::read_packet (this=0x7fc8ec001b30) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/protocol_classic.cc:808 #9 0x0000000000c5af52 in Protocol_classic::get_command (this=0x7fc8ec001b30, com_data=0x7fc921805de0, cmd=0x7fc921805e0c) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/protocol_classic.cc:965 #10 0x0000000000cfb3c7 in do_command (thd=0x7fc8ec000ae0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:938 #11 0x0000000000dc858c in handle_connection (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/connection_handler_per_thread.cc:300 #12 0x0000000000f7df44 in pfs_spawn_thread (arg=0x29d0ff0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #13 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 5 (Thread 0x7fc9097fb700 (LWP 21793)): #0 0x00007fc929590705 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x000000000107148b in wait (this=0x21007f8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:165 #2 os_event::wait_low (this=0x21007f8, reset_sig_count=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0event.cc:335 #3 0x00000000011a727c in buf_resize_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/buf/buf0buf.cc:3015 #4 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #5 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 4 (Thread 0x7fc920c24700 (LWP 21768)): #0 0x00007fc929383644 in __io_getevents_0_4 () from /lib64/libaio.so.1 #1 0x0000000001068944 in LinuxAIOHandler::collect (this=0x7fc920c23df0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2492 #2 0x000000000106ab84 in LinuxAIOHandler::poll (this=0x7fc920c23df0, m1=0x7fc920c23ec8, m2=0x7fc920c23ec0, request=0x7fc920c23e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2638 #3 0x000000000106cf97 in os_aio_linux_handler (request=0x7fc920c23e90, m2=0x7fc920c23ec0, m1=0x7fc920c23ec8, global_segment=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:2694 #4 os_aio_handler (segment=1, m1=0x7fc920c23ec8, m2=0x7fc920c23ec0, request=0x7fc920c23e90) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/os/os0file.cc:6246 #5 0x0000000001204678 in fil_aio_wait (segment=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/fil/fil0fil.cc:5817 #6 0x00000000011115c0 in io_handler_thread (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/srv/srv0start.cc:308 #7 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #8 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 3 (Thread 0x7fc921743700 (LWP 21813)): #0 0x00007fc929590ab2 in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x0000000000ef7096 in native_cond_timedwait (abstime=0x7fc921741050, mutex=0x29b16f8, cond=0x29b17b8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/include/thr_cond.h:129 #2 my_cond_timedwait (abstime=0x7fc921741050, mp=0x29b16f8, cond=0x29b17b8) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/include/thr_cond.h:182 #3 inline_mysql_cond_timedwait (src_line=871, abstime=0x7fc921741050, mutex=0x29b16f8, that=0x29b17b8, src_file=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/include/mysql/psi/mysql_thread.h:1229 #4 Relay_log_info::wait_for_pos (this=0x29b1230, thd=0x7fc8e8000ae0, log_name=, log_pos=12400, timeout=300) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_rli.cc:871 #5 0x000000000085fba9 in Item_master_pos_wait::val_int (this=0x7fc8e8006598) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/item_func.cc:4892 #6 0x00000000007f3c34 in Item::send (this=0x7fc8e8006598, protocol=0x7fc8e8001b30, buffer=0x7fc9217414a0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/item.cc:7550 #7 0x0000000000cb1bd3 in THD::send_result_set_row (this=0x7fc8e8000ae0, row_items=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_class.cc:4661 #8 0x0000000000cb1cbb in Query_result_send::send_data (this=0x7fc8e8006880, items=...) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_class.cc:2716 #9 0x0000000000cc90e9 in JOIN::exec (this=0x7fc8e8006a38) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_executor.cc:156 #10 0x0000000000d32b20 in handle_query (thd=0x7fc8e8000ae0, lex=0x7fc8e8002c28, result=0x7fc8e8006880, added_options=1, removed_options=0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_select.cc:184 #11 0x0000000000cf3dd3 in execute_sqlcom_select (thd=0x7fc8e8000ae0, all_tables=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:5195 #12 0x0000000000cf7611 in mysql_execute_command (thd=0x7fc8e8000ae0, first_level=true) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:2794 #13 0x0000000000cf9415 in mysql_parse (thd=0x7fc8e8000ae0, parser_state=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:5611 #14 0x0000000000cfa628 in dispatch_command (thd=0x7fc8e8000ae0, com_data=0x7fc921742de0, command=COM_QUERY) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:1461 #15 0x0000000000cfb4c4 in do_command (thd=0x7fc8e8000ae0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:999 #16 0x0000000000dc858c in handle_connection (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/connection_handler_per_thread.cc:300 #17 0x0000000000f7df44 in pfs_spawn_thread (arg=0x29d0ff0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #18 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 2 (Thread 0x7fc921702700 (LWP 21814)): #0 0x00007fc92824e00d in poll () from /lib64/libc.so.6 #1 0x00000000012a64ff in vio_io_wait (vio=, event=, timeout=28800000) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:786 #2 0x00000000012a65f3 in vio_socket_io_wait (vio=, event=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:77 #3 0x00000000012a6c28 in vio_read (vio=0x7fc8dc0008e0, buf=0x7fc8dc00a090 "\001", size=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/vio/viosocket.c:132 #4 0x0000000000c4de13 in net_read_raw_loop (net=0x7fc8dc002280, count=4) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:672 #5 0x0000000000c4e6ab in net_read_packet_header (net=0x7fc8dc002280) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:756 #6 net_read_packet (net=, complen=0x7fc921701d38) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:822 #7 0x0000000000c4e95c in my_net_read (net=0x7fc8dc002280) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/net_serv.cc:899 #8 0x0000000000c5c14c in Protocol_classic::read_packet (this=0x7fc8dc001b30) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/protocol_classic.cc:808 #9 0x0000000000c5af52 in Protocol_classic::get_command (this=0x7fc8dc001b30, com_data=0x7fc921701de0, cmd=0x7fc921701e0c) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/protocol_classic.cc:965 #10 0x0000000000cfb3c7 in do_command (thd=0x7fc8dc000ae0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:938 #11 0x0000000000dc858c in handle_connection (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/conn_handler/connection_handler_per_thread.cc:300 #12 0x0000000000f7df44 in pfs_spawn_thread (arg=0x29d0ff0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #13 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #14 0x00007fc92825860d in clone () from /lib64/libc.so.6 Thread 1 (Thread 0x7fc921784700 (LWP 21809)): #0 0x00007fc929591771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000079e2b4 in handle_fatal_signal (sig=11) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/signal_handler.cc:220 #2 #3 buf_pool_from_bpage (bpage=0x9d) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/buf0buf.ic:97 #4 buf_block_free (block=0x9d) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/buf0buf.ic:799 #5 0x000000000105cb11 in mem_heap_free_block_free (heap=0x7fc8e40b7118) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/mem/mem0mem.cc:475 #6 0x00000000010c3860 in mem_heap_free (heap=0x7fc8e40b7118) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/include/mem0mem.ic:529 #7 row_mysql_prebuilt_free_blob_heap (prebuilt=0x7fc8e40b3168) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0mysql.cc:176 #8 0x00000000010c3af9 in row_prebuilt_free (prebuilt=0x7fc8e40b3168, dict_locked=1) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/row/row0mysql.cc:1034 #9 0x000000000101d49e in ha_innobase::commit_inplace_alter_table (this=0x7fc8e400e830, altered_table=0x7fc8e40a98c0, ha_alter_info=0x7fc921781050, commit=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/handler/handler0alter.cc:8726 #10 0x000000000101f227 in ha_innopart::commit_inplace_alter_table (this=0x7fc8e400e830, altered_table=0x7fc8e40a98c0, ha_alter_info=0x7fc921781050, commit=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/innobase/handler/handler0alter.cc:9120 #11 0x0000000000d5f575 in mysql_inplace_alter_table (thd=0x7fc8e40008c0, table_list=0x7fc8e4006890, table=0x7fc8e4019970, altered_table=0x7fc8e40a98c0, ha_alter_info=0x7fc921781050, inplace_supported=, target_mdl_request=0x7fc921781810, alter_ctx=0x7fc92177fab0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_table.cc:7545 #12 0x0000000000d631bd in mysql_alter_table (thd=0x7fc8e40008c0, new_db=0x7fc8e40a98c0 "(\242\n\344\310\177", new_name=0x7fc921781050 "0\"x!\311\177", create_info=0x7fc921781050, table_list=0x7fc8e4006890, alter_info=0x7fc921782330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_table.cc:9686 #13 0x0000000000e65373 in Sql_cmd_alter_table::execute (this=, thd=0x7fc8e40008c0) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_alter.cc:316 #14 0x0000000000cf4e58 in mysql_execute_command (thd=0x7fc8e40008c0, first_level=true) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:4893 #15 0x0000000000cf9415 in mysql_parse (thd=0x7fc8e40008c0, parser_state=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/sql_parse.cc:5611 #16 0x0000000000eaf003 in Query_log_event::do_apply_event (this=0x7fc8e40a0a50, rli=0x29b1230, query_arg=0x7fc8e40227a9 "ALTER TABLE `test_partition`\nMODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST ,\nMODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`,\nADD PRIMARY KEY"..., q_len_arg=140500795401504) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/log_event.cc:4595 #17 0x0000000000eac978 in Log_event::apply_event (this=0x7fc8e40a0a50, rli=0x29b1230) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/log_event.cc:3242 #18 0x0000000000ee7046 in apply_event_and_update_pos (ptr_ev=0x7fc921783718, thd=0x7fc8e40008c0, rli=0x29b1230) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:4702 #19 0x0000000000ef08f9 in exec_relay_log_event (thd=0x7fc8e40008c0, rli=0x29b1230) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:5212 #20 0x0000000000ef27f1 in handle_slave_sql (arg=) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/sql/rpl_slave.cc:7320 #21 0x0000000000f7df44 in pfs_spawn_thread (arg=0x7fc8f8163330) at /export/home/pb2/build/sb_0-21378219-1480347226.17/mysql-5.7.17/storage/perfschema/pfs.cc:2188 #22 0x00007fc92958cdf5 in start_thread () from /lib64/libpthread.so.0 #23 0x00007fc92825860d in clone () from /lib64/libc.so.6 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 14 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug89506 The log files in var/log may give you some hint of what went wrong. If you want to report this error, please read first the documentation at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html mysql-test-run: *** ERROR: there were failing test cases -- 5.7.18, 5.7.21 not affected [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test: ./mtr rpl_bug89506 Logging: ./mtr rpl_bug89506 MySQL Version 5.7.18 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] set sql_mode=''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. use test; CREATE TABLE `test_partition` ( `currenttime` datetime NOT NULL, `ddid` varchar(200) NOT NULL, `publishtime` varchar(128) DEFAULT NULL, `link` text, `type` text, `title` text, `taskname` text, `isupdate` int(2) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (TO_DAYS(currenttime)) (PARTITION p2016 VALUES LESS THAN (736695) ENGINE = InnoDB, PARTITION p2017 VALUES LESS THAN (737060) ENGINE = InnoDB, PARTITION p201801 VALUES LESS THAN (737091) ENGINE = InnoDB, PARTITION p201802 VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION p201803 VALUES LESS THAN (737150) ENGINE = InnoDB, PARTITION p201804 VALUES LESS THAN (737180) ENGINE = InnoDB, PARTITION p201805 VALUES LESS THAN (737211) ENGINE = InnoDB, PARTITION p201806 VALUES LESS THAN (737241) ENGINE = InnoDB, PARTITION p201807 VALUES LESS THAN (737272) ENGINE = InnoDB, PARTITION p201808 VALUES LESS THAN (737303) ENGINE = InnoDB, PARTITION p201809 VALUES LESS THAN (737333) ENGINE = InnoDB, PARTITION p201810 VALUES LESS THAN (737364) ENGINE = InnoDB, PARTITION p201811 VALUES LESS THAN (737394) ENGINE = InnoDB, PARTITION p201812 VALUES LESS THAN (737425) ENGINE = InnoDB, PARTITION p201901 VALUES LESS THAN (737456) ENGINE = InnoDB, PARTITION p201902 VALUES LESS THAN (737484) ENGINE = InnoDB, PARTITION p201903 VALUES LESS THAN (737515) ENGINE = InnoDB, PARTITION p201904 VALUES LESS THAN (737545) ENGINE = InnoDB, PARTITION p201905 VALUES LESS THAN (737576) ENGINE = InnoDB, PARTITION p201906 VALUES LESS THAN (737606) ENGINE = InnoDB, PARTITION p201907 VALUES LESS THAN (737637) ENGINE = InnoDB, PARTITION p201908 VALUES LESS THAN (737668) ENGINE = InnoDB, PARTITION p201909 VALUES LESS THAN (737698) ENGINE = InnoDB, PARTITION p201910 VALUES LESS THAN (737729) ENGINE = InnoDB, PARTITION p201911 VALUES LESS THAN (737759) ENGINE = InnoDB, PARTITION p201912 VALUES LESS THAN (737790) ENGINE = InnoDB, PARTITION p2020 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; insert into test_partition select '2017-01-01' ,uuid(),'20170101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-08-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-09-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-10-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-11-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-12-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; ALTER TABLE `test_partition` MODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST , MODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`, ADD PRIMARY KEY (`currenttime`, `ddid`), ADD UNIQUE INDEX `currenttime` (`currenttime`) USING BTREE; use test; desc test_partition; Field Type Null Key Default Extra ddid varchar(255) NO PRI NULL currenttime datetime NO PRI NULL publishtime varchar(128) YES NULL link text YES NULL type text YES NULL title text YES NULL taskname text YES NULL isupdate int(2) NO 0 main.rpl_bug89506 [ pass ] 1673 MTR's internal check of the test case 'main.rpl_bug89506' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test/var/tmp/check-mysqld_2.log'. mysqltest: Results saved in '/export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test/var/tmp/check-mysqld_2.result'. mysqltest: Connecting to server localhost:13001 (socket /export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test/var/tmp/mysqld.2.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test/var/tmp/check-mysqld_2.result 2018-02-02 10:49:46.124484156 +0300 +++ /export/umesh/server/binaries/GABuilds/mysql-5.7.18/mysql-test/var/tmp/check-mysqld_2.reject 2018-02-02 10:49:48.084528537 +0300 @@ -1,4 +1,4 @@ -Slave_IO_State +Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port # @@ -8,8 +8,8 @@ Relay_Log_File # Relay_Log_Pos # Relay_Master_Log_File # -Slave_IO_Running No -Slave_SQL_Running No +Slave_IO_Running Yes +Slave_SQL_Running Yes Replicate_Do_DB # Replicate_Ignore_DB # Replicate_Do_Table # @@ -30,7 +30,7 @@ Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key -Seconds_Behind_Master NULL +Seconds_Behind_Master 0 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error @@ -42,7 +42,7 @@ Master_Info_File # SQL_Delay 0 SQL_Remaining_Delay NULL -Slave_SQL_Running_State +Slave_SQL_Running_State Slave has read all relay log; waiting for more updates Master_Retry_Count # Master_Bind Last_IO_Error_Timestamp @@ -593,6 +593,7 @@ def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +test_partition tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok safe_process[22242]: Child process: 22244, exit: 1 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 1.673 of 15 seconds executing testcases Check of testcase failed for: main.rpl_bug89506 Completed: All 1 tests were successful. -- [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test: [umshastr@hod03]/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test: ./mtr rpl_bug89506 Logging: ./mtr rpl_bug89506 MySQL Version 5.7.21 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc Warnings: Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. Note #### Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. [connection master] set sql_mode=''; Warnings: Warning 3090 Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release. use test; CREATE TABLE `test_partition` ( `currenttime` datetime NOT NULL, `ddid` varchar(200) NOT NULL, `publishtime` varchar(128) DEFAULT NULL, `link` text, `type` text, `title` text, `taskname` text, `isupdate` int(2) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 /*!50100 PARTITION BY RANGE (TO_DAYS(currenttime)) (PARTITION p2016 VALUES LESS THAN (736695) ENGINE = InnoDB, PARTITION p2017 VALUES LESS THAN (737060) ENGINE = InnoDB, PARTITION p201801 VALUES LESS THAN (737091) ENGINE = InnoDB, PARTITION p201802 VALUES LESS THAN (737119) ENGINE = InnoDB, PARTITION p201803 VALUES LESS THAN (737150) ENGINE = InnoDB, PARTITION p201804 VALUES LESS THAN (737180) ENGINE = InnoDB, PARTITION p201805 VALUES LESS THAN (737211) ENGINE = InnoDB, PARTITION p201806 VALUES LESS THAN (737241) ENGINE = InnoDB, PARTITION p201807 VALUES LESS THAN (737272) ENGINE = InnoDB, PARTITION p201808 VALUES LESS THAN (737303) ENGINE = InnoDB, PARTITION p201809 VALUES LESS THAN (737333) ENGINE = InnoDB, PARTITION p201810 VALUES LESS THAN (737364) ENGINE = InnoDB, PARTITION p201811 VALUES LESS THAN (737394) ENGINE = InnoDB, PARTITION p201812 VALUES LESS THAN (737425) ENGINE = InnoDB, PARTITION p201901 VALUES LESS THAN (737456) ENGINE = InnoDB, PARTITION p201902 VALUES LESS THAN (737484) ENGINE = InnoDB, PARTITION p201903 VALUES LESS THAN (737515) ENGINE = InnoDB, PARTITION p201904 VALUES LESS THAN (737545) ENGINE = InnoDB, PARTITION p201905 VALUES LESS THAN (737576) ENGINE = InnoDB, PARTITION p201906 VALUES LESS THAN (737606) ENGINE = InnoDB, PARTITION p201907 VALUES LESS THAN (737637) ENGINE = InnoDB, PARTITION p201908 VALUES LESS THAN (737668) ENGINE = InnoDB, PARTITION p201909 VALUES LESS THAN (737698) ENGINE = InnoDB, PARTITION p201910 VALUES LESS THAN (737729) ENGINE = InnoDB, PARTITION p201911 VALUES LESS THAN (737759) ENGINE = InnoDB, PARTITION p201912 VALUES LESS THAN (737790) ENGINE = InnoDB, PARTITION p2020 VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */; insert into test_partition select '2017-01-01' ,uuid(),'20170101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-08-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-09-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-10-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-11-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2018-12-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-01-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-02-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-03-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-04-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-05-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-06-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; insert into test_partition select '2019-07-01' ,uuid(),'20180101',uuid(),uuid(),uuid(),uuid(),'0'; ALTER TABLE `test_partition` MODIFY COLUMN `ddid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL FIRST , MODIFY COLUMN `currenttime` datetime NOT NULL AFTER `ddid`, ADD PRIMARY KEY (`currenttime`, `ddid`), ADD UNIQUE INDEX `currenttime` (`currenttime`) USING BTREE; use test; desc test_partition; Field Type Null Key Default Extra ddid varchar(255) NO PRI NULL currenttime datetime NO PRI NULL publishtime varchar(128) YES NULL link text YES NULL type text YES NULL title text YES NULL taskname text YES NULL isupdate int(2) NO 0 main.rpl_bug89506 [ pass ] 2174 MTR's internal check of the test case 'main.rpl_bug89506' failed. This means that the test case does not preserve the state that existed before the test case was executed. Most likely the test case did not do a proper clean-up. It could also be caused by the previous test run by this thread, if the server wasn't restarted. This is the diff of the states of the servers before and after the test case was executed: mysqltest: Logging to '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var/tmp/check-mysqld_1.log'. mysqltest: Results saved in '/export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var/tmp/check-mysqld_1.result'. mysqltest: Connecting to server localhost:13000 (socket /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var/tmp/mysqld.1.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: ... Done processing test commands. --- /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var/tmp/check-mysqld_1.result 2018-02-02 10:52:03.877604724 +0300 +++ /export/umesh/server/binaries/GABuilds/mysql-advanced-5.7.21/mysql-test/var/tmp/check-mysqld_1.reject 2018-02-02 10:52:06.340660543 +0300 @@ -600,6 +600,7 @@ def sys utf8 utf8_general_ci NULL def test latin1 latin1_swedish_ci NULL tables_in_test +test_partition tables_in_mysql mysql.columns_priv mysql.db mysqltest: Result content mismatch not ok safe_process[22506]: Child process: 22508, exit: 1 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 2.174 of 16 seconds executing testcases Check of testcase failed for: main.rpl_bug89506 Completed: All 1 tests were successful.