Installation incomplete with Warning: Error while sending QUERY packet. PID=10634 ......

[zhangzlili]

Hello friends!

I was installing magento 2.1.1 CE with sample data using setup wizard. When it ran step 6 installation, at 57%, the installation stopped with the following console log with error message:

......
Module 'Magento_CustomerSampleData':
Installing data...

[ERROR] exception 'Exception' with message 'Warning: Error while sending QUERY packet. PID=10634 in /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228' in /home/posnowz/www/magento2b/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'Error while sen...', '/home/posnowz/w...', 228, Array)
#1 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#2 /home/posnowz/www/magento2b/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#3 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `setup_m...', Array)
#6 /home/posnowz/www/magento2b/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(452): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `setup_m...', Array)
#7 /home/posnowz/www/magento2b/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(507): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('UPDATE `setup_m...', Array)
#8 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(635): Magento\Framework\DB\Adapter\Pdo\Mysql->query('UPDATE `setup_m...', Array)
#9 /home/posnowz/www/magento2b/vendor/magento/framework/Module/ModuleResource.php(129): Zend_Db_Adapter_Abstract->update('setup_module', Array, Array)
#10 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Model/Installer.php(854): Magento\Framework\Module\ModuleResource->setDataVersion('Magento_Custome...', '2.0.0')
#11 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Model/Installer.php(796): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data')
#12 [internal function]: Magento\Setup\Model\Installer->installDataFixtures()
#13 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Model/Installer.php(344): call_user_func_array(Array, Array)
#14 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#15 /home/posnowz/www/magento2b/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/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 /home/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#20 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): 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/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#23 /home/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#25 /home/posnowz/www/magento2b/setup/index.php(31): Zend\Mvc\Application->run()
#26 {main}

Could you please help me out with this?

Thanks!

[Gabriel Guarino · Accepted solution]

Hi @zhangzlili,

Have you reviewed the memory_limit and the max_execution_time?

Please check those values and run the installation process in an empty database again.

[zhangzlili]

Hi Guarino,


I have ajusted memory_limit=1G & max_execution_time=18000 in php.ini then ran the installation in an empty database. And still got an error message as the following:


......
Module 'Magento_Quote':
Installing data...
[ERROR] exception 'Exception' with message 'Warning: PDOStatement::execute(): MySQL server has gone away in /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228' in /home/posnowz/www/magento2b/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'PDOStatement::e...', '/home/posnowz/w...', 228, Array)
#1 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#2 /home/posnowz/www/magento2b/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#3 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SHOW TABLES', Array)
#6 /home/posnowz/www/magento2b/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(452): Zend_Db_Adapter_Pdo_Abstract->query('SHOW TABLES', Array)
#7 /home/posnowz/www/magento2b/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(507): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('SHOW TABLES', Array)
#8 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(794): Magento\Framework\DB\Adapter\Pdo\Mysql->query('SHOW TABLES', Array)
#9 /home/posnowz/www/magento2b/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(129): Zend_Db_Adapter_Abstract->fetchCol('SHOW TABLES')
#10 /home/posnowz/www/magento2b/vendor/magento/module-quote/Setup/QuoteSetup.php(73): Zend_Db_Adapter_Pdo_Mysql->listTables()
#11 /home/posnowz/www/magento2b/vendor/magento/module-quote/Setup/QuoteSetup.php(91): Magento\Quote\Setup\QuoteSetup->_flatTableExist('quote_address')
#12 /home/posnowz/www/magento2b/vendor/magento/module-quote/Setup/InstallData.php(56): Magento\Quote\Setup\QuoteSetup->addAttribute('quote_address', 'vat_request_dat...', Array)
#13 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Model/Installer.php(844): Magento\Quote\Setup\InstallData->install(Object(Magento\Setup\Module\DataSetup), Object(Magento\Setup\Model\ModuleContext))
#14 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Model/Installer.php(796): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\DataSetup), 'data')
#15 [internal function]: Magento\Setup\Model\Installer->installDataFixtures()
#16 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Model/Installer.php(344): call_user_func_array(Array, Array)
#17 /home/posnowz/www/magento2b/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#18 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#19 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 /home/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#21 /home/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#24 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#25 /home/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#26 /home/posnowz/www/magento2b/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#27 /home/posnowz/www/magento2b/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#28 /home/posnowz/www/magento2b/setup/index.php(31): Zend\Mvc\Application->run()
#29 {main}



The magento with sample data was installed on vps with php5.6.23, apache 2.2.15, MySQL 5.6.31, my installation base url: /home/posnowz/www/magento2b/, and real memory 256MB total, 241.08 MB used, virtual memory 512 MB total, 411.35 MB use.




Please help me out with this.
Thank you so much!