Re: [HACKERS] PID of backend - Mailing list pgsql-hackers

From Dmitry Samersoff
Subject Re: [HACKERS] PID of backend
Date
Msg-id XFMail.990603162301.dms@wplus.net
Whole thread Raw
In response to Re: [HACKERS] PID of backend  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
On 03-Jun-99 The Hermit Hacker wrote:
> On Wed, 2 Jun 1999, Dmitry Samersoff wrote:
> 
>> Thanks ! It's exactly what I need. (But it s'seems not documented ?) 
>> 
>> I need to restart backend because (as written  above) 
>> every 300 000 "open cursor" query completly loose it's mind.
> 
> I'm lost here...doesn't doing a close and then reopening the connection
> restart the backend?  Why would you have to 'kill' it?

After 300 000 open cursor query (and certtainly close cursor), 
next query returns error like example below for all other connections 
(ROLLBACK is a query from other process, it just example of message nothing
more)
- ie backend exists in memory but stops answer query and allocates new
connections. 

>> Jun  2 00:12:32 mail popper[17585]: PgSQL:ROLLBACK failed: PQsendQuery()
>>> There is no connection to the backend. 

---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Re: Freezing docs for v6.5
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Open 6.5 items