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

galera.galera_mdev_15611 MTR failed: Aborting on MDL BF-BF conflict

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4.18
    • N/A
    • Galera, Tests
    • None
    • kvm-deb-bionic-aarch64

    Description

      galera.galera_mdev_15611 failed on BB 10.4 CS: Aborting on MDL BF-BF conflict.
      It seems to be a sporadic issue.

      stdio.log:

      10.4.18, 1398160a719394cff3e7e4ee214f51375e8825a1, kvm-deb-bionic-aarch64

      galera.galera_mdev_15611 'innodb'        w1 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2021-01-26 12:04:01
      line
      2021-01-26 12:03:34 12 [ERROR] Aborting
      ^ Found warnings in /dev/shm/var/1/log/mysqld.2.err
      ok
       
       - saving '/dev/shm/var/1/log/galera.galera_mdev_15611-innodb/' to '/dev/shm/var/log/galera.galera_mdev_15611-innodb/'
       
      Retrying test galera.galera_mdev_15611, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      

      mysqld.2.err.1:

      10.4.18, 1398160a719394cff3e7e4ee214f51375e8825a1, kvm-deb-bionic-aarch64

      2021-01-26 12:03:34 12 [Note] WSREP: MDL BF-BF conflict
      schema:  test
      request: (12 	seqno 5 	wsrep (high priority, exec, executing) cmd 0 161 	insert into t1 select 1fK`)
      granted: (11 	seqno 4 	wsrep (toi, exec, executing) cmd 0 1 	CREATE TABLE t2 (
      id int primary key ,
      f_id int DEFAULT NULL, FOREIGN KEY(f_id)  REFERENCES t1 (id)
      ))
      2021-01-26 12:03:34 12 [ERROR] Aborting 
      

      Server logs.

      Attachments

        Activity

          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.