Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
24.02.3
-
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
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