Magento Expert Forum - Improve your Magento experience

Results 1 to 2 of 2

[Solved] MySQL: Error while sending QUERY packet. PID=XXX” with Magento 2 Migration

  1. #1
    Junior Member
    Join Date
    Jun 2016
    Location
    Bhavnagar, Gujarat, India
    Posts
    1,125
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Default [Solved] MySQL: Error while sending QUERY packet. PID=XXX” with Magento 2 Migration

    As you all know Magento 1 has come to an end in June 2020. So, most of the E-commerce businesses have been migrated to Magento 2. If you are not a developer person you can seamlessly migrate your Magento store at Magento Migration Service. In the migration process, one needs to transfer the data to the database. While transferring, the session time out limit might not be exceeded which can be the cause of receiving MySQL: Error while sending QUERY Packet. Perhaps, the other reason for the error could be the data being bulky for large businesses.

    Name:  Error-MySQL-Error-while-sending-QUERY.png
Views: 12
Size:  259.0 KB

    Hence, the solution for it is right here. I have mentioned two ways: one is by changing the code and another is by increasing the value of memory size and execution time to resolve the error. Let’s execute it 🚀

    Steps to solve the error “MySQL: Error while sending QUERY Packet. PID=XXX in Magento Migration:

    The first way is to change the code.

    Step 1: First of all, go to the following path:

    vendor\magento\data-migration-tool\etc\opensource-to-opensource\1.9.X.X\config.xml

    Read All Steps At : https://magecomp.com/blog/solved-mys...o-2-migration/

    View more threads in the same category:


  2. #2
    Junior Member
    Join Date
    Nov 2019
    Posts
    1,083
    Thanks
    6
    Thanked 3 Times in 3 Posts

    Default

    Helpful post! Thanks for sharing.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •