$ designate-manage database sync 2014-09-01 17:09:49.793 3723 INFO migrate.versioning.api [designate-manage - - - - -] 0 -> 1... 2014-09-01 17:09:49.955 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:49.956 3723 INFO migrate.versioning.api [designate-manage - - - - -] 1 -> 2... 2014-09-01 17:09:50.201 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.202 3723 INFO migrate.versioning.api [designate-manage - - - - -] 2 -> 3... 2014-09-01 17:09:50.317 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.317 3723 INFO migrate.versioning.api [designate-manage - - - - -] 3 -> 4... 2014-09-01 17:09:50.512 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.513 3723 INFO migrate.versioning.api [designate-manage - - - - -] 4 -> 5... 2014-09-01 17:09:50.601 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.601 3723 INFO migrate.versioning.api [designate-manage - - - - -] 5 -> 6... 2014-09-01 17:09:50.635 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.635 3723 INFO migrate.versioning.api [designate-manage - - - - -] 6 -> 7... 2014-09-01 17:09:50.798 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.798 3723 INFO migrate.versioning.api [designate-manage - - - - -] 7 -> 8... 2014-09-01 17:09:50.898 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.898 3723 INFO migrate.versioning.api [designate-manage - - - - -] 8 -> 9... 2014-09-01 17:09:50.969 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:50.969 3723 INFO migrate.versioning.api [designate-manage - - - - -] 9 -> 10... 2014-09-01 17:09:51.144 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.145 3723 INFO migrate.versioning.api [designate-manage - - - - -] 10 -> 11... 2014-09-01 17:09:51.176 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.177 3723 INFO migrate.versioning.api [designate-manage - - - - -] 11 -> 12... 2014-09-01 17:09:51.271 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.271 3723 INFO migrate.versioning.api [designate-manage - - - - -] 12 -> 13... 2014-09-01 17:09:51.369 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.370 3723 INFO migrate.versioning.api [designate-manage - - - - -] 13 -> 14... 2014-09-01 17:09:51.434 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.435 3723 INFO migrate.versioning.api [designate-manage - - - - -] 14 -> 15... 2014-09-01 17:09:51.695 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.696 3723 INFO migrate.versioning.api [designate-manage - - - - -] 15 -> 16... 2014-09-01 17:09:51.946 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.946 3723 INFO migrate.versioning.api [designate-manage - - - - -] 16 -> 17... 2014-09-01 17:09:51.978 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.979 3723 INFO migrate.versioning.api [designate-manage - - - - -] 17 -> 18... 2014-09-01 17:09:51.988 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:51.988 3723 INFO migrate.versioning.api [designate-manage - - - - -] 18 -> 19... 2014-09-01 17:09:52.004 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:52.005 3723 INFO migrate.versioning.api [designate-manage - - - - -] 19 -> 20... 2014-09-01 17:09:52.181 3723 INFO migrate.versioning.api [designate-manage - - - - -] done 2014-09-01 17:09:52.181 3723 INFO migrate.versioning.api [designate-manage - - - - -] 20 -> 21... 2014-09-01 17:09:52.586 3723 ERROR oslo.db.sqlalchemy.exc_filters [designate-manage - - - - -] DBAPIError exception wrapped from (IntegrityError) (1215, 'Cannot add foreign key constraint') 'ALTER TABLE records ENGINE=InnoDB' () 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters Traceback (most recent call last): 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters context) 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters cursor.execute(statement, parameters) 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters self.errorhandler(self, exc, value) 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters raise errorclass, errorvalue 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters IntegrityError: (1215, 'Cannot add foreign key constraint') 2014-09-01 17:09:52.586 3723 TRACE oslo.db.sqlalchemy.exc_filters 2014-09-01 17:09:52.588 3723 CRITICAL designate [designate-manage - - - - -] DBError: (IntegrityError) (1215, 'Cannot add foreign key constraint') 'ALTER TABLE records ENGINE=InnoDB' () 2014-09-01 17:09:52.588 3723 TRACE designate Traceback (most recent call last): 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/bin/designate-manage", line 10, in 2014-09-01 17:09:52.588 3723 TRACE designate sys.exit(main()) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/designate/cmd/manage.py", line 125, in main 2014-09-01 17:09:52.588 3723 TRACE designate fn(*fn_args) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/designate/manage/database.py", line 51, in sync 2014-09-01 17:09:52.588 3723 TRACE designate get_manager().upgrade(None) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/migration_cli/manager.py", line 44, in upgrade 2014-09-01 17:09:52.588 3723 TRACE designate results.append(plugin.upgrade(revision)) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/migration_cli/ext_migrate.py", line 48, in upgrade 2014-09-01 17:09:52.588 3723 TRACE designate init_version=self.init_version) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/oslo/db/sqlalchemy/migration.py", line 79, in db_sync 2014-09-01 17:09:52.588 3723 TRACE designate return versioning_api.upgrade(engine, repository, version) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 186, in upgrade 2014-09-01 17:09:52.588 3723 TRACE designate return _migrate(url, repository, version, upgrade=True, err=err, **opts) 2014-09-01 17:09:52.588 3723 TRACE designate File "", line 2, in _migrate 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/migrate/versioning/util/__init__.py", line 160, in with_engine 2014-09-01 17:09:52.588 3723 TRACE designate return f(*a, **kw) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/migrate/versioning/api.py", line 366, in _migrate 2014-09-01 17:09:52.588 3723 TRACE designate schema.runchange(ver, change, changeset.step) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/migrate/versioning/schema.py", line 93, in runchange 2014-09-01 17:09:52.588 3723 TRACE designate change.run(self.engine, step) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/migrate/versioning/script/py.py", line 148, in run 2014-09-01 17:09:52.588 3723 TRACE designate script_func(engine) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/designate/storage/impl_sqlalchemy/migrate_repo/versions/021_convert_to_innodb_utf8.py", line 31, in upgrade 2014-09-01 17:09:52.588 3723 TRACE designate "ALTER TABLE %s ENGINE=InnoDB" % table) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1752, in execute 2014-09-01 17:09:52.588 3723 TRACE designate return connection.execute(statement, *multiparams, **params) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 721, in execute 2014-09-01 17:09:52.588 3723 TRACE designate return self._execute_text(object, multiparams, params) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 870, in _execute_text 2014-09-01 17:09:52.588 3723 TRACE designate statement, parameters 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 958, in _execute_context 2014-09-01 17:09:52.588 3723 TRACE designate context) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1156, in _handle_dbapi_exception 2014-09-01 17:09:52.588 3723 TRACE designate util.raise_from_cause(newraise, exc_info) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause 2014-09-01 17:09:52.588 3723 TRACE designate reraise(type(exception), exception, tb=exc_tb) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 951, in _execute_context 2014-09-01 17:09:52.588 3723 TRACE designate context) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 436, in do_execute 2014-09-01 17:09:52.588 3723 TRACE designate cursor.execute(statement, parameters) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute 2014-09-01 17:09:52.588 3723 TRACE designate self.errorhandler(self, exc, value) 2014-09-01 17:09:52.588 3723 TRACE designate File "/home/kiall/HP/gozer/openstack/designate/.venv/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler 2014-09-01 17:09:52.588 3723 TRACE designate raise errorclass, errorvalue 2014-09-01 17:09:52.588 3723 TRACE designate DBError: (IntegrityError) (1215, 'Cannot add foreign key constraint') 'ALTER TABLE records ENGINE=InnoDB' () 2014-09-01 17:09:52.588 3723 TRACE designate