You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@struts.apache.org by Michael Muller <mm...@theworld.com> on 2003/07/08 02:35:15 UTC

getConnection loop shutting down


i start tomcat, make one database call (that throws an uncaught
exception), and then shut tomcat down.

when i shut down tomcat, it goes into a loop connecting to the database. 
  some of the log is attached.

i have also seen it go into a different loop, one where it's waiting for 
(i assume) the DB connections to be freed.

   -- mike


Jul 7, 2003 6:08:44 PM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on port 8080
Jul 7, 2003 6:08:44 PM org.apache.jk.common.ChannelSocket init
INFO: JK2: ajp13 listening on /0.0.0.0:8009
Jul 7, 2003 6:08:45 PM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/90  config=C:\Program
Files\jakarta-tomcat-4.1.18-LE-jdk14\bin\..\conf\jk2.properties
Jul 7, 2003 6:09:26 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing,
config='org.apache.struts.taglib.logic.LocalStrings', returnNull=true
Jul 7, 2003 6:09:26 PM org.apache.struts.tiles.TilesRequestProcessor
initDefinitionsMapping
INFO: Tiles definition factory found for request processor ''.
Jul 7, 2003 6:09:26 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings',
returnNull=true
Jul 7, 2003 6:09:26 PM org.apache.struts.util.PropertyMessageResources
<init>
INFO: Initializing, config='org.apache.struts.util.LocalStrings',
returnNull=true
Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:   getConnection()
Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:    Check for timeout, activeCount=1, useCount=0
Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:    Found available connection
Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:    Return allocated connection, activeCount=1, useCount=1
Jul 7, 2003 6:09:29 PM org.apache.struts.action.RequestProcessor
processException
WARNING: Unhandled Exception thrown: class java.sql.SQLException
Stopping service Tomcat-Standalone
Jul 7, 2003 6:11:06 PM org.apache.struts.tiles.TilesRequestProcessor
initDefinitionsMapping
INFO: Tiles definition factory found for request processor ''.
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:   getConnection()
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:    Check for timeout, activeCount=1, useCount=1
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
createConnection
INFO:    createConnection()
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:    Return new connection, activeCount=2, useCount=2
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:   getConnection()
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
getConnection
INFO:    Check for timeout, activeCount=1, useCount=2
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
createConnection
INFO:    createConnection()
Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
getConnection





---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org


Re: getConnection loop shutting down

Posted by Michael Muller <mm...@theworld.com>.
My apologies, pilot error.  I wasn't closing my db connections in a 
finally block.

Odd failure mode on Tomcat's part, though.

   -- Mike

Michael Muller wrote:

> 
> 
> i start tomcat, make one database call (that throws an uncaught
> exception), and then shut tomcat down.
> 
> when i shut down tomcat, it goes into a loop connecting to the database. 
>  some of the log is attached.
> 
> i have also seen it go into a different loop, one where it's waiting for 
> (i assume) the DB connections to be freed.
> 
>   -- mike
> 
> 
> Jul 7, 2003 6:08:44 PM org.apache.coyote.http11.Http11Protocol start
> INFO: Starting Coyote HTTP/1.1 on port 8080
> Jul 7, 2003 6:08:44 PM org.apache.jk.common.ChannelSocket init
> INFO: JK2: ajp13 listening on /0.0.0.0:8009
> Jul 7, 2003 6:08:45 PM org.apache.jk.server.JkMain start
> INFO: Jk running ID=0 time=0/90  config=C:\Program
> Files\jakarta-tomcat-4.1.18-LE-jdk14\bin\..\conf\jk2.properties
> Jul 7, 2003 6:09:26 PM org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing,
> config='org.apache.struts.taglib.logic.LocalStrings', returnNull=true
> Jul 7, 2003 6:09:26 PM org.apache.struts.tiles.TilesRequestProcessor
> initDefinitionsMapping
> INFO: Tiles definition factory found for request processor ''.
> Jul 7, 2003 6:09:26 PM org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing, config='org.apache.struts.taglib.html.LocalStrings',
> returnNull=true
> Jul 7, 2003 6:09:26 PM org.apache.struts.util.PropertyMessageResources
> <init>
> INFO: Initializing, config='org.apache.struts.util.LocalStrings',
> returnNull=true
> Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:   getConnection()
> Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:    Check for timeout, activeCount=1, useCount=0
> Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:    Found available connection
> Jul 7, 2003 6:09:29 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:    Return allocated connection, activeCount=1, useCount=1
> Jul 7, 2003 6:09:29 PM org.apache.struts.action.RequestProcessor
> processException
> WARNING: Unhandled Exception thrown: class java.sql.SQLException
> Stopping service Tomcat-Standalone
> Jul 7, 2003 6:11:06 PM org.apache.struts.tiles.TilesRequestProcessor
> initDefinitionsMapping
> INFO: Tiles definition factory found for request processor ''.
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:   getConnection()
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:    Check for timeout, activeCount=1, useCount=1
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> createConnection
> INFO:    createConnection()
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:    Return new connection, activeCount=2, useCount=2
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:   getConnection()
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> INFO:    Check for timeout, activeCount=1, useCount=2
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> createConnection
> INFO:    createConnection()
> Jul 7, 2003 6:11:06 PM org.apache.struts.legacy.GenericDataSource
> getConnection
> 
> 
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: struts-user-help@jakarta.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: struts-user-help@jakarta.apache.org