View Revisions: Issue #435

Summary 0000435: Unexpected movement on load balancing (master slave mode)
Revision 2018-10-17 09:45 by t-ishii
Description First, I'm not for sure that It's a bug of pgpool,
but just I want you to give us any advice to investigate the root cause of this situation.
because It seems related with master slave mode and load balancing function of pgpool.
We are currently using pgpool(3.0.3) & PostgreSQL (9.0.18, 1 master & 1 slave)
and faced a unexpected trouble on upgrading the version of pgpool(to 3.7.5) and postgreSQL(to 9.6.10, 1 master & 1 slave).

I attached the log and current setting of pgpool.conf.

It looks similar with a old (but seems fixed) bug.
http://lists.pgfoundry.org/pipermail/pgpool-hackers/2010-May/000311.html

And This doesn't happen in Local test env (pgpool(to 3.7.5) and postgreSQL(9.6.9, 1 master & 1 slave). It's very mysterious.
Could you give me any advice on this situation?
Revision 2018-10-12 11:40 by jgj1018
Description First, I'm not for sure that It's a bug of pgpool,
but just I want you to give us any advice to investigate the root cause of this situation.
because It seems related with master slave mode and load balancing function of pgpool.
We are currently using pgpool(3.0.3) & PostgreSQL (9.0.18, 1 master & 1 slave)
and faced a unexpected trouble on upgrading the version of pgpool(to 3.7.5) and postgreSQL(to 9.6.10, 1 master & 1 slave).

I attached the log and current setting of pgpool.conf.

It looks similar with a old (but seems fixed) bug.
http://lists.pgfoundry.org/pipermail/pgpool-hackers/2010-May/000311.html

And This doesn't happen in Local test env (pgpool(to 3.7.5) and postgreSQL(9.6.9, 1 master & 1 slave). It's very mysterious.
Could you give me any advice on this situation?