query sql ,Query error report: Lost connection to MySQL server during query

91 views
Skip to first unread message

张飞虎

unread,
Sep 18, 2023, 12:40:51 AM9/18/23
to maxs...@googlegroups.com
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ä

unread,
Sep 18, 2023, 1:51:19 AM9/18/23
to maxs...@googlegroups.com

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

张飞虎

unread,
Sep 18, 2023, 3:31:15 AM9/18/23
to Markus Mäkelä, maxs...@googlegroups.com
@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写道:
Reply all
Reply to author
Forward
0 new messages