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