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
