Help Center/ Relational Database Service/ Troubleshooting/ RDS for MySQL/ SQL Issues/ ERROR [1412] Reported by an RDS for MySQL DB Instance
Updated on 2023-03-06 GMT+08:00

ERROR [1412] Reported by an RDS for MySQL DB Instance

Scenario

The following error is displayed:

ERROR[1412]:Table definition has changed, please retry transaction

This problem may occur in MySQL-5.7.31.2.

Fault Analysis

Cause 1: A transaction is started using START TRANSACTION WITH CONSISTENT SNAPSHOT.

Scenario 1

Scenario 2

Scenario 3

Cause 2: DDL operations are performed for binlog files.

Solution

If the error is caused by any of the preceding causes, the fault needs to be rectified on the service side.