Lbaas Vip creation on ACI setups are failing with following DB error.
2016-11-25 21:31:57.465 4205 ERROR neutron.api.v2.resource (orm_util.state_str(state), self.key)
2016-11-25 21:31:57.465 4205 ERROR neutron.api.v2.resource DetachedInstanceError: Parent instance <Vip at 0x9da01d0> is not bound to a Session; lazy load operation of attribute 'port' cannot proceed
2016-11-25 21:31:57.465 4205 ERROR neutron.api.v2.resource
2016-11-25 21:31:57.493 4205 INFO neutron.wsgi [req-6878eb38-d56e-4c2d-854d-86ce60c1d4f5 aeb31202cdb34999aa5f3ae782d2d0b4 16d02722e6004a84a48fcdd53ab91183 - - -] 10.105.1.40 - - [25/Nov/2016 21:31:57] "POST /v2.0/lb/vips.json HTTP/1.1" 500 383 0.518860
Observed same failure with both NFP-loadbalancer provider and default haproxy provider.
Full Traceback :
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource [req-91a58ada-3836-4d99-b02a-0fcb08802c7f ddc665a2825c401293ac76fc52aec8bf 1d0c01c0c24940f6ba437a222bb22eb4 - - -] create failed
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource Traceback (most recent call last):
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron/api/v2/resource.py", line 84, in resource
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource result = method(request=request, **args)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 410, in create
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource return self._create(request, body, **kwargs)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 148, in wrapper
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource ectxt.value = e.inner_exc
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource self.force_reraise()
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 138, in wrapper
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource return f(*args, **kwargs)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 521, in _create
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource obj = do_create(body)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 503, in do_create
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource request.context, reservation.reservation_id)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource self.force_reraise()
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource six.reraise(self.type_, self.value, self.tb)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron/api/v2/base.py", line 496, in do_create
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource return obj_creator(request.context, **kwargs)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron_lbaas/services/loadbalancer/plugin.py", line 147, in create_vip
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource v = super(LoadBalancerPlugin, self).create_vip(context, vip)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron_lbaas/db/loadbalancer/loadbalancer_db.py", line 416, in create_vip
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource return self._make_vip_dict(vip_db)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib/python2.7/site-packages/neutron_lbaas/db/loadbalancer/loadbalancer_db.py", line 239, in _make_vip_dict
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource if vip.port:
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 237, in __get__
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource return self.impl.get(instance_state(instance), dict_)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/attributes.py", line 583, in get
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource value = self.callable_(state, passive)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/strategies.py", line 505, in _load_for_state
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource (orm_util.state_str(state), self.key)
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource DetachedInstanceError: Parent instance <Vip at 0x872ddd0> is not bound to a Session; lazy load operation of attribute 'port' cannot proceed
2016-10-21 00:49:07.721 24251 ERROR neutron.api.v2.resource