QUERY packet error

having run php app/console oro:install --env prod everything seems to install and when installation finishes
I get the message:

Oro Application has been successfully installed in prod mode. Please run oro:api:doc:cache:clear command to warm-up API documentation cache

1 2	Oro Application has been successfully installed in prod mode. Please run oro:api:doc:cache:clear command to warm-up API documentation cache

followed by

PHP Warning: Error while sending QUERY packet. PID=3297 in /home/XXXXX/XXXXXXXXX.com/public_html/vendor/doctrine/dbal/lib /Doctrine/DBAL/Driver/PDOStatement.php on line 91

1 2 3

PHP Warning:  Error while sending QUERY packet. PID=3297 in /home/XXXXX/XXXXXXXXX.com/public_html/vendor/doctrine/dbal/lib /Doctrine/DBAL/Driver/PDOStatement.php on line 91

How do I now resolve this?

Topic

[MichaelKeymaster]

Check the max_allowed_packet setting on you MySQL server and increase it if necessary (64 MB is probably the reasonable default nowadays, so set it to 64 MB if it is currently less than that).

MySQL

SHOW VARIABLES LIKE 'max_allowed_packet';

1	SHOW VARIABLES LIKE 'max_allowed_packet';

Also, if your MySQL is running on a separate machine, make sure there are no network connectivity issues, as this error can also be result of loosing connection to MySQL.

[artelcreativeParticipant]

Thanks. I’d already increased max_allowed_packet so was surprised to see the error again. However, simply re-running the install command seems to have fixed this as there were no errors second time around.

[Author]

Replies