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

galera_sr.galera_sr_rollback_retry MTR failed: 1213: Deadlock found when trying to get lock

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.15
    • 10.4.16, 10.5.7, 10.6.0
    • Galera, Tests
    • None
    • kvm-deb-stretch-x86

    Description

      galera_sr.galera_sr_rollback_retry failed on BB 10.4: "1213: Deadlock found when trying to get lock".
      It seems to be a sporadic issue.

      stdio.log:

      10.4.15 2000d05c2ed85563e35c4548d9518249ddf403df

      		 
      galera_sr.galera_sr_rollback_retry 'innodb' w2 [ fail ]
      		 
              Test ended at 2020-08-25 01:56:06
      		 
       
      		 
      CURRENT_TEST: galera_sr.galera_sr_rollback_retry
      		 
      mysqltest: In included file "./include/have_wsrep_enabled.inc": 
      included from ./include/galera_init.inc at line 15:
      		 
      included from ./include/galera_cluster.inc at line 11:
      		 
      included from /usr/share/mysql/mysql-test/suite/galera_sr/t/galera_sr_rollback_retry.test at line 2:
      		 
      At line 6: query 'if (`SELECT COUNT(*)=0 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME = 'wsrep_on' AND VARIABLE_VALUE='ON'`)
      		 
      {' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
      		 
       
      		 
       - skipping '/dev/shm/var/2/log/galera_sr.galera_sr_rollback_retry-innodb/'
      		 
       
      		 
      Retrying test galera_sr.galera_sr_rollback_retry, attempt(2/3)...

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Jan Lindström (Inactive) made transition -
          Open In Progress
          		16d 20h 9m 1
          Jan Lindström (Inactive) made transition -
          In Progress Closed
          		11h 51m 1

          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.