| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection master; |
| 4 |
create table t1 (a int primary key, b int) engine=innodb; |
| 5 |
insert t1 values (1,1); |
| 6 |
include/save_master_gtid.inc |
| 7 |
connection slave; |
| 8 |
include/sync_with_master_gtid.inc |
| 9 |
include/stop_slave.inc |
| 10 |
set @save_innodb_lock_wait_timeout= @@global.innodb_lock_wait_timeout; |
| 11 |
set @save_slave_trans_retries= @@global.slave_transaction_retries; |
| 12 |
set @@global.innodb_lock_wait_timeout= 1; |
| 13 |
set @@global.slave_transaction_retries= 0; |
| 14 |
connection master; |
| 15 |
update t1 set b=b+10 where a=1; |
| 16 |
include/save_master_gtid.inc |
| 17 |
connection slave1; |
| 18 |
BEGIN; |
| 19 |
SELECT * FROM t1 WHERE a=1 FOR UPDATE; |
| 20 |
a b |
| 21 |
1 1 |
| 22 |
connection slave; |
| 23 |
include/start_slave.inc |
| 24 |
include/wait_for_slave_sql_error.inc [errno=1205] |
| 25 |
connection slave1; |
| 26 |
ROLLBACK; |
| 27 |
connection slave; |
| 28 |
set @save_dbug = @@global.debug_dbug; |
| 29 |
set @@global.debug_dbug= "+d,delay_sql_thread_after_release_run_lock"; |
| 30 |
include/start_slave.inc |
| 31 |
set debug_sync= "now wait_for sql_thread_run_lock_released"; |
| 32 |
# Validating that the SQL thread is running.. |
| 33 |
# ..success |
| 34 |
# Validating that Last_SQL_Errno is cleared.. |
| 35 |
# ..success |
| 36 |
set debug_sync= "now signal sql_thread_continue"; |
| 37 |
# Wait for debug_sync signal to have been received before issuing RESET |
| 38 |
set @@global.debug_dbug= @saved_dbug; |
| 39 |
set debug_sync= "RESET"; |
| 40 |
# Cleanup |
| 41 |
connection master; |
| 42 |
drop table t1; |
| 43 |
connection slave; |
| 44 |
include/stop_slave.inc |
| 45 |
set @@global.innodb_lock_wait_timeout= @save_innodb_lock_wait_timeout; |
| 46 |
set @@global.slave_transaction_retries= @save_slave_trans_retries; |
| 47 |
include/start_slave.inc |
| 48 |
include/rpl_end.inc |
| 49 |
# End of rpl_sql_thd_start_errno_cleared.test |