sqlalchemy: migration error when running db-sync
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Ceilometer |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
using mysql,
1) create database ceilometer;
2) run ./bin/ceilomete
i get the following error on last migration:
2013-05-31 10:45:19.619 9409 CRITICAL ceilometer [-] (OperationalError) (1005, "Can't create table 'ceilometer.event' (errno: 150)") '\nCREATE TABLE event (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tgenerated FLOAT, \n\tunique_name_id INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(unique_name_id) REFERENCES unique_name (id)\n)\n\n' ()
2013-05-31 10:45:19.619 9409 TRACE ceilometer Traceback (most recent call last):
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "./bin/
2013-05-31 10:45:19.619 9409 TRACE ceilometer storage.
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/opt/stack/
2013-05-31 10:45:19.619 9409 TRACE ceilometer migration.
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/opt/stack/
2013-05-31 10:45:19.619 9409 TRACE ceilometer return versioning_
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/lib/
2013-05-31 10:45:19.619 9409 TRACE ceilometer return _migrate(url, repository, version, upgrade=True, err=err, **opts)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "<string>", line 2, in _migrate
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/opt/stack/
2013-05-31 10:45:19.619 9409 TRACE ceilometer return f(*a, **kw)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/lib/
2013-05-31 10:45:19.619 9409 TRACE ceilometer schema.
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/lib/
2013-05-31 10:45:19.619 9409 TRACE ceilometer change.
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/lib/
2013-05-31 10:45:19.619 9409 TRACE ceilometer script_func(engine)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/opt/stack/
2013-05-31 10:45:19.619 9409 TRACE ceilometer i.create()
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer checkfirst=
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer conn._run_
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer **kwargs)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer return meth(obj, **kw)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer self.connection
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer params)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer compiled
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer context)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer context)
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/local/
2013-05-31 10:45:19.619 9409 TRACE ceilometer cursor.
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/lib/
2013-05-31 10:45:19.619 9409 TRACE ceilometer self.errorhandl
2013-05-31 10:45:19.619 9409 TRACE ceilometer File "/usr/lib/
2013-05-31 10:45:19.619 9409 TRACE ceilometer raise errorclass, errorvalue
2013-05-31 10:45:19.619 9409 TRACE ceilometer OperationalError: (OperationalError) (1005, "Can't create table 'ceilometer.event' (errno: 150)") '\nCREATE TABLE event (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tgenerated FLOAT, \n\tunique_name_id INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(unique_name_id) REFERENCES unique_name (id)\n)\n\n' ()
description: | updated |
Changed in ceilometer: | |
milestone: | none → havana-2 |
status: | Fix Committed → Fix Released |
Changed in ceilometer: | |
milestone: | havana-2 → 2013.2 |
Reviewed: https:/ /review. openstack. org/31545 github. com/openstack/ ceilometer/ commit/ 99702d47667245d 62a6868608789a0 4b4a84f66b
Committed: http://
Submitter: Jenkins
Branch: master
commit 99702d47667245d 62a6868608789a0 4b4a84f66b
Author: Gordon Chung <email address hidden>
Date: Mon Jun 3 14:49:38 2013 -0400
sqlalchemy: migration error when running db-sync
migration incorrectly sorted order of tables for Events causing Event
and Trait tables to be generated before unique_name table which both tables
require
Change-Id: I6fe7ceb0905ace 3993116c6a274b6 c39e11554bf
Fixes:Bug #1186283