Timeout overflow in mysql_query_rules

[alpes214]

Description of the issue

It is possible to set query timeout in mysql_query_rules. If timeout is set to a relatively high value, for example more than 35 minutes, then query is ending unexpectedly.

Steps to reproduce

1. Set query rules with timeout value equals to one hour.

INSERT INTO mysql_query_rules (rule_id,active,match_digest,destination_hostgroup,timeout,apply) VALUES (1,1,'^SELECT.*FOR UPDATE$',0,3600*1000,1), (2,1,'^SELECT',1,3600*1000,1);
load mysql query rules to runtime; save mysql query rules to disk;

2. Execute query

mysql> select 1, sleep(3601);
+---+-------------+
| 1 | sleep(3601) |
+---+-------------+
| 1 |           1 |
+---+-------------+
1 row in set (2.00 sec)

3. The query ended sooner than expected. Expected: query runs for 1 hr and 1 second;

The version of OS and ProxySQL

$ cat /etc/*-release
PRETTY_NAME="Debian GNU/Linux 9 (stretch)"
NAME="Debian GNU/Linux"
VERSION_ID="9"
VERSION="9 (stretch)"
VERSION_CODENAME=stretch
ID=debian
HOME_URL="https://www.debian.org/"
SUPPORT_URL="https://www.debian.org/support"
BUG_REPORT_URL="https://bugs.debian.org/"

The FULL error log

proxysql.log

[renecannao]

Fixed in 2.0.12 .
Still not fixed in 2.1.0