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

galera.galera_ftwrl_drain fails with wrong errno 1146

Details

    Description

      10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33

      galera.galera_ftwrl_drain 'innodb'       [ fail ]
              Test ended at 2021-07-08 01:30:37
       
      CURRENT_TEST: galera.galera_ftwrl_drain
      mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205...
       
      The result from queries just before the failure was:
      < snip >
      INSERT INTO t1 VALUES (1);
      connection node_2;
      SET SESSION wsrep_sync_wait = 0;
      SET SESSION wsrep_on = 0;
      SET SESSION wsrep_on = 1;
      SELECT COUNT(*) = 0 FROM t1;
      COUNT(*) = 0
      1
      connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
      connection node_2a;
      FLUSH TABLES WITH READ LOCK;;
      connection node_2;
      SET GLOBAL wsrep_provider_options = 'dbug=';
      SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
      connection node_2a;
      connection node_2;
      SET SESSION lock_wait_timeout = 1;
      SET SESSION innodb_lock_wait_timeout=1;
      SET SESSION wait_timeout=1;
      INSERT INTO t2 VALUES (2);
      

      Reproducible on 10.2/10.3 ES.
      I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check.

      Attachments

        Activity

          elenst Elena Stepanova created issue -
          elenst Elena Stepanova made changes -
          Field Original Value New Value
          Description {code:sql|title=10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33}
          galera.galera_ftwrl_drain 'innodb' [ fail ]
                  Test ended at 2021-07-08 01:30:37

          CURRENT_TEST: galera.galera_ftwrl_drain
          mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205...

          The result from queries just before the failure was:
          < snip >
          INSERT INTO t1 VALUES (1);
          connection node_2;
          SET SESSION wsrep_sync_wait = 0;
          SET SESSION wsrep_on = 0;
          SET SESSION wsrep_on = 1;
          SELECT COUNT(*) = 0 FROM t1;
          COUNT(*) = 0
          1
          connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
          connection node_2a;
          FLUSH TABLES WITH READ LOCK;;
          connection node_2;
          SET GLOBAL wsrep_provider_options = 'dbug=';
          SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
          connection node_2a;
          connection node_2;
          SET SESSION lock_wait_timeout = 1;
          SET SESSION innodb_lock_wait_timeout=1;
          SET SESSION wait_timeout=1;
          INSERT INTO t2 VALUES (2);
          {noformat}

          Reproducible on 10.2/10.3 ES.
          I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check.
          {code:sql|title=10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33}
          galera.galera_ftwrl_drain 'innodb' [ fail ]
                  Test ended at 2021-07-08 01:30:37

          CURRENT_TEST: galera.galera_ftwrl_drain
          mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205...

          The result from queries just before the failure was:
          < snip >
          INSERT INTO t1 VALUES (1);
          connection node_2;
          SET SESSION wsrep_sync_wait = 0;
          SET SESSION wsrep_on = 0;
          SET SESSION wsrep_on = 1;
          SELECT COUNT(*) = 0 FROM t1;
          COUNT(*) = 0
          1
          connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
          connection node_2a;
          FLUSH TABLES WITH READ LOCK;;
          connection node_2;
          SET GLOBAL wsrep_provider_options = 'dbug=';
          SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync';
          connection node_2a;
          connection node_2;
          SET SESSION lock_wait_timeout = 1;
          SET SESSION innodb_lock_wait_timeout=1;
          SET SESSION wait_timeout=1;
          INSERT INTO t2 VALUES (2);
          {code}

          Reproducible on 10.2/10.3 ES.
          I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check.

          It fails constantly in Jenkins.

          elenst Elena Stepanova added a comment - It fails constantly in Jenkins.
          elenst Elena Stepanova made changes -
          Labels affects-tests
          julien.fritsch Julien Fritsch made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Julius Goryavsky [ sysprg ] Jan Lindström [ jplindst ]
          jplindst Jan Lindström (Inactive) made changes -
          Component/s Debug [ 14208 ]
          Component/s Galera [ 10124 ]
          Component/s Tests [ 10800 ]
          Component/s Debug [ 14936 ]
          Component/s Galera [ 14918 ]
          Component/s Tests [ 14999 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.3 [ 23605 ]
          Fix Version/s 10.2 [ 23606 ]
          Key MENT-1257 MDEV-26815
          Affects Version/s 10.2 [ 14601 ]
          Affects Version/s 10.3 [ 22126 ]
          Affects Version/s 10.3 [ 23605 ]
          Affects Version/s 10.2 [ 23606 ]
          Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2021-10-13 14:09:00.0 2021-10-13 14:09:00.99
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.2.41 [ 26032 ]
          Fix Version/s 10.3.32 [ 26029 ]
          Fix Version/s 10.4.22 [ 26031 ]
          Fix Version/s 10.5.13 [ 26026 ]
          Fix Version/s 10.6.5 [ 26034 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 123330 ] MariaDB v4 [ 159493 ]
          elenst Elena Stepanova made changes -

          People

            jplindst Jan Lindström (Inactive)
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.