[MXS-4436] Maxscale( 2.1.7) no response to query Created: 2022-12-08  Updated: 2022-12-08  Resolved: 2022-12-08

Status: Closed
Project: MariaDB MaxScale
Component/s: Core, readwritesplit
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: ichabod Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: handlersocket, hang


 Description   

we are using the maxscale 2.1.7， but our java application execute a read-only no transaction query ocatinally hang-up to timeout until java application get the exception("SQLSTATE(08S01), Communication link failure"). the wait time is just equal to the maxscale readwritesplit serivce connection_timeout.
I have tcpdump the network traffic. it seems the java application send the mysql query to maxscale. but maxscale do not response the query!

Serivce Config
type=service
router=readwritesplit
servers=server1,server2,server3
user=root
passwd=xxx
max_slave-connections=100%
use_sql_variables_in=master
max_slave_replication_lag=1
router_options=master_accept_reads=true,rwsplit_safe_interval=50
connection_timeout=120

 Comments   
Comment by ichabod [ 2022-12-08 ]

we wrapped our maxscale as a docker image, the image linux version is : Centos 7.9.2009

Comment by ichabod [ 2022-12-08 ]

No error has been found in the log, no route log, just like the query has not been recived(already open debug mode, it seems epoll not receive the EPOOLIN event?)

Comment by ichabod [ 2022-12-08 ]

backend mysql version is :mysql 5.7.0

Comment by markus makela [ 2022-12-08 ]

MaxScale 2.1 went EOL a long time ago, I'd recommend upgrading to something newer.

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