Bug 1025204 - Missing InnoDB engine for mysql after migration
Summary: Missing InnoDB engine for mysql after migration
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: OpenShift Online
Classification: Red Hat
Component: Containers
Version: 2.x
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: ---
Assignee: Dan McPherson
QA Contact: libra bugs
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-31 08:57 UTC by Meng Bo
Modified: 2015-05-14 23:32 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-24 03:28:06 UTC
Target Upstream Version:


Attachments (Terms of Use)

Description Meng Bo 2013-10-31 08:57:37 UTC
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>):

Comment 1 Dan McPherson 2013-10-31 14:18:28 UTC
https://github.com/openshift/origin-server/pull/4062

Comment 3 Meng Bo 2013-11-01 06:40:23 UTC
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.


Note You need to log in before you can comment on or make changes to this bug.