0001314: clear DBPool

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001314

[Resin]

minor

always

08-23-06 11:48

09-05-06 13:46

Reporter

ferg

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.0

Product Version

Product Build

Summary

0001314: clear DBPool

Description

(rep by Sergiy Proskuryakov)

Is there anyway to reset or purge connection pool in Resin w/o restarting?
We?ve had an issue with oracle giving us error - ORA-01000: maximum open cursors exceeded.
After awhile Resin has thrown this error - javax.resource.ResourceException: Connection pool is full. Can't allocate connection.

We have critical production information which got stuck.
The Resin instance is not taking any traffic right now.
We have a way to awake one of our threads which will try to post data into the database.

Our system:
Starting Resin on Sat, 19 Aug 2006 00:14:28 -0400 (EDT)
[00:14:30.016] Windows 2003 5.2 x86
[00:14:30.016] Java 1.5.0_06-b05, 32, mixed mode, Cp1252, en, Sun Microsystems Inc.
[00:14:30.016] resin.home = D:\resin-pro-3.0.20
[00:14:30.016] server.root = D:\resin-pro-3.0.20
[00:14:30.016]
[00:14:30.094] Loaded Socket JNI library.
[00:14:30.109] http listening to *:8080
[00:14:30.109] hmux listening to 127.0.0.1:6802

Steps To Reproduce

Additional Information

Attached Files

Relationships

There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
08-23-06 11:48	ferg	New Issue
09-05-06 13:46	ferg	Assigned To	=> ferg
09-05-06 13:46	ferg	Status	new => closed
09-05-06 13:46	ferg	Resolution	open => fixed
09-05-06 13:46	ferg	Fixed in Version	=> 3.1.0
09-05-06 13:46	ferg	Description Updated

Mantis 1.0.0rc3[^]

27 total queries executed.
24 unique queries executed.