Database migrations failing on 077_convert_to_utf8.py
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Fix Released
|
Undecided
|
Adam Gandelman |
Bug Description
On Ubuntu Precise, mysql 5.5.17-4ubuntu6 x86_64, 'nova-manage db sync' results in error:
2012-02-13 13:26:02,905 CRITICAL nova [-] (OperationalError) (1025, "Error on rename of './nova/
(nova): TRACE: Traceback (most recent call last):
(nova): TRACE: File "/usr/bin/
(nova): TRACE: main()
(nova): TRACE: File "/usr/bin/
(nova): TRACE: fn(*fn_args, **fn_kwargs)
(nova): TRACE: File "/usr/bin/
(nova): TRACE: return migration.
(nova): TRACE: File "/usr/lib/
(nova): TRACE: return IMPL.db_
(nova): TRACE: File "/usr/lib/
(nova): TRACE: return versioning_
(nova): TRACE: File "/usr/lib/
(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/
(nova): TRACE: return f(*a, **kw)
(nova): TRACE: File "/usr/lib/
(nova): TRACE: schema.
(nova): TRACE: File "/usr/lib/
(nova): TRACE: change.
(nova): TRACE: File "/usr/lib/
(nova): TRACE: script_func(engine)
(nova): TRACE: File "/usr/lib/
(nova): TRACE: "ALTER TABLE %s CONVERT TO CHARACTER SET utf8" % table)
(nova): TRACE: File "/usr/lib/
(nova): TRACE: return connection.
(nova): TRACE: File "/usr/lib/
(nova): TRACE: params)
(nova): TRACE: File "/usr/lib/
(nova): TRACE: statement, parameters
(nova): TRACE: File "/usr/lib/
(nova): TRACE: context)
(nova): TRACE: File "/usr/lib/
(nova): TRACE: context)
(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:
There have been similar bugs in the past with migrations against mysql servers configured with 'default_
For reference, see: Bug #816236 Bug #916992 Bug #917205
Changed in nova: | |
milestone: | none → essex-4 |
status: | Fix Committed → Fix Released |
Changed in nova: | |
milestone: | essex-4 → 2012.1 |
Adam. I think Hu already filed a bug on this... I fixed it in :
https:/ /review. openstack. org/#change, 3891
We should however pull that fix out into a smaller patch and get this fixed today.