Error while sending QUERY packet

[kevinpandora]

Preconditions

1. Running data-migration-tool locally using MAMP on a Mac
2. Migrating from v1.8.1.0 to v2.3.5

Steps to reproduce

1. Running the data-migration-tool to transfer data over
2. Reach the following step: [2020-06-23 21:57:27][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: started [2020-06-23 21:57:27][INFO][mode: data][stage: data migration][step: Map Step]: started 50% [==============>-------------] Remaining Time: < 1 sec In ErrorHandler.php line 61: Warning: Error while sending QUERY packet. PID=89869 in /XXXXXXXXXXXX/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php on line 182
3. Increased the max_allowed_packed multiple times with same result.

Expected result

1. Successfully completing / transferring

Actual result

1. As mentioned above, receive the Error while sending QUERY packet error each time. Despite changing the SQL settings, it continues to give error. Wondering if there are other settings that should be increased for this error or if there is a limit on size from the database that would be an issue. The source database is quite large.

Additional notes

Current settings in my.cnf increased to: key_buffer_size = 768M max_allowed_packet = 15360M table_open_cache = 256

Any insight in to what we can try would be greatly appreciated! Thank you.

[m2-assistant[bot]]

Hi @kevinpandora. Thank you for your report. To help us process this issue please make sure that you provided sufficient information.

Please, add a comment to assign the issue: @magento I am working on this

---

• Join Magento Community Engineering Slack and ask your questions in #github channel.

[m2-assistant[bot]]

Hi @kevinpandora! :wave: Thank you for collaboration. Only members of Community Contributors Team are allowed to be assigned to the issue. Please use @magento add to contributors team command to join Contributors team.

[carlos-reynosa]

I'm also getting this error

[carlos-reynosa]

@kevinpandora did you ever find a solution?

[eBusinessAtlantique]

I solved this by changing config.xml file with <bulk_size>100</bulk_size> <direct_document_copy>1</direct_document_copy>