connection is locked to hostgroup (writer) but trying to reach hostgroup (reader)

[suyestyle]

ProxySQL version 2.3.2-10-g8cd66cf, codename Truls

10 is a writer group, 20 is a reader group

I encountered a problem when executing a select query statement. The following error was reported：

ProxySQL Error: connection is locked to hostgroup 10 but trying to reach hostgroup 20

[renecannao]

Hi @suyestyle .

As the error implies, proxysql is configured to send a query to hostgroup 20, while the client connection is locked on hostgroup 10.

This is a configuration problem.
The configuration missing in the issue itself, but I would speculate you copied a pair of generic query rules not suitable for real traffic / production

[suyestyle]

How should I solve this problem？

I need to tell you what configuration？

[renecannao]

Most probably, it is a problem that you created while configuring ProxySQL .
As mentioned earlier, I would speculate you copied a pair of generic query rules not suitable for real traffic / production.