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!

답변 없음

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인