Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/rpl/t/

Edit File: rpl_wait_for_executed_gtid_set_with_sleep.test

--source include/not_group_replication_plugin.inc

# WL#7796 - WAIT_FOR_EXECUTED_GTID_SET
#
# This test waits for a transaction that has not been committed, sleeps
# for a second and verifies that the wait function is still waiting. Then
# executes a statement which fulfils the waiting condition. That would
# verify that the wait function does not return immediately.

--source include/have_log_bin.inc
--source include/have_gtid.inc
--source include/master-slave.inc

--connection slave
--let $master_uuid= query_get_value(select SOURCE_UUID from performance_schema.replication_connection_status WHERE service_state = 'ON', SOURCE_UUID, 1)

--let $gtid_not_committed_wait_set= $master_uuid:3-4
--let $gtid_committed_and_not_committed_set= $master_uuid:1-6

--connection master

CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
INSERT INTO t1 VALUES (1);

--connection master1

--let $connection_id= `SELECT CONNECTION_ID()`
--send
--replace_result $master_uuid MASTER_UUID
--eval SELECT WAIT_FOR_EXECUTED_GTID_SET('$gtid_not_committed_wait_set', 10000)
sleep 2;

--connection default
# Now executing the next transaction.
INSERT INTO t1 VALUES (2);
# Checking the waiting thread condition.
--echo The connection master1 should be waiting for the WAIT_FOR_EXECUTED_GTID_SET here
--let $wait_condition=SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE Id='$connection_id' AND Info Like 'SELECT WAIT_FOR_EXECUTED_GTID_SET%'
--source include/wait_condition.inc

INSERT INTO t1 VALUES (3);

--connection master1
--replace_result $master_uuid MASTER_UUID
--reap

# This part of the test checks for the validity of the
# wait_for_executed_gtid_set function which has a set of GTID which is
# committed as well as uncommitted. It should wait for the entire set to be
# executed.

--connection master1

--send
--replace_result $master_uuid MASTER_UUID
--eval SELECT WAIT_FOR_EXECUTED_GTID_SET('$gtid_committed_and_not_committed_set', 10000)

--connection default
--echo The connection master1 should be waiting for the WAIT_FOR_EXECUTED_GTID_SET here
--let $wait_condition=SELECT COUNT(*)=1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE Id='$connection_id' AND Info Like 'SELECT WAIT_FOR_EXECUTED_GTID_SET%'
--source include/wait_condition.inc

INSERT INTO t1 VALUES (4);
DROP TABLE t1;

--connection master1
--replace_result $master_uuid MASTER_UUID
--reap

--let $wait_for_gtid_executed_set=1
--source include/sync_slave_sql_with_master.inc

--connection master
--source include/rpl_end.inc