Re: PostgreSQL / PHP Overrun Error

--- Mike Rogers <temp6453@hotmail.com> wrote:
> 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

All of those functions are okay to use except that I would
commment out the calls to pg_freeresult().  I have seen various
older bug reports that have noted that this function can be
troublesome.  Plus, PHP frees this memory automatically whether
you call this function or not.  I rarely use this function,
unless I am making queries that return enormous amounts of data,
and even then I really do not require it.

Last note, the PHP debug information that you gathered seemed to
be cleaning up the pg_notice memory if I was not mistaken.  I
would not be surprised if this function was called by
pg_freeresult.

Brent

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com