Innodb Cluster.status showing group replication failed

[Sunil Potluri]

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.