[pgpool-general: 9089] Re: kind does not match between main(0) slot[0] (52)
Bo Peng
pengbo at sraoss.co.jp
Tue Apr 30 14:43:25 JST 2024
Hi,
> We've noticed a failure in one of our test runs tonight which I can't
> explain. During a reboot test of the nodes in the cluster, one of the
> pgpool instances (the one with ip 172.29.30.2) starts returning the
> following error:
> pid 194: ERROR: unable to read message kind
> pid 194: DETAIL: kind does not match between main(0) slot[0] (52)
The error means the responses from main node and node0 do not match.
I checked the logs and the logs show that node0 is down, but pcp_node_info shows "up".
Could you share your pgpool.conf of all pgpool nodes and
the test scenario?
> Any attempt to establish a connection to this node fails with the error
> above. The other 2 nodes in the cluster are fine. I've attached the log of
> the node and copied the status for the watchdog and backends below. What
> could be causing this error?
>
> Best regards,
> Emond
>
> Watchdog Cluster Information
> Total Nodes : 3
> Remote Nodes : 2
> Member Remote Nodes : 2
> Alive Remote Nodes : 2
> Nodes required for quorum: 2
> Quorum state : QUORUM EXIST
> Local node escalation : NO
> Leader Node Name : 172.29.30.2:5432 Linux 8dd701b3cff8
> Leader Host Name : 172.29.30.2
>
> Watchdog Node Information
> Node Name : 172.29.30.1:5432 Linux bd65977729e4
> Host Name : 172.29.30.1
> Delegate IP : Not_Set
> Pgpool port : 5432
> Watchdog port : 9009
> Node priority : 1
> Status : 7
> Status Name : STANDBY
> Membership Status : MEMBER
>
> Node Name : 172.29.30.2:5432 Linux 8dd701b3cff8
> Host Name : 172.29.30.2
> Delegate IP : Not_Set
> Pgpool port : 5432
> Watchdog port : 9009
> Node priority : 1
> Status : 4
> Status Name : LEADER
> Membership Status : MEMBER
>
> Node Name : 172.29.30.3:5432 Linux 7d75ba5595ed
> Host Name : 172.29.30.3
> Delegate IP : Not_Set
> Pgpool port : 5432
> Watchdog port : 9009
> Node priority : 1
> Status : 7
> Status Name : STANDBY
> Membership Status : MEMBER
>
> Hostname : 172.29.30.1
> Port : 5432
> Status : 2
> Weight : 0.333333
> Status Name : up
> Backend Status Name : up
> Role : standby
> Backend Role : standby
> Replication Delay : 0
> Replication State : streaming
> Replication Sync State : async
> Last Status Change : 2024-04-29 04:29:48
>
>
> Hostname : 172.29.30.2
> Port : 5432
> Status : 2
> Weight : 0.333333
> Status Name : up
> Backend Status Name : up
> Role : primary
> Backend Role : primary
> Replication Delay : 0
> Replication State : none
> Replication Sync State : none
> Last Status Change : 2024-04-29 04:29:48
>
>
> Hostname : 172.29.30.3
> Port : 5432
> Status : 2
> Weight : 0.333333
> Status Name : up
> Backend Status Name : up
> Role : standby
> Backend Role : standby
> Replication Delay : 0
> Replication State : streaming
> Replication Sync State : async
> Last Status Change : 2024-04-29 04:29:48
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/
More information about the pgpool-general
mailing list