[MDEV-32626] Server hangs during startup with plugin_load_add=server_audit when plugin is already loaded with INSTALL SONAME Created: 2023-10-30  Updated: 2023-11-07  Resolved: 2023-11-07

Status: Closed
Project: MariaDB Server
Component/s: Plugin - Audit, Plugins, Server
Affects Version/s: 10.4.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Simon Schneider Assignee: Sergei Golubchik
Resolution: Cannot Reproduce Votes: 0
Labels: crash
Environment:

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


Issue Links:
Relates
relates to MDEV-32041 "plugin already loaded" should be a W... Closed
relates to MDEV-22406 Galera node freezes when query_respon... Open

 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

  1. execute sql: INSTALL SONAME 'server_audit'
  2. add lines to my.cnf:

    [mysqld]
    plugin_load_add = server_audit
    server_audit = FORCE_PLUS_PERMANENT

  3. stop the server
  4. (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.



 Comments   
Comment by Sergei Golubchik [ 2023-10-31 ]

I don't seem to be able to repeat it. The server starts normally, the error log contains

2023-10-31 22:13:44 0 [ERROR] mysqld: Plugin 'SERVER_AUDIT' already installed

Please, try with the latest MariaDB release, 10.4.12 was released on 28 Jan 2020.

Comment by Daniel Black [ 2023-11-06 ]

The ERROR will be downgraded to a note with MDEV-32041

Comment by Simon Schneider [ 2023-11-07 ]

I'm unable to reproduce the issue with MariaDB 10.4.31. Sorry about wasting your time, I should have checked that first.

I will upgrade our installations and consider this issue resolved. Please close this ticket.

Generated at Thu Feb 08 10:32:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.