No response to this? I'm at my wit's end, my customers are screaming that they can't send email.
At 04:01 PM 1/13/2012, Scott MacLean wrote: >I had this problem last July, where some messages sent to my >EmailSpam address are killing off ASSP worker threads. It seems to be >a combination of the contents of the email, and the contents of the whitelist. > >Last July when this was happening, after working on this for a while, >you had me set EmailErrorsModifyWhite to disabled, and the problem >went away. However, I really need the ham/spam reports to add/remove >items to/from the whitelist. I ended up switching my whitelistdb from >SQL to a file. This didn't work, so I truncated the whitelistdb table >and started fresh. This solved the problem, and people were able to >add/remove addresses from the whitelist once again. > >I really don't want to have to truncate my whitelist table again, it >really annoys my users. However, they are complaining greatly of the >timeouts and problems connecting to SMTP. The problem is that they >will send an email to my EmailSpam address, and the thread processing >the message just dies: > >Jan-13-12 07:34:00 [Worker_4] 11.22.33.44 info: authentication - login is used >Jan-13-12 07:34:00 [Worker_4] 11.22.33.44 authenticated >Jan-13-12 07:34:00 FS-58040-10689 [Worker_4] 11.22.33.44 ><[email protected]> email: combined spam & whitelist report >Jan-13-12 07:34:00 FS-58040-10689 [Worker_4] 11.22.33.44 ><[email protected]> email: combined spam & noprocessing report > >That is the last we ever see of Worker_4 in the log. > >The client goes through the helo/auth/mail from/rcpt to/data >sequence, and after it sends the \n.\n sequence, it waits for a >response from ASSP. However, because the thread has died on ASSP, it >never gets a response and eventually times out. It then tries to >re-send the message, which takes out yet another thread...until the >mail client has killed every worker thread. At that point my watchdog >process recognizes something bad has happened and steps in to stop >and restart ASSP. (my watchdog process watches the stats page - if it >stops getting a response from the stats page for several minutes, it >restarts ASSP). > >When I have users trying to send reports in this way, my ASSP is >being restarted every ten minutes or so. This means it is available >for only a few minutes at a time, with 7-8 minute gaps of >unavailability, and it is driving my users insane. > >It is not every report that does this - only some messages. I have >not been able to discern why some messages will kill the thread >reliably every time, and why others will be processed normally with >no problems. However, as the whitelist fills up, the problem seems to >get worse and worse. There are currently 89610 rows in my whitelist table. > >I know the last time we looked at this you said: > > >I know there are problems using the ODBC driver, because of several > >MS limitations - but ADO should work. > >Check that you use the latest MS-ODBC driver (Native Client) . > > > >I don't know exactly what else could be the reason. > >On reason could be: Tie::RDMB/DBI reads out the supported features > >from the datebase table. If the feature 'record locking' is enabled, > >all is fine - if not DBI uses Storable to lock the records. > >So if the return value for that feature is how ever wrong, the > >SQL-Server and Perl its self locks the record. It is realy hard to > >say what is going on on your system. > >I have tried both ODBC and ADO, it did not change the behavior at all. > >Any idea as to what I should be looking at next? I really need to >solve this problem. > >------------------------------------------------------------------------------ >RSA(R) Conference 2012 >Mar 27 - Feb 2 >Save $400 by Jan. 27 >Register now! >http://p.sf.net/sfu/rsa-sfdev2dev2 >_______________________________________________ >Assp-test mailing list >[email protected] >https://lists.sourceforge.net/lists/listinfo/assp-test ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ Assp-test mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/assp-test
