This is a minor release for ProxySQL 2.0, containing bug fixes and enhancements.

Compared to ProxySQL 2.0.15, 2.0.16 introduces the following changes:

Enhanchements

• Removed duplicated and unchecked call to 'conn_unregister' in 'monitor_group_replication_thread'. #3268.
• Galera nodes permanently dropped from runtime_mysql_servers for writer_is_also_reader=2. #3187
  • Readers that were only part of the 'reader_hostgroup', due to, for example, having 'read_only' flag equal 1, were being permanently dropped from the runtime_mysql_servers table.
• Galera node wrongly purged after placed 'OFFLINE HARD' in the 'offline_hostgroup'. #3216
  • If due to a previous event the node was placed in the offline_hostgroup, never purged from it, and a later event tried to place it again in the offline_hostgroup, the second placement wont overwrite it's status, creating the possibility of being completely purged from the tables.
• Server wrongly used as reader for Galera cluster with 'writer_is_also_reader=2'. #3219
  • Due to selective cleanup of readers for 'writer_is_also_reader=2', in case of no available backups writers, a server could unexpectedly end in the reader_hostgroup.

Bug fixes

• Fixes client connection hanging forever when backend is already gone. #3133
• Fixed ProxySQL creating more than 'max_connections' connections. #2619
  • ProxySQL now enforces 'CLIENT_MULTI_RESULTS' for client connections specifying 'CLIENT_MULTI_STATEMENTS' as MySQL spec states.
• Fixed error log and errors reported to clients when several statements fails #3177
• Fix several memory leaks detected by valgrind: #3204
  • Fixed memory leak in 'save_mysql_servers_runtime_to_database' due to non-freed resultset.
  • Updated 'mariadb_lib.c.patch' with a memory leak fix for 'mysql_close_no_command'.
• Fixed ProxySQL Native Galera support stop to work after PROXYSQL RESTART. #2330
• Fixed connections not being cleaned up when 'match_tracked_options' always failing. #3201
• Fix for AWS Aurora 2.9 change in 'MASTER_SESSION_ID' 'REPLICA_LAG_IN_MILLISECONDS'. Replication lag for 'MASTER_SESSION_ID' is now asumed to be '0'. #3234
• Fixes correctly setting collations requested during connection phase and for 'MYSQL_CHANGE_USER'. This fix workarounds two MySQL bugs: #3249
  • https://bugs.mysql.com/bug.php?id=102265
  • https://bugs.mysql.com/bug.php?id=102266
• Fixes abort during startup in ARM CentOS systems due to unsupported pagesize by jemalloc. #3256
• Fixed small memory leak during query rules creation. #3262
• Fixed invalids writes and reads due to writing outside buffer boundaries in 'MySQL_HostGroups_Manager::update_group_replication_set_writer'. #3263
• Fixed invalid cluster state reached for 'MySQL Group Replication' after node failure. #3266

MD5s:

