[openstack-dev] [oslo.db][sqlalchemy][mistral] Configuring default transaction isolation level

gord chung gord at live.ca
Tue Dec 8 12:49:43 UTC 2015

we had this in ceilometer events. you can see it here: 

note, that patch is removing it because it slowed everything way down 
because of locking. if you can avoid it, avoid it.

On 08/12/2015 7:28 AM, Renat Akhmerov wrote:
> Hi,
> Moshe, thanks a lot for bringing this up. I remember I tried to find a 
> way to change isolation level per connection but also was unable to do 
> that.
> An advice from oslo team would be very helpful.
> Renat Akhmerov
> @ Mirantis Inc.
>> On 08 Dec 2015, at 13:41, ELISHA, Moshe (Moshe) 
>> <moshe.elisha at alcatel-lucent.com 
>> <mailto:moshe.elisha at alcatel-lucent.com>> wrote:
>> Hi,
>> We at Mistral want to move from the default transaction isolation 
>> level of REPEATABLE READ to READ COMMITTED as part of a bugfix[1].
>> I did not find a way to pass the isolation level to sqlachemy using 
>> oslo.db and the current solution is to use monkey-patching[2] that 
>> adds the “isolation_level” property.
>> Is there currently a better way to set the default isolation level?
>> If not – I will create a BP for it.
>> Thanks.
>> [1]https://review.openstack.org/#/c/253819
>> [2]https://review.openstack.org/#/c/253819/11/mistral/db/sqlalchemy/base.py
>> __________________________________________________________________________
>> OpenStack Development Mailing List (not for usage questions)
>> Unsubscribe:OpenStack-dev-request at lists.openstack.org 
>> <mailto:OpenStack-dev-request at lists.openstack.org>?subject:unsubscribe
>> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
> __________________________________________________________________________
> OpenStack Development Mailing List (not for usage questions)
> Unsubscribe: OpenStack-dev-request at lists.openstack.org?subject:unsubscribe
> http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-dev/attachments/20151208/4acf71c7/attachment.html>

More information about the OpenStack-dev mailing list