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

GCF-1060 test hangs when SR transaction deadlocks trying to complete rollback

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.32
    • 10.4
    • Galera
    • None

    Description

      Local SR transaction gets aborted:

      2023-12-28 14:56:16 10 [Note] WSREP: MDL conflict·
      schema:  test
      request: (10    seqno 57    wsrep (toi, exec, aborted) cmd 3 8  TRUNCATE TABLE t1)
      granted: (11    seqno -1    wsrep (local, exec, certifying) cmd 3 5     INSERT INTO t1 VALUE (1,'x'),(2,'x'),(3,'x'))
      2023-12-28 14:56:16 10 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
      2023-12-28 14:56:16 10 [Note] WSREP: MDL conflict-> BF abort
      schema:  test
      request: (10    seqno 57    wsrep (toi, exec, aborted) cmd 3 8  TRUNCATE TABLE t1)
      granted: (11    seqno -1    wsrep (local, exec, certifying) cmd 3 5     INSERT INTO t1 VALUE (1,'x'),(2,'x'),(3,'x'))
      2023-12-28 14:56:16 10 [Note] WSREP: MDL ticket: type: MDL_SHARED_WRITE space: TABLE db: test name: t1 (Waiting for table metadata lock)
      2023-12-28 14:56:16 10 [Note] WSREP: Seqno -1 successfully BF aborted 60 victim_seqno -1
      2023-12-28 14:56:16 10 [Note] WSREP: client: 11 txc: 60 state: certifying -> must_abort
      

      but later it cannot complete rollback:

      2023-12-28 14:56:16 11 [Note] WSREP: after_statement: enter(11,exec,local,deadlock_error,3,toi: -1,nbo: -1)
      2023-12-28 14:56:16 11 [Note] WSREP: after_statement_enter
          server: 17006100-a578-11ee-975f-1683cf31f43b, client: 11, state: exec, mode: local
          trx_id: 60, seqno: -1, flags: 1
          state: aborted, bfa_state: certifying, error: deadlock_error, status: 3
          is_sr: 0, frags: 0, frags size: 0, unit: 0, size: 1, counter: 0, log_pos: 0, sr_rb: 0
          own: 1 thread_id: 7febc0145700
      

      hanging here:

      #3  0x00007febc9093ee2 in gu::Lock::wait (this=0x7febc0143810, cond=...) at /home/denis/dev/galera-bugs/galerautils/src/gu_lock.hpp:46
      #4  0x00007febc909dcdf in galera::Monitor<galera::ReplicatorSMM::CommitOrder>::enter (this=0x5618223f0fa0, obj=...) at /home/denis/dev/galera-bugs/galera/src/monitor.hpp:163
      #5  0x00007febc9086a5b in galera::ReplicatorSMM::release_rollback (this=0x5618223efdf0, trx=...) at /home/denis/dev/galera-bugs/galera/src/replicator_smm.cpp:1509
      #6  0x00007febc905d278 in galera_release (gh=0x5618223dbb50, ws_handle=0x7febc0143e88) at /home/denis/dev/galera-bugs/galera/src/wsrep_provider.cpp:905
      #7  0x00005618208f55a5 in wsrep::wsrep_provider_v26::release (this=<optimized out>, ws_handle=...) at /home/denis/dev/mariadb-server-features/wsrep-lib/src/wsrep_provider_v26.cpp:976
      #8  0x00005618208f1d27 in wsrep::transaction::after_statement (this=this@entry=0x7feb6c008990, lock=...) at /home/denis/dev/mariadb-server-features/wsrep-lib/src/transaction.cpp:913
      #9  0x00005618208cd947 in wsrep::client_state::after_statement (this=this@entry=0x7feb6c008928) at /home/denis/dev/mariadb-server-features/wsrep-lib/src/client_state.cpp:265
      

      Attachments

        1. backtrace_all
          56 kB
        2. mysqld.1.err
          739 kB
        3. mysqld.2.err
          695 kB

        Issue Links

          Activity

            People

              denis.protivensky Denis Protivensky
              denis.protivensky Denis Protivensky
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.