[ZCS 8.8.10] Unable to purge mailbox no such account

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
wodel
Posts: 33
Joined: Sat Sep 13, 2014 12:24 am

[ZCS 8.8.10] Unable to purge mailbox no such account

Postby wodel » Tue Oct 30, 2018 9:58 am

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.


User avatar
DualBoot
Elite member
Elite member
Posts: 1057
Joined: Mon Apr 18, 2016 8:18 pm
Location: Earth
ZCS/ZD Version: ZCS FLOSS - 8.7.11 Mutli servers

Re: [ZCS 8.8.10] Unable to purge mailbox no such account

Postby DualBoot » Tue Oct 30, 2018 10:57 am

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
Posts: 33
Joined: Sat Sep 13, 2014 12:24 am

Re: [ZCS 8.8.10] Unable to purge mailbox no such account

Postby wodel » Tue Oct 30, 2018 11:14 am

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.
User avatar
DualBoot
Elite member
Elite member
Posts: 1057
Joined: Mon Apr 18, 2016 8:18 pm
Location: Earth
ZCS/ZD Version: ZCS FLOSS - 8.7.11 Mutli servers

Re: [ZCS 8.8.10] Unable to purge mailbox no such account

Postby DualBoot » Tue Oct 30, 2018 12:58 pm

you mean you did it with my trick ?
wodel
Posts: 33
Joined: Sat Sep 13, 2014 12:24 am

Re: [ZCS 8.8.10] Unable to purge mailbox no such account

Postby wodel » Tue Oct 30, 2018 2:19 pm

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.
User avatar
DualBoot
Elite member
Elite member
Posts: 1057
Joined: Mon Apr 18, 2016 8:18 pm
Location: Earth
ZCS/ZD Version: ZCS FLOSS - 8.7.11 Mutli servers

Re: [ZCS 8.8.10] Unable to purge mailbox no such account

Postby DualBoot » Tue Oct 30, 2018 2:52 pm

Yes it is a prequirement.

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 28 guests