Here is a small segment from my mailet log. This is the first occurance of
the error. There are hundreds of others below these lines. This is in the
middle of my loop sending the mail to the addresses in the list.
Looking closer at this, I notice that James has lost contact with mySQL.
However in between the container exceptions, my queries to the same mySQL
are working just fine. So where I originally thought this might be mySQL
running out of resources, I now don't think that's the case.
20/03/06 08:50:44 INFO James.Mailet: JWMMailList:
javax.mail.MessagingException: Exception spooling message: Exception caught
while storing mail Container: java.sql.SQLException: Cannot connect to MySQL
server on 127.0.0.1:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.BindException);
nested exception is:
class javax.mail.MessagingException: Exception caught while storing
mail Container: java.sql.SQLException: Cannot connect to MySQL server on
127.0.0.1:3306. Is there a MySQL server running on the machine/port you are
trying to connect to? (java.net.BindException)
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: .......Sending to:
[EMAIL PROTECTED] -- Sessler, Fran
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (DBQuery)
SELECT * FROM MESSAGETEXT WHERE 1 AND ( LABEL = 'footerhtml' )
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (Info)
DBTableObject.executeQuery() - SELECT * FROM MESSAGETEXT WHERE 1 AND (
LABEL = 'footerhtml' )
20/03/06 08:50:44 INFO James.Mailet: IsInfected: Part:
C:\james_virus_scan\scan\virus2783111342068123183\part43619.tt
20/03/06 08:50:44 INFO James.Mailet: IsInfected: Part:
C:\james_virus_scan\scan\virus2783111342068123183\part43620.tt
20/03/06 08:50:44 INFO James.Mailet: IsInfected: exec: "C:\Program
Files\CA\SharedComponents\ScanEngine\Inocmd32.exe" -VER
-LIS:\james_virus_scan\scan\virus2783111342068123183\scanReport.txt
\james_virus_scan\scan\virus2783111342068123183
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (Info)
DBTableObject.executeQuery() done <############### my query succeeded ##
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (Trace)
recordFound=true
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (DBQuery)
SELECT * FROM MESSAGETEXT WHERE 1 AND ( LABEL = 'footerhtml' )
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (Info)
DBTableObject.executeQuery() - SELECT * FROM MESSAGETEXT WHERE 1 AND (
LABEL = 'footerhtml' )
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (Info)
DBTableObject.executeQuery() done
20/03/06 08:50:44 INFO James.Mailet: Mar 20, 2006 8:50:44 AM (Trace)
recordFound=true
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: New mail - sender:
[EMAIL PROTECTED], recipients:
[EMAIL PROTECTED], name:
Mail1142866106148-9536-!912038, remoteHost: JWMHosting, remoteAddr:
64.34.176.28, state: root, lastUpdated: Mon Mar 20 08:48:26 CST 2006,
errorMessage: null
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: Message resent unaltered.
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: recipients set to:
[xxxxxjeffsautobodyrepair.com]
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: apparentlyTo set to:
[EMAIL PROTECTED]
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: MESSAGE_ID restored to:
<[EMAIL PROTECTED]>
20/03/06 08:50:44 INFO James.Mailet: JWMMailList:
javax.mail.MessagingException: Exception spooling message: Exception caught
while storing mail Container: java.sql.SQLException: Cannot connect to MySQL
server on 127.0.0.1:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.BindException);
nested exception is:
class javax.mail.MessagingException: Exception caught while storing
mail Container: java.sql.SQLException: Cannot connect to MySQL server on
127.0.0.1:3306. Is there a MySQL server running on the machine/port you are
trying to connect to? (java.net.BindException)
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: Close Connection
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: java.sql.SQLException:
Cannot connect to MySQL server on 127.0.0.1:3306. Is there a MySQL server
running on the machine/port you are trying to connect to?
(java.net.BindException)
20/03/06 08:50:44 INFO James.Mailet: JWMMailList: JDBCMailLog: Unexpected
exception while closing database connection.
20/03/06 08:50:47 INFO James.Mailet: RemoteDelivery: Exception delivering
message (Mail1142866106148-9536-!442689-to-austin.rr.com) - IOException
while sending message;
nested exception is:
java.io.IOException: java.sql.SQLException: Cannot connect to MySQL
server on 127.0.0.1:3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.BindException)
-----Original Message-----
From: Stefano Bagnara [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006 2:02 PM
To: James Users List
Subject: Re: Mail List Mailet Infinite Loop on db failure
JWM wrote:
> I don't have any stack traces. In the mailet log, it is happily
processing
> through the mail list, then there is an exception saying it can't get
> connection to mySQL. Then the maillist starts over just like it was a
brand
> new note. It starts sending to the list again and the same exception
> occurs, etc. etc. until I delete the message from the spool. The
connection
> problem with mySQL is an issue. But the biggest concern is to tame this
> infinite loop that results from it or any other possible error. Once
that's
> done, I'll figure out the mySQL connection problem.
Please post the exact text you get in the logs (about the exception). If
you don't have the stacktrace at least we can find which line print that
text!
Stefano
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
