[Pgpool-general] Idle in transaction after node recovery

[Toshihiro Kitagawa]

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" <peter at bigfish.hu> 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
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>