[Pgpool-general] About deadlocks

Pablo Milano pm-pgpool at datatransfer.com.ar
Wed Aug 10 21:38:38 GMT 2005


Hello,

I have been using pgpool without problems, but yesterday I started having a
strange behaviour. After about 400 transactions against a replicated
database, pgpool enters degenerated mode with the following error:

pgpool: 2005-08-10 12:49:27 ERROR: pid 14588: pool_check_fd: data is not
ready tp->tv_sec 15 tp->tp_usec 15000000
pgpool: 2005-08-10 12:49:27 ERROR: pid 14588: pool_process_query: secondary
data is not ready at synchronous point. abort this session
pgpool: 2005-08-10 12:49:27 ERROR: pid 14588: pool_process_query: kind does
not match between backends master(T) secondary(

I was using replication_strict in "false". Because of this error, I tried
increasing the timeout but same thing happened. I then tried changing
replication_strict to "true" and it seems to work fine.

I've read in the documentation that setting replication_strict to "false"
could lead to deadlocks, but I can't understand clearly what kind of
deadlock may happen. Could anyone give a "clarifying" example for me?.
Is the error log I posted caused by a deadlock?. I'm a bit confused.

Thanks in advance



More information about the Pgpool-general mailing list