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

Create new "Auditing" thread state

Details

    Description

      We have previously seen the server_audit plugin cause threads to hang in various states due to the problems described by MDEV-18661 / MDEV-19291. These threads could hang in many different states, such as "System lock", "init", and "freeing items." This made the root cause of the issue quite difficult to diagnose on production systems.

      In case a similar issue happens again, it might make sense to add a new "Auditing" thread state. This new thread state could be used anytime a thread calls a function in the audit plugin API.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-18661 loading the audit plugin causes performance regression

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-19291 server_audit plugin mutex causes stalls at very high concurrency

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-19391 Create new "Registering transaction" thread state

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            GeoffMontee Geoff Montee (Inactive) created issue -
            GeoffMontee Geoff Montee (Inactive) made changes -
            Field Original Value New Value
            GeoffMontee Geoff Montee (Inactive) made changes -
            GeoffMontee Geoff Montee (Inactive) made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 10.5 [ 23123 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 98749 ] MariaDB v4 [ 131145 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 201817 112495
            Zendesk active tickets 201817
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels tech_debt

            People

              Unassigned Unassigned
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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