[Pgpool-general] stuck with error: "secondary data is not ready at synchronous point" [SumsaultRT #3219]

Mark Stosberg mark at summersault.com
Tue May 23 19:01:49 UTC 2006


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


More information about the Pgpool-general mailing list