galera.galera_sst_mysqldump_with_key 'innodb_plugin,release' [ fail ]
|
Test ended at 2018-08-02 15:18:28
|
|
CURRENT_TEST: galera.galera_sst_mysqldump_with_key
|
--- /usr/share/mysql/mysql-test/suite/galera/r/galera_sst_mysqldump_with_key.result 2018-08-02 14:30:47.000000000 -0400
|
+++ /dev/shm/var/log/galera_sst_mysqldump_with_key.reject 2018-08-02 15:18:28.514178337 -0400
|
@@ -183,103 +183,6 @@
|
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_dbug = '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;
|
-SET GLOBAL debug_dbug = $debug_orig;
|
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");
|
|
mysqltest: Result length mismatch
|
|
- saving '/dev/shm/var/log/galera.galera_sst_mysqldump_with_key-innodb_plugin,release/' to '/dev/shm/var/log/galera.galera_sst_mysqldump_with_key-innodb_plugin,release/'
|
***Warnings generated in error logs during shutdown after running tests: galera.galera_sst_mysqldump_with_key
|
|
2018-08-02 15:17:08 281473283062592 [Warning] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, set bind_address to allow mysql client connections from other cluster members (e.g. 0.0.0.0).
|
2018-08-02 15:17:54 281473280240448 [Warning] WSREP: wsrep_sst_method is set to 'mysqldump' yet mysqld bind_address is set to '127.0.0.1', which makes it impossible to receive state transfer from another node, since mysqld won't accept such connections. If you wish to use mysqldump state transfer method, set bind_address to allow mysql client connections from other cluster members (e.g. 0.0.0.0).
|