Install errors

[CCaway]

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

[Manthan Dave]

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

[CCaway]

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

[Rakesh Jesadiya]

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

[Manthan Dave]

@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.

[CCaway]

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

[CCaway]

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

[Sunil Patel]

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

[Manthan Dave]

@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. 

[CCaway]

 @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