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

WSREP: BF lock wait long for trx

    XMLWordPrintable

Details

    Description

      Hi, it seems the problem of WSREP: BF lock wait long for trx .... is appear again and locking a whole cluster (galera). I have a cluster with 3 nodes using HAProxy and KeepAlived. The cluster hung several times for a week. And one of the node produced a bigger error log than the others.

      As you can see inside attachment, the error log that i extracted before writing so many BF lock wait long for trx ....

      If any mistake, pls let me know. I using earlier version of MariaDB, 10.1.31

      is this still buggy? or i don't figure it out that this isn't bug?

      Sorry for my bad english

      *edit : For each hung, i take a look on the error log and seems that the crash triggered by sql statement "commit". Any idea?

      Spec:
      OS = CentOS 7.2.1511
      MariaDB = 10.1.31
      VM

      Attachments

        1. bug#1.JPG
          128 kB
          Pramudya Aditya
        2. mysql_error.log.185
          7.10 MB
          Pramudya Aditya

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              pramudyapp Pramudya Aditya
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.