Public bug reported:
After Bug #907878 was resolved, migrations are failing against MySQL +
InnoDB databases on precise:
2012-01-16 00:33:12,574 INFO migrate.versioning.api [-] 63 -> 64...
2012-01-16 00:33:12,643 DEBUG migrate.versioning.util [-] Disposing SQLAlchemy
engine
Engine(mysql://nova:uhrydphlpy8ix...@ip-10-252-37-92.us-west-2.compute.internal/nova)
from (pid=4828) with_engine
/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py:162
Command failed, please check log for more info
2012-01-16 00:33:12,645 CRITICAL nova [-] (OperationalError) (1025, "Error on
rename of './nova/#sql-1115_36' to './nova/instance_actions' (errno: 150)")
'\nALTER TABLE instance_actions DROP COLUMN instance_id' ()
(nova): TRACE: Traceback (most recent call last):
(nova): TRACE: File "/usr/bin/nova-manage", line 2382, in <module>
(nova): TRACE: main()
(nova): TRACE: File "/usr/bin/nova-manage", line 2370, in main
(nova): TRACE: fn(*fn_args, **fn_kwargs)
(nova): TRACE: File "/usr/bin/nova-manage", line 1207, in sync
(nova): TRACE: return migration.db_sync(version)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/nova/db/migration.py",
line 35, in db_sync
(nova): TRACE: return IMPL.db_sync(version=version)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migration.py", line 51, in
db_sync
(nova): TRACE: return versioning_api.upgrade(FLAGS.sql_connection,
repo_path, version)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 186, in
upgrade
(nova): TRACE: return _migrate(url, repository, version, upgrade=True,
err=err, **opts)
(nova): TRACE: File "<string>", line 2, in _migrate
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/versioning/util/__init__.py", line
159, in with_engine
(nova): TRACE: return f(*a, **kw)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/versioning/api.py", line 366, in
_migrate
(nova): TRACE: schema.runchange(ver, change, changeset.step)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/versioning/schema.py", line 91, in
runchange
(nova): TRACE: change.run(self.engine, step)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/versioning/script/py.py", line 145,
in run
(nova): TRACE: script_func(engine)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/nova/db/sqlalchemy/migrate_repo/versions/064_change_instance_id_to_uuid_in_instance_actions.py",
line 52, in upgrade
(nova): TRACE: instance_actions.c.instance_id.drop()
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/changeset/schema.py", line 549, in
drop
(nova): TRACE: engine._run_visitor(visitorcallable, self, connection,
**kwargs)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 2234, in
_run_visitor
(nova): TRACE: conn._run_visitor(visitorcallable, element, **kwargs)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1904, in
_run_visitor
(nova): TRACE: **kwargs).traverse_single(element)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 53, in
traverse_single
(nova): TRACE: ret = super(AlterTableVisitor, self).traverse_single(elem)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/sql/visitors.py", line 86, in
traverse_single
(nova): TRACE: return meth(obj, **kw)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 138, in
visit_column
(nova): TRACE: self.execute()
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/migrate/changeset/ansisql.py", line 42, in
execute
(nova): TRACE: return self.connection.execute(self.buffer.getvalue())
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1405, in
execute
(nova): TRACE: params)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1582, in
_execute_text
(nova): TRACE: statement, parameters
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1646, in
_execute_context
(nova): TRACE: context)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1639, in
_execute_context
(nova): TRACE: context)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 330, in
do_execute
(nova): TRACE: cursor.execute(statement, parameters)
(nova): TRACE: File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py",
line 174, in execute
(nova): TRACE: self.errorhandler(self, exc, value)
(nova): TRACE: File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
(nova): TRACE: raise errorclass, errorvalue
(nova): TRACE: OperationalError: (OperationalError) (1025, "Error on rename of
'./nova/#sql-1115_36' to './nova/instance_actions' (errno: 150)") '\nALTER
TABLE instance_actions DROP COLUMN instance_id' ()
(nova): TRACE:
MySQL 5.5 on Precise has switched from using MyISAM as the default
storage engine to InnoDB. When InnoDB is configured as the default,
migrations need to make sure FK constraints are removed. This seems to
only be an issue on systems that use InnoDB by default first. See Bug
#816236 and Bug #904888 .
** Affects: nova
Importance: Undecided
Assignee: Adam Gandelman (gandelman-a)
Status: In Progress
** Affects: nova (Ubuntu)
Importance: High
Status: New
** Changed in: nova (Ubuntu)
Importance: Undecided => High
** Also affects: nova
Importance: Undecided
Status: New
** Changed in: nova
Status: New => In Progress
** Changed in: nova
Assignee: (unassigned) => Adam Gandelman (gandelman-a)
--
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to nova in Ubuntu.
https://bugs.launchpad.net/bugs/916992
Title:
Database migration v064 fails against MySQL 5.5 + InnoDB
To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/916992/+subscriptions
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
