Help Center/ Data Replication Service/ User Guide (Ankara Region)/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Whether the max_allowed_packet Value of the Source Database Is Too Small
Updated on 2024-04-11 GMT+08:00

Whether the max_allowed_packet Value of the Source Database Is Too Small

MySQL Serving as the Source

Table 1 Checking whether the max_allowed_packet value of the source database is too small

Check Item

Whether the max_allowed_packet value of the source database is too small

Description

If the max_allowed_packet value of the source database is too small, data migration may fail.

Item to Be Confirmed and Handling Suggestion

Potential problem: If there is a lot of data to be migrated or there are too many fields to be migrated, and the max_allowed_packet value of the source database is too small, then the migration task may fail.

Handling suggestion: Change the max_allowed_packet value of the source database to a value greater than 16777216.