← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1341875] Re: BDuplicateEntry: (IntegrityError) on create_port

 

[Expired for neutron because there has been no activity for 60 days.]

** Changed in: neutron
       Status: Incomplete => Expired

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

Title:
  BDuplicateEntry: (IntegrityError) on create_port

Status in OpenStack Neutron (virtual network service):
  Expired

Bug description:
  Not quite sure why this is occurring:

  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource Traceback (most recent call last):
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/api/v2/resource.py", line 84, in resource
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     result = method(request=request, **args)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/api/v2/base.py", line 406, in create
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     obj = obj_creator(request.context, **kwargs)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/plugins/nicira/NeutronPlugin.py", line 1129, in create_port
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     neutron_db = super(NvpPluginV2, self).create_port(context, port)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/db/db_base_plugin_v2.py", line 1326, in create_port
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     context.session.add(allocated)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 447, in __exit__
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     self.rollback()
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 58, in __exit__
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     compat.reraise(exc_type, exc_value, exc_tb)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 444, in __exit__
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     self.commit()
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 354, in commit
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     self._prepare_impl()
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 334, in _prepare_impl
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     self.session.flush()
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py", line 541, in _wrap
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     _raise_if_duplicate_entry_error(e, get_engine().name)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource   File "/usr/lib/python2.7/dist-packages/neutron/openstack/common/db/sqlalchemy/session.py", line 492, in _raise_if_duplicate_entry_error
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource     raise exception.DBDuplicateEntry(columns, integrity_error)
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry '172.16.112.12-0f115b59-09c7-44c9-b1b1-4544be29dbdb-999f1e44-cf12' for key 'PRIMARY'") 'INSERT INTO ipallocations (port_id, ip_address, subnet_id, network_id) VALUES (%s, %s, %s, %s)' (('c0443f0a-c4e9-4127-99da-608f6e1ba7a4', '172.16.112.12', '0f115b59-09c7-44c9-b1b1-4544be29dbdb', '999f1e44-cf12-40e5-9f50-aaf34a04249c'), ('c0443f0a-c4e9-4127-99da-608f6e1ba7a4', '172.16.112.12', '0f115b59-09c7-44c9-b1b1-4544be29dbdb', '999f1e44-cf12-40e5-9f50-aaf34a04249c'))
  2014-07-11 16:50:35.303 1487 TRACE neutron.api.v2.resource 

  
  </SNIP>

  
  <SNIP>

  2014-07-11 17:21:31.839 1487 TRACE neutron.api.v2.resource
  DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry
  '192.168.100.12-28b44565-13a9-431e-9901-3e37a273f1d4-6de758a8-b60' for
  key 'PRIMARY'") 'INSERT INTO ipallocations (port_id, ip_address,
  subnet_id, network_id) VALUES (%s, %s, %s, %s)'
  (('f0e75025-4b79-4b80-8cc0-71dec5653edc', '192.168.100.12',
  '28b44565-13a9-431e-9901-3e37a273f1d4', '6de758a8-b606-4185-87ea-
  8f282294404c'), ('f0e75025-4b79-4b80-8cc0-71dec5653edc',
  '192.168.100.12', '28b44565-13a9-431e-9901-3e37a273f1d4',
  '6de758a8-b606-4185-87ea-8f282294404c<92>))

  </SNIP>

  <SNIP>

  2014-07-11 17:28:18.088 1487 TRACE neutron.api.v2.resource
  DBDuplicateEntry: (IntegrityError) (1062, "Duplicate entry
  '192.168.111.12-1c084d54-ca4d-4d86-bb74-3e8e93d417a0-287c7b09-7f5' for
  key 'PRIMARY'") 'INSERT INTO ipallocations (port_id, ip_address,
  subnet_id, network_id) VALUES (%s, %s, %s, %s)'
  (('a5bc4187-6c6e-4544-bc16-60105aad2b79', '192.168.111.12', '1c084d54
  -ca4d-4d86-bb74-3e8e93d417a0',
  '287c7b09-7f55-4c24-b714-03e9da92b9b7'),
  ('a5bc4187-6c6e-4544-bc16-60105aad2b79', '192.168.111.12', '1c084d54
  -ca4d-4d86-bb74-3e8e93d417a0',
  '287c7b09-7f55-4c24-b714-03e9da92b9b7'))

  </SNIP>
  ~

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


References