Amazon Aurora 8.0 MYSQL AUTO_INCREMENT sometimes gets out of sync on read and write replicas

0

Some time ago I have posted this:

https://repost.aws/questions/QUPmtTo4DuT2STM21dxD3KBA/amazon-aurora-mysql-auto-increment-sometimes-gets-out-of-sync-on-read-and-write-replicas

The autoincrement was not in sync for some tables on read and write replicas. I was told by our AWS account managers that this was a bug in Aurora mysql version 5. We have upgraded to version 8. Currently we have 8.0.mysql_aurora.3.04.0. The bug was not fixed, or maybe it was fixed and came back again.

Enter image description here

Enter image description here

Because of this I sometimes have errors on inserts. The autoincrement seems to get in sync on database failover.

As you can see in the images, multiple tables have autoincrement out of sync. Amazon AWS please fix this bug!

Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions