yahoo-eng-team team mailing list archive

[YAMAMOTO Takashi <yamamoto@xxxxxxxxxxxx>]

https://review.openstack.org/358541

** Also affects: neutron
   Importance: Undecided
       Status: New

** Changed in: networking-midonet
   Importance: Undecided => Critical

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1615577

Title:
  fwaas db migration faliure with postgres

Status in networking-midonet:
  New
Status in neutron:
  New

Bug description:
      Traceback (most recent call last):
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/oslo_db/sqlalchemy/test_migrations.py", line 602, in test_models_sync
          self.db_sync(self.get_engine())
        File "midonet/neutron/tests/unit/db/test_migrations.py", line 102, in db_sync
          migration.do_alembic_command(conf, 'upgrade', 'heads')
        File "/opt/stack/networking-midonet/.tox/py27/src/neutron/neutron/db/migration/cli.py", line 108, in do_alembic_command
          getattr(alembic_command, cmd)(config, *args, **kwargs)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/command.py", line 174, in upgrade
          script.run_env()
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/script/base.py", line 407, in run_env
          util.load_python_file(self.dir, 'env.py')
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/util/pyfiles.py", line 93, in load_python_file
          module = load_module_py(module_id, path)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/util/compat.py", line 79, in load_module_py
          mod = imp.load_source(module_id, path, fp)
        File "/opt/stack/networking-midonet/.tox/py27/src/neutron-fwaas/neutron_fwaas/db/migration/alembic_migrations/env.py", line 86, in <module>
          run_migrations_online()
        File "/opt/stack/networking-midonet/.tox/py27/src/neutron-fwaas/neutron_fwaas/db/migration/alembic_migrations/env.py", line 77, in run_migrations_online
          context.run_migrations()
        File "<string>", line 8, in run_migrations
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/runtime/environment.py", line 797, in run_migrations
          self.get_context().run_migrations(**kw)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/runtime/migration.py", line 312, in run_migrations
          step.migration_fn(**kw)
        File "/opt/stack/networking-midonet/.tox/py27/src/neutron-fwaas/neutron_fwaas/db/migration/alembic_migrations/versions/d6a12e637e28_neutron_fwaas_v2_0.py", line 61, in upgrade
          sa.Column('enabled', sa.Boolean))
        File "<string>", line 8, in create_table
        File "<string>", line 3, in create_table
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/operations/ops.py", line 1098, in create_table
          return operations.invoke(op)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/operations/base.py", line 318, in invoke
          return fn(self, operation)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/operations/toimpl.py", line 101, in create_table
          operations.impl.create_table(table)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/alembic/ddl/impl.py", line 193, in create_table
          _ddl_runner=self)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/event/attr.py", line 256, in __call__
          fn(*args, **kw)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/langhelpers.py", line 546, in __call__
          return getattr(self.target, self.name)(*arg, **kw)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py", line 1030, in _on_table_create
          t._on_table_create(target, bind, **kw)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/base.py", line 1369, in _on_table_create
          self.create(bind=bind, checkfirst=checkfirst)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/dialects/postgresql/base.py", line 1317, in create
          bind.execute(CreateEnumType(self))
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 914, in execute
          return meth(self, multiparams, params)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/sql/ddl.py", line 68, in _execute_on_connection
          return connection._execute_ddl(self, multiparams, params)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 968, in _execute_ddl
          compiled
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
          context)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
          util.raise_from_cause(newraise, exc_info)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
          reraise(type(exception), exception, tb=exc_tb, cause=cause)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
          context)
        File "/opt/stack/networking-midonet/.tox/py27/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
          cursor.execute(statement, parameters)
      oslo_db.exception.DBError: (psycopg2.ProgrammingError) type "firewallrules_action" already exists
       [SQL: "CREATE TYPE firewallrules_action AS ENUM ('allow', 'deny', 'reject')"]

To manage notifications about this bug go to:
https://bugs.launchpad.net/networking-midonet/+bug/1615577/+subscriptions