Guest User

neutron.db.migration.migrate_to_ml2 foreign key error

a guest
Apr 21st, 2015
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 3.34 KB | None | 0 0
  1. [root@gpu2 neutron]# python -m neutron.db.migration.migrate_to_ml2 openvswitch   mysql://quantum:mquserpassword@gpu4/ovs_quantum
  2. Traceback (most recent call last):
  3.   File "/usr/lib64/python2.6/runpy.py", line 122, in _run_module_as_main
  4.     "__main__", fname, loader, pkg_name)
  5.   File "/usr/lib64/python2.6/runpy.py", line 34, in _run_code
  6.     exec code in run_globals
  7.   File "/usr/lib/python2.6/site-packages/neutron/db/migration/migrate_to_ml2.py", line 462, in <module>
  8.     main()
  9.   File "/usr/lib/python2.6/site-packages/neutron/db/migration/migrate_to_ml2.py", line 458, in main
  10.     args.vxlan_udp_port)
  11.   File "/usr/lib/python2.6/site-packages/neutron/db/migration/migrate_to_ml2.py", line 138, in __call__
  12.     metadata.create_all(engine)
  13.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/schema.py", line 2848, in create_all
  14.     tables=tables)
  15.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1479, in _run_visitor
  16.     conn._run_visitor(visitorcallable, element, **kwargs)
  17.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1122, in _run_visitor
  18.     **kwargs).traverse_single(element)
  19.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 122, in traverse_single
  20.     return meth(obj, **kw)
  21.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/ddl.py", line 70, in visit_metadata
  22.     self.traverse_single(table, create_ok=True)
  23.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/sql/visitors.py", line 122, in traverse_single
  24.     return meth(obj, **kw)
  25.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/ddl.py", line 89, in visit_table
  26.     self.connection.execute(schema.CreateTable(table))
  27.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 662, in execute
  28.     params)
  29.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 720, in _execute_ddl
  30.     compiled
  31.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 874, in _execute_context
  32.     context)
  33.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 1024, in _handle_dbapi_exception
  34.     exc_info
  35.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/util/compat.py", line 196, in raise_from_cause
  36.     reraise(type(exception), exception, tb=exc_tb)
  37.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/base.py", line 867, in _execute_context
  38.     context)
  39.   File "/usr/lib64/python2.6/site-packages/sqlalchemy/engine/default.py", line 324, in do_execute
  40.     cursor.execute(statement, parameters)
  41.   File "/usr/lib64/python2.6/site-packages/MySQLdb/cursors.py", line 173, in execute
  42.     self.errorhandler(self, exc, value)
  43.   File "/usr/lib64/python2.6/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  44.     raise errorclass, errorvalue
  45. sqlalchemy.exc.OperationalError: (OperationalError) (1005, "Can't create table 'ovs_quantum.ml2_network_segments' (errno: 150)") '\nCREATE TABLE ml2_network_segments (\n\tid VARCHAR(36) NOT NULL, \n\tnetwork_id VARCHAR(36) NOT NULL, \n\tnetwork_type VARCHAR(32) NOT NULL, \n\tphysical_network VARCHAR(64), \n\tsegmentation_id INTEGER, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(network_id) REFERENCES networks (id) ON DELETE CASCADE\n)\n\n' ()
  46. [root@gpu2 neutron]# python -m neutron.db.migration.migrate_to_ml2 openvswitch   mysql://quantum:mquserpassword@gpu4/ovs_quantum
Advertisement
Add Comment
Please, Sign In to add comment