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

Michael Ulitskiy mulitskiy at acedsl.com
Tue Jan 24 17:28:39 GMT 2006


Thanks a lot. Now my simple test works.
Could you please comment on David Boreham message?
Is the same modification is needed on line 273 of pool_process_query.c?

Michael

On Tuesday 24 January 2006 08:33 am, Tatsuo Ishii wrote:
> > 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