Thanks for your answer.
The client and server run on the same machine(Windows7). They are connected by 
ODBC.The client accesses server by call ODBC API.Connection and query timeout 
don't be set in the client. 


2011-12-08 



feng.zhou 



发件人: Craig Ringer 
发送时间: 2011-12-07  21:03:46 
收件人: feng.zhou 
抄送: pgsql-sql 
主题: Re: [SQL] No response from the backend 
 
On 12/07/2011 07:27 PM, feng.zhou wrote: 
Hi
There are some questions when using progreSQL8.4.2. I don't sure this problem 
is bug.The detail is following:
I make a client program that communicate with  progreSQL by ODBC on Windows7. 
After running serveral months, this client program is hung at 00:01 in 
2011-11-26 , and become OK after 8 hours.When becoming OK, client program log 
message is following: 

2011/11/26 08:38:05.527,  : SQL ERROR: GetSelectRowNum: No response from the 
backend;
No response from the backend
2011/11/26 08:38:05.527,   : SQL ERROR: GetSelectRowNum: State:42601,Native:26
2011/11/26 08:38:05.527,   : SQL ERROR: GetSelectRowNum: Could not send 
Query(connection dead);
Could not send Query(connection dead)

I don't know how to solve this problem. Someone can explain this problem 
cause.Thanks

I'd say you had a connectivity drop-out, and it only recovered when your TCP/IP 
connection timed out. Reduce your TCP/IP timeouts and/or enable keepalives if 
you have an unreliable network connection between client and server.

If that's not the case, then more detail please. Where do the client and server 
run (same machine?)? How are they connected? etc.

--
Craig Ringer

Reply via email to