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.
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:
Step 2: Find below tag
Step 3: Replace to this
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.
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 ?