Bug #87451 5.1.43: connector/j leaks on the client with server-side prepared statements

• Submitted: 17 Aug 2017 6:31
• Modified: 22 Aug 2017 18:07
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Duplicate
• Category: Connector / J
• Severity: S1 (Critical)
• Version: 5.1.43
• OS: Any
• CPU Architecture: Any

[17 Aug 2017 6:31] Shane Bester

Description:
Connector/J 5.1.42 leaks on the server-side.
Since fix of https://bugs.mysql.com/bug.php?id=74932 that is solved.

But now a leak occurs on the client, and can be seen by ever increasing "Surviving Generations" in the GC runs.

How to repeat:
I'll attach a standalone testcase.  Profile client GC and heap usage while it is running.

[17 Aug 2017 8:04] MySQL Verification Team

a picture of how the testcase memory usage looks in jvisualvm

Attachment: jvisualvm_the_leak.png (image/png, text), 80.71 KiB.

[17 Aug 2017 8:10] MySQL Verification Team

Oops I hadn't noticed recent bug.  Looks related or same.. not sure.

https://bugs.mysql.com/bug.php?id=87429

[17 Aug 2017 14:51] Eduard Gurskiy

I've attached built fix to related issue. Please try it.

[22 Aug 2017 18:07] Filipe Silva

Hi Shane,

I confirm that this bug is a duplicate of Bug#87429.