0005890: jdbc connection leak with the following configuration

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0005890

[Resin]

minor

always

04-30-15 11:53

06-03-15 08:59

Reporter

alex

View Status

public

Assigned To

ferg

Priority

normal

Resolution

unable to reproduce

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

Product Version

4.0.43

Product Build

Summary

0005890: jdbc connection leak with the following configuration

Description

rep. by Sujit Bhattacharyya
<database jndi-name='jdbc/xxxx'>
         <driver>
           <type>oracle.jdbc.OracleDriver</type>
           <url>jdbc:oracle:thin:@10.0.0.xx:1521:orcl</url>
           <user>xxxx</user>
           <password>xxxx</password>
         </driver>
<close-dangling-connections>true</close-dangling-connections>
         <max-pool-time>20s</max-pool-time>
         <max-connections>5000</max-connections>
        <max-idle-time>5s</max-idle-time>
         <max-active-time>20s</max-active-time>
         <connection-wait-time>10s</connection-wait-time>
         <max-create-connections>500</max-create-connections>
       </database>

Steps To Reproduce

Additional Information

Smaller JVM Heap make finalize call occur (on UserConnection) which closes the connection and frees oracle process.

Attached Files

Relationships

Notes
(0006637) ferg 06-03-15 08:59	Applications are responsible for closing their UserConnection. The close-danging-connection only protects connections opened in a servlet request. If an application opens a connection in a different thread, it must close the connection itself.

Issue History
Date Modified	Username	Field	Change
04-30-15 11:53	alex	New Issue
06-03-15 08:59	ferg	Note Added: 0006637
06-03-15 08:59	ferg	Assigned To	=> ferg
06-03-15 08:59	ferg	Status	new => closed
06-03-15 08:59	ferg	Resolution	open => unable to reproduce

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.