On 12.04.2013 09:41, Singh, Devendra wrote:
Hi All,
I hit a hang issue in postgres 8.4 query. Hit this issue multiple time on
HP-UX. Below is the snapshot of the hang thread.
-------------------------------- lwpid : 600943
-------------------------------
0: c00000000054ced0 : _poll_sys() + 0x30 (/usr/lib/hpux64/libc.so.1)
1: c000000000561560 : poll() + 0xe0 (/usr/lib/hpux64/libc.so.1)
2: c000000001f798e0 : pqSocketPoll() at fe-misc.c:1079
3: c000000001f790e0 : pqWait() at fe-misc.c:1024
4: c000000001f6ebb0 : PQgetResult() at fe-exec.c:1554
5: c000000001f6f0a0 : PQexec() at fe-exec.c:1735
Is it a known issue? Any possible workaround ?
The first thing that comes to mind is that the query is simply taking a
long time to execute, or is being blocked trying to acquire a lock that
another process is holding in the server. You'll have to provide a lot
more details if you want anyone to make a better guess than that. A
simplified test program that reproduces the problem would be best.
- Heikki
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs