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

no expected deadlock in galera_insert_bulk test

    XMLWordPrintable

Details

    • Bug
    • Status: In Testing (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.6
    • 10.6
    • Galera
    • None

    Description

      No expected deadlock in galera_insert_bulk test:

      galera.galera_insert_bulk 'innodb'       w2 [ fail ]
              Test ended at 2023-02-01 14:06:22
       
      CURRENT_TEST: galera.galera_insert_bulk
      mysqltest: At line 42: query 'COMMIT' succeeded - should have failed with error ER_LOCK_DEADLOCK (1213)...
       
      The result from queries just before the failure was:
      < snip >
      connection node_1;
      connection node_1;
      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
      SET foreign_key_checks = 0;
      SET unique_checks = 0;
      START TRANSACTION;
      connection node_2;
      SET foreign_key_checks = 1;
      SET unique_checks = 1;
      INSERT INTO t1 VALUES (1001);
      connection node_1;
      COMMIT;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/galera_insert_bulk.log

      Attachments

        1. mysqld.1.err
          308 kB
        2. mysqld.2.err
          106 kB

        Issue Links

          Activity

            People

              sysprg Julius Goryavsky
              sysprg Julius Goryavsky
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.