I recently had an issue where the mail boxes on one of my Domino servers were not compacting at all during their normal window.
My logs showed
09/03/2009 04:00:01 AM Router: Beginning mailbox file compaction of mail1.box
09/03/2009 04:00:01 AM Switching to copy-style compaction for E:\Lotus\Domino\Data\mail1.box due to unique fields names table size
09/03/2009 04:00:02 AM Router: Shutdown is in progress
09/03/2009 04:01:49 AM Router: Unable to compact mailbox file mail1.box: Database is currently in use by you or another user
09/03/2009 04:01:49 AM Router: Completed mailbox file compaction of mail1.box
09/03/2009 04:01:49 AM Router: Beginning mailbox file compaction of mail2.box
09/03/2009 04:02:02 AM Router: Completed mailbox file compaction of mail2.box
09/03/2009 04:02:02 AM Router: Beginning mailbox file compaction of mail3.box
09/03/2009 04:02:02 AM Switching to copy-style compaction for E:\Lotus\Domino\Data\mail3.box due to unique fields names table size
09/03/2009 04:03:49 AM Router: Unable to compact mailbox file mail3.box: Database is currently in use by you or another user
09/03/2009 04:03:49 AM Router: Completed mailbox file compaction of mail3.box
09/03/2009 04:03:50 AM Router operation resumed.
Since I haven’t had the need to monitor for failure of mailbox compaction, I was not aware of this issue until I received complaints of Non Delivery Errors. Specifically “554 Error writing message to safe storage; message could not be stored to disk“.
I was unable to find anything useful either from Lotus’ technotes online, their forums or using Google in general so I thought I’d post something to help out others who travel this path.
I contacted Lotus and opened a PMR but they were clueless as well. I really wanted to know what the “unique fields names table size” error was all about but they really didn’t know and tossed me a technote pertaining to “Database has too many unique field names” which really didn’t apply. They also focused on database corruption caused by anti-virus programs. I figure that, if this was the issue, this should have come up in the past 5 years on some of the 30+ other servers I’m working with so I was pretty sure this was also not a cause.
Long and short, I still don’t have an effective means to generically monitor for mail box compact failure. I *could* set up a monitor for the “unique fields names table size” string but it seems that seems like overkill.
To resolve the issue is simple enough:
- shut down the server,
- rename all the mail boxes,
- restart the server (allowing new mail boxes to be created),
- copy over any not-dead messages to one of the newly created mail boxes and
- delete the old mail boxes
A side-effect of the above is that my name becomes the “from” address for all the copied messages. Anybody have a simple solution for that? I haven’t actually researched it yet since it comes up so infrequently but it would be handy to know.