Error instaling magento 2.2

[grandechefe]

Hi

I have a problem in instal magento 2.2. I have this error:

Exception: Warning: Error while sending QUERY packet

the installation stops at the 66% wtiith this log:

Module 'Magento_ConfigurableSampleData':
Installing data... 
[ERROR] Exception: Warning: Error while sending QUERY packet. PID=26444 in /home/pedro/web/grandechefe.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 in /home/pedro/web/grandechefe.com/public_html/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'Error while sen...', '/home/pedro/web...', 228, Array)
#1 /home/pedro/web/grandechefe.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#2 /home/pedro/web/grandechefe.com/public_html/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array)
#3 /home/pedro/web/grandechefe.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /home/pedro/web/grandechefe.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /home/pedro/web/grandechefe.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `setup_m...', Array)
#6 /home/pedro/web/grandechefe.com/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `setup_m...', Array)
#7 /home/pedro/web/grandechefe.com/public_html/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(580): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('UPDATE `setup_m...', Array)
#8 /home/pedro/web/grandechefe.com/public_html/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(635): Magento\Framework\DB\Adapter\Pdo\Mysql->query('UPDATE `setup_m...', Array)
#9 /home/pedro/web/grandechefe.com/public_html/vendor/magento/framework/Module/ModuleResource.php(131): Zend_Db_Adapter_Abstract->update('setup_module', Array, '(module = 'Mage...')
#10 /home/pedro/web/grandechefe.com/public_html/setup/src/Magento/Setup/Model/Installer.php(877): Magento\Framework\Module\ModuleResource->setDataVersion('Magento_Configu...', '2.0.0')
#11 /home/pedro/web/grandechefe.com/public_html/setup/src/Magento/Setup/Model/Installer.php(791): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data')
#12 [internal function]: Magento\Setup\Model\Installer->installDataFixtures()
#13 /home/pedro/web/grandechefe.com/public_html/setup/src/Magento/Setup/Model/Installer.php(342): call_user_func_array(Array, Array)
#14 /home/pedro/web/grandechefe.com/public_html/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#15 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#16 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#17 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#20 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-mvc/src/DispatchListener.php(118): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#21 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#22 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#23 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-eventmanager/src/EventManager.php(263): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /home/pedro/web/grandechefe.com/public_html/vendor/zendframework/zend-mvc/src/Application.php(340): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#25 /home/pedro/web/grandechefe.com/public_html/setup/index.php(35): Zend\Mvc\Application->run()
#26 {main}

can you help?

Hosting:

4GB Ram

2 CPU

Ubuntu 16.04.1

PHP 7

Mysql 5.7.21

Pedro

[kalyanchakri]

Hi @grandechefe,

Can you please try increasing the values of below parameters

memory_limit
max_execution_time

max_allowed_packet

I think in your case increasing max_allowed_packet alone itself solve your issue. Please check this link for more information on how to set that value.

http://devdocs.magento.com/guides/v2.2/install-gde/prereq/mysql.html

--------
Give Kudos if it helped and Accept it as solution

[grandechefe]

Hi

I have this:

max_allowed_packet = 512M

max_execution_time = 18000

memory_limit = 2048M

[kalyanchakri]

Values are fine. It should work with those values.

anyway please try increasing the value of "max_allowed_packet" a little more and see if it works.

--------
Give Kudos if it helped and Accept it as solution

[grandechefe]

Hi

I just increase the value to max_allowed_packet = 1024M and the error continues.

Pedro

[kalyanchakri]

Did you restart MySQL service after increasing it?

[grandechefe]

Hi

Yes i do

Pedro

[grandechefe]

Hi

There is some special configuration, permissions for the installation?

Pedro

[kalyanchakri]

Not sure about it.

Did you try through CLI ?