magento / magento/data-migration-tool
Error while sending QUERY packet
Open
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 339
- Forks
- 195
- PR merge metrics
- No merged PRs in 30d
Description
Preconditions
- Running data-migration-tool locally using MAMP on a Mac
- Migrating from v1.8.1.0 to v2.3.5
Steps to reproduce
- Running the data-migration-tool to transfer data over
- 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 - Increased the max_allowed_packed multiple times with same result.
Expected result
- Successfully completing / transferring
Actual result
- 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.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the migration from v1.8.1.0 to v2.3.5 with the data-migration-tool, then inspect ErrorHandler.php line 61 and vendor/magento/data-migration-tool/src/Migration/ResourceModel/Adapter/Mysql.php line 182. Confirm the relevant MySQL limit or failure condition and verify that the migration completes without the QUERY packet error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100