[ZCS 8.8.10] Unable to purge mailbox no such account

[wodel]

Hi,

After deleting an account from the webui, I started getting this error message

Code: Select all

2018-10-30 10:34:04,035 WARN  [MailboxPurge] [mid=6;] mailbox - no account found in directory for mailbox 6 (was expecting 1e334b89-8a52-433b-9653-04bb12b93b91)
2018-10-30 10:34:04,035 WARN  [MailboxPurge] [mid=6;] mailbox - no account found in directory for mailbox 6 (was expecting 1e334b89-8a52-433b-9653-04bb12b93b91)
2018-10-30 10:34:04,035 WARN  [MailboxPurge] [mid=6;] purge - Unable to purge mailbox 6
com.zimbra.cs.account.AccountServiceException: no such account: 1e334b89-8a52-433b-9653-04bb12b93b91
ExceptionId:MailboxPurge:1540892044035:269ba7f01cf392a0
Code:account.NO_SUCH_ACCOUNT
        at com.zimbra.cs.account.AccountServiceException.NO_SUCH_ACCOUNT(AccountServiceException.java:214)
        at com.zimbra.cs.mailbox.Mailbox.getAccount(Mailbox.java:972)
        at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:463)
        at com.zimbra.cs.mailbox.MailboxManager.getMailboxById(MailboxManager.java:390)

Searching the web I didn't find an answer on how to correct this error, I tried this
https://www.zimbrafr.org/forum/topic/73 ... h-account/

But it didn't work, I got

Code: Select all

MariaDB [zimbra]> DELETE FROM mailbox WHERE account_id='1e334b89-8a52-433b-9653-04bb12b93b91';
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`mboxgroup6`.`mail_item`, CONSTRAINT `fk_mail_item_mailbox_id` FOREIGN KEY (`mailbox_id`) REFERENCES `zimbra`.`mailbox` (`id`))

is there a way to correct this error?

PS : this is a multi-node installation, and this error happened in my first store.

Regards.

[DualBoot]

Hello,

i ran into that problem and I use that trick :

Code: Select all

zmprov ca account_to_delete@mydomain.tld zimbraId 'the zimbra account id which is in error in the log'

Then delete the account

Code: Select all

zmprov da account_to_delete@mydomain.tld

Regards,

[wodel]

Hi and thanks

I did this using this article : https://wiki.zimbra.com/wiki/Errors_in_ ... unning_HSM

Code: Select all

mysql -e 'select * from zimbra.mailbox where account_id="7c1a9843-dbaf-496d-bc3a-bd9ddb2344f6"'

then I used your suggestion

Code: Select all

zmprov ca user1@domain.com.com test123 zimbraId "7c1a9843-dbaf-496d-bc3a-bd9ddb2344f6"
zmprov da user1@domain.com.com

PS : If in multi server installation, you have to create the account in the same store where the orphaned id was created in the first place.

Thanks again

Regards.

[DualBoot]

you mean you did it with my trick ?

[wodel]

Hi,

Yes I did it with your trick, but I had to create the account on the original store, since I have a multi-node installation.

The first time when I created the account, it was created on the wrong store, so the delete didn't correct the problem, so I redid the creation on the correct store and voilà.
the orphaned id was deleted with the account.

Regards.

[DualBoot]

Yes it is a prequirement.