query sql ，Query error report： Lost connection to MySQL server during query

[张飞虎]

hi all~:

I used maxscale to query a sql but got an error :Lost connection to MySQL server during query

maxscale.log

2023-09-18 12:17:36   info   : (1) [readconnroute] (Gic-Service); Routed [COM_PING] to 'server2'
2023-09-18 12:17:36   info   : (1) [readconnroute] (Gic-Service); Routed [COM_QUERY] to 'server2' select * from db.table_name
2023-09-18 12:17:37   info   : Variables have changed on 'server2', next check in 10 seconds: 'wait_timeout = 28800'
2023-09-18 12:17:39   info   : (1) Stopped Gic-Service client session [1]

[Markus Mäkelä]

Hi,

Looks like the log doesn't have that much information in it. What version of MaxScale is this?

Using the readwritesplit router usually gives you more information and better errors the log messages. You could try changing the router from readconnroute to readwritesplit and then comment out the router_options parameter and try it again. In older versions of MaxScale the logging for readconnroute was not that accurate and there was sometimes no error in the log if the connection was closed abruptly.

Markus

--
You received this message because you are subscribed to the Google Groups "MaxScale" group.
To unsubscribe from this group and stop receiving emails from it, send an email to maxscale+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/CAMew%3DtvTHoomJ6JB%3Dnm8QSsvKtQpkwLhdcrXGqk2%2BAQZahRHXQ%40mail.gmail.com.

-- 
Markus Mäkelä, Senior Software Engineer
MariaDB Corporation

[张飞虎]

@Markus Mäkelä  

Sorry, I found the reason. The problem is because I added the nginx proxy. I need to pay attention to the timeout parameter of nginx.😅

'Markus Mäkelä' via MaxScale <maxs...@googlegroups.com> 于2023年9月18日周一 13:51写道：

To view this discussion on the web, visit https://groups.google.com/d/msgid/maxscale/c81b7a71-b436-f78a-d112-57f7b8c2fb3c%40mariadb.com.