Proxysql 2.0.2 errors on setting time_zone

[shrestha-s]

Hi,
Proxysql 2.0.2 produces following error when setting TIME_ZONE variable.

OS Version: Ubuntu 14.04.5 LTS
ProxySQL Version: 2.0.2-1-g533442f, codename Truls
Backend DB: Mysql 5.6.37

Fyi, I am logged-in through ProxySQL to the backend DB as a user with full privileges

mysql> SET @OLD_TIME_ZONE=@@TIME_ZONE;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @OLD_TIME_ZONE;
+----------------+
| @OLD_TIME_ZONE |
+----------------+
| SYSTEM         |
+----------------+
1 row in set (0.00 sec)

mysql> 
mysql> 
mysql> SET TIME_ZONE=@OLD_TIME_ZONE;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> 
mysql> SELECT @@TIME_ZONE;
ERROR 1298 (HY000): Unknown or incorrect time zone: ''

I've tested this with ProxySQL 1.4.13 and verified that this is not an issue. I've also confirmed that even without explicitly calling "SELECT @@TIME_ZONE", I can run into the same issue as follows:

mysql> SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;
Query OK, 0 rows affected (0.00 sec)

mysql> SET @OLD_TIME_ZONE=@@TIME_ZONE;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @OLD_TIME_ZONE;
+----------------+
| @OLD_TIME_ZONE |
+----------------+
| SYSTEM         |
+----------------+
1 row in set (0.01 sec)

mysql> SET TIME_ZONE=@OLD_TIME_ZONE;
Query OK, 0 rows affected (0.00 sec)

mysql> SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;
ERROR 1298 (HY000): Unknown or incorrect time zone: ''

The error message seen in proysql.log when this is encountered is:

2019-03-20 11:43:01 MySQL_Session.cpp:1815:handler_again___status_SETTING_TIME_ZONE(): [WARNING] Error while setting TIME_ZONE: 1298, Unknown or incorrect time zone: ''
2019-03-20 11:43:01 MySQL_Session.cpp:103:kill_query_thread(): [WARNING] KILL CONNECTION 983 on <hostname>:3306

Thanks
S

[mgale]

@renecannao Hey, is this the same issue that got fixed here? #1063

[renecannao]

issue confirmed.
ProxySQL 1.4 doesn't attempt to parse the SET command.
ProxySQL 2.0 does it, and it fails.

[renecannao]

Fixed in 2.0.4 .
Thank you for the report.

[soq58724]

Hello renecannao. But this still a problem with ProxySQL version: 2.0.15. Could you help please?