← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #28286

[Bug 1419723] [NEW] DBDuplicateEntry when creating secgroup

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

Error when attempted to create secutity groups in more then one thread.

full log: http://logs.openstack.org/33/144633/45/check/gate-rally-dsvm-
neutron-rally/0ed9492/logs/

ERROR neutron.api.v2.resource [req-f211be5c-0c2e-42d7-86e4-773a299f3e03 ctx_rally_08bdcaef529f4ebc8b24263106e2e2ff_user_1 ctx_rally_1e92a94e-1a15-47f3-84ab-e656556d2567_tenant_1] create failed
Traceback (most recent call last):
  File "/opt/stack/new/neutron/neutron/api/v2/resource.py", line 83, in resource
    result = method(request=request, **args)
  File "/opt/stack/new/neutron/neutron/api/v2/base.py", line 452, in create
    obj = obj_creator(request.context, **kwargs)
  File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 127, in create_security_group
    self._ensure_default_security_group(context, tenant_id)
  File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 536, in _ensure_default_security_group
    default_sg=True)
  File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 156, in create_security_group
    context.session.add(egress_rule)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 470, in __exit__
    self.rollback()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 467, in __exit__
    self.commit()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 377, in commit
    self._prepare_impl()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 357, in _prepare_impl
    self.session.flush()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1919, in flush
    self._flush(objects)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2037, in _flush
    transaction.rollback(_capture_exception=True)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
    compat.reraise(exc_type, exc_value, exc_tb)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2001, in _flush
    flush_context.execute()
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
    rec.execute(self)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
    uow
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 65, in save_obj
    mapper, table, insert)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 570, in _emit_insert_statements
    execute(statement, multiparams)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
    return meth(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
    return connection._execute_clauseelement(self, multiparams, params)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1155, in _handle_dbapi_exception
    util.raise_from_cause(newraise, exc_info)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
    reraise(type(exception), exception, tb=exc_tb)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
    context)
  File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, 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
DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry '08bdcaef529f4ebc8b24263106e2e2ff' for key 'PRIMARY'") 'INSERT INTO default_security_group (tenant_id, security_group_id) VALUES (%s, %s)' ('08bdcaef529f4ebc8b24263106e2e2ff', '23327aad-6c5b-40c0-8069-2401e09893d1')

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: db

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

Title:
  DBDuplicateEntry when creating secgroup

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Error when attempted to create secutity groups in more then one
  thread.

  full log: http://logs.openstack.org/33/144633/45/check/gate-rally-
  dsvm-neutron-rally/0ed9492/logs/

  ERROR neutron.api.v2.resource [req-f211be5c-0c2e-42d7-86e4-773a299f3e03 ctx_rally_08bdcaef529f4ebc8b24263106e2e2ff_user_1 ctx_rally_1e92a94e-1a15-47f3-84ab-e656556d2567_tenant_1] create failed
  Traceback (most recent call last):
    File "/opt/stack/new/neutron/neutron/api/v2/resource.py", line 83, in resource
      result = method(request=request, **args)
    File "/opt/stack/new/neutron/neutron/api/v2/base.py", line 452, in create
      obj = obj_creator(request.context, **kwargs)
    File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 127, in create_security_group
      self._ensure_default_security_group(context, tenant_id)
    File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 536, in _ensure_default_security_group
      default_sg=True)
    File "/opt/stack/new/neutron/neutron/db/securitygroups_db.py", line 156, in create_security_group
      context.session.add(egress_rule)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 470, in __exit__
      self.rollback()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
      compat.reraise(exc_type, exc_value, exc_tb)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 467, in __exit__
      self.commit()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 377, in commit
      self._prepare_impl()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 357, in _prepare_impl
      self.session.flush()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1919, in flush
      self._flush(objects)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2037, in _flush
      transaction.rollback(_capture_exception=True)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
      compat.reraise(exc_type, exc_value, exc_tb)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2001, in _flush
      flush_context.execute()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 372, in execute
      rec.execute(self)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 526, in execute
      uow
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 65, in save_obj
      mapper, table, insert)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 570, in _emit_insert_statements
      execute(statement, multiparams)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 729, in execute
      return meth(self, multiparams, params)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 322, in _execute_on_connection
      return connection._execute_clauseelement(self, multiparams, params)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 826, in _execute_clauseelement
      compiled_sql, distilled_params
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 958, in _execute_context
      context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1155, in _handle_dbapi_exception
      util.raise_from_cause(newraise, exc_info)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 199, in raise_from_cause
      reraise(type(exception), exception, tb=exc_tb)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 951, in _execute_context
      context)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 436, 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
  DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry '08bdcaef529f4ebc8b24263106e2e2ff' for key 'PRIMARY'") 'INSERT INTO default_security_group (tenant_id, security_group_id) VALUES (%s, %s)' ('08bdcaef529f4ebc8b24263106e2e2ff', '23327aad-6c5b-40c0-8069-2401e09893d1')

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next