Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Administrators
Reload this Page [SOLVED] zmmailboxdctl is not running

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
Page 1 of 2 1 2
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-22-2009, 08:06 AM
Elite Member
  
Posts: 279
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
Reply With Quote
  #2 (permalink)  
Old 06-22-2009, 08:10 AM
Elite Member
  
Posts: 279
Default
I put this in the wrong section. Can someone move it to admin for me? Thanks.

dj
Reply With Quote
  #3 (permalink)  
Old 06-22-2009, 09:06 AM
Elite Member
  
Posts: 279
Default
Any ideas from anyone? mysql seems to be running. Which log file would have sql errors listed?

dj
Reply With Quote
  #4 (permalink)  
Old 06-22-2009, 09:19 AM
Elite Member
  
Posts: 279
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';
Reply With Quote
  #5 (permalink)  
Old 06-22-2009, 09:39 AM
Elite Member
  
Posts: 279
Default
Now a zmcontrol status shows my stats are not running. Any help please.

dj
Reply With Quote
  #6 (permalink)  
Old 06-22-2009, 09:55 AM
Zimbra Consultant & Moderator
  
Posts: 19,653
Default
What errors do you see in the log files? You should also check the Troubleshooting tips here: Logger - Zimbra :: Wiki
__________________
Regards


Bill
Last edited by phoenix; 06-22-2009 at 10:07 AM..
Reply With Quote
  #7 (permalink)  
Old 06-22-2009, 10:05 AM
Elite Member
  
Posts: 279
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
Reply With Quote
  #8 (permalink)  
Old 06-22-2009, 10:12 AM
Zimbra Consultant & Moderator
  
Posts: 19,653
Default
Follow the instructions in this thread: [SOLVED] URGENT!! zmmailboxdctl is not running
__________________
Regards


Bill
Reply With Quote
  #9 (permalink)  
Old 06-22-2009, 10:20 AM
Elite Member
  
Posts: 279
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
Reply With Quote
  #10 (permalink)  
Old 06-22-2009, 10:34 AM
Zimbra Consultant & Moderator
  
Posts: 19,653
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
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Today's Posts or Week's Posts | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode


Similar Threads

Product Information

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com


Home - Blog - Contact Us - Archive - Top


 

SEO by vBSEO ©2011, Crawlability, Inc.