MySQL error in file: /engine/modules/iComm/show.php at line 45

Error Number: 1213

The Error returned was:
WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction

SQL query:

SELECT c.post_id, c.date, c.user_id, c.is_register, c.text, c.autor, c.email, c.approve, p.id, p.date as newsdate, p.title, p.category, p.comm_num, p.alt_name, u.foto, u.user_group, u.user_id FROM dle_comments c LEFT JOIN dle_post p ON(p.id=c.post_id) LEFT JOIN dle_users u ON(u.user_id=c.user_id) WHERE c.approve=1 ORDER BY c.date DESC LIMIT 0, 9