Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
10.4.12
-
Red Hat Enterprise Linux release 8.8 (Ootpa) over VMware ESXi 8.0
46 G RAM, 4 * Intel(R) Xeon(R) Platinum 8268 CPU @ 2.90GHz
Description
The mariadbd process hangs at startup when the config file my.cnf asks for server_audit to be loaded, when this plugin has already been loaded via SQL statement.
Expected behaviour
Server startup proceeds with a warning, e.g.: plugin server_audit already loaded
Actual behaviour
Server becomes unresponsive during startup. There is no error message and the process doesn't react to signals. Only kill -9 will terminate it.
Steps to reproduce
- execute sql: INSTALL SONAME 'server_audit'
- add lines to my.cnf:
[mysqld]
plugin_load_add = server_audit
server_audit = FORCE_PLUS_PERMANENT - stop the server
- (try to) start the server
Further Information
The error log shows a partial startup: "InnoDB buffer pool(s) load completed" is the last message.
When the server is run through strace, some threads repeatedly call futex(...) and receive ETIMEDOUT, others are stuck at "futex(..., FUTEX_WAIT_PRIVATE, ...", a call that never returns.
Attachments
Issue Links
- relates to
-
MDEV-32041 "plugin already loaded" should be a Warning, not an Error
- Closed
-
MDEV-22406 Galera node freezes when query_response_time plugin loading
- Open