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

galera_3nodes.galera_wsrep_schema MTR failed: mysql_shutdown failed

Details

    Description

      galera_3nodes.galera_wsrep_schema failed on BB 10.4 and BB 10.5: "mysql_shutdown failed".

      stdio.log:

      10.4.15 571764c04fc9b736366959b2c0e00d9bd0eb5a4e

      galera_3nodes.galera_wsrep_schema 'innodb' w2 [ fail ]
              Test ended at 2020-08-26 14:43:12
       
      CURRENT_TEST: galera_3nodes.galera_wsrep_schema
      mysqltest: In included file "./include/shutdown_mysqld.inc": 
      included from /usr/share/mysql-test/suite/galera_3nodes/t/galera_wsrep_schema.test at line 52:
      At line 40: mysql_shutdown failed
       
      The result from queries just before the failure was:
      < snip >
      SELECT COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size') FROM mysql.wsrep_cluster_members;
      COUNT(*) = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size')
      1
      SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
      COUNT(*) = 1
      1
      SELECT node_incoming_address LIKE '127.0.0.1:%' from mysql.wsrep_cluster_members;
      node_incoming_address LIKE '127.0.0.1:%'
      1
      1
      1
      SELECT cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid') FROM mysql.wsrep_cluster_members;
      cluster_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_state_uuid')
      1
      1
      1
      SELECT COUNT(*) = 1 FROM mysql.wsrep_cluster_members WHERE node_uuid = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_gcomm_uuid');
      COUNT(*) = 1
      1
      connection node_2;
      

      Attachments

        Issue Links

          Activity

            stepan.patryshev Stepan Patryshev (Inactive) created issue -
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Field Original Value New Value
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Assignee Stepan Patryshev [ stepan.patryshev ] Jan Lindström [ jplindst ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Fix Version/s 10.6 [ 24028 ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Affects Version/s 10.6.0 [ 24431 ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            Attachment MDEV-23595_104_logs_201202.zip [ 55451 ]
            stepan.patryshev Stepan Patryshev (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.6 [ 24028 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 112972 ] MariaDB v4 [ 142216 ]
            jplindst Jan Lindström (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            jplindst Jan Lindström (Inactive) made changes -
            issue.field.resolutiondate 2022-05-16 12:11:39.0 2022-05-16 12:11:39.518
            jplindst Jan Lindström (Inactive) made changes -
            Fix Version/s 10.4.26 [ 27511 ]
            Fix Version/s 10.5.17 [ 27509 ]
            Fix Version/s 10.6.9 [ 27507 ]
            Fix Version/s 10.7.5 [ 27505 ]
            Fix Version/s 10.8.4 [ 27503 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.4.25 [ 27510 ]
            Fix Version/s 10.5.16 [ 27508 ]
            Fix Version/s 10.6.8 [ 27506 ]
            Fix Version/s 10.7.4 [ 27504 ]
            Fix Version/s 10.8.3 [ 27502 ]
            Fix Version/s 10.8.4 [ 27503 ]
            Fix Version/s 10.7.5 [ 27505 ]
            Fix Version/s 10.6.9 [ 27507 ]
            Fix Version/s 10.5.17 [ 27509 ]
            Fix Version/s 10.4.26 [ 27511 ]
            julien.fritsch Julien Fritsch made changes -

            People

              jplindst Jan Lindström (Inactive)
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.