pqSocketCheck() didn't return, hung in poll()? Is it a bug?

From: Lizzy M <lizzymy(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: pqSocketCheck() didn't return, hung in poll()? Is it a bug?
Date: 2009-07-08 08:08:44
Message-ID: 1ea109390907080108wdd505afs8859405c25843735@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

Hi all,

I have this problem today: one thread of our application hung, and
we found the thread waiting for the result of poll() function. poll()
was called by pgSocketCheck(). So is it a bug of pg? I found the bug
report from website(http://archives.postgresql.org/pgsql-bugs/2008-02/msg00260.php),
and want to know:

1. Has this problem been solved in the newest version?
2. If not, what shall I do to avoid this problem?

Thanks a lot!

PS: version info:
PostgreSQL version: PostgreSQL 8.3.3 on i686-pc-linux-gnu
Operating system: CentOS release 5.2 (Final)
Kernel version: Linux version 2.6.18-92.el5xen
(mockbuild(at)builder16(dot)centos(dot)org)

gdb info:
(gdb) bt
#0 0x00d31402 in __kernel_vsyscall ()
#1 0x003d3dc3 in poll () from /lib/i686/nosegneg/libc.so.6
#2 0x0013de5d in pqSocketCheck () from /usr/local/pgsql/lib/libpq.so.5
#3 0x0013df8d in pqWaitTimed () from /usr/local/pgsql/lib/libpq.so.5
#4 0x0013e003 in pqWait () from /usr/local/pgsql/lib/libpq.so.5
#5 0x0013d792 in PQgetResult () from /usr/local/pgsql/lib/libpq.so.5

--
Yours Sincerely,
Liz

Browse pgsql-bugs by date

  From Date Subject
Next Message Wojciech Strzałka 2009-07-08 09:56:00 Re: Unknown winsock error 10061
Previous Message Andreas Wenk 2009-07-07 19:32:01 Re: Sugestion a db modele like mysql workbrench

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-07-08 08:47:05 Re: Passing a table to function
Previous Message leif 2009-07-08 07:41:42 Re: Bug in ecpg lib ?