nova db sync failure on precise
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
High
|
Adam Gandelman |
Bug Description
On recent precise, we're seeing a failure of devstack install in 'nova db sync'
2011-12-15 18:39:14,483 INFO migrate.
2011-12-15 18:39:14,504 DEBUG migrate.
2011-12-15 18:39:14,506 CRITICAL nova [-] (OperationalError) (1025, "Error on rename of './nova/
(nova): TRACE: Traceback (most recent call last):
(nova): TRACE: File "/opt/stack/
(nova): TRACE: main()
(nova): TRACE: File "/opt/stack/
(nova): TRACE: fn(*fn_args, **fn_kwargs)
(nova): TRACE: File "/opt/stack/
(nova): TRACE: return migration.
(nova): TRACE: File "/opt/stack/
...
(nova): TRACE: File "/usr/lib/
(nova): TRACE: cursor.
(nova): TRACE: File "/usr/lib/
(nova): TRACE: self.errorhandl
(nova): TRACE: File "/usr/lib/
(nova): TRACE: raise errorclass, errorvalue
(nova): TRACE: OperationalError: (OperationalError) (1025, "Error on rename of './nova/
(nova): TRACE:
Command failed, please check log for more info
This is seen most recently on nova tip of:
commit 8eeb132f80acdf3
Merge: 22040a5 6090313
Author: Jenkins <email address hidden>
Date: Thu Dec 15 18:05:56 2011 +0000
Merge "Updates OVS rules applied to IPv4 VIFs"
Changed in nova: | |
assignee: | nobody → Adam Gandelman (gandelman-a) |
importance: | Undecided → High |
milestone: | none → essex-2 |
status: | New → In Progress |
Changed in nova: | |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | essex-2 → 2012.1 |
This is very similar to Bug #816236 , which was triggered by configuring MySQL to use InnoDB before the initial migrations. This hasn't shown up with Devstack on Oneiric because MySQL 5.2 uses MyISAM as the default. MySQL 5.5/Precise now uses InnoDB out of the box, so the same bug is turning up in migrations like 064_change_ instance_ id_to_uuid_ in_instance_ actions. py. The same fix from bug #816236 can be applied here but I'm not certain it is a fix or a workaround to a problem with earlier migrations (specifically 022_set_ engine_ mysql_innodb. py) or python- migrate/ sqlalchemy.