No such account errors in mailbox.log file

[jsabater]

Hello everyone!

I am having the following problems on my private server with Open Source Edition 5.0.6:

2008-06-23 15:23:19,897 WARN  [btpool0-0] [] SoapEngine - unable to construct SOAP context
com.zimbra.cs.account.AccountServiceException: no such account: joan@zimbra.linuxsilo.net
ExceptionId:btpool0-0:1214234599897:fc7857048352f12d
Code:account.NO_SUCH_ACCOUNT
        at com.zimbra.cs.account.AccountServiceException.NO_SUCH_ACCOUNT(AccountServiceException.java:165)
        at com.zimbra.soap.ZimbraSoapContext.<init>(ZimbraSoapContext.java:213)
        at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:189)
        at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:159)
        at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:266)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:189)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
        at org.mortbay.servlet.UserAgentFilter.doFilter(UserAgentFilter.java:81)
        at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter.java:132)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)
        at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:716)
        at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:406)
        at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211)
        at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
        at org.mortbay.jetty.handler.rewrite.RewriteHandler.handle(RewriteHandler.java:350)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139)
        at org.mortbay.jetty.Server.handle(Server.java:313)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:844)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:644)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:205)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381)
        at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)
        at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)

That account was deleted by me yesterday, but it seems that it was corrupted or something. This message appears lots of times in the mailbox.log log. I have tried reinstalling to see if the installer, when verifying the database integrity, could fix that, but no luck.

Any hints?

[jsabater]

Checked the MySQL tables and could not find any traces of the deleted accounts, therefore I guess those traces must be somewhere else:

mysql> select * from deleted_account;
+--------------------------------+--------------------------------------+------------+------------+
| email                          | account_id                           | mailbox_id | deleted_at |
+--------------------------------+--------------------------------------+------------+------------+
| joan@zimbra.linuxsilo.net      | 3b329ea8-9014-42c6-b50d-b16382c886ee |          8 | 1214201354 | 
| rverdu@linuxsilo.net           | baa567e3-d1f5-45e6-9ef9-72194406a3c5 |          9 | 1213948309 | 
| sebastian@zimbra.linuxsilo.net | a9352e55-02e0-470d-8a39-43ea11e7f729 |          3 | 1214201247 | 
+--------------------------------+--------------------------------------+------------+------------+
3 rows in set (0.00 sec)

[jsabater]

It looks like the trace is not in LDAP either:

$ zmprov -l
prov> deleteAccount joan@zimbra.linuxsilo.net  
ERROR: account.NO_SUCH_ACCOUNT (no such account: joan@zimbra.linuxsilo.net)
prov> deleteAccount sebastia@zimbra.linuxsilo.net
ERROR: account.NO_SUCH_ACCOUNT (no such account: sebastia@zimbra.linuxsilo.net)
prov> deleteAccount raul@zimbra.linuxsilo.net
ERROR: account.NO_SUCH_ACCOUNT (no such account: raul@zimbra.linuxsilo.net)

[jsabater]

So it seemed to be related to zmlogger. I did this to sort it out:

sudo su - zimbra
zmcontrol stop (and checked no processes were left)
mv /opt/zimbra/logger/db /opt/zimbra/logger/db.bak
zmcontrol start
/opt/zimbra/libexec/zmloggerinit
/opt/zimbra/libexec/zmgengraphs

I lost information but at least got it working again. No more
NO_SUCH_ACCOUNT errors. Let's see how it evolves, as I am worried that it has to do with mailboxdctl as well.