mysql Archives - latcoding.com

How to solve MySQL 5.7 replication: Error ‘Duplicate entry ‘31222217’ for key ‘PRIMARY” on query.

Posted on August 11, 2023 by Ambar Hasbiyatmoko

Replication: Error duplicate entry for key PRIMARY on query. Default database: ‘mydb’. Query: ‘INSERT INTO tb_order … Sometimes your replication will get error because of network problem, storage full or RAM full. One of the errors is: Duplicate entry for… Continue Reading →

How to solve MySQL 5.7 replication error: Relay log read failure: Could not parse relay log event entry

Posted on August 8, 2023 by Ambar Hasbiyatmoko

MySQL 5.7 – Relay log read failure: Could not parse relay log event entry. Error: Yesterday, my replication (mysql 5.7) was getting error, i run show slave status; on the slave and getting a response as below: Relay log read… Continue Reading →