[JBoss JIRA] Created: (JBAS-5526) DB Connections established which fail check-valid-connection-sql do not immediatly close their connection
7:21 p.m.
DB Connections established which fail check-valid-connection-sql do not immediatly close
their connection
---------------------------------------------------------------------------------------------------------
Key: JBAS-5526
URL: http://jira.jboss.com/jira/browse/JBAS-5526
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public (Everyone can see)
Affects Versions: JBossAS-4.2.2.GA
Environment: Red Hat Enterprise 5.1, MS SQL Server 2005
Reporter: Dan Killey
When a DB connection is attempted to be created where it is configured with
check-valid-connection-sql, if the socket/connection succeeds but the
check-valid-connection-sql statement fails a connection remains open until GC. In a large
volume environment this can lead to many sockets being opened until GC occurs and can thus
run into file handle limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:40 a.m.
New subject: [JBoss JIRA] Updated: (JBAS-5526) DB Connections established which fail check-valid-connection-sql do not immediatly close their connection
[ http://jira.jboss.com/jira/browse/JBAS-5526?page=all ]
Adrian Brock updated JBAS-5526:
-------------------------------
Component/s: JCA service
Fix Version/s: JBossAS-5.0.0.CR1
JBossAS-4.2.3.GA
Description:
When a DB connection is attempted to be created where it is configured with
check-valid-connection-sql, if the socket/connection succeeds but the new-connection-sql
statement fails a connection remains open until GC. In a large volume environment this can
lead to many sockets being opened until GC occurs and can thus run into file handle
limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
was:
When a DB connection is attempted to be created where it is configured with
check-valid-connection-sql, if the socket/connection succeeds but the
check-valid-connection-sql statement fails a connection remains open until GC. In a large
volume environment this can lead to many sockets being opened until GC occurs and can thus
run into file handle limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
Assignee: Adrian Brock
DB Connections established which fail check-valid-connection-sql do
not immediatly close their connection
---------------------------------------------------------------------------------------------------------
Key: JBAS-5526
URL: http://jira.jboss.com/jira/browse/JBAS-5526
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: JCA service
Affects Versions: JBossAS-4.2.2.GA
Environment: Red Hat Enterprise 5.1, MS SQL Server 2005
Reporter: Dan Killey
Assigned To: Adrian Brock
Fix For: JBossAS-4.2.3.GA, JBossAS-5.0.0.CR1
When a DB connection is attempted to be created where it is configured with
check-valid-connection-sql, if the socket/connection succeeds but the new-connection-sql
statement fails a connection remains open until GC. In a large volume environment this can
lead to many sockets being opened until GC occurs and can thus run into file handle
limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:42 a.m.
New subject: [JBoss JIRA] Updated: (JBAS-5526) DB Connections established which fail check-valid-connection-sql do not immediatly close their connection
[ http://jira.jboss.com/jira/browse/JBAS-5526?page=all ]
Adrian Brock updated JBAS-5526:
-------------------------------
Description:
When a DB connection is attempted to be created where it is configured with
new-connection-sql, if the socket/connection succeeds but the new-connection-sql statement
fails a connection remains open until GC. In a large volume environment this can lead to
many sockets being opened until GC occurs and can thus run into file handle limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
was:
When a DB connection is attempted to be created where it is configured with
check-valid-connection-sql, if the socket/connection succeeds but the new-connection-sql
statement fails a connection remains open until GC. In a large volume environment this can
lead to many sockets being opened until GC occurs and can thus run into file handle
limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
DB Connections established which fail check-valid-connection-sql do
not immediatly close their connection
---------------------------------------------------------------------------------------------------------
Key: JBAS-5526
URL: http://jira.jboss.com/jira/browse/JBAS-5526
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: JCA service
Affects Versions: JBossAS-4.2.2.GA
Environment: Red Hat Enterprise 5.1, MS SQL Server 2005
Reporter: Dan Killey
Assigned To: Adrian Brock
Fix For: JBossAS-4.2.3.GA, JBossAS-5.0.0.CR1
When a DB connection is attempted to be created where it is configured with
new-connection-sql, if the socket/connection succeeds but the new-connection-sql statement
fails a connection remains open until GC. In a large volume environment this can lead to
many sockets being opened until GC occurs and can thus run into file handle limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6:44 a.m.
New subject: [JBoss JIRA] Closed: (JBAS-5526) DB Connections established which fail check-valid-connection-sql do not immediatly close their connection
[ http://jira.jboss.com/jira/browse/JBAS-5526?page=all ]
Adrian Brock closed JBAS-5526.
------------------------------
Resolution: Done
This also effects other "initialization" done on the connections,
e.g. setting the transaction isolation level.
This has been fixed by catching all errors from connection initialization
in the resource adapters and closing the connection when one occurs.
I also fixed a similar issue in the JMS resource adapter, e.g. where the connection
could be constructed but the session creation throws an error.
DB Connections established which fail check-valid-connection-sql do
not immediatly close their connection
---------------------------------------------------------------------------------------------------------
Key: JBAS-5526
URL: http://jira.jboss.com/jira/browse/JBAS-5526
Project: JBoss Application Server
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: JCA service
Affects Versions: JBossAS-4.2.2.GA
Environment: Red Hat Enterprise 5.1, MS SQL Server 2005
Reporter: Dan Killey
Assigned To: Adrian Brock
Fix For: JBossAS-5.0.0.CR1, JBossAS-4.2.3.GA
When a DB connection is attempted to be created where it is configured with
new-connection-sql, if the socket/connection succeeds but the new-connection-sql statement
fails a connection remains open until GC. In a large volume environment this can lead to
many sockets being opened until GC occurs and can thus run into file handle limits.
If a valid TCP connection was established, but the SQL fails, I am suggesting the
connection should also be closed at the time of failure, not waiting till GC.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
6637
days inactive
6637
days old
3 comments
2 participants
participants (2)
-
Adrian Brock (JIRA) -
Dan Killey (JIRA)