I have the following trouble in a percona xtradbcluster node:
2020-03-18T18:45:46.990524Z 87698 [Note] WSREP: Cleaning up wsrep-transaction for local query: call spSMSRuteo (‘1LED’,‘593991133120’)
2020-03-18T18:45:46.990539Z 87698 [Note] WSREP: Assigned new next trx-id (1541199718) to Store-Procedure execution
2020-03-18T18:45:46.990722Z 87698 [Note] WSREP: wsrep: replicating commit (-1)
2020-03-18T18:45:46.990734Z 87698 [Note] WSREP: wsrep: initiating replication for write set (-1)
2020-03-18T18:45:47.974502Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(NON_PRIM,2d697678,483)
memb {
c9eba592,0
}
joined {
}
left {
}
partitioned {
2d697678,0
}
)
2020-03-18T18:45:47.974600Z 0 [Note] WSREP: New COMPONENT: primary = no, bootstrap = no, my_idx = 0, memb_num = 1
2020-03-18T18:45:47.974629Z 0 [Note] WSREP: Flow-control interval: [100, 100]
2020-03-18T18:45:47.974634Z 0 [Note] WSREP: Received NON-PRIMARY.
2020-03-18T18:45:47.974637Z 0 [Note] WSREP: Shifting SYNCED → OPEN (TO: 9411424374)
2020-03-18T18:45:47.974640Z 0 [Note] WSREP: Current view of cluster as seen by this node
view (view_id(NON_PRIM,c9eba592,484)
memb {
c9eba592,0
}
joined {
}
left {
}
partitioned {
2d697678,0
}
)
2020-03-18T18:45:47.974690Z 1 [Note] WSREP: New cluster view: global state: 324ee5bb-5be3-11e7-9ea8-1f02259db6e6:9411424374, view# -1: non-Primary, number of nodes: 1, my index: 0, protocol version 3
2020-03-18T18:45:47.974695Z 87967 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87967 Query: INSERT INTO smsConsultaRuteoLog (Fecha, UserName, Numero, TiempoMS, FechaFin, ProviderID, Destination, Portado, Kind, Value)^M
VALUES(@fechaInicio, @userNameSP, @NumeroSP, @difFecha, @fechaFin, @ProviderID, @Destination, @Portado, @Kind, @Value)
2020-03-18T18:45:47.974720Z 87967 [Note] WSREP: conflict state: NO_CONFLICT
2020-03-18T18:45:47.974727Z 87967 [Note] WSREP: --------- CONFLICT DETECTED --------
2020-03-18T18:45:47.974730Z 87955 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87955 Query: UPDATE routelog SET status=10, outconnector=‘smppin1’, sourceaddrton=‘5’, sourceaddrnpi=‘0’, destaddrton=‘1’, destaddrnpi=‘1’, endtime=‘2020-03-18 12:45:45’, endsecs=1584557145, endmsecs=575, npdus=1, username=‘smsPrem’ WHERE msgid=1000000815766410
2020-03-18T18:45:47.974741Z 87989 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87989 Query: UPDATE routelog SET status=10, outconnector=‘smppin1’, sourceaddrton=‘5’, sourceaddrnpi=‘0’, destaddrton=‘1’, destaddrnpi=‘1’, endtime=‘2020-03-18 12:45:45’, endsecs=1584557145, endmsecs=577, npdus=1, username=‘msbirdprm’ WHERE msgid=1000000815766402
2020-03-18T18:45:47.974764Z 87979 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87979 Query: INSERT INTO smsConsultaRuteoLog (Fecha, UserName, Numero, TiempoMS, FechaFin, ProviderID, Destination, Portado, Kind, Value)^M
VALUES(@fechaInicio, @userNameSP, @NumeroSP, @difFecha, @fechaFin, @ProviderID, @Destination, @Portado, @Kind, @Value)
2020-03-18T18:45:47.974773Z 87694 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87694 Query: INSERT INTO smsConsultaRuteoLog (Fecha, UserName, Numero, TiempoMS, FechaFin, ProviderID, Destination, Portado, Kind, Value)^M
VALUES(@fechaInicio, @userNameSP, @NumeroSP, @difFecha, @fechaFin, @ProviderID, @Destination, @Portado, @Kind, @Value)
2020-03-18T18:45:47.974789Z 87984 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87984 Query: INSERT INTO smsConsultaRuteoLog (Fecha, UserName, Numero, TiempoMS, FechaFin, ProviderID, Destination, Portado, Kind, Value)^M
VALUES(@fechaInicio, @userNameSP, @NumeroSP, @difFecha, @fechaFin, @ProviderID, @Destination, @Portado, @Kind, @Value)
2020-03-18T18:45:47.974801Z 87984 [Note] WSREP: conflict state: NO_CONFLICT
2020-03-18T18:45:47.974748Z 87955 [Note] WSREP: conflict state: NO_CONFLICT
2020-03-18T18:45:47.974815Z 87984 [Note] WSREP: --------- CONFLICT DETECTED --------
2020-03-18T18:45:47.974821Z 87984 [Note] WSREP: cluster conflict due to certification failure for threads:
2020-03-18T18:45:47.974773Z 87989 [Note] WSREP: conflict state: NO_CONFLICT
2020-03-18T18:45:47.974834Z 87665 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87665 Query: UPDATE routelog SET status=10, outconnector=‘smppin1’, sourceaddrton=‘5’, sourceaddrnpi=‘0’, destaddrton=‘1’, destaddrnpi=‘1’, endtime=‘2020-03-18 12:45:46’, endsecs=1584557146, endmsecs=728, npdus=1, username=‘Tyntec1’ WHERE msgid=2000000741724105
2020-03-18T18:45:47.974841Z 87989 [Note] WSREP: --------- CONFLICT DETECTED --------
2020-03-18T18:45:47.974845Z 87699 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 87699 Query: UPDATE emguser SET lastfailedlogin=‘2020-03-18 12:45:46’, lastipstr=‘174.136.36.66’, failedlogins=0, lockeduntil=‘2099-10-25 01:59:59’ WHERE userid=70
2020-03-18T18:45:47.974851Z 87665 [Note] WSREP: conflict state: NO_CONFLICT
2020-03-18T18:45:47.974857Z 87665 [Note] WSREP: --------- CONFLICT DETECTED --------
2020-03-18T18:45:47.974861Z 87665 [Note] WSREP: cluster conflict due to certification failure for threads:
what is the cause for this error?