Hi! Can you point what mechanism driver is this or the piece of code that give this error?
On Mon, Jan 11, 2016 at 11:58 AM, Koteswar <koti.ke...@gmail.com> wrote: > 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 > > __________________________________________________________________________ > OpenStack Development Mailing List (not for usage questions) > Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe > http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev > > -- Regards, Ann Kamyshnikova Mirantis, Inc
__________________________________________________________________________ OpenStack Development Mailing List (not for usage questions) Unsubscribe: openstack-dev-requ...@lists.openstack.org?subject:unsubscribe http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev