View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000477pgpool-HABugpublic2019-03-22 05:072019-05-21 11:02
Reporterrweiche1 Assigned To 
PriorityhighSeverityblockReproducibilityalways
Status closedResolutionopen 
Summary0000477: backend databases continue to report waiting
DescriptionBoth backend databases continually report waiting:
2019-03-21 13:00:10: pid 37111: DEBUG: Backend DB node 0 status is 1
2019-03-21 13:00:10: pid 37111: DEBUG: Backend DB node 1 status is 1
2019-03-21 13:00:15: pid 37111: DEBUG: Backend DB node 0 status is 1
2019-03-21 13:00:15: pid 37111: DEBUG: Backend DB node 1 status is 1
I can see the connection request from pgpool to the database:
< 2019-03-21 13:01:04.898 PDT > LOG: connection received: host=172.30.75.51 port=48605
< 2019-03-21 13:01:04.899 PDT > LOG: connection authorized: user=postgres database=postgres
< 2019-03-21 13:01:05.065 PDT > LOG: connection received: host=172.30.75.52 port=46560
< 2019-03-21 13:01:05.065 PDT > LOG: connection authorized: user=postgres database=postgres
< 2019-03-21 13:01:05.735 PDT > LOG: connection received: host=172.30.75.50 port=33850
< 2019-03-21 13:01:05.735 PDT > LOG: connection authorized: user=postgres database=postgres
I cannot access the backend databases.

backend_hostname0 = 'nmsp-obmdb1-prod.xypoint.com'
                                   # Host name or IP address to connect to for backend 0
backend_port0 = 5433
                                   # Port number for backend 0
backend_weight0 = 1
                                   # Weight for backend 0 (only in load balancing mode)
backend_data_directory0 = '/var/opt/OV/databases/omidb'
                                   # Data directory for backend 0
backend_flag0 = 'ALLOW_TO_FAILOVER'
                                   # Controls various backend behavior
                                   # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER
backend_hostname1 = 'nmsp-obmdb2-prod.xypoint.com'
backend_port1 = 5433
backend_weight1 = 1
backend_data_directory1 = '/var/opt/OV/databases/omidb'
backend_flag1 = 'ALLOW_TO_FAILOVER'

pgpool version:
pg96-3.6.1-1pgdg.rhel7.x86_64

Postgres version 9.6

TagsNo tags attached.

Activities

hoshiai

2019-03-26 17:36

developer   ~0002462

Sorry, could you submit it again?
because 'project' field is wrong , so I want you to change the 'project' to Pgpool-II instead of pgpool-HA.

Issue History

Date Modified Username Field Change
2019-03-22 05:07 rweiche1 New Issue
2019-03-26 17:36 hoshiai Note Added: 0002462
2019-05-21 11:02 administrator Status new => closed