View Issue Details

IDProjectCategoryView StatusLast Update
0000831Pgpool-IIBugpublic2024-03-12 15:19
ReporterJai Assigned To 
PriorityurgentSeveritycrashReproducibilityhave not tried
Status newResolutionopen 
Product Version4.2.16 
Summary0000831: Getting "unable to read data from DB node 0" when new primary attached to pgpool after failover
DescriptionHi ,

We are facing below errors after promoting standby to primary and old primary became standby. Please suggest how can it be fixed.

2024-03-10 04:53:22: pid 13678: ERROR: unable to read data from DB node 0
2024-03-10 04:53:22: pid 13678: DETAIL: pool_check_fd call failed with error "Success"
2024-03-10 04:53:33: pid 13271: LOG: child process with pid: 13722 exits with status 256
2024-03-10 04:53:33: pid 13271: LOG: fork a new child process with pid: 24185
2024-03-10 04:53:35: pid 13786: LOG: forked new pcp worker, pid=24206 socket=7
2024-03-10 04:53:35: pid 13786: LOG: PCP process with pid: 24206 exit with SUCCESS.
2024-03-10 04:53:35: pid 13786: LOG: PCP process with pid: 24206 exits with status 0
2024-03-10 04:54:00: pid 13786: LOG: forked new pcp worker, pid=24564 socket=7
2024-03-10 04:54:00: pid 13786: LOG: PCP process with pid: 24564 exit with SUCCESS.
2024-03-10 04:54:00: pid 13786: LOG: PCP process with pid: 2

In pgpool service status below messages are appearing in the process list

─ 6453 pgpool:10.0.10.15(58205) DISCARD
   ├─ 6454 pgpool 10.0.20.16(51879) DISCARD
   ├─ 6455 pgpool:10.0.10.16(62758) DISCARD
           
TagsNo tags attached.

Activities

pengbo

2024-03-12 15:19

developer   ~0004502

Users are encouraged to ask general questions on mailing list "pgpool-general@pgpool.net".
Could you send your question to mailing list?

Issue History

Date Modified Username Field Change
2024-03-11 19:59 Jai New Issue
2024-03-12 15:19 pengbo Note Added: 0004502