| Summary: | Missing InnoDB engine for mysql after migration | ||
|---|---|---|---|
| Product: | OpenShift Online | Reporter: | Meng Bo <bmeng> |
| Component: | Containers | Assignee: | Dan McPherson <dmcphers> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | libra bugs <libra-bugs> |
| Severity: | high | Docs Contact: | |
| Priority: | high | ||
| Version: | 2.x | CC: | dmcphers |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2014-01-24 03:28:06 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
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. |
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>):