c064d6ef9b18f6ff16d9242d72b4d4e8  proxysql-2.0.16-1-centos67.x86_64.rpm
a0c7038b74809647ae588236cd769a94  proxysql-2.0.16-1-centos7.aarch64.rpm
38c7d3eb82209a5a0f9db994ee80b67d  proxysql-2.0.16-1-centos7.x86_64.rpm
1014f5ac8ca5df8a50024328b2da77cc  proxysql-2.0.16-1-centos8.aarch64.rpm
721ba3af14f79f2dc1129292464cb209  proxysql-2.0.16-1-centos8.x86_64.rpm
bfa3c43193cbbb666ff21b173bd4febf  proxysql-2.0.16-1-dbg-centos67.x86_64.rpm
76d8c9faa50495a42e934ac7d63f8071  proxysql-2.0.16-1-dbg-centos7.x86_64.rpm
b6ab87cb26e3344c6ddc8fccfb56a6a0  proxysql-2.0.16-1-dbg-centos8.x86_64.rpm
11fd0f0686118ff96bc098d0e767a145  proxysql-2.0.16-1-dbg-fedora24.x86_64.rpm
2ab20ffa1f0599a2484a772e73b6fb7f  proxysql-2.0.16-1-dbg-fedora27.x86_64.rpm
79bda95e010c051fe5210067cd4152aa  proxysql-2.0.16-1-dbg-fedora28.x86_64.rpm
b6778ed336bfac0c11ebf47a25aab695  proxysql-2.0.16-1-fedora24.x86_64.rpm
95599f80609d636c5e10585754f21836  proxysql-2.0.16-1-fedora27.x86_64.rpm
e82decb6b12a424a302826abf2a98fa1  proxysql-2.0.16-1-fedora28.x86_64.rpm
50ad65b34e8b1530d173706922d1eaa5  proxysql_2.0.16-dbg-debian10_amd64.deb
d4944deebbe5cafd93c95cf586c74f7f  proxysql_2.0.16-dbg-debian8_amd64.deb
65990b610cb3e80a3b3a3f4469804994  proxysql_2.0.16-dbg-debian9_amd64.deb
710ad504721191bab611a41b452687c8  proxysql_2.0.16-dbg-ubuntu14_amd64.deb
181270114df6c32decf78b9e72e98e20  proxysql_2.0.16-dbg-ubuntu16_amd64.deb
520e28a5f8fc4a67ae9d8847d565d137  proxysql_2.0.16-dbg-ubuntu18_amd64.deb
196868d86084a09527964def6b776149  proxysql_2.0.16-dbg-ubuntu20_amd64.deb
206de1c048e8b4d404dd26a5564a084b  proxysql_2.0.16-debian10_amd64.deb
15caf5fe165a08c446e1d3a27d0948e3  proxysql_2.0.16-debian10_arm64.deb
ff6a1ff17886bd464d4c5b2c7a861d24  proxysql_2.0.16-debian8_amd64.deb
a43b93ce4162537086d2f7bf04eee684  proxysql_2.0.16-debian9_amd64.deb
27fd01a789cdfdcbfceba20408a8db49  proxysql_2.0.16-debian9_arm64.deb
3c0625acfe238d9934e75c03649ee992  proxysql_2.0.16-ubuntu14_amd64.deb
823f50d64fbc6d3c89433f81dd17c7e0  proxysql_2.0.16-ubuntu16_amd64.deb
422a634c59ab55fed2c0eb34a9fa70ad  proxysql_2.0.16-ubuntu18_amd64.deb
eb940388c95711c00ab5dec1c5f1fd9f  proxysql_2.0.16-ubuntu18_arm64.deb
2ae54e2af69879936abb494a5016f2ab  proxysql_2.0.16-ubuntu20_amd64.deb
164650f61bc09247a882b9b7ab503f39  proxysql_2.0.16-ubuntu20_arm64.deb

SHA1s:

