[pgpool-general: 5297] show pool_nodes showing select_cnt 0 for standby

[Rolan Yadlin]

Hi,

we are using load_balance_mode = on, yet, in some of our setups the
pgpool_nodes is showing the select_cnt is very unbalanced.

an example from one of the setups:

 node_id |   hostname    | port | status | lb_weight |  role   | select_cnt
| load_balance_node | replication_delay
---------+---------------+------+--------+-----------+---------+------------+-------------------+-------------------
 0       | 172.18.255.41 | 5432 | up     | 0.500000  | primary | 8235100
 | false             | 0
 1       | 172.18.255.42 | 5432 | up     | 0.500000  | standby | 0
 | true              | 0

*pgstat output:*
Node: 0
Host: 172.18.255.41
Port: 5432
Weight: 0.500000
Status: Up, in pool and connected (2)
Role: Master

Node: 1
Host: 172.18.255.42
Port: 5432
Weight: 0.500000
Status: Up, in pool and connected (2)
Role: Slave
Replication lag: 0 bytes

*Configuration*:
#------------------------------------------------------------------------------
# LOAD BALANCING MODE
#------------------------------------------------------------------------------

load_balance_mode = on
                                   # Activate load balancing mode
                                   # (change requires restart)
ignore_leading_white_space = on
                                   # Ignore leading white spaces of each
query
white_function_list = 'get_oid_values'
                                   # Comma separated list of function names
                                   # that don't write to database
                                   # Regexp are accepted
black_function_list = ''
                                   # Comma separated list of function names
                                   # that write to database
                                   # Regexp are accepted

database_redirect_preference_list = ''
                                                                   # comma
separated list of pairs of database and node id.
                                                                   #
example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
                                                                   # valid
for streaming replicaton mode only.

app_name_redirect_preference_list = ''
                                                                   # comma
separated list of pairs of app name and node id.
                                                                   #
example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
                                                                   # valid
for streaming replicaton mode only.
allow_sql_comments = off
                                                                   # if on,
ignore SQL comments when judging if load balance or
                                                                   # query
cache is possible.
                                                                   # If
off, SQL comments effectively prevent the judgment
                                                                   # (pre
3.4 behavior).

# - Streaming -

sr_check_period = 10
                                   # Streaming replication check period
                                   # Disabled (0) by default
....
delay_threshold = 200000
                                   # Threshold before not dispatching query
to standby node
                                   # Unit is in bytes
                                   # Disabled (0) by default



we have tries reloading with "allow_sql_comments = on" and "delay_threshold
= 0"

what could it be?

Thanks in advance,
Rolan.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170205/61881129/attachment.html>