Hi Dmitry, This is known problem. It is being addressed by https://bugs.launchpad.net/neutron/+bug/1209151 https://review.openstack.org/#/c/40636/1
Thanks, Eugene. On Wed, Aug 7, 2013 at 7:59 PM, Dmitriy Andrushko <[email protected]>wrote: > 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 > > _______________________________________________ > OpenStack-dev mailing list > [email protected] > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev >
_______________________________________________ OpenStack-dev mailing list [email protected] http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
