[Pgpool-general] Idle in transaction after node recovery
Hadadi Péter
peter at bigfish.hu
Mon Feb 28 16:21:44 UTC 2011
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
More information about the Pgpool-general
mailing list