View Issue Details

IDProjectCategoryView StatusLast Update
0000513Pgpool-IIBugpublic2019-07-02 09:45
ReportervanAssigned Topengbo 
PriorityhighSeverityminorReproducibilityalways
Status resolvedResolutionopen 
Product Version4.0.2 
Target VersionFixed in Version 
Summary0000513: pgpool showing primary node down even if it is UP.
DescriptionHi i am running pgpool in streaming replication mode with load balancing (master_slave_mode = on, master_slave_sub_mode = 'stream')
with one primary and one replica node

Stop the primary node
 node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change
---------+-----------------------------------------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
 0 | statefulset-primary.default.svc.cluster.local | 5432 | down | 0.500000 | primary | 0 | false | 0 | 2019-05-19 17:16:31
 1 | statefulset-replica.default.svc.cluster.local | 5432 | up | 0.500000 | standby | 0 | true | 0 | 2019-05-19 17:16:18



After starting the primary node , still i am getting same output

 node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change
---------+-----------------------------------------------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
 0 | statefulset-primary.default.svc.cluster.local | 5432 | down | 0.500000 | primary | 0 | false | 0 | 2019-05-19 17:16:31
 1 | statefulset-replica.default.svc.cluster.local | 5432 | up | 0.500000 | standby | 0 | true | 0 | 2019-05-19 17:16:18




2019-05-19 17:18:03: pid 418: DEBUG: do_query: extended:0 query:"SELECT pg_is_in_recovery()"
2019-05-19 17:18:03: pid 418: DEBUG: pool_write: to backend: 1 kind:Q
2019-05-19 17:18:03: pid 418: DEBUG: pool_flush_it: flush size: 32
2019-05-19 17:18:03: pid 418: DEBUG: pool_read: read 75 bytes from backend 1
2019-05-19 17:18:03: pid 418: DEBUG: do_query: kind: 'T'
2019-05-19 17:18:03: pid 418: DEBUG: do_query: received ROW DESCRIPTION ('T')
2019-05-19 17:18:03: pid 418: DEBUG: do_query: row description: num_fileds: 1
2019-05-19 17:18:03: pid 418: DEBUG: do_query: kind: 'D'
2019-05-19 17:18:03: pid 418: DEBUG: do_query: received DATA ROW ('D')
2019-05-19 17:18:03: pid 418: DEBUG: do_query: kind: 'C'
2019-05-19 17:18:03: pid 418: DEBUG: do_query: received COMMAND COMPLETE ('C')
2019-05-19 17:18:03: pid 418: DEBUG: do_query: kind: 'Z'
2019-05-19 17:18:03: pid 418: DEBUG: do_query: received READY FOR QUERY ('Z')
2019-05-19 17:18:03: pid 418: DEBUG: verify_backend_node_status: there's no primary node
2019-05-19 17:18:03: pid 418: DEBUG: node status[0]: 0
2019-05-19 17:18:03: pid 418: DEBUG: node status[1]: 2




TagsNo tags attached.

Activities

van

2019-05-20 02:24

reporter  

pgpool.conf (40,124 bytes)

van

2019-05-20 02:26

reporter  

pool_hba.conf (3,240 bytes)

pengbo

2019-05-21 09:09

developer   ~0002606

Could you try to restart pgpool with -D option to discard status file?

van

2019-05-21 15:59

reporter   ~0002614

Hi pengbo,

I tried with following command:
pgpool -D -n -a configs/pool_hba.conf -f configs/pgpool.conf

Still I am getting the error with db node restart
2019-05-21 12:28:06: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:28:06: pid 15058: DEBUG: node status[0]: 0
2019-05-21 12:28:16: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:28:16: pid 15058: DEBUG: node status[0]: 0
2019-05-21 12:28:26: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:28:26: pid 15058: DEBUG: node status[0]: 0
2019-05-21 12:28:36: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:28:36: pid 15058: DEBUG: node status[0]: 0
2019-05-21 12:28:46: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:28:46: pid 15058: DEBUG: node status[0]: 0
2019-05-21 12:28:56: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:28:56: pid 15058: DEBUG: node status[0]: 0
2019-05-21 12:29:06: pid 15058: DEBUG: verify_backend_node_status: there's no primary node
2019-05-21 12:29:06: pid 15058: DEBUG: node status[0]: 0

pengbo

2019-05-21 17:00

developer   ~0002620

Last edited: 2019-05-21 17:00

View 2 revisions

Are the 2 backend nodes in streaming replication?

Connect to the primary node, try to run the command below. Could you show me the result?

===
=# select * from pg_stat_replication;
===

Is pgpool not running in the same server with PostgreSQL backend, becuase I found you set the same port with PostgreSQL.

pengbo

2019-07-01 09:23

developer   ~0002684

If you have resolved this issue, may I close this issue or mark this as "Resolved"?

van

2019-07-01 19:24

reporter   ~0002685

Hi pengbo,

Please resolve it. Thanks

Issue History

Date Modified Username Field Change
2019-05-20 02:24 van New Issue
2019-05-20 02:24 van File Added: pgpool.conf
2019-05-20 02:26 van File Added: pool_hba.conf
2019-05-21 09:09 pengbo Note Added: 0002606
2019-05-21 11:01 administrator Assigned To => pengbo
2019-05-21 11:01 administrator Status new => assigned
2019-05-21 11:01 administrator Description Updated View Revisions
2019-05-21 14:20 pengbo Status assigned => feedback
2019-05-21 15:59 van Note Added: 0002614
2019-05-21 15:59 van Status feedback => assigned
2019-05-21 17:00 pengbo Note Added: 0002620
2019-05-21 17:00 pengbo Note Edited: 0002620 View Revisions
2019-05-21 17:00 pengbo Status assigned => feedback
2019-07-01 09:23 pengbo Note Added: 0002684
2019-07-01 19:24 van Note Added: 0002685
2019-07-01 19:24 van Status feedback => assigned
2019-07-02 09:45 pengbo Status assigned => resolved