Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: [SOLVED] zmmailboxdctl is not running

  1. #1
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default [SOLVED] zmmailboxdctl is not running

    I have had problems this morning with Zimbra not running. When I do a zmcontrol status I get that the mzzailboxdctl is not running. For a while it would come and go but now I can't get it to stay running at all. I have done a zmcontrol stop and start and have totally restarted the server twice.

    I have pasted the last little bit of the zimbra.log below.

    dj

    Code:
    ExceptionId:btpool0-6:1245678039307:a9c42326f1ba111d 
    Code:service.FAILURE 
    	at 
    com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253) 
    	at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.java:144) 
    	at com.zimbra.cs.mailbox.Mailbox.endTransaction(Mailbox.java:6740) 
    	at com.zimbra.cs.mailbox.Mailbox.getConfig(Mailbox.java:1235) 
    	at com.zimbra.cs.mailbox.Mailbox.finishInitialization(Mailbox.java:524) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:414) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.ja
    va:273) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.ja
    va:226) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccount(MailboxManager.java
    :211) 
    	at 
    com.zimbra.cs.session.SoapSession.expandLocalMountpoints(SoapSession.java:722) 
    	at 
    com.zimbra.cs.session.SoapSession.expandLocalMountpoints(SoapSession.java:736) 
    	at com.zimbra.cs.session.SoapSession.putRefresh(SoapSession.java:697) 
    	at com.zimbra.soap.SoapEngine.generateResponseHeader(SoapEngine.java:486) 
    	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:301) 
    	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:188) 
    	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:148) 
    	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(ContextHandlerColl
    ection.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:211) 
    	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:4
    42) 
    Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: 
    Communications link failure during commit(). Transaction resolution 
    unknown. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888) 
    	at com.mysql.jdbc.Connection.commit(Connection.java:2246) 
    	at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.jav
    a:248) 
    	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(
    PoolingDataSource.java:244) 
    	at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.java:142) 
    	... 40 more

  2. #2
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    I put this in the wrong section. Can someone move it to admin for me? Thanks.

    dj

  3. #3
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    Any ideas from anyone? mysql seems to be running. Which log file would have sql errors listed?

    dj

  4. #4
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    I have attached some mysql log information.

    Code:
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 67 
    select period_start from disk_aggregate where period='day' order by 
    period_start desc limit 1; 
    # Time: 090622 10:30:09 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0 
    delete from disk_status where time < '2009-05-22 00:00:00'; 
    /opt/zimbra/logger/mysql/libexec/mysqld, Version: 5.0.51a-log (Source 
    distribution). started with: 
    Tcp port: 7307  Unix socket: /opt/zimbra/logger/db/mysql.sock 
    Time                 Id Command    Argument 
    /opt/zimbra/logger/mysql/libexec/mysqld, Version: 5.0.51a-log (Source 
    distribution). started with: 
    Tcp port: 7307  Unix socket: /opt/zimbra/logger/db/mysql.sock 
    Time                 Id Command    Argument 
    # Time: 090622 10:40:02 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0 
    use zimbra_logger; 
    delete from service_status where time <= '2009-06-22 10:30:02'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 8 
    select distinct loghostname, server from service_status; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 3 
    select id from processing_history where app='mta'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 118  Rows_examined: 716 
    select distinct(postfix_qid) from raw_logs where postfix_qid is not 
    null and app like 'postfix%' and id > '14444737'; 
    # Time: 090622 10:40:03 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0 
    delete from processing_history where app='mta'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 3 
    select id from processing_history where app='clamd'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 3 
    select id from processing_history where app='amavis'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 3 
    select id from processing_history where app='sendmail'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 3 
    select id from processing_history where app='zimbramon'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0 
    delete from processing_history where app='zimbramon'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 1 
    select period_start from mta_aggregate where period='hour' order by 
    period_start desc limit 1; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 34 
    select period_start from mta_aggregate where period='day' order by 
    period_start desc limit 1; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 1 
    select period_start from amavis_aggregate where period='hour' order by 
    period_start desc limit 1; 
    # Time: 090622 10:40:05 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 3 
    select period_start from amavis_aggregate where period='day' order by 
    period_start desc limit 1; 
    # Time: 090622 10:40:06 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 1 
    select period_start from disk_aggregate where period='hour' order by 
    period_start desc limit 1; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 9057 
    select distinct(server) from disk_status where time >= '2009-06-22 
    09:00:00' and time <= '2009-06-22 10:00:00'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 2  Rows_examined: 9058 
    select distinct(device) from disk_status where server = 
    'cormail.richmond.ky.us' and time >= '2009-06-22 09:00:00' and time <= 
    '2009-06-22 10:00:00'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 9056 
    select avg(total) from disk_status where server = 
    'cormail.richmond.ky.us' and device = 
    '/dev/mapper/VolGroup00-LogVol00' and time >= '2009-06-22 09:00:00' 
    and time <= '2009-06-22 10:00:00'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 9056 
    select avg(available) from disk_status where server = 
    'cormail.richmond.ky.us' and device = 
    '/dev/mapper/VolGroup00-LogVol00' and time >= '2009-06-22 09:00:00' 
    and time <= '2009-06-22 10:00:00'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 9056 
    select avg(total) from disk_status where server = 
    'cormail.richmond.ky.us' and device = '/dev/sda1' and time >= 
    '2009-06-22 09:00:00' and time <= '2009-06-22 10:00:00'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 9056 
    select avg(available) from disk_status where server = 
    'cormail.richmond.ky.us' and device = '/dev/sda1' and time >= 
    '2009-06-22 09:00:00' and time <= '2009-06-22 10:00:00'; 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 67 
    select period_start from disk_aggregate where period='day' order by 
    period_start desc limit 1; 
    # Time: 090622 10:40:09 
    # User@Host: zimbra[zimbra] @ localhost [] 
    # Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0 
    delete from disk_status where time < '2009-05-22 00:00:00';

  5. #5
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    Now a zmcontrol status shows my stats are not running. Any help please.

    dj

  6. #6
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,480
    Rep Power
    56

    Default

    What errors do you see in the log files? You should also check the Troubleshooting tips here: Logger - Zimbra :: Wiki
    Last edited by phoenix; 06-22-2009 at 09:07 AM.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  7. #7
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    Mailbox log file errors

    Code:
    com.zimbra.common.service.ServiceException: system failure: committing 
    database transaction 
    ExceptionId:btpool0-7:1245685393338:b277446bd3db1c08 
    Code:service.FAILURE 
    	at 
    com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:253) 
    	at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.java:144) 
    	at com.zimbra.cs.mailbox.Mailbox.endTransaction(Mailbox.java:6740) 
    	at com.zimbra.cs.mailbox.Mailbox.getConfig(Mailbox.java:1235) 
    	at com.zimbra.cs.mailbox.Mailbox.finishInitialization(Mailbox.java:524) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:414) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.ja
    va:273) 
    	at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.ja
    va:226) 
    	at 
    com.zimbra.soap.DocumentHandler.getRequestedMailbox(DocumentHandler.java:158) 
    	at com.zimbra.soap.SoapEngine.generateResponseHeader(SoapEngine.java:502) 
    	at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:301) 
    	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:188) 
    	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:148) 
    	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(ContextHandlerColl
    ection.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:211) 
    	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:4
    42) 
    Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: 
    Communications link failure during commit(). Transaction resolution 
    unknown. 
    	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888) 
    	at com.mysql.jdbc.Connection.commit(Connection.java:2246) 
    	at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.jav
    a:248) 
    	at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(
    PoolingDataSource.java:244) 
    	at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.java:142) 
    	... 37 more
    dj

  8. #8
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,480
    Rep Power
    56

    Default

    Follow the instructions in this thread: [SOLVED] URGENT!! zmmailboxdctl is not running
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  9. #9
    dljordaneku is offline Elite Member
    Join Date
    Sep 2007
    Location
    Richmond, Ky
    Posts
    281
    Rep Power
    7

    Default

    The first part of the manual sql recovery? When I ran the zmprov gaa | xargs -i zmprov getMailboxInfo {} I started getting mailbox ids with quotas but after a while I got

    zclient.IO_ERROR (invoke Connection refused, server: localhost) (cause: java.net.ConnectException Connection refused)


    dj

  10. #10
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,480
    Rep Power
    56

    Default

    If you follow the thread you'll get to a post that says to run the following: Mysql Crash Recovery - Zimbra :: Wiki - make sure you have a backup before performing any of those operations. Just for emphasis. Take a backup before attempting any recovery.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Outlook no longer updating
    By jeremy.pratt in forum Zimbra Connector for BlackBerry
    Replies: 10
    Last Post: 05-30-2008, 03:22 PM
  2. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  3. Can't seem to get global in BES
    By sdemeyer in forum Zimbra Connector for BlackBerry
    Replies: 12
    Last Post: 03-19-2008, 08:22 AM
  4. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  5. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •