0005890: jdbc connection leak with the following configuration

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ 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

Status

closed

Product Version

4.0.43

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>

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.