Warning: Error while sending QUERY packet. PID=2210

[aMiSTACX]

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

[carlo_mascella]

Hi there,

did you solve this at the end?

If yes, how you did please? I'm still looking for a solution.

Thanks

[gelanivishal]

Hello @aMiSTACX, @carlo_mascella

You can solve this problem by following few steps:

1. Open your terminal window
2. Please write following command in your termina
   

   ssh root@yourIP port

3. Enter root password
4. 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.
   OR
   

   vi /etc/my.cnf

5. Add the line under the [MYSQLD] section. :
   

   max_allowed_packet=524288000 (obviously adjust size for whatever you need) 
   wait_timeout = 100

6. Control + O (save) then ENTER (confirm) then Control + X (exit file)
7. Then restart your MySQL server by the following command
   

   /etc/init.d/mysql stop
   /etc/init.d/mysql start

8. 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

[aMiSTACX]

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

[carlo_mascella]

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.