Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16059

galera mtr test galera_ist_rsync fails with result length mismatch

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.3.6
    • N/A
    • Galera, Tests
    • 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
      
      

      Attachments

        Activity

          People

            stepan.patryshev Stepan Patryshev (Inactive)
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.