BUG #3995: pqSocketCheck doesn't return

Started by Noro, Kyoukoabout 18 years ago3 messagesbugs
Jump to latest
#1Noro, Kyouko
kyouko.Noro@hp.com

The following bug has been logged online:

Bug reference: 3995
Logged by: Kyoko Noro
Email address: kyouko.noro@hp.com
PostgreSQL version: 8.2.3
Operating system: Red Hat Enterprise Linux AS release 4
Description: pqSocketCheck doesn't return
Details:

Hello Support team

I have a problem.May I ask your advice?

Sometimes pqSocketCheck doesn't return and our appication hang.Do you have
any bug report about the problem like this?

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noro, Kyouko (#1)
Re: BUG #3995: pqSocketCheck doesn't return

"Kyoko Noro" <kyouko.noro@hp.com> writes:

Sometimes pqSocketCheck doesn't return and our appication hang.

pqSocketCheck isn't accessible from outside libpq, and furthermore
it's often called with the *intention* of waiting for something to
happen. You need to provide more details of what you are doing
and what is happening (vs. what you expected to happen).

regards, tom lane

#3Noro, Kyouko
kyouko.Noro@hp.com
In reply to: Tom Lane (#2)
Re: BUG #3995: pqSocketCheck doesn't return

Hello Tom,

Thank you for your reply.

pqSocketCheck isn't accessible from outside libpq

Yes, I see.
SQL in our application is hang sometimes.
I saw gdb backtrace as follows.

(gdb) bt
#0 0x900bc8bc in poll ()
#2 0x0149abd2 in pqSocketCheck ()
・・・

I've been searching some cases like this but I've not had yet.
So If you have any bug reports, may I ask your advice?

Best raguard,
/kyoko noro

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, February 29, 2008 12:37 PM
To: Noro, Kyouko
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #3995: pqSocketCheck doesn't return

"Kyoko Noro" <kyouko.noro@hp.com> writes:

Sometimes pqSocketCheck doesn't return and our appication hang.

pqSocketCheck isn't accessible from outside libpq, and furthermore it's often called with the *intention* of waiting for something to happen. You need to provide more details of what you are doing and what is happening (vs. what you expected to happen).

regards, tom lane