[Pgpool-general] Idle in transaction after node recovery

[Hadadi Péter]

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: pgpool_pdo_test.zip
Type: application/zip
Size: 39149 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110304/4fd4c966/attachment-0001.zip>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_test.php
Type: text/php
Size: 1329 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110304/4fd4c966/attachment-0001.bin>