james-server-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pgoldst...@apache.org
Subject cvs commit: jakarta-james/src/xdocs FAQ.xml
Date Sun, 24 Nov 2002 21:15:43 GMT
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="danny@thought.co.uk" 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/>&lt;dburl&gt;jdbc:microsoft:sqlserver://dbserver.host.name:1433;SelectMethod=cursor&lt;/dburl&gt;</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 &quot;Packet is larger than max_allowed_packet&quot; 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:james-dev-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:james-dev-help@jakarta.apache.org>


Mime
View raw message