Open Stack

Hi, all!
Following request from ML2 team discussed during weekly IRC meeting,
i'm writing about issue with devstack and ML2 setup.
I have clear Ubuntu 12.04 installation and devstack just cloned from
repository. In devstack folder there is localrc file with basic
options to enable ML2. According to Wiki page just  two options
required to enable ML2, particularly my config include:

disable_service n-net
enable_service n-sch
enable_service q-svc
enable_service q-agt
enable_service q-dhcp
enable_service q-l3
enable_service q-meta
enable_service quantum
Q_PLUGIN=ml2
ENABLE_TENANT_VLANS=True

During stack setup i meet error, below is the partial trace:
<--cut, not valuable-->
2013-08-07 16:45:23 INFO  [alembic.migration] Running upgrade 2032abe8edac -> 52
c5e4a18807, LBaaS Pool scheduler
2013-08-07 16:45:23 Traceback (most recent call last):
2013-08-07 16:45:23   File "/usr/local/bin/neutron-db-manage", line 10, in <modu
le>
2013-08-07 16:45:23     sys.exit(main())
2013-08-07 16:45:23   File "/opt/stack/neutron/neutron/db/migration/cli.py", lin
e 140, in main
2013-08-07 16:45:23     CONF.command.func(config, CONF.command.name)
2013-08-07 16:45:23   File
"/opt/stack/neutron/neutron/db/migration/cli.py", line 77, in
do_upgrade_downgrade
2013-08-07 16:45:23     do_alembic_command(config, cmd, revision,
sql=CONF.command.sql)
2013-08-07 16:45:23   File
"/opt/stack/neutron/neutron/db/migration/cli.py", line 56, in
do_alembic_command
2013-08-07 16:45:23     getattr(alembic_command, cmd)(config, *args, **kwargs)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124,
in upgrade
2013-08-07 16:45:23     script.run_env()
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 193,
in run_env
2013-08-07 16:45:23     util.load_python_file(self.dir, 'env.py')
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 177, in
load_python_file
2013-08-07 16:45:23     module = load_module(module_id, path)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 39,
in load_module
2013-08-07 16:45:23     return imp.load_source(module_id, path, fp)
2013-08-07 16:45:23   File
"/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py",
line 102, in <module>
2013-08-07 16:45:23     run_migrations_online()
2013-08-07 16:45:23   File
"/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py",
line 86, in run_migrations_online
2013-08-07 16:45:23     options=build_options())
2013-08-07 16:45:23   File "<string>", line 7, in run_migrations
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line
652, in run_migrations
2013-08-07 16:45:23     self.get_context().run_migrations(**kw)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line
224, in run_migrations
2013-08-07 16:45:23     change(**kw)
2013-08-07 16:45:23   File
"/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/52c5e4a18807_lbaas_pool_scheduler.py",
line 45, in upgrade
2013-08-07 16:45:23     sa.PrimaryKeyConstraint('pool_id')
2013-08-07 16:45:23   File "<string>", line 7, in create_table
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line
631, in create_table
2013-08-07 16:45:23     self._table(name, *columns, **kw)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line
149, in create_table
2013-08-07 16:45:23     self._exec(schema.CreateTable(table))
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76,
in _exec
2013-08-07 16:45:23     conn.execute(construct, *multiparams, **params)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1449, in execute
2013-08-07 16:45:23     params)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1542, in _execute_ddl
2013-08-07 16:45:23     compiled
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1698, in _execute_context
2013-08-07 16:45:23     context)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",
line 1691, in _execute_context
2013-08-07 16:45:23     context)
2013-08-07 16:45:23   File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",
line 331, in do_execute
2013-08-07 16:45:23     cursor.execute(statement, parameters)
2013-08-07 16:45:23   File
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in
execute
2013-08-07 16:45:23     self.errorhandler(self, exc, value)
2013-08-07 16:45:23   File
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in
defaulterrorhandler
2013-08-07 16:45:23     raise errorclass, errorvalue
2013-08-07 16:45:23 sqlalchemy.exc.OperationalError:
(OperationalError) (1005, "Can't create table
'neutron_ml2.poolloadbalanceragentbindings' (errno: 150)") '\nCREATE
TABLE poolloadbalanceragentbindings (\n\tpool_id VARCHAR(36) NOT NULL,
\n\tloadbalancer_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY
(pool_id), \n\tFOREIGN KEY(loadbalancer_agent_id) REFERENCES agents
(id) ON DELETE CASCADE, \n\tFOREIGN KEY(pool_id) REFERENCES pools (id)
ON DELETE CASCADE\n)\n\n' ()
2013-08-07 16:45:23 ++ failed
2013-08-07 16:45:23 ++ local r=1
2013-08-07 16:45:23 +++ jobs -p
2013-08-07 16:45:23 ++ kill
<--cut, not valuable-->


After some research i've found that problem in this SQL relates to
this part of the statement "FOREIGN KEY(loadbalancer_agent_id)
REFERENCES agents (id)", i.e. it refers to foreign key in table
"agents", which should be in neutron_ml2 database. It looks like this
table should be created during execution of
/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/511471cc46b_agent_ext_model_supp.py
migration script, which executed before this one, but in some reason
table wasn't created.

I'm still working on this issue, but probably there is already some
solution. In this case please provide me any information on such
solution or workaround.


Thank you in advance!

Kind regards, Dmitriy