[pgpool-general: 3155] pgpool-II not load balancing

[Manuel Mendoza]

Hi everyone,

 

I have hell of a headache configuring pgpool, i hope you can help me.

 

Let me add a little bit of context:

2 DB servers(DB1 and DB2) and 2 web tomcat servers (WEB1 and WEB2)

DB1 is master and DB2 is slave with replication.

Replication is working fine.

WEB1 and WEB2 both have pgpool installed and each tomcat connects to its own
local pgpool. 
pgpool is configured with the two backends, WD, load balance and
master-slave in stream mode.

 

Ok, now the problem:

While testing pgpool configuration, I launched some easy queries(select 1)
to WEB1's pgpool in order to test the load balancing.

Pgpool shows the following log

 

2014-09-09 03:47:00 LOG:   pid 22005: connection received: host=[local]

2014-09-09 03:47:00 LOG:   pid 22005: statement: select 1

2014-09-09 03:47:00 LOG:   pid 22005: DB node id: 0 backend pid: 5228
statement: select 1

2014-09-09 03:47:07 LOG:   pid 22021: connection received: host=[local]

2014-09-09 03:47:07 LOG:   pid 22021: statement: select 1

2014-09-09 03:47:07 LOG:   pid 22021: DB node id: 1 backend pid: 35193
statement: select 1

2014-09-09 03:47:15 LOG:   pid 22017: connection received: host=[local]

2014-09-09 03:47:15 LOG:   pid 22017: statement: select 1

2014-09-09 03:47:15 LOG:   pid 22017: DB node id: 0 backend pid: 5231
statement: select 1

2014-09-09 03:47:20 LOG:   pid 22016: connection received: host=[local]

2014-09-09 03:47:20 LOG:   pid 22016: statement: select 1

2014-09-09 03:47:20 LOG:   pid 22016: DB node id: 0 backend pid: 5232
statement: select 1

2014-09-09 03:47:27 LOG:   pid 22012: connection received: host=[local]

2014-09-09 03:47:27 LOG:   pid 22012: statement: select 1

2014-09-09 03:47:27 LOG:   pid 22012: DB node id: 1 backend pid: 35196
statement: select 1

 

Everything seems to be working, some queries goes to DB1 and others to DB2,
but in postgres log I see the following:

 

2014-09-09 10:47:00 CEST [35192]: [1-1] LOG:  connection received:
host=172.24.32.105 port=59021

2014-09-09 10:47:00 CEST [35192]: [2-1] LOG:  connection authorized:
user=postgres database=postgres

2014-09-09 10:47:00 CEST [35192]: [3-1] LOG:  disconnection: session time:
0:00:00.032 user=postgres database=postgres host=172.24.32.105 port=59021

2014-09-09 10:47:07 CEST [35193]: [1-1] LOG:  connection received:
host=172.24.32.105 port=59024

2014-09-09 10:47:07 CEST [35193]: [2-1] LOG:  connection authorized:
user=postgres database=postgres

2014-09-09 10:47:07 CEST [35193]: [3-1] LOG:  disconnection: session time:
0:00:00.008 user=postgres database=postgres host=172.24.32.105 port=59024

2014-09-09 10:47:15 CEST [35194]: [1-1] LOG:  connection received:
host=172.24.32.105 port=59026

2014-09-09 10:47:15 CEST [35194]: [2-1] LOG:  connection authorized:
user=postgres database=postgres

2014-09-09 10:47:15 CEST [35194]: [3-1] LOG:  disconnection: session time:
0:00:00.008 user=postgres database=postgres host=172.24.32.105 port=59026

2014-09-09 10:47:20 CEST [35195]: [1-1] LOG:  connection received:
host=172.24.32.105 port=59028

2014-09-09 10:47:20 CEST [35195]: [2-1] LOG:  connection authorized:
user=postgres database=postgres

2014-09-09 10:47:20 CEST [35195]: [3-1] LOG:  disconnection: session time:
0:00:00.006 user=postgres database=postgres host=172.24.32.105 port=59028

2014-09-09 10:47:27 CEST [35196]: [1-1] LOG:  connection received:
host=172.24.32.105 port=59030

2014-09-09 10:47:27 CEST [35196]: [2-1] LOG:  connection authorized:
user=postgres database=postgres

2014-09-09 10:47:27 CEST [35196]: [3-1] LOG:  disconnection: session time:
0:00:00.019 user=postgres database=postgres host=172.24.32.105 port=59030

 

Which means that pgpool is not load balancing, is sending all queries to all
DB servers. I have tested many configurations but there is something I am
missing and I cannot find it. Can anyone help me?

 

Thank you very much!

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140911/f977508e/attachment.html>