[MXS-3427] The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56' Created: 2021-03-04  Updated: 2021-03-12  Resolved: 2021-03-12

Status: Closed
Project: MariaDB MaxScale
Component/s: galeramon, mariadbbackend
Affects Version/s: 2.5.7, 2.5.8
Fix Version/s: 2.5.10

Type: Bug Priority: Major
Reporter: Anthony Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: regression
Environment:

RHEL 8
Percona XtraDB Cluster 5.7



 Description   

Dear all,

Since the upgrade from Maxscale 2.5.6 to 2.5.7+, it seem that there are regression and maxscale doesn't works anymore with Percona XtraDB Cluster 5.7.

Indeed, once launched, it cannot connect to backend due to this issue:

[...]
2021-03-04 21:33:06   error  : Failed to execute query on server 'server2' ([server2]:3306): The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'
2021-03-04 21:33:06   error  : Failed to execute query on server 'server3' ([server3]:3306): The 'INFORMATION_SCHEMA.SESSION_STATUS' feature is disabled; see the documentation for 'show_compatibility_56'

It worked well with Maxscale 2.5.6.

Best regards,



 Comments   
Comment by markus makela [ 2021-03-05 ]

You can fix it by adding show_compatibility_56=ON to the server configuration.

Comment by Anthony [ 2021-03-05 ]

@markus it's a regression, it works well with 2.5.6.

I cannot add this in the conf and this param has been removed in mysql v8.0.1+ (when we will upgrade mysql).

Best regards,

Generated at Thu Feb 08 04:21:20 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.