From: Craig Ringer <ringerc@ringerc.id.au>
To: feng.zhou <feng.zhou@wellintech.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: No response from the backend
Date: Wed, 07 Dec 2011 21:25:47 +0800
Message-ID: <4EDF695B.1010008@ringerc.id.au> (raw)
In-Reply-To: <201112071927138456264@wellintech.com>
References: <201112071927138456264@wellintech.com>
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 instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ringerc@ringerc.id.au, feng.zhou@wellintech.com
Subject: Re: No response from the backend
In-Reply-To: <4EDF695B.1010008@ringerc.id.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox