Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL / PHP Overrun Error

From: "Mike Rogers" <temp6453(at)hotmail(dot)com>
To: "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com>, <pgsql-php(at)postgresql(dot)org>
Subject: Re: PostgreSQL / PHP Overrun Error
Date: 2001-09-26 19:46:16
Message-ID: OE64wAeRaNgEpTX5V3G00002a0a@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-php
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
>

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2001-09-26 19:53:29
Subject: Re: LOCAL_CREDS -> SCM_CREDS in src/backend/libpq/auth.c:535
Previous:From: Doug McNaughtDate: 2001-09-26 19:18:18
Subject: Re: Spinlock performance improvement proposal

pgsql-bugs by date

Next:From: Brent R. MatzelleDate: 2001-09-26 20:05:10
Subject: Re: PostgreSQL / PHP Overrun Error
Previous:From: mlwDate: 2001-09-26 17:15:14
Subject: Re: PostgreSQL / PHP Overrun Error

pgsql-php by date

Next:From: Brent R. MatzelleDate: 2001-09-26 20:05:10
Subject: Re: PostgreSQL / PHP Overrun Error
Previous:From: mlwDate: 2001-09-26 17:15:14
Subject: Re: PostgreSQL / PHP Overrun Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group