Beta 4 problem(s)

Started by Mitch Vincentalmost 25 years ago3 messages
#1Mitch Vincent
mitch@venux.net

I've been using the 7.1 beta version for quite a while now and just upgraded
to beta 4, I've noticed my application is reporting that the backend shuts
down prematurely... (I'm using PHP).. I'm having a time trying to debug
this.. I know it's not my code as this works fine on a 7.0.3 install.. I've
upped my debug level to the max and don't see anything indicating that the
backend crashed, so I'm at a loss..

In the PHP code, I just go to execute a query (after checking to make sure
the value returned by pg_connect isn't 0) and I get a PHP warning "Warning:
1 is not a valid PostgreSQL link resource in ...".

I'd like to figure this out, any pointers on what I might be able to do in
the backend?

It seems to be somewhat PHP related because I can take the individual
queries and run them in psql just fine.. Are there any known issues in beta4
that might cause this kind of thing to happen? Are there any changes that
anyone can think of that might need to happen to the PHP PostgreSQL support
for 7.1? I'd be happy to look into doing making the changes if so..

Thanks!!

-Mitch

#2Matthew
matt@ctlno.com
In reply to: Mitch Vincent (#1)
RE: Beta 4 problem(s)

Did you recompile PHP with postgre support after you upgraded?

Show quoted text

-----Original Message-----
From: Mitch Vincent [SMTP:mitch@venux.net]
Sent: Thursday, February 01, 2001 9:13 AM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] Beta 4 problem(s)

I've been using the 7.1 beta version for quite a while now and just
upgraded
to beta 4, I've noticed my application is reporting that the backend shuts
down prematurely... (I'm using PHP).. I'm having a time trying to debug
this.. I know it's not my code as this works fine on a 7.0.3 install..
I've
upped my debug level to the max and don't see anything indicating that the
backend crashed, so I'm at a loss..

In the PHP code, I just go to execute a query (after checking to make sure
the value returned by pg_connect isn't 0) and I get a PHP warning
"Warning:
1 is not a valid PostgreSQL link resource in ...".

I'd like to figure this out, any pointers on what I might be able to do in
the backend?

It seems to be somewhat PHP related because I can take the individual
queries and run them in psql just fine.. Are there any known issues in
beta4
that might cause this kind of thing to happen? Are there any changes that
anyone can think of that might need to happen to the PHP PostgreSQL
support
for 7.1? I'd be happy to look into doing making the changes if so..

Thanks!!

-Mitch

#3Mitch Vincent
mitch@venux.net
In reply to: Matthew (#2)
Re: Beta 4 problem(s)

Yes, I did..

-Mitch

----- Original Message -----
From: "Matthew" <matt@ctlno.com>
To: "'Mitch Vincent'" <mitch@venux.net>; <pgsql-hackers@postgresql.org>
Sent: Thursday, February 01, 2001 10:33 AM
Subject: RE: [HACKERS] Beta 4 problem(s)

Did you recompile PHP with postgre support after you upgraded?

-----Original Message-----
From: Mitch Vincent [SMTP:mitch@venux.net]
Sent: Thursday, February 01, 2001 9:13 AM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] Beta 4 problem(s)

I've been using the 7.1 beta version for quite a while now and just
upgraded
to beta 4, I've noticed my application is reporting that the backend

shuts

down prematurely... (I'm using PHP).. I'm having a time trying to debug
this.. I know it's not my code as this works fine on a 7.0.3 install..
I've
upped my debug level to the max and don't see anything indicating that

the

backend crashed, so I'm at a loss..

In the PHP code, I just go to execute a query (after checking to make

sure

the value returned by pg_connect isn't 0) and I get a PHP warning
"Warning:
1 is not a valid PostgreSQL link resource in ...".

I'd like to figure this out, any pointers on what I might be able to do

in

the backend?

It seems to be somewhat PHP related because I can take the individual
queries and run them in psql just fine.. Are there any known issues in
beta4
that might cause this kind of thing to happen? Are there any changes

that

Show quoted text

anyone can think of that might need to happen to the PHP PostgreSQL
support
for 7.1? I'd be happy to look into doing making the changes if so..

Thanks!!

-Mitch