Problem with deadlock on AWS RDS MySQL

0

Hello,
We have an issue regarding AWS RDS MySQL.
We have migrated from an AWS EC2 MySQL to RDS MySQL for improving performance, stability and reliability but we are facing a big issue.
After we migrated the databases and started a few php crons that are inserting in MySQL various data(statistics for our application) using INSERT .. ON DUPLICATE KEYS UPDATE we are constantly receiving the following error when the cron is being executed: "Deadlock found when trying to get lock; try restarting transaction
Query: INSERT INTO.."
We are using InnoDB engine.
We have used mysql 5.6.24-log on the EC2 Instance and now on RDS we are using 5.7.21-log.
Parameter group: default.mysql5.7.

Thank you!

Edited by: numanx on Jun 13, 2018 5:29 AM

numanx
preguntada hace 6 años534 visualizaciones
2 Respuestas
0

Hi Numanx,

I am sending you a message now with some more details about your instance.

Cheers,

respondido hace 6 años
0

Was there a solution to it? Facing similar issue.

siimk
respondido hace 5 años

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas