v2.2.1-Release notes

Release date: 2021-09-02 ​ This is a minor release for the ProxySQL 2.2 series containing several bug fixes.

Compared to ProxySQL 2.2.0, 2.2.1 introduces the following changes:

Fixes

Major

• Add support for 'grave accent' (`) for SET statements parsing: #3479.
  • Previously grave accents break the detection of SET statements, like SET `group_concat_max_len` = 2048, this is now fixed.
• Added client information for multi-statements parsing error message: #3487.
• Add support for comments in 'USE' statements: #3493.
• Fixed memory leak induced by 'stmts' not being closed when failed to prepare. #3544
• Fixed possible mismatch of CLIENT_DEPRECATE_EOF in sessions using fast_forward: #commit
• Fixes autocommit track being lost for session being locked in a hostgroup: #3560
• Fixed memory corruption reported by ASAN due to unexpected packet by 'mysqlsh': #3554
• Fixed 'heap-buffer-overflow' detected by ASAN in 'generate_show_fields_from': #3554
• Fixed memory leak detected by ASAN during 'PROXYSQL SHUTDOWN SLOW': #3554
• Fixed 'strcat-param-overlap' found by ASAN in 'IsKeepMultiplexEnabledVariables': #3554
• Fixed 'stack-buffer-overflow' found by ASAN during SHA1 generation: #3554
• Fixed double-free memory corruption due to unitialized memory in prepared statements bind buffers: #3546
• Fixed invalid bind of prepared statement params when 'new_params_bound_flag' is not provided: #commit
• Fixed copy of data when to MYSQL_TS structure for prepared statements when length is '0': #commit

Minor

• Fixed default 'mysql-default_query_timeout' range into the one specified in doc. With values:
  • Minimum: 1000.
  • Maximum: 1728000000.
• Fixed uninitialised value in MySQL_Monitor_State_Data(): #commit
• Changing pt-heartbeat query from MIN to MAX matching pmp-check-mysql-replication-delay default behavior: #3514

Enhancements

• Added more verbosity when mysql_real_connect() fails: #commit
• Added client information to error generated when multi-statement command fails to be parsed: #3488
• Added exception logging for 'httpserver::webserver::start' when initializing RESTAPI server: #commit

SHA256s:

c154dffc8895c643488e383207a977ed95e1a346007f65fc7ddf3af5fc8a98c7  proxysql-2.2.1-1-centos67.x86_64.rpm
9daae2afdb92b12942e67cba8742c6d2f5ddc72c8564f7832b469896a0538a5b  proxysql-2.2.1-1-centos7.aarch64.rpm
aba0fdf954331484799ce2592d7f2d100cb12ab08621dad9d35d26e7ac98758e  proxysql-2.2.1-1-centos7.x86_64.rpm
fd2b604b895a0158c76f98b502a015b8cb6b51b54a3e38e78f06f170b7e61999  proxysql-2.2.1-1-centos8.aarch64.rpm
b455e14b69a29387ba10a86ff5b7cfcb871c12a0bcf1dc2474a7d117a00f2c37  proxysql-2.2.1-1-centos8.x86_64.rpm
8b1809fada0d648fdb8e3efc9b6c735a1aa15780176b1460f56fbc1600d61fca  proxysql-2.2.1-1-dbg-centos67.x86_64.rpm
b882f8454f29c84141bd4282e3795ecf353ee5e45a9db7b57bc1f636507d33a5  proxysql-2.2.1-1-dbg-centos7.x86_64.rpm
17f5a3845f52e7803bd170f582092eb2e16ced9583cb59341e10aacdf4af3c9e  proxysql-2.2.1-1-dbg-centos8.x86_64.rpm
700db994dc2bd3549811a518ad27731782aa445959eeda7807c16a6af618d831  proxysql-2.2.1-1-dbg-fedora24.x86_64.rpm
b769d4bd54ab938d197b579fc2923d11a66f71f7bb6cbd003412f868c4b9dad2  proxysql-2.2.1-1-dbg-fedora27.x86_64.rpm
05c92ab6171f7f7303032f94cf1ad5a096ec5edec9d7f5b89ebdd5cb6487642e  proxysql-2.2.1-1-dbg-fedora28.x86_64.rpm
30a35ed28ffad384ca6fde7f72087ba0ee65a5eab37d4894070b7ad2d9cf3618  proxysql-2.2.1-1-fedora24.x86_64.rpm
810bc4acbe6267816546ad107b33b28224d64cd8f16d4f233992bd4ca9e03a6f  proxysql-2.2.1-1-fedora27.x86_64.rpm
4aa8ce9e4a95e9053a6ac1da037792c164bb5e21fbed5b2869d97d732a5f0f2b  proxysql-2.2.1-1-fedora28.x86_64.rpm
82e2e3634d19add97183c6b9d4663e9a3ea1b56503bd0526a02e65ded4317306  proxysql_2.2.1-dbg-debian10_amd64.deb
46a38e0525e85940972d7c0eab169ad8f49208ccc22090e3fec2022b071e2ab0  proxysql_2.2.1-dbg-debian8_amd64.deb
23805b1847ed6244ea22eae41d8c3e2925f5c7996c17d74d385e212d92ec61cf  proxysql_2.2.1-dbg-debian9_amd64.deb
b34e28d6747d87f741018a006296b19dca12f6069b08675326419862ffda4012  proxysql_2.2.1-dbg-ubuntu14_amd64.deb
6428a2f3a3b5ab3a919c9a6f1244ffe1cef33eae395065b65f45b0490342b12c  proxysql_2.2.1-dbg-ubuntu16_amd64.deb
fca52e9be59fdf6cda5472a4fca7995e2c245a3b156dc799357109cbed5830c8  proxysql_2.2.1-dbg-ubuntu18_amd64.deb
14bf68d105cf770afa54db9cc62971119f92719bc63692efa74f2e649f79079d  proxysql_2.2.1-dbg-ubuntu20_amd64.deb
767c95d89103b030a9cb6161455af9f0e5dde40301b1baf4ce66b6bc8dc80386  proxysql_2.2.1-debian10_amd64.deb
608ff215e514f382f870397a9abeb10fe4965642c3a04c21a3d4d0156756c8dd  proxysql_2.2.1-debian10_arm64.deb
23953cd4a50c64d1f33dc79b97e2e868c9aee72f0f6ad5c07a9a0a60b8410923  proxysql_2.2.1-debian8_amd64.deb
60f3e46a63c725566d6c63b8a045a9756ae89b5b5ef811cb2da7686f675d6f63  proxysql_2.2.1-debian9_amd64.deb
163258a5242b89d041918f4b8ee3bfeb9f7e2d3a52ab089ca967cb11c815f315  proxysql_2.2.1-debian9_arm64.deb
53fa0dcd370d16834c35fb8a13f2fc35a0bc14160e3028b8bc1410deb194bfb0  proxysql_2.2.1-ubuntu14_amd64.deb
5b37c62a57fffab8eb9cc649a508bac75045894aaa831eb65e7f1ee32b9549a9  proxysql_2.2.1-ubuntu16_amd64.deb
7b74512e42bfa85e56c6fc905b7a242d2632483d43885787e7bed13c329e25a0  proxysql_2.2.1-ubuntu18_amd64.deb
4692d440e36acb1231dec430810b3189be8272ee9d729b63fdb28477ad0e7046  proxysql_2.2.1-ubuntu18_arm64.deb
6af757dad205132e1594671f62755c122a3122209adf486ea133fbea50d83fbb  proxysql_2.2.1-ubuntu20_amd64.deb
48b4f9cbc63dbba4b94b6cdec7058b8909bcaa76d6b59e3467af7a1880500543  proxysql_2.2.1-ubuntu20_arm64.deb