yahoo-eng-team team mailing list archive

[OpenStack Infra <1758786@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://review.openstack.org/556739
Committed: https://git.openstack.org/cgit/openstack/neutron-fwaas/commit/?id=d9c52bcd54881d336cf1d5a74b4ed3697a1223fe
Submitter: Zuul
Branch:    master

commit d9c52bcd54881d336cf1d5a74b4ed3697a1223fe
Author: Zhenmei <zma@xxxxxxxxxx>
Date:   Mon Mar 26 22:42:53 2018 -0400

    Fix sanity check for default firewall group name
    
    Only query name for duplicate firewall group named check
    
    Change-Id: I2b1e85546de6d778532e43097d56d6b629acf436
    Closes-Bug: #1758786


** Changed in: neutron
       Status: In Progress => Fix Released

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

Title:
  neutron db migration failed in subproject neutron-fwaas

Status in neutron:
  Fix Released

Bug description:
  We use command “neutron-db-manage --config-file /etc/neutron/neutron.conf --config-file /etc/neutron/plugins/vmware/dvs.ini upgrade  head” to do db migration from ocata to queens. The sanity_check in the script "876782258a43_create_default_firewall_groups_table" failed with following error message:
  \"/usr/lib/python2.7/dist-packages/neutron_fwaas/db/migration/alembic_migrations/versions/queens/expand/876782258a43_create_default_firewall_groups_table.py\", line 65, in check_sanity

      resources.FIREWALL_GROUP.name == const.DEFAULT_FWG).first()

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\",
  line 2755, in first

      ret = list(self[0:1])

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\",
  line 2547, in __getitem__

      return list(res)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\",
  line 2855, in __iter__

      return self._execute_and_instances(context)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/orm/query.py\",
  line 2878, in _execute_and_instances

      result = conn.execute(querycontext.statement, self._params)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\",
  line 945, in execute

      return meth(self, multiparams, params)

    File \"/usr/lib/python2.7/dist-
  packages/sqlalchemy/sql/elements.py\", line 263, in
  _execute_on_connection

      return connection._execute_clauseelement(self, multiparams,
  params)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\",
  line 1053, in _execute_clauseelement

      compiled_sql, distilled_params

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\",
  line 1189, in _execute_context

      context)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\",
  line 1398, in _handle_dbapi_exception

      util.raise_from_cause(newraise, exc_info)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/util/compat.py\",
  line 203, in raise_from_cause

      reraise(type(exception), exception, tb=exc_tb, cause=cause)

    File \"/usr/lib/python2.7/dist-packages/sqlalchemy/engine/base.py\",
  line 1182, in _execute_context

      context)

    File \"/usr/lib/python2.7/dist-
  packages/sqlalchemy/engine/default.py\", line 470, in do_execute

      cursor.execute(statement, parameters)

    File \"/usr/lib/python2.7/dist-packages/pymysql/cursors.py\", line
  165, in execute

      result = self._query(query)

    File \"/usr/lib/python2.7/dist-packages/pymysql/cursors.py\", line
  321, in _query

      conn.query(q)

    File \"/usr/lib/python2.7/dist-packages/pymysql/connections.py\",
  line 860, in query

      self._affected_rows =
  self._read_query_result(unbuffered=unbuffered)

    File \"/usr/lib/python2.7/dist-packages/pymysql/connections.py\",
  line 1061, in _read_query_result

      result.read()

    File \"/usr/lib/python2.7/dist-packages/pymysql/connections.py\",
  line 1349, in read

      first_packet = self.connection._read_packet()

    File \"/usr/lib/python2.7/dist-packages/pymysql/connections.py\",
  line 1018, in _read_packet

      packet.check_error()

    File \"/usr/lib/python2.7/dist-packages/pymysql/connections.py\",
  line 384, in check_error

      err.raise_mysql_exception(self._data)

    File \"/usr/lib/python2.7/dist-packages/pymysql/err.py\", line 107,
  in raise_mysql_exception

      raise errorclass(errno, errval)

  oslo_db.exception.DBError: (pymysql.err.InternalError) (1054,
  u\"Unknown column 'firewall_groups_v2.shared' in 'field list'\") [SQL:
  u'SELECT firewall_groups_v2.project_id AS
  firewall_groups_v2_project_id, firewall_groups_v2.id AS
  firewall_groups_v2_id, firewall_groups_v2.name AS
  firewall_groups_v2_name, firewall_groups_v2.description AS
  firewall_groups_v2_description,
  firewall_groups_v2.ingress_firewall_policy_id AS
  firewall_groups_v2_ingress_firewall_policy_id,
  firewall_groups_v2.egress_firewall_policy_id AS
  firewall_groups_v2_egress_firewall_policy_id,
  firewall_groups_v2.admin_state_up AS
  firewall_groups_v2_admin_state_up, firewall_groups_v2.status AS
  firewall_groups_v2_status, firewall_groups_v2.shared AS
  firewall_groups_v2_shared \

  FROM firewall_groups_v2 \

  WHERE firewall_groups_v2.name = %(name_1)s \

  LIMIT %(param_1)s'

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1758786/+subscriptions