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]>