Re: PostgreSQL / PHP Overrun Error

I am currently running PHP-4.0.6 (with the memory leak patch as posted to
correct a problem in this release [it is on the download page]).
The script that causes them mostly "includes" other scripts to do it's job.
The home page uses some of the scripts that it uses and I've seen the errors
there too. There errors seem infrequent, and just occur randomly... Maybe
every 2-10 minutes on a reasonably high-volume server. The commands that
seem to be getting executed by the script [it's not my script]:
pg_exec
pg_errormessage
pg_fetch_array
pg_errormessage
pg_freeresult
pg_fieldname
pg_fieldtype
pg_fieldsize
pg_cmdtuples
pg_numrows
pg_numfields

I have been trying minor modifications to the code to ensure that there are
no minor erorrs (such as setting things to null in case functions don't) but
am trying to track it down further.
I truly wish there was a way to get a status report from the script as
it goes [see what line it stopped on]- Unfortunatly, I don't think that's
really possible.

Thanks;
--
Mike

----- Original Message -----
From: "Brent R. Matzelle" <bmatzelle(at)yahoo(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Wednesday, September 26, 2001 1:55 PM
Subject: Re: [PHP] PostgreSQL / PHP Overrun Error

> --- Mike Rogers <temp6453(at)hotmail(dot)com> wrote:
> > Can anyone provide further input as to why this is causing
> > problems? The
> > PHP code works sometimes and not others, and it seems to be
> > only that one
> > script, so I do not believe it to be a hardware issue.
> >
> > Any thoughts? I can provide any further system information if
> > needed. I
> > have tried recompiling pgsql, php and apache with different
> > optimizations
> > [including none at all and debug mode on as i have now] with
> > little change
> > in the result.
>
> I performed a search on http://bugs.php.net/ but I did not find
> your problem. If it persists then I would suggest submitting a
> new bug report.
>
> PHP 4.0.6 is the first version of PHP to have the
> pg_last_notice() function which apparently the problem is tied
> in with. Is that the version that you are running? What PHP
> pg_* commands are you using on this PHP script that you are not
> using on other pages?
>
> Brent
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger. http://im.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>