[SOLVED] delivery fails with 451 error for one particular mailbox

[sysinternals]

as a follow up for my previous post, there is a remaining issue.

one of the users is complaining he can't receive mail, when I chet it I see all of his email is deferred with a "451 try again later" messaje and all his email queues up.

It only happens for this mailbox, the remaining 50 ones are working fine.

here's an example from maillog:

Mar 11 14:41:48 zimbra postfix/lmtp[14085]: 9B3BC43C006: to=<someuser@example.com>, relay=zimbra.example.com[172.16.8.61]:7025, delay=55775, delays=55773/0.05/0.03/2.1, dsn=4.0.0, status=deferred (host zimbra.example.com[172.16.8.61] said: 451 4.0.0 Temporary message delivery failure try again (in reply to end of DATA command))

if I check the mailbox.log I see the following:

2010-03-11 00:12:14,099 INFO [LmtpServer-29] [name=someuser@example.com;mid=53;] lmtp - try again for message someuser@example.com: exception occurred
com.zimbra.common.service.ServiceException: system failure: writing new object of type 5
ExceptionId:LmtpServer-29:1268273534096:1d5ecb8ececd588f
Code:service.FAILURE

at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java :168)
at com.zimbra.cs.mailbox.Message.createInternal(Messa ge.java:400)
at com.zimbra.cs.mailbox.Message.create(Message.java: 324)
at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(M ailbox.java:4866)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4728)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4684)
at com.zimbra.cs.filter.ZimbraMailAdapter.addMessage( ZimbraMailAdapter.java:414)
at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFi ling(ZimbraMailAdapter.java:408)
at com.zimbra.cs.filter.ZimbraMailAdapter.executeActi ons(ZimbraMailAdapter.java:266)
at org.apache.jsieve.SieveFactory.evaluate(SieveFacto ry.java:159)
at com.zimbra.cs.filter.RuleManager.applyRules(RuleMa nager.java:196)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes(ZimbraLmtpBacke
nd.java:379)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (ZimbraLmtpBackend.java:138)
at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(LmtpHandler.java:375)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(TcpLmtpHandler.java:67)
at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa ndler.java:364)
at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(LmtpHandler.java:174)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(TcpLmtpHandler.java:61)
at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:160)
at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:128)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnect ionException: Communications link failu
re due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1913 )
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2304)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2803)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:15 73)
at com.mysql.jdbc.ServerPreparedStatement.serverExecu te(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInte rnal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:1299)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedState
ment.java:233)
at com.zimbra.cs.db.DbMailItem.create(DbMailItem.java :150)
at com.zimbra.cs.mailbox.Message.createInternal(Messa ge.java:400)
at com.zimbra.cs.mailbox.Message.create(Message.java: 324)
at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(M ailbox.java:4866)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4728)
at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.j ava:4684)
at com.zimbra.cs.filter.ZimbraMailAdapter.addMessage( ZimbraMailAdapter.java:414)
at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFi ling(ZimbraMailAdapter.java:408)
at com.zimbra.cs.filter.ZimbraMailAdapter.executeActi ons(ZimbraMailAdapter.java:266)
at org.apache.jsieve.SieveFactory.evaluate(SieveFacto ry.java:159)
at com.zimbra.cs.filter.RuleManager.applyRules(RuleMa nager.java:196)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver MessageToLocalMailboxes(ZimbraLmtpBacke
nd.java:379)
at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver (ZimbraLmtpBackend.java:138)
at com.zimbra.cs.lmtpserver.LmtpHandler.processMessag eData(LmtpHandler.java:375)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDA TA(TcpLmtpHandler.java:67)
at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHa ndler.java:364)
at com.zimbra.cs.lmtpserver.LmtpHandler.processComman d(LmtpHandler.java:174)
at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCom mand(TcpLmtpHandler.java:61)
at com.zimbra.cs.tcpserver.ProtocolHandler.processCon nection(ProtocolHandler.java:160)
at com.zimbra.cs.tcpserver.ProtocolHandler.run(Protoc olHandler.java:128)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Wo rker.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

any ideas/pointers on were I could find the cause of the problem?

Thanks for your help

[sysinternals]

I solved it.

This is what I did:

created a new account
moved over the messages to the new account with imapsync
deleted the old account
re-created it
moved the messages back with imapsync

I guess there must be a better way, but that worked for me

Fer