[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