mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01:00
![Marko Mäkelä](/assets/img/avatar_default.png)
dict_create_or_check_foreign_constraint_tables(): Change the warning about the foreign key metadata table creation to a note. Remove messages after metadata table creation. If the creation fails, startup will abort with a message. Normally the creation succeeds on bootstrap, and the messages would only be noise. Remove the related suppressions from the tests.
458 lines
17 KiB
Text
458 lines
17 KiB
Text
Setting SST method to mysqldump ...
|
|
CREATE USER 'sst';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'sst';
|
|
SET GLOBAL wsrep_sst_auth = 'sst:';
|
|
SET GLOBAL wsrep_sst_method = 'mysqldump';
|
|
Performing State Transfer on a server that has been temporarily disconnected
|
|
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
COMMIT;
|
|
Unloading wsrep provider ...
|
|
SET GLOBAL wsrep_provider = 'none';
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
COMMIT;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
Loading wsrep provider ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
ROLLBACK;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
DROP TABLE t1;
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
Performing State Transfer on a server that has been shut down cleanly and restarted
|
|
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
COMMIT;
|
|
Shutting down server ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
COMMIT;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
Starting server ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
ROLLBACK;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
DROP TABLE t1;
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
Performing State Transfer on a server that starts from a clean var directory
|
|
This is accomplished by shutting down node #2 and removing its var directory before restarting it
|
|
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
COMMIT;
|
|
Shutting down server ...
|
|
Cleaning var directory ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
COMMIT;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
Starting server ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
ROLLBACK;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
DROP TABLE t1;
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
Performing State Transfer on a server that has been killed and restarted
|
|
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
COMMIT;
|
|
Killing server ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
INSERT INTO t1 VALUES ('node1_committed_during');
|
|
COMMIT;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
Performing --wsrep-recover ...
|
|
Starting server ...
|
|
Using --wsrep-start-position when starting mysqld ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
INSERT INTO t1 VALUES ('node2_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_committed_after');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
INSERT INTO t1 VALUES ('node1_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 VALUES ('node1_to_be_rollbacked_after');
|
|
ROLLBACK;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
DROP TABLE t1;
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
Performing State Transfer on a server that has been killed and restarted
|
|
while a DDL was in progress on it
|
|
CREATE TABLE t1 (f1 CHAR(255)) ENGINE=InnoDB;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
INSERT INTO t1 VALUES ('node1_committed_before');
|
|
START TRANSACTION;
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
INSERT INTO t1 VALUES ('node2_committed_before');
|
|
COMMIT;
|
|
SET GLOBAL debug = 'd,sync.alter_opened_table';
|
|
ALTER TABLE t1 ADD COLUMN f2 INTEGER;
|
|
SET wsrep_sync_wait = 0;
|
|
Killing server ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_during');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_during');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_during');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_during');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_during');
|
|
COMMIT;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
Performing --wsrep-recover ...
|
|
Starting server ...
|
|
Using --wsrep-start-position when starting mysqld ...
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES ('node2_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node2_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node2_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node2_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node2_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_committed_after');
|
|
COMMIT;
|
|
SET AUTOCOMMIT=OFF;
|
|
START TRANSACTION;
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_committed_after');
|
|
COMMIT;
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
INSERT INTO t1 (f1) VALUES ('node1_to_be_rollbacked_after');
|
|
ROLLBACK;
|
|
SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
|
|
COUNT(*) = 2
|
|
1
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
SELECT COUNT(*) = 2 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 't1';
|
|
COUNT(*) = 2
|
|
1
|
|
SELECT COUNT(*) = 35 FROM t1;
|
|
COUNT(*) = 35
|
|
1
|
|
SELECT COUNT(*) = 0 FROM (SELECT COUNT(*) AS c, f1 FROM t1 GROUP BY f1 HAVING c NOT IN (5, 10)) AS a1;
|
|
COUNT(*) = 0
|
|
1
|
|
DROP TABLE t1;
|
|
COMMIT;
|
|
SET AUTOCOMMIT=ON;
|
|
CALL mtr.add_suppression("Slave SQL: Error 'The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement' on query");
|
|
DROP USER sst;
|
|
CALL mtr.add_suppression("Slave SQL: Error 'The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement' on query");
|
|
CALL mtr.add_suppression("InnoDB: Error: Table \"mysql\"\\.\"innodb_index_stats\" not found");
|
|
CALL mtr.add_suppression("Can't open and lock time zone table");
|
|
CALL mtr.add_suppression("Can't open and lock privilege tables");
|
|
CALL mtr.add_suppression("Info table is not ready to be used");
|
|
CALL mtr.add_suppression("Native table .* has the wrong structure");
|