provisioning_blocks NeutronDbObjectDuplicateEntry exception

[Zhengwei Gao]

When hot migrating instance, It was error with log:

2017-06-16 11:56:14.527 37207 ERROR neutron.plugins.ml2.managers File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2017-06-16 11:56:14.527 37207 ERROR neutron.plugins.ml2.managers context)
2017-06-16 11:56:14.527 37207 ERROR neutron.plugins.ml2.managers File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2017-06-16 11:56:14.527 37207 ERROR neutron.plugins.ml2.managers
2017-06-16 11:56:14.527 37207 ERROR neutron.plugins.ml2.managers DBDuplicateEntry: (pymysql.err.IntegrityError) (1062, u"Duplicate entry '2969-L2' for key 'PRIMARY'") [SQL: u'INSERT INTO provisioningblocks (standard_attr_id, entity) VALUES (%s, %s)'] [parameters: (2969, 'L2')]
2017-06-16 11:56:14.527 37207 ERROR neutron.plugins.ml2.managers
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource [req-a8effb59-0563-4638-8f0e-342019185570 1ce07f2de1f3401b81e043a41d415b1c 0e705ba9f41a49c7aca8e61d32082022 - - -] update failed
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource Traceback (most recent call last):
......................
"/usr/lib/python2.7/site-packages/neutron/plugins/ml2/managers.py", line 660, in update_port_precommit
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource raise_db_retriable=True)
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/managers.py", line 424, in _call_on_drivers
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource method=method_name
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource MechanismDriverError: update_port_precommit failed.
2017-06-16 11:56:14.533 37207 ERROR neutron.api.v2.resource
2017-06-16 11:56:14.536 37207 INFO neutron.wsgi [req-a8effb59-0563-4638-8f0e-342019185570 1ce07f2de1f3401b81e043a41d415b1c 0e705ba9f41a49c7aca8e61d32082022 - - -] 10.11.108.32,10.11.108.211 - - [16/Jun/2017 11:56:14] "PUT /v2.0/ports/fcbb6a33-1207-4238-b0fa-7509944038d8.json HTTP/1.1" 500 317 0.395132

Detail log: http://paste.openstack.org/show/613233/

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/475995

[OpenStack Infra (hudson-openstack)]

Change abandoned by Armando Migliaccio (<email address hidden>) on branch: master
Review: https://review.openstack.org/475995
Reason: This review is > 3 months without comment and currently blocked by a core reviewer with a -1. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and contacting the reviewer with the -1 on this review to ensure you address their concerns.

[Rodolfo Alonso (rodolfo-alonso-hernandez)]

Bug closed due to lack of activity, please feel free to reopen if needed.