Hi everyone and thanks by advance for your sharp advices.
We’ve got a setup of 3 Percona Nodes installed on Ubuntu 10.04-LTS.
Two of the 3 nodes had crashed and now this is impossible to start again the service.
if i type sudo service mysql start, i received ERROR 1047 (08S01) at line 1: Unknown command
While inspecting the log i found this :
140514 15:54:12 [ERROR] Slave SQL: Could not execute Write_rows event on table SWIAT_LIVE_V3.CAR_WS_RESULT; Cannot add or update a child row: a foreign key constraint fails (
CAR_WS_RESULT_FK_1 FOREIGN KEY (
CAR_DETAILS)), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event’s master log FIRST, end_log_pos 190, Error_code: 1452
140514 15:54:12 [Warning] WSREP: RBR event 2 Write_rows apply warning: 151, 8414353
140514 15:54:12 [ERROR] WSREP: receiving IST failed, node restart required: Failed to apply app buffer: seqno: 8414353, status: WSREP_FATAL
sounds a issue with the replication… but sincerly i don’t know how to handle this as long i’m not a DBA.
Any advices are welcome.