Magento2 MySQL Issues

[armindopereira]

Hi,

when using Magento2 backend, i'm running into a lot of timeout errors (from cloudflare and from nginx (when cloudflare is disabled) ).
These timeout errors happen when i'm trying to insert / update a product.

One of those errors are
"Warning: Error while sending QUERY packet. PID=10744 in /home/****/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228"

Can someone help me solve this.

Regards

[Meetanshi]

Hello @armindopereira 

I suggest you contact your hosting provider.

As this issue is related to PHP variable and not Magento.

However, you can check other server issues by using the following link:

https://devdocs.magento.com/guides/v2.3/comp-mgr/module-man/compman-readiness.html

Hope it helps.

[Manish Mittal]

Hello @armindopereira 

You guessed right MySQL have limitation for size of data, you need to break your query in small group of records or you can Change your max_allowed_packet by using SET GLOBAL max_allowed_packet=524288000;

For more ref:

https://stackoverflow.com/questions/30753674/error-while-sending-query-packet