proxysql 2.0.10 empty Queries_GTID_sync field in stats_mysql_connection_pool table

[MaxFedotov]

Hello,

starting from version 2.0.9 when using proyxsql-binlog-reader for causal reads, Queries_GTID_sync field in stats_mysql_connection_pool table is always 0.

How to reproduce:
Install proxysql version 2.0.9 or 2.0.10
build proxysql-binlog-reader, configure proxysql and use test from this article: https://www.percona.com/blog/2020/02/18/configuring-proxysql-binlog-reader/

run test and select data from stats_mysql_connection_pool table

Admin> select hostgroup, Queries, Queries_GTID_sync from stats_mysql_connection_pool;
+-----------+---------+-------------------+
| hostgroup | Queries | Queries_GTID_sync |
+-----------+---------+-------------------+
| 1         | 19537   | 0                 |
| 2         | 11500   | 0                 |
| 2         | 37723   | 0                 |
+-----------+---------+-------------------+
3 rows in set (0.01 sec)

Queries_GTID_sync will be always 0, although all queries will be routed correctly

[renecannao]

Hi @MaxFedotov .
Thank you for the report.
We identified the root cause:
PR #2469 broke this, as it stops setting with_gtid , later required in MySQL_Connection::handler() to increment parent->queries_gtid_sync.

[MaxFedotov]

@renecannao, thanks a lot!