[MDEV-12733] Galera node hang when changing server_audit options online Created: 2017-05-08  Updated: 2023-06-06  Resolved: 2023-06-06

Status: Closed
Project: MariaDB Server
Component/s: Galera, Server
Affects Version/s: 10.1.18
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Joseph Palermo Assignee: Alexey Botchkov
Resolution: Won't Fix Votes: 1
Labels: None

Attachments: File server_audit_backtrace.md    

 Description   

We encountered a problem with one node hanging in a Galera cluster. At the time one connection was issuing:

SET GLOBAL server_audit_events='CONNECT,QUERY_DDL,QUERY_DCL',server_audit_output_type=syslog,server_audit_excl_users='XXXXXXXXXX',server_audit_logging=1,binlog_row_image='minimal',expire_logs_days=1;

Other connections seemed to be internal healthcheck / logging utilities running SHOW STATUS LIKE 'wsrep_local_state' or dumping wsrep status variables via SHOW GLOBAL STATUS LIKE 'wsrep%'.

Attached is thread apply all bt output indicating the mutex contention. It looks like all threads were waiting on the server_audit mutex.

We are writing to only a single node. The other nodes in the cluster seemed to not be affected at the time.

Encountered on MariaDB 10.1.18 / Galera 25.3.17.



 Comments   
Comment by Jan Lindström (Inactive) [ 2019-05-20 ]

holyfoot This could be a problem with audit itself not actually a Galera.

Comment by Jan Lindström [ 2023-06-06 ]

10.1 is EOL.

Generated at Thu Feb 08 08:00:02 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.