Saturday, 2017-03-11

*** Syed__ has quit IRC00:45
*** VW_ has joined #craton01:14
*** VW has quit IRC01:14
*** VW_ has quit IRC01:54
*** VW has joined #craton01:54
openstackgerritJim Baker proposed openstack/craton master: JSON Path-like querying for variables  https://review.openstack.org/44394103:41
*** Guest4565 has joined #craton04:09
*** Guest4565 has quit IRC04:13
*** Guest4565 has joined #craton04:18
*** Guest4565 has left #craton04:44
openstackgerritiswarya vakati proposed openstack/craton master: Replaces uuid.uuid4 with uuidutils.generate_uuid()  https://review.openstack.org/44456208:09
*** gk- has joined #craton11:09
*** gk- has quit IRC11:10
*** VW has quit IRC12:01
*** VW has joined #craton12:01
*** VW has quit IRC12:12
*** VW has joined #craton12:12
*** VW has quit IRC12:17
thomasemThanks for the assist jimbaker17:17
thomasemCan we also get a workflow +1 on this? https://review.openstack.org/43350517:18
thomasemIt's pretty straightforward.17:18
thomasemAnyway, not going to be on long. Just hopped on to grok the changes made to the JSON path patch. :)17:19
thomasemKeep on having a lovely weekend!17:19
jimbakerthomasem, hey, saw your responses as emails17:27
jimbakerso wanted to move the conversation briefly over here17:27
jimbakerre subqueries - what i mean by this is that we construct queries based on the original query; mix with procedural code; and give it enough to continue on its merry way17:27
jimbakerall of it is in the scope of the same transaction17:28
jimbakerwhich by default in mysql innodb is repeatable read (which works well for us imho)17:28
jimbakerhttps://dev.mysql.com/doc/refman/5.7/en/innodb-transaction-isolation-levels.html#isolevel_repeatable-read17:29
jimbakeranyway, i need to get out of here. i will revisit this question of overrides later this evening. i think i have some ideas on how to fix; and they should be fairly straightforward to implement — and not so much code17:32
thomasemjimbaker: ahhhhhhhh, I see. So, it's not as big an issue as it seems, then, since it's working from the same snapshot? Going to dig in a bit. I didn't know about that nuance.21:09
thomasemI think that's what thread_id is here? https://gist.github.com/thomasem/5580ad0d340bf3a2f79003d436f435f4 so, we can see all of those SELECTs happening in thread_id 14.21:21
thomasemYeah, let's dig in on Monday regarding the descendants problem you're referring to, if that's cool. I'm a more kinesthetic/visual guy, so I'll want to set up the scenario and see the bug. :)21:29
thomasemThat gist contains all of the queries generated by doing: $ curl -s 'http://127.0.0.1:8080/v1/hosts?details=all&vars=nova_console_type:"novnc",glance_default_store:"swift"' -H "Content-Type: application/json" -H "X-Auth-Token: demo_root" -H "X-Auth-User: demo_root" -H "X-Auth-Project: b9f10eca66ac4c279c139d01e65f96b4"21:31
thomasemFYI21:32

Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!