Hi Péter, Thank you for your cooperation.
I found a bug in handling of /*NO LOAD BALANCE*/ comment. I've attached a patch. Can you please try it? Regards, -- Toshihiro Kitagawa SRA OSS, Inc. Japan On Fri, 04 Mar 2011 09:40:55 +0100 "Hadadi Péter" <[email protected]> wrote: > Hi Toshihiro, > > configuration and log files attached. > > Problem starts here: > > 2011-03-04 09:18:04 LOG: pid 27470: statement: BEGIN > > Thanks, > > Peter > > On 3/3/11 6:50 AM, Toshihiro Kitagawa wrote: > > Hi Péter, > > > > I could not reproduce your problem. Can you send pgpool.conf and > > debugging mode pgpool logs that contain the stuck state for investigation? > > If log file size is large, send me it please. > > > > Regards, > > > > -- > > Toshihiro Kitagawa > > SRA OSS, Inc. Japan > > > > On Mon, 28 Feb 2011 17:21:44 +0100 > > "Hadadi Péter" <[email protected]> wrote: > > > >> Hi, > >> > >> I'm testing pgpool 3.0.3 with two database nodes (PostgreSQL 9.0.3) in > >> master/slave (streaming replication) mode. > >> Failover and failback works well (master node "dies" -> slave node became > >> primary) but after recovery of original master node first BEGIN query > >> stuck in server > >> meanwhile other SELECT queries run seamlessly. > >> > >> Restarting pgpool and/or database nodes didn't solve the problem the only > >> way is to shut down the slave server (which acts as a primary node) > >> and do a recovery process after failover. > >> > >> Any idea why it is happen? > >> > >> System use PDO connections with PHP 5.2.6. > >> > >> Thanks, > >> > >> Peter > >> > >> > >> _______________________________________________ > >> Pgpool-general mailing list > >> [email protected] > >> http://pgfoundry.org/mailman/listinfo/pgpool-general > >> > > > >
no_load_balance.patch
Description: Binary data
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
