The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-12-24. For the latest, interactive version please visit https://mariadb.com/kb/.

MaxScale JDBC CLOB

I am using MaxScale 22.08.1 with four MariaDB 10.5.16 servers, configured in a cluster. When I execute a JDBC (mariadb-java-client-2.7.4) Insert query with a Text base Clob using MaxScale, the query doesn't return, but keep on executing indefinitely (or for a long time). The same query executes successfully directly on the related MariaDB servers. In other words when I connect directly to one of the MariaDB servers in the cluster. Because I am new to MaxScale, I am not sure if I am missing something or there is a potential bug. Thank you.

Answer Answered by Markus Mäkelä in this comment.

To see what is happening in MaxScale when that query is running, add log_info=true under the [maxscale] section. This will show where the query is routed and what the router's are doing in MaxScale when the query appears to hang.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.