yahoo-eng-team team mailing list archive

[Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>]

** Changed in: quantum
       Status: Fix Committed => Fix Released

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

Title:
  duplicate entry in dhcp agent auto schedule

Status in OpenStack Quantum (virtual network service):
  Fix Released

Bug description:
  Traceback (most recent call last):
    File "/mnt/data/git/quantum/quantum/openstack/common/rpc/amqp.py", line 433, in _process_data
      **args)
    File "/mnt/data/git/quantum/quantum/common/rpc.py", line 44, in dispatch
      quantum_ctxt, version, method, namespace, **kwargs)
    File "/mnt/data/git/quantum/quantum/openstack/common/rpc/dispatcher.py", line 148, in dispatch
      return getattr(proxyobj, method)(ctxt, **kwargs)
    File "/mnt/data/git/quantum/quantum/db/dhcp_rpc_base.py", line 40, in get_active_networks
      plugin.auto_schedule_networks(context, host)
    File "/mnt/data/git/quantum/quantum/db/agentschedulers_db.py", line 318, in auto_schedule_networks
      self.network_scheduler.auto_schedule_networks(self, context, host)
    File "/mnt/data/git/quantum/quantum/scheduler/dhcp_agent_scheduler.py", line 113, in auto_schedule_networks
      context, [net_id], active=True)
    File "/mnt/data/git/quantum/quantum/db/agentschedulers_db.py", line 96, in get_dhcp_agents_hosting_networks
      for binding in query
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/query.py", line 2226, in __iter__
      self.session._autoflush()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1120, in _autoflush
      self.flush()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1718, in flush
      self._flush(objects)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 1789, in _flush
      flush_context.execute()
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 331, in execute
      rec.execute(self)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 475, in execute
      uow
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
      table, insert)
    File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 530, in _emit_insert_statements
      execute(statement, multiparams)
    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 1584, in _execute_clauseelement
      compiled_sql, distilled_params
    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
  IntegrityError: (IntegrityError) (1062, "Duplicate entry 'b8525b9a-f522-4603-a092-5d3f89af28af-d5724d7e-389d-4ba0-8d00-fc6' for key 'PRIMARY'") 'INSERT INTO networkdhcpagentbindings (network_id, dhcp_agent_id) VALUES (%s, %s)' ('b8525b9a-f522-4603-a092-5d3f89af28af', 'd5724d7e-389d-4ba0-8d00-fc673a147bfa')

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