Help Center/ Relational Database Service/ Troubleshooting/ RDS for MySQL/ SQL Issues/ ERROR [1412] Reported by an RDS for MySQL DB Instance
Updated on 2022-09-21 GMT+08:00
View PDF

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

Scenario

The following error information 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.

Parent topic: SQL Issues