[MDEV-27982] MariaDB hangs on commit Created: 2022-03-02  Updated: 2022-04-03  Resolved: 2022-04-03

Status: Closed
Project: MariaDB Server
Component/s: Galera, Storage Engine - InnoDB
Affects Version/s: 10.5.8
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: William Welter Assignee: Jan Lindström (Inactive)
Resolution: Incomplete Votes: 0
Labels: None
Environment:

Galera version: 26.4.6-buster
Debian Version: 10.6
Kernel version: 4.19.0-12-amd64

Attachments: Text File backtraces.txt     Text File innodb.txt     Text File stop-log.txt    

 Description   

In an environment with 3 node Galera Cluster and some replicas, for some reason, almost all the transactions hang in the “starting” state on the commit statement.
We tried to kill these transactions without success.
We tried to restart the service but it hangs on stopping Galera replication.
By looking at the backtrace it seems that we have a mutex deadlock on the group commit feature.

Unfortunately, we didn't find a way to reproduce the problem

 Comments   
Comment by Jan Lindström (Inactive) [ 2022-03-02 ]

This reminds me https://jira.mariadb.org/browse/MDEV-27348 i.e. most likely issue is fixed on more recent MariaDB server and Galera library version. You should use Galera library provided by MariaDB.

Comment by Jan Lindström (Inactive) [ 2022-03-02 ]

Can you try with more recent version of MariaDB server and Galera library?

Comment by William Welter [ 2022-03-02 ]

Yes, we will try to update it soon.

Generated at Thu Feb 08 09:57:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.