#1 Could be a logging bug. Notice how the day is always the same as the minute.
On 4/5/06, Richard Mixon <[EMAIL PROTECTED]> wrote: > > I'm still curious about the crazy logAbandoned messages - not sure how to > interpret or rely on them. I'll try a again with a briefer posting - maybe > I > was too detailed in the original post. > > We are getting strange (erroneous?) messages because of the logAbandoned > parameter: > > 1) The dates look like they are from lalaland (e.g. a date of > April 34,2006 in the second line below). > Maybe I do not understand how remove abandoned is working - the > timeout is supposed to start once a connection is determined to be > "idle". > 2) Second the abandoned objects do not appear to be in order - > they jump from 10:23 to 13:34, 13:01, 13:35, back to 10:29 (see > below). > > Here is an extract/grep from our catalina.out: > DBCP object created 2006-23-04 10:23:35 by the following code was never > closed: > DBCP object created 2006-34-04 13:34:55 by the following code was never > closed: > DBCP object created 2006-01-04 13:01:49 by the following code was never > closed: > DBCP object created 2006-35-04 13:35:00 by the following code was never > closed: > DBCP object created 2006-29-04 10:29:21 by the following code was never > closed: > DBCP object created 2006-36-04 13:36:39 by the following code was never > closed: > DBCP object created 2006-23-04 10:23:35 by the following code was never > closed: > DBCP object created 2006-36-04 13:36:43 by the following code was never > closed: > DBCP object created 2006-01-04 13:01:49 by the following code was never > closed: > DBCP object created 2006-36-04 13:36:56 by the following code was never > closed: > DBCP object created 2006-40-04 13:40:30 by the following code was never > closed: > DBCP object created 2006-15-04 15:15:02 by the following code was never > closed: > DBCP object created 2006-15-04 15:15:02 by the following code was never > closed: > DBCP object created 2006-11-04 14:11:46 by the following code was never > closed: > DBCP object created 2006-00-04 16:00:01 by the following code was never > closed: > DBCP object created 2006-00-04 16:00:01 by the following code was never > closed: > DBCP object created 2006-39-04 13:39:55 by the following code was never > closed: > DBCP object created 2006-00-04 16:00:02 by the following code was never > closed: > DBCP object created 2006-00-04 16:00:02 by the following code was never > closed: > DBCP object created 2006-11-04 14:11:46 by the following code was never > closed: > DBCP object created 2006-26-04 16:26:18 by the following code was never > closed: > DBCP object created 2006-26-04 16:26:18 by the following code was never > closed: > DBCP object created 2006-26-04 16:26:18 by the following code was never > closed: > > And, here's the relevant portion of our server.xml: > <Host name="acme.com" debug="0" autoDeploy="false" > appBase="/home/httpd/vhosts/acme.com"> > <Alias>www.acme.com</Alias> > <Logger className="org.apache.catalina.logger.FileLogger" > directory="logs" prefix="acme.com_log." > suffix=".txt" > timestamp="true"/> > <Context path="" docBase="httpdocs" reloadable="true" debug="0"> > <Resource name="jdbc/acme.com" auth="Container" > type="javax.sql.DataSource"/> > <ResourceParams name="jdbc/acme.com"> > <parameter> > <name>url</name> > > > <value>jdbc:mysql://localhost/acme?autoReconnect=true&zeroDateTimeBehavi > or=convertToNull&noDatetimeStringSync=true</value> > </parameter> > <parameter> > <name>driverClassName</name> > <value>com.mysql.jdbc.Driver</value> > </parameter> > > <parameter> > <name>username</name> > <value>acme</value> > </parameter> > <parameter> > <name>password</name> > <value>secret</value> > </parameter> > <parameter> > <name>removeAbandoned</name> > <value>true</value> > </parameter> > <parameter> > <name>removeAbandonedTimeout</name> > <value>60</value> > </parameter> > <parameter> > <name>logAbandoned</name> > <value>true</value> > </parameter> > </ResourceParams> > </Context> > </Host> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
