How to delete index directories of specified users

[mikiso]

Hi,

Our customer reported that they couldn't delete index directories
when executing zmmailboxmove --purgeOld.
Messages and accounts were deleted, but only the index directories
weren't deleted and it turns out to be a bug:50308.

Our customer wants to delete the directories for a workaround
because they run short of disk space for the server.

Do anyone have a tool for deleting index directory for specified users or
any workaround?
I assume we can detect the location in the index directory by mailbox_id
of the moved store server.

I tested deleting all messages from store and then run "zmprov rim", but
1KB of index data still remains..


---
Our environment:
ZCS5.0.16 NE multi-server RHEL5

[y@w]

You probably need to know what mailbox id and mailbox group and then can just do this: King0770-Notes - Zimbra :: Wiki

[mikiso]

Thanks y@w,

I think I can delete the indice if the volume ids, mailbox id and mailbox group won't get changed after executing zmmailboxmove.

[y@w]

Yeah, accidentally deleting indexes for a few of the wrong accounts isn't a big deal since they can be regenerated anyway.

Another thing that you may want to look at if you're really desperate for disk space is optimizing the mail_items tables in the database. Since Zimbra uses innodb, when the users' mail gets deleted off the server, the space isn't regained from the MySQL tables. Running an optimize table on while give you that disk space back. Just make sure you do that at night when there aren't many users on as it locks the tables.

[mikiso]

I see.
I didn't notice that optimizing the tables helps reducing the space, however our production server accomodates over 100,000 users and we know it's not good for large site.

In addition, unfortunately, zimbra support replied us that mailbox_id will be changed after executing zmmailboxmove.I think volume_id will be changed as well.

So, if we want to delete those indice, we may need "index consistency check" tool as blob consistency check tool for messages in the store.