you can set max_allowed_packet in the command line arguments to start mysqld or in /etc/my.cnf the default is 1M (which your exception shows) I use 10M for James, but I've seen 50M emails occasionally, so its anyones guess what the "right" size is. see www.mysql.com for more details about this, and other mysql configuration options. d.
> -----Original Message----- > From: Andrew Timberlake [mailto:[EMAIL PROTECTED]] > Sent: 10 April 2002 21:45 > To: James Users List > Subject: MySQL error > > > I have set James up with a full JDBC repository but I'm getting errors > when I send any large messages. > > It seems that MySQL is the problem. > Does anyone have a solution to this??? > > TIA > > Andrew > > This is the error printed to the console: > > Phoenix 4.0a4 > > Application file:/usr/java/james/apps/james.sar uses a deprecated > packaging format. > James 2.0a3-cvs > Started POP3 Server plain:110 > Started SMTP Server plain:25 > java.lang.IllegalArgumentException: Packet is larger than > max_allowed_packet from server configuration of 1048576 bytes > at org.gjt.mm.mysql.Buffer.ensureCapacity(Unknown Source) > at org.gjt.mm.mysql.Buffer.writeBytesNoNull(Unknown Source) > at org.gjt.mm.mysql.PreparedStatement.execute(Unknown Source) > at > org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailR > epository.java:407) > at > org.apache.james.mailrepository.JDBCSpoolRepository.store(JDBCSpoo > lRepository.java:176) > at org.apache.james.James.sendMail(James.java:253) > at java.lang.reflect.Method.invoke(Native Method) > at > org.apache.avalon.phoenix.components.application.BlockInvocationHa > ndler.invoke(BlockInvocationHandler.java:91) > at $Proxy9.sendMail(Unknown Source) > at > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:602) > at > org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java:251) > at > org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandl > er.java:163) > at > org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.r > un(Connection.java:167) > at > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute > (ExecutableRunnable.java:47) > at > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThr > ead.java:86) > javax.mail.MessagingException: Exception spooling message: > Exception caught while storing mail Container: > java.lang.IllegalArgumentException: Packet is larger than > max_allowed_packet from server configuration of 1048576 bytes; > nested exception is: > java.lang.RuntimeException: Exception caught while storing > mail Container: java.lang.IllegalArgumentException: Packet is > larger than max_allowed_packet from server configuration of 1048576 bytes > at org.apache.james.James.sendMail(James.java:259) > at java.lang.reflect.Method.invoke(Native Method) > at > org.apache.avalon.phoenix.components.application.BlockInvocationHa > ndler.invoke(BlockInvocationHandler.java:91) > at $Proxy9.sendMail(Unknown Source) > at > org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:602) > at > org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java:251) > at > org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandl > er.java:163) > at > org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.r > un(Connection.java:167) > at > org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute > (ExecutableRunnable.java:47) > at > org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThr > ead.java:86) > > > -- > Andrew Timberlake > Digital Design Development > http://www.ddd.co.za > mailto:[EMAIL PROTECTED] > 011 705 1737 > 082 415 8283 > > "If debugging is the process of removing bugs, > then programming must be the process of putting them in." > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
