pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mitch Vincent <mitch@venux.net>
To: pgsql-php@postgresql.org
Subject: PostgreSQL troubles with 4.0.3pl1
Date: Thu, 19 Oct 2000 09:11:53 -0700
Message-ID: <012b01c039e7$4ba950f0$0200000a@doot> (raw)

    I've never had much trouble with PHP and PostgreSQL until this morning..
I was using persistent connections but started to have strange things happen
with PHP when I used them, so I elected to go back to using plain old
pg_connect(). I did and everything seemed to be working fine, then this
morning I go and log into my application and on most of my queries I get
something like

Warning: 1 is not a valid PostgreSQL link resource in
/usr/site/php/classes/db_pgsql.inc on line 64

Warning: 1 is not a valid PostgreSQL link resource in
/usr/site/php/classes/db_pgsql.inc on line 67


So it seems that pg_connect isn't returning false and that's a good thing,
still it seems the connection index is unusable..

I've stopped and restarted Apache and PostgreSQL, I even went so far as to
reboot and ruin my impressive uptime to make sure everything that needed to
be restarted got restarted... It's almost as if it's still trying to use
persistent connections..

Has anyone seen this before? The problems with persistent connections wasn't
noticeable until 4.0.3pl1 so it might be a problem there..


-Mitch

"I'd change the world if God would just give me the source code."




view thread (2+ messages)  latest in thread

Message-ID: <012b01c039e7$4ba950f0$0200000a@doot>
Permalink:  ../012b01c039e7$4ba950f0$0200000a@doot/
Also on:    postgresql.org/message-id/012b01c039e7$4ba950f0$0200000a@doot

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: mitch@venux.net
  Subject: Re: PostgreSQL troubles with 4.0.3pl1
  In-Reply-To: <012b01c039e7$4ba950f0$0200000a@doot>
  References: <012b01c039e7$4ba950f0$0200000a@doot>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox