Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.3.6
-
CentOS 7.4
Description
galera mtr test galera_ist_rsync from galera test suite fails with result length mismatch
failure is not sporadic, test fails all times
checked on RC mariadb-10.3.6-76-g461de7e
MariaDB Version 10.3.7-MariaDB
$ ./mysql-test-run.pl galera.galera_ist_rsync
|
Logging: /home/qa-user1/rr/server/mysql-test/mysql-test-run.pl galera.galera_ist_rsync
|
vardir: /home/qa-user1/rr/build-mariadb/mysql-test/var
|
Checking leftover processes...
|
Removing old var directory...
|
Creating var directory '/home/qa-user1/rr/build-mariadb/mysql-test/var'...
|
Checking supported features...
|
MariaDB Version 10.3.7-MariaDB
|
- SSL connections supported
|
Collecting tests...
|
Installing system database...
|
|
==============================================================================
|
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
|
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
|
galera.galera_ist_rsync 'innodb,release' [ fail ]
|
Test ended at 2018-04-30 10:39:41
|
|
CURRENT_TEST: galera.galera_ist_rsync
|
--- /home/qa-user1/rr/server/mysql-test/suite/galera/r/galera_ist_rsync.result 2018-04-23 18:14:30.275304161 +0300
|
+++ /home/qa-user1/rr/server/mysql-test/suite/galera/r/galera_ist_rsync.reject 2018-04-30 10:39:41.103909712 +0300
|
@@ -285,111 +285,3 @@
|
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;
|
|
mysqltest: Result length mismatch
|
|