[Commits] e78249590b8: Merge remote-tracking branch 'origin/10.1' into 10.2
revision-id: e78249590b8230fe3224caf35ec8a302d7915c7c (mariadb-10.2.19-14-ge78249590b8) parent(s): b86e18cb44fd4ab42c08e4b7aae1b7e131a3ea46 41fa9a598655a15b423a7453eba5acaf5bd5d324 author: Jan Lindström committer: Jan Lindström timestamp: 2018-11-21 13:54:45 +0200 message: Merge remote-tracking branch 'origin/10.1' into 10.2 mysql-test/suite/galera/disabled.def | 6 +- .../galera/r/galera_autoinc_sst_mariabackup.result | 47 ++++ .../galera/r/galera_ist_mariabackup,debug.rdiff | 114 ++++++++ .../suite/galera/r/galera_ist_mariabackup.result | 287 +++++++++++++++++++++ ...a_ist_mariabackup_innodb_flush_logs,debug.rdiff | 114 ++++++++ ...galera_ist_mariabackup_innodb_flush_logs.result | 96 +++++++ .../galera_sst_mariabackup_encrypt_with_key.result | 3 + .../r/galera_sst_mysqldump_with_key,debug.rdiff | 106 ++++++++ .../galera/r/galera_sst_mysqldump_with_key.result | 108 -------- mysql-test/suite/galera/r/partition.result | 18 +- .../galera/t/galera_autoinc_sst_mariabackup.cnf | 12 + .../galera/t/galera_autoinc_sst_mariabackup.test | 96 +++++++ .../suite/galera/t/galera_ist_mariabackup.cnf | 12 + .../suite/galera/t/galera_ist_mariabackup.test | 16 ++ .../t/galera_ist_mariabackup_innodb_flush_logs.cnf | 14 + .../galera_ist_mariabackup_innodb_flush_logs.test | 12 + .../t/galera_sst_mariabackup_encrypt_with_key.cnf | 12 + .../t/galera_sst_mariabackup_encrypt_with_key.test | 14 + mysql-test/suite/galera/t/partition.test | 14 +- 19 files changed, 980 insertions(+), 121 deletions(-) diff --cc mysql-test/suite/galera/disabled.def index a8cb9bbafbf,94256dd88d7..10b0a0fdb98 --- a/mysql-test/suite/galera/disabled.def +++ b/mysql-test/suite/galera/disabled.def @@@ -27,19 -27,10 +27,23 @@@ galera_ssl_upgrade : MDEV-13549 Galera galera.MW-329 : wsrep_local_replays not stable MW-416 : MDEV-13549 Galera test failures MW-388 : MDEV-13549 Galera test failures +galera.MW-44 : MDEV-15809 Test failure on galera.MW-44 +galera.galera_pc_ignore_sb : MDEV-15811 Test failure on galera_pc_ignore_sb +galera_kill_applier : race condition at the start of the test +galera_ist_progress: MDEV-15236 galera_ist_progress fails when trying to read transfer status +pxc-421: Lock timeout exceeded galera_sst_mysqldump_with_key : MDEV-16890 Galera test failure +galera.galera_binlog_stmt_autoinc : MDEV-17106 Test failure on galera.galera_binlog_stmt_autoinc +galera.galera_kill_ddl : MDEV-17108 Test failure on galera.galera_kill_ddl +galera.galera_var_node_address : MDEV-17151 Galera test failure on galera.galera_var_node_address galera_binlog_stmt_autoinc: MDEV-17106 Test failure on galera.galera_binlog_stmt_autoinc galera_gc_fc_limit : MDEV-17061 Test failure on galera.galera_gc_fc_limit - partition : MDEV-13881 galera.partition failed in buildbot with wrong result galera_as_slave_replication_budle : MDEV-15785 Test case galera_as_slave_replication_bundle caused debug assertion galera_wan : MDEV-17259: Test failure on galera.galera_wan galera_pc_ignore_sb : MDEV-17357 Test failure on galera.galera_pc_ignore_sb galera_drop_database : test ++galera_sst_xtrabackup-v2_data_dir : xtrabackup is deprecated ++galera_sst_xtrabackup-v2_encrypt_with_key : xtrabackup is deprecated ++galera_sst_xtrabackup-v2-options : xtrabackup is deprecated ++galera_sst_xtrabackup-v2 : xtrabackup is deprecated ++galera_autoinc_sst_xtrabackup : xtrabackup is deprecated diff --cc mysql-test/suite/galera/r/galera_autoinc_sst_mariabackup.result index 00000000000,228d7c6f041..d0fac1e3d14 mode 000000,100644..100644 --- a/mysql-test/suite/galera/r/galera_autoinc_sst_mariabackup.result +++ b/mysql-test/suite/galera/r/galera_autoinc_sst_mariabackup.result @@@ -1,0 -1,36 +1,47 @@@ ++connection node_1; + CREATE TABLE t1 (f1 INTEGER PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB; + CREATE PROCEDURE p1 () + BEGIN + DECLARE x INT DEFAULT 1; + DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END; + WHILE 1 DO + INSERT INTO t1 VALUES (DEFAULT); + COMMIT; + END WHILE; + END| + CALL p1();; ++connection node_2; + CALL p1();; ++connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2; ++connection node_2a; + Killing server ... + INSERT INTO t1 VALUES (DEFAULT); ++connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1; ++connection node_1a; + INSERT INTO t1 VALUES (DEFAULT); ++connection node_1; + Got one of the listed errors ++connection node_2; + Got one of the listed errors ++connection node_1a; ++connection node_2a; + count_equal + 1 + CALL mtr.add_suppression("WSREP: Action message in non-primary configuration from member 0"); + SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'; + VARIABLE_VALUE + 2 + SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'; + VARIABLE_VALUE = 2 + 1 ++connection node_1a; + SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'; + VARIABLE_VALUE + 2 + SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'; + VARIABLE_VALUE = 2 + 1 + DROP PROCEDURE p1; + DROP TABLE t1; + CALL mtr.add_suppression("gcs_caused\\(\\) returned -1 \\(Operation not permitted\\)"); + CALL mtr.add_suppression("WSREP: Action message in non-primary configuration from member 0"); diff --cc mysql-test/suite/galera/r/galera_ist_mariabackup,debug.rdiff index 00000000000,1c787cd2fef..23d2e52e196 mode 000000,100644..100644 --- a/mysql-test/suite/galera/r/galera_ist_mariabackup,debug.rdiff +++ b/mysql-test/suite/galera/r/galera_ist_mariabackup,debug.rdiff @@@ -1,0 -1,103 +1,114 @@@ ---- r/galera_ist_mariabackup.result 2018-11-19 15:15:21.093874145 +0200 -+++ r/galera_ist_mariabackup.reject 2018-11-19 16:25:52.220523327 +0200 -@@ -259,3 +259,100 @@ ++--- r/galera_ist_mariabackup.result 2018-11-21 08:59:49.349536948 +0200 +++++ r/galera_ist_mariabackup.reject 2018-11-21 13:29:54.520133456 +0200 ++@@ -285,3 +285,111 @@ + 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 +++connection node_1; + +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'); +++connection node_2; + +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_dbug = 'd,sync.alter_opened_table'; +++connection node_1; + +ALTER TABLE t1 ADD COLUMN f2 INTEGER; +++connection node_2; + +SET wsrep_sync_wait = 0; + +Killing server ... +++connection node_1; + +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'); +++connect node_1a_galera_st_kill_slave_ddl, 127.0.0.1, root, , test, $NODE_MYPORT_1; + +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'); +++connection node_2; + +Performing --wsrep-recover ... +++connection node_2; + +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; +++connection node_1; + +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; +++connection node_1a_galera_st_kill_slave_ddl; + +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; +++connection node_1; + +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; + +SET GLOBAL debug_dbug = $debug_orig; diff --cc mysql-test/suite/galera/r/galera_ist_mariabackup.result index 00000000000,099d944d491..8a7c02ab1b6 mode 000000,100644..100644 --- a/mysql-test/suite/galera/r/galera_ist_mariabackup.result +++ b/mysql-test/suite/galera/r/galera_ist_mariabackup.result @@@ -1,0 -1,261 +1,287 @@@ ++connection node_1; ++connection node_2; + Performing State Transfer on a server that has been temporarily disconnected ++connection node_1; + 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; ++connection node_2; + 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'; ++connection node_1; + 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'); ++connect node_1a_galera_st_disconnect_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1; + 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'); ++connection node_2; + 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; ++connection node_1; + 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; ++connection node_1a_galera_st_disconnect_slave; + 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; ++connection node_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; + Performing State Transfer on a server that has been shut down cleanly and restarted ++connection node_1; + 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; ++connection node_2; + 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 ... ++connection node_1; + 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'); ++connect node_1a_galera_st_shutdown_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1; + 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'); ++connection node_2; + 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; ++connection node_1; + 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; ++connection node_1a_galera_st_shutdown_slave; + 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; ++connection node_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; + Performing State Transfer on a server that has been killed and restarted ++connection node_1; + 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; ++connection node_2; + 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 ... ++connection node_1; + 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'); ++connect node_1a_galera_st_kill_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1; + 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'); ++connection node_2; + 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; ++connection node_1; + 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; ++connection node_1a_galera_st_kill_slave; + 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; ++connection node_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; diff --cc mysql-test/suite/galera/r/galera_ist_mariabackup_innodb_flush_logs,debug.rdiff index 00000000000,d85d3bdad75..bda006e9aed mode 000000,100644..100644 --- a/mysql-test/suite/galera/r/galera_ist_mariabackup_innodb_flush_logs,debug.rdiff +++ b/mysql-test/suite/galera/r/galera_ist_mariabackup_innodb_flush_logs,debug.rdiff @@@ -1,0 -1,103 +1,114 @@@ ---- r/galera_ist_mariabackup_innodb_flush_logs.result 2018-11-19 15:21:15.429784085 +0200 -+++ r/galera_ist_mariabackup_innodb_flush_logs.reject 2018-11-19 16:27:43.100491616 +0200 -@@ -86,3 +86,100 @@ ++--- r/galera_ist_mariabackup_innodb_flush_logs.result 2018-11-21 09:00:28.081526942 +0200 +++++ r/galera_ist_mariabackup_innodb_flush_logs.reject 2018-11-21 13:30:56.432119642 +0200 ++@@ -94,3 +94,111 @@ + 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 +++connection node_1; + +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'); +++connection node_2; + +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_dbug = 'd,sync.alter_opened_table'; +++connection node_1; + +ALTER TABLE t1 ADD COLUMN f2 INTEGER; +++connection node_2; + +SET wsrep_sync_wait = 0; + +Killing server ... +++connection node_1; + +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'); +++connect node_1a_galera_st_kill_slave_ddl, 127.0.0.1, root, , test, $NODE_MYPORT_1; + +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'); +++connection node_2; + +Performing --wsrep-recover ... +++connection node_2; + +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; +++connection node_1; + +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; +++connection node_1a_galera_st_kill_slave_ddl; + +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; +++connection node_1; + +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; + +SET GLOBAL debug_dbug = $debug_orig; diff --cc mysql-test/suite/galera/r/galera_ist_mariabackup_innodb_flush_logs.result index 00000000000,e3bf407ddaa..7813b5a58fc mode 000000,100644..100644 --- a/mysql-test/suite/galera/r/galera_ist_mariabackup_innodb_flush_logs.result +++ b/mysql-test/suite/galera/r/galera_ist_mariabackup_innodb_flush_logs.result @@@ -1,0 -1,88 +1,96 @@@ + Performing State Transfer on a server that has been killed and restarted ++connection node_1; + 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; ++connection node_2; + 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 ... ++connection node_1; + 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'); ++connect node_1a_galera_st_kill_slave, 127.0.0.1, root, , test, $NODE_MYPORT_1; + 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'); ++connection node_2; + 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; ++connection node_1; + 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; ++connection node_1a_galera_st_kill_slave; + 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; ++connection node_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; diff --cc mysql-test/suite/galera/r/galera_sst_mysqldump_with_key.result index 02dde169911,bdf3844f2c5..de52ac2fd1d --- a/mysql-test/suite/galera/r/galera_sst_mysqldump_with_key.result +++ b/mysql-test/suite/galera/r/galera_sst_mysqldump_with_key.result @@@ -204,120 -183,12 +204,12 @@@ COUNT(*) = 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 - connection node_1; - 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'); - connection node_2; - 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_dbug = 'd,sync.alter_opened_table'; - connection node_1; - ALTER TABLE t1 ADD COLUMN f2 INTEGER; - connection node_2; - SET wsrep_sync_wait = 0; - Killing server ... - connection node_1; - 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'); - connect node_1a_galera_st_kill_slave_ddl, 127.0.0.1, root, , test, $NODE_MYPORT_1; - 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'); - connection node_2; - Performing --wsrep-recover ... - connection node_2; - 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; - connection node_1; - 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; - connection node_1a_galera_st_kill_slave_ddl; - 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; - connection node_1; - 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; - SET GLOBAL debug_dbug = $debug_orig; +connection node_1; 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; +connection node_2; 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("InnoDB: New log files created"); -CALL mtr.add_suppression("InnoDB: Creating foreign key constraint system tables"); 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"); diff --cc mysql-test/suite/galera/r/partition.result index 3835de514aa,6b0868aab3e..bdf6df25589 --- a/mysql-test/suite/galera/r/partition.result +++ b/mysql-test/suite/galera/r/partition.result @@@ -118,10 -109,9 +118,10 @@@ connection node_1 SET GLOBAL wsrep_load_data_splitting = ON; CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2; +connection node_2; - SELECT COUNT(*) = 20002 FROM t1; - COUNT(*) = 20002 - 1 + SELECT COUNT(*) FROM t1; + COUNT(*) + 20002 wsrep_last_committed_diff 1 DROP TABLE t1; @@@ -130,10 -119,9 +130,10 @@@ connection node_1 SET GLOBAL wsrep_load_data_splitting = ON; CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2; +connection node_2; - SELECT COUNT(*) = 101 FROM t1; - COUNT(*) = 101 - 1 + SELECT COUNT(*) FROM t1; + COUNT(*) + 101 wsrep_last_committed_diff 1 DROP TABLE t1; @@@ -143,10 -130,9 +143,10 @@@ connection node_1 SET GLOBAL wsrep_load_data_splitting = OFF; CREATE TABLE t1 (pk INT PRIMARY KEY) ENGINE=INNODB PARTITION BY HASH(pk) PARTITIONS 2; +connection node_2; - SELECT COUNT(*) = 20002 FROM t1; - COUNT(*) = 20002 - 1 + SELECT COUNT(*) FROM t1; + COUNT(*) + 20002 wsrep_last_committed_diff 1 DROP TABLE t1;
participants (1)
-
jan