Troubles with Percona Xtradbcluster

Iori_yagamiIori_yagami EntrantActive Member Participant
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?

Comments

  • steven Linsteven Lin Contributor Active Member Contributor
    You should have at least 3 nodes to be a cluster.
  • steven Linsteven Lin Contributor Active Member Contributor
    Network issues may cause breaks of node's communication.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.