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.