Galera Issue: Node 1 Return BF Lock Wait Long
There is a Galera cluster with 3 nodes. The MariaDB is community 10.5.16 via RHEL 8.7 distros. We have got the following errors with a JBOSS application. I am not sure whether it is related to the issue of wsrep_slave_threads. It looks like some versions but not for all.
<code>2023-07-14 17:41:37 0 [Note] InnoDB: WSREP: BF lock wait long for trx:64112653 query: insert into tbl_api_call_log (log_uuid, api_url, querystring ,bodystring, headerString, created_at,created_ip) values('b6e5cac2-bc23-4d8c-a4f8-c409dd617de7','https://<machine_info>/api/services/GetObject.jsp','user_uuid=cd203036-8692-4014-9d7c-73563fc4db71&fuuid=2eb8bb13-dbfc-4fb1-a569-743cf2578731&','','referer=https://<machine_info>/tado/cms/tado_report_details?uuid=8d62cde6-6afb-4cc1-9405-7e75aa07bae7&c=1&token=N0swNis2dE9aL1hpbVZxOHZldEZjUT09&accept-language=en-US,en;q=0.8,zh-HK;q=0.6,zh-TW;q=0.4,zh;q=0.2&x-forwarded-proto=https&cookie=token=eyJ1c2VyX3V1aWQiOiJjZDIwMzAzNi04NjkyLTQwMTQtOWQ3Yy03MzU2M2ZjNGRiNzEiLCJpc19hY3RpdmUiOiIxIiwidXNlcl90eXBlIjoiIiwidHlwIjoiSldUIiwibG9naW4iOiJSMTIzNjEiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJhdXRoMCJ9.6Sz5SX0hiXT-4TMwJ8bVbUsgCvolvbUnS4eRs95ls9w; JSESSIONID=nA1HU8Gjkh4IgcyOTxcqdCz2y7lYxU8or0I2FES-.p01tado-55c479c77-v269f; user_profile=VjdtWGV5TTRDUU5jcE1pYnFGTG</code>
Answer
MDEV-29684 was fixed in 10.5.19, not sure if its your case. Please report bug reports in https://jira.mariadb.org and include a backtrace.