cancel
Showing results for 
Search instead for 
Did you mean: 

Install errors

SOLVED

Install errors

Hi

 

Is this familiar to anybody. Its about halfway through, about the 50% mark, and seems to have created the tables

 

 

Installing data...
Data install/update:
Module 'Magento_Store':
Upgrading data... 

Module 'Magento_Directory':
Installing data... Upgrading data... 

 

 

Red from here down 

[ERROR] Exception: Warning: Error while sending QUERY packet. PID=1955 in /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228 in /home/Web/devel/vendor/magento/framework/App/ErrorHandler.php:61
Stack trace:
#0 [internal function]: Magento\Framework\App\ErrorHandler->handler(2, 'Error while sen...', '/home/Web/devel...', 228, Array)
#1 /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#2 /home/Web/devel/vendor/magento/framework/DB/Statement/Pdo/Mysql.php(93): Zend_Db_Statement_Pdo->_execute(Array)
#3 /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#4 /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#5 /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('UPDATE `setup_m...', Array)
#6 /home/Web/devel/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(517): Zend_Db_Adapter_Pdo_Abstract->query('UPDATE `setup_m...', Array)
#7 /home/Web/devel/vendor/magento/framework/DB/Adapter/Pdo/Mysql.php(580): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('UPDATE `setup_m...', Array)
#8 /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(635): Magento\Framework\DB\Adapter\Pdo\Mysql->query('UPDATE `setup_m...', Array)
#9 /home/Web/devel/vendor/magento/framework/Module/ModuleResource.php(131): Zend_Db_Adapter_Abstract->update('setup_module', Array, '(module = 'Mage...')
#10 /home/Web/devel/setup/src/Magento/Setup/Model/Installer.php(877): Magento\Framework\Module\ModuleResource->setDataVersion('Magento_Directo...', '2.0.1')
#11 /home/Web/devel/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/Web/devel/setup/src/Magento/Setup/Model/Installer.php(342): call_user_func_array(Array, Array)
#14 /home/Web/devel/setup/src/Magento/Setup/Controller/Install.php(109): Magento\Setup\Model\Installer->install(Array)
#15 /home/Web/devel/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(84): Magento\Setup\Controller\Install->startAction()
#16 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#17 /home/Web/devel/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#18 /home/Web/devel/vendor/zendframework/zend-eventmanager/src/EventManager.php(260): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /home/Web/devel/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#20 /home/Web/devel/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/Web/devel/vendor/zendframework/zend-eventmanager/src/EventManager.php(490): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#23 /home/Web/devel/vendor/zendframework/zend-eventmanager/src/EventManager.php(260): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /home/Web/devel/vendor/zendframework/zend-mvc/src/Application.php(340): Zend\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Zend\Mvc\MvcEvent))
#25 /home/Web/devel/setup/index.php(35): Zend\Mvc\Application->run()
#26 {main}

 

 

 

 

Thank You

Cheers, Neil

 

 

** Dell Optiplex 9010, Intel Core I5, 16GB Memory, Centos 7.4 **
** PHP 7.1.16, MariaDB 10.1.11 **
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Install errors

@CCaway - Yes might be issue with maria DB configuration settings.

 

So last option would be open your mariadb config file(my.cnf) - increase wait_timeout = 10 to wait_timeout=180

 

this 180 will be work for you.

 

Refer this link -  https://stackoverflow.com/questions/41398490/mariadb-error-while-sending-query-packet-not-max-allowe...

 

 

if issue solved,Click Kudos & Accept as Solution

View solution in original post

26 REPLIES 26

Re: Install errors

Yes its because of execution timeout issue , kindly do below configuration in php.ini file

 

In your php.ini file configuration should be like below :

 

max_execution_time = 18000

max_input_time = 18000

memory_limit = 1024M

 

Fore More details refer below link : 

 

http://devdocs.magento.com/guides/v2.0/install-gde/prereq/apache.html

 

http://devdocs.magento.com/guides/v2.0/install-gde/system-requirements.html

if issue solved,Click Kudos & Accept as Solution

Re: Install errors

Thanks for your reply Dave

 

I have reset the time outs, I had already set timezone, memory(2G) and other bits according to the documentation, unfortunatly, it made no difference to the outcome.  I also then updated timeouts to 36000, still no good.

 

I checked that PHP conformed, that is all good, the machine installed by default with MariaDB 5.56 (Via VestaCP), so I upgraded and that upgrade, by default is MariaDB 10.1.11 (is this an issue?) 

 

I have only been using the default /etc/php.ini file

 

In a nutshell it is falling over at exactly the same place.

 

Thanks again

 

Cheers, Neil

 

 

** Dell Optiplex 9010, Intel Core I5, 16GB Memory, Centos 7.4 **
** PHP 7.1.16, MariaDB 10.1.11 **

Re: Install errors

Have you check php extension mod_version and mod_rewrite is available or not. Both extension required for Setup Magento 2.

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: Install errors

@CCaway - Okay i understand !!

 

You have issue with your Database configuration settings. as you are getting pId (Error while sending QUERY packet. PID=1955) error.

 

so you need to increase max_allowed_packet value from your database configuration.

 

change max_allowed_packet = 16M or at least max_allowed_packet  = 64M

 

Also you need to check that all the required modules are enabled or not - here is the technology stack php module required for Magento 2 Install - https://devdocs.magento.com/guides/v2.2/install-gde/system-requirements-tech.html

 

Hope it helps , let me know here if issue still not resolved.

 

 

if issue solved,Click Kudos & Accept as Solution

Re: Install errors

Hi Rakesh

 

Thay are available

 

Configured on the virtualhost as below

 

    <Directory /home/Web/devel>
        AllowOverride All
        Options +Includes -Indexes +ExecCGI
        php_admin_value open_basedir none
        php_admin_value upload_tmp_dir /home/web/tmp
        php_admin_value session.save_path /home/web/tmp
    </Directory>

or is there a problem here?

Cheers, Neil

 

 

** Dell Optiplex 9010, Intel Core I5, 16GB Memory, Centos 7.4 **
** PHP 7.1.16, MariaDB 10.1.11 **

Re: Install errors

Hi Dave

 

max_allowed_packet was set to 32M I have now set it to 64 has made now difference.

 

Technology Stack as below and confirmed with phpinfo

PHP Extensions Check
You meet 20 out of 20 PHP extensions requirements. Hide detail

PHP Extension curl.
PHP Extension dom.
PHP Extension iconv.
PHP Extension mcrypt.
PHP Extension simplexml.
PHP Extension spl.
PHP Extension xsl.
PHP Extension intl.
PHP Extension mbstring.
PHP Extension ctype.
PHP Extension hash.
PHP Extension openssl.
PHP Extension pdo_mysql.
PHP Extension soap.
PHP Extension zip.
PHP Extension phar.
PHP Extension xmlwriter.
PHP Extension libxml.
PHP Extension pcre.
PHP Extension gd.

 LOL, frustrating

 

Cheers, Neil

** Dell Optiplex 9010, Intel Core I5, 16GB Memory, Centos 7.4 **
** PHP 7.1.16, MariaDB 10.1.11 **

Re: Install errors

Hello @CCaway

 

If you are facing too much issue then install magento using ssh

 

php -d memory_limit=5G  bin/magento setup:install --base-url=http://127.0.0.1/magento2/ --db-host=localhost --db-name=magento --db-user=magento --db-password=magento --admin-firstname=Magento --admin-lastname=User --admin-email=user@example.com --admin-user=admin --admin-password=admin123 --language=en_US --currency=USD --timezone=America/Chicago --use-rewrites=1

 

 


Problem solved? Click Kudos & Accept as Solution!
Sunil Patel
Magento 2 Certified Professional Developer & Frontend Developer

Re: Install errors

@CCaway  - I understand, You have issue related to configuration side only , something is still missed out.

 

can you increase php memory_limit to 2048M ? put  this  memory_limit = 2048M in your php.ini file.

 

Also after that remove database again - restart the server - and try to install it again and then let me know issue is still remaining or not. 

if issue solved,Click Kudos & Accept as Solution

Re: Install errors

 @Sunil Patel 

 

Hi Sunil

 

Thank you, however it run but only to the same point of error

 

[Exception]
Warning: Error while sending QUERY packet. PID=20418 in /home/Web/devel/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php on line 228

 

Perplexing

 

Cheers, Neil

 

** Dell Optiplex 9010, Intel Core I5, 16GB Memory, Centos 7.4 **
** PHP 7.1.16, MariaDB 10.1.11 **