SOS! HELP- APACHE PROCESS PROBLEM

[Chandragupt <cg...@rediffmail.com>]

Hi,

We have developed a BioInformatics Web based Application using
CGIC , Linux and Apache as the webserver. We are using MySQL
database for data handling.
We have run into a problem wherein if the browser which has sent
the request to Apache is closed in between a process, the 
process
continues to run instead of being terminated. This causes the
queuing of unwanted processes (both for Apache and MySQL).

Can you suggest some solutions to this problem? Is there any way
to programatically trap the browser generated( e.g when the
browser is closed or stop button is pressed) events in Apache or
CGIC?

Looking forward to an early reply.

regards

Chandragupt
TCG Software Services (P) Ltd.
India

Cell Nos.
09818022792
09810255383
09810230704



On Fri, 25 Oct 2002 David Burry wrote :
>At 09:38 PM 10/24/2002 -0400, Glenn wrote:
> >Have you looked at the %...X directive in Apache2?
>
>
>That's an interesting idea I hadn't thought of...  it doesn't 
>solve the chargeback issue but it's worth investigating for 
>detecting successful downloads...
>
>Dave
>

__________________________________________________________
Give your Company an email address like
ravi @ ravi-exports.com.  Sign up for Rediffmail Pro today!
Know more. http://www.rediffmailpro.com/signup/

Re: SOS! HELP- APACHE PROCESS PROBLEM

[Jeff Trawick <tr...@attglobal.net>]

"William A. Rowe, Jr." <wr...@apache.org> writes:

> At 07:04 PM 10/25/2002, Jeff Trawick wrote:
> >"Chandragupt" <cg...@rediffmail.com> writes:
> >
> >> Hi,
> >> 
> >> We have developed a BioInformatics Web based Application using
> >> CGIC , Linux and Apache as the webserver. We are using MySQL
> >> database for data handling.
> >> We have run into a problem wherein if the browser which has sent
> >> the request to Apache is closed in between a process, the process
> >> continues to run instead of being terminated. This causes the
> >> queuing of unwanted processes (both for Apache and MySQL).
> >
> >isn't this like PR 8388?
> >
> >http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8388
> >
> >Can the CGI write an HTML comment to the browser fairly regularly to
> >cause Apache to detect when the connection is reset?  Wouldn't that
> >abort the connection and cause the CGI to get cleaned up?
> >
> >How else would Apache notice?
> 
> What about simply writing 0 bytes to the socket periodically?  Would
> that catch the disconnect?

dunno about the idea of writing 0 bytes...  how would a CGI break core
(or 3rd-party filter) out of a pipe read and tell it to write 0 bytes
to the network?

unfortunately, writing actual data doesn't work at the moment...  I
was playing with it last night and saw that core_output encounters an
error writing to the client but some upstream filter (content-length?)
didn't notice...  hoping to play with that now for a while...

-- 
Jeff Trawick | trawick@attglobal.net
Born in Roswell... married an alien...

Re: SOS! HELP- APACHE PROCESS PROBLEM

["William A. Rowe, Jr." <wr...@apache.org>]

At 07:04 PM 10/25/2002, Jeff Trawick wrote:
>"Chandragupt" <cg...@rediffmail.com> writes:
>
>> Hi,
>> 
>> We have developed a BioInformatics Web based Application using
>> CGIC , Linux and Apache as the webserver. We are using MySQL
>> database for data handling.
>> We have run into a problem wherein if the browser which has sent
>> the request to Apache is closed in between a process, the process
>> continues to run instead of being terminated. This causes the
>> queuing of unwanted processes (both for Apache and MySQL).
>
>isn't this like PR 8388?
>
>http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8388
>
>Can the CGI write an HTML comment to the browser fairly regularly to
>cause Apache to detect when the connection is reset?  Wouldn't that
>abort the connection and cause the CGI to get cleaned up?
>
>How else would Apache notice?

What about simply writing 0 bytes to the socket periodically?  Would
that catch the disconnect?

Bill

Re: SOS! HELP- APACHE PROCESS PROBLEM

[Jeff Trawick <tr...@attglobal.net>]

"Chandragupt" <cg...@rediffmail.com> writes:

> Hi,
> 
> We have developed a BioInformatics Web based Application using
> CGIC , Linux and Apache as the webserver. We are using MySQL
> database for data handling.
> We have run into a problem wherein if the browser which has sent
> the request to Apache is closed in between a process, the process
> continues to run instead of being terminated. This causes the
> queuing of unwanted processes (both for Apache and MySQL).

isn't this like PR 8388?

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=8388

Can the CGI write an HTML comment to the browser fairly regularly to
cause Apache to detect when the connection is reset?  Wouldn't that
abort the connection and cause the CGI to get cleaned up?

How else would Apache notice?

Note that there was various streaming breakage until recently :(

-- 
Jeff Trawick | trawick@attglobal.net
Born in Roswell... married an alien...