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

Galera test failure on galera_sst_mysqldump_with_key

    XMLWordPrintable

    Details

      Description

      e.g on http://buildbot.askmonty.org/buildbot/builders/kvm-deb-xenial-amd64/builds/3793

      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).
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jplindst Jan Lindström
                Reporter:
                jplindst Jan Lindström
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: