Hello Magento Folks ?,
How are you doing? Welcome to Magento Blog series. Today I will guide you How to Solve Error “MySQL: Error while sending QUERY packet. PID=XXX” in Magento Migration. By any chance, you missed our last published article, take a look at How to Disable Payment Method Programmatically in Magento 2.
Introduction
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.
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
Step 2: Find below tag
<bulk_size>0</bulk_size> <direct_document_copy>0</direct_document_copy>
Step 3: Replace to this
<bulk_size>100</bulk_size> <direct_document_copy>1</direct_document_copy>
The second way is to expand the value of memory size and execution time.
Step 1: Change below value in php.ini
memory_limit = 2048M max_execution_time = 180000
Step 2: Change below value in MySQL file
max_allowed_packet = 504288000 innodb_log_file_size = 3000000 wait_timeout = 4500000
After changing the above value, restart the server.
That’s it.
Final Words:
Therefore, by executing the above steps you will be able to solve the error “MySQL: Error while sending QUERY packet. PID=XXX” in Magento Migration. If you face any trouble write in the comment section below and I will solve it. Share the article with your Magento friends too.
Happy Coding ?