Re: PostgreSQL / PHP Overrun Error

--- Mike Rogers <temp6453(at)hotmail(dot)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