I am running percona xtradb cluster 8.0. One of my nodes went down, when I try to bring it up. The log says the transfer is complete and joined.
0.0 (DB404): State transfer from 3.0 (DB403) complete.
[Galera] Shifting JOINER -> JOINED (TO: 799642)
However looking at the wsrep_local_state_comment status says joining. The wsrep_cluster_size has 5 which is the total amount including the bad node. Also showing all incoming ip addresses as well. wsrep_ready is off but I am guessing that is because it is still joining.
The log file also fills up with
[InnoDB] Page cleaner took 11974ms to flush 474 pages
And the node never fully joins the cluster. When I try to query I get WSREP has not yet prepared node for application use Any advice would be appreciated.