[Pgpool-general] statements hanging after transaction w/ replication_strict on

[Yoshiyuki Asaba]

Hi,

From: "Felix J. Ogris" <fjo-lists at ogris.de>
Subject: [Pgpool-general] statements hanging after transaction w/ replication_strict on
Date: Mon, 15 Oct 2007 15:42:36 +0200

> we have encountered a strange behaviour with replication_strict set to true.
> If we do a SELECT inside a transaction and repeat that statement within the
> same connection, but outside a transaction, then pgpool hangs:

Thanks for the report. Could you apply the attached patch?

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp
-------------- next part --------------
Index: pool_process_query.c
===================================================================
RCS file: /cvsroot/pgpool/pgpool-II/pool_process_query.c,v
retrieving revision 1.23.2.20
diff -c -r1.23.2.20 pool_process_query.c
*** pool_process_query.c	15 Oct 2007 06:51:44 -0000	1.23.2.20
--- pool_process_query.c	16 Oct 2007 02:04:00 -0000
***************
*** 3830,3835 ****
--- 3830,3836 ----
  	backend->slots[0] = slots[selected_slot];
  #endif
  	LOAD_BALANCE_STATUS(backend->info->load_balancing_node) = LOAD_SELECTED;
+ 	selected_slot = backend->info->load_balancing_node;
  
  	/* start load balancing */
  	in_load_balance = 1;