I have 4 dbs running Java Agents every 10 minutes to monitor incoming emails and send them to MQ. They retrieve emails from the Inbox folder and place them into a temporary folder (so they are never processed twice). These folders are created with a string followed by timestamp. I know that there are lots of things involved, but would you believe that these creation of folders could cause a database to get corrupt? Have you ever seen this before?
Any ideas are appreciated.
Tx.
Subject: Can temporary Folders cause Database Corruption?
The corruption is linked to temporary documents created in the background and deleted. The databases have Soft Deletion enabled and these databases were getting corrupt when Compact -B ran on the weekend.
I now need to see if there is any trick with the creation of documents in the background or if it is a problem with Lotus Notes Server Java 6.5.5 (no fix packs deployed).
Please, let me know if you have any other idea.
Thanks.
Subject: Can temporary Folders cause Database Corruption?
Romario,
Why are you using temporary folders at all? Agent execution in a database is serialized, meaning that there should never be two instances active at the same time.
Simply processing the documents, stamping them and removing them from the Inbox folder should work just as well.
cheers,
Bram