pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedNo response from the backend
5+ messages / 3 participants
[nested] [flat]
* No response from the backend
@ 2011-12-07 11:27 feng.zhou <feng.zhou@wellintech.com>
0 siblings, 1 reply; 5+ messages in thread
From: feng.zhou @ 2011-12-07 11:27 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: No response from the backend
@ 2011-12-07 13:25 Craig Ringer <ringerc@ringerc.id.au>
parent: feng.zhou <feng.zhou@wellintech.com>
0 siblings, 1 reply; 5+ messages in thread
From: Craig Ringer @ 2011-12-07 13:25 UTC (permalink / raw)
To: feng.zhou <feng.zhou@wellintech.com>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re: [SQL] No response from the backend
@ 2011-12-08 01:38 =?utf-8?B?ZmVuZy56aG91?= <feng.zhou@wellintech.com>
parent: Craig Ringer <ringerc@ringerc.id.au>
0 siblings, 1 reply; 5+ messages in thread
From: feng.zhou @ 2011-12-08 01:38 UTC (permalink / raw)
To: Craig Ringer <ringerc@ringerc.id.au>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: No response from the backend
@ 2011-12-08 04:11 Craig Ringer <ringerc@ringerc.id.au>
parent: =?utf-8?B?ZmVuZy56aG91?= <feng.zhou@wellintech.com>
0 siblings, 1 reply; 5+ messages in thread
From: Craig Ringer @ 2011-12-08 04:11 UTC (permalink / raw)
To: feng.zhou <feng.zhou@wellintech.com>; +Cc: pgsql-sql
On 12/08/2011 09:38 AM, feng.zhou wrote:
> 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.
>
Since client and server are on the same host, it's unlikely to be
network connectivity. Check the server logs.
--
Craig Ringer
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Re: [SQL] No response from the backend
@ 2011-12-08 04:18 =?utf-8?B?ZmVuZy56aG91?= <feng.zhou@wellintech.com>
parent: Craig Ringer <ringerc@ringerc.id.au>
0 siblings, 0 replies; 5+ messages in thread
From: feng.zhou @ 2011-12-08 04:18 UTC (permalink / raw)
To: Craig Ringer <ringerc@ringerc.id.au>; +Cc: pgsql-sql
Thanks, I will try it
2011-12-08
feng.zhou
发件人： Craig Ringer
发送时间： 2011-12-08 11:49:33
收件人： feng.zhou
抄送： pgsql-sql
主题： Re: [SQL] No response from the backend
On 12/08/2011 09:38 AM, feng.zhou wrote:
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.
Since client and server are on the same host, it's unlikely to be network connectivity. Check the server logs.
--
Craig Ringer
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2011-12-08 04:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-07 11:27 No response from the backend feng.zhou <feng.zhou@wellintech.com>
2011-12-07 13:25 ` Craig Ringer <ringerc@ringerc.id.au>
2011-12-08 01:38 ` =?utf-8?B?ZmVuZy56aG91?= <feng.zhou@wellintech.com>
2011-12-08 04:11 ` Craig Ringer <ringerc@ringerc.id.au>
2011-12-08 04:18 ` =?utf-8?B?ZmVuZy56aG91?= <feng.zhou@wellintech.com>
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