[SOLVED] URGENT!! zmmailboxdctl is not running

[arto]

Hi.

This morning i restart zimbra server and then i have stoped the service zmmailboxdctl. I can't start this service.

My mailbox.log:

2009-02-11 13:02:23,621 INFO [PostStartupCrashRecovery] [] cache - initializing folder and tag caches for mailbox 41
2009-02-11 13:02:24,234 FATAL [PostStartupCrashRecovery] [] system - Unable to commit database transaction. Forcing server to abort.
com.zimbra.common.service.ServiceException: system failure: committing database transaction
ExceptionId:PostStartupCrashRecovery:1234353744233 :18bdfe7e9da3b1f5
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:253)
at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.j ava:146)
at com.zimbra.cs.mailbox.Mailbox.endTransaction(Mailb ox.java:6885)
at com.zimbra.cs.mailbox.Mailbox.getConfig(Mailbox.ja va:1256)
at com.zimbra.cs.mailbox.Mailbox.finishInitialization (Mailbox.java:530)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByI d(MailboxManager.java:430)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByI d(MailboxManager.java:328)
at com.zimbra.cs.redolog.op.IndexItem.redo(IndexItem. java:93)
at com.zimbra.cs.redolog.RedoLogManager$PostStartupCr ashRecoveryThread.run(RedoLogManager.java:306)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnect ionException: Communications link failure during commit(). Transaction resolution unknown.
at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:888)
at com.mysql.jdbc.Connection.commit(Connection.java:2 246)
at org.apache.commons.dbcp.DelegatingConnection.commi t(DelegatingConnection.java:248)
at org.apache.commons.dbcp.PoolingDataSource$PoolGuar dConnectionWrapper.commit(PoolingDataSource.java:2 44)
at com.zimbra.cs.db.DbPool$Connection.commit(DbPool.j ava:144)
... 7 more


I need help. I don't know what can i do.

Thanks and sorry with my english. I'm spanish administrator.

[uxbod]

Welcome to the forums

Please post the output from

su - zimbra
zmcontrol -v

[arto]

Release 5.0.10_GA_2638.UBUNTU8 UBUNTU8 FOSS edition

[uxbod]

Okay, it sounds like one of your mailboxes is corrupt. So to find the one that is affected you can run

su - zimbra
zmprov gaa | xargs -i zmprov getMailboxInfo {}

Once you have found the account using that mailbox, disable IMAP to that account and restart the mailbox service using

zmmailboxdctl restart

When that is running again try to re-index the account using

zmprov rim {user@domain} start

when that has finished re-enable IMAP access and see if that has cured the problem.

[arto]

Thanks a lot.

I have this message with zmprov:

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

[uxbod]

zmmailboxdctl restart

to get it started first.

[arto]

I can't start zmmailboxdctl.

I do restart and next zmprov. Continue the same message

ERROR: zclient.IO_ERROR (invoke Connection reset, server: localhost) (cause: java.net.SocketException Connection reset)


In /var/log/zimbra.log i have this:

Feb 11 14:06:28 correu zmmailboxdmgr[5679]: stale pid 5212 found in /opt/zimbra/log/zmmailboxd_manager.pid: No such process
Feb 11 14:06:28 correu zmmailboxdmgr[5679]: assuming no other instance is running
Feb 11 14:06:28 correu zmmailboxdmgr[5679]: file /opt/zimbra/log/zmmailboxd.pid does not exist
Feb 11 14:06:28 correu zmmailboxdmgr[5679]: assuming no other instance is running
Feb 11 14:06:28 correu zmmailboxdmgr[5679]: no manager process is running

[uxbod]

Any new messages in /opt/zimbra/log/mailboxd.log ?

[arto]

No. Is the same.

I know the mailbox user corrupt. Yesterday one user can't open his mailbox. When this morning i restart service the zmmailboxdctl fails.

Only have his name. I can't find his mailbox for delete it.

More help?

[uxbod]

Looks like you are going to have to go through Mysql Crash Recovery - Zimbra :: Wiki. Please ensure you have a recent backup before performing this operation.