Bug #95002 failed to close ssl connection by timeout under thread pool
Submitted: 12 Apr 2019 8:03 Modified: 16 Apr 2019 7:01
Reporter: Fangxin Flou (OCA) Email Updates:
Status: Unsupported Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.7.25 OS:Any
Assigned to: CPU Architecture:Any
Tags: SSL

[12 Apr 2019 8:03] Fangxin Flou
build thread pool (percona version) with bundled ssl, the ssl connection cannot be closed by "set @@session.wait_timeout=2" (in main.ssl test case).

If rebuild mysql with openssl (by -DWITH_SSL=system), the test case passed.

How to repeat:

enable thread pool
connect by ssl1
set @@session.wait_timeout=2

connect by ssl2
select sleep(3);
show processlist;

you will find that ssl1 does disappear from process list.
[15 Apr 2019 1:24] zhai weixiang
I think you should report the bug to mariadb or percona, as thread pool of offical mysql is close source :)
[15 Apr 2019 7:50] MySQL Verification Team
Hello Fangxin Flou,

Thank you for the report.
Agree with Zhai, also please note that MySQL Enterprise Edition binary distributions are compiled using OpenSSL. It is not possible to use yaSSL(bundled) with MySQL Enterprise Edition and MySQL Enterprise Thread Pool is an extension included in MySQL Enterprise Edition. Thank you!

[16 Apr 2019 7:01] Fangxin Flou
I just think that it may be a bug of bundled ssl