[Pgpool-general] is there a way out of degeneration mode

Tatsuo Ishii ishii at sraoss.co.jp
Tue Jan 24 13:33:21 GMT 2006


> Oh, I forgot you are using master/slave mode. In this mode UPDATE
> etc.(DML) will not be sent to slave thus causes problems below.  Let
> me think again how to handle LISTEN/NOTIFY in master/slave mode...

Ok I think I found the cause. Waiting for replies from the secondary
should be only done in replication mode, not by master/slave mode.
Please try following patches.

*** pool_process_query.c	5 Jan 2006 13:08:44 -0000	1.10
--- pool_process_query.c	24 Jan 2006 13:28:14 -0000
***************
*** 315,321 ****
  		}
  
  		/* this is the synchronous point */
! 		if (DUAL_MODE)
  		{
  			if (kind == 0)
  			{
--- 315,321 ----
  		}
  
  		/* this is the synchronous point */
! 		if (REPLICATION)
  		{
  			if (kind == 0)
  			{


--
Tatsuo Ishii
SRA OSS, Inc. Japan


More information about the Pgpool-general mailing list