Re: [users@httpd] Apache stops listening

[Joshua Kogut <jm...@gmail.com>]

Would you have a problem with me looking over your code? Loops love to get
out of hand. especially when they realize that you are inserting info into a
database. lol

On 10/31/05, PMilanese@nypl.org <PM...@nypl.org> wrote:
>
>
> About once a week or so Apache just stops listening and we have to restart
>
> the Apache service. I had found in one of my php scripts a problem with
> some database calls. The result set was being populated over and over
> again in a loop that may occur several thousand times. I added an unset to
>
> the bottom of the loop and we went from having this problem on almost a
> daily basis to about once a week. I just went through my php code with a
> fine tooth comb and found one other spot that this may be occuring and
> changed it. I am hoping this will fix our problem. Has anyone seen this
> problem before? Am I on the right track? Also, I am considering setting
> up a scheduled event to restart Apache at 2AM every morning. Do you think
> this might help?
>
>
>  *[Pete Says:] How do you define 'stops listening', and do you mean 'stops
> responding'? If you note problems with database calls, then that may be
> where all of your problems lie. Perhaps it is timing out threads, consuming
> all of them, and denying requests as a result. Are you sure your code is
> exiting properly? I would continue checking for that kind of thing. You do
> not mention CPU use either. When apache does not respond, does load go up on
> the cpu(s)?*
>  --------------------------------------------------------------------- The
> official User-To-User support forum of the Apache HTTP Server Project. See
> for more info. To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org" from the digest:
> users-digest-unsubscribe@httpd.apache.org For additional commands, e-mail:
> users-help@httpd.apache.org




--
|| jmkogut ||
email: jmkogut@gmail.com
|| Networking: Where all your problems are category 5. ||