Recovery Account without backup

[isacap18]

Hello,
I have an issue with only one email account, this account is causing that all the server goes down when the user search email or when we have tried to use zimbra desktop or any mail client in order to download the emails, until when we have tried to configure the email in a BlackBerry.
I tried to download the emails using Import/Export option but when I tried to import to new account it didn't work just upload a few emails.
I tried to restored in a new account using backup but it didn't work too, because the backups display an error.

So how can i fix this account? Or any idea to how recover the account?

The error that the backup sent is this:

account@server.com system failure: getting map of message id to blob digest
com.zimbra.common.service.ServiceException: system failure: getting map of message id to blob digest
ExceptionId:FullBackupThread:1319094331751:61eeed7 a98dde78e
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE (ServiceException.java:248)
at com.zimbra.cs.db.DbBackup.getBlobDigestMap(DbBacku p.java:220)
at com.zimbra.cs.backup.BackupAccountSession$BlobDige sts.preload(BackupAccountSession.java:504)
at com.zimbra.cs.backup.BackupAccountSession.loadBlob DigestMap(BackupAccountSession.java:467)
at com.zimbra.cs.backup.FileBackupTarget$BackupAcctSe ssion.storeBlobsBeforeMaintenanceMode(FileBackupTa rget.java:1411)
at com.zimbra.cs.backup.BackupAccountSession.startFul lBackup(BackupAccountSession.java:130)
at com.zimbra.cs.backup.BackupSet.startFullBackup(Bac kupSet.java:389)
at com.zimbra.cs.backup.FileBackupTarget$FileBackupSe t.startFullBackup(FileBackupTarget.java:967)
at com.zimbra.cs.backup.BackupManager.doBackupFull(Ba ckupManager.java:817)
at com.zimbra.cs.backup.BackupManager$FullBackupThrea d.run(BackupManager.java:223)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnect ionException: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException
MESSAGE: Can not read response from server. Expected to read 43 bytes, read 23 bytes before connection was unexpectedly lost.

STACKTRACE:

java.io.EOFException: Can not read response from server. Expected to read 43 bytes, read 23 bytes before connection was unexpectedly lost.
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1997 )
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2464)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2916)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:885)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1360)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.ja va:2369)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:4 51)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate (MysqlIO.java:2076)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java :1451)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1787)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1467)
at com.zimbra.cs.db.DebugPreparedStatement.executeQue ry(DebugPreparedStatement.java:160)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:93 )
at com.zimbra.cs.db.DbBackup.getBlobDigestMap(DbBacku p.java:207)
at com.zimbra.cs.backup.BackupAccountSession$BlobDige sts.preload(BackupAccountSession.java:504)
at com.zimbra.cs.backup.BackupAccountSession.loadBlob DigestMap(BackupAccountSession.java:467)
at com.zimbra.cs.backup.FileBackupTarget$BackupAcctSe ssion.storeBlobsBeforeMaintenanceMode(FileBackupTa rget.java:1411)
at com.zimbra.cs.backup.BackupAccountSession.startFul lBackup(BackupAccountSession.java:130)
at com.zimbra.cs.backup.BackupSet.startFullBackup(Bac kupSet.java:389)
at com.zimbra.cs.backup.FileBackupTarget$FileBackupSe t.startFullBackup(FileBackupTarget.java:967)
at com.zimbra.cs.backup.BackupManager.doBackupFull(Ba ckupManager.java:817)
at com.zimbra.cs.backup.BackupManager$FullBackupThrea d.run(BackupManager.java:223)


** END NESTED EXCEPTION **



Last packet sent to the server was 15199 ms ago.

Query being executed when exception was thrown:

SELECT id, mod_content, blob_digest FROM mboxgroup49.mail_item WHERE mailbox_id = 149
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO. java:2622)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2916)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:885)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1360)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.ja va:2369)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:4 51)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate (MysqlIO.java:2076)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java :1451)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :1787)
at com.mysql.jdbc.Connection.execSQL(Connection.java: 3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(Prep aredStatement.java:1467)
at com.zimbra.cs.db.DebugPreparedStatement.executeQue ry(DebugPreparedStatement.java:160)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:93 )
at com.zimbra.cs.db.DbBackup.getBlobDigestMap(DbBacku p.java:207)
... 8 more

[gvillari]

Hi,

Are the services all running?

zmcontrol status

Regards

[isacap18]

Yes,
All the service are running. Zimbra is working normal, the backups run normal too but only with this email account display the error. I tried restored other account from the backups and I could without problem, the issue is only with this account

[gvillari]

Have you try reindexing the account?

[isacap18]

Not yet, because, I don't sure how much it will take and I don't sure if this will down all the server too and as I know I can't stop the reindex process until it finish, right?

[gvillari]

Yes, this is the message to warning about this operation:

Re-Indexing a user's mailbox can take a long time and CANNOT be undone.
If re-indexing is not allowed to finish, then the index will be incomplete and searches may not return all results.

Regards

[isacap18]

Is possible copy all mailbox to a new account and try reindex this new account? Or what do you recommend me?

[gvillari]

Originally Posted by isacap18

Is possible copy all mailbox to a new account and try reindex this new account? Or what do you recommend me?

You can create a new account, copy all items from the older to the newer account. Then, after that you make sure that the new account has no problems (make a backup and try a restore), you can delete the older and rename the newer with the old name.

Tell me if this resolve the issue.

Regards

[isacap18]

How Can I do that? Is there a command to do this? or which steps can I follow to do it as the best way?

[gvillari]

Originally Posted by isacap18

How Can I do that? Is there a command to do this? or which steps can I follow to do it as the best way?

Do you mean how can I transfer all items across mailboxes?
To do that you can use the imapsync tools:

Guide to imapsync - Zimbra :: Wiki

Regards