// 5.5.48 [umshastr@hod03]/export/umesh/server/binaries: cd mysql-5.5.48 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.48: cd mysql-test/ [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.48/mysql-test: vi t/rpl_bug79610.test [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.48/mysql-test: vi t/rpl_bug79610-slave.opt [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.48/mysql-test: ./mtr rpl_bug79610.test [umshastr@hod03]/export/umesh/server/binaries/mysql-5.5.48/mysql-test: ./mtr rpl_bug79610.test Logging: ./mtr rpl_bug79610.test 151213 14:34:15 [Note] /export/umesh/server/binaries/mysql-5.5.48/bin/mysqld (mysqld 5.5.48) starting as process 19969 ... 151213 14:34:15 [Note] Plugin 'FEDERATED' is disabled. MySQL Version 5.5.48 Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.5.48/mysql-test/var'... Installing system database... ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 include/master-slave.inc [connection master] CREATE DATABASE `db2`; USE `db2`; create table a1(f1 int); create table a2(f1 int); CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB; create database db1; use db1; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table1` (`ID`) ON DELETE no action ) ENGINE=InnoDB; show databases; Database information_schema db2 mtr mysql performance_schema test use db2; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table0` (`ID`) ON DELETE no action ) ENGINE=InnoDB; DROP DATABASE db2; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails main.rpl_bug79610 [ fail ] Test ended at 2015-12-13 14:34:19 CURRENT_TEST: main.rpl_bug79610 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 1101 Binlog_Do_DB Binlog_Ignore_DB ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1156 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1202 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB db1 Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table db1.% Last_Errno 1217 Last_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Skip_Counter 0 Exec_Master_Log_Pos 1055 Relay_Log_Space 1459 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1217 Last_SQL_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Replicate_Ignore_Server_Ids Master_Server_Id 1 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:44742 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:44743 db test Command Sleep Time 0 State Info ---- 3. ---- Id 4 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 6 User root Host localhost:44749 db db2 Command Query Time 0 State Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:44750 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 27: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 1156, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-5.5.48/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID; NOW() @@SERVER_ID 2015-12-13 16:34:19 1 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 1156 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:44789 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 8 root localhost NULL Query 0 NULL SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 1156 **** SHOW BINLOG EVENTS on default **** binlog_name = 'master-bin.000001' SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 107 Server ver: 5.5.48-log, Binlog ver: 4 master-bin.000001 107 Query 1 190 CREATE DATABASE `db2` master-bin.000001 190 Query 1 275 use `db2`; create table a1(f1 int) master-bin.000001 275 Query 1 360 use `db2`; create table a2(f1 int) master-bin.000001 360 Query 1 487 use `db2`; CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 487 Query 1 614 use `db2`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 614 Query 1 695 create database db1 master-bin.000001 695 Query 1 1055 use `db1`; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table1` (`ID`) ON DELETE no action ) ENGINE=InnoDB master-bin.000001 1055 Query 1 1156 use `db2`; DROP TABLE IF EXISTS `a1`,`a2`,`table0` **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info == /export/umesh/server/binaries/mysql-5.5.48/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID; NOW() @@SERVER_ID 2015-12-13 16:34:19 2 **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1156 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1202 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB db1 Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table db1.% Last_Errno 1217 Last_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Skip_Counter 0 Exec_Master_Log_Pos 1055 Relay_Log_Space 1459 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master NULL Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1217 Last_SQL_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Replicate_Ignore_Server_Ids Master_Server_Id 1 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 1101 Binlog_Do_DB Binlog_Ignore_DB **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 4 system user NULL Connect 0 Waiting for master to send event NULL 8 root localhost NULL Query 0 NULL SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 1101 **** SHOW BINLOG EVENTS on default **** binlog_name = 'slave-bin.000001' SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 107 Server ver: 5.5.48-log, Binlog ver: 4 slave-bin.000001 107 Query 1 190 CREATE DATABASE `db2` slave-bin.000001 190 Query 1 275 use `db2`; create table a1(f1 int) slave-bin.000001 275 Query 1 360 use `db2`; create table a2(f1 int) slave-bin.000001 360 Query 1 487 use `db2`; CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-bin.000001 487 Query 1 614 use `db2`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-bin.000001 614 Query 2 974 use `db2`; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table0` (`ID`) ON DELETE no action ) ENGINE=InnoDB slave-bin.000001 974 Query 1 1101 use `db2`; DROP TABLE IF EXISTS `a1`,`a2`,`table0` /* generated by server */ **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'slave-relay-bin.000002' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000002 4 Format_desc 2 107 Server ver: 5.5.48-log, Binlog ver: 4 slave-relay-bin.000002 107 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 151 Format_desc 1 107 Server ver: 5.5.48-log, Binlog ver: 4 slave-relay-bin.000002 254 Query 1 190 CREATE DATABASE `db2` slave-relay-bin.000002 337 Query 1 275 use `db2`; create table a1(f1 int) slave-relay-bin.000002 422 Query 1 360 use `db2`; create table a2(f1 int) slave-relay-bin.000002 507 Query 1 487 use `db2`; CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-relay-bin.000002 634 Query 1 614 use `db2`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-relay-bin.000002 761 Query 1 695 create database db1 slave-relay-bin.000002 842 Query 1 1055 use `db1`; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table1` (`ID`) ON DELETE no action ) ENGINE=InnoDB slave-relay-bin.000002 1202 Query 1 1156 use `db2`; DROP TABLE IF EXISTS `a1`,`a2`,`table0` - saving '/export/umesh/server/binaries/mysql-5.5.48/mysql-test/var/log/main.rpl_bug79610/' to '/export/umesh/server/binaries/mysql-5.5.48/mysql-test/var/log/main.rpl_bug79610/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 4 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug79610 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.6.28 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test: ./mtr rpl_bug79610.test Logging: ./mtr rpl_bug79610.test 2015-12-13 14:41:03 0 [Note] /export/umesh/server/binaries/mysql-advanced-5.6.28/bin/mysqld (mysqld 5.6.28-enterprise-commercial-advanced) starting as process 20440 ... 2015-12-13 14:41:03 20440 [Note] Plugin 'FEDERATED' is disabled. 2015-12-13 14:41:03 20440 [Note] Binlog end 2015-12-13 14:41:03 20440 [Note] Shutting down plugin 'CSV' 2015-12-13 14:41:03 20440 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.28 Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var'... Installing system database... ============================================================================== 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] CREATE DATABASE `db2`; USE `db2`; create table a1(f1 int); create table a2(f1 int); CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB; create database db1; use db1; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table1` (`ID`) ON DELETE no action ) ENGINE=InnoDB; show databases; Database information_schema db2 mtr mysql performance_schema test use db2; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table0` (`ID`) ON DELETE no action ) ENGINE=InnoDB; DROP DATABASE db2; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails main.rpl_bug79610 [ fail ] Test ended at 2015-12-13 14:41:06 CURRENT_TEST: main.rpl_bug79610 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 1184 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set ========================== === SHOW SLAVE STATUS === ---- 1. ---- Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1249 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1302 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB db1 Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table db1.% Last_Errno 1217 Last_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Skip_Counter 0 Exec_Master_Log_Pos 1138 Relay_Log_Space 1586 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1217 Last_SQL_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 2886d16d-a19f-11e5-ab6e-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 151213 16:41:06 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:44763 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:44764 db test Command Sleep Time 0 State Info ---- 3. ---- Id 4 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 6 User root Host localhost:44770 db db2 Command Query Time 0 State init Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:44771 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 27: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 1249, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var/tmp/analyze-sync_with_master-mysqld.1.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2015-12-13 16:41:06 @@SERVER_ID 1 @@SERVER_UUID 2886d16d-a19f-11e5-ab6e-0010e05f3e06 @@PORT 13000 **** GTID_* on default **** SELECT @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 1249 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; Server_id 2 Host 127.0.0.1 Port 13001 Master_id 1 Slave_UUID 28bad0d2-a19f-11e5-ab6e-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:44810 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for binlog to be updated NULL 8 root localhost NULL Query 0 init SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 1249 **** SHOW BINLOG EVENTS on default **** binlog_name = 'master-bin.000001' SHOW BINLOG EVENTS IN 'master-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 120 Server ver: 5.6.28-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 120 Query 1 213 CREATE DATABASE `db2` master-bin.000001 213 Query 1 308 use `db2`; create table a1(f1 int) master-bin.000001 308 Query 1 403 use `db2`; create table a2(f1 int) master-bin.000001 403 Query 1 540 use `db2`; CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 540 Query 1 677 use `db2`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 677 Query 1 768 create database db1 master-bin.000001 768 Query 1 1138 use `db1`; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table1` (`ID`) ON DELETE no action ) ENGINE=InnoDB master-bin.000001 1138 Query 1 1249 use `db2`; DROP TABLE IF EXISTS `a1`,`a2`,`table0` **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'No such row' SHOW RELAYLOG EVENTS IN 'No such row'; Log_name Pos Event_type Server_id End_log_pos Info **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position rand_seed: '' _rand_state: '' extra debug info if any: '' connection default; == /export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var/tmp/analyze-sync_with_master-mysqld.2.err == DO_NOT_CHECK_IN_THIS_LINE: include/show_rpl_debug_info.inc should only be used for debugging. Never check in a test that calls it on success. CURRENT_CONNECTION = 'default' ############################## default ############################## **** SHOW WARNINGS on default **** SHOW WARNINGS; Level Code Message **** SELECT replication-related variables on default **** SELECT NOW(), @@SERVER_ID, @@SERVER_UUID, @@PORT; NOW() 2015-12-13 16:41:06 @@SERVER_ID 2 @@SERVER_UUID 28bad0d2-a19f-11e5-ab6e-0010e05f3e06 @@PORT 13001 **** GTID_* on default **** SELECT @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; Slave_IO_State Waiting for master to send event Master_Host 127.0.0.1 Master_User root Master_Port 13000 Connect_Retry 1 Master_Log_File master-bin.000001 Read_Master_Log_Pos 1249 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1302 Relay_Master_Log_File master-bin.000001 Slave_IO_Running Yes Slave_SQL_Running No Replicate_Do_DB Replicate_Ignore_DB db1 Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table db1.% Last_Errno 1217 Last_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Skip_Counter 0 Exec_Master_Log_Pos 1138 Relay_Log_Space 1586 Until_Condition None Until_Log_File Until_Log_Pos 0 Master_SSL_Allowed No Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master NULL Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 1217 Last_SQL_Error Error 'Cannot delete or update a parent row: a foreign key constraint fails' on query. Default database: 'db2'. Query: 'DROP TABLE IF EXISTS `a1`,`a2`,`table0`' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID 2886d16d-a19f-11e5-ab6e-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp 151213 16:41:06 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 1184 Binlog_Do_DB Binlog_Ignore_DB Executed_Gtid_Set **** SHOW SLAVE HOSTS on default **** SHOW SLAVE HOSTS; **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 4 system user NULL Connect 0 Waiting for master to send event NULL 8 root localhost NULL Query 0 init SHOW PROCESSLIST **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 1184 **** SHOW BINLOG EVENTS on default **** binlog_name = 'slave-bin.000001' SHOW BINLOG EVENTS IN 'slave-bin.000001'; Log_name Pos Event_type Server_id End_log_pos Info slave-bin.000001 4 Format_desc 2 120 Server ver: 5.6.28-enterprise-commercial-advanced-log, Binlog ver: 4 slave-bin.000001 120 Query 1 213 CREATE DATABASE `db2` slave-bin.000001 213 Query 1 308 use `db2`; create table a1(f1 int) slave-bin.000001 308 Query 1 403 use `db2`; create table a2(f1 int) slave-bin.000001 403 Query 1 540 use `db2`; CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-bin.000001 540 Query 1 677 use `db2`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-bin.000001 677 Query 2 1047 use `db2`; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table0` (`ID`) ON DELETE no action ) ENGINE=InnoDB slave-bin.000001 1047 Query 1 1184 use `db2`; DROP TABLE IF EXISTS `a1`,`a2`,`table0` /* generated by server */ **** SHOW RELAYLOG EVENTS on default **** relaylog_name = 'slave-relay-bin.000002' SHOW RELAYLOG EVENTS IN 'slave-relay-bin.000002'; Log_name Pos Event_type Server_id End_log_pos Info slave-relay-bin.000002 4 Format_desc 2 120 Server ver: 5.6.28-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 120 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 168 Format_desc 1 120 Server ver: 5.6.28-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 284 Query 1 213 CREATE DATABASE `db2` slave-relay-bin.000002 377 Query 1 308 use `db2`; create table a1(f1 int) slave-relay-bin.000002 472 Query 1 403 use `db2`; create table a2(f1 int) slave-relay-bin.000002 567 Query 1 540 use `db2`; CREATE TABLE `table0` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-relay-bin.000002 704 Query 1 677 use `db2`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-relay-bin.000002 841 Query 1 768 create database db1 slave-relay-bin.000002 932 Query 1 1138 use `db1`; CREATE TABLE `table2` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `DIVISION_ID` bigint(20) DEFAULT NULL, PRIMARY KEY (`ID`), KEY `FK_TABLE1_DIVISION_1` (`DIVISION_ID`), CONSTRAINT `FK_TABLE1_DIVISION_1` FOREIGN KEY (`DIVISION_ID`) REFERENCES `db2`.`table1` (`ID`) ON DELETE no action ) ENGINE=InnoDB slave-relay-bin.000002 1302 Query 1 1249 use `db2`; DROP TABLE IF EXISTS `a1`,`a2`,`table0` **** slave_relay_info on default **** SELECT * FROM mysql.slave_relay_log_info; Number_of_lines Relay_log_name Relay_log_pos Master_log_name Master_log_pos Sql_delay Number_of_workers Id **** slave_master_info on default **** SELECT * FROM mysql.slave_master_info; Number_of_lines Master_log_name Master_log_pos Host User_name User_password Port Connect_retry Enabled_ssl Ssl_ca Ssl_capath Ssl_cert Ssl_cipher Ssl_key Ssl_verify_server_cert Heartbeat Bind Ignored_server_ids Uuid Retry_count Ssl_crl Ssl_crlpath Enabled_auto_position rand_seed: '' _rand_state: '' extra debug info if any: '' connection default; - saving '/export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var/log/main.rpl_bug79610/' to '/export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test/var/log/main.rpl_bug79610/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 3 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug79610 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 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.28/mysql-test: