Mysql wsrep issue
HA Setup with 3 controllers , devices went down due to power outage once devices were backup controller 1 is refusing to join the mysql cluster again , please see error below:
Error on Node-1 ( Controller 1 )
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [Note] WSREP: wsrep_start_
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [Note] WSREP: SST received: 3cec74d0-
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [Note] WSREP: Receiving IST: 40494 writesets, seqnos 11010669-11051163
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [ERROR] Slave SQL: Could not execute Update_rows event on table keystone.token; Can't find record in 'token', Error_code: 1032; handler error HA_ERR_
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [Warning] WSREP: RBR event 2 Update_rows apply warning: 120, 11010671
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [ERROR] WSREP: receiving IST failed, node restart required: Failed to apply app buffer: UxFS, seqno: 11010671, status: WSREP_FATAL
<27>Apr 10 13:22:21 node-1 mysqld: at galera/
<27>Apr 10 13:22:21 node-1 mysqld: at galera/
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [Note] WSREP: Closing send monitor...
<27>Apr 10 13:22:21 node-1 mysqld: 140410 13:22:21 [Note] WSREP: Closed send monitor.
And on Node-2 ( Controller 2 who is the donor ) the following error is shown:
<27>Apr 10 13:22:21 node-2 mysqld: 140410 13:22:21 [ERROR] WSREP: async IST sender failed to serve tcp://10.
<27>Apr 10 13:22:21 node-2 mysqld: at galera/
Has anyone seen this before ?
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Philip Wege
- Solved:
- Last query:
- Last reply: