0001394: Need to invalidate all db pool connections

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001394

[Resin]

minor

always

10-09-06 12:46

10-24-06 13:50

Reporter

sam

View Status

public

Assigned To

ferg

Priority

urgent

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.0

Product Version

3.0.21

Product Build

Summary

0001394: Need to invalidate all db pool connections

Description

(rep by M Young)

We have a strange set up which utilizes oracle synonyms to redirect data
sources to different tables. Whenever we switch synonyms we get oracle
1003 (stale connection) errors over and over. What I think we need to do is
to reset/invalidate all connections in the DB pool so that the next
request will force a new connection to the DB.

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0001552) ferg 10-24-06 13:50	server/141z

Issue History
Date Modified	Username	Field	Change
10-09-06 12:46	sam	New Issue
10-24-06 13:50	ferg	Note Added: 0001552
10-24-06 13:50	ferg	Assigned To	=> ferg
10-24-06 13:50	ferg	Status	new => closed
10-24-06 13:50	ferg	Resolution	open => fixed
10-24-06 13:50	ferg	Fixed in Version	=> 3.1.0

Mantis 1.0.0rc3[^]

29 total queries executed.
26 unique queries executed.