1'#--------------------FN_DYNVARS_165_01-------------------------#' 2SET @start_global_value = @@global.sql_slave_skip_counter; 3SELECT @@global.sql_slave_skip_counter; 4@@global.sql_slave_skip_counter 50 6'#--------------------FN_DYNVARS_165_02-------------------------#' 7SET @@global.sql_slave_skip_counter = DEFAULT; 8SELECT @@global.sql_slave_skip_counter; 9@@global.sql_slave_skip_counter 100 11'#--------------------FN_DYNVARS_165_03-------------------------#' 12SET @@global.sql_slave_skip_counter = 0; 13SET @@global.sql_slave_skip_counter = 5; 14SET @@global.sql_slave_skip_counter = 1024; 15SET @@global.sql_slave_skip_counter = 2147483648; 16SET @@global.sql_slave_skip_counter = 2147483648*2; 17Warnings: 18Warning 1292 Truncated incorrect sql_slave_skip_counter value: '4294967296' 19SET @@global.sql_slave_skip_counter = 2147483648*2-1; 20SET @@global.sql_slave_skip_counter = 18446744065119617025; 21Warnings: 22Warning 1292 Truncated incorrect sql_slave_skip_counter value: '18446744065119617025' 23'#--------------------FN_DYNVARS_165_03-------------------------#' 24SET @@global.sql_slave_skip_counter = '5'; 25ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' 26SET @@global.sql_slave_skip_counter = 5.5; 27ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' 28SET @@global.sql_slave_skip_counter = -.5; 29ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' 30SET @@global.sql_slave_skip_counter = -.0; 31ERROR 42000: Incorrect argument type to variable 'sql_slave_skip_counter' 32'#--------------------FN_DYNVARS_165_03-------------------------#' 33SET @@global.sql_slave_skip_counter = 1024; 34SELECT VARIABLE_VALUE 35FROM INFORMATION_SCHEMA.SESSION_VARIABLES 36WHERE VARIABLE_NAME='sql_slave_skip_counter'; 37VARIABLE_VALUE 381024 39'#--------------------FN_DYNVARS_165_03-------------------------#' 40SET @@sql_slave_skip_counter = 10; 41ERROR HY000: Variable 'sql_slave_skip_counter' is a GLOBAL variable and should be set with SET GLOBAL 42SET @@session.sql_slave_skip_counter = 12; 43ERROR HY000: Variable 'sql_slave_skip_counter' is a GLOBAL variable and should be set with SET GLOBAL 44SET @@local.sql_slave_skip_counter = 13; 45ERROR HY000: Variable 'sql_slave_skip_counter' is a GLOBAL variable and should be set with SET GLOBAL 46SET @@global.sql_slave_skip_counter = 0; 47SET @@global.enforce_gtid_consistency = on; 48SET @@global.gtid_mode = off_permissive; 49set global sql_slave_skip_counter= 1; 50set global sql_slave_skip_counter= 0; 51SET @@global.gtid_mode = on_permissive; 52set global sql_slave_skip_counter= 1; 53set global sql_slave_skip_counter= 0; 54SET @@global.gtid_mode = on; 55set global sql_slave_skip_counter= 1; 56ERROR HY000: sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to skip, generate an empty transaction with the same GTID as the transaction 57select @@global.sql_slave_skip_counter; 58@@global.sql_slave_skip_counter 590 60set global sql_slave_skip_counter= 0; 61ERROR HY000: sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to skip, generate an empty transaction with the same GTID as the transaction 62select @@global.sql_slave_skip_counter; 63@@global.sql_slave_skip_counter 640 65SET @@global.gtid_mode = on_permissive; 66SET @@global.gtid_mode = off_permissive; 67SET @@global.gtid_mode = off; 68SET @@global.enforce_gtid_consistency = off; 69