Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-32626

Server hangs during startup with plugin_load_add=server_audit when plugin is already loaded with INSTALL SONAME

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4.12
    • N/A
    • Plugin - Audit, Plugins, Server
    • 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

      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.

      Attachments

        Issue Links

          Activity

            simon.schneider Simon Schneider added a comment - - edited

            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.

            simon.schneider Simon Schneider added a comment - - edited 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.
            danblack Daniel Black added a comment -

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

            danblack Daniel Black added a comment - The ERROR will be downgraded to a note with MDEV-32041
            serg Sergei Golubchik added a comment - - edited

            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.

            serg Sergei Golubchik added a comment - - edited 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.

            People

              serg Sergei Golubchik
              simon.schneider Simon Schneider
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.