I have ASSP build 15059 running on Windows 2008 Server against a MS SQL Server 2008 R2 database. It's running Activestate v5.20.1 (32 bit).
The server has lots of disk space and 16 GB of RAM, with lots of processor power. I have seen as many as 50 simultaneous inbound SMTP connections, but it averages more around 10-15. I'm having major problems where ASSP will just die, stop accepting connections for long periods of time - between 30 and 60 seconds. Sometimes it will just run really slowly, where it will accept a connection, but it will be 30 seconds or more before the connection is transferred to the mail server and a 220 response is received. During this time, both the mail server and the SQL server are basically idling, doing nothing at all. However, many of these times I am seeing this being logged in ASSP: Mar-04-15 17:13:40 [Worker_5] Warning: Worker_5 - check the database connections has taken 2.375 seconds (max=1.000s) Mar-04-15 17:14:41 [Main_Thread] Warning: Main_Thread - check the database connections has taken 2.822 seconds (max=1.000s) Mar-04-15 17:16:45 [Worker_10] Warning: Worker_10 - check the database connections has taken 27.143 seconds (max=1.000s) Mar-04-15 17:17:41 [Worker_2] Warning: Worker_2 - check the database connections has taken 7.436 seconds (max=1.000s) Mar-04-15 17:21:56 [Worker_9] Warning: Worker_9 - check the database connections has taken 25.270 seconds (max=1.000s) Mar-04-15 17:27:23 [Worker_6] Warning: Worker_6 - check the database connections has taken 4.449 seconds (max=1.000s) Mar-04-15 17:27:24 [Main_Thread] Warning: Main_Thread - check the database connections has taken 5.634 seconds (max=1.000s) Mar-04-15 17:27:26 [Worker_9] Warning: Worker_9 - check the database connections has taken 4.603 seconds (max=1.000s) Mar-04-15 17:27:26 [Worker_7] Warning: Worker_7 - check the database connections has taken 5.896 seconds (max=1.000s) Mar-04-15 17:29:14 [Worker_10] Warning: Worker_10 - check the database connections has taken 9.730 seconds (max=1.000s) When the server is running smoothly (and it does, sometimes!) and processing lots of mail, I can see the SQL server processing between 30-50 transactions per second. When ASSP stops responding, and starts logging the database connection messages, the SQL server activity drops to pretty much zero. So I don't think a database bottleneck is the issue. My DBdriver is set to ADO,provider=SQLNCLI10;DataTypeCompatibility=80; I have my DBCacheMaxAge set to 10. Any ideas what else I should be looking for to figure this problem out? I'm also seeing random crashes, where ASSP simply quits, no errors, nothing in an event log, no indication as to why it is restarting. It just dumps what it is doing and restarts: 04-15 17:44:16 NB-09055-07507 [Worker_5] 112.93.36.xxx <xxxxx...@xxxx.com> [SMTP Error] 550 5.1.1 User unknown: x...@xxxxx.com Mar-04-15 17:44:16 NB-09055-02811 [Worker_3] 69.49.111.xxxx <x...@xxxx.com> to: x...@xxxx.com recipient accepted: x...@xxxx.com Mar-04-15 17:44:16 NB-09056-10350 [Worker_7] [ValidHELO] 156.99.167.xxxx <xx...@xxxx.com> [scoring] (not valid HELO: 'IVORAEX') Mar-04-15 17:44:16 NB-09056-10350 [Worker_7] 156.99.167.xxxx <x...@xxxx.com> Message-Score: added 25 (ihValencePB) for not valid HELO: 'IVORAEX', total score for this message is now 25 Mar-04-15 17:45:21 [startup] Starting as a service Mar-04-15 17:45:24 [startup] ASSP version 2.4.4(15059) (Perl 5.020001) (on MSWin32) initializing Lastly, ASSP will just "pause" and do absolutely nothing for a couple minutes now and then. No indication as to what happened, no errors, it just stops. CPU, disk, database all idle during this time, ASSP just stops doing anything - and then picks up from where it left off - note the time gap between from 17:47:41 to 17:49:06 Mar-04-15 17:47:36 [Worker_8] 66.207.47.59 info: no (more) data readable from 66.207.47.xxxx (connection closed by peer) - An existing connection was forcibly closed by the remote host. Mar-04-15 17:47:38 [Worker_8] Disconnected: session:451CAA2C 66.207.47.xxxxx - command list was 'n/a' - used 1 SocketCalls - processing time 7 seconds Mar-04-15 17:47:39 [Worker_8] Worker_8 will sleep now Mar-04-15 17:47:39 [Main_Thread] Info: Main_Thread got connection request Mar-04-15 17:47:41 [Worker_8] Worker_8 wakes up Mar-04-15 17:49:06 [Worker_10000] Info: Name Server 8.8.8.8: ResponseTime = 15 ms for sourceforge.net Mar-04-15 17:49:06 [Worker_10000] Info: Name Server 216.227.137.xxx : ResponseTime = 1 ms for sourceforge.net Mar-04-15 17:49:06 [Worker_10000] Info: Name Server 67.159.56.xxx: ResponseTime = 8 ms for sourceforge.net Mar-04-15 17:49:07 NB-09180-03959 [Worker_9] [MessageOK] 192.41.46.xxxx <xx...@xxxx.ca> to: xxxxx@xxxx .com message ok - (whitelistdb) - [FW Re Automatic reply] -> D:/ASSP/notspam/3959.eml All of this has made my mail server EXTREMELY unreliable, and I am being pressured to ditch ASSP entirely because of the continual problems it is creating. I am open to any and all suggestions! ------------------------------------------------------------------------------ Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
