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

galera.galera_ftwrl_drain fails with wrong errno 1146

    XMLWordPrintable

    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

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration