Please report a bug for future enhancements:SET SESSION AURORA_READ_REPLICA_READ

[otooi]

This is the place to report a reproducible bug, documentation error or feature request for ProxySQL.

Support questions will not be answered here. For community support, use the Google forum: https://groups.google.com/forum/#!forum/proxysql

• Note that due to time constraints ProxySQL engineers may be slow to respond to forum posts
• For information on paid support contracts: https://proxysql.com/services/support/

If you are submitting a reproducible bug report, please provide:

• A clear description of the issue
• ProxySQL version : 2.3.2
• OS version : AMZN2
• The steps to reproduce the issue
• The full ProxySQL error log (default location: /var/lib/proxysql/proxysql.log)

Hello,

As of Aurora MySQL 2.07, the read-committed isolation level can be used on the reader instances.
AuroraMySQL.Reference.IsolationLevels

set session aurora_read_replica_read_committed = ON;
set session transaction isolation level read committed;

I use these settings, the following error occurs in proxysql.

2022-01-11 17:16:06 MySQL_Session.cpp:7093:unable_to_parse_set_statement(): [WARNING] Unable to parse unknown SET query from client 10.0.10.10:12345. Setting lock_hostgroup. Please report a bug for future enhancements:SET SESSION AURORA_READ_REPLICA_READ
_COMMITTED = ON

Thank you

[renecannao]

Solved in #3754