[Pgpool-general] stuck with error: "secondary data is not ready at synchronous point" [SumsaultRT #3219]
Mark Stosberg
mark at summersault.com
Wed May 24 18:34:31 UTC 2006
On Wed, May 24, 2006 at 06:47:21AM +0900, Tatsuo Ishii wrote:
> > Hello,
> >
> > I'm getting started trying to use pgpool 2.6.3 with PostgreSQL 8.1.3.
> >
> > I already have Slony-I replicating two servers, I have tested that Slony works
> > by running a query on the master, and seeing the result on the slave.
> >
> > I've followed the instructions for using pgpool with Slony-I, and set
> > the values for secondary host, and set true to master_slave_mode and load_balance_mode.
> >
> > I updated my application to talk to port 9999 on the localhost, where pgpool is
> > running.
> >
> > However, I get this error, and then application failure:
> >
> > pid 91373: pool_check_fd: data is not ready tp->tv_sec 5 tp->tp_usec 0
> > pid 91373: pool_process_query: secondary data is not ready at synchronous point. abort this session
> > pid 91373: pool_process_query: kind does not match between backends master(1) secondary()
> >
> > What does that mean? I'm not sure how to get past it.
> >
> > Thanks!
> >
> > Mark
>
> pgpool 2.6.3 is fairly old. Can you grab 3.0.2 and try it out?
Thanks! I hadn't realized I had an old version. Simply upgrading to 3.0.2
fixed the issue!
Mark
More information about the Pgpool-general
mailing list