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 > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
