Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

‎05-29-2016 11:26 AM
‎05-29-2016 11:26 AM

Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

I tried multiple times to install Magento 2.0 on the below Ubuntu system and it fails always at 14% and the mysql server is down afterwards and not able to start.

Must be multiple people with the same problem I tried first with MYSQL 5.6 and afterwards wirh Percona MySql 5.6 same issue.

 

Reinstalled the Ubuntu image nothing changed same issue.

Drives me crazy as I can't

 

No LSB modules are available.
Distributor ID:    Ubuntu
Description:    Ubuntu 14.04.4 LTS
Release:    14.04
Codename:    trusty

 

Module 'Magento_Sales':
Installing schema..
[ERROR] exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:129
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:host=loca...', 'root', 'password', Array)
#1 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(470): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#4 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
#5 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
#6 /var/www/public/app/code/Magento/Sales/Setup/InstallSchema.php(1132): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
#7 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Sales\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
#8 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#9 [internal function]: Magento\Setup\Model\Installer->installSchema()
#10 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#11 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#12 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#13 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#14 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#15 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#16 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#17 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#18 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#19 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#20 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#23 {main}

Next exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(470): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#3 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
#4 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
#5 /var/www/public/app/code/Magento/Sales/Setup/InstallSchema.php(1132): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
#6 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Sales\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
#7 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#8 [internal function]: Magento\Setup\Model\Installer->installSchema()
#9 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#10 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#11 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#12 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#13 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#14 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#15 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#16 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#17 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#18 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#19 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#20 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#22 {main}

0 Kudos
14 REPLIES 14
‎05-29-2016 01:21 PM
‎05-29-2016 01:21 PM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

Hello,

 

Check your MySQL's logs (try /var/log/mysql or somewhere around there)

 

http://stackoverflow.com/questions/5376427/cant-connect-to-local-mysql-server-through-socket-var-mys...

 

 

 

 

Stanislav

0 Kudos
‎05-30-2016 01:54 AM
‎05-30-2016 01:54 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

I changed in my.cnf 127.0.0.1 to localhost, no the MySQL server dont crash but I still stuck on 14% on the installation with below error:

 

Module 'Magento_Sales':
Installing schema..
[ERROR] exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /var/www/public/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#2 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#3 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array)
#5 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array)
#6 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
#7 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
#8 /var/www/public/app/code/Magento/Sales/Setup/InstallSchema.php(1132): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
#9 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Sales\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
#10 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#11 [internal function]: Magento\Setup\Model\Installer->installSchema()
#12 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#13 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#14 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#15 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#16 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#17 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#18 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#19 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#20 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#21 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#22 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#24 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#25 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine, query was: CREATE TABLE IF NOT EXISTS `sales_order_grid` (
`entity_id` int UNSIGNED NOT NULL COMMENT 'Entity Id' ,
`status` varchar(32) NULL COMMENT 'Status' ,
`store_id` smallint UNSIGNED NULL COMMENT 'Store Id' ,
`store_name` varchar(255) NULL COMMENT 'Store Name' ,
`customer_id` int UNSIGNED NULL COMMENT 'Customer Id' ,
`base_grand_total` decimal(12,4) NULL COMMENT 'Base Grand Total' ,
`base_total_paid` decimal(12,4) NULL COMMENT 'Base Total Paid' ,
`grand_total` decimal(12,4) NULL COMMENT 'Grand Total' ,
`total_paid` decimal(12,4) NULL COMMENT 'Total Paid' ,
`increment_id` varchar(50) NULL COMMENT 'Increment Id' ,
`base_currency_code` varchar(3) NULL COMMENT 'Base Currency Code' ,
`order_currency_code` varchar(255) NULL COMMENT 'Order Currency Code' ,
`shipping_name` varchar(255) NULL COMMENT 'Shipping Name' ,
`billing_name` varchar(255) NULL COMMENT 'Billing Name' ,
`created_at` timestamp NULL default NULL COMMENT 'Created At' ,
`updated_at` timestamp NULL default NULL COMMENT 'Updated At' ,
`billing_address` varchar(255) NULL COMMENT 'Billing Address' ,
`shipping_address` varchar(255) NULL COMMENT 'Shipping Address' ,
`shipping_information` varchar(255) NULL COMMENT 'Shipping Method Name' ,
`customer_email` varchar(255) NULL COMMENT 'Customer Email' ,
`customer_group` varchar(255) NULL COMMENT 'Customer Group' ,
`subtotal` decimal(12,4) NULL COMMENT 'Subtotal' ,
`shipping_and_handling` decimal(12,4) NULL COMMENT 'Shipping and handling amount' ,
`customer_name` varchar(255) NULL COMMENT 'Customer Name' ,
`payment_method` varchar(255) NULL COMMENT 'Payment Method' ,
`total_refunded` decimal(12,4) NULL COMMENT 'Total Refunded' ,
PRIMARY KEY (`entity_id`),
INDEX `SALES_ORDER_GRID_STATUS` (`status`),
INDEX `SALES_ORDER_GRID_STORE_ID` (`store_id`),
INDEX `SALES_ORDER_GRID_BASE_GRAND_TOTAL` (`base_grand_total`),
INDEX `SALES_ORDER_GRID_BASE_TOTAL_PAID` (`base_total_paid`),
INDEX `SALES_ORDER_GRID_GRAND_TOTAL` (`grand_total`),
INDEX `SALES_ORDER_GRID_TOTAL_PAID` (`total_paid`),
UNIQUE `SALES_ORDER_GRID_INCREMENT_ID_STORE_ID` (`increment_id`, `store_id`),
INDEX `SALES_ORDER_GRID_SHIPPING_NAME` (`shipping_name`),
INDEX `SALES_ORDER_GRID_BILLING_NAME` (`billing_name`),
INDEX `SALES_ORDER_GRID_CREATED_AT` (`created_at`),
INDEX `SALES_ORDER_GRID_CUSTOMER_ID` (`customer_id`),
INDEX `SALES_ORDER_GRID_UPDATED_AT` (`updated_at`),
FULLTEXT `FTI_65B9E9925EC58F0C7C2E2F6379C233E7` (`increment_id`, `billing_name`, `shipping_name`, `shipping_address`, `billing_address`, `customer_name`, `customer_email`)
) COMMENT='Sales Flat Order Grid' ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /var/www/public/lib/internal/Magento/Framework/DB/Statement/Pdo/Mysql.php(95): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Statement.php(303): Magento\Framework\DB\Statement\Pdo\Mysql->_execute(Array)
#2 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('CREATE TABLE IF...', Array)
#4 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(444): Zend_Db_Adapter_Pdo_Abstract->query('CREATE TABLE IF...', Array)
#5 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
#6 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
#7 /var/www/public/app/code/Magento/Sales/Setup/InstallSchema.php(1132): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
#8 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Sales\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
#9 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#10 [internal function]: Magento\Setup\Model\Installer->installSchema()
#11 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#12 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#13 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#14 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#15 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#16 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#17 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#18 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#19 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#20 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#21 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#23 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#24 {main}

0 Kudos
‎05-30-2016 03:07 AM
‎05-30-2016 03:07 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

Hello,

 

Have you found MySql log ?

 

There should be more description about the error.

 

 

http://stackoverflow.com/questions/9595852/mysql-got-error-1-from-storage-engine-error

 

 

 

Stanislav

0 Kudos
‎05-30-2016 06:11 AM
‎05-30-2016 06:11 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

In the error.log are a lot of error now but I'm not sure if this is now related because the previous install failed.

 

But it always stop at the same point 14% don't understand why this happens with the first install and a clean server Smiley Sad

 

2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Fetch of persistent statistics requested for table "mountains"."admin_passwords" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Fetch of persistent statistics requested for table "mountains"."admin_system_messages" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Fetch of persistent statistics requested for table "mountains"."admin_user" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2016-05-30 15:07:02 7ffd707bb700 InnoDB: Error: Table "mysql"."innodb_table_stats" not found.
2016-05-3

0 Kudos
‎05-30-2016 06:51 AM
‎05-30-2016 06:51 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

Hello,

 

>Table "mysql"."innodb_table_stats" not found.

 

http://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-a...

 

 

 

>In the error.log are a lot of error

 

Delete all errors (make file empty) then try to install.

 

So that you will se only the latest (actual) errors 

 

 

 

Stanislav 

0 Kudos
‎05-30-2016 07:56 AM
‎05-30-2016 07:56 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

Yes, that what I did and I found the same solution as you.

What I don't understand how it could fail so bad with a complete new server setup, is there any information what my.cnf configuration magento 2.0 installation needs to work properly.

0 Kudos
‎05-30-2016 08:08 AM
‎05-30-2016 08:08 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

I did not upgrade from 5.5 I did a fresh install of Server Version: 5.6.30-76.3 - Percona Server (GPL), Release 76.3, Revision 3850db5

