mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 04:46:15 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			46 lines
		
	
	
	
		
			1.5 KiB
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			46 lines
		
	
	
	
		
			1.5 KiB
		
	
	
	
		
			Text
		
	
	
	
	
	
#
 | 
						|
# Test GAL-501 Improved URI parsing for IPv6 addresses 
 | 
						|
# The .cnf file contains
 | 
						|
# wsrep_node_address=[::1]
 | 
						|
# ist.recv_addr=[::1]
 | 
						|
 | 
						|
--let galera_connection_address=::1
 | 
						|
--source include/galera_cluster.inc
 | 
						|
--source include/check_ipv6.inc
 | 
						|
--source include/force_restart.inc
 | 
						|
 | 
						|
--let $galera_connection_name = node_3
 | 
						|
--let $galera_server_number = 3
 | 
						|
--source include/galera_connect.inc
 | 
						|
--connection node_3
 | 
						|
--source include/galera_wait_ready.inc
 | 
						|
 | 
						|
# Confirm that initial handshake happened over ipv6
 | 
						|
 | 
						|
SELECT VARIABLE_VALUE LIKE '%[::1]%' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_incoming_addresses';
 | 
						|
SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
 | 
						|
 | 
						|
# Force IST
 | 
						|
 | 
						|
--connection node_2
 | 
						|
SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
 | 
						|
 | 
						|
--connection node_1
 | 
						|
--let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
 | 
						|
--source include/wait_condition.inc
 | 
						|
 | 
						|
CREATE TABLE t1 (f1 INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
 | 
						|
INSERT INTO t1 VALUES (1);
 | 
						|
 | 
						|
--connection node_2
 | 
						|
SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
 | 
						|
 | 
						|
--let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
 | 
						|
--source include/wait_condition.inc
 | 
						|
 | 
						|
--let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
 | 
						|
--source include/wait_condition.inc
 | 
						|
 | 
						|
SELECT COUNT(*) AS EXPECT_1 FROM t1;
 | 
						|
 | 
						|
DROP TABLE t1;
 |