Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1924

[MySQLAuth] Failed to execute auth query: database table is locked: mysqlauth_users

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.16
    • Fix Version/s: None
    • Component/s: Authenticator
    • Labels:
      None

      Description

      A MaxScale instance that has a very high rate of authentication failures is seeing occasional errors like the following:

      2018-06-14 18:39:15   error  : [MySQLAuth] Failed to execute auth query: database table is locked: mysqlauth_users
      2018-06-14 18:39:15   warning: [MySQLAuth] Client hostname lookup of '' failed, getnameinfo() returned: 'Name or service not known'.
      2018-06-14 18:39:15   warning: [MySQLAuth] Splitter Service: login attempt for user 'platform_app_usr'@[10.1.1.1]:41650, authentication failed.
      2018-06-14 18:39:16   notice : [MySQLAuth] [Splitter Service] Loaded 332 MySQL users for listener Splitter Listener.
      

      Is this caused by the high rate of authentication failures?

        Attachments

          Activity

            People

            • Assignee:
              markus makela markus makela
              Reporter:
              GeoffMontee Geoff Montee
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: