Hide Forgot
Description of problem: Create any app with mysql cartridge added. Do server upgrade and gear migration. Check the mysql engines. InnoDB cannot be found. mysql> show engines; +------------+---------+-----------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+-----------------------------------------------------------+--------------+------+------------+ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | +------------+---------+-----------------------------------------------------------+--------------+------+------------+ 4 rows in set (0.00 sec) Version-Release number of selected component (if applicable): devenv-stage_532 to devenv_3973 How reproducible: always Steps to Reproduce: 1.Create app with mysql added include drupal and redmine quickstarts. 2.Upgrade the server to devenv_3973 3.Restart broker, mcollective, clean broker cache and pending ops 4.Migrate the datastore rhc-admin-migrate-datastore --version 2.0.35 --compatible 5.Migrate the gears oo-admin-upgrade upgrade-node --version 2.0.35 --ignore-cartridge-version 6.Check the mysql engine after migration finished. > mysql show engines; Actual results: There were 5 engines before upgrade and the InnoDB one was missing after upgrade. Expected results: The InnoDB engine should be present after migration. Additional info: This will cause many quickstarts met error, like drupal and redmine. For drupal: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /var/lib/openshift/52720764755f286e2c000007/app-root/data/downloads/drupal-7.23/includes/lock.inc). For redmine: *** Exception PhusionPassenger::UnknownError in Class (Mysql2::Error: Unknown table engine 'InnoDB': SHOW CREATE TABLE `queries` (ActiveRecord::StatementInvalid)) (process 28225, thread #<Thread:0x00000001716118>):
https://github.com/openshift/origin-server/pull/4062
Commit pushed to master at https://github.com/openshift/origin-server https://github.com/openshift/origin-server/commit/d92e3226f14cb900edbf1986e6ed4a102f9613ba Bug 1025204
Upgrade from devenv-stage_528 to latest stage branch, issue has been fixed. Mysql has InnoDB engine after migration, and quickstart drupal and redmine both work well. mysql> show engines; +------------+---------+------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +------------+---------+------------------------------------------------------------+--------------+------+------------+ | MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO | | CSV | YES | CSV storage engine | NO | NO | NO | | MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | | InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES | | MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO | +------------+---------+------------------------------------------------------------+--------------+------+------------+ 5 rows in set (0.00 sec) Move bug to verified.