Errors in mailbox.log while running HSM

---

Problem:

Errors in "mailbox.log" while running HSM

2016-12-20 07:43:19,249 WARN  [BlobMover] [mid=40;] hsm - Unable to look up account 7c1a9843-dbaf-496d-bc3a-bd9ddb2344f6.
2016-12-20 07:43:19,250 INFO  [BlobMover] [mid=40;] hsm - Skipping mailbox 40 because it has been moved to another server.
2016-12-20 07:43:20,245 WARN  [BlobMover] [mid=1;] hsm - Unable to look up account e3cce2b2-7a41-4b6d-afde-bad6e6173518.
2016-12-20 07:43:20,245 INFO  [BlobMover] [mid=1;] hsm - Skipping mailbox 1 because it has been moved to another server.

Also it throws error "No Such Account" while trying to purge and trying to get the account information.

zmprov -l ga user1@domain.com.com
ERROR: account.NO_SUCH_ACCOUNT (no such account: user1@domain.com.com)

zmprov -l ga user2@domain.com.com
ERROR: account.NO_SUCH_ACCOUNT (no such account: user2@domain.com.com)

zmpurgeoldmbox -a user1@domain.com.com -s `zmhostname`
Error occurred: system failure: Account user1@domain.com.com not found

zmpurgeoldmbox -a user2@domain.com.com -s `zmhostname`
Error occurred: system failure: Account user2@domain.com.com not found

Solution:

The cause of this error is the mailbox which has zimbraID "7c1a9843-dbaf-496d-bc3a-bd9ddb2344f6" and "e3cce2b2-7a41-4b6d-afde-bad6e6173518" moved to another mailbox host, but not purged.

1). Find out the email address which is mapped with zimbraId's.

mysql -e 'select * from zimbra.mailbox where account_id="7c1a9843-dbaf-496d-bc3a-bd9ddb2344f6"'
mysql -e 'select * from zimbra.mailbox where account_id="e3cce2b2-7a41-4b6d-afde-bad6e6173518"'

2). Create same user with existing zimbra id.

zmprov ca user1@domain.com.com test123 zimbraId "7c1a9843-dbaf-496d-bc3a-bd9ddb2344f6"
zmprov ca user2@domain.com.com test123 zimbraId "e3cce2b2-7a41-4b6d-afde-bad6e6173518"

3). Delete the user because it doesn't exist.

zmprov da user1@domain.com.com
zmprov da user2@domain.com.com

Submitted by: Navdeep Mathur