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

galera_bf_abort_at_after_statement MTR failed: query 'reap' succeeded - should have failed with errno 1213

Details

    Description

      galera_bf_abort_at_after_statement failed on bb: "query 'reap' succeeded - should have failed with errno 1213".

      stdio.log:

      10.4.12 8a931e4d16303b76e4744428faaab7b200f408ec

      galera.galera_bf_abort_at_after_statement 'innodb' w2 [ fail ]
              Test ended at 2020-01-22 18:17:49
       
      CURRENT_TEST: galera.galera_bf_abort_at_after_statement
      mysqltest: At line 32: query 'reap' succeeded - should have failed with errno 1213...
       
      The result from queries just before the failure was:
      < snip >
      INSERT INTO t1 VALUES (1, 1);
      connection node_2;
      START TRANSACTION;
      SET DEBUG_SYNC = 'wsrep_after_statement_enter SIGNAL blocked WAIT_FOR continue';
      UPDATE t1 SET val=2 WHERE id=1;
      connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
      SET DEBUG_SYNC = 'now WAIT_FOR blocked';
      connection node_1;
      UPDATE t1 SET val=3 WHERE id=1;
      connection node_2a;
      SET DEBUG_SYNC = 'now SIGNAL continue';
      connection node_2;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/galera_bf_abort_at_after_statement.log
       
       - saving '/dev/shm/var/2/log/galera.galera_bf_abort_at_after_statement-innodb/' to '/dev/shm/var/log/galera.galera_bf_abort_at_after_statement-innodb/'
       
      Retrying test galera.galera_bf_abort_at_after_statement, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      galera.galera_var_auto_inc_control_off 'innodb' w1 [ pass ]   4041
      galera.galera_var_certify_nonPK_off 'innodb' w1 [ pass ]   2037
      galera.galera_bf_abort_at_after_statement 'innodb' w2 [ retry-pass ]   2096
       
      Retrying test galera.galera_bf_abort_at_after_statement, attempt(3/3)...
       
      galera.galera_bf_abort_at_after_statement 'innodb' w2 [ retry-pass ]   2039
      

      Attachments

        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 ]

          It failed also on bb, 10.5.

          stepan.patryshev Stepan Patryshev (Inactive) added a comment - It failed also on bb, 10.5 .
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Affects Version/s 10.5.2 [ 24030 ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Fix Version/s 10.5 [ 23123 ]
          jplindst Jan Lindström (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 103301 ] MariaDB v4 [ 144543 ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2022-05-03 06:26:00.0 2022-05-03 06:26:00.641
          jplindst Jan Lindström (Inactive) 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.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          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.