[pgpool-general: 7659] Re: unable to read data from DB node 0 Errors

[Bo Peng]

Hello,

> Any ideas why we would see these errors in the pgpool output / log?
> 
> 
> 2021-08-05 00:16:08: pid 1752: LOG: find_primary_node_repeatedly: 
> waiting for finding a primary node
> 2021-08-05 00:16:08: pid 1785: DEBUG:  initializing backend status
> 2021-08-05 00:16:08: pid 1752: DEBUG:  authenticate kind = 0
> 2021-08-05 00:16:08: pid 1752: ERROR:  unable to read data from DB node 0
> 2021-08-05 00:16:08: pid 1752: DETAIL:  EOF encountered with backend
> 2021-08-05 00:16:08: pid 1752: LOG:  find_primary_node: 
> make_persistent_db_connection_noerror failed on node 0
> 2021-08-05 00:16:08: pid 1752: DEBUG:  verify_backend_node_status: 
> there's no primary node
> 2021-08-05 00:16:09: pid 1752: DEBUG:  authenticate kind = 0
> 2021-08-05 00:16:09: pid 1752: ERROR:  unable to read data from DB node 0
> 2021-08-05 00:16:09: pid 1752: DETAIL:  EOF encountered with backend
> 2021-08-05 00:16:09: pid 1752: LOG:  find_primary_node: 
> make_persistent_db_connection_noerror failed on node 0
> 2021-08-05 00:16:09: pid 1752: DEBUG:  verify_backend_node_status: 
> there's no primary node
> 2021-08-05 00:16:10: pid 1752: DEBUG:  authenticate kind = 0
> 2021-08-05 00:16:10: pid 1752: ERROR:  unable to read data from DB node 0
> 2021-08-05 00:16:10: pid 1752: DETAIL:  EOF encountered with backend
> 2021-08-05 00:16:10: pid 1752: LOG:  find_primary_node: 
> make_persistent_db_connection_noerror failed on node 0
> 2021-08-05 00:16:10: pid 1752: DEBUG:  verify_backend_node_status: 
> there's no primary node
> 2021-08-05 00:16:11: pid 1752: DEBUG:  authenticate kind = 0
> 2021-08-05 00:16:11: pid 1752: ERROR:  unable to read data from DB node 0
> 2021-08-05 00:16:11: pid 1752: DETAIL:  EOF encountered with backend
> 2021-08-05 00:16:11: pid 1752: LOG:  find_primary_node: 
> make_persistent_db_connection_noerror failed on node 0
> 2021-08-05 00:16:11: pid 1752: DEBUG:  verify_backend_node_status: 
> there's no primary node
> 2021-08-05 00:16:12: pid 1752: DEBUG:  authenticate kind = 0
> 2021-08-05 00:16:12: pid 1752: ERROR:  unable to read data from DB node 0
> 2021-08-05 00:16:12: pid 1752: DETAIL:  EOF encountered with backend

It seems that pgpool can't connect to DB node 0.
Please make sure you can connect to DB node 0 from 
the server where pgpool is running using the information
specified in the following parameters:

  backend_hostname0
  backend_port0
  sr_check_user
  sr_check_password

> 
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
http://www.sraoss.co.jp/