0 Kudos
‎05-30-2016 11:41 AM
‎05-30-2016 11:41 AM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

I did the following steps to fix the mysql server:

 

http://dba.stackexchange.com/questions/111616/innodb-error-table-mysql-innodb-table-stats-not-found

http://dba.stackexchange.com/questions/54608/innodb-error-table-mysql-innodb-table-stats-not-found-a...

 

So MySQL started without errors again. But after try to install magento again MySql crashed again and I got the same error as before from the install (can't believe it I was a Magento Fan but this is crap) :

 

Module 'Magento_Sales':
Installing schema..
[ERROR] exception 'PDOException' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:129
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(129): PDO->__construct('mysql:host=loca...', , Array)
#1 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#2 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#3 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(470): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#4 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
#5 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
#6 /var/www/public/app/code/Magento/Sales/Setup/InstallSchema.php(2498): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
#7 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Sales\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
#8 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#9 [internal function]: Magento\Setup\Model\Installer->installSchema()
#10 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#11 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#12 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#13 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#14 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#15 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#16 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#17 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#18 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#19 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#20 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#22 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#23 {main}

Next exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)' in /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php:144
Stack trace:
#0 /var/www/public/vendor/magento/zendframework1/library/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(332): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(470): Magento\Framework\DB\Adapter\Pdo\Mysql->_connect()
#3 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(499): Magento\Framework\DB\Adapter\Pdo\Mysql->_query('CREATE TABLE IF...', Array)
#4 /var/www/public/lib/internal/Magento/Framework/DB/Adapter/Pdo/Mysql.php(1984): Magento\Framework\DB\Adapter\Pdo\Mysql->query('CREATE TABLE IF...')
#5 /var/www/public/app/code/Magento/Sales/Setup/InstallSchema.php(2498): Magento\Framework\DB\Adapter\Pdo\Mysql->createTable(Object(Magento\Framework\DB\Ddl\Table))
#6 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(821): Magento\Sales\Setup\InstallSchema->install(Object(Magento\Setup\Module\Setup), Object(Magento\Setup\Model\ModuleContext))
#7 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(756): Magento\Setup\Model\Installer->handleDBSchemaData(Object(Magento\Setup\Module\Setup), 'schema')
#8 [internal function]: Magento\Setup\Model\Installer->installSchema()
#9 /var/www/public/setup/src/Magento/Setup/Model/Installer.php(333): call_user_func_array(Array, Array)
#10 /var/www/public/setup/src/Magento/Setup/Controller/Install.php(103): Magento\Setup\Model\Installer->install(Array)
#11 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractActionController.php(82): Magento\Setup\Controller\Install->startAction()
#12 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch(Object(Zend\Mvc\MvcEvent))
#13 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#14 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#15 /var/www/public/vendor/zendframework/zend-mvc/src/Controller/AbstractController.php(118): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#16 /var/www/public/vendor/zendframework/zend-mvc/src/DispatchListener.php(93): Zend\Mvc\Controller\AbstractController->dispatch(Object(Zend\Http\PhpEnvironment\Request), Object(Zend\Http\PhpEnvironment\Response))
#17 [internal function]: Zend\Mvc\DispatchListener->onDispatch(Object(Zend\Mvc\MvcEvent))
#18 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(444): call_user_func(Array, Object(Zend\Mvc\MvcEvent))
#19 /var/www/public/vendor/zendframework/zend-eventmanager/src/EventManager.php(205): Zend\EventManager\EventManager->triggerListeners('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#20 /var/www/public/vendor/zendframework/zend-mvc/src/Application.php(314): Zend\EventManager\EventManager->trigger('dispatch', Object(Zend\Mvc\MvcEvent), Object(Closure))
#21 /var/www/public/setup/index.php(31): Zend\Mvc\Application->run()
#22 {main}

 

 

0 Kudos
‎05-30-2016 12:12 PM
‎05-30-2016 12:12 PM

Re: Unbelievable issues with Magento 2.0 installation on Ubuntu 14. MySql fails after install

stupid error I had the wrong URL as the install added automatic /magento

Now I was able to install but afterwards when I selcted go to backend the same issue MySql died:

 

2016-05-30 21:06:33 7ff699b71780  InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2016-05-30 21:06:33 14942 [ERROR] InnoDB: File (unknown): 'read' returned OS error 71. Cannot continue operation
160530 21:06:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
root@s15879145:/var/log/mysql# mysql status
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@s15879145:/var/log/mysql# service mysql status
 * MySQL (Percona Server) is stopped.

0 Kudos