[Pgpool-general] pgpool limitations

[Sandeep Thakkar]

I have found that sometimes the client connections get disconnected and the new ones are established. What I do is I get the PIDs using "pcp_proc_count" before running "pcp_attach_node" and then run "pcp_proc_count" to check if the PIDs remain same. I found that the behaviour is random. When can this happen?


________________________________
 From: Tatsuo Ishii <ishii at sraoss.co.jp>
To: singh.gurjeet at gmail.com 
Cc: pgpool-general at pgfoundry.org; pgpool-hackers at pgfoundry.org 
Sent: Thursday, August 11, 2011 6:11 AM
Subject: Re: [Pgpool-general] pgpool limitations
 
>> > > Is there something in the works to enable this, or is this feature
>> still in
>> > > design phase? If it is already being/been developed, I wish to know if
>> this
>> > > can be back-patched to a point release of pgpool 3.0.x.
>> >
>> > It has been already in pgpool-II 3.1 alpha version.
>> > Currently there's no plan to back-patching to 3.0.x.
>>
>> I certainly hope we won't backpatch a new feature. That would be insane.
>>
> 
> I don't consider this a new feature. I'd say this is unexpected side-effect
> (a.k.a bug) of pcp_attach_node, since nowhere in the docs does is say that
> invoking pcp_attach_node would drop all client connections.

This behavior has not been changed since pcp_attach_node was born in
2006. Moreover, the enhancement in 3.1 is only for steaming
replication mode. Other modes including replication mode does not take
advantage of this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20111123/62e16741/attachment-0001.html>