Hi Edgar, Nice catch! I proposed a fix here https://review.openstack.org/#/c/61663/
Could you please test it and and tell us if it fixes your problem? Thanks, Roman On Thu, Dec 12, 2013 at 5:45 AM, Edgar Magana <emag...@plumgrid.com> wrote: > In commit: > https://review.openstack.org/#/c/58814/ > > There is an assumption that all "plugins" creates the > plumgrid_neutron.agents which is not the case. I just tested big switch and > plumgrid and they are failing: > > INFO [alembic.migration] Running upgrade havana -> e197124d4b9, add unique > constraint to members > INFO [alembic.migration] Running upgrade e197124d4b9 -> 1fcfc149aca4, Add a > unique constraint on (agent_type, host) columns to prevent a race > condition when an agent entry is 'upserted'. > Traceback (most recent call last): > File "/usr/local/bin/neutron-db-manage", line 10, in <module> > sys.exit(main()) > File "/opt/stack/neutron/neutron/db/migration/cli.py", line 143, in main > CONF.command.func(config, CONF.command.name) > File "/opt/stack/neutron/neutron/db/migration/cli.py", line 80, in > do_upgrade_downgrade > do_alembic_command(config, cmd, revision, sql=CONF.command.sql) > File "/opt/stack/neutron/neutron/db/migration/cli.py", line 59, in > do_alembic_command > getattr(alembic_command, cmd)(config, *args, **kwargs) > File "/usr/local/lib/python2.7/dist-packages/alembic/command.py", line > 124, in upgrade > script.run_env() > File "/usr/local/lib/python2.7/dist-packages/alembic/script.py", line 193, > in run_env > util.load_python_file(self.dir, 'env.py') > File "/usr/local/lib/python2.7/dist-packages/alembic/util.py", line 177, > in load_python_file > module = load_module(module_id, path) > File "/usr/local/lib/python2.7/dist-packages/alembic/compat.py", line 39, > in load_module > return imp.load_source(module_id, path, fp) > File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", > line 105, in <module> > run_migrations_online() > File "/opt/stack/neutron/neutron/db/migration/alembic_migrations/env.py", > line 89, in run_migrations_online > options=build_options()) > File "<string>", line 7, in run_migrations > File "/usr/local/lib/python2.7/dist-packages/alembic/environment.py", line > 652, in run_migrations > self.get_context().run_migrations(**kw) > File "/usr/local/lib/python2.7/dist-packages/alembic/migration.py", line > 224, in run_migrations > change(**kw) > File > "/opt/stack/neutron/neutron/db/migration/alembic_migrations/versions/1fcfc149aca4_agents_unique_by_type_and_host.py", > line 50, in upgrade > local_cols=['agent_type', 'host'] > File "<string>", line 7, in create_unique_constraint > File "/usr/local/lib/python2.7/dist-packages/alembic/operations.py", line > 539, in create_unique_constraint > schema=schema, **kw) > File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line > 135, in add_constraint > self._exec(schema.AddConstraint(const)) > File "/usr/local/lib/python2.7/dist-packages/alembic/ddl/impl.py", line > 76, in _exec > conn.execute(construct, *multiparams, **params) > File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", > line 1449, in execute > params) > File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", > line 1542, in _execute_ddl > compiled > File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", > line 1698, in _execute_context > context) > File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", > line 1691, in _execute_context > context) > File > "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line > 331, in do_execute > cursor.execute(statement, parameters) > File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in > execute > self.errorhandler(self, exc, value) > File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, > in defaulterrorhandler > raise errorclass, errorvalue > sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1146, "Table > 'plumgrid_neutron.agents' doesn't exist") 'ALTER TABLE agents ADD CONSTRAINT > uniq_agents0agent_type0host UNIQUE (agent_type, host)' () > ++ failed > ++ local r=1 > +++ jobs -p > ++ kill > ++ set +o xtrace > > > > Is this known issues? If not, let me know and I can properly reported. > > Thanks, > > Edgar > > _______________________________________________ > OpenStack-dev mailing list > OpenStack-dev@lists.openstack.org > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > _______________________________________________ OpenStack-dev mailing list OpenStack-dev@lists.openstack.org http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
