pgoldstein 2002/11/24 13:15:43
Modified: www FAQ.html
src/xdocs FAQ.xml
Log:
Updated the FAQ to include Noel's max_packet_size issue on MySQL.
Revision Changes Path
1.19 +43 -6 jakarta-james/www/FAQ.html
Index: FAQ.html
===================================================================
RCS file: /home/cvs/jakarta-james/www/FAQ.html,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- FAQ.html 21 Nov 2002 15:20:53 -0000 1.18
+++ FAQ.html 24 Nov 2002 21:15:42 -0000 1.19
@@ -1,12 +1,9 @@
<html>
<head>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
-<title>Apache Jakarta James - Frequently Asked Questions - Java Mail and News
server, SMTP POP3 IMAP NNTP</title>
+<title>Jakarta James - Frequently Asked Questions</title>
<meta value="Danny Angus" name="author">
<meta value="[EMAIL PROTECTED]" name="email">
-<meta
content="mail,email,SMTP,POP3,NNTP,IMAP,MAILET,JAVA,WINDOWS,LINUX,server,Windows,2k,NT,98,ME,XP,Linux."
name="keywords">
-<meta content="Java mail server (mailserver) providing SMTP POP3 IMAP and News NNTP
runs on Microsoft Windows 2k,NT,98,ME,XP, and most flavours of Linux."
name="description">
-<meta content="ALL" name="ROBOTS">
<LINK TITLE="Style" HREF="stylesheet.css" TYPE="text/css" REL="stylesheet">
</head>
<body vlink="#525D76" alink="#525D76" link="#525D76" text="#000000"
bgcolor="#ffffff">
@@ -247,7 +244,7 @@
<a href="#11">Why isn't my mailet making changes to a MimeMessage?</a>
</li>
-
+
<li>
<a href="#12">How to remove unneeded services like NNTP, POP3?</a>
@@ -271,6 +268,12 @@
<a href="#15">I am using Microsoft's SQL Type 4 JDBC Driver, why do I get a "Can't
start manual transaction mode because there are cloned connections" exception?</a>
</li>
+
+<li>
+
+<a href="#16">I am using James with a MySQL database and I keep getting a "Packet
is larger than max_allowed_packet" when receiving large messages despite the fact that
my max packet size is configured to be larger than my max message size. What's going
on?</a>
+
+</li>
</ul>
@@ -870,7 +873,41 @@
</td>
</tr>
</table>
-
+
+<a name="16"></a>
+
+<table width="100%" cellpadding="2" cellspacing="0" border="0">
+<tr>
+<td bgcolor="#828DA6"><font face="arial,helvetica.sanserif" color="#ffffff"><a
name="I%20am%20using%20James%20with%20a%20MySQL%20database%20and%20I%20keep%20getting%20a%20%22Packet%20is%20larger%20than%20max_allowed_packet%22%20when%20receiving%20large%20messages%20despite%20the%20fact%20that%20my%20max%20packet%20size%20is%20configured%20to%20be%20larger%20than%20my%20max%20message%20size.%20%20What's%20going%20on?"><strong>I
am using James with a MySQL database and I keep getting a "Packet is larger than
max_allowed_packet" when receiving large messages despite the fact that my max packet
size is configured to be larger than my max message size. What's going
on?</strong></a></font></td>
+</tr>
+<tr>
+<td>
+<blockquote>
+
+<p>When a user tries to send a large message that is close to but not quite at the
max message limit the send fails and an exception similar to the following appears in
the log:</p>
+
+<p>Sent: 451 Error processing message:<br>
+ Exception spooling message: Exception caught while storing mail
Container:<br>
+ java.lang.IllegalArgumentException: Packet is larger than
max_allowed_packet<br>
+ from server configuration of 4193280 bytes;<br>
+ nested exception is:<br>
+ java.lang.RuntimeException: Exception caught while storing
mail<br>
+ Container: java.lang.IllegalArgumentException: Packet is larger
than<br>
+ max_allowed_packet from server configuration of 4193280 bytes<br>
+</p>
+
+<p>Because of how the JDBC driver is written, a 25%
+ factor is necessary between the maximum message size and the
max_packet_size
+ to prevent the driver from throwing an exception. So if you want a 4MB
+ maximum message size, you need a 5MB max_packet size. Or a 4MB
+ max_packet_size allows only a 3.2MB max message.
+ </p>
+<p>Noel Bergman</p>
+
+</blockquote>
+</td>
+</tr>
+</table>
</blockquote>
</td>
1.20 +22 -2 jakarta-james/src/xdocs/FAQ.xml
Index: FAQ.xml
===================================================================
RCS file: /home/cvs/jakarta-james/src/xdocs/FAQ.xml,v
retrieving revision 1.19
retrieving revision 1.20
diff -u -r1.19 -r1.20
--- FAQ.xml 2 Nov 2002 02:55:36 -0000 1.19
+++ FAQ.xml 24 Nov 2002 21:15:43 -0000 1.20
@@ -44,7 +44,7 @@
<li>
<a href="#11">Why isn't my mailet making changes to a
MimeMessage?</a>
</li>
- <li>
+ <li>
<a href="#12">How to remove unneeded services like NNTP, POP3?</a>
</li>
<li>
@@ -56,6 +56,9 @@
<li>
<a href="#15">I am using Microsoft's SQL Type 4 JDBC Driver, why
do I get a "Can't start manual transaction mode because there are cloned connections"
exception?</a>
</li>
+ <li>
+ <a href="#16">I am using James with a MySQL database and I keep
getting a "Packet is larger than max_allowed_packet" when receiving large messages
despite the fact that my max packet size is configured to be larger than my max
message size. What's going on?</a>
+ </li>
</ul>
</p>
</section>
@@ -278,7 +281,24 @@
<p>To solve this you need to add <b>;SelectMethod=cursor</b> to the end of your
dburl string. Your dburl string would then look something like
this<br/><dburl>jdbc:microsoft:sqlserver://dbserver.host.name:1433;SelectMethod=cursor</dburl></p>
<p>NOTE. some people have complained about performance when using this option, the
alternative is a 3rd party JDBC driver but these are often not free.<br/>Serge
Sozonoff</p>
</subsection>
-
+ <a name="16"/>
+ <subsection name="I am using James with a MySQL database and I keep
getting a "Packet is larger than max_allowed_packet" when receiving large
messages despite the fact that my max packet size is configured to be larger than my
max message size. What's going on?">
+ <p>When a user tries to send a large message that is close to but not
quite at the max message limit the send fails and an exception similar to the
following appears in the log:</p>
+ <p>Sent: 451 Error processing message:<br/>
+ Exception spooling message: Exception caught while storing mail
Container:<br/>
+ java.lang.IllegalArgumentException: Packet is larger than
max_allowed_packet<br/>
+ from server configuration of 4193280 bytes;<br/>
+ nested exception is:<br/>
+ java.lang.RuntimeException: Exception caught while storing
mail<br/>
+ Container: java.lang.IllegalArgumentException: Packet is larger
than<br/>
+ max_allowed_packet from server configuration of 4193280 bytes<br/></p>
+ <p>Because of how the JDBC driver is written, a 25%
+ factor is necessary between the maximum message size and the
max_packet_size
+ to prevent the driver from throwing an exception. So if you want a 4MB
+ maximum message size, you need a 5MB max_packet size. Or a 4MB
+ max_packet_size allows only a 3.2MB max message.
+ </p><p>Noel Bergman</p>
+ </subsection>
</section>
</body>
</document>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
