You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-user@james.apache.org by vivek mahajan <vi...@gmail.com> on 2010/02/05 10:02:19 UTC

storing mail problem

mailet log is generating following output please tell me why i m getting
this error.

04/02/10 13:48:10 INFO  James.Mailet: Error while storing mail.
javax.mail.MessagingException: Exception caught while storing mail
Container: ;
  nested exception is:
    com.mysql.jdbc.PacketTooBigException: Packet for query is too large
(2407031 > 1048576). You can change this value on the server by setting the
max_allowed_packet' variable.
    at
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:764)
    at
org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
    at
org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
    at
org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
    at
org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
    at
org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
    at
org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
    at java.lang.Thread.run(Thread.java:636)
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too
large (2407031 > 1048576). You can change this value on the server by
setting the max_allowed_packet' variable.
    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
    at
org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
    at
org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
    ... 7 more
04/02/10 13:48:11 INFO  James.Mailet: ToRepository: Storing mail
Mail1265271490984-2 in file://var/mail/error/

Re: storing mail problem

Posted by Norman Maurer <no...@googlemail.com>.
Like the error said.. the Package is to large for mysql. You need to
adjust the mysql settings. See:

http://dev.mysql.com/doc/refman/5.1/en/packet-too-large.html

Bye,
Norman


2010/2/5 vivek mahajan <vi...@gmail.com>:
> mailet log is generating following output please tell me why i m getting
> this error.
>
> 04/02/10 13:48:10 INFO  James.Mailet: Error while storing mail.
> javax.mail.MessagingException: Exception caught while storing mail
> Container: ;
>  nested exception is:
>    com.mysql.jdbc.PacketTooBigException: Packet for query is too large
> (2407031 > 1048576). You can change this value on the server by setting the
> max_allowed_packet' variable.
>    at
> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:764)
>    at
> org.apache.james.transport.mailets.ToMultiRepository.storeMail(ToMultiRepository.java:230)
>    at
> org.apache.james.transport.mailets.ToMultiRepository.service(ToMultiRepository.java:154)
>    at
> org.apache.james.transport.mailets.LocalDelivery.service(LocalDelivery.java:66)
>    at
> org.apache.james.transport.LinearProcessor.service(LinearProcessor.java:424)
>    at
> org.apache.james.transport.JamesSpoolManager.process(JamesSpoolManager.java:405)
>    at
> org.apache.james.transport.JamesSpoolManager.run(JamesSpoolManager.java:309)
>    at java.lang.Thread.run(Thread.java:636)
> Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too
> large (2407031 > 1048576). You can change this value on the server by
> setting the max_allowed_packet' variable.
>    at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
>    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
>    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
>    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
>    at
> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
>    at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:882)
>    at
> org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
>    at
> org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepository.java:752)
>    ... 7 more
> 04/02/10 13:48:11 INFO  James.Mailet: ToRepository: Storing mail
> Mail1265271490984-2 in file://var/mail/error/
>

---------------------------------------------------------------------
To unsubscribe, e-mail: server-user-unsubscribe@james.apache.org
For additional commands, e-mail: server-user-help@james.apache.org