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

Galera test failure on galera_autoinc_sst_mariabackup

Details

    Description

      galera.galera_autoinc_sst_mariabackup 'innodb' w8 [ fail ]
      		 
              Test ended at 2019-01-09 09:09:13
      		 
       
      		 
      CURRENT_TEST: galera.galera_autoinc_sst_mariabackup
      		 
      mysqltest: In included file "./include/galera_wait_ready.inc": 
      included from /home/jan/mysql/10.4-galera-2/mysql-test/suite/galera/include/start_mysqld.inc at line 16:
      		 
      included from /home/jan/mysql/10.4-galera-2/mysql-test/suite/galera/t/galera_autoinc_sst_mariabackup.test at line 50:
      		 
      At line 28: "Server did not transition to READY state"
      		 
       
      		 
      The result from queries just before the failure was:
      		 
      < snip >
      		 
      connection node_1;
      		 
      connection node_1;
      		 
      connection node_2;
      		 
      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 ...
      		 
       
      		 
      More results from queries before failure can be found in /home/jan/mysql/10.4-galera-2/mysql-test/var/8/log/galera_autoinc_sst_mariabackup.log

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-17458 Unable to Start Galera Node

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            stepan.patryshev Stepan Patryshev (Inactive) added a comment - - edited

            I found the following [ERROR] in mysqld.2.err:

            2019-10-20 12:10:56 0 [ERROR] WSREP: gcs/src/gcs_state_msg.cpp:gcs_state_msg_get_quorum():947: Failed to establish quorum.
            		 
            2019-10-20 12:10:56 0 [Note] WSREP: Quorum results:
            		 
            	version    = 6,
            		 
            	component  = NON-PRIMARY,
            		 
            	conf_id    = -1,
            		 
            	members    = 0/1 (joined/total),
            		 
            	act_id     = -1,
            		 
            	last_appl. = -1,
            		 
            	protocols  = -1/-1/-1 (gcs/repl/appl),
            		 
            	vote policy= 1,
            		 
            	group UUID = 00000000-0000-0000-0000-000000000000

            All logs: 191023_galera_autoinc_sst_mariabackup.zip.

            Reproduced on:

            MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 421d52e89627d85794d7e8e4b70216b14f384178; debug built from sources.

            Galera 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - - edited I found the following [ERROR] in mysqld.2.err: 2019-10-20 12:10:56 0 [ERROR] WSREP: gcs/src/gcs_state_msg.cpp:gcs_state_msg_get_quorum():947: Failed to establish quorum. 2019-10-20 12:10:56 0 [Note] WSREP: Quorum results: version = 6, component = NON-PRIMARY, conf_id = -1, members = 0/1 (joined/total), act_id = -1, last_appl. = -1, protocols = -1/-1/-1 (gcs/repl/appl), vote policy= 1, group UUID = 00000000-0000-0000-0000-000000000000 All logs: 191023_galera_autoinc_sst_mariabackup.zip . Reproduced on: MariaDB Version 10.4.9-MariaDB-debug: Repository: MariaDB/server; branch 10.4; Revision 421d52e89627d85794d7e8e4b70216b14f384178; debug built from sources. Galera 26.4.3(r4535): Repository: MariaDB/galera; branch mariadb-4.x; Revision 752664dc3c7065d8e0c73ac99d0028a5f84eb250; debug built from sources.
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            It failed also on Azure: "MariaDBEnterprise - MTR" pipeline, run: #20191122.3.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - It failed also on Azure: "MariaDBEnterprise - MTR" pipeline, run: #20191122.3.
            stepan.patryshev Stepan Patryshev (Inactive) added a comment -

            Increased the priority since it failed on Azure.

            stepan.patryshev Stepan Patryshev (Inactive) added a comment - Increased the priority since it failed on Azure.

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (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.