203103a3fcfb96ac5341204daf77d8496b6800cb  proxysql-2.0.16-1-centos67.x86_64.rpm
f1296510e4e36111f4ed6da2aa54bca3019a7cfc  proxysql-2.0.16-1-centos7.aarch64.rpm
5fdb74b0649cd1558b9d4f7da582f4b2ae3496b9  proxysql-2.0.16-1-centos7.x86_64.rpm
cf9fa705c417d4eb1c0246dcd7d6182178430c7e  proxysql-2.0.16-1-centos8.aarch64.rpm
5f5649ed76afc056428d11b3a6ff07f1b2e98f5b  proxysql-2.0.16-1-centos8.x86_64.rpm
1d0ee2e909f1e76e958a22db94a8217e53c9606a  proxysql-2.0.16-1-dbg-centos67.x86_64.rpm
0d66b407692075402b28b544879980a9a3d8117f  proxysql-2.0.16-1-dbg-centos7.x86_64.rpm
a0fb9865d1780e2ac219d724ed384b9390818fe1  proxysql-2.0.16-1-dbg-centos8.x86_64.rpm
b60d4a8395d129f8cfef208cea0a53d8c7baf105  proxysql-2.0.16-1-dbg-fedora24.x86_64.rpm
01cdb5f1a3984d89eb55b14f1c6dea98de94db78  proxysql-2.0.16-1-dbg-fedora27.x86_64.rpm
335612671875209dd3d25e9798b9fff74b907072  proxysql-2.0.16-1-dbg-fedora28.x86_64.rpm
6835c3ec8a8f2f4848ae5b213d0478863de5243d  proxysql-2.0.16-1-fedora24.x86_64.rpm
5007159cdfd09c5e89b5b143da69b1ea0815d1ce  proxysql-2.0.16-1-fedora27.x86_64.rpm
31ddc44164fbe66f9d8d17f79d37d9e9c33458a1  proxysql-2.0.16-1-fedora28.x86_64.rpm
1b62297b492ea1d2ec77838ac5973d398f81bd43  proxysql_2.0.16-dbg-debian10_amd64.deb
0613d11e3c1641d5d6fa55c289388c1f7d98b114  proxysql_2.0.16-dbg-debian8_amd64.deb
c0bcdbb3f07f0f3e58a1355bead5b0d5268505b7  proxysql_2.0.16-dbg-debian9_amd64.deb
b1a63c1f2c11ec8d5ccf4aa37908be8f85efb626  proxysql_2.0.16-dbg-ubuntu14_amd64.deb
d16fa73bc52dda92e5d317736872a9f045ef8452  proxysql_2.0.16-dbg-ubuntu16_amd64.deb
fe2156741a2e6e09251a5c8a09d1129b1b914c43  proxysql_2.0.16-dbg-ubuntu18_amd64.deb
3de8acff3837ea965ea4b40f958893e5dd2e8a1f  proxysql_2.0.16-dbg-ubuntu20_amd64.deb
790b8641ab92015e9fee28916dc8ddb0e9641064  proxysql_2.0.16-debian10_amd64.deb
d8c9a30a8682467f2b9342ddd4d909a346e682bc  proxysql_2.0.16-debian10_arm64.deb
12a27b433203c17896ba0e87cacd89fe048a9e04  proxysql_2.0.16-debian8_amd64.deb
e0b8ccea139a62b71362e43db6741e2d4641cea5  proxysql_2.0.16-debian9_amd64.deb
a6e7489222d0981829abb0543792a50eebe00cea  proxysql_2.0.16-debian9_arm64.deb
a19b5d91535f6ba6c0e001bd448c4254e4cfdbd5  proxysql_2.0.16-ubuntu14_amd64.deb
85c34911e8f628ef1a2473e7a1bbd615ad2bc70a  proxysql_2.0.16-ubuntu16_amd64.deb
fb4e9239087485f0a25d5425699fb1e7a7ea7a83  proxysql_2.0.16-ubuntu18_amd64.deb
7253b02889b28319f3ec2af337d8d43d23f0b016  proxysql_2.0.16-ubuntu18_arm64.deb
639ab6e229c46742be4bb98f78b58f773c6d5650  proxysql_2.0.16-ubuntu20_amd64.deb
804329078b2a64747e250ef260b37325d4859a4e  proxysql_2.0.16-ubuntu20_arm64.deb

SHA256s:

912394065550b5c0a54075dd4505d51c836baa33cbc863d0ed886412d8cd15c3  proxysql-2.0.16-1-centos67.x86_64.rpm
fa5e457abf478bd8630e37a1fae423ed69bdebee14c4aef548bf97cd11446377  proxysql-2.0.16-1-centos7.aarch64.rpm
4a42c06342bb95b472baa434181566345696bc4d50688885bab0c06f72fa2bb9  proxysql-2.0.16-1-centos7.x86_64.rpm
d85bdd7f769aa562fb61cdde8538267072e2ea149359b9e170e998fffb235a48  proxysql-2.0.16-1-centos8.aarch64.rpm
2bd325786e8df0d2d0fa34a1b1e59711555199e0071e25f920bae892485f9bcd  proxysql-2.0.16-1-centos8.x86_64.rpm
a10d57d7af5f273867b287975c731b1460620e2ab43b20ae1a81afdfdfbf1372  proxysql-2.0.16-1-dbg-centos67.x86_64.rpm
36218c9086535eaf733b0efaee4bea0025a1ec4c67016aa7f6b4a5b0751d32cf  proxysql-2.0.16-1-dbg-centos7.x86_64.rpm
a8c240e523e59c6d50da33e7db284e5a642ea4cb93369d8bf64a02180daa75bf  proxysql-2.0.16-1-dbg-centos8.x86_64.rpm
eb111568af84edc6fb9218c4656721c72ff1e184531d5a227245a43b27f0bb37  proxysql-2.0.16-1-dbg-fedora24.x86_64.rpm
22a3c1d6b07505e9ddcb2c37f14cb6d944d5176f1a0d399e42caf5ee650d130c  proxysql-2.0.16-1-dbg-fedora27.x86_64.rpm
500d11d2b3741874905477b32e91b3270c65081abbd835e8ebb89b65e065ed93  proxysql-2.0.16-1-dbg-fedora28.x86_64.rpm
5497fc738f5f42b1bea95b366be11d0c395ac3655a4930f67391b8569b3fde6b  proxysql-2.0.16-1-fedora24.x86_64.rpm
62d2c423c9e256a9e0171a2fe9e242615e4b47825837a6c1e686acbbb4c0c625  proxysql-2.0.16-1-fedora27.x86_64.rpm
084fcdf389ade63b3250732e78dccf0046f3500cc392c5497823f9e53a7a0f27  proxysql-2.0.16-1-fedora28.x86_64.rpm
305acf496f7feb01278b7d6aee4ef6d07ab11eb8313cf193be786ddf4449102e  proxysql_2.0.16-dbg-debian10_amd64.deb
aea603c2d1e51fc3efea88d4776587b8cd679e1c1fd24273f464242a6a55da82  proxysql_2.0.16-dbg-debian8_amd64.deb
b236e7d6de794416ee1570a862cedfa1f8bc5fbc8a1f552120b72761f82cbe31  proxysql_2.0.16-dbg-debian9_amd64.deb
eb21abe8c4d201d2189213d5c070830c567855945b77a17817f11ff5298ab4ee  proxysql_2.0.16-dbg-ubuntu14_amd64.deb
29b10ae839130a94e67dd543ed7fa9ecd6ef235704dc999dba5fca3d41fa1ebd  proxysql_2.0.16-dbg-ubuntu16_amd64.deb
956f774cb3b62bf4269a9381869971e8e1222c1d36cb693c8521c9eda45174a0  proxysql_2.0.16-dbg-ubuntu18_amd64.deb
661baace0fc9c2e3297b7815a38204e5396737c162767e3826aa80b0feae97f1  proxysql_2.0.16-dbg-ubuntu20_amd64.deb
e81ce716f680fc7f2c72bd23f23c707267bdbe7d230b64f99c74140d62551d43  proxysql_2.0.16-debian10_amd64.deb
6567c907144b48c776d5b58e2823c02f4d38b69de4887165310a89ab584cfd85  proxysql_2.0.16-debian10_arm64.deb
82780d62ffbc44cd915a5c2a58412cacca11402ea2f65a9b881625836ec39014  proxysql_2.0.16-debian8_amd64.deb
a3b811cba6fd3a36d09a2e9d3dc13ac1395c86e77100cd3f20f9076e65782b37  proxysql_2.0.16-debian9_amd64.deb
f692fa1b8b1f2d3d36d473e278e50e3707371c6e8473a257a741014361fb55ff  proxysql_2.0.16-debian9_arm64.deb
5cbc4a55350dc6646238842982910a9fae7e59bd8a4487463bcdd854e1a1b01e  proxysql_2.0.16-ubuntu14_amd64.deb
24082527bae962992deefe79625cb9060480089dcf1fab1009eb66e78886733f  proxysql_2.0.16-ubuntu16_amd64.deb
304a7bad0f828896e04d3faae0a51a10c72bf9d731a54cfdf4f58f8107b16677  proxysql_2.0.16-ubuntu18_amd64.deb
72e50964ed415dcda821d06549b9382a991d965e38eeb0378b32071155305126  proxysql_2.0.16-ubuntu18_arm64.deb
056632984b48ed80d1635057fd6a5b3eb329cae0ed79f52df4a00cca98c034be  proxysql_2.0.16-ubuntu20_amd64.deb
1441e4685e80e4f6c9c1e34535f1b8b113ec84628c03c89ea94e1c11d4ea5ea4  proxysql_2.0.16-ubuntu20_arm64.deb