Debian Codegraph @

mysql-test/suite/galera/t/galera_sst_mariabackup_lost_found.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3 --source include/have_mariabackup.inc
4
5 # Save original auto_increment_offset values.
6 --let $node_1=node_1
7 --let $node_2=node_2
8 --source include/auto_increment_offset_save.inc
9
10 --connection node_2
11
12 #--connection node_2
13 #--source suite/galera/include/galera_stop_replication.inc
14
15 --echo Shutting down server ...
16 --source include/shutdown_mysqld.inc
17
18 --connection node_1
19 --let $wait_condition = SELECT VARIABLE_VALUE = 1 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
20 --source include/wait_condition.inc
21
22 CREATE DATABASE `lost+found`;
23 USE `lost+found`;
24 CREATE TABLE t1(id INT);
25 INSERT INTO t1 VALUES (1), (2);
26 SELECT * FROM `lost+found`.t1;
27
28 CREATE DATABASE `#mysql50#not_lost+found`;
29 USE `#mysql50#not_lost+found`;
30 CREATE TABLE t1(id INT);
31 INSERT INTO t1 VALUES (1), (2);
32 SELECT * FROM `#mysql50#not_lost+found`.t1;
33
34 #
35 # Force SST
36 #
37 --echo Cleaning var directory ...
38 --remove_file $MYSQLTEST_VARDIR/mysqld.2/data/grastate.dat
39 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/mtr
40 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/performance_schema
41 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/test
42 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data/mysql
43 --remove_files_wildcard $MYSQLTEST_VARDIR/mysqld.2/data
44
45 --connection node_2
46
47 --echo Starting server ...
48 let $restart_noprint=2;
49 --source include/start_mysqld.inc
50
51 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
52 --source include/wait_condition.inc
53
54 --let $wait_condition = SELECT VARIABLE_VALUE = 'ON' FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_ready';
55 --source include/wait_condition.inc
56
57 SELECT * FROM `lost+found`.t1;
58 SELECT * FROM `#mysql50#not_lost+found`.t1;
59
60 --connection node_1
61
62 DROP DATABASE `lost+found`;
63 DROP DATABASE `#mysql50#not_lost+found`;
64
65 # rmdir $MYSQLD_DATADIR/lost+found;
66 # rmdir $MYSQLD_DATADIR/not_lost+found;
67
68 # Restore original auto_increment_offset values.
69 --source include/auto_increment_offset_restore.inc
70
71 --source include/galera_end.inc