View Issue Details

IDProjectCategoryView StatusLast Update
0000506Pgpool-IIIncompatible changepublic2019-05-17 09:51
Reporterpio01 Assigned To 
PriorityurgentSeveritymajorReproducibilityhave not tried
Status closedResolutionopen 
Product Version3.7.3 
Summary0000506: FATAL: pgpool is not accepting any new connections
DescriptionHi

Could you please help me what about this error? I need to added again the node with pcp_attach_nodes?
I have always restart the service and delete file in /tmp/ directory.

May 1 03:22:54 host01 pgpool[11148]: [38-1] 2019-05-01 03:22:54: pid 11148: FATAL: pgpool is not accepting any new connections
May 1 03:22:54 host01 pgpool[11148]: [38-2] 2019-05-01 03:22:54: pid 11148: DETAIL: all backend nodes are down, pgpool requires at least one valid node
May 1 03:22:54 host01 pgpool[11148]: [38-3] 2019-05-01 03:22:54: pid 11148: HINT: repair the backend nodes and restart pgpool
..
..
WARNING: All the DB nodes are in down status and skip writing status file
FATAL: pgpool is not accepting any new connections
TagsNo tags attached.

Activities

pio01

2019-05-01 18:07

reporter   ~0002578

Please, you can find the log file and config file
pgpool.conf (36,216 bytes)
pgpool.log (2,921 bytes)

pio01

2019-05-02 07:09

reporter   ~0002579

I have fix this issues. The problem was the password configuration on both clusters and adapt the pg_hba file.

administrator

2019-05-07 08:34

administrator   ~0002584

Great!
Could you close this issue?

Issue History

Date Modified Username Field Change
2019-05-01 16:56 pio01 New Issue
2019-05-01 18:07 pio01 File Added: pgpool.conf
2019-05-01 18:07 pio01 File Added: pgpool.log
2019-05-01 18:07 pio01 Note Added: 0002578
2019-05-02 07:09 pio01 Note Added: 0002579
2019-05-07 08:34 administrator Note Added: 0002584
2019-05-07 08:42 administrator Status new => resolved
2019-05-17 09:51 administrator Status resolved => closed