After a power outage I am unable to make a node to rejoin the mysql-innodb-cluster. I am attaching the error in the mysql-innodb-cluster/2 node at the end of this message and the current juju status of my cloud in this url: Ubuntu Pastebin
I am not sure how to solve this, maybe reissuing the vault certificates?
ubuntu@juju-5025f7-2-lxd-3:~$ cat /var/log/mysql/error.log 2024-02-07T14:10:57.929310Z 108 [ERROR] [MY-010584] [Repl] Replica SQL for channel ‘group_replication_recovery’: Worker 1 failed executing transaction ‘7d734394-9b3d-11ec-8fec-00163e96d3c5:671171873’ at source log binlog.005060, end_log_pos 24988952; Could not execute Update_rows event on table vault.vault; Can’t find record in ‘vault’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s source log binlog.005060, end_log_pos 24988952, Error_code: MY-001032 2024-02-07T14:10:57.929789Z 107 [ERROR] [MY-010586] [Repl] Error running query, replica SQL thread aborted. Fix the problem, and restart the replica SQL thread with “START REPLICA”. We stopped at log ‘binlog.005060’ position 24987415 2024-02-07T14:10:57.930808Z 27 [ERROR] [MY-011574] [Repl] Plugin group_replication reported: ‘Maximum number of retries when trying to connect to a donor reached. Aborting group replication incremental recovery.’ 2024-02-07T14:10:57.930876Z 27 [ERROR] [MY-011620] [Repl] Plugin group_replication reported: ‘Fatal error during the incremental recovery process of Group Replication. The server will leave the group.’ 2024-02-07T14:10:57.930961Z 27 [ERROR] [MY-011712] [Repl] Plugin group_replication reported: ‘The server was automatically set into read only mode after an error was detected.’ 2024-02-07T14:10:57.931099Z 27 [System] [MY-011565] [Repl] Plugin group_replication reported: ‘Setting super_read_only=ON.’ 2024-02-07T14:11:01.030976Z 0 [System] [MY-011504] [Repl] Plugin group_replication reported: ‘Group membership changed: This member has left the group.’