Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_err_ignoredtable.result

raw
1 stop slave;
2 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
3 reset master;
4 reset slave;
5 drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
6 start slave;
7 create table t1 (a int primary key);
8 insert into t1 values (1),(1);
9 ERROR 23000: Duplicate entry '1' for key 1
10 show slave status;
11 Slave_IO_State Master_Host Master_User Master_Port Connect_Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicate_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Error Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key Seconds_Behind_Master
12 # 127.0.0.1 root MASTER_PORT 1 master-bin.000001 269 # # master-bin.000001 Yes Yes 0 0 269 # None 0 No #
13 show tables like 't1';
14 Tables_in_test (t1)
15 t1
16 drop table t1;
17 select get_lock('crash_lock%20C', 10);
18 get_lock('crash_lock%20C', 10)
19 1
20 create table t2 (a int primary key);
21 insert into t2 values(1);
22 create table t3 (id int);
23 insert into t3 values(connection_id());
24 update t2 set a = a + 1 + get_lock('crash_lock%20C', 10);
25 select (@id := id) - id from t3;
26 (@id := id) - id
27 0
28 kill @id;
29 drop table t2,t3;
30 show binlog events from 102;
31 Log_name Pos Event_type Server_id End_log_pos Info
32 master-bin.000001 # Query 1 # #
33 master-bin.000001 # Table_map 1 # #
34 master-bin.000001 # Write_rows 1 # #
35 master-bin.000001 # Query 1 # #
36 master-bin.000001 # Query 1 # #
37 master-bin.000001 # Table_map 1 # #
38 master-bin.000001 # Write_rows 1 # #
39 master-bin.000001 # Query 1 # #
40 master-bin.000001 # Table_map 1 # #
41 master-bin.000001 # Write_rows 1 # #
42 master-bin.000001 # Table_map 1 # #
43 master-bin.000001 # Update_rows 1 # #
44 master-bin.000001 # Query 1 # #