Default page

View File Name : ndb_rpl_slave_conflict_role_var.result

include/master-slave.inc
Warnings:
Note	####	Sending passwords in plain text without SSL/TLS is extremely insecure.
Note	####	Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.
[connection master]
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
Slave_SQL_Running = 'Yes'
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
stop slave sql_thread;
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
Slave_SQL_Running = 'No'
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
Show set-to-same state is ok
set global ndb_slave_conflict_role = NONE;
Now transition through all status, including set-to-self
set global ndb_slave_conflict_role = "PRIMARY";
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
set global ndb_slave_conflict_role = "PRIMARY";
set global ndb_slave_conflict_role = "SECONDARY";
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
set global ndb_slave_conflict_role = "SECONDARY";
set global ndb_slave_conflict_role = "NONE";
set global ndb_slave_conflict_role = "SECONDARY";
set global ndb_slave_conflict_role = "PRIMARY";
set global ndb_slave_conflict_role = "NONE";
set global ndb_slave_conflict_role = "PASS";
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = "PASS";
set global ndb_slave_conflict_role = "NONE";
Now test illegal transitions
set global ndb_slave_conflict_role = "PRIMARY";
set global ndb_slave_conflict_role = "PASS";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PRIMARY to PASS failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
set global ndb_slave_conflict_role = "SECONDARY";
set global ndb_slave_conflict_role = "PASS";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from SECONDARY to PASS failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
set global ndb_slave_conflict_role = "NONE";
set global ndb_slave_conflict_role = "PASS";
set global ndb_slave_conflict_role = "PRIMARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PASS to PRIMARY failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = "SECONDARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PASS to SECONDARY failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = "NONE";
Now test transitions not possible due to 
Slave SQL thread running
start slave sql_thread;
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
Slave_SQL_Running = 'Yes'
Warnings:
Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
From NONE
set global ndb_slave_conflict_role = "NONE";
set global ndb_slave_conflict_role = "PRIMARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from NONE to PRIMARY failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
set global ndb_slave_conflict_role = "SECONDARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from NONE to SECONDARY failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
set global ndb_slave_conflict_role = "PASS";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from NONE to PASS failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
stop slave sql_thread;
From PRIMARY
set global ndb_slave_conflict_role = "PRIMARY";
start slave sql_thread;
set global ndb_slave_conflict_role = "PRIMARY";
set global ndb_slave_conflict_role = "SECONDARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PRIMARY to SECONDARY failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
set global ndb_slave_conflict_role = "NONE";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PRIMARY to NONE failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
set global ndb_slave_conflict_role = "PASS";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PRIMARY to PASS failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
stop slave sql_thread;
From SECONDARY
set global ndb_slave_conflict_role = "SECONDARY";
start slave sql_thread;
set global ndb_slave_conflict_role = "SECONDARY";
set global ndb_slave_conflict_role = "PRIMARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from SECONDARY to PRIMARY failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
set global ndb_slave_conflict_role = "NONE";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from SECONDARY to NONE failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
set global ndb_slave_conflict_role = "PASS";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from SECONDARY to PASS failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
stop slave sql_thread;
From PASS
set global ndb_slave_conflict_role = "NONE";
set global ndb_slave_conflict_role = "PASS";
start slave sql_thread;
set global ndb_slave_conflict_role = "PASS";
set global ndb_slave_conflict_role = "PRIMARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PASS to PRIMARY failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = "SECONDARY";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PASS to SECONDARY failed : Invalid role change.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = "NONE";
ERROR HY000: Error when executing command SET GLOBAL ndb_slave_conflict_role: Role change from PASS to NONE failed : Cannot change role while Slave SQL thread is running.  Use STOP SLAVE first.
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
stop slave sql_thread;
set global ndb_slave_conflict_role = "NONE";
Test some aliases for role names
set global ndb_slave_conflict_role = PR;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
set global ndb_slave_conflict_role = S;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
set global ndb_slave_conflict_role = N;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
set global ndb_slave_conflict_role = PA;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = 0;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
set global ndb_slave_conflict_role = 2;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PRIMARY
set global ndb_slave_conflict_role = 1;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	SECONDARY
set global ndb_slave_conflict_role = 0;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	NONE
set global ndb_slave_conflict_role = 3;
show global variables like 'ndb_slave_conflict_role';
Variable_name	Value
ndb_slave_conflict_role	PASS
set global ndb_slave_conflict_role = NON;
start slave sql_thread;
include/rpl_end.inc