<div dir="ltr">Hi Dmitry,<div><br></div><div>This is known problem. It is being addressed by <a href="https://bugs.launchpad.net/neutron/+bug/1209151">https://bugs.launchpad.net/neutron/+bug/1209151</a> <a href="https://review.openstack.org/#/c/40636/1">https://review.openstack.org/#/c/40636/1</a></div>
<div><br></div><div style>Thanks,</div><div style>Eugene.</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Aug 7, 2013 at 7:59 PM, Dmitriy Andrushko <span dir="ltr"><<a href="mailto:dandrushko@mirantis.com" target="_blank">dandrushko@mirantis.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi, all!<br>
Following request from ML2 team discussed during weekly IRC meeting,<br>
i'm writing about issue with devstack and ML2 setup.<br>
I have clear Ubuntu 12.04 installation and devstack just cloned from<br>
repository. In devstack folder there is localrc file with basic<br>
options to enable ML2. According to Wiki page just two options<br>
required to enable ML2, particularly my config include:<br>
<br>
disable_service n-net<br>
enable_service n-sch<br>
enable_service q-svc<br>
enable_service q-agt<br>
enable_service q-dhcp<br>
enable_service q-l3<br>
enable_service q-meta<br>
enable_service quantum<br>
Q_PLUGIN=ml2<br>
ENABLE_TENANT_VLANS=True<br>
<br>
During stack setup i meet error, below is the partial trace:<br>
<--cut, not valuable--><br>
2013-08-07 16:45:23 INFO [alembic.migration] Running upgrade 2032abe8edac -> 52<br>
c5e4a18807, LBaaS Pool scheduler<br>
2013-08-07 16:45:23 Traceback (most recent call last):<br>
2013-08-07 16:45:23 File "/usr/local/bin/neutron-db-manage", line 10, in <modu<br>
le><br>
2013-08-07 16:45:23 sys.exit(main())<br>
2013-08-07 16:45:23 File "/opt/stack/neutron/neutron/db/migration/cli.py", lin<br>
e 140, in main<br>
2013-08-07 16:45:23 CONF.command.func(config, <a href="http://CONF.command.name" target="_blank">CONF.command.name</a>)<br>
2013-08-07 16:45:23 File<br>
"/opt/stack/neutron/neutron/db/migration/cli.py", line 77, in<br>
do_upgrade_downgrade<br>
2013-08-07 16:45:23 do_alembic_command(config, cmd, revision,<br>
sql=CONF.command.sql)<br>
2013-08-07 16:45:23 File<br>
"/opt/stack/neutron/neutron/db/migration/cli.py", line 56, in<br>
do_alembic_command<br>
2013-08-07 16:45:23 getattr(alembic_command, cmd)(config, *args, **kwargs)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/command.py", line 124,<br>
in upgrade<br>
2013-08-07 16:45:23 script.run_env()<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 193,<br>
in run_env<br>
2013-08-07 16:45:23 util.load_python_file(self.dir, 'env.py')<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 177, in<br>
load_python_file<br>
2013-08-07 16:45:23 module = load_module(module_id, path)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 39,<br>
in load_module<br>
2013-08-07 16:45:23 return imp.load_source(module_id, path, fp)<br>
2013-08-07 16:45:23 File<br>
"/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py",<br>
line 102, in <module><br>
2013-08-07 16:45:23 run_migrations_online()<br>
2013-08-07 16:45:23 File<br>
"/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py",<br>
line 86, in run_migrations_online<br>
2013-08-07 16:45:23 options=build_options())<br>
2013-08-07 16:45:23 File "<string>", line 7, in run_migrations<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line<br>
652, in run_migrations<br>
2013-08-07 16:45:23 self.get_context().run_migrations(**kw)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line<br>
224, in run_migrations<br>
2013-08-07 16:45:23 change(**kw)<br>
2013-08-07 16:45:23 File<br>
"/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/52c5e4a18807_lbaas_pool_scheduler.py",<br>
line 45, in upgrade<br>
2013-08-07 16:45:23 sa.PrimaryKeyConstraint('pool_id')<br>
2013-08-07 16:45:23 File "<string>", line 7, in create_table<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line<br>
631, in create_table<br>
2013-08-07 16:45:23 self._table(name, *columns, **kw)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line<br>
149, in create_table<br>
2013-08-07 16:45:23 self._exec(schema.CreateTable(table))<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line 76,<br>
in _exec<br>
2013-08-07 16:45:23 conn.execute(construct, *multiparams, **params)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
line 1449, in execute<br>
2013-08-07 16:45:23 params)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
line 1542, in _execute_ddl<br>
2013-08-07 16:45:23 compiled<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
line 1698, in _execute_context<br>
2013-08-07 16:45:23 context)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py",<br>
line 1691, in _execute_context<br>
2013-08-07 16:45:23 context)<br>
2013-08-07 16:45:23 File<br>
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py",<br>
line 331, in do_execute<br>
2013-08-07 16:45:23 cursor.execute(statement, parameters)<br>
2013-08-07 16:45:23 File<br>
"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in<br>
execute<br>
2013-08-07 16:45:23 self.errorhandler(self, exc, value)<br>
2013-08-07 16:45:23 File<br>
"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in<br>
defaulterrorhandler<br>
2013-08-07 16:45:23 raise errorclass, errorvalue<br>
2013-08-07 16:45:23 sqlalchemy.exc.OperationalError:<br>
(OperationalError) (1005, "Can't create table<br>
'neutron_ml2.poolloadbalanceragentbindings' (errno: 150)") '\nCREATE<br>
TABLE poolloadbalanceragentbindings (\n\tpool_id VARCHAR(36) NOT NULL,<br>
\n\tloadbalancer_agent_id VARCHAR(36) NOT NULL, \n\tPRIMARY KEY<br>
(pool_id), \n\tFOREIGN KEY(loadbalancer_agent_id) REFERENCES agents<br>
(id) ON DELETE CASCADE, \n\tFOREIGN KEY(pool_id) REFERENCES pools (id)<br>
ON DELETE CASCADE\n)\n\n' ()<br>
2013-08-07 16:45:23 ++ failed<br>
2013-08-07 16:45:23 ++ local r=1<br>
2013-08-07 16:45:23 +++ jobs -p<br>
2013-08-07 16:45:23 ++ kill<br>
<--cut, not valuable--><br>
<br>
<br>
After some research i've found that problem in this SQL relates to<br>
this part of the statement "FOREIGN KEY(loadbalancer_agent_id)<br>
REFERENCES agents (id)", i.e. it refers to foreign key in table<br>
"agents", which should be in neutron_ml2 database. It looks like this<br>
table should be created during execution of<br>
/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/511471cc46b_agent_ext_model_supp.py<br>
migration script, which executed before this one, but in some reason<br>
table wasn't created.<br>
<br>
I'm still working on this issue, but probably there is already some<br>
solution. In this case please provide me any information on such<br>
solution or workaround.<br>
<br>
<br>
Thank you in advance!<br>
<br>
Kind regards, Dmitriy<br>
<br>
_______________________________________________<br>
OpenStack-dev mailing list<br>
<a href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a><br>
<a href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev" target="_blank">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a><br>
</blockquote></div><br></div>