Bug #100657 create new sql connection to kill timeout query but not close itself
Submitted: 27 Aug 2020 10:29 Modified: 27 Sep 2020 12:36
Reporter: xiaoya deng Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:8.0.20 OS:Any
Assigned to: CPU Architecture:Any

[27 Aug 2020 10:29] xiaoya deng 
Description:
in CancelQueryTaskImpl.java line 68

cancelThread create a new sql connection but not close itself when it has killed timeout query(in other connection) 

others

in StatementImpl.java line 291,line 292

the variables cancelConn and cancelStmt is not used

How to repeat:
1. set the queryTimeout is 5 second
2. execute sql :select sleep(6)
3. show processlist in the database, you can see the threads grow up fast.
[27 Aug 2020 12:36] MySQL Verification Team 
Hello xiaoya deng,

Thank you for the report.
Could you please provide simple java test case to reproduce this issue at our end?  Thank you.

regards,
Umesh
[28 Sep 2020 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".