Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id 6C3369ED581
	for <pgsql-sql@postgresql.org>; Wed,  7 Dec 2011 07:30:17 -0400 (AST)
Received: from [119.161.170.176] (helo=MAIL.kingview.com)
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <feng.zhou@wellintech.com>) id 1RYFhY-0001dB-N9
	for pgsql-sql@postgresql.org; Wed, 07 Dec 2011 11:30:17 +0000
Received: from zhoufeng ([172.16.3.16]) by MAIL.kingview.com with Microsoft
	SMTPSVC(6.0.3790.1830); Wed, 7 Dec 2011 19:07:49 +0800
Date: Wed, 7 Dec 2011 19:27:14 +0800
From: "feng.zhou" <feng.zhou@wellintech.com>
To: "pgsql-sql" <pgsql-sql@postgresql.org>
Subject: No response from the backend
Message-ID: <201112071927138456264@wellintech.com>
X-mailer: Foxmail 6, 15, 201, 22 [cn]
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=====003_Dragon448228876823_====="
X-OriginalArrivalTime: 07 Dec 2011 11:07:49.0609 (UTC)
	FILETIME=[7500DD90:01CCB4D0]
X-Host-Lookup-Failed: Reverse DNS lookup failed for 119.161.170.176 (failed)
X-Pg-Spam-Score: 3.0 (+++)
X-Archive-Number: 201112/10
X-Sequence-Number: 36071


This is a multi-part message in MIME format.

--=====003_Dragon448228876823_=====
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

2011-12-07 



feng.zhou 

--=====003_Dragon448228876823_=====
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18928"><LINK rel=stylesheet 
href="BLOCKQUOTE{margin-Top: 0px; margin-Bottom: 0px; margin-Left: 2em}"></HEAD>
<BODY style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">
<DIV><FONT size=2 face=Verdana>
<DIV><FONT size=2>Hi</FONT></DIV>
<DIV>There are some questions when using progreSQL8.4.2. I don't sure this 
problem is bug.The detail is following:</DIV>
<DIV>I&nbsp;make a&nbsp;client program that communicate 
with&nbsp;&nbsp;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:&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>
<DIV>2011/11/26&nbsp;08:38:05.527,&nbsp;&nbsp;:&nbsp;SQL&nbsp;ERROR:&nbsp;GetSelectRowNum:&nbsp;<FONT 
color=#ff0000>No&nbsp;response&nbsp;from&nbsp;the&nbsp;backend</FONT>;</DIV>
<DIV>No&nbsp;response&nbsp;from&nbsp;the&nbsp;backend</DIV>
<DIV>2011/11/26&nbsp;08:38:05.527,&nbsp;&nbsp;&nbsp;:&nbsp;SQL&nbsp;ERROR:&nbsp;GetSelectRowNum:&nbsp;State:42601,Native:26</DIV>
<DIV>
<DIV>
<DIV>2011/11/26&nbsp;08:38:05.527,&nbsp;&nbsp;&nbsp;:&nbsp;SQL&nbsp;ERROR:&nbsp;GetSelectRowNum:&nbsp;<FONT 
color=#ff0000>Could&nbsp;not&nbsp;send&nbsp;Query(connection&nbsp;dead);</FONT></DIV>
<DIV>Could&nbsp;not&nbsp;send&nbsp;Query(connection&nbsp;dead)</DIV>
<DIV>&nbsp;</DIV>
<DIV>I don't know how to solve this problem. Someone can explain this problem 
cause.Thanks</DIV></DIV></DIV></DIV></FONT></DIV>
<DIV><FONT size=2 face=Verdana></FONT>&nbsp;</DIV>
<DIV align=left><FONT color=#c0c0c0 size=2 face=Verdana>2011-12-07 
</FONT></DIV><FONT size=2 face=Verdana>
<HR style="WIDTH: 122px; HEIGHT: 2px" align=left SIZE=2>

<DIV><FONT color=#c0c0c0 size=2 face=Verdana><SPAN>feng.zhou</SPAN> 
</FONT></DIV></FONT></BODY></HTML>

--=====003_Dragon448228876823_=====--