cancel
Showing results for 
Search instead for 
Did you mean: 

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

SOLVED

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

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!

2 REPLIES

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

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.

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

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

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!