// 5.6.26 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.26/mysql-test: ./mtr rpl_issue56487 Logging: ./mtr rpl_issue56487 2015-08-25 08:44:17 0 [Note] /export/umesh/server/binaries/mysql-advanced-5.6.26/bin/mysqld (mysqld 5.6.26-enterprise-commercial-advanced) starting as process 1006 ... 2015-08-25 08:44:17 1006 [Note] Plugin 'FEDERATED' is disabled. 2015-08-25 08:44:17 1006 [Note] Binlog end 2015-08-25 08:44:17 1006 [Note] Shutting down plugin 'MyISAM' 2015-08-25 08:44:17 1006 [Note] Shutting down plugin 'CSV' MySQL Version 5.6.26 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-advanced-5.6.26/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 `db1`; USE `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB; 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB; DROP TABLE IF EXISTS `db1`.`table1`; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails use test; create table t1(f1 int); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); select count(*) from t1; count(*) 6 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 3037 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1099 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 0 Last_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 887 Relay_Log_Space 3453 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 0 Last_SQL_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID b64099cc-4af4-11e5-b64c-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-advanced-5.6.26/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 150825 09:44:20 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set b64099cc-4af4-11e5-b64c-0010e05f3e06:1-11 Executed_Gtid_Set b64099cc-4af4-11e5-b64c-0010e05f3e06:1-4 Auto_Position 1 stop slave; set gtid_next='b64099cc-4af4-11e5-b64c-0010e05f3e06:5'; begin; commit; set gtid_next='automatic'; start slave; 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 3037 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1099 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 0 Last_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 887 Relay_Log_Space 4262 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 0 Last_SQL_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID b64099cc-4af4-11e5-b64c-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-advanced-5.6.26/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 150825 09:44:22 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set b64099cc-4af4-11e5-b64c-0010e05f3e06:1-11 Executed_Gtid_Set b64099cc-4af4-11e5-b64c-0010e05f3e06:1-5 Auto_Position 1 main.rpl_issue56487 [ fail ] Found warnings/errors in server log file! Test ended at 2015-08-25 08:44:24 line 2015-08-25 09:44:20 1052 [ERROR] Slave SQL: Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */', Error_code: 0 2015-08-25 09:44:22 1052 [ERROR] Slave SQL: Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217 ; Error on slave: actual message='no error', error code=0. Default database: 'db1'. Query: 'DROP TABLE IF EXISTS `table1` /* generated by server */', Error_code: 0 ^ Found warnings in /export/umesh/server/binaries/mysql-advanced-5.6.26/mysql-test/var/log/mysqld.2.err ok - saving '/export/umesh/server/binaries/mysql-advanced-5.6.26/mysql-test/var/log/main.rpl_issue56487/' to '/export/umesh/server/binaries/mysql-advanced-5.6.26/mysql-test/var/log/main.rpl_issue56487/' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 8 seconds executing testcases mysql-test-run: WARNING: Got errors/warnings while running tests, please examine '/export/umesh/server/binaries/mysql-advanced-5.6.26/mysql-test/var/log/warnings' for details. Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_issue56487 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.8 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8-rc/mysql-test: ./mtr rpl_issue56487 Logging: ./mtr rpl_issue56487 MySQL Version 5.7.8 Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.7.8-rc/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 `db1`; USE `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB; 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB; DROP TABLE IF EXISTS `db1`.`table1`; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails use test; create table t1(f1 int); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); insert into t1 values(1); select count(*) from t1; count(*) 6 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 2813 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1156 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 3002 Last_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217; Error on slave:actual message='no error', error code=0. Default database:'db1'. Query:'DROP TABLE IF EXISTS `table1` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 941 Relay_Log_Space 3235 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 3002 Last_SQL_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217; Error on slave:actual message='no error', error code=0. Default database:'db1'. Query:'DROP TABLE IF EXISTS `table1` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID e971b62f-4b04-11e5-8afa-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8-rc/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 150825 11:40:17 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set e971b62f-4b04-11e5-8afa-0010e05f3e06:1-11 Executed_Gtid_Set e971b62f-4b04-11e5-8afa-0010e05f3e06:1-4 Auto_Position 1 Replicate_Rewrite_DB Channel_Name stop slave; set gtid_next='e971b62f-4b04-11e5-8afa-0010e05f3e06:5'; begin; commit; set gtid_next='automatic'; start slave; 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 2813 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 1156 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 3002 Last_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217; Error on slave:actual message='no error', error code=0. Default database:'db1'. Query:'DROP TABLE IF EXISTS `table1` /* generated by server */' Skip_Counter 0 Exec_Master_Log_Pos 941 Relay_Log_Space 3745 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 3002 Last_SQL_Error Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217; Error on slave:actual message='no error', error code=0. Default database:'db1'. Query:'DROP TABLE IF EXISTS `table1` /* generated by server */' Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID e971b62f-4b04-11e5-8afa-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8-rc/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 150825 11:40:19 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set e971b62f-4b04-11e5-8afa-0010e05f3e06:1-11 Executed_Gtid_Set e971b62f-4b04-11e5-8afa-0010e05f3e06:1-5 Auto_Position 1 Replicate_Rewrite_DB Channel_Name main.rpl_issue56487 [ fail ] Found warnings/errors in server log file! Test ended at 2015-08-25 10:40:21 line 2015-08-25T08:40:17.570231Z 6 [ERROR] Slave SQL for channel '': Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217; Error on slave:actual message='no error', error code=0. Default database:'db1'. Query:'DROP TABLE IF EXISTS `table1` /* generated by server */', Error_code: 3002 2015-08-25T08:40:19.598055Z 10 [ERROR] Slave SQL for channel '': Query caused different errors on master and slave. Error on master: message (format)='Cannot delete or update a parent row: a foreign key constraint fails' error code=1217; Error on slave:actual message='no error', error code=0. Default database:'db1'. Query:'DROP TABLE IF EXISTS `table1` /* generated by server */', Error_code: 3002 ^ Found warnings in /export/umesh/server/binaries/mysql-5.7.8-rc/mysql-test/var/log/mysqld.2.err ok - the logfile can be found in '/export/umesh/server/binaries/mysql-5.7.8-rc/mysql-test/var/log/main.rpl_issue56487/rpl_issue56487.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 8 seconds executing testcases mysql-test-run: WARNING: Got errors/warnings while running tests, please examine '/export/umesh/server/binaries/mysql-5.7.8-rc/mysql-test/var/log/warnings' for details. Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_issue56487 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-5.7.8-rc/mysql-test: