Received: from web13008.mail.yahoo.com (web13008.mail.yahoo.com [216.136.174.18]) by postgresql.org (8.11.3/8.11.4) with SMTP id f8QK5Fh72807 for ; Wed, 26 Sep 2001 16:05:15 -0400 (EDT) (envelope-from bmatzelle@yahoo.com) Message-ID: <20010926200510.6710.qmail@web13008.mail.yahoo.com> Received: from [146.145.232.35] by web13008.mail.yahoo.com via HTTP; Wed, 26 Sep 2001 13:05:10 PDT Date: Wed, 26 Sep 2001 13:05:10 -0700 (PDT) From: "Brent R. Matzelle" Subject: Re: PostgreSQL / PHP Overrun Error To: Mike Rogers , pgsql-php@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200109/23 X-Sequence-Number: 544 --- Mike Rogers 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