← Back to team overview

yahoo-eng-team team mailing list archive

  1. yahoo-eng-team team
  2. Mailing list archive
  3. Message #17282

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

  Thread Previous • Date Previous • • Thread Next 
Public bug reported:

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

** Affects: neutron
     Importance: Undecided
         Status: New

-- 
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):
  New

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

Follow ups

References

  Thread Previous • Date Previous • • Thread Next