As you noted, MDAC on our server has been downgraded as well. The culprit... None other than Crystal Reports. However, instead of reinstalling version 2.7 of MDAC (which now has 3 versions, 2.7, 2.7 refresh, and 2.7 SP1) I am going to attempt to install and run MDAC 2.8. Is there any known issues with 2.8 that I should be aware of?

UPDATE:

We installed MDAC 2.8 and are not having any problems, the Memory leak has also gone away. For those wondering MDAC 2.8 can be found at the link below:

http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=6C050FE3-C795-4B7D-B037-185D0506396C

Thanks,

Sean

Sean,

Can you please ensure you are actually running MDAC 2.7, and it has not been corrupted? We (actually SpamFilter users) have found using the MDAC Component Checker that their install of MDAC had been down-revved by other applications. Reinstalling MDAC 2.7 fixed all leak issues.

Roberto F.
LogSat Software

Hi all,

It has been about 24 and after switching to the 2.5 driver the memory usage has remained at 9megs with the list hidden and no load.

Will upgrade to the latest version and see what happens.

It leaked in standalone mode as well. I will install it on my backup server and give it a try right now and see how it does in a few hours.

Kevin

Kevin,

Now that you and George have found this to happen on NT4, we were finally able to reproduce the leak on an NT4 server with SpamFilter running as a service. What is odd is that the leak only happened once, we were not able to reproduce it again... Working with the debug data we collected, we may have found a possible problem. Non matter what we did, after the code change the leak was unreproduceable.

We've just uploaded beta build .196 in the registered user are. If you can give it a try, please let us know if a miracle happened and the leak is gone.

If not, can you please try running SpamFilter in standalone mode rather than as a service, and let us know if that leaks as well?

If so, can you please run SpamFilter from the command line with the follwoing switch:

SpamFilter -d

and let it run until you see 50-100MB leaking. When you close SpamFilter, the -d switch  will show a debug window to come up. Please email us the contents.

If the leak only occurs in the service, please add the -d switch in the registry at:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SpamFilter,

edit the ImagePath value and add the -d option at the end of the existing value, ex:

C:\\SpamFilter\\SpamFilterSvc.exe /startedbyscm:F9D641D8-40E26D57-SpamFilter -d

Roberto F.
LogSat Software

All,

I have 2 test beds set up and never having really used MySql before, this was a task. I have a autoresopnder endless loop set up and hit both servers with 200 messages / min

Both servers: SpamFilter build 195

Both Servers: ODBC Driver 3.5

After 2 hours

On the NT4 (SP6a) box, the server crashed and burnned in very short order.  I have so many errors comming from God knows where that I went into sensory overload trying to look at them

On the Win2K box ... well, it is still running and I have about 40meg being used by SpamFilter.

On the NT box, I changed my UDL to point to my Microsoft (how I hate that word) MS-SQL 2000 SP3(+) and it is running as I write this and looks like it will be fine.

So ... what the heck?  I just do not have enough experience with MySQL to go much further.  I have, in fact, sent all my test information over to Roberto and I believe he is setting a test up on and NT box but I do not want to speak for him.

Regards,

Dan S.