🐛: WebUI showed the same mailbox twice. Database corrupted after deleting the "duplicate"

[kamilst96]

What happened?

Stalwart WebUI rendered both MAILBOX1 and MAILBOX2 as MAILBOX2. After deleting MAILBOX2, database corrupted, seemingly deleting MAILBOX2 metadata but MAILBOX1 actual content.

Due to the corruption, the mailbox list is not being rendered anymore. Error complains about MAILBOX1 being missing.

How can we reproduce the problem?

I can reproduce the problem by doing the following steps:

I do not believe it can be reproduced at will. It's a result of the WebUI spontaneously rendering a single mailbox twice, while one of them seemingly representing another mailbox.

• 2024: Created MAILBOX1
• Created MAILBOX2
• List displays MAILBOX2 twice
• Be unlucky deleting the MAILBOX1 displayed as MAILBOX2

I suspect that the delete operation removed MAILBOX2 metadata while removing the actual MAILBOX1, somehow.

Version

v0.13.x

What database are you using?

RocksDB

What blob storage are you using?

RocksDB

Where is your directory located?

Internal

What operating system are you using?

Linux

Relevant log output

Code of Conduct

• I agree to follow this project's Code of Conduct

[kamilst96]

Ah, one thing of note: the error was persistent between browser refreshes. So something might have happened during MAILBOX2 creation, and was only triggered during deletion. Unfortunately, I wasn't wise enough to attempt restarting the server.

[mdecimus]

Any useful information in the logs?
The webadmin won't show the same account twice, and even if it did, the server will delete just one entry.
Have you perhaps somehow created multiple accounts with the same name?

[kamilst96]

Any useful information in the logs?

Unfortunately no. I was combing through logs and there was nothing concerning the operation.

The webadmin won't show the same account twice, and even if it did, the server will delete just one entry.

Which is why it was strange. Creating MAILBOX2 resulted in two MAILBOX2 being displayed, and MAILBOX1 missing. At first I thought it's on another page or something, so I ignored it.

Interestingly, from what I noticed yesterday, MAILBOX2 still exists, along with its metadata, completely intact. I just need to search for it in account list. Only MAILBOX1 somehow bugged out in the process. As long as Accounts gets results not containing MAILBOX1, the list will render. So, the MAILBOX1 seems to be gone, but some lingering metadata is bugging out the account list.

Also, /manage/directory/accounts/MAILBOX1 results in ' not found', instead of 'MAILBOX1 not found', so there is something somewhere.

I am treating it as a one-off and rebuilding from exports, so there is no urgency to deal with it. Perhaps I really did something weird, when I was creating multiple accounts one after another.