** 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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to