I have a problem with my program that inserts records into postgreSQL
After continuously running for several days, it suddenly hangs. Attaching
gdb to a process gives the following stack trace. It seems like a few
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?
#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
#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',
Get a FREE online computer virus scan from McAfee when you click here.
pgsql-bugs by date
|Next:||From: Laurent FAILLIE||Date: 2004-02-20 09:10:24|
|Subject: Re: zlib directory in configure. |
|Previous:||From: Wade Klaver||Date: 2004-02-20 00:52:37|
|Subject: date_part returns different results with same interval.|