0

I did a fresh install of Maxscale, and I was trying to set up a Read-Write-Split service on a master-slave mariadb cluster.

When I was trying to connect with DataGrip or DBeaver, I got the following error message: [HY000][1927] Capability mismatch (bdd-master)

But when I use the mysql command line client, it works well.

Do you have any idea of what could be wrong?

DavidBu
  • 478
  • 4
  • 6
  • You can try to introspect / connect to server using JDBC metadata. Go to data source's advanced tab and under *Expert options* check *Introspect using JDBC metadata* – Vasilii Chernov May 20 '22 at 13:14
  • What version of MaxScale are you using? Depending on the version, this is either a bug or a transient problem. – markusjm May 20 '22 at 16:05

2 Answers2

1

MaxScale sends a Capability mismatch error when it detects that the client application requests a protocol capability that one of the backend databases cannot support. In general, this should not happen as MaxScale tries to mimic the backend database and calculates the capabilities so that these sort of mismatches do not happen.

There are some known bugs that can cause this, both in MaxScale as well as old versions of MariaDB and MySQL. Upgrading to the latest possible version of MaxScale should help solve any problems you might see.

Additionally, you should disable the query cache in the database if you are using MySQL as there is a bug in MySQL (and old MariaDB versions as well) that causes these sort of problems to appear.

markusjm
  • 2,358
  • 1
  • 11
  • 23
  • I found indeed a related issue here: https://jira.mariadb.org/browse/MXS-3704 But what worries me is that I use the version MaxScale 6.3.0. – DavidBu May 23 '22 at 12:34
  • Indeed, installing MaxScale 6.3.1 solved my problem. Thank you – DavidBu May 23 '22 at 17:00
0

It seems that is related to the router used (readwritesplit).

Datagrip send this command when it initiate the connection: set autocommit=1, session_track_schema=1, sql_mode = concat(@@sql_mode,',STRICT_TRANS_TABLES')

It seems that some of theses parameters are not supported by readwritesplit.

DavidBu
  • 478
  • 4
  • 6