An issue that happened to me running ArGoSoft Mail Server .NET Edition on Win 2000 Server SP4 about a week ago:

Mid February I still ran Mail Server .NET v1.0.4.1. To fight spam I turned on greylisting. I used the standard setup - it worked fine!

A few weeks later the server tried to reboot - and could not restart the mail server. I found out that there were more then 400.000 records in the greylisting database and the mail server hangs at the step "remove expired records from greylisting database" when starting.

I upgraded to v1.0.4.4 to get the "Database Command box" feature of the Mail Server Controller and to delete the records manually. Issuing an SQL DELETE * FROM  MailServerData.dbo.Greylisting ran into a timeout, if I remember it right.

Only method to restart the mail server again was to use MS SQL Server Management Studio Express to delete the superfluous records. I also upgraded to 1.0.4.5 at the same time (because of the SMTP delivery issue) - mail server started again without problems, I only lost the validated records of the greylisting database.

Did anyone experience something similar?

Did I miss to set up a mainenance process somewhere? (I remember there was something in ArGoSoft Mail Server, but I did not find something similar in Mail Server .NET Edition)

thanks for any clues,

         fra

I am deleting outdated graylisting database records at server startup, but, if there are too many records there, it may timeout...  I will consider increasing timeout...

You could try executing

TRUNCATE  TABLE Graylisting

from the Maintenance box, it would be faster, but it would delete all records, not only expired ones.

Archie

hi archie,

thanks for this hint!

And: increasing the timeout will not solve the problem... If the mail server is luckily up and running, the maintenance SQL will never be performed.

    fra