[pgpool-general: 7659] Re: unable to read data from DB node 0 Errors
Bo Peng
pengbo at sraoss.co.jp
Fri Aug 6 12:09:15 JST 2021
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/
More information about the pgpool-general
mailing list