MySQL Forums
Forum List  »  InnoDB clusters

Innodb Cluster.status showing group replication failed
Posted by: Sunil Potluri
Date: July 18, 2023 04:36AM

Dear Team,

We have Mysql Innodb cluster with group replication of 3 nodes. After a code deployment in applicaiton reaplication stopped and current cluster status is showing below error.

Version is 8.0.32.

cluster.status();
{
"clusterName": "pr_cls",
"clusterRole": "PRIMARY",
"defaultReplicaSet": {
"name": "default",
"primary": "node2p:1543",
"ssl": "REQUIRED",
"status": "OK_NO_TOLERANCE_PARTIAL",
"statusText": "Cluster is NOT tolerant to any failures. 2 members are not active.",
"topology": {
"node1p:1543": {
"address": "node1p:1543",
"instanceErrors": [
"ERROR: applier thread of Group Replication Applier channel stopped with an error: Worker 1 failed executing transaction 'e3a79e26-f954-11ed-b6c5-0050569602ab:6620'; Error 'This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)' on query. Default database: 'emsigner_prd'. Query: 'CREATE DEFINER=`root`@`localhost` FUNCTION `FGetCustomercompanyCIF`(
P_Workflowid varchar(500)
) RETURNS varchar(750) CHARSET utf8mb4
BEGIN
.
.
.
.
.
RETURN ifnull(V_CompanyCIF,null);
END' (1418) at 2023-07-13 16:25:44.995660",
"ERROR: group_replication has stopped with an error."
],
"memberRole": "SECONDARY",
"memberState": "ERROR",
"mode": "n/a",
"readReplicas": {},
"role": "HA",
"status": "(MISSING)",
"version": "8.0.32"
},

Please let me know how I can fix the replication issue and avoid recurring in future.. if at all, application team wants to run DDL commands.

Options: ReplyQuote


Subject
Views
Written By
Posted
Innodb Cluster.status showing group replication failed
255
July 18, 2023 04:36AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.