[Pgpool-general] Idle in transaction after node recovery

[Toshihiro Kitagawa]

Hi Péter,

Thank you for your cooperation.

I found a bug in handling of /*NO LOAD BALANCE*/ comment.
I've attached a patch. Can you please try it?

Regards,

--
Toshihiro Kitagawa
SRA OSS, Inc. Japan

On Fri, 04 Mar 2011 09:40:55 +0100
"Hadadi Péter" <peter at bigfish.hu> wrote:

> Hi Toshihiro,
> 
> configuration and log files attached.
> 
> Problem starts here:
> 
> 2011-03-04 09:18:04 LOG: pid 27470: statement: BEGIN
> 
> Thanks,
> 
> Peter
> 
> On 3/3/11 6:50 AM, Toshihiro Kitagawa wrote:
> > 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
> >>
> > 
> 
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: no_load_balance.patch
Type: application/octet-stream
Size: 641 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110307/b51b3d44/attachment.obj>