[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