Help Center> Data Replication Service> User Guide (ME-Abu Dhabi Region)> Troubleshooting> Solutions to Failed Check Items> Database Parameters> Checking Whether the max_allowed_packet Value of the Destination Database Is too Small
Updated on 2023-02-02 GMT+08:00

Checking Whether the max_allowed_packet Value of the Destination Database Is too Small

MySQL

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

Check Item

Whether the max_allowed_packet value of the destination database is too small

Description

A large amount of data cannot be written to the destination database during the migration because the max_allowed_packet value is smaller than 100 MB. As a result, the full migration failed.

Failure Cause and Handling Suggestion

Failure cause: The max_allowed_packet value of the destination database is too small, which may cause data fails to be written during the migration.

Handling suggestions: Set the max_allowed_packet value greater than 100 MB