<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Let me try to fix the bug filed by
nachi at
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<a href="https://bugs.launchpad.net/quantum/+bug/1086173">https://bugs.launchpad.net/quantum/+bug/1086173</a><br>
On 12/04/2012 06:39 AM, Salvatore Orlando wrote:<br>
</div>
<blockquote
cite="mid:CAGR=i3hVL5bW3gSsRGxXq+tTaH84XEMnXv+BnPdWhYOLebNt8A@mail.gmail.com"
type="cite">
<pre wrap="">I've looked at <a class="moz-txt-link-freetext" href="https://review.openstack.org/#/c/16596/">https://review.openstack.org/#/c/16596/</a>, and I agree we
need to do the same in Quantum.
Salvatore
On 3 December 2012 22:18, gong yong sheng <a class="moz-txt-link-rfc2396E" href="mailto:gongysh@linux.vnet.ibm.com"><gongysh@linux.vnet.ibm.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">It seems easy to fix it.
On 12/04/2012 06:03 AM, Nachi Ueno wrote:
Hi Quantum folks
This bp for nova looks like solve the quantum one also.
<a class="moz-txt-link-freetext" href="https://blueprints.launchpad.net/nova/+spec/non-blocking-db">https://blueprints.launchpad.net/nova/+spec/non-blocking-db</a>
2012/12/3 Nachi Ueno <a class="moz-txt-link-rfc2396E" href="mailto:nachi@nttmcl.com"><nachi@nttmcl.com></a>
</pre>
<blockquote type="cite">
<pre wrap="">
Hi Quantum folks
I faced the problem with mysql transaction and eventlet.
Quantum using transaction support of sqlalchemy
Quantum also using eventlet for RPC
Let's say there are api request A and B.
Sql request of A will lock B's sql request.
so B's sql request will wait the A's transaction.
On the other hand, we are using evenetlet.
Since we are using mysql c client, the API request may block eventlet
thread.
so when B start wait sql lock, it blocks all eventlet thread including api
request A until lock timeout.
I asked Jay about the this problem, and he said Nova solve this problem by
this way.
<a class="moz-txt-link-freetext" href="https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L2610">https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L2610</a>
The strategy is to get lock just after the transaction started using. (
I'm not sure we can use same strategy in the quantum. )
Anyway, It looks big change needed for me.
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
OpenStack-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
_______________________________________________
OpenStack-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
</blockquote>
<pre wrap="">
_______________________________________________
OpenStack-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:OpenStack-dev@lists.openstack.org">OpenStack-dev@lists.openstack.org</a>
<a class="moz-txt-link-freetext" href="http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev">http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>