## rpl_bug77684.test --source include/master-slave.inc --source include/have_binlog_format_row.inc --echo [On Master] --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`; --echo [master - SHOW DATABASES ] SHOW DATABASES; sync_slave_with_master; --echo [On Slave] --connection slave --echo [slave - SHOW DATABASES ] SHOW DATABASES; query_vertical SHOW SLAVE STATUS; --echo Cleanup --die "DONE" ## rpl_bug77684-master.opt --binlog-format=row ## rpl_bug77684-slave.opt --replicate-ignore-db=db1 --replicate-wild-ignore-table=db1.% ################ 5.6.27 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.6.27/mysql-test: ./mtr rpl_bug77684 Logging: ./mtr rpl_bug77684 2015-07-13 15:04:49 0 [Note] /export/umesh/server/binaries/mysql-5.6.27/bin/mysqld (mysqld 5.6.27-enterprise-commercial-advanced) starting as process 2488 ... 2015-07-13 15:04:49 2488 [Note] Plugin 'FEDERATED' is disabled. 2015-07-13 15:04:49 2488 [Note] Binlog end 2015-07-13 15:04:49 2488 [Note] Shutting down plugin 'CSV' 2015-07-13 15:04:49 2488 [Note] Shutting down plugin 'MyISAM' MySQL Version 5.6.27 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.6.27/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] [On 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 SHOW DATABASES; Database information_schema db1 mtr mysql performance_schema test SHOW BINLOG EVENTS; Log_name Pos Event_type Server_id End_log_pos Info master-bin.000001 4 Format_desc 1 120 Server ver: 5.6.27-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 120 Query 1 213 CREATE DATABASE `db1` master-bin.000001 213 Query 1 350 use `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 350 Query 1 712 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB master-bin.000001 712 Query 1 839 use `db1`; DROP TABLE IF EXISTS `table1` /* generated by server */ main.rpl_bug77684 [ fail ] Test ended at 2015-07-13 15:04:52 CURRENT_TEST: main.rpl_bug77684 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 120 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 839 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 876 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 712 Relay_Log_Space 1176 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 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 bfdb78f3-295f-11e5-9b51-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.27/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 150713 16:04:52 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 2 User root Host localhost:50345 db test Command Sleep Time 0 State Info ---- 2. ---- Id 3 User root Host localhost:50346 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:50352 db test Command Query Time 0 State init Info SHOW PROCESSLIST ---- 5. ---- Id 7 User root Host localhost:50353 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 18: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 839, 300)' returned NULL indicating slave SQL thread failure == /export/umesh/server/binaries/mysql-5.6.27/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-07-13 16:04:52 @@SERVER_ID 1 @@SERVER_UUID bfdb78f3-295f-11e5-9b51-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 839 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 c00f301b-295f-11e5-9b51-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 5 root localhost:52628 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 839 **** 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.27-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 120 Query 1 213 CREATE DATABASE `db1` master-bin.000001 213 Query 1 350 use `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 350 Query 1 712 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB master-bin.000001 712 Query 1 839 use `db1`; DROP TABLE IF EXISTS `table1` /* generated by server */ **** 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-5.6.27/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-07-13 16:04:52 @@SERVER_ID 2 @@SERVER_UUID c00f301b-295f-11e5-9b51-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 839 Relay_Log_File slave-relay-bin.000002 Relay_Log_Pos 876 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 712 Relay_Log_Space 1176 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 bfdb78f3-295f-11e5-9b51-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.6.27/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 150713 16:04:52 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 120 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 120 **** 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.27-enterprise-commercial-advanced-log, Binlog ver: 4 **** 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.27-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.27-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 284 Query 1 213 CREATE DATABASE `db1` slave-relay-bin.000002 377 Query 1 350 use `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-relay-bin.000002 514 Query 1 712 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB slave-relay-bin.000002 876 Query 1 839 use `db1`; DROP TABLE IF EXISTS `table1` /* generated by server */ **** 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-5.6.27/mysql-test/var/log/main.rpl_bug77684/' to '/export/umesh/server/binaries/mysql-5.6.27/mysql-test/var/log/main.rpl_bug77684/' -------------------------------------------------------------------------- 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_bug77684 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.6.27/mysql-test: ## 5.7.8 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8/mysql-test: ./mtr rpl_bug77684 Logging: ./mtr rpl_bug77684 MySQL Version 5.7.8 Checking supported features... - SSL connections supported Collecting tests... Checking leftover processes... Removing old var directory... Creating var directory '/export/umesh/server/binaries/mysql-5.7.8/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] [On 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; [master - SHOW DATABASES ] SHOW DATABASES; Database information_schema db1 mtr mysql performance_schema sys test [On Slave] [slave - SHOW DATABASES ] SHOW DATABASES; Database information_schema mtr mysql performance_schema sys test 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 941 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 Yes 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 Skip_Counter 0 Exec_Master_Log_Pos 941 Relay_Log_Space 1363 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 0 Master_SSL_Verify_Server_Cert No Last_IO_Errno 0 Last_IO_Error Last_SQL_Errno 0 Last_SQL_Error Replicate_Ignore_Server_Ids Master_Server_Id 1 Master_UUID bdc83f6a-295c-11e5-960d-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8/mysql-test/var/mysqld.2/data/master.info SQL_Delay 0 SQL_Remaining_Delay NULL Slave_SQL_Running_State Slave has read all relay log; waiting for more updates Master_Retry_Count 10 Master_Bind Last_IO_Error_Timestamp Last_SQL_Error_Timestamp Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name [On Master] DROP TABLE IF EXISTS `db1`.`table1`; ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails main.rpl_bug77684 [ fail ] Test ended at 2015-07-13 14:43:20 CURRENT_TEST: main.rpl_bug77684 === SHOW MASTER STATUS === ---- 1. ---- File slave-bin.000001 Position 154 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 1133 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 1555 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 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 bdc83f6a-295c-11e5-960d-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8/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 150713 15:43:20 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name ========================= === SHOW PROCESSLIST === ---- 1. ---- Id 3 User root Host localhost:50280 db test Command Sleep Time 0 State Info ---- 2. ---- Id 4 User root Host localhost:50281 db test Command Sleep Time 0 State Info ---- 3. ---- Id 5 User system user Host db Command Connect Time 0 State Waiting for master to send event Info ---- 4. ---- Id 7 User root Host localhost:50287 db test Command Query Time 0 State starting Info SHOW PROCESSLIST ---- 5. ---- Id 8 User root Host localhost:50288 db test Command Sleep Time 0 State Info ======================== analyze: sync_with_master mysqltest: At line 36: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 1133, 300)' returned NULL indicating slave SQL thread failure safe_process[804]: Child process: 805, exit: 1 == /export/umesh/server/binaries/mysql-5.7.8/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-07-13 15:43:20 @@SERVER_ID 2 @@SERVER_UUID bdd14b30-295c-11e5-9556-0010e05f3e06 @@PORT 13001 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED Warnings: Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. **** 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 1133 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 1555 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 bdc83f6a-295c-11e5-960d-0010e05f3e06 Master_Info_File /export/umesh/server/binaries/mysql-5.7.8/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 150713 15:43:20 Master_SSL_Crl Master_SSL_Crlpath Retrieved_Gtid_Set Executed_Gtid_Set Auto_Position 0 Replicate_Rewrite_DB Channel_Name **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; CHANNEL_NAME GROUP_NAME SOURCE_UUID bdc83f6a-295c-11e5-960d-0010e05f3e06 THREAD_ID 23 SERVICE_STATE ON COUNT_RECEIVED_HEARTBEATS 0 LAST_HEARTBEAT_TIMESTAMP 0000-00-00 00:00:00 RECEIVED_TRANSACTION_SET LAST_ERROR_NUMBER 0 LAST_ERROR_MESSAGE LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00 **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; CHANNEL_NAME THREAD_ID NULL SERVICE_STATE OFF LAST_ERROR_NUMBER 3002 LAST_ERROR_MESSAGE 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 */' LAST_ERROR_TIMESTAMP 2015-07-13 15:43:20 **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File slave-bin.000001 Position 154 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 5 system user NULL Connect 0 Waiting for master to send event NULL 9 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 11 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 12 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 13 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 15 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 16 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 17 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 18 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 19 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 23 thread/sql/slave_io FOREGROUND 5 root localhost NULL Connect 0 Waiting for master to send event NULL 21 NULL YES YES NULL 27 thread/sql/one_connection FOREGROUND 9 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size slave-bin.000001 154 **** 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 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 slave-bin.000001 123 Previous_gtids 2 154 **** 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 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 123 Previous_gtids 2 154 slave-relay-bin.000002 154 Rotate 1 0 master-bin.000001;pos=4 slave-relay-bin.000002 202 Format_desc 1 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 slave-relay-bin.000002 321 Rotate 0 369 master-bin.000001;pos=154 slave-relay-bin.000002 369 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 434 Query 1 312 CREATE DATABASE `db1` slave-relay-bin.000002 527 Anonymous_Gtid 1 377 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 592 Query 1 514 use `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB slave-relay-bin.000002 729 Anonymous_Gtid 1 579 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 794 Query 1 941 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB slave-relay-bin.000002 1156 Anonymous_Gtid 1 1006 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' slave-relay-bin.000002 1221 Query 1 1133 use `db1`; DROP TABLE IF EXISTS `table1` /* generated by server */ **** 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 Channel_name **** 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 Channel_name **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; == /export/umesh/server/binaries/mysql-5.7.8/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-07-13 15:43:20 @@SERVER_ID 1 @@SERVER_UUID bdc83f6a-295c-11e5-960d-0010e05f3e06 @@PORT 13000 **** GTID_* on default **** SELECT @@GLOBAL.GTID_MODE, @@GLOBAL.GTID_EXECUTED, @@GLOBAL.GTID_PURGED, @@GLOBAL.GTID_OWNED, @@SESSION.GTID_EXECUTED, @@SESSION.GTID_OWNED; @@GLOBAL.GTID_MODE OFF @@GLOBAL.GTID_EXECUTED @@GLOBAL.GTID_PURGED @@GLOBAL.GTID_OWNED @@SESSION.GTID_EXECUTED @@SESSION.GTID_OWNED Warnings: Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. Level Warning Code 1681 Message '@@SESSION.GTID_EXECUTED' is deprecated and will be removed in a future release. **** SHOW SLAVE STATUS on default **** SHOW SLAVE STATUS; **** replication_connection_status on default **** SELECT * FROM performance_schema.replication_connection_status; **** replication_applier_status_by_worker on default **** SELECT * FROM performance_schema.replication_applier_status_by_worker; **** replication_applier_status_by_coordinator on default **** SELECT * FROM performance_schema.replication_applier_status_by_coordinator; **** SHOW MASTER STATUS on default **** SHOW MASTER STATUS; File master-bin.000001 Position 1133 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 bdd14b30-295c-11e5-9556-0010e05f3e06 **** SHOW PROCESSLIST on default **** SHOW PROCESSLIST; Id User Host db Command Time State Info 6 root localhost:52563 NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 9 root localhost NULL Query 0 starting SHOW PROCESSLIST **** SELECT * FROM performance_schema.threads **** SELECT * FROM performance_schema.threads; THREAD_ID NAME TYPE PROCESSLIST_ID PROCESSLIST_USER PROCESSLIST_HOST PROCESSLIST_DB PROCESSLIST_COMMAND PROCESSLIST_TIME PROCESSLIST_STATE PROCESSLIST_INFO PARENT_THREAD_ID ROLE INSTRUMENTED HISTORY CONNECTION_TYPE 1 thread/sql/main BACKGROUND NULL NULL NULL NULL NULL 0 NULL NULL NULL NULL YES YES NULL 2 thread/sql/thread_timer_notifier BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 3 thread/innodb/io_ibuf_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 4 thread/innodb/io_log_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 5 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 6 thread/innodb/io_read_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 7 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 8 thread/innodb/io_write_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 9 thread/innodb/page_cleaner_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 11 thread/innodb/srv_lock_timeout_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 12 thread/innodb/srv_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 13 thread/innodb/srv_error_monitor_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 14 thread/innodb/srv_master_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 15 thread/innodb/srv_purge_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 16 thread/innodb/buf_dump_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 17 thread/innodb/dict_stats_thread BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL YES YES NULL 18 thread/sql/signal_handler BACKGROUND NULL NULL NULL NULL NULL NULL NULL NULL 1 NULL YES YES NULL 19 thread/sql/compress_gtid_table FOREGROUND 1 NULL NULL NULL Daemon 0 Suspending NULL 1 NULL YES YES NULL 24 thread/sql/one_connection FOREGROUND 6 root localhost NULL Binlog Dump 0 Master has sent all binlog to slave; waiting for more updates NULL 1NULL YES YES TCP/IP 27 thread/sql/one_connection FOREGROUND 9 root localhost NULL Query 0 Sending data SELECT * FROM performance_schema.threads NULL NULL YES YES Socket **** SHOW BINARY LOGS on default **** SHOW BINARY LOGS; Log_name File_size master-bin.000001 1133 **** 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 123 Server ver: 5.7.8-rc-enterprise-commercial-advanced-log, Binlog ver: 4 master-bin.000001 123 Previous_gtids 1 154 master-bin.000001 154 Anonymous_Gtid 1 219 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 219 Query 1 312 CREATE DATABASE `db1` master-bin.000001 312 Anonymous_Gtid 1 377 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 377 Query 1 514 use `db1`; CREATE TABLE `table1` (`ID` bigint(20) primary key) ENGINE=InnoDB master-bin.000001 514 Anonymous_Gtid 1 579 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 579 Query 1 941 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 `table1` (`ID`) ON DELETE CASCADE ) ENGINE=InnoDB master-bin.000001 941 Anonymous_Gtid 1 1006 SET @@SESSION.GTID_NEXT= 'ANONYMOUS' master-bin.000001 1006 Query 1 1133 use `db1`; DROP TABLE IF EXISTS `table1` /* generated by server */ **** 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 Channel_name **** 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 Channel_name **** mysql.gtid_executed on default **** SELECT * FROM mysql.gtid_executed; source_uuid interval_start interval_end rpl_topology= rand_seed: '' _rand_state: '' extra debug info if any: '' rpl_topology= connection default; - the logfile can be found in '/export/umesh/server/binaries/mysql-5.7.8/mysql-test/var/log/main.rpl_bug77684/rpl_bug77684.log' -------------------------------------------------------------------------- The servers were restarted 0 times Spent 0.000 of 5 seconds executing testcases Completed: Failed 1/1 tests, 0.00% were successful. Failing test(s): main.rpl_bug77684 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