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 ...