Export Failed - Need Help

[ObiWan]

Hey guys,
Need your help solving this problem:


26-Oct-2011 16:06 - Error: ZxMig Notification, Export failed.

This is an automated notification from ZxBackup about Export.

Operation Export failed.

Operation Id: *********
Operation Host: *********

- exception -
Unknown Exception
at com.zextras.backup.ZEExportOperation.doOperation(Z EExportOperation.java:318)
at com.zextras.op.ZEOperation.exec(ZEOperation.java:5 84)
at com.zextras.backup.ZEBackupThread.execOperation(ZE BackupThread.java:194)
at com.zextras.backup.ZEBackupThread.run(ZEBackupThre ad.java:104)
Caused by: com.zimbra.common.service.ServiceException: system failure: getting next mailbox id, mailboxId=-1
ExceptionId:ZxBackup Thread:1319637968695:1be7cf22e6c9d006
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248)
at com.zimbra.cs.db.DbMailbox.getNextMailboxId(DbMail box.java:172)
at com.zimbra.cs.db.DbMailbox.createMailbox(DbMailbox .java:187)
at com.zimbra.cs.mailbox.MailboxManager.createMailbox Internal(MailboxManager.java:812)
at com.zimbra.cs.mailbox.MailboxManager.createMailbox (MailboxManager.java:786)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccountId(MailboxManager.java:359)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccount(MailboxManager.java:282)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByA ccount(MailboxManager.java:259)
at com.zextras.backup.ZEScanOperation.doAccountScan(Z EScanOperation.java:119)
at com.zextras.backup.ZEScanOperation.doDomainScan(ZE ScanOperation.java:52)
at com.zextras.backup.ZEExportOperation.doOperation(Z EExportOperation.java:312)
... 3 more
Caused by: java.sql.SQLException: Got error -1 from storage engine

Query being executed when exception was thrown:
UPDATE current_volumes SET next_mailbox_id = next_mailbox_id + 1


at com.mysql.jdbc.SQLError.createSQLException(SQLErro r.java:1075)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3566)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:3498)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:19 59)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2113)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2568)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2113)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2409)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2327)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2312)
at com.zimbra.cs.db.DebugPreparedStatement.executeUpd ate(DebugPreparedStatement.java:169)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at com.zimbra.cs.db.DbMailbox.getNextMailboxId(DbMail box.java:157)
... 12 more



Server version 7.1.2 OSE
Migration tool version 1.0.1

Thanks

[Cine]

Hello ObiWan, and welcome to the Forums!

Looks like MySQL has some problem accessing an account..

My suggestion is to set the LogLevel and Notification Level to "Debug" (in the ZxMig pane of the Admin Interface) and retry.
If the problem persists you'll find a "last account" line in the notification. Try to access that account and to reindex it.


Have a nice day,
Cine

[Jay]

Hi,
I've investigated this issue and it may be caused either by a MySQL table corruption or by a low ram issue.
If i were you i would watch out for database corruption first, using `zmdbintegrityreport` (Issues with database integrity check - Zimbra :: Wiki) command then i would upgrade your database engine if you upgraded from a zimbra 6x (more info on zimbra release notes).

Have a nice day,
Jay