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:
Category:Connector / J Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[13 Sep 2019 17:54] OCA Admin
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
[13 Sep 2019 17:54] OCA Admin
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.

[13 Sep 2019 18:51] MySQL Verification Team
Thank you for the contribution.
[16 Oct 2019 6:22] Yanming Zhou
https://bugs.mysql.com/bug.php?id=97241 is a better solution.
[31 Dec 2019 12:31] Filipe Silva
Bug#97241 is not really an alternative to this but a complement. Both are interesting feature requests.
[25 Sep 2020 22:52] Daniel So
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."
[20 Oct 2020 6:52] Frederic Descamps
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/
[24 Nov 2020 16:40] Flavio Pompermaier
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


[1] https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-22.html
[24 Nov 2020 22:35] Daniel So
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.