Wednesday, 2015-11-25

*** yamahata has quit IRC00:01
openstackrecheckConsole logs not available after 14:13s for gate-cinder-python27 249358,1,0aa171300:19
*** markvoelker has quit IRC00:26
*** dims has joined #openstack-qa00:30
*** dims_ has quit IRC00:31
*** akshai_ has quit IRC00:31
*** dmorita has joined #openstack-qa00:32
*** mylu_ has quit IRC00:37
openstackrecheckConsole logs not available after 14:13s for gate-tempest-dsvm-large-ops 249475,2,0617d4a00:39
*** mylu has joined #openstack-qa00:39
*** yamamoto has joined #openstack-qa00:44
*** yamamoto has quit IRC00:46
openstackgerritMasayuki Igawa proposed openstack/os-testr: Add *.egg* to .gitignore  https://review.openstack.org/24900800:47
*** Swami has quit IRC00:53
openstackrecheckConsole logs not available after 14:10s for gate-nova-python27 127427,50,963bbac00:53
openstackgerritMerged openstack/os-testr: Add *.egg* to .gitignore  https://review.openstack.org/24900800:55
*** yamamoto has joined #openstack-qa00:55
*** yamamoto has quit IRC00:55
*** yamamoto has joined #openstack-qa00:56
*** bknudson has quit IRC00:56
*** bknudson has joined #openstack-qa00:58
*** yamamoto has quit IRC00:58
*** hoangcx has joined #openstack-qa00:59
*** hoangcx has left #openstack-qa00:59
*** ajmiller has quit IRC00:59
*** jacky_zhang has joined #openstack-qa00:59
*** salv-orl_ has quit IRC01:01
*** openstackrecheck has quit IRC01:02
*** yamahata has joined #openstack-qa01:03
*** zhangjn has joined #openstack-qa01:05
*** eil397 has quit IRC01:06
*** hitalia has quit IRC01:06
*** eil397 has joined #openstack-qa01:11
*** Swami has joined #openstack-qa01:14
*** glauco__ has joined #openstack-qa01:22
*** glauco has quit IRC01:22
*** markvoelker has joined #openstack-qa01:27
*** Liuqing has joined #openstack-qa01:29
*** markvoelker has quit IRC01:31
*** hitalia has joined #openstack-qa01:38
*** tochi has quit IRC01:39
*** yamamoto has joined #openstack-qa01:40
*** tochi has joined #openstack-qa01:44
*** mylu has quit IRC01:47
*** Swami has quit IRC01:48
*** zhangjn has quit IRC01:49
*** EinstCrazy has joined #openstack-qa01:51
*** mriedem has joined #openstack-qa01:52
*** shuquan has joined #openstack-qa01:52
*** zhangjn has joined #openstack-qa01:52
*** mylu has joined #openstack-qa01:53
*** eil397 has quit IRC01:56
*** shuquan has quit IRC02:01
*** shuquan has joined #openstack-qa02:09
*** glauco__ has quit IRC02:10
*** mtanino has quit IRC02:13
*** shuquan has quit IRC02:17
*** shuquan has joined #openstack-qa02:23
*** markvoelker has joined #openstack-qa02:28
openstackgerritMerged openstack/tempest: Drop fixed_network dependency from CONF  https://review.openstack.org/24046702:30
*** markvoelker has quit IRC02:33
*** shuquan has quit IRC02:36
*** jdandrea has quit IRC02:38
*** dims has quit IRC02:39
*** hitalia has quit IRC02:41
*** Triveni has joined #openstack-qa02:43
openstackgerritMerged openstack/tempest: Use Tempest-lib's compute migrations_client  https://review.openstack.org/24041602:45
*** eil397 has joined #openstack-qa03:04
*** salv-orlando has joined #openstack-qa03:05
*** eil397 has quit IRC03:10
*** eil397 has joined #openstack-qa03:11
*** dramalho has joined #openstack-qa03:11
*** mriedem has quit IRC03:13
*** dramalho has quit IRC03:16
*** binbincong has joined #openstack-qa03:21
*** mtanino has joined #openstack-qa03:21
*** tochi has quit IRC03:28
*** markvoelker has joined #openstack-qa03:29
*** weshay has quit IRC03:32
*** Triveni has quit IRC03:34
*** markvoelker has quit IRC03:34
*** markvoelker has joined #openstack-qa03:35
openstackgerritMasayuki Igawa proposed openstack/os-testr: Add colored output feature to subunit-trace  https://review.openstack.org/24900503:37
*** salv-orlando has quit IRC03:38
*** bkopilov has quit IRC03:38
*** boris-42 has quit IRC03:38
*** achanda has joined #openstack-qa03:41
*** hichihara has joined #openstack-qa03:48
*** zhangjn has quit IRC03:51
*** achanda has quit IRC03:51
*** salv-orlando has joined #openstack-qa03:51
*** salv-orlando has quit IRC03:56
*** tochi has joined #openstack-qa04:08
openstackgerritMasayuki Igawa proposed openstack/os-testr: Add colored output feature to subunit-trace  https://review.openstack.org/24900504:08
openstackgerritMasayuki Igawa proposed openstack/os-testr: Add colored output feature to subunit-trace  https://review.openstack.org/24900504:15
openstackgerritBin Bin Cong proposed openstack/tempest: Implement keystone v3 case test_authentication_with_invalid_domain  https://review.openstack.org/24293204:19
*** SridharG has joined #openstack-qa04:19
*** Liuqing has quit IRC04:41
*** Liuqing has joined #openstack-qa04:42
openstackgerritJacky_lei_zhang proposed openstack/tempest: Fix some inconsistency in docstrings  https://review.openstack.org/24954804:42
*** hichihara has quit IRC04:43
*** bochi-michael has joined #openstack-qa04:49
*** mtanino has quit IRC04:59
*** rossella_s has quit IRC05:14
*** rossella_s has joined #openstack-qa05:14
*** salv-orlando has joined #openstack-qa05:18
*** shausy has joined #openstack-qa05:21
*** salv-orlando has quit IRC05:24
*** zhangjn has joined #openstack-qa05:28
*** bkopilov has joined #openstack-qa05:29
openstackgerritGhanshyam Mann proposed openstack/tempest: Adding script to use tempest-lib files in tempest  https://review.openstack.org/24956005:31
gmannmtreinish: oomichi: masayukig : andreaf : mkoderer_ JordonP : please have look adding script to use lib files in tempest - https://review.openstack.org/#/c/249560/105:34
gmannit will be nice to avoid manual deletion of files from tempest05:34
*** Triveni has joined #openstack-qa05:42
*** bkopilov has quit IRC05:46
*** Liuqing has quit IRC05:47
*** Liuqing has joined #openstack-qa05:48
*** amotoki has quit IRC05:49
*** Poornima has joined #openstack-qa05:49
*** SridharG has left #openstack-qa05:50
*** hitalia has joined #openstack-qa05:55
*** nadya_ has joined #openstack-qa05:56
*** nadya_ has quit IRC05:58
*** amotoki has joined #openstack-qa06:01
*** asselin has quit IRC06:04
*** asselin has joined #openstack-qa06:04
*** jasonsb has joined #openstack-qa06:09
*** amotoki has quit IRC06:10
*** binbincong has quit IRC06:11
*** pcrews has quit IRC06:12
*** amotoki has joined #openstack-qa06:15
*** pcrews has joined #openstack-qa06:16
*** rcernin has joined #openstack-qa06:19
*** yamamoto has quit IRC06:22
*** yamamoto has joined #openstack-qa06:23
*** bkopilov has joined #openstack-qa06:27
*** binbincong has joined #openstack-qa06:29
*** jasonsb has quit IRC06:35
*** aopincar has joined #openstack-qa06:37
*** jasonsb has joined #openstack-qa06:37
*** Liuqing_ has joined #openstack-qa06:38
*** Liuqing has quit IRC06:39
*** amotoki has quit IRC06:39
*** zhangjn has quit IRC06:42
*** pcrews has quit IRC06:42
*** binbincong has quit IRC06:53
*** vgridnev has joined #openstack-qa06:54
*** neeti has joined #openstack-qa06:56
*** amotoki has joined #openstack-qa06:57
*** gamado has joined #openstack-qa06:58
*** SridharG has joined #openstack-qa06:58
*** nadya_ has joined #openstack-qa07:02
*** mylu has quit IRC07:03
*** mylu has joined #openstack-qa07:04
*** mylu has quit IRC07:08
*** armax has quit IRC07:08
*** itzikb has joined #openstack-qa07:09
*** shardy has joined #openstack-qa07:10
*** jasonsb has quit IRC07:10
*** binbincong has joined #openstack-qa07:12
*** yfried has joined #openstack-qa07:18
yfriedandreaf: gmann: https://review.openstack.org/#/c/246983 https://review.openstack.org/#/c/247542 could you please review ?07:26
yfriedmasayukig: ^07:26
*** dims has joined #openstack-qa07:35
*** fedexo has quit IRC07:36
*** anshul has joined #openstack-qa07:37
*** salv-orlando has joined #openstack-qa07:38
*** asselin has quit IRC07:39
*** dims_ has joined #openstack-qa07:39
*** asselin has joined #openstack-qa07:40
*** dims has quit IRC07:40
*** salv-orlando has quit IRC07:41
openstackgerritGhanshyam Mann proposed openstack/tempest: Use Tempest-lib's compute security_groups_client  https://review.openstack.org/24961807:44
*** rcernin_ has joined #openstack-qa07:47
*** tosky has joined #openstack-qa07:50
openstackgerritGhanshyam Mann proposed openstack/tempest: Use Tempest-lib's compute services_client  https://review.openstack.org/24962107:50
*** itzikb has quit IRC07:52
*** gszasz has joined #openstack-qa07:54
*** itzikb has joined #openstack-qa07:56
*** zhangjn has joined #openstack-qa07:59
openstackgerritGhanshyam Mann proposed openstack/tempest: Use snapshots_client from tempest-lib  https://review.openstack.org/24962308:00
*** zhangjn has quit IRC08:00
openstackgerritGhanshyam Mann proposed openstack/tempest: Adding script to use tempest-lib files in tempest  https://review.openstack.org/24956008:01
*** zhangjn has joined #openstack-qa08:01
*** e0ne has joined #openstack-qa08:07
openstackgerritGhanshyam Mann proposed openstack/tempest: Use tenant_networks_client from tempest-lib  https://review.openstack.org/24962508:08
*** e0ne has quit IRC08:12
openstackgerritGhanshyam Mann proposed openstack/tempest: Use tenant_usages_client from tempest-lib  https://review.openstack.org/24962608:15
*** zhangjn has quit IRC08:16
*** e0ne has joined #openstack-qa08:16
*** achanda has joined #openstack-qa08:19
*** hitalia has quit IRC08:22
*** eil397 has quit IRC08:24
*** vponomaryov has left #openstack-qa08:25
*** vgridnev has quit IRC08:26
*** vponomaryov has joined #openstack-qa08:26
ekarlsoso the plugin model for devstack doesn't do excercises ?08:26
*** e0ne has quit IRC08:28
*** zhangjn has joined #openstack-qa08:29
*** sshnaidm has joined #openstack-qa08:30
*** gfidente has joined #openstack-qa08:30
*** gfidente has quit IRC08:30
*** gfidente has joined #openstack-qa08:30
*** yfried_ has joined #openstack-qa08:30
*** yfried has quit IRC08:31
*** aopincar has quit IRC08:32
openstackgerritMotohiro/Yuanying Otsuka proposed openstack/tempest-lib: Make git log messsage to shorter  https://review.openstack.org/22767408:32
*** achanda has quit IRC08:33
*** e0ne has joined #openstack-qa08:33
*** tosky has quit IRC08:35
*** itsuugo has quit IRC08:36
*** neeti has quit IRC08:36
*** jlanoux has joined #openstack-qa08:41
*** maht has joined #openstack-qa08:42
*** tosky has joined #openstack-qa08:43
openstackgerritGhanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest  https://review.openstack.org/24956008:43
*** aopincar has joined #openstack-qa08:44
*** e0ne has quit IRC08:44
openstackgerritGuillaume Chenuet proposed openstack/tempest: When running Tempest test test_create_port_in_allowed_allocation_pools on a 3 controllers infra, we have this error: No more IP addresses available on network UUID.  https://review.openstack.org/24315908:44
*** anshul has quit IRC08:47
*** neeti has joined #openstack-qa08:50
*** aopincar has quit IRC08:50
*** jordanP has joined #openstack-qa08:51
*** anshul has joined #openstack-qa08:51
*** gamado has quit IRC08:51
*** yfried_ has quit IRC08:58
*** yfried has joined #openstack-qa08:58
openstackgerritGhanshyam Mann proposed openstack/tempest: Use versions_client, versions from tempest-lib  https://review.openstack.org/24964409:01
andreafgmann: nice work on https://review.openstack.org/#/c/249560, thanks09:09
andreafgmann: I only have once usability concern, see on the review09:09
*** itzikb_ has joined #openstack-qa09:10
*** mkoderer_ is now known as mkoderer09:11
*** achanda has joined #openstack-qa09:11
gmannandreaf: ok, Thanks for review. I will check09:11
*** itzikb has quit IRC09:11
*** shardy has quit IRC09:12
jacky_zhanghello everyone,i am a new people in tempest community....09:14
*** dtantsur|afk is now known as dtantsur09:14
*** nadya_ has quit IRC09:14
*** rossella_s has quit IRC09:14
*** rossella_s has joined #openstack-qa09:14
*** shardy has joined #openstack-qa09:14
*** Liuqing_ has quit IRC09:15
andreafjacky_zhang: welcome :)09:15
*** Liuqing has joined #openstack-qa09:15
andreafjacky_zhang, gmann, oomichi: I think we have a few places where you could start if you want to contribute and learn about QA tools such as tempest and tempest-lib09:16
bochi-michaeljacky_zhang:  hello09:16
jacky_zhangandreaf, thanks09:16
jacky_zhangbochi-michael, hello..09:16
andreafgmann, oomichi: do you have the link to the etherpad for the service client work at hand?09:17
gmannandreaf: yea, i sec09:17
gmannandreaf: jacky_zhang https://etherpad.openstack.org/p/mitaka-tempest-service-clients09:17
gmannit needs lot of work and good to start knowing QA09:18
andreafjacky_zhang: there are a good few sources of documentation on what we do in the QA team, e.g. http://docs.openstack.org/developer/tempest/ and http://docs.openstack.org/developer/tempest-lib/ and http://docs.openstack.org/developer/devstack/09:18
jacky_zhangok,thanks all,i will read it09:18
*** yfried has quit IRC09:18
andreafand the wiki: https://wiki.openstack.org/wiki/QA09:19
*** lezbar has quit IRC09:21
*** gamado has joined #openstack-qa09:25
*** salv-orlando has joined #openstack-qa09:27
*** salv-orlando has quit IRC09:28
*** lezbar has joined #openstack-qa09:28
*** salv-orlando has joined #openstack-qa09:29
openstackgerritMasayuki Igawa proposed openstack/tempest: Add run_stress to cliff-based cli framework  https://review.openstack.org/24039909:30
*** vgridnev has joined #openstack-qa09:31
openstackgerritMasayuki Igawa proposed openstack/tempest: Migrate verify-tempest-config to new cliff cli framework  https://review.openstack.org/24724009:33
*** dims_ has quit IRC09:34
*** itzikb has joined #openstack-qa09:37
*** Liuqing has quit IRC09:41
*** jacky_zhang has quit IRC09:41
*** itzikb_ has quit IRC09:41
*** achanda has quit IRC09:41
openstackgerritJordan Pittier proposed openstack/tempest: tempest/clients.py: always set the image_client attribute  https://review.openstack.org/24207609:42
*** dansmith has quit IRC09:42
*** aopincar has joined #openstack-qa09:45
*** dansmith has joined #openstack-qa09:45
*** dansmith is now known as Guest1115309:45
*** sshnaidm has quit IRC09:47
*** amotoki has quit IRC09:48
*** salv-orlando has quit IRC09:50
*** yfried has joined #openstack-qa09:51
*** bapalm has quit IRC09:53
*** bapalm has joined #openstack-qa09:55
*** salv-orlando has joined #openstack-qa09:57
*** nadya_ has joined #openstack-qa09:58
*** e0ne has joined #openstack-qa10:01
*** sshnaidm has joined #openstack-qa10:03
openstackgerritGhanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest  https://review.openstack.org/24956010:05
openstackgerritGuillaume Chenuet proposed openstack/tempest: When running Tempest test test_create_port_in_allowed_allocation_pools on a 3 controllers infra, we have this error: No more IP addresses available on network UUID.  https://review.openstack.org/24315910:05
*** Liuqing has joined #openstack-qa10:05
*** rcernin_ has quit IRC10:06
gmannandreaf: done. Nice point about error exit. I updated with checking all files first and if all are ok then proceed10:06
*** zhangjn has quit IRC10:09
*** EinstCrazy has quit IRC10:13
*** neeti has quit IRC10:13
*** yamamoto has quit IRC10:15
*** glauco has joined #openstack-qa10:16
openstackgerritDmitry Ratushnyy proposed openstack/tempest: Add scenario tests for arp poisoning.  https://review.openstack.org/24835510:16
andreafgmann: thanks for the update, I think there is one issue now with $1 left over in the function - see other comments as well10:20
*** Liuqing has quit IRC10:22
*** anshul has quit IRC10:22
openstackgerritIsaac Beckman proposed openstack-infra/devstack-gate: create GRE bridge interfaces only once  https://review.openstack.org/23936310:23
dmelladogmann: andreaf regarding the addition of tempest-config to tempest-cli that we chat about in latest meeting, would you care to comment in the ml when you've some time? thanks in advance! http://lists.openstack.org/pipermail/openstack-dev/2015-November/080398.html10:23
*** Liuqing has joined #openstack-qa10:23
dmelladojordanP: as well ;)10:23
openstackgerritBenny Kopilov proposed openstack/tempest: Change multi-backend configuration to a list  https://review.openstack.org/24341510:26
*** dtantsur is now known as dtantsur|brb10:29
*** Liuqing has quit IRC10:29
*** anshul has joined #openstack-qa10:30
*** Liuqing has joined #openstack-qa10:30
*** dmorita has quit IRC10:31
*** safchain has joined #openstack-qa10:33
gmannandreaf: ops, i will update thanks.10:37
*** yfried has quit IRC10:37
*** yfried_ has joined #openstack-qa10:37
*** yamahata has quit IRC10:43
*** tochi has quit IRC10:47
*** yamamoto has joined #openstack-qa10:53
*** yamamoto has quit IRC10:56
*** yamamoto has joined #openstack-qa10:57
*** rfolco_ has joined #openstack-qa10:58
*** glauco has quit IRC11:00
openstackgerritJordan Pittier proposed openstack/tempest: Add a volume extend scenario  https://review.openstack.org/24910011:01
*** k4n0 has joined #openstack-qa11:01
openstackgerritBenny Kopilov proposed openstack/tempest: Change multi-backend configuration to a list  https://review.openstack.org/24341511:08
jlanouxHi andreaf jordanP! Could you have a look at https://review.openstack.org/#/c/225575/ please?11:09
jordanPyep, it's wednesday !11:10
jlanouxjordanP: :) thanks!11:10
jordanPI am going to leave a "check experimental" comment and pray that it fails all over the place11:10
jordanPhahaha :evil:11:10
dmelladolol11:10
*** yamamoto_ has joined #openstack-qa11:11
*** itsuugo has joined #openstack-qa11:11
jlanouxand if it fails all over the place, I'm going to recheck again and again11:11
*** Guest11153 has quit IRC11:12
openstackgerritGhanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest  https://review.openstack.org/24956011:13
*** yamamoto has quit IRC11:15
*** dansmith has joined #openstack-qa11:15
*** dansmith is now known as Guest1050411:15
*** aysyd has joined #openstack-qa11:18
gmannsdague: mtreinish - Could you have look on microversion testing patches  - https://review.openstack.org/#/q/status:open+project:openstack/tempest+branch:master+topic:bp/api-microversions-testing-support,n,z11:18
*** yamamoto_ has quit IRC11:20
*** aysyd has quit IRC11:22
*** aysyd has joined #openstack-qa11:23
*** jacky-zhang has joined #openstack-qa11:24
*** yamamoto has joined #openstack-qa11:25
andreafjlanoux: I'll try later today11:26
jlanouxthanks andreaf11:27
*** NithyaG has joined #openstack-qa11:28
*** dtantsur|brb is now known as dtantsur11:28
*** Guest10504 has quit IRC11:29
*** glauco has joined #openstack-qa11:30
openstackgerritVasyl Saienko proposed openstack-dev/devstack: Add configure_provision_network function  https://review.openstack.org/24807411:30
openstackgerritVasyl Saienko proposed openstack-dev/devstack: Update VM network connection  https://review.openstack.org/24971711:30
*** wuhg has quit IRC11:31
*** dansmith_ has joined #openstack-qa11:31
*** apevec has joined #openstack-qa11:32
*** apevec has quit IRC11:32
*** apevec has joined #openstack-qa11:32
*** yamamoto has quit IRC11:32
openstackgerritIsaac Beckman proposed openstack-infra/devstack-gate: create GRE bridge interfaces only once  https://review.openstack.org/23936311:36
*** jamielennox is now known as jamielennox|away11:42
*** neeti has joined #openstack-qa11:43
jordanPandreaf, gmann hi. Could I have you opinion on https://review.openstack.org/#/c/248136 (Scenarios: cleanup class scope variable usage) It should be super easy to review11:48
jordanPthanks !11:48
*** zhangjn has joined #openstack-qa11:48
*** zhangjn has quit IRC11:49
ekarlsois using exercises deprecated when using the plugin model ?11:49
*** zhangjn has joined #openstack-qa11:49
jordanPekarlso, I don't think so. I think you could have your plugin to copy whatever you want in the exercices directory11:51
*** dansmith_ has quit IRC11:52
*** glauco has quit IRC11:52
jordanPbut sdague or dtroyer_zz should confirm when they are awake11:52
*** dansmith_ has joined #openstack-qa11:52
*** glauco has joined #openstack-qa11:52
*** amotoki has joined #openstack-qa11:54
*** dramalho has joined #openstack-qa11:57
*** gamado has quit IRC12:00
*** jamielennox|away is now known as jamielennox12:01
*** dramalho has quit IRC12:01
openstackgerritJoseph Lanoux proposed openstack/tempest: Migrate scenario tests ssh-auth-strategy  https://review.openstack.org/22557512:02
*** yamamoto has joined #openstack-qa12:02
*** dansmith_ is now known as dansmith12:04
*** dansmith is now known as Guest8784312:05
*** achanda has joined #openstack-qa12:05
*** jaypipes has joined #openstack-qa12:05
*** ChanServ sets mode: +o jaypipes12:05
openstackgerritGhanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest  https://review.openstack.org/24956012:10
*** EinstCrazy has joined #openstack-qa12:10
*** gamado has joined #openstack-qa12:15
*** maht has quit IRC12:15
openstackgerritGhanshyam Mann proposed openstack/tempest: Use Tempest-lib's compute volumes_client  https://review.openstack.org/24973412:17
*** neeti has quit IRC12:19
*** achanda has quit IRC12:24
*** achanda has joined #openstack-qa12:33
*** weshay_xchat has joined #openstack-qa12:35
*** achanda has quit IRC12:41
*** dims has joined #openstack-qa12:42
*** Triveni has quit IRC12:43
*** Poornima has quit IRC12:43
openstackgerritDmitry Ratushnyy proposed openstack/tempest: Add scenario tests for arp poisoning.  https://review.openstack.org/24835512:45
*** weshay_xchat is now known as weshahy12:46
*** weshahy is now known as weshay12:46
*** e0ne_ has joined #openstack-qa12:48
*** boris-42 has joined #openstack-qa12:49
*** k4n0 has quit IRC12:49
*** jaypipes_ has joined #openstack-qa12:51
*** e0ne has quit IRC12:51
*** jaypipes has quit IRC12:51
*** jaypipes_ is now known as jaypipes12:53
*** anshul has quit IRC12:54
*** korzen has joined #openstack-qa12:59
*** bkopilov has quit IRC13:00
*** bochi-michael has quit IRC13:02
*** gamado has quit IRC13:02
*** asselin has quit IRC13:04
*** asselin has joined #openstack-qa13:04
*** jaypipes has quit IRC13:04
*** yamamoto has quit IRC13:05
*** aopincar has quit IRC13:05
*** david-lyle has quit IRC13:09
*** salv-orlando has quit IRC13:12
*** rossella_s has quit IRC13:14
*** rossella_s has joined #openstack-qa13:14
*** isaacb has joined #openstack-qa13:15
isaacbDoes anyone knows what's the story with: gate-grenade-dsvm-multinode13:16
*** maht has joined #openstack-qa13:16
*** gamado has joined #openstack-qa13:18
*** yamamoto has joined #openstack-qa13:19
*** tnguyen1 has joined #openstack-qa13:20
*** maht has quit IRC13:20
*** gamado has quit IRC13:23
*** salv-orlando has joined #openstack-qa13:23
*** salv-orlando has quit IRC13:24
*** salv-orlando has joined #openstack-qa13:25
ekarlsosdague: dtantsur u about ?13:25
dtantsuro/13:26
isaacbgate-grenade-dsvm-multinode always fails13:28
isaacbsomething with ssh timout13:28
*** maht has joined #openstack-qa13:29
*** jordanP has quit IRC13:30
*** itzikb has quit IRC13:38
*** jaypipes has joined #openstack-qa13:57
*** ChanServ sets mode: +o jaypipes13:57
*** dkranz has joined #openstack-qa13:57
*** shausy has quit IRC14:03
*** zz_dimtruck is now known as dimtruck14:05
*** openstackgerrit has quit IRC14:06
*** openstackgerrit has joined #openstack-qa14:07
*** gfidente has quit IRC14:13
*** gfidente has joined #openstack-qa14:14
*** gfidente has quit IRC14:14
*** gfidente has joined #openstack-qa14:14
*** jacky-zhang has quit IRC14:14
*** gfidente has quit IRC14:18
*** gfidente has joined #openstack-qa14:18
*** rcernin has quit IRC14:19
isaacbsdague: can you help understand why gate-grenade-dsvm-multinode fails14:19
*** artom has joined #openstack-qa14:22
*** yamamoto has quit IRC14:23
*** mylu has joined #openstack-qa14:26
*** openstackrecheck has joined #openstack-qa14:27
*** dimtruck is now known as zz_dimtruck14:28
*** mylu has quit IRC14:31
*** Guest87843 is now known as dansmith14:32
*** gfidente is now known as gfidente|lunch14:33
*** zz_dimtruck is now known as dimtruck14:34
*** Swami has joined #openstack-qa14:35
*** mylu has joined #openstack-qa14:37
*** yamamoto has joined #openstack-qa14:40
*** dramalho has joined #openstack-qa14:43
*** akshai has joined #openstack-qa14:47
*** jordanP has joined #openstack-qa14:47
*** dramalho has quit IRC14:48
openstackgerritRuby Loo proposed openstack-dev/devstack: Set unprovision and active timeout to match build_timeout  https://review.openstack.org/24833014:52
*** bkopilov has joined #openstack-qa14:55
*** SridharG has left #openstack-qa15:04
*** mylu has quit IRC15:09
*** e0ne_ has quit IRC15:09
*** rbak has joined #openstack-qa15:09
*** mylu has joined #openstack-qa15:10
*** e0ne has joined #openstack-qa15:11
*** rbrndt has joined #openstack-qa15:13
*** mylu has quit IRC15:15
*** aix has quit IRC15:16
openstackgerritMerged openstack/tempest: Use Tempest-lib's compute networks_client  https://review.openstack.org/24042115:17
*** jecarey has joined #openstack-qa15:18
openstackgerritViswanath proposed openstack-dev/devstack: Fixing error: cp: cannot create regular file '/etc/cinder/api-paste.ini': Permission denied  https://review.openstack.org/24984615:20
openstackgerritMerged openstack/tempest: Use Tempest-lib's compute quota_classes_client  https://review.openstack.org/24899915:21
*** mtanino has joined #openstack-qa15:28
*** vgridnev has quit IRC15:30
openstackgerritLance Bragstad proposed openstack/tempest: Fix race condition when changing passwords for admin tests  https://review.openstack.org/24986315:46
openstackgerritLance Bragstad proposed openstack-dev/devstack: TEST: use fernet  https://review.openstack.org/19578015:47
*** aix has joined #openstack-qa15:49
ekarlsosdague: u about ? How does the whole exercise stuff work with plugins15:53
openstackgerritDaniel Mellado proposed openstack/tempest: [WIP] Split out keystone tenant client  https://review.openstack.org/24817015:58
*** pcrews has joined #openstack-qa15:58
*** boris-42 has quit IRC15:58
*** zhangjn has quit IRC16:00
*** ccneill has joined #openstack-qa16:04
*** nicholasgoracke has joined #openstack-qa16:08
*** dims has quit IRC16:09
*** jdandrea has joined #openstack-qa16:09
*** jdandrea has quit IRC16:09
*** armax has joined #openstack-qa16:10
*** jdandrea has joined #openstack-qa16:10
*** dims has joined #openstack-qa16:11
*** jdandrea has quit IRC16:11
*** jdandrea has joined #openstack-qa16:12
*** EinstCrazy has quit IRC16:14
openstackgerritGuillaume Chenuet proposed openstack/tempest: When running Tempest test test_create_port_in_allowed_allocation_pools on a 3 controllers infra, we have this error: No more IP addresses available on network UUID.  https://review.openstack.org/24315916:19
*** vgridnev has joined #openstack-qa16:28
*** achanda has joined #openstack-qa16:32
*** fedexo has joined #openstack-qa16:35
jordanPhi mtreinish. Can I ask you to do a quick review of https://review.openstack.org/#/c/248136/ (Scenarios: cleanup class scope variable usage) please ? It shouldn't take more than 5min :)16:36
mtreinishjordanP: sure, one sec16:36
jordanPthanks !16:37
mtreinishjordanP: +A16:39
jordanPawesome, thanks16:39
*** Liuqing has quit IRC16:40
*** ajmiller has joined #openstack-qa16:43
mtreinishSpamapS: when you're back around we kicked off the subunit2sql migration. Hopefully it'll be done by next week :)16:43
*** hitalia has joined #openstack-qa16:45
*** eil397 has joined #openstack-qa16:49
openstackgerritGuillaume Chenuet proposed openstack/tempest: Fixing test_create_port_in_allowed_allocation_pool when 3 (or more) controllers  https://review.openstack.org/24315916:50
hopjordanP mtreinish: hi, could you make final desition for https://review.openstack.org/#/c/249195/ ?16:51
*** tosky has quit IRC16:51
*** yfried_ has quit IRC16:53
jordanPhop, I like this test. You are not adding a new test but just changing a test16:53
jordanPif we follow Ken'ichi's logic then this test should be removed16:54
jordanPI am not sure we want this, so updating the test is fine16:54
jordanPhop, I have one question though, you here ?16:54
hopyes16:54
jordanPhop, let's take test_update_server_name for example16:54
jordanPnow, with your patch you call self._update_server_name twice16:55
jordanPbut that's redundant. If the test pass the complicated test, which is when non-ascii chars are in the name16:55
jordanPthen there's no need to try the "easy" case16:55
jordanPso I suggest you just call self._update_server_name(server['id'], 'ACTIVE', prefix_name) and remove the "self._update_server_name(server['id'], 'ACTIVE')"16:56
jordanPthis way you also prove that you don"t add a new test but just rework a little an existing test16:56
*** jordanP has quit IRC16:57
*** jordanP has joined #openstack-qa16:57
hopjordanP: ok, I got it, could you also leave comment for Ken'ichi and other reviews ?16:57
jordanPhop, re. I was DCed :(16:57
jordanPI will16:58
jordanPjust updatr your patch first16:58
hopok16:58
jordanPso that I am sure we are talking about the same thing16:58
hopI have another question about thist test https://review.openstack.org/#/c/182365/16:59
hopif I understood right, I have 2 ways, hard: find out why devstask has only one image and easy use the same image17:00
*** asselin has quit IRC17:00
hopa'm I right ?17:00
*** asselin has joined #openstack-qa17:00
*** markvoelker has quit IRC17:03
*** jlanoux has quit IRC17:04
SpamapSmtreinish: AWESOME17:04
SpamapSmtreinish: can I watch it?17:04
mtreinishSpamapS: heh, I guess. The only issue is it's started up as a full priv. user so we can see it in the processlist17:06
*** ifarkas has quit IRC17:06
mtreinishbut you can figure out what it's doing in other ways17:06
SpamapSmtreinish: show table status is all I need17:06
mtreinishyep, that's what I've been doing too17:07
*** e0ne has quit IRC17:09
SpamapSmtreinish: can has?17:10
*** maht has quit IRC17:11
mtreinishSpamapS: yeah, just log into the server17:11
*** gfidente|lunch has quit IRC17:11
*** eil397 has quit IRC17:12
*** gfidente has joined #openstack-qa17:12
SpamapSmtreinish: I don't know how to do that?17:12
mtreinishSpamapS: oh, the info is here: http://docs.openstack.org/infra/system-config/logstash.html#subunit2sql17:13
*** rossella_s has quit IRC17:14
SpamapSmtreinish: did we ever discuss why letting anybody login to an sql server is a really bad idea?17:14
mtreinishyes17:14
mtreinishyes we have :)17:14
SpamapSok17:14
SpamapSI thought I remembered it, but I didn't want to miss an opportunity to remind anybody ;)17:14
*** amotoki has quit IRC17:15
*** rossella_s has joined #openstack-qa17:16
SpamapSmtreinish: ok, so looks pretty slow, we're 50 minutes in and we have 500000 rows in test_runs_new17:16
*** maht has joined #openstack-qa17:17
mtreinishyep, thats what I thought too17:17
mtreinishSpamapS: we did resize everything to max size (both the instance and volume) before running the migration17:18
mtreinishI was hoping that would help make it faster17:18
mtreinishso it's running on a 64gb instance now instead of the 8gb from before17:18
SpamapSOh that will likely help17:18
*** dzamboni has joined #openstack-qa17:18
SpamapSunless you didn't also raise innodb_buffer_pool_size accordingly17:18
mtreinishSpamapS: I don't know if trove does that automagically or not17:19
SpamapSyou didn't17:19
SpamapS4GB17:19
SpamapSso, it won't help much17:19
SpamapSit doesn't resize that no17:19
mtreinishSpamapS: well we're still early into it we can always stop it, tune the db, delete the new tables and run the migration again17:20
SpamapSmtreinish: also log_buffer_size is too low17:20
SpamapSWAY too low17:20
SpamapSlike for anything to work well17:20
SpamapS8MB17:20
SpamapSI had it at 1GB on my test server17:20
SpamapS(that buffer is where the double writes happen first)17:20
SpamapSthat said17:21
SpamapSif the buffer pool is so small17:21
SpamapSnothing will be writing fast17:21
SpamapSit's still 2x the size buffer pool I had17:21
mtreinishSpamapS: well let's ping fungi or nibalizer, stop the migration and then tune things17:21
SpamapSso reads _SHOULD_ be a little faster17:21
hopjordanP: I've updated patch, thank you for help!17:21
mtreinishSpamapS: 50min lost in the grand scheme of things isn't a big deal especially if we can make it much faster17:22
jordanPhop, I'll leave a comment right now17:22
SpamapSmtreinish: agreed!17:22
*** maht has quit IRC17:24
*** maht has joined #openstack-qa17:25
*** jecarey has quit IRC17:25
*** maht has quit IRC17:25
*** rossella_s has quit IRC17:27
*** eil397 has joined #openstack-qa17:27
*** rossella_s has joined #openstack-qa17:28
*** hop has quit IRC17:29
*** nic has joined #openstack-qa17:30
*** david-lyle has joined #openstack-qa17:30
*** Swami has quit IRC17:33
*** dtantsur is now known as dtantsur|afk17:33
*** sshnaidm has quit IRC17:39
*** jasonsb has joined #openstack-qa17:42
*** dramalho has joined #openstack-qa17:43
*** mylu has joined #openstack-qa17:47
*** dramalho has quit IRC17:48
*** mylu has quit IRC17:48
*** bdperkin has quit IRC17:49
*** Swami has joined #openstack-qa17:50
mtreinishSpamapS: well now it looks like it's jumped to 2M rows done17:51
*** nicholasgoracke has quit IRC17:52
SpamapSmtreinish: actually it does seem like it has suddenly started churning through a lot17:52
SpamapSmtreinish: I wonder if the OS level cache is working17:53
SpamapSoh yeah it's cranking17:53
SpamapS3 million17:53
mtreinishnice17:53
mtreinishthere is a lot of ram...17:53
mtreinishit's like twice the size of my biggest machine here17:54
*** nicholasgoracke has joined #openstack-qa17:54
*** nicholasgoracke has quit IRC17:54
*** yfried_ has joined #openstack-qa17:55
*** nicholasgoracke has joined #openstack-qa17:55
*** achanda has quit IRC17:55
SpamapSmtreinish: I think we should let it go a bit17:58
SpamapSmtreinish: It's at 4 million now17:58
SpamapSsuggesting that the cache hits are going up rapidly17:58
mtreinishyep, I'm fine with that17:58
SpamapStest_runs data_length fits in 64GB17:58
mtreinishyep, that's what I was just checking17:59
SpamapSso if that's the case, it will cache all the pages soon and just run at write-capped speed17:59
SpamapStest_run_metadata fits in that RAM too17:59
mtreinishheh, having 64gb is kinda nice17:59
*** achanda has joined #openstack-qa18:00
*** david-lyle has quit IRC18:00
mtreinishSpamapS: do you think the tuning will be a useful post migration step then? (assuming we're good to go here)18:00
*** shardy has quit IRC18:00
SpamapSmtreinish: we probably could speed it up by doing a SELECT * FROM test_runs LIMIT 1 OFFSET $nrows18:00
SpamapSmtreinish: are we ok with keeping the instance that big? If so, yes.18:00
SpamapSmtreinish: the buffer pool is used more aggressively than the OS buffer cache18:01
SpamapSmtreinish: so if mysql thinks it has all the rows for a query in cache it will use a different optimization strategy for instance18:01
SpamapSwell, innodb I should say18:01
SpamapSmysql's optimizer is blissfully unaware18:01
SpamapSmtreinish: honestly, the concurrency on the queries though.. it's not the thing18:01
SpamapSmtreinish: these are things that make 10 row queries faster when run with 1000 other concurrent queries. ;)18:02
mtreinishheh, sure I don't think we'll get there18:02
SpamapSmtreinish: we have 100000 row queries that need to run one at a time. Nothing speeds that up except BIG CPU, BIG L3-cache and BIG RAM18:02
SpamapSI mean, once you've got int keys :)18:02
*** jordanP has quit IRC18:03
mtreinishSpamapS: well at one point we'll be running 5-10 at a time. Once openstack health is really being used18:03
mtreinishbut yeah I get what you're saying18:03
mtreinishas for keeping the larger instance, I think it'll be fine. fungi said we can resize down (trove allows it) if we end up under utilizing it18:04
mtreinishalthough I don't really trust resize down18:04
mtreinishbut in the meantime I think we can assume it'll be big18:04
*** fedexo has quit IRC18:06
fungimtreinish: well, the instance resizing is safe for trove, presumably, because there's no data on the system. we just get rebooted on a new instance at the smaller flavor, with the same config applied and the same volume remounted to it18:06
*** e0ne has joined #openstack-qa18:07
mtreinishfungi: yeah, I understand that. I just have seen enough people try to do a real resize down to not trust the words18:08
fungiahh18:09
mtreinishit's just a stigma I have attached to the concept. It likely works fine for trove18:09
*** isaacb has quit IRC18:09
mtreinishSpamapS: it's moving already at 8M18:10
SpamapSoh yeah, cranking.. 8.4 million18:10
mtreinishhah18:10
SpamapSso I'd expect the insert..select's to finish in a few hours18:10
mtreinishoh, wow, I wonder how long building the indexes will take18:11
SpamapSand then hopefully the alters go really fast too .. those at least read the source table in a linear fashion and so can take advantage of os readahead18:11
SpamapSCPU is the biggest limiter in index rebuilds usually18:11
SpamapSor if the disks are REALLY slow at writing, but that doesn't seem to be the case18:11
mtreinishit's got a fair amount of cpu now, 14 cores IIRC18:13
mtreinishSpamapS: yeah 14: https://www.rackspace.com/en-us/cloud/databases18:13
*** achanda has quit IRC18:13
*** gszasz has quit IRC18:14
*** aalam has joined #openstack-qa18:15
*** bdperkin has joined #openstack-qa18:20
*** bdperkin has joined #openstack-qa18:20
*** david-lyle has joined #openstack-qa18:20
*** achanda has joined #openstack-qa18:24
*** yfried_ has quit IRC18:25
*** yfried_ has joined #openstack-qa18:27
*** lekha has quit IRC18:27
*** moravec has quit IRC18:28
*** vgridnev has quit IRC18:29
*** lekha has joined #openstack-qa18:30
SpamapSmtreinish: btw..18:36
SpamapS|  12 | query | 10.208.5.122:59464 | subunit2sql | Query   | 8495 | Sending data | SELECT tests.test_id AS tests_test_id, test_runs.status AS test_runs_status, test_runs.start_time AS |18:36
SpamapSthats.. a bad query ;)18:36
SpamapSmtreinish: but we should try it again post migration ;)18:37
*** nicholasgoracke has quit IRC18:39
*** nicholasgoracke has joined #openstack-qa18:39
*** yamahata has joined #openstack-qa18:42
*** achanda_ has joined #openstack-qa18:42
*** achanda has quit IRC18:42
*** achanda_ has quit IRC18:43
*** tnguyen1 has quit IRC18:46
*** aalam has quit IRC18:47
*** maht has joined #openstack-qa18:48
*** maht has quit IRC18:48
*** maht has joined #openstack-qa18:48
*** glauco has quit IRC18:51
*** rbrndt has quit IRC18:52
*** maht has quit IRC18:53
*** maht has joined #openstack-qa18:53
mtreinishSpamapS: yeah, that's from openstack-health. It's what ends up getting generated when you try to view the results for a single job18:55
mtreinishit takes forever pre-migration18:55
*** vgridnev has joined #openstack-qa18:56
*** nadya_ has quit IRC18:57
mtreinishSpamapS: fixing the db api method that generates that query will be a good optimization18:57
*** e0ne has quit IRC18:58
mtreinishSpamapS: although, that query is more or less the one we were using as a benchmark18:58
*** safchain has quit IRC19:03
*** jecarey has joined #openstack-qa19:03
*** jecarey has quit IRC19:03
*** jecarey has joined #openstack-qa19:04
*** maht has quit IRC19:06
*** maht has joined #openstack-qa19:06
*** nicholasgoracke has quit IRC19:09
openstackgerritMichael Krotscheck proposed openstack/eslint-config-openstack: Permit single-line statements in brace-style  https://review.openstack.org/24998319:09
*** nicholasgoracke has joined #openstack-qa19:10
*** maht has quit IRC19:10
*** aix has quit IRC19:11
*** maht has joined #openstack-qa19:11
*** maht has quit IRC19:12
*** maht has joined #openstack-qa19:12
*** maht has quit IRC19:17
*** maht has joined #openstack-qa19:17
*** dimtruck is now known as zz_dimtruck19:18
*** salv-orl_ has joined #openstack-qa19:19
*** maht has quit IRC19:20
*** maht has joined #openstack-qa19:20
*** salv-orlando has quit IRC19:22
*** maht has quit IRC19:22
*** glauco_ has joined #openstack-qa19:23
*** rbrndt has joined #openstack-qa19:24
*** rbrndt has quit IRC19:25
*** korzen has left #openstack-qa19:26
*** nicholasgoracke has quit IRC19:31
*** nicholasgoracke has joined #openstack-qa19:31
*** nicholasgoracke has quit IRC19:33
*** nicholasgoracke has joined #openstack-qa19:33
*** glauco_ has quit IRC19:35
*** nicholasgoracke has quit IRC19:37
*** nicholasgoracke has joined #openstack-qa19:38
*** ngoracke has joined #openstack-qa19:38
*** rbrndt has joined #openstack-qa19:39
*** nadya_ has joined #openstack-qa19:40
*** achanda has joined #openstack-qa19:42
*** nicholasgoracke has quit IRC19:42
*** achanda has quit IRC19:50
*** achanda has joined #openstack-qa19:53
*** achanda has quit IRC19:53
*** ngoracke has quit IRC19:54
*** nicholasgoracke has joined #openstack-qa19:54
*** rfolco_ has quit IRC19:58
*** hitalia has quit IRC20:06
*** salv-orl_ has quit IRC20:07
*** aysyd has quit IRC20:11
*** nadya_ has quit IRC20:13
*** Swami has quit IRC20:22
*** nic has quit IRC20:29
*** nicholasgoracke has quit IRC20:35
SpamapSmtreinish: ACK.. we'll see. :)20:41
*** dzamboni has quit IRC20:43
*** salv-orlando has joined #openstack-qa20:44
*** jasonsb has quit IRC20:44
*** artom has quit IRC20:47
SpamapSmtreinish: 80 million... this is crazy. ;)20:48
*** vgridnev has quit IRC20:52
*** e0ne has joined #openstack-qa20:58
mtreinishSpamapS: yeah, it's moving20:58
SpamapSmtreinish: that query.. does it realy always take > 4 hours????21:02
mtreinishit'll be quite a bit longer I think :(21:03
*** e0ne has quit IRC21:03
mtreinishit happens anytime someone clicks a link on the second page on openstack health21:04
mtreinishSpamapS: we **really** need this migration :)21:04
*** vgridnev has joined #openstack-qa21:04
andreafmtreinish, SpamapS: nice to see that the migration is running21:05
andreafbtw, we should celebrate subunit2sql 1.0 :D21:05
mtreinishandreaf: have you applied it internally yet?21:05
mtreinishandreaf: heh, I'm not sure it's that big a deal21:05
andreafmtreinish: no, I haven't done the migration internally yet21:06
mtreinishandreaf: but I wouldn't complain about a celebratory cake :)21:06
*** mtanino has quit IRC21:06
mtreinishandreaf: ok, your data set is much smaller so I was wondering how long it takes for you21:07
SpamapSmtreinish: indeed.. and I think the migrated DB will do it 10x, maybe even 40x faster as I observed in some cases. I'm just not sure thats enough! ;)21:09
SpamapSmtreinish: for some reason I thought we were fighting a 30 minute query.. not 4 hours!21:09
andreafmtreinish: yes we started on a fresh DB recently, and we're just collecting periodic test for now, so it's really small21:09
mtreinishSpamapS: heh, well we can work on improving the query some. I'm sure that this isn't the end of your bag of tricks either :)21:09
SpamapSaccording to explain, it has to look at 296 million rows21:11
mtreinishhmm21:13
SpamapSmtreinish: a lot of those will just be joining in the join buffer, which is only 1MB, so reducing row size is likely where we get the 40x speedup.21:13
SpamapSand the fact that we're joining 8 bytes, instead of 110 ;)21:13
SpamapSat that size difference L2 cache might even play a role21:13
SpamapSmtreinish: did we also do the migration where we moved some keys into their own column?21:14
*** mylu has joined #openstack-qa21:15
mtreinishSpamapS: no, we haven't done that yet. But the columns where we can do that aren't being used in this query21:15
mtreinishthe only place it makes sense is for attrs and tags in test_run_metadata21:15
SpamapSahh21:15
SpamapSI thought they were from run_metadata21:16
*** lutostag_ is now known as lutostag21:16
mtreinishwe can't do it there because those fields are completely infra specific21:16
mtreinishand they'll be completely deployment specific for any other users21:17
mtreinishit just sucks that for our dashboards we need to hit the run metadata quite a bit21:17
SpamapSwait21:17
SpamapSFROM runs, run_metadata21:18
SpamapSwhere's the join?21:18
*** apevec has quit IRC21:18
mtreinishhmm, thats a good question. Is there some magic because there is a fk?21:18
SpamapSif there is I've never relied on such a thing21:19
mtreinishthis is 100% sqlalchemy generated, so I dunno how it came up with that21:19
SpamapShttp://paste.openstack.org/show/480044/21:19
SpamapSif I manually add the join explicitly21:19
SpamapSthe explain is fantastic21:19
lifelessSpamapS: is the query constrained in the where portion?21:20
SpamapSlifeless: it is, thats why we need run_metadata21:20
lifelessSpamapS: SQL engines are meant to treat them equivalently to joins... perhaps mysql doesn't?21:20
SpamapSbut it's not constrained by a join21:20
SpamapSlifeless: mysql does do that. But that's not done here.21:21
SpamapSbut, the explain does show it as using the run_id as a ref, so there is some magic happening21:21
*** dims_ has joined #openstack-qa21:21
SpamapSstill, being explicit makes the rows go from 296 million to 13651221:22
lifelessSpamapS: does the query have (in the where clause) - run_metadata.run_id = runs.id21:22
SpamapSand the query returns in 0.62s21:22
SpamapSlifeless: no21:22
*** dims has quit IRC21:22
SpamapSit looks like a cartesian product to me21:23
lifelessSpamapS: could you try that - no explicit join, but add that = to the where ?21:23
lifelessjust out of interest :)21:23
mtreinishSpamapS: it has to be, no table has that many rows21:23
mtreinishwell except for test_run_metadata, but that's not in the query21:23
SpamapSlifeless: not surprisingly, that produces the same explain as the explicit inner join21:23
SpamapSso...21:24
SpamapSorm is confused21:24
lifelessyes21:24
lifelessI concur21:24
SpamapSmtreinish: we should fix this specific query21:24
SpamapS(I love how we have a multi-week effort to improve general efficiency then as it's running I see the actual specific bad query and figure it out ;-)21:24
SpamapSmtreinish: can you point me at the python that makes that monstrosity?21:26
mtreinishSpamapS: I think it's: https://github.com/openstack-infra/subunit2sql/blob/master/subunit2sql/db/api.py#L1053-L106621:26
*** dims has joined #openstack-qa21:26
*** rossella_s has quit IRC21:26
mtreinishSpamapS: to be fair you had the bad query the whole time :)21:26
*** dkranz has quit IRC21:27
*** rossella_s has joined #openstack-qa21:27
SpamapSmtreinish: I KNOW21:27
SpamapSmtreinish: I fully know, and I think I even came to this conclusion one night before face planting on the keyboard..21:27
SpamapSor I"m having dejavu21:27
mtreinishhaha21:27
mtreinishI've done that before too :)21:28
SpamapSmtreinish: I don't see the relationships in db/models.py ??21:28
*** dims_ has quit IRC21:28
SpamapSI see the FK21:29
SpamapSbut not the _relationship_21:29
mtreinishSpamapS: which relationship?21:29
mtreinishbut it's likely we/me forgot to add that21:29
mtreinishSpamapS: btw, 106M rows done...21:31
SpamapSmtreinish: http://docs.sqlalchemy.org/en/latest/orm/tutorial.html#building-a-relationship21:31
mtreinishyeah, I have that open already :)21:31
SpamapSmtreinish: thats why21:32
SpamapSFKs != relationships21:32
SpamapSI don't know why it was able to join the other bits21:32
* SpamapS distrusts all ORMs21:32
mtreinishSpamapS: yeah, I don't blame you for that. It always seems like I miss a detail whenever I try to use it21:34
SpamapShave to run out for a bit..21:35
SpamapSmtreinish: anyway, add relationships, try and see what query gets generated. ;)21:35
mtreinishSpamapS: ok, I'll give it a try21:35
*** openstackgerrit has quit IRC21:36
*** openstackgerrit has joined #openstack-qa21:37
*** hitalia has joined #openstack-qa21:37
*** vgridnev has quit IRC21:51
*** dims_ has joined #openstack-qa21:53
*** dims has quit IRC21:56
openstackgerritMatthew Treinish proposed openstack-infra/subunit2sql: Add missing relationship from orm models  https://review.openstack.org/25003422:00
mtreinishSpamapS: ^^^ I'm not sure if I did that correctly22:00
*** nicholasgoracke has joined #openstack-qa22:06
openstackgerritMatthew Treinish proposed openstack-infra/subunit2sql: Add missing relationship from orm models  https://review.openstack.org/25003422:13
*** sabeen1 has joined #openstack-qa22:25
*** safchain has joined #openstack-qa22:25
*** Swami has joined #openstack-qa22:26
*** sabeen3 has joined #openstack-qa22:29
*** hitalia has quit IRC22:29
*** sabeen1 has quit IRC22:29
mtreinishSpamapS: wow, it's already done with test_runs it's moved onto test_run_metadata22:30
*** jaypipes has quit IRC22:30
mtreinishSpamapS: although test_run_metadata is moving kinda slowly, I guess we'll have to wait for it to rebuild the cache22:32
*** david-lyle has quit IRC22:34
*** moravec has joined #openstack-qa22:42
*** jccnd has joined #openstack-qa22:47
*** moravec has quit IRC22:50
openstackgerritMatthew Treinish proposed openstack-infra/subunit2sql: Add missing relationship from orm models  https://review.openstack.org/25003422:51
mtreinishSpamapS: ^^^ that at least passes tests, but I'm still not sure it's complete22:51
*** nicholasgoracke has quit IRC22:53
*** safchain has quit IRC23:03
*** ccneill has quit IRC23:05
*** david-lyle has joined #openstack-qa23:07
*** erlon has quit IRC23:09
*** akshai has quit IRC23:17
*** akshai has joined #openstack-qa23:20
*** rbak has quit IRC23:24
*** david-lyle has quit IRC23:24
*** akshai has quit IRC23:25
*** jecarey has quit IRC23:25
openstackgerritTim Buckley proposed openstack/stackviz: Use consistent dataset IDs in URLs.  https://review.openstack.org/25006323:30
openstackgerritMatthew Treinish proposed openstack-infra/subunit2sql: Add seperate page for v1.0.0 release notes  https://review.openstack.org/25006623:33
*** mmedvede has quit IRC23:36
openstackgerritAlexander Gubanov proposed openstack/tempest: WIP: Add tests API microversion with instance tags  https://review.openstack.org/23317623:38
*** mmedvede has joined #openstack-qa23:40
*** sabeen3 has quit IRC23:42
openstackgerritRamy Asselin proposed openstack-infra/elastic-recheck: Make uncategorized_fails.py configurable  https://review.openstack.org/25007223:50
*** davideagnello has quit IRC23:59

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