Bugs item #938422, was opened at 2004-04-20 08:43 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=938422&group_id=22866
Category: JBossCX Group: v3.2 Status: Open Resolution: None Priority: 5 Submitted By: MarcMA (marcma12) Assigned to: Nobody/Anonymous (nobody) Summary: Negative ConnectionCount after killing conns Initial Comment: WXP Pro., Linux Debian. JDK 1.4.2_03 sse-ds-xml is attached. server.log is partially attached. JBoss 3.2.3 / JBoss 3.2.4RC1 (same problem), Sybase 12, Jconn2 (5.5) Problem: After killing connections from the databaseside manually or by accident (db-probs) the ManagedConnectionPool destroys the connections, but reanimates them after a certain period of time. It also counts negative amounts of connections while destroying them. Maybe it is destroying the connections twice? Result: There are more connections used by jboss than managed by pool. The more fatal db errors the more connections get lost. Reproduce: Prepare a setting. Watch the amount of connections in the MBean for the MCP. Watch the amount of connections from the databaseside (sp_who). Kill all opened connections from the databaseside (kill in isql). Again have a look at the connections from the databasside. All connections are gone. Watch the MBean for MCP. ConnectionCount=5. (The pool did not realize yet). Wait minimum idle-timout-minutes or do an application request. The pool gets destroyed. ConnectionCount=-5 or -4. Depends on the load of the request you have done. Again wait minimum idle-timeout-minutes. Watch amount of connections from the databaseside. Amount of connections=10. Watch ConnectionCount from MCP MBean. It says 5. Wait up to 24hours. Nothing changes. Still 10 opened connections. Hmm. Makes 5 lost connections. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=938422&group_id=22866 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
