Hi, it works!
Great. Thanks everybody for help!!! 2007/11/16, Yoshiyuki Asaba <[EMAIL PROTECTED]>: > > Hi, > > From: "Oleg Laktionov" <[EMAIL PROTECTED]> > Subject: Re: [Pgpool-general] pgpool-ii health checking > Date: Wed, 14 Nov 2007 19:54:46 +0300 > > > >You need to perform pcp_attach_node command. pgpool do not reattach a > > >node in health checking. > > > > And why pgpool does not balance connections when one node fails? I > cannot > > connect to the database through the pgpool if some of the nodes is down. > > Only restart of the pgpool helps... > > Thank you for the report. Could you apply the following patch? > > > http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgpool/pgpool-II/pool_auth.c.diff?r1=1.3&r2=1.3.2.1&f=u > > -- > Yoshiyuki Asaba > [EMAIL PROTECTED] > > > > > 2007-11-13 13:48:55 LOG: pid 25848: connection received: host= > > tmpwc.test.sportbox.ru port=46253 > > 2007-11-13 13:48:55 DEBUG: pid 25848: Protocol Major: 3 Minor: 0 > database: > > sportdb user: zope > > 2007-11-13 13:48:55 DEBUG: pid 25848: new_connection: connecting 0 > backend > > 2007-11-13 13:48:55 DEBUG: pid 25848: new_connection: connecting 1 > backend > > 2007-11-13 13:48:55 DEBUG: pid 25848: new_connection: connecting 2 > backend > > 2007-11-13 13:48:55 DEBUG: pid 25848: new_connection: skipping slot 2 > > because backend_status = 3 > > 2007-11-13 13:48:55 DEBUG: pid 25848: pool_read_message_length: slot: 0 > > length: 8 > > 2007-11-13 13:48:55 DEBUG: pid 25848: pool_read_message_length: slot: 1 > > length: 8 > > 2007-11-13 13:48:55 DEBUG: pid 25848: trying clear text password > > authentication > > 2007-11-13 13:48:55 DEBUG: pid 25848: trying clear text password > > authentication > > 2007-11-13 13:48:55 DEBUG: pid 25848: trying clear text password > > authentication > > 2007-11-13 13:48:55 DEBUG: pid 24485: reap_handler called > > 2007-11-13 13:48:55 DEBUG: pid 24485: reap_handler: call wait3 > > 2007-11-13 13:48:55 DEBUG: pid 24485: child 25848 exits with status 11 > by > > signal 11 > > 2007-11-13 13:48:55 DEBUG: pid 26148: I am 26148 > > 2007-11-13 13:48:55 DEBUG: pid 24485: fork a new child pid 26148 > > 2007-11-13 13:48:55 DEBUG: pid 24485: reap_handler: normally exited > > > > > > > > 2007/11/14, Yoshiyuki Asaba <[EMAIL PROTECTED]>: > > > > > > Hi, > > > > > > From: "Oleg Laktionov" <[EMAIL PROTECTED]> > > > Subject: Re: [Pgpool-general] pgpool-ii health checking > > > Date: Tue, 13 Nov 2007 14:40:44 +0300 > > > > > > > Pgpool successfully realized the failure... > > > > > > > > Further I start the Postgresql server on the node tmpwc ... > > > > > > > > 2007-11-13 13:44:04 DEBUG: pid 25879: I am 25879 > > > > 2007-11-13 13:44:14 LOG: pid 24485: starting health checking > > > > 2007-11-13 13:44:14 DEBUG: pid 24485: health_check: 0 the DB node > > > status: 2 > > > > 2007-11-13 13:44:14 DEBUG: pid 24485: health_check: 1 the DB node > > > status: 2 > > > > 2007-11-13 13:44:14 DEBUG: pid 24485: health_check: 2 the DB node > > > status: 3 > > > > 2007-11-13 13:44:24 LOG: pid 24485: starting health checking > > > > 2007-11-13 13:44:24 DEBUG: pid 24485: health_check: 0 the DB node > > > status: 2 > > > > 2007-11-13 13:44:24 DEBUG: pid 24485: health_check: 1 the DB node > > > status: 2 > > > > 2007-11-13 13:44:24 DEBUG: pid 24485: health_check: 2 the DB node > > > status: 3 > > > > > > > > Nevertheless pgpoll does not see this event... Ordinary connection > to > > > the > > > > tmpwc works fine... > > > > > > You need to perform pcp_attach_node command. pgpool do not reattach a > > > node in health checking. > > > > > > > > > > And I have some more question. Can I disable failover mode for the > > > pgpool? > > > > For example I wish to use only replica.test.sportbox.ru as the > master > > > node. > > > > Is it possible anyhow? > > > > > > No, if a master node is down, pgpool determines a new master node. > > > > > > -- > > > Yoshiyuki Asaba > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > 2007/11/13, Yoshiyuki Asaba <[EMAIL PROTECTED]>: > > > > > > > > > > Hi, > > > > > > > > > > From: "Oleg Laktionov" < [EMAIL PROTECTED]> > > > > > Subject: Re: [Pgpool-general] pgpool-ii health checking > > > > > Date: Mon, 12 Nov 2007 10:37:06 +0300 > > > > > > > > > > > I use pgpool-ii-1.3. > > > > > > > > > > Hmm... I can't reproduce it. > > > > > Could you show us pgpool's error log? > > > > > > > > > > Regards, > > > > > -- > > > > > Yoshiyuki Asaba > > > > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > 2007/11/12, Yoshiyuki Asaba < [EMAIL PROTECTED] >: > > > > > > > > > > > > > > Hi, > > > > > > > > > > > > > > From: "Oleg Laktionov" < [EMAIL PROTECTED]> > > > > > > > Subject: [Pgpool-general] pgpool-ii health checking > > > > > > > Date: Fri, 9 Nov 2007 16:19:43 +0300 > > > > > > > > > > > > > > > About pgpool-ii... > > > > > > > > Can anybody explain me the mechanism of performing backend > > > health > > > > > > > checking? > > > > > > > > Pgpool-ii successfully understands that some of the backends > is > > > > > down. > > > > > > > > Nevertheless when some of the backends is online again, > pgpool > > > does > > > > > not > > > > > > > see > > > > > > > > this event. > > > > > > > > Only restart of the pgpool-ii helps... > > > > > > > > > > > > > > Which version do you use? > > > > > > > > > > > > > > -- > > > > > > > Yoshiyuki Asaba > > > > > > > [EMAIL PROTECTED] > > > > > > > _______________________________________________ > > > > > > > Pgpool-general mailing list > > > > > > > [email protected] > > > > > > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > > best regards, > > > > > > Oleg Laktionov > > > > > > > > > > > > > > > > > > > > > -- > > > > best regards, > > > > Oleg Laktionov > > > _______________________________________________ > > > Pgpool-general mailing list > > > [email protected] > > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > > > > > > > > > > -- > > best regards, > > Oleg Laktionov > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general > -- best regards, Oleg Laktionov
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
