# See if master_pos_wait(,,timeout) # Terminates with "timeout expired" (-1) source include/master-slave.inc; sync_slave_with_master; # Ask for a master log that has certainly not been reached yet # timeout= 2 seconds select master_pos_wait('master-bin.999999',0,2); explain extended select master_pos_wait('master-bin.999999',0,2); # Testcase for bug 651 (master_pos_wait() hangs if slave idle and STOP SLAVE). send select master_pos_wait('master-bin.999999',0); connection slave1; stop slave sql_thread; connection slave; reap; # # bug#26622 MASTER_POS_WAIT does not work as documented # connection master; echo "*** must be empty ***"; query_vertical show slave status; echo "*** must be NULL ***"; select master_pos_wait('foo', 98); # End of 4.1 tests --echo *** MDEV-7130: MASTER_POS_WAIT(log_name,log_pos,timeout,"connection_name") hangs, does not respect the timeout *** --connection slave --source include/stop_slave.inc reset slave all; --replace_result $MASTER_MYPORT MASTER_MYPORT eval change master 'my_slave' to master_port=$MASTER_MYPORT, master_host='127.0.0.1', master_user='root'; set default_master_connection = 'my_slave'; --source include/start_slave.inc --echo # Call without connection name -- works (expected -1) select master_pos_wait('master-bin.000001',1000000,1); set default_master_connection = ''; --echo # Call for non-existing anonymous connection -- works (expected NULL) select master_pos_wait('master-bin.000001',1000000,1); --echo # Call with a valid connection name -- hangs before MDEV-7130 fix (expected -1) select master_pos_wait('master-bin.000001',1000000,1,"my_slave"); STOP SLAVE 'my_slave'; RESET SLAVE 'my_slave' ALL; --replace_result $MASTER_MYPORT MASTER_MYPORT eval change master to master_port=$MASTER_MYPORT, master_host='127.0.0.1', master_user='root'; # End of 10.0 tests --echo # --echo # Start of 10.3 tests --echo # --echo # --echo # MDEV-13965 Parameter data type control for Item_longlong_func --echo # --error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION SELECT MASTER_POS_WAIT('x',1,ROW(1,1)); --error ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION SELECT MASTER_POS_WAIT('x',1,1,ROW(1,1)); --echo # --echo # End of 10.3 tests --echo # --let $rpl_only_running_threads= 1 --source include/rpl_end.inc