MySQL Bugs: #96870: Contribution: Allow to disable AbandonedConnectionCleanupThread completely

Bug #96870	Contribution: Allow to disable AbandonedConnectionCleanupThread completely
Submitted:	13 Sep 2019 17:54	Modified:	25 Sep 2020 22:52
Reporter:	OCA Admin (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / J	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
This bug tracks a contribution by Andrey Turbanov (Github user: turbanoff) as described in http://github.com/mysql/mysql-connector-j/pull/41

How to repeat:
See description

Suggested fix:
See contribution code attached

Contribution submitted via Github - Allow to disable AbandonedConnectionCleanupThread completely (*) Contribution by Andrey Turbanov (Github turbanoff, mysql-connector-j/pull/41#issuecomment-531312254): I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: git_patch_306909669.txt (text/plain), 5.20 KiB.

Thank you for the contribution.

https://bugs.mysql.com/bug.php?id=97241 is a better solution.

Bug#97241 is not really an alternative to this but a complement. Both are interesting feature requests.

Posted by developer:
 
Added the following entry to the Connector/J 8.0.22 changelog: 

"When using Connector/J, the AbandonedConnectionCleanupThread thread can now be disabled completely by setting the new system property com.mysql.disableAbandonedConnectionCleanup to true when configuring the JVM. The feature is for well-behaving applications that always close all connections they create. Thanks to Andrey Turbanov for contributing to the new feature."

Thank you for your contribution that has been added to 8.0.22: https://lefred.be/content/mysql-8-0-22-thank-you-for-the-contributions/

Hello eveyone, I found out that this property has been renamed to com.mysql.cj.disableAbandonedConnectionCleanup, while on this ticket and on the release notes at [1] you find the versione without the ".cj" version...is it possible to correct the release notes at least with the correct parameter?

I refer to the maven dependency of release 8.0.22

<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>

[1] https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-22.html

Posted by developer:
 
Thanks for reporting the mistake! The name of the new property has been corrected in the Connector/J 8.0.22 changelog to com.mysql.cj.disableAbandonedConnectionCleanup.