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
View PDF
Share

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
Parent topic: Database Parameters