Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
-
Not for Release Notes
-
Q3/2025 Maintenance
Description
Even without any client connects or disconnects (as described in MDEV-37159) we can see that server_audit_file_buffer_size is not honored when >=2 clients are actively connected and used:
1. Start a server, and open two client sessions
2. In client a execute:
INSTALL PLUGIN server_audit SONAME 'server_audit'; |
SET GLOBAL server_audit_logging=ON; |
SET GLOBAL server_audit_file_buffer_size=8192; # Apparent default of 8k |
SELECT 1; |
3. In client b execute:
SELECT 2; # This triggers an Audit log write |
The outcome:
|
bb-12.0-mdev-34680x3-hf CS 12.0.1 8ead5a2a8a15a95f060e02d26c1ed28800fbdb03 (Optimized, Clang) Build 02/07/2025 |
$ cat data/server_audit.log; wc -c data/server_audit.log
|
20250704 19:37:59,qa-roel-2,root,localhost,4,5,QUERY,test,'SET GLOBAL server_audit_logging=ON',0
|
20250704 19:37:59,qa-roel-2,root,localhost,4,6,QUERY,test,'SET GLOBAL server_audit_file_buffer_size=8192',0
|
20250704 19:37:59,qa-roel-2,root,localhost,4,7,QUERY,test,'SELECT 1',0
|
20250704 19:38:05,qa-roel-2,root,localhost,5,2,QUERY,test,'SELECT 2',0
|
347 data/server_audit.log
|
Attachments
Issue Links
- is caused by
-
MDEV-34680 Asynchronous and Buffered Logging for Audit Plugin
-
- Closed
-