Tonight I did some further testing. I tried switching the DBdriver to an ODBC (MSODBCSQL11), SQL Server (SQLSRV32) and ODBC Native Client (SQLNCLI10) - all of them continue to show the database time warnings when used, the same as the ADO type.
Looking at the mail server run tonight at 11:30 pm, the usage is very low, maybe one message processed every six seconds. The server CPU and disk usage is very low, almost zero. The SQL Server performance values are also near zero - basically the server is pretty much idling. Yet I am still seeing these warnings where database connections are taking 5, 7, sometimes as much as 20 seconds. It's clear that whenever these database connections are being attempted, that ASSP is blocking, which is what is causing the whole thing to come to a screeching halt. I'm starting to think that there is another issue - a threading issue perhaps, where a thread is blocking when a database connection is opened - and it is not the database itself that is causing the delay, but something else blocking within ASSP. On 3/4/2015 5:55 PM, Scott MacLean wrote: > 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 ------------------------------------------------------------------------------ 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
