magento / magento/data-migration-tool

Error while sending QUERY packet

Open
#831 5 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PHP
Stars
339
Forks
195
PR merge metrics
No merged PRs in 30d

Description

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.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.