Sieve - Evaluation failed

[ferrischia]

Hi


I'm currently using Zimbra Version 4.0.5_GA_518.RHEL4 Dec 18, 2006.

I encountered alot of 451 4.0.0 Temporary message delivery failure try again (DATA) error. When I look at /opt/zimbra/log/zimbra.log, I noticed that it's caused by "Sieve - Evaluation failed. Reason: null" when the mail filter of that account is trying to redirect mails.

Any way to resolve this? I'm at my wits end.


This only happened on a few accounts. Other accounts with similiar mail redirecting filters are working fine. I have tried deleting and re creating the accounts affected but the results are the same.




Thanks a bunch.

[xpinx2pin]

Hi I Had a same problem here...

Anyone can help me?

2010-04-16 16:02:12,069 ERROR [LmtpServer-459] [name=ade.yusriati@p**.com;mid=28;] Sieve - Evaluation failed. Reason: null
2010-04-16 16:02:12,069 INFO  [LmtpServer-459] [name=ade.yusriati@p**.com;mid=28;] lmtp - try again for message ade.yusriati@p**.com: exception occurred
com.zimbra.common.service.ServiceException: system failure: fetching conversation for hash aVcc6QgVOx9ikAYUtJaGmSjQ0,o=
ExceptionId:LmtpServer-459:1271408531852:778c7700b763a9ca
Code:service.FAILURE
        at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253)
        at com.zimbra.cs.db.DbMailItem.getByHash(DbMailItem.java:1957)
        at com.zimbra.cs.mailbox.Mailbox.getConversationByHash(Mailbox.java:3083)
        at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:4847)
        at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4728)
        at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4684)
        at com.zimbra.cs.filter.ZimbraMailAdapter.addMessage(ZimbraMailAdapter.java:414)
        at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFiling(ZimbraMailAdapter.java:408)
        at com.zimbra.cs.filter.ZimbraMailAdapter.executeActions(ZimbraMailAdapter.java:266)
        at org.apache.jsieve.SieveFactory.evaluate(SieveFactory.java:159)
        at com.zimbra.cs.filter.RuleManager.applyRules(RuleManager.java:196)
        at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliverMessageToLocalMailboxes(ZimbraLmtpBackend.java:379)
        at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver(ZimbraLmtpBackend.java:138)
        at com.zimbra.cs.lmtpserver.LmtpHandler.processMessageData(LmtpHandler.java:375)
        at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDATA(TcpLmtpHandler.java:67)
        at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHandler.java:364)
        at com.zimbra.cs.lmtpserver.LmtpHandler.processCommand(LmtpHandler.java:174)
        at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCommand(TcpLmtpHandler.java:61)
        at com.zimbra.cs.tcpserver.ProtocolHandler.processConnection(ProtocolHandler.java:160)
        at com.zimbra.cs.tcpserver.ProtocolHandler.run(ProtocolHandler.java:128)
        at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Communications link failure 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.java:2803)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
        at com.zimbra.cs.db.DbMailItem.getByHash(DbMailItem.java:1948)
        at com.zimbra.cs.mailbox.Mailbox.getConversationByHash(Mailbox.java:3083)
        at com.zimbra.cs.mailbox.Mailbox.addMessageInternal(Mailbox.java:4847)
        at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4728)
        at com.zimbra.cs.mailbox.Mailbox.addMessage(Mailbox.java:4684)
        at com.zimbra.cs.filter.ZimbraMailAdapter.addMessage(ZimbraMailAdapter.java:414)
        at com.zimbra.cs.filter.ZimbraMailAdapter.doDefaultFiling(ZimbraMailAdapter.java:408)
        at com.zimbra.cs.filter.ZimbraMailAdapter.executeActions(ZimbraMailAdapter.java:266)
        at org.apache.jsieve.SieveFactory.evaluate(SieveFactory.java:159)
        at com.zimbra.cs.filter.RuleManager.applyRules(RuleManager.java:196)
        at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliverMessageToLocalMailboxes(ZimbraLmtpBackend.java:379)
        at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver(ZimbraLmtpBackend.java:138)
        at com.zimbra.cs.lmtpserver.LmtpHandler.processMessageData(LmtpHandler.java:375)
        at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDATA(TcpLmtpHandler.java:67)
        at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHandler.java:364)
        at com.zimbra.cs.lmtpserver.LmtpHandler.processCommand(LmtpHandler.java:174)
        at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCommand(TcpLmtpHandler.java:61)
        at com.zimbra.cs.tcpserver.ProtocolHandler.processConnection(ProtocolHandler.java:160)
        at com.zimbra.cs.tcpserver.ProtocolHandler.run(ProtocolHandler.java:128)
        at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:595)


** END NESTED EXCEPTION **



Last packet sent to the server was 148 ms ago.

Query being executed when exception was thrown:

com.mysql.jdbc.ServerPreparedStatement[2] - SELECT mi.id, mi.type, mi.parent_id, mi.folder_id, mi.index_id, mi.imap_id, mi.date, mi.size, mi.volume_id, mi.blob_digest, mi.unread, mi.flags, mi.tags, mi.subject, mi.name, mi.metadata, mi.mod_metadata, mi.change_date, mi.mod_content FROM mboxgroup28.mail_item AS mi, mboxgroup28.open_conversation AS oc WHERE oc.hash = 'aVcc6QgVOx9ikAYUtJaGmSjQ0,o=' AND mi.id = oc.conv_id AND oc.mailbox_id = 28 AND mi.mailbox_id = oc.mailbox_id
        at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2515)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2803)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
        at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
        at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1262)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
        at com.zimbra.cs.db.DbMailItem.getByHash(DbMailItem.java:1948)
        ... 20 more
2010-04-16 16:02:12,070 INFO  [LmtpServer-459] [] lmtp - 451 4.0.0 Temporary message delivery failure try again (DATA)
2010-04-16 16:02:12,070 INFO  [LmtpServer-459] [] ProtocolHandler - Handler exiting normally