Cette page n'est pas encore disponible dans votre langue. Nous nous efforçons d'ajouter d'autres langues. Nous vous remercions de votre compréhension.

On this page
Help Center/ Relational Database Service/ Troubleshooting/ RDS for MySQL/ SQL Issues/ ERROR [1412] Reported by an RDS for MySQL DB Instance

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

Updated on 2022-09-21 GMT+08:00

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback