0001314: clear DBPool

Viewing Issue Simple Details [ Jump to Notes ]

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

Status

closed

Product Version

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

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.