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

SQL Errors detected when restarting maxscale.

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 24.02.3
    • N/A
    • N/A
    • None

    Description

      I was getting some unexpected behavior and trying to debug SSL on maxscale. That led me to turn on sql error log plugin, this one: https://mariadb.com/kb/en/sql-error-log-plugin/ . On the restart of maxscale, I see these SQL errors:

      2024-09-25 20:04:05 maxscale[maxscale] @ e100.edw.ee [192.168.8.100] ERROR 1054: Unknown column 'ID' in 'field list' : SELECT ID, FULL_COLLATION_NAME FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITY WHERE FULL_COLLATION_NAME = @@global.collation_server
      2024-09-25 20:04:05 maxscale[maxscale] @ e100.edw.ee [192.168.8.100] ERROR 1046: No database selected : SELECT ID, FULL_COLLATION_NAME, CHARACTER_SET_NAME FROM information_schema.COLLATION_CHARACTER_SET_APPLICABILITYSELECT id, collation_name, character_set_name FROM information_schema.collations
      

      Database version is 10.6.19-15.
      Maxscale version is 24.02.3

      Attachments

        Activity

          markus makela markus makela added a comment -

          This is expected behavior. MaxScale has support for multiple versions of the information_schema tables and only one of them works for each version. The code that generates this is here: https://github.com/mariadb-corporation/MaxScale/blob/27c9cb95545128bd3a56cb8964e015f04f5339f1/server/modules/protocol/MariaDB/mariadb_maxscale.cc#L283

          markus makela markus makela added a comment - This is expected behavior. MaxScale has support for multiple versions of the information_schema tables and only one of them works for each version. The code that generates this is here: https://github.com/mariadb-corporation/MaxScale/blob/27c9cb95545128bd3a56cb8964e015f04f5339f1/server/modules/protocol/MariaDB/mariadb_maxscale.cc#L283

          People

            Unassigned Unassigned
            edward Edward Stoever
            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.