Hi, Edgar, Please file a bug on this. Obviously this was introduced by that commit.
Thanks, Eugene. On Thu, Dec 12, 2013 at 7: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