duplicate entry in dhcp agent auto schedule

[yong sheng gong]

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')

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/30211

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/30211
Committed: http://github.com/openstack/quantum/commit/7e3cef2d7b6bb839c399ce8730153b6fa7076d96
Submitter: Jenkins
Branch: master

commit 7e3cef2d7b6bb839c399ce8730153b6fa7076d96
Author: gongysh <email address hidden>
Date: Thu May 23 11:45:49 2013 +0800

    avoid auto scheduling one dhcp agent twice.

    Bug #1183173

    Change-Id: Iff7b23faae50e6736b253ca5a2b1280451127200