Debian Codegraph @

mysql-test/suite/galera/t/MDEV-37366.test

raw
1 #
2 # MDEV-37366: Inconsistency detected - create sequence
3 # Failed 'SELECT NEXT VALUE' on applier node.
4 #
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/big_test.inc
8 --source include/have_log_bin.inc
9
10 #
11 # Save original auto_increment_offset values.
12 #
13 --let $node_1=node_1
14 --let $node_2=node_2
15 --source ../galera/include/auto_increment_offset_save.inc
16
17 #
18 # Verify there are two nodes in galera cluster.
19 #
20 --connection node_1
21 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
22 --source include/wait_condition.inc
23
24 #
25 # Create a sequence table on node1.
26 #
27 SET SESSION binlog_row_image=minimal;
28 CREATE SEQUENCE `seq_test` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 0 cache 1000 nocycle ENGINE=InnoDB;
29 SHOW CREATE TABLE seq_test;
30
31 #
32 # Execute 'SELECT NEXT VALUE' which should not fail on applier node.
33 #
34 --disable_ps_protocol
35 SELECT NEXT VALUE FOR seq_test;
36 SELECT NEXT VALUE FOR seq_test;
37 --enable_ps_protocol
38
39 #
40 # Verify there are two nodes in galera cluster.
41 #
42 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
43 --source include/wait_condition.inc
44
45 #
46 # Cleanup
47 #
48 --connection node_2
49
50 DROP SEQUENCE seq_test;
51
52 # Restore original variable values.
53 --source ../galera/include/auto_increment_offset_restore.inc