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 [email protected] 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" <[email protected]> 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" <[email protected]> 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 >>>> [email protected] >>>> http://pgfoundry.org/mailman/listinfo/pgpool-general >>>> >>> >> >> _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
