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

ER_LOCK_DEADLOCK instead of ER_NO_SUCH_TABLE in galera_var_ignore_apply_errors

    XMLWordPrintable

Details

    • Bug
    • Status: In Review (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.5
    • 10.5, 10.6
    • Galera, Tests
    • None

    Description

      ER_LOCK_DEADLOCK instead of ER_NO_SUCH_TABLE in galera.galera_var_ignore_apply_errors test:

      galera.galera_var_ignore_apply_errors    w4 [ fail ]
              Test ended at 2024-11-18 06:11:57
       
      CURRENT_TEST: galera.galera_var_ignore_apply_errors
      mysqltest: At line 263: query 'SELECT * FROM t1' failed with wrong errno ER_LOCK_DEADLOCK (1213): 'Deadlock found when trying to get lock; try restarting transaction', instead of ER_NO_SUCH_TABLE (1146)...
       
      The result from queries just before the failure was:
      < snip >
      VARIABLE_VALUE = 'Primary'
      1
      SELECT COUNT(*) AS expect_0 FROM parent;
      expect_0
      0
      SELECT COUNT(*) AS expect_0 FROM child;
      expect_0
      0
      DROP TABLE child, parent;
      connection node_2;
      SET GLOBAL wsrep_ignore_apply_errors = 4;
      connection node_2;
      SET GLOBAL wsrep_on = OFF;
      CREATE TABLE t1 (f1 INTEGER);
      SET GLOBAL wsrep_on = ON;
      connection node_1;
      CREATE TABLE t1 (f1 INTEGER, f2 INTEGER);
      DROP TABLE t1;
      connection node_2;
      SELECT * FROM t1;
       
      More results from queries before failure can be found in /dev/shm/var/4/log/galera_var_ignore_apply_errors.log
       
       - saving '/dev/shm/var/4/log/galera.galera_var_ignore_apply_errors/' to '/dev/shm/var/log/galera.galera_var_ignore_apply_errors/

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            sysprg Julius Goryavsky
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.