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@xxxxxxxxx> To: <pgsql-php@xxxxxxxxxxxxxx> Sent: Wednesday, September 26, 2001 1:55 PM Subject: Re: [PHP] PostgreSQL / PHP Overrun Error > --- Mike Rogers <temp6453@xxxxxxxxxxx> 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 >