Open Stack

Hi All,



In my mechanism driver, I am reading/writing into sql db in a fixed
interval looping call. Sometimes I get the following error when I stop and
start neutron server

InvalidRequestError: This session is in 'prepared' state; no further SQL
can be emitted within this transaction.



I am using context.session.query() for add, delete, update and get. Please
help me if any one resolved an issue like this.



Full trace is as follows:

2016-01-06 15:33:21.799 [01;31mERROR neutron.plugins.ml2.managers
[[01;36mreq-d940a1b6-253a-43d2-b5ff-6c784c8a520f [00;36madmin
83b5358da62a407f88155f447966356f[01;31m] [01;35m[01;31mMechanism driver
'hp' failed in create_port_precommit[00m

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00mTraceback (most recent call last):

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00m  File "/opt/stack/neutron/neutron/plugins/ml2/managers.py",
line 394, in _call_on_drivers

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00m    getattr(driver.obj, method_name)(context)

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00m  File
"/usr/local/lib/python2.7/dist-packages/baremetal_network_provisioning/ml2/mechanism_hp.py",
line 67, in create_port_precommit

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00m    raise e

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00mInvalidRequestError: This session is in 'prepared' state; no
further SQL can be emitted within this transaction.

[01;31m2016-01-06 15:33:21.799 TRACE neutron.plugins.ml2.managers
[01;35m[00m

2016-01-06 15:33:21.901 [01;31mERROR neutron.api.v2.resource
[[01;36mreq-d940a1b6-253a-43d2-b5ff-6c784c8a520f [00;36madmin
83b5358da62a407f88155f447966356f[01;31m] [01;35m[01;31mcreate failed[00m

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource
[01;35m[00mTraceback (most recent call last):

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/api/v2/resource.py", line 83, in resource

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
result = method(request=request, **args)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 146, in
wrapper

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
ectxt.value = e.inner_exc

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line
195, in __exit__

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
six.reraise(self.type_, self.value, self.tb)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 136, in
wrapper

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
return f(*args, **kwargs)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/api/v2/base.py", line 516, in create

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
obj = do_create(body)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/api/v2/base.py", line 498, in do_create

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
request.context, reservation.reservation_id)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line
195, in __exit__

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
six.reraise(self.type_, self.value, self.tb)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/api/v2/base.py", line 491, in do_create

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
return obj_creator(request.context, **kwargs)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 146, in
wrapper

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
ectxt.value = e.inner_exc

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line
195, in __exit__

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
six.reraise(self.type_, self.value, self.tb)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 136, in
wrapper

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
return f(*args, **kwargs)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 1040, in
create_port

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
result, mech_context = self._create_port_db(context, port)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/plugins/ml2/plugin.py", line 1032, in
_create_port_db

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
self.mechanism_manager.create_port_precommit(mech_context)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 590, in
create_port_precommit

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
self._call_on_drivers("create_port_precommit", context)

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
File "/opt/stack/neutron/neutron/plugins/ml2/managers.py", line 405, in
_call_on_drivers

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m
method=method_name

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource
[01;35m[00mMechanismDriverError: create_port_precommit failed.

[01;31m2016-01-06 15:33:21.901 TRACE neutron.api.v2.resource [01;35m[00m



Regards,

Koteswar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20160111/bac67a2f/attachment.html>