** Changed in: neutron
       Status: Fix Committed => 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/1307295

Title:
  duplicate entry exception for vxlan-allocation

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

Bug description:
  I run multiple neutron-servers using haproxy. Here's the exception
  thrown by all the neutron-servers when services restart:

  2014-04-14 11:42:18.315 6457 ERROR neutron.service [-] Unrecoverable error: 
please check log for details.
  2014-04-14 11:42:18.315 6457 TRACE neutron.service Traceback (most recent 
call last):
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/service.py", line 103, in serve_wsgi
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     service.start()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/service.py", line 72, in start
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     self.wsgi_app = 
_run_wsgi(self.app_name)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/service.py", line 117, in _run_wsgi
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     app = 
config.load_paste_app(app_name)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/common/config.py", line 145, in 
load_paste_app
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     app = 
deploy.loadapp("config:%s" % config_path, name=app_name)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 247, in loadapp
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return loadobj(APP, 
uri, name=name, **kw)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 272, in loadobj
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return context.create()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 710, in create
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return 
self.object_type.invoke(self)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 144, in invoke
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     **context.local_conf)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/util.py",
 line 56, in fix_call
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     val = callable(*args, 
**kw)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/paste/urlmap.py", line 25, in urlmap_factory
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     app = 
loader.get_app(app_name, global_conf=global_conf)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 350, in get_app
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     name=name, 
global_conf=global_conf).create()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 710, in create
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return 
self.object_type.invoke(self)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 144, in invoke
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     **context.local_conf)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/util.py",
 line 56, in fix_call
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     val = callable(*args, 
**kw)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/auth.py", line 69, in pipeline_factory
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     app = 
loader.get_app(pipeline[-1])
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 350, in get_app
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     name=name, 
global_conf=global_conf).create()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 710, in create
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return 
self.object_type.invoke(self)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/loadwsgi.py",
 line 146, in invoke
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return 
fix_call(context.object, context.global_conf, **context.local_conf)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/PasteDeploy-1.5.0-py2.6.egg/paste/deploy/util.py",
 line 56, in fix_call
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     val = callable(*args, 
**kw)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/api/v2/router.py", line 71, in factory
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return 
cls(**local_config)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/api/v2/router.py", line 75, in 
__init__
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     plugin = 
manager.NeutronManager.get_plugin()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/manager.py", line 211, in get_plugin
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return 
cls.get_instance().plugin
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/manager.py", line 206, in get_instance
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     cls._create_instance()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/openstack/common/lockutils.py", line 
249, in inner
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return f(*args, 
**kwargs)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/manager.py", line 200, in 
_create_instance
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     cls._instance = cls()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/manager.py", line 112, in __init__
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     plugin_provider)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/manager.py", line 140, in 
_get_plugin_instance
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     return plugin_class()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/plugins/ml2/plugin.py", line 106, in 
__init__
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     
self.type_manager.initialize()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/plugins/ml2/managers.py", line 74, in 
initialize
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     driver.obj.initialize()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/plugins/ml2/drivers/type_vxlan.py", 
line 81, in initialize
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     
self._sync_vxlan_allocations()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/plugins/ml2/drivers/type_vxlan.py", 
line 172, in _sync_vxlan_allocations
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     session.add(alloc)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/session.py",
 line 402, in __exit__
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     self.commit()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/session.py",
 line 314, in commit
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     self._prepare_impl()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib64/python2.6/site-packages/SQLAlchemy-0.7.8-py2.6-linux-x86_64.egg/sqlalchemy/orm/session.py",
 line 298, in _prepare_impl
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     self.session.flush()
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/openstack/common/db/sqlalchemy/session.py",
 line 615, in _wrap
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     
_raise_if_duplicate_entry_error(e, get_engine().name)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service   File 
"/usr/lib/python2.6/site-packages/neutron/openstack/common/db/sqlalchemy/session.py",
 line 559, in _raise_if_duplicate_entry_error
  2014-04-14 11:42:18.315 6457 TRACE neutron.service     raise 
exception.DBDuplicateEntry(columns, integrity_error)
  2014-04-14 11:42:18.315 6457 TRACE neutron.service DBDuplicateEntry: 
(IntegrityError) (1062, "Duplicate entry '1' for key 'PRIMARY'") 'INSERT INTO 
ml2_vxlan_allocations (vxlan_vni, allocated) VALUES (%s, %s)' ((1, 0), (2, 0), 
(3, 0), (4, 0), (5, 0), (6, 0), (7, 0), (8, 0)  ... displaying 10 of 100000 
total bound parameter sets ...  (99999, 0), (100000, 0))
  2014-04-14 11:42:18.315 6457 TRACE neutron.service 
  2014-04-14 11:42:18.331 6457 CRITICAL neutron [-] (IntegrityError) (1062, 
"Duplicate entry '1' for key 'PRIMARY'") 'INSERT INTO ml2_vxlan_allocations 
(vxlan_vni, allocated) VALUES (%s, %s)' ((1, 0), (2, 0), (3, 0), (4, 0), (5, 
0), (6, 0), (7, 0), (8, 0)  ... displaying 10 of 100000 total bound parameter 
sets ...  (99999, 0), (100000, 0))

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to