# Troubles with Percona Xtradbcluster

**URL:** <https://forums.percona.com/t/troubles-with-percona-xtradbcluster/7477>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 18, 2020, 6:00pm UTC](https://forums.percona.com/t/troubles-with-percona-xtradbcluster/7477 "2020-03-18T18:00:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Iori\_yagami](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/iori_yagami/32/6316_2.png) [@Iori\_yagami](https://forums.percona.com/u/Iori_yagami)\
**Post date:** [March 18, 2020, 6:00pm UTC](https://forums.percona.com/t/troubles-with-percona-xtradbcluster/7477/1 "2020-03-18T18:00:30Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![steven\_Lin](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@steven\_Lin](https://forums.percona.com/u/steven_Lin)\
**Post date:** [March 24, 2020, 3:37am UTC](https://forums.percona.com/t/troubles-with-percona-xtradbcluster/7477/2 "2020-03-24T03:37:21Z")

</div>

You should have at least 3 nodes to be a cluster.

---

<div class="post-metadata">

**Author:** ![steven\_Lin](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@steven\_Lin](https://forums.percona.com/u/steven_Lin)\
**Post date:** [March 24, 2020, 3:39am UTC](https://forums.percona.com/t/troubles-with-percona-xtradbcluster/7477/3 "2020-03-24T03:39:16Z")

</div>

Network issues may cause breaks of node’s communication.