Apache Stuck In Sending Reply
First and foremost, my apologies for having to post this question here. But this is the best source for answers as far as I know.
Our production environment runs Apache 2.2.8 on Windows Server 2008 (R2) with 8GB RAM and ample of hard disk space. This is a 3 tier setup with Resin (caucho) as the application server and MS SQL as the database server. We run a shared hosting environment whereby each virtual host is connected to its respected resin application server. (single apache server, multiple resin)
Recently, our web site has been not accessible and the only way to resolve it is to restart apache. When checked on the mod_status page, i noticed that the connection builds up on "W" (which is sending reply). The connection would then just accumulate until the worker runs out and apache crashes.
Our other sites share the same setup but do not encounter this issue. This particular site however, handles more load than the others. However, this issue occurs randomly even during off peak hours.
I've went through numerous sites but they all suggest to investigate on the application scripts for an indefinite loop. We've done this and could not find any issue with our scripts.
Hope any of you experts out there could assist us in identifying the root cause of this issue.