[DERBY-6440] Connections opened by ForeignTableVTI never get released

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.11.1.1
• Fix Version/s: 10.10.2.1, 10.11.1.1
• Component/s: Tools
• Assignee: Richard N. Hillegas
• Reporter: Knut Anders Hatlen
• Created: 23/Dec/13 18:25
• Updated: 09/Sep/16 09:52
• Resolved: 10/Oct/14 17:50

Description

I noticed during a run of suites.All that one database instance never got garbage collected, even after it had been shut down. It turned out it could not get garbage collected because it was still referenced from the static HashMap _connections in ForeignTableVTI. Looking closer at ForeignTableVTI, it looks as if it only calls put() and get() on the HashMap, never remove(), so its memory footprint will keep increasing as it is used.

It would be good to have some way (preferably automatic) of releasing the resources held by ForeignTableVTI when they are no longer needed.

Issue Links

• relates to: DERBY-6759 Derby 10.10 backport issue (fall 2014)