Skip site navigation (1) Skip section navigation (2)

Hang in PQgetResult

From: "Ivetta Starikova" <ivetta_s(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Hang in PQgetResult
Date: 2004-02-20 02:58:48
Message-ID: BAY10-F105KGW2yL30P000045a8@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hello,
I have a problem with my program that inserts records into postgreSQL 
database.
After continuously running for several days, it suddenly hangs.  Attaching 
with
gdb to a process gives the following stack trace.  It seems like a few 
people
reported this problem but I haven't seen anyone suggest a steady solution.
In this post http://archives.postgresql.org/pgsql-bugs/2000-09/msg00062.php
it is suggested to call PQstatus(), before making PQexec().  So the idea is
to call PQstatus() and if it's not good to reconnect, right?
Please, help.
Thank you.

(gdb) where

#0  0x4013241e in select () from /lib/libc.so.6

#1  0x401cb980 in __DTOR_END__ () from /usr/idp/mgt-svr/lib/logActions/db.so

#2  0x401bf9e5 in pqWait (forRead=1, forWrite=0, conn=0x81f2318) at 
fe-misc.c:782

#3  0x401bd9fd in PQgetResult (conn=0x81f2318) at fe-exec.c:1337

#4  0x401bdbe5 in PQexec (conn=0x81f2318,

    query=0xbfffe298 "INSERT INTO my_table VALUES (2, 1, 'no', 'no', 'no', 
'no',"...)

    at fe-exec.c:1462

_________________________________________________________________
Get a FREE online computer virus scan from McAfee when you click here. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


Responses

pgsql-bugs by date

Next:From: Laurent FAILLIEDate: 2004-02-20 09:10:24
Subject: Re: zlib directory in configure.
Previous:From: Wade KlaverDate: 2004-02-20 00:52:37
Subject: date_part returns different results with same interval.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group