- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Warning: Error while sending QUERY packet. PID=2210
During a module install you have the option to backup the database. However, when selected I get an error and the backup does not complete:
Warning: Error while sending QUERY packet. PID=2210 in /var/www/magento/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228
On gitbub it was stated to increase the max_allowed_packet in mysql. I went as high as 512M and then stopped as it makes no sense. Perhaps somewhere else? This error also seems to appear during installations, but I have no issues installing Magento with my current settings.
This is an Ubuntu LAMP stack. AWS t-small [2 GB RAM].
If you can explain exactly what is going on here, maybe it can be solved. I saw suggestions of php.ini of max execution. But I don't want to guess. Please advise. Thanks!
A.I
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Warning: Error while sending QUERY packet. PID=2210
Hi there,
did you solve this at the end?
If yes, how you did please? I'm still looking for a solution.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Warning: Error while sending QUERY packet. PID=2210
Hello @aMiSTACX, @carlo_mascella
You can solve this problem by following few steps:
- Open your terminal window
- Please write following command in your termina
ssh root@yourIP port
- Enter root password
- Now edit your server my.cnf file using below command\
nano /etc/my.cnf
if the command is not recognized do this first or try vi then repeat: yum install nano.
ORvi /etc/my.cnf
- Add the line under the [MYSQLD] section. :
max_allowed_packet=524288000 (obviously adjust size for whatever you need) wait_timeout = 100
- Control + O (save) then ENTER (confirm) then Control + X (exit file)
- Then restart your MySQL server by the following command
/etc/init.d/mysql stop /etc/init.d/mysql start
- You can verify by going into PHPMyAdmin or opening a SQL command window and executing:
SHOW VARIABLES LIKE 'max_allowed_packet';
This works for me. I hope it should work for you
--
If my answer is useful, please Accept as Solution & give Kudos
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Warning: Error while sending QUERY packet. PID=2210
Hello,
Yes, this was solved and tested on Ubuntu 16.04 w/ MySQL 5.7.x
Here is the info:
https://amistacx.com/magento-error-while-sending-query-packet/
Good to go!
AMIS
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Re: Warning: Error while sending QUERY packet. PID=2210
Hello,
thanks for sharing.
Actually I guess my hosting provider don't give me permission to change that values.
I'm actually looking with them how to upgrade service.
Thakks by the way.
C.