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

Using too big key for internal temp tables

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 2.2.18
    • N/A
    • Authenticator
    • None
    • Centos 7
      Maxscale version 2.2.18
      DB version : MariaDB 10.3.2

    Description

      Hi,

      We have got many error when we restart our maxscale services

      2019-01-08 20:36:59 error : [MySQLAuth] Failed to load users from server 'xx.xx.xx.xx': Internal error: Using too big key for internal temp tables

      2019-01-08 20:36:59 notice : [MySQLAuth] [RWSVC] No users were loaded but 'inject_service_user' is enabled. Enabling service credentials for authentication until database users have been successfully loaded.

      It begin with 10 or 15 warning per day, and for last few days we can't log into the database through maxscale.

      Maxscale is able to telnet database server on port 3306, with maxscale account it can log in and show user database.

      Direct access to database is okay with same account.

      Not a network or a firewall problem.

      Maxscale version 2.2.18
      DB version : MariaDB 10.3.2

      Could you help us ?

      Thx

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              julien.cornillad Cornillad
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.