[Pgpool-general] Idle in transaction after node recovery

[Hadadi Péter]

Hi Toshihiro,

the patch solved the problem.

Thanks,

Peter
-- 
Hadadi Péter
fejlesztő
BIG FISH Internet-technológiai Kft.
1016 Budapest, Krisztina körút 87-89.
Tel.: +36 (1) 209-0760
Fax: +36 (1) 799-274
Mobil: +36 (30) 221-0271
http://www.bigfish.hu
peter.hadadi at bigfish.hu

On 3/7/11 11:58 AM, Toshihiro Kitagawa wrote:
> 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
>>>>
>>>
>>
>>