*** yamahata has quit IRC | 00:01 | |
openstackrecheck | Console logs not available after 14:13s for gate-cinder-python27 249358,1,0aa1713 | 00:19 |
---|---|---|
*** markvoelker has quit IRC | 00:26 | |
*** dims has joined #openstack-qa | 00:30 | |
*** dims_ has quit IRC | 00:31 | |
*** akshai_ has quit IRC | 00:31 | |
*** dmorita has joined #openstack-qa | 00:32 | |
*** mylu_ has quit IRC | 00:37 | |
openstackrecheck | Console logs not available after 14:13s for gate-tempest-dsvm-large-ops 249475,2,0617d4a | 00:39 |
*** mylu has joined #openstack-qa | 00:39 | |
*** yamamoto has joined #openstack-qa | 00:44 | |
*** yamamoto has quit IRC | 00:46 | |
openstackgerrit | Masayuki Igawa proposed openstack/os-testr: Add *.egg* to .gitignore https://review.openstack.org/249008 | 00:47 |
*** Swami has quit IRC | 00:53 | |
openstackrecheck | Console logs not available after 14:10s for gate-nova-python27 127427,50,963bbac | 00:53 |
openstackgerrit | Merged openstack/os-testr: Add *.egg* to .gitignore https://review.openstack.org/249008 | 00:55 |
*** yamamoto has joined #openstack-qa | 00:55 | |
*** yamamoto has quit IRC | 00:55 | |
*** yamamoto has joined #openstack-qa | 00:56 | |
*** bknudson has quit IRC | 00:56 | |
*** bknudson has joined #openstack-qa | 00:58 | |
*** yamamoto has quit IRC | 00:58 | |
*** hoangcx has joined #openstack-qa | 00:59 | |
*** hoangcx has left #openstack-qa | 00:59 | |
*** ajmiller has quit IRC | 00:59 | |
*** jacky_zhang has joined #openstack-qa | 00:59 | |
*** salv-orl_ has quit IRC | 01:01 | |
*** openstackrecheck has quit IRC | 01:02 | |
*** yamahata has joined #openstack-qa | 01:03 | |
*** zhangjn has joined #openstack-qa | 01:05 | |
*** eil397 has quit IRC | 01:06 | |
*** hitalia has quit IRC | 01:06 | |
*** eil397 has joined #openstack-qa | 01:11 | |
*** Swami has joined #openstack-qa | 01:14 | |
*** glauco__ has joined #openstack-qa | 01:22 | |
*** glauco has quit IRC | 01:22 | |
*** markvoelker has joined #openstack-qa | 01:27 | |
*** Liuqing has joined #openstack-qa | 01:29 | |
*** markvoelker has quit IRC | 01:31 | |
*** hitalia has joined #openstack-qa | 01:38 | |
*** tochi has quit IRC | 01:39 | |
*** yamamoto has joined #openstack-qa | 01:40 | |
*** tochi has joined #openstack-qa | 01:44 | |
*** mylu has quit IRC | 01:47 | |
*** Swami has quit IRC | 01:48 | |
*** zhangjn has quit IRC | 01:49 | |
*** EinstCrazy has joined #openstack-qa | 01:51 | |
*** mriedem has joined #openstack-qa | 01:52 | |
*** shuquan has joined #openstack-qa | 01:52 | |
*** zhangjn has joined #openstack-qa | 01:52 | |
*** mylu has joined #openstack-qa | 01:53 | |
*** eil397 has quit IRC | 01:56 | |
*** shuquan has quit IRC | 02:01 | |
*** shuquan has joined #openstack-qa | 02:09 | |
*** glauco__ has quit IRC | 02:10 | |
*** mtanino has quit IRC | 02:13 | |
*** shuquan has quit IRC | 02:17 | |
*** shuquan has joined #openstack-qa | 02:23 | |
*** markvoelker has joined #openstack-qa | 02:28 | |
openstackgerrit | Merged openstack/tempest: Drop fixed_network dependency from CONF https://review.openstack.org/240467 | 02:30 |
*** markvoelker has quit IRC | 02:33 | |
*** shuquan has quit IRC | 02:36 | |
*** jdandrea has quit IRC | 02:38 | |
*** dims has quit IRC | 02:39 | |
*** hitalia has quit IRC | 02:41 | |
*** Triveni has joined #openstack-qa | 02:43 | |
openstackgerrit | Merged openstack/tempest: Use Tempest-lib's compute migrations_client https://review.openstack.org/240416 | 02:45 |
*** eil397 has joined #openstack-qa | 03:04 | |
*** salv-orlando has joined #openstack-qa | 03:05 | |
*** eil397 has quit IRC | 03:10 | |
*** eil397 has joined #openstack-qa | 03:11 | |
*** dramalho has joined #openstack-qa | 03:11 | |
*** mriedem has quit IRC | 03:13 | |
*** dramalho has quit IRC | 03:16 | |
*** binbincong has joined #openstack-qa | 03:21 | |
*** mtanino has joined #openstack-qa | 03:21 | |
*** tochi has quit IRC | 03:28 | |
*** markvoelker has joined #openstack-qa | 03:29 | |
*** weshay has quit IRC | 03:32 | |
*** Triveni has quit IRC | 03:34 | |
*** markvoelker has quit IRC | 03:34 | |
*** markvoelker has joined #openstack-qa | 03:35 | |
openstackgerrit | Masayuki Igawa proposed openstack/os-testr: Add colored output feature to subunit-trace https://review.openstack.org/249005 | 03:37 |
*** salv-orlando has quit IRC | 03:38 | |
*** bkopilov has quit IRC | 03:38 | |
*** boris-42 has quit IRC | 03:38 | |
*** achanda has joined #openstack-qa | 03:41 | |
*** hichihara has joined #openstack-qa | 03:48 | |
*** zhangjn has quit IRC | 03:51 | |
*** achanda has quit IRC | 03:51 | |
*** salv-orlando has joined #openstack-qa | 03:51 | |
*** salv-orlando has quit IRC | 03:56 | |
*** tochi has joined #openstack-qa | 04:08 | |
openstackgerrit | Masayuki Igawa proposed openstack/os-testr: Add colored output feature to subunit-trace https://review.openstack.org/249005 | 04:08 |
openstackgerrit | Masayuki Igawa proposed openstack/os-testr: Add colored output feature to subunit-trace https://review.openstack.org/249005 | 04:15 |
openstackgerrit | Bin Bin Cong proposed openstack/tempest: Implement keystone v3 case test_authentication_with_invalid_domain https://review.openstack.org/242932 | 04:19 |
*** SridharG has joined #openstack-qa | 04:19 | |
*** Liuqing has quit IRC | 04:41 | |
*** Liuqing has joined #openstack-qa | 04:42 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Fix some inconsistency in docstrings https://review.openstack.org/249548 | 04:42 |
*** hichihara has quit IRC | 04:43 | |
*** bochi-michael has joined #openstack-qa | 04:49 | |
*** mtanino has quit IRC | 04:59 | |
*** rossella_s has quit IRC | 05:14 | |
*** rossella_s has joined #openstack-qa | 05:14 | |
*** salv-orlando has joined #openstack-qa | 05:18 | |
*** shausy has joined #openstack-qa | 05:21 | |
*** salv-orlando has quit IRC | 05:24 | |
*** zhangjn has joined #openstack-qa | 05:28 | |
*** bkopilov has joined #openstack-qa | 05:29 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Adding script to use tempest-lib files in tempest https://review.openstack.org/249560 | 05:31 |
gmann | mtreinish: oomichi: masayukig : andreaf : mkoderer_ JordonP : please have look adding script to use lib files in tempest - https://review.openstack.org/#/c/249560/1 | 05:34 |
gmann | it will be nice to avoid manual deletion of files from tempest | 05:34 |
*** Triveni has joined #openstack-qa | 05:42 | |
*** bkopilov has quit IRC | 05:46 | |
*** Liuqing has quit IRC | 05:47 | |
*** Liuqing has joined #openstack-qa | 05:48 | |
*** amotoki has quit IRC | 05:49 | |
*** Poornima has joined #openstack-qa | 05:49 | |
*** SridharG has left #openstack-qa | 05:50 | |
*** hitalia has joined #openstack-qa | 05:55 | |
*** nadya_ has joined #openstack-qa | 05:56 | |
*** nadya_ has quit IRC | 05:58 | |
*** amotoki has joined #openstack-qa | 06:01 | |
*** asselin has quit IRC | 06:04 | |
*** asselin has joined #openstack-qa | 06:04 | |
*** jasonsb has joined #openstack-qa | 06:09 | |
*** amotoki has quit IRC | 06:10 | |
*** binbincong has quit IRC | 06:11 | |
*** pcrews has quit IRC | 06:12 | |
*** amotoki has joined #openstack-qa | 06:15 | |
*** pcrews has joined #openstack-qa | 06:16 | |
*** rcernin has joined #openstack-qa | 06:19 | |
*** yamamoto has quit IRC | 06:22 | |
*** yamamoto has joined #openstack-qa | 06:23 | |
*** bkopilov has joined #openstack-qa | 06:27 | |
*** binbincong has joined #openstack-qa | 06:29 | |
*** jasonsb has quit IRC | 06:35 | |
*** aopincar has joined #openstack-qa | 06:37 | |
*** jasonsb has joined #openstack-qa | 06:37 | |
*** Liuqing_ has joined #openstack-qa | 06:38 | |
*** Liuqing has quit IRC | 06:39 | |
*** amotoki has quit IRC | 06:39 | |
*** zhangjn has quit IRC | 06:42 | |
*** pcrews has quit IRC | 06:42 | |
*** binbincong has quit IRC | 06:53 | |
*** vgridnev has joined #openstack-qa | 06:54 | |
*** neeti has joined #openstack-qa | 06:56 | |
*** amotoki has joined #openstack-qa | 06:57 | |
*** gamado has joined #openstack-qa | 06:58 | |
*** SridharG has joined #openstack-qa | 06:58 | |
*** nadya_ has joined #openstack-qa | 07:02 | |
*** mylu has quit IRC | 07:03 | |
*** mylu has joined #openstack-qa | 07:04 | |
*** mylu has quit IRC | 07:08 | |
*** armax has quit IRC | 07:08 | |
*** itzikb has joined #openstack-qa | 07:09 | |
*** shardy has joined #openstack-qa | 07:10 | |
*** jasonsb has quit IRC | 07:10 | |
*** binbincong has joined #openstack-qa | 07:12 | |
*** yfried has joined #openstack-qa | 07:18 | |
yfried | andreaf: gmann: https://review.openstack.org/#/c/246983 https://review.openstack.org/#/c/247542 could you please review ? | 07:26 |
yfried | masayukig: ^ | 07:26 |
*** dims has joined #openstack-qa | 07:35 | |
*** fedexo has quit IRC | 07:36 | |
*** anshul has joined #openstack-qa | 07:37 | |
*** salv-orlando has joined #openstack-qa | 07:38 | |
*** asselin has quit IRC | 07:39 | |
*** dims_ has joined #openstack-qa | 07:39 | |
*** asselin has joined #openstack-qa | 07:40 | |
*** dims has quit IRC | 07:40 | |
*** salv-orlando has quit IRC | 07:41 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use Tempest-lib's compute security_groups_client https://review.openstack.org/249618 | 07:44 |
*** rcernin_ has joined #openstack-qa | 07:47 | |
*** tosky has joined #openstack-qa | 07:50 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use Tempest-lib's compute services_client https://review.openstack.org/249621 | 07:50 |
*** itzikb has quit IRC | 07:52 | |
*** gszasz has joined #openstack-qa | 07:54 | |
*** itzikb has joined #openstack-qa | 07:56 | |
*** zhangjn has joined #openstack-qa | 07:59 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use snapshots_client from tempest-lib https://review.openstack.org/249623 | 08:00 |
*** zhangjn has quit IRC | 08:00 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Adding script to use tempest-lib files in tempest https://review.openstack.org/249560 | 08:01 |
*** zhangjn has joined #openstack-qa | 08:01 | |
*** e0ne has joined #openstack-qa | 08:07 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use tenant_networks_client from tempest-lib https://review.openstack.org/249625 | 08:08 |
*** e0ne has quit IRC | 08:12 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use tenant_usages_client from tempest-lib https://review.openstack.org/249626 | 08:15 |
*** zhangjn has quit IRC | 08:16 | |
*** e0ne has joined #openstack-qa | 08:16 | |
*** achanda has joined #openstack-qa | 08:19 | |
*** hitalia has quit IRC | 08:22 | |
*** eil397 has quit IRC | 08:24 | |
*** vponomaryov has left #openstack-qa | 08:25 | |
*** vgridnev has quit IRC | 08:26 | |
*** vponomaryov has joined #openstack-qa | 08:26 | |
ekarlso | so the plugin model for devstack doesn't do excercises ? | 08:26 |
*** e0ne has quit IRC | 08:28 | |
*** zhangjn has joined #openstack-qa | 08:29 | |
*** sshnaidm has joined #openstack-qa | 08:30 | |
*** gfidente has joined #openstack-qa | 08:30 | |
*** gfidente has quit IRC | 08:30 | |
*** gfidente has joined #openstack-qa | 08:30 | |
*** yfried_ has joined #openstack-qa | 08:30 | |
*** yfried has quit IRC | 08:31 | |
*** aopincar has quit IRC | 08:32 | |
openstackgerrit | Motohiro/Yuanying Otsuka proposed openstack/tempest-lib: Make git log messsage to shorter https://review.openstack.org/227674 | 08:32 |
*** achanda has quit IRC | 08:33 | |
*** e0ne has joined #openstack-qa | 08:33 | |
*** tosky has quit IRC | 08:35 | |
*** itsuugo has quit IRC | 08:36 | |
*** neeti has quit IRC | 08:36 | |
*** jlanoux has joined #openstack-qa | 08:41 | |
*** maht has joined #openstack-qa | 08:42 | |
*** tosky has joined #openstack-qa | 08:43 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest https://review.openstack.org/249560 | 08:43 |
*** aopincar has joined #openstack-qa | 08:44 | |
*** e0ne has quit IRC | 08:44 | |
openstackgerrit | Guillaume 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/243159 | 08:44 |
*** anshul has quit IRC | 08:47 | |
*** neeti has joined #openstack-qa | 08:50 | |
*** aopincar has quit IRC | 08:50 | |
*** jordanP has joined #openstack-qa | 08:51 | |
*** anshul has joined #openstack-qa | 08:51 | |
*** gamado has quit IRC | 08:51 | |
*** yfried_ has quit IRC | 08:58 | |
*** yfried has joined #openstack-qa | 08:58 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use versions_client, versions from tempest-lib https://review.openstack.org/249644 | 09:01 |
andreaf | gmann: nice work on https://review.openstack.org/#/c/249560, thanks | 09:09 |
andreaf | gmann: I only have once usability concern, see on the review | 09:09 |
*** itzikb_ has joined #openstack-qa | 09:10 | |
*** mkoderer_ is now known as mkoderer | 09:11 | |
*** achanda has joined #openstack-qa | 09:11 | |
gmann | andreaf: ok, Thanks for review. I will check | 09:11 |
*** itzikb has quit IRC | 09:11 | |
*** shardy has quit IRC | 09:12 | |
jacky_zhang | hello everyone,i am a new people in tempest community.... | 09:14 |
*** dtantsur|afk is now known as dtantsur | 09:14 | |
*** nadya_ has quit IRC | 09:14 | |
*** rossella_s has quit IRC | 09:14 | |
*** rossella_s has joined #openstack-qa | 09:14 | |
*** shardy has joined #openstack-qa | 09:14 | |
*** Liuqing_ has quit IRC | 09:15 | |
andreaf | jacky_zhang: welcome :) | 09:15 |
*** Liuqing has joined #openstack-qa | 09:15 | |
andreaf | jacky_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-lib | 09:16 |
bochi-michael | jacky_zhang: hello | 09:16 |
jacky_zhang | andreaf, thanks | 09:16 |
jacky_zhang | bochi-michael, hello.. | 09:16 |
andreaf | gmann, oomichi: do you have the link to the etherpad for the service client work at hand? | 09:17 |
gmann | andreaf: yea, i sec | 09:17 |
gmann | andreaf: jacky_zhang https://etherpad.openstack.org/p/mitaka-tempest-service-clients | 09:17 |
gmann | it needs lot of work and good to start knowing QA | 09:18 |
andreaf | jacky_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_zhang | ok,thanks all,i will read it | 09:18 |
*** yfried has quit IRC | 09:18 | |
andreaf | and the wiki: https://wiki.openstack.org/wiki/QA | 09:19 |
*** lezbar has quit IRC | 09:21 | |
*** gamado has joined #openstack-qa | 09:25 | |
*** salv-orlando has joined #openstack-qa | 09:27 | |
*** salv-orlando has quit IRC | 09:28 | |
*** lezbar has joined #openstack-qa | 09:28 | |
*** salv-orlando has joined #openstack-qa | 09:29 | |
openstackgerrit | Masayuki Igawa proposed openstack/tempest: Add run_stress to cliff-based cli framework https://review.openstack.org/240399 | 09:30 |
*** vgridnev has joined #openstack-qa | 09:31 | |
openstackgerrit | Masayuki Igawa proposed openstack/tempest: Migrate verify-tempest-config to new cliff cli framework https://review.openstack.org/247240 | 09:33 |
*** dims_ has quit IRC | 09:34 | |
*** itzikb has joined #openstack-qa | 09:37 | |
*** Liuqing has quit IRC | 09:41 | |
*** jacky_zhang has quit IRC | 09:41 | |
*** itzikb_ has quit IRC | 09:41 | |
*** achanda has quit IRC | 09:41 | |
openstackgerrit | Jordan Pittier proposed openstack/tempest: tempest/clients.py: always set the image_client attribute https://review.openstack.org/242076 | 09:42 |
*** dansmith has quit IRC | 09:42 | |
*** aopincar has joined #openstack-qa | 09:45 | |
*** dansmith has joined #openstack-qa | 09:45 | |
*** dansmith is now known as Guest11153 | 09:45 | |
*** sshnaidm has quit IRC | 09:47 | |
*** amotoki has quit IRC | 09:48 | |
*** salv-orlando has quit IRC | 09:50 | |
*** yfried has joined #openstack-qa | 09:51 | |
*** bapalm has quit IRC | 09:53 | |
*** bapalm has joined #openstack-qa | 09:55 | |
*** salv-orlando has joined #openstack-qa | 09:57 | |
*** nadya_ has joined #openstack-qa | 09:58 | |
*** e0ne has joined #openstack-qa | 10:01 | |
*** sshnaidm has joined #openstack-qa | 10:03 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest https://review.openstack.org/249560 | 10:05 |
openstackgerrit | Guillaume 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/243159 | 10:05 |
*** Liuqing has joined #openstack-qa | 10:05 | |
*** rcernin_ has quit IRC | 10:06 | |
gmann | andreaf: done. Nice point about error exit. I updated with checking all files first and if all are ok then proceed | 10:06 |
*** zhangjn has quit IRC | 10:09 | |
*** EinstCrazy has quit IRC | 10:13 | |
*** neeti has quit IRC | 10:13 | |
*** yamamoto has quit IRC | 10:15 | |
*** glauco has joined #openstack-qa | 10:16 | |
openstackgerrit | Dmitry Ratushnyy proposed openstack/tempest: Add scenario tests for arp poisoning. https://review.openstack.org/248355 | 10:16 |
andreaf | gmann: thanks for the update, I think there is one issue now with $1 left over in the function - see other comments as well | 10:20 |
*** Liuqing has quit IRC | 10:22 | |
*** anshul has quit IRC | 10:22 | |
openstackgerrit | Isaac Beckman proposed openstack-infra/devstack-gate: create GRE bridge interfaces only once https://review.openstack.org/239363 | 10:23 |
dmellado | gmann: 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.html | 10:23 |
*** Liuqing has joined #openstack-qa | 10:23 | |
dmellado | jordanP: as well ;) | 10:23 |
openstackgerrit | Benny Kopilov proposed openstack/tempest: Change multi-backend configuration to a list https://review.openstack.org/243415 | 10:26 |
*** dtantsur is now known as dtantsur|brb | 10:29 | |
*** Liuqing has quit IRC | 10:29 | |
*** anshul has joined #openstack-qa | 10:30 | |
*** Liuqing has joined #openstack-qa | 10:30 | |
*** dmorita has quit IRC | 10:31 | |
*** safchain has joined #openstack-qa | 10:33 | |
gmann | andreaf: ops, i will update thanks. | 10:37 |
*** yfried has quit IRC | 10:37 | |
*** yfried_ has joined #openstack-qa | 10:37 | |
*** yamahata has quit IRC | 10:43 | |
*** tochi has quit IRC | 10:47 | |
*** yamamoto has joined #openstack-qa | 10:53 | |
*** yamamoto has quit IRC | 10:56 | |
*** yamamoto has joined #openstack-qa | 10:57 | |
*** rfolco_ has joined #openstack-qa | 10:58 | |
*** glauco has quit IRC | 11:00 | |
openstackgerrit | Jordan Pittier proposed openstack/tempest: Add a volume extend scenario https://review.openstack.org/249100 | 11:01 |
*** k4n0 has joined #openstack-qa | 11:01 | |
openstackgerrit | Benny Kopilov proposed openstack/tempest: Change multi-backend configuration to a list https://review.openstack.org/243415 | 11:08 |
jlanoux | Hi andreaf jordanP! Could you have a look at https://review.openstack.org/#/c/225575/ please? | 11:09 |
jordanP | yep, it's wednesday ! | 11:10 |
jlanoux | jordanP: :) thanks! | 11:10 |
jordanP | I am going to leave a "check experimental" comment and pray that it fails all over the place | 11:10 |
jordanP | hahaha :evil: | 11:10 |
dmellado | lol | 11:10 |
*** yamamoto_ has joined #openstack-qa | 11:11 | |
*** itsuugo has joined #openstack-qa | 11:11 | |
jlanoux | and if it fails all over the place, I'm going to recheck again and again | 11:11 |
*** Guest11153 has quit IRC | 11:12 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest https://review.openstack.org/249560 | 11:13 |
*** yamamoto has quit IRC | 11:15 | |
*** dansmith has joined #openstack-qa | 11:15 | |
*** dansmith is now known as Guest10504 | 11:15 | |
*** aysyd has joined #openstack-qa | 11:18 | |
gmann | sdague: 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,z | 11:18 |
*** yamamoto_ has quit IRC | 11:20 | |
*** aysyd has quit IRC | 11:22 | |
*** aysyd has joined #openstack-qa | 11:23 | |
*** jacky-zhang has joined #openstack-qa | 11:24 | |
*** yamamoto has joined #openstack-qa | 11:25 | |
andreaf | jlanoux: I'll try later today | 11:26 |
jlanoux | thanks andreaf | 11:27 |
*** NithyaG has joined #openstack-qa | 11:28 | |
*** dtantsur|brb is now known as dtantsur | 11:28 | |
*** Guest10504 has quit IRC | 11:29 | |
*** glauco has joined #openstack-qa | 11:30 | |
openstackgerrit | Vasyl Saienko proposed openstack-dev/devstack: Add configure_provision_network function https://review.openstack.org/248074 | 11:30 |
openstackgerrit | Vasyl Saienko proposed openstack-dev/devstack: Update VM network connection https://review.openstack.org/249717 | 11:30 |
*** wuhg has quit IRC | 11:31 | |
*** dansmith_ has joined #openstack-qa | 11:31 | |
*** apevec has joined #openstack-qa | 11:32 | |
*** apevec has quit IRC | 11:32 | |
*** apevec has joined #openstack-qa | 11:32 | |
*** yamamoto has quit IRC | 11:32 | |
openstackgerrit | Isaac Beckman proposed openstack-infra/devstack-gate: create GRE bridge interfaces only once https://review.openstack.org/239363 | 11:36 |
*** jamielennox is now known as jamielennox|away | 11:42 | |
*** neeti has joined #openstack-qa | 11:43 | |
jordanP | andreaf, 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 review | 11:48 |
jordanP | thanks ! | 11:48 |
*** zhangjn has joined #openstack-qa | 11:48 | |
*** zhangjn has quit IRC | 11:49 | |
ekarlso | is using exercises deprecated when using the plugin model ? | 11:49 |
*** zhangjn has joined #openstack-qa | 11:49 | |
jordanP | ekarlso, I don't think so. I think you could have your plugin to copy whatever you want in the exercices directory | 11:51 |
*** dansmith_ has quit IRC | 11:52 | |
*** glauco has quit IRC | 11:52 | |
jordanP | but sdague or dtroyer_zz should confirm when they are awake | 11:52 |
*** dansmith_ has joined #openstack-qa | 11:52 | |
*** glauco has joined #openstack-qa | 11:52 | |
*** amotoki has joined #openstack-qa | 11:54 | |
*** dramalho has joined #openstack-qa | 11:57 | |
*** gamado has quit IRC | 12:00 | |
*** jamielennox|away is now known as jamielennox | 12:01 | |
*** dramalho has quit IRC | 12:01 | |
openstackgerrit | Joseph Lanoux proposed openstack/tempest: Migrate scenario tests ssh-auth-strategy https://review.openstack.org/225575 | 12:02 |
*** yamamoto has joined #openstack-qa | 12:02 | |
*** dansmith_ is now known as dansmith | 12:04 | |
*** dansmith is now known as Guest87843 | 12:05 | |
*** achanda has joined #openstack-qa | 12:05 | |
*** jaypipes has joined #openstack-qa | 12:05 | |
*** ChanServ sets mode: +o jaypipes | 12:05 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Add script to use tempest-lib files in tempest https://review.openstack.org/249560 | 12:10 |
*** EinstCrazy has joined #openstack-qa | 12:10 | |
*** gamado has joined #openstack-qa | 12:15 | |
*** maht has quit IRC | 12:15 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Use Tempest-lib's compute volumes_client https://review.openstack.org/249734 | 12:17 |
*** neeti has quit IRC | 12:19 | |
*** achanda has quit IRC | 12:24 | |
*** achanda has joined #openstack-qa | 12:33 | |
*** weshay_xchat has joined #openstack-qa | 12:35 | |
*** achanda has quit IRC | 12:41 | |
*** dims has joined #openstack-qa | 12:42 | |
*** Triveni has quit IRC | 12:43 | |
*** Poornima has quit IRC | 12:43 | |
openstackgerrit | Dmitry Ratushnyy proposed openstack/tempest: Add scenario tests for arp poisoning. https://review.openstack.org/248355 | 12:45 |
*** weshay_xchat is now known as weshahy | 12:46 | |
*** weshahy is now known as weshay | 12:46 | |
*** e0ne_ has joined #openstack-qa | 12:48 | |
*** boris-42 has joined #openstack-qa | 12:49 | |
*** k4n0 has quit IRC | 12:49 | |
*** jaypipes_ has joined #openstack-qa | 12:51 | |
*** e0ne has quit IRC | 12:51 | |
*** jaypipes has quit IRC | 12:51 | |
*** jaypipes_ is now known as jaypipes | 12:53 | |
*** anshul has quit IRC | 12:54 | |
*** korzen has joined #openstack-qa | 12:59 | |
*** bkopilov has quit IRC | 13:00 | |
*** bochi-michael has quit IRC | 13:02 | |
*** gamado has quit IRC | 13:02 | |
*** asselin has quit IRC | 13:04 | |
*** asselin has joined #openstack-qa | 13:04 | |
*** jaypipes has quit IRC | 13:04 | |
*** yamamoto has quit IRC | 13:05 | |
*** aopincar has quit IRC | 13:05 | |
*** david-lyle has quit IRC | 13:09 | |
*** salv-orlando has quit IRC | 13:12 | |
*** rossella_s has quit IRC | 13:14 | |
*** rossella_s has joined #openstack-qa | 13:14 | |
*** isaacb has joined #openstack-qa | 13:15 | |
isaacb | Does anyone knows what's the story with: gate-grenade-dsvm-multinode | 13:16 |
*** maht has joined #openstack-qa | 13:16 | |
*** gamado has joined #openstack-qa | 13:18 | |
*** yamamoto has joined #openstack-qa | 13:19 | |
*** tnguyen1 has joined #openstack-qa | 13:20 | |
*** maht has quit IRC | 13:20 | |
*** gamado has quit IRC | 13:23 | |
*** salv-orlando has joined #openstack-qa | 13:23 | |
*** salv-orlando has quit IRC | 13:24 | |
*** salv-orlando has joined #openstack-qa | 13:25 | |
ekarlso | sdague: dtantsur u about ? | 13:25 |
dtantsur | o/ | 13:26 |
isaacb | gate-grenade-dsvm-multinode always fails | 13:28 |
isaacb | something with ssh timout | 13:28 |
*** maht has joined #openstack-qa | 13:29 | |
*** jordanP has quit IRC | 13:30 | |
*** itzikb has quit IRC | 13:38 | |
*** jaypipes has joined #openstack-qa | 13:57 | |
*** ChanServ sets mode: +o jaypipes | 13:57 | |
*** dkranz has joined #openstack-qa | 13:57 | |
*** shausy has quit IRC | 14:03 | |
*** zz_dimtruck is now known as dimtruck | 14:05 | |
*** openstackgerrit has quit IRC | 14:06 | |
*** openstackgerrit has joined #openstack-qa | 14:07 | |
*** gfidente has quit IRC | 14:13 | |
*** gfidente has joined #openstack-qa | 14:14 | |
*** gfidente has quit IRC | 14:14 | |
*** gfidente has joined #openstack-qa | 14:14 | |
*** jacky-zhang has quit IRC | 14:14 | |
*** gfidente has quit IRC | 14:18 | |
*** gfidente has joined #openstack-qa | 14:18 | |
*** rcernin has quit IRC | 14:19 | |
isaacb | sdague: can you help understand why gate-grenade-dsvm-multinode fails | 14:19 |
*** artom has joined #openstack-qa | 14:22 | |
*** yamamoto has quit IRC | 14:23 | |
*** mylu has joined #openstack-qa | 14:26 | |
*** openstackrecheck has joined #openstack-qa | 14:27 | |
*** dimtruck is now known as zz_dimtruck | 14:28 | |
*** mylu has quit IRC | 14:31 | |
*** Guest87843 is now known as dansmith | 14:32 | |
*** gfidente is now known as gfidente|lunch | 14:33 | |
*** zz_dimtruck is now known as dimtruck | 14:34 | |
*** Swami has joined #openstack-qa | 14:35 | |
*** mylu has joined #openstack-qa | 14:37 | |
*** yamamoto has joined #openstack-qa | 14:40 | |
*** dramalho has joined #openstack-qa | 14:43 | |
*** akshai has joined #openstack-qa | 14:47 | |
*** jordanP has joined #openstack-qa | 14:47 | |
*** dramalho has quit IRC | 14:48 | |
openstackgerrit | Ruby Loo proposed openstack-dev/devstack: Set unprovision and active timeout to match build_timeout https://review.openstack.org/248330 | 14:52 |
*** bkopilov has joined #openstack-qa | 14:55 | |
*** SridharG has left #openstack-qa | 15:04 | |
*** mylu has quit IRC | 15:09 | |
*** e0ne_ has quit IRC | 15:09 | |
*** rbak has joined #openstack-qa | 15:09 | |
*** mylu has joined #openstack-qa | 15:10 | |
*** e0ne has joined #openstack-qa | 15:11 | |
*** rbrndt has joined #openstack-qa | 15:13 | |
*** mylu has quit IRC | 15:15 | |
*** aix has quit IRC | 15:16 | |
openstackgerrit | Merged openstack/tempest: Use Tempest-lib's compute networks_client https://review.openstack.org/240421 | 15:17 |
*** jecarey has joined #openstack-qa | 15:18 | |
openstackgerrit | Viswanath proposed openstack-dev/devstack: Fixing error: cp: cannot create regular file '/etc/cinder/api-paste.ini': Permission denied https://review.openstack.org/249846 | 15:20 |
openstackgerrit | Merged openstack/tempest: Use Tempest-lib's compute quota_classes_client https://review.openstack.org/248999 | 15:21 |
*** mtanino has joined #openstack-qa | 15:28 | |
*** vgridnev has quit IRC | 15:30 | |
openstackgerrit | Lance Bragstad proposed openstack/tempest: Fix race condition when changing passwords for admin tests https://review.openstack.org/249863 | 15:46 |
openstackgerrit | Lance Bragstad proposed openstack-dev/devstack: TEST: use fernet https://review.openstack.org/195780 | 15:47 |
*** aix has joined #openstack-qa | 15:49 | |
ekarlso | sdague: u about ? How does the whole exercise stuff work with plugins | 15:53 |
openstackgerrit | Daniel Mellado proposed openstack/tempest: [WIP] Split out keystone tenant client https://review.openstack.org/248170 | 15:58 |
*** pcrews has joined #openstack-qa | 15:58 | |
*** boris-42 has quit IRC | 15:58 | |
*** zhangjn has quit IRC | 16:00 | |
*** ccneill has joined #openstack-qa | 16:04 | |
*** nicholasgoracke has joined #openstack-qa | 16:08 | |
*** dims has quit IRC | 16:09 | |
*** jdandrea has joined #openstack-qa | 16:09 | |
*** jdandrea has quit IRC | 16:09 | |
*** armax has joined #openstack-qa | 16:10 | |
*** jdandrea has joined #openstack-qa | 16:10 | |
*** dims has joined #openstack-qa | 16:11 | |
*** jdandrea has quit IRC | 16:11 | |
*** jdandrea has joined #openstack-qa | 16:12 | |
*** EinstCrazy has quit IRC | 16:14 | |
openstackgerrit | Guillaume 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/243159 | 16:19 |
*** vgridnev has joined #openstack-qa | 16:28 | |
*** achanda has joined #openstack-qa | 16:32 | |
*** fedexo has joined #openstack-qa | 16:35 | |
jordanP | hi 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 |
mtreinish | jordanP: sure, one sec | 16:36 |
jordanP | thanks ! | 16:37 |
mtreinish | jordanP: +A | 16:39 |
jordanP | awesome, thanks | 16:39 |
*** Liuqing has quit IRC | 16:40 | |
*** ajmiller has joined #openstack-qa | 16:43 | |
mtreinish | SpamapS: 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-qa | 16:45 | |
*** eil397 has joined #openstack-qa | 16:49 | |
openstackgerrit | Guillaume Chenuet proposed openstack/tempest: Fixing test_create_port_in_allowed_allocation_pool when 3 (or more) controllers https://review.openstack.org/243159 | 16:50 |
hop | jordanP mtreinish: hi, could you make final desition for https://review.openstack.org/#/c/249195/ ? | 16:51 |
*** tosky has quit IRC | 16:51 | |
*** yfried_ has quit IRC | 16:53 | |
jordanP | hop, I like this test. You are not adding a new test but just changing a test | 16:53 |
jordanP | if we follow Ken'ichi's logic then this test should be removed | 16:54 |
jordanP | I am not sure we want this, so updating the test is fine | 16:54 |
jordanP | hop, I have one question though, you here ? | 16:54 |
hop | yes | 16:54 |
jordanP | hop, let's take test_update_server_name for example | 16:54 |
jordanP | now, with your patch you call self._update_server_name twice | 16:55 |
jordanP | but that's redundant. If the test pass the complicated test, which is when non-ascii chars are in the name | 16:55 |
jordanP | then there's no need to try the "easy" case | 16:55 |
jordanP | so 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 |
jordanP | this way you also prove that you don"t add a new test but just rework a little an existing test | 16:56 |
*** jordanP has quit IRC | 16:57 | |
*** jordanP has joined #openstack-qa | 16:57 | |
hop | jordanP: ok, I got it, could you also leave comment for Ken'ichi and other reviews ? | 16:57 |
jordanP | hop, re. I was DCed :( | 16:57 |
jordanP | I will | 16:58 |
jordanP | just updatr your patch first | 16:58 |
hop | ok | 16:58 |
jordanP | so that I am sure we are talking about the same thing | 16:58 |
hop | I have another question about thist test https://review.openstack.org/#/c/182365/ | 16:59 |
hop | if I understood right, I have 2 ways, hard: find out why devstask has only one image and easy use the same image | 17:00 |
*** asselin has quit IRC | 17:00 | |
hop | a'm I right ? | 17:00 |
*** asselin has joined #openstack-qa | 17:00 | |
*** markvoelker has quit IRC | 17:03 | |
*** jlanoux has quit IRC | 17:04 | |
SpamapS | mtreinish: AWESOME | 17:04 |
SpamapS | mtreinish: can I watch it? | 17:04 |
mtreinish | SpamapS: heh, I guess. The only issue is it's started up as a full priv. user so we can see it in the processlist | 17:06 |
*** ifarkas has quit IRC | 17:06 | |
mtreinish | but you can figure out what it's doing in other ways | 17:06 |
SpamapS | mtreinish: show table status is all I need | 17:06 |
mtreinish | yep, that's what I've been doing too | 17:07 |
*** e0ne has quit IRC | 17:09 | |
SpamapS | mtreinish: can has? | 17:10 |
*** maht has quit IRC | 17:11 | |
mtreinish | SpamapS: yeah, just log into the server | 17:11 |
*** gfidente|lunch has quit IRC | 17:11 | |
*** eil397 has quit IRC | 17:12 | |
*** gfidente has joined #openstack-qa | 17:12 | |
SpamapS | mtreinish: I don't know how to do that? | 17:12 |
mtreinish | SpamapS: oh, the info is here: http://docs.openstack.org/infra/system-config/logstash.html#subunit2sql | 17:13 |
*** rossella_s has quit IRC | 17:14 | |
SpamapS | mtreinish: did we ever discuss why letting anybody login to an sql server is a really bad idea? | 17:14 |
mtreinish | yes | 17:14 |
mtreinish | yes we have :) | 17:14 |
SpamapS | ok | 17:14 |
SpamapS | I thought I remembered it, but I didn't want to miss an opportunity to remind anybody ;) | 17:14 |
*** amotoki has quit IRC | 17:15 | |
*** rossella_s has joined #openstack-qa | 17:16 | |
SpamapS | mtreinish: ok, so looks pretty slow, we're 50 minutes in and we have 500000 rows in test_runs_new | 17:16 |
*** maht has joined #openstack-qa | 17:17 | |
mtreinish | yep, thats what I thought too | 17:17 |
mtreinish | SpamapS: we did resize everything to max size (both the instance and volume) before running the migration | 17:18 |
mtreinish | I was hoping that would help make it faster | 17:18 |
mtreinish | so it's running on a 64gb instance now instead of the 8gb from before | 17:18 |
SpamapS | Oh that will likely help | 17:18 |
*** dzamboni has joined #openstack-qa | 17:18 | |
SpamapS | unless you didn't also raise innodb_buffer_pool_size accordingly | 17:18 |
mtreinish | SpamapS: I don't know if trove does that automagically or not | 17:19 |
SpamapS | you didn't | 17:19 |
SpamapS | 4GB | 17:19 |
SpamapS | so, it won't help much | 17:19 |
SpamapS | it doesn't resize that no | 17:19 |
mtreinish | SpamapS: well we're still early into it we can always stop it, tune the db, delete the new tables and run the migration again | 17:20 |
SpamapS | mtreinish: also log_buffer_size is too low | 17:20 |
SpamapS | WAY too low | 17:20 |
SpamapS | like for anything to work well | 17:20 |
SpamapS | 8MB | 17:20 |
SpamapS | I had it at 1GB on my test server | 17:20 |
SpamapS | (that buffer is where the double writes happen first) | 17:20 |
SpamapS | that said | 17:21 |
SpamapS | if the buffer pool is so small | 17:21 |
SpamapS | nothing will be writing fast | 17:21 |
SpamapS | it's still 2x the size buffer pool I had | 17:21 |
mtreinish | SpamapS: well let's ping fungi or nibalizer, stop the migration and then tune things | 17:21 |
SpamapS | so reads _SHOULD_ be a little faster | 17:21 |
hop | jordanP: I've updated patch, thank you for help! | 17:21 |
mtreinish | SpamapS: 50min lost in the grand scheme of things isn't a big deal especially if we can make it much faster | 17:22 |
jordanP | hop, I'll leave a comment right now | 17:22 |
SpamapS | mtreinish: agreed! | 17:22 |
*** maht has quit IRC | 17:24 | |
*** maht has joined #openstack-qa | 17:25 | |
*** jecarey has quit IRC | 17:25 | |
*** maht has quit IRC | 17:25 | |
*** rossella_s has quit IRC | 17:27 | |
*** eil397 has joined #openstack-qa | 17:27 | |
*** rossella_s has joined #openstack-qa | 17:28 | |
*** hop has quit IRC | 17:29 | |
*** nic has joined #openstack-qa | 17:30 | |
*** david-lyle has joined #openstack-qa | 17:30 | |
*** Swami has quit IRC | 17:33 | |
*** dtantsur is now known as dtantsur|afk | 17:33 | |
*** sshnaidm has quit IRC | 17:39 | |
*** jasonsb has joined #openstack-qa | 17:42 | |
*** dramalho has joined #openstack-qa | 17:43 | |
*** mylu has joined #openstack-qa | 17:47 | |
*** dramalho has quit IRC | 17:48 | |
*** mylu has quit IRC | 17:48 | |
*** bdperkin has quit IRC | 17:49 | |
*** Swami has joined #openstack-qa | 17:50 | |
mtreinish | SpamapS: well now it looks like it's jumped to 2M rows done | 17:51 |
*** nicholasgoracke has quit IRC | 17:52 | |
SpamapS | mtreinish: actually it does seem like it has suddenly started churning through a lot | 17:52 |
SpamapS | mtreinish: I wonder if the OS level cache is working | 17:53 |
SpamapS | oh yeah it's cranking | 17:53 |
SpamapS | 3 million | 17:53 |
mtreinish | nice | 17:53 |
mtreinish | there is a lot of ram... | 17:53 |
mtreinish | it's like twice the size of my biggest machine here | 17:54 |
*** nicholasgoracke has joined #openstack-qa | 17:54 | |
*** nicholasgoracke has quit IRC | 17:54 | |
*** yfried_ has joined #openstack-qa | 17:55 | |
*** nicholasgoracke has joined #openstack-qa | 17:55 | |
*** achanda has quit IRC | 17:55 | |
SpamapS | mtreinish: I think we should let it go a bit | 17:58 |
SpamapS | mtreinish: It's at 4 million now | 17:58 |
SpamapS | suggesting that the cache hits are going up rapidly | 17:58 |
mtreinish | yep, I'm fine with that | 17:58 |
SpamapS | test_runs data_length fits in 64GB | 17:58 |
mtreinish | yep, that's what I was just checking | 17:59 |
SpamapS | so if that's the case, it will cache all the pages soon and just run at write-capped speed | 17:59 |
SpamapS | test_run_metadata fits in that RAM too | 17:59 |
mtreinish | heh, having 64gb is kinda nice | 17:59 |
*** achanda has joined #openstack-qa | 18:00 | |
*** david-lyle has quit IRC | 18:00 | |
mtreinish | SpamapS: 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 IRC | 18:00 | |
SpamapS | mtreinish: we probably could speed it up by doing a SELECT * FROM test_runs LIMIT 1 OFFSET $nrows | 18:00 |
SpamapS | mtreinish: are we ok with keeping the instance that big? If so, yes. | 18:00 |
SpamapS | mtreinish: the buffer pool is used more aggressively than the OS buffer cache | 18:01 |
SpamapS | mtreinish: so if mysql thinks it has all the rows for a query in cache it will use a different optimization strategy for instance | 18:01 |
SpamapS | well, innodb I should say | 18:01 |
SpamapS | mysql's optimizer is blissfully unaware | 18:01 |
SpamapS | mtreinish: honestly, the concurrency on the queries though.. it's not the thing | 18:01 |
SpamapS | mtreinish: these are things that make 10 row queries faster when run with 1000 other concurrent queries. ;) | 18:02 |
mtreinish | heh, sure I don't think we'll get there | 18:02 |
SpamapS | mtreinish: 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 RAM | 18:02 |
SpamapS | I mean, once you've got int keys :) | 18:02 |
*** jordanP has quit IRC | 18:03 | |
mtreinish | SpamapS: well at one point we'll be running 5-10 at a time. Once openstack health is really being used | 18:03 |
mtreinish | but yeah I get what you're saying | 18:03 |
mtreinish | as 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 it | 18:04 |
mtreinish | although I don't really trust resize down | 18:04 |
mtreinish | but in the meantime I think we can assume it'll be big | 18:04 |
*** fedexo has quit IRC | 18:06 | |
fungi | mtreinish: 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 it | 18:06 |
*** e0ne has joined #openstack-qa | 18:07 | |
mtreinish | fungi: yeah, I understand that. I just have seen enough people try to do a real resize down to not trust the words | 18:08 |
fungi | ahh | 18:09 |
mtreinish | it's just a stigma I have attached to the concept. It likely works fine for trove | 18:09 |
*** isaacb has quit IRC | 18:09 | |
mtreinish | SpamapS: it's moving already at 8M | 18:10 |
SpamapS | oh yeah, cranking.. 8.4 million | 18:10 |
mtreinish | hah | 18:10 |
SpamapS | so I'd expect the insert..select's to finish in a few hours | 18:10 |
mtreinish | oh, wow, I wonder how long building the indexes will take | 18:11 |
SpamapS | and 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 readahead | 18:11 |
SpamapS | CPU is the biggest limiter in index rebuilds usually | 18:11 |
SpamapS | or if the disks are REALLY slow at writing, but that doesn't seem to be the case | 18:11 |
mtreinish | it's got a fair amount of cpu now, 14 cores IIRC | 18:13 |
mtreinish | SpamapS: yeah 14: https://www.rackspace.com/en-us/cloud/databases | 18:13 |
*** achanda has quit IRC | 18:13 | |
*** gszasz has quit IRC | 18:14 | |
*** aalam has joined #openstack-qa | 18:15 | |
*** bdperkin has joined #openstack-qa | 18:20 | |
*** bdperkin has joined #openstack-qa | 18:20 | |
*** david-lyle has joined #openstack-qa | 18:20 | |
*** achanda has joined #openstack-qa | 18:24 | |
*** yfried_ has quit IRC | 18:25 | |
*** yfried_ has joined #openstack-qa | 18:27 | |
*** lekha has quit IRC | 18:27 | |
*** moravec has quit IRC | 18:28 | |
*** vgridnev has quit IRC | 18:29 | |
*** lekha has joined #openstack-qa | 18:30 | |
SpamapS | mtreinish: 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 |
SpamapS | thats.. a bad query ;) | 18:36 |
SpamapS | mtreinish: but we should try it again post migration ;) | 18:37 |
*** nicholasgoracke has quit IRC | 18:39 | |
*** nicholasgoracke has joined #openstack-qa | 18:39 | |
*** yamahata has joined #openstack-qa | 18:42 | |
*** achanda_ has joined #openstack-qa | 18:42 | |
*** achanda has quit IRC | 18:42 | |
*** achanda_ has quit IRC | 18:43 | |
*** tnguyen1 has quit IRC | 18:46 | |
*** aalam has quit IRC | 18:47 | |
*** maht has joined #openstack-qa | 18:48 | |
*** maht has quit IRC | 18:48 | |
*** maht has joined #openstack-qa | 18:48 | |
*** glauco has quit IRC | 18:51 | |
*** rbrndt has quit IRC | 18:52 | |
*** maht has quit IRC | 18:53 | |
*** maht has joined #openstack-qa | 18:53 | |
mtreinish | SpamapS: yeah, that's from openstack-health. It's what ends up getting generated when you try to view the results for a single job | 18:55 |
mtreinish | it takes forever pre-migration | 18:55 |
*** vgridnev has joined #openstack-qa | 18:56 | |
*** nadya_ has quit IRC | 18:57 | |
mtreinish | SpamapS: fixing the db api method that generates that query will be a good optimization | 18:57 |
*** e0ne has quit IRC | 18:58 | |
mtreinish | SpamapS: although, that query is more or less the one we were using as a benchmark | 18:58 |
*** safchain has quit IRC | 19:03 | |
*** jecarey has joined #openstack-qa | 19:03 | |
*** jecarey has quit IRC | 19:03 | |
*** jecarey has joined #openstack-qa | 19:04 | |
*** maht has quit IRC | 19:06 | |
*** maht has joined #openstack-qa | 19:06 | |
*** nicholasgoracke has quit IRC | 19:09 | |
openstackgerrit | Michael Krotscheck proposed openstack/eslint-config-openstack: Permit single-line statements in brace-style https://review.openstack.org/249983 | 19:09 |
*** nicholasgoracke has joined #openstack-qa | 19:10 | |
*** maht has quit IRC | 19:10 | |
*** aix has quit IRC | 19:11 | |
*** maht has joined #openstack-qa | 19:11 | |
*** maht has quit IRC | 19:12 | |
*** maht has joined #openstack-qa | 19:12 | |
*** maht has quit IRC | 19:17 | |
*** maht has joined #openstack-qa | 19:17 | |
*** dimtruck is now known as zz_dimtruck | 19:18 | |
*** salv-orl_ has joined #openstack-qa | 19:19 | |
*** maht has quit IRC | 19:20 | |
*** maht has joined #openstack-qa | 19:20 | |
*** salv-orlando has quit IRC | 19:22 | |
*** maht has quit IRC | 19:22 | |
*** glauco_ has joined #openstack-qa | 19:23 | |
*** rbrndt has joined #openstack-qa | 19:24 | |
*** rbrndt has quit IRC | 19:25 | |
*** korzen has left #openstack-qa | 19:26 | |
*** nicholasgoracke has quit IRC | 19:31 | |
*** nicholasgoracke has joined #openstack-qa | 19:31 | |
*** nicholasgoracke has quit IRC | 19:33 | |
*** nicholasgoracke has joined #openstack-qa | 19:33 | |
*** glauco_ has quit IRC | 19:35 | |
*** nicholasgoracke has quit IRC | 19:37 | |
*** nicholasgoracke has joined #openstack-qa | 19:38 | |
*** ngoracke has joined #openstack-qa | 19:38 | |
*** rbrndt has joined #openstack-qa | 19:39 | |
*** nadya_ has joined #openstack-qa | 19:40 | |
*** achanda has joined #openstack-qa | 19:42 | |
*** nicholasgoracke has quit IRC | 19:42 | |
*** achanda has quit IRC | 19:50 | |
*** achanda has joined #openstack-qa | 19:53 | |
*** achanda has quit IRC | 19:53 | |
*** ngoracke has quit IRC | 19:54 | |
*** nicholasgoracke has joined #openstack-qa | 19:54 | |
*** rfolco_ has quit IRC | 19:58 | |
*** hitalia has quit IRC | 20:06 | |
*** salv-orl_ has quit IRC | 20:07 | |
*** aysyd has quit IRC | 20:11 | |
*** nadya_ has quit IRC | 20:13 | |
*** Swami has quit IRC | 20:22 | |
*** nic has quit IRC | 20:29 | |
*** nicholasgoracke has quit IRC | 20:35 | |
SpamapS | mtreinish: ACK.. we'll see. :) | 20:41 |
*** dzamboni has quit IRC | 20:43 | |
*** salv-orlando has joined #openstack-qa | 20:44 | |
*** jasonsb has quit IRC | 20:44 | |
*** artom has quit IRC | 20:47 | |
SpamapS | mtreinish: 80 million... this is crazy. ;) | 20:48 |
*** vgridnev has quit IRC | 20:52 | |
*** e0ne has joined #openstack-qa | 20:58 | |
mtreinish | SpamapS: yeah, it's moving | 20:58 |
SpamapS | mtreinish: that query.. does it realy always take > 4 hours???? | 21:02 |
mtreinish | it'll be quite a bit longer I think :( | 21:03 |
*** e0ne has quit IRC | 21:03 | |
mtreinish | it happens anytime someone clicks a link on the second page on openstack health | 21:04 |
mtreinish | SpamapS: we **really** need this migration :) | 21:04 |
*** vgridnev has joined #openstack-qa | 21:04 | |
andreaf | mtreinish, SpamapS: nice to see that the migration is running | 21:05 |
andreaf | btw, we should celebrate subunit2sql 1.0 :D | 21:05 |
mtreinish | andreaf: have you applied it internally yet? | 21:05 |
mtreinish | andreaf: heh, I'm not sure it's that big a deal | 21:05 |
andreaf | mtreinish: no, I haven't done the migration internally yet | 21:06 |
mtreinish | andreaf: but I wouldn't complain about a celebratory cake :) | 21:06 |
*** mtanino has quit IRC | 21:06 | |
mtreinish | andreaf: ok, your data set is much smaller so I was wondering how long it takes for you | 21:07 |
SpamapS | mtreinish: 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 |
SpamapS | mtreinish: for some reason I thought we were fighting a 30 minute query.. not 4 hours! | 21:09 |
andreaf | mtreinish: yes we started on a fresh DB recently, and we're just collecting periodic test for now, so it's really small | 21:09 |
mtreinish | SpamapS: 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 |
SpamapS | according to explain, it has to look at 296 million rows | 21:11 |
mtreinish | hmm | 21:13 |
SpamapS | mtreinish: 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 |
SpamapS | and the fact that we're joining 8 bytes, instead of 110 ;) | 21:13 |
SpamapS | at that size difference L2 cache might even play a role | 21:13 |
SpamapS | mtreinish: did we also do the migration where we moved some keys into their own column? | 21:14 |
*** mylu has joined #openstack-qa | 21:15 | |
mtreinish | SpamapS: no, we haven't done that yet. But the columns where we can do that aren't being used in this query | 21:15 |
mtreinish | the only place it makes sense is for attrs and tags in test_run_metadata | 21:15 |
SpamapS | ahh | 21:15 |
SpamapS | I thought they were from run_metadata | 21:16 |
*** lutostag_ is now known as lutostag | 21:16 | |
mtreinish | we can't do it there because those fields are completely infra specific | 21:16 |
mtreinish | and they'll be completely deployment specific for any other users | 21:17 |
mtreinish | it just sucks that for our dashboards we need to hit the run metadata quite a bit | 21:17 |
SpamapS | wait | 21:17 |
SpamapS | FROM runs, run_metadata | 21:18 |
SpamapS | where's the join? | 21:18 |
*** apevec has quit IRC | 21:18 | |
mtreinish | hmm, thats a good question. Is there some magic because there is a fk? | 21:18 |
SpamapS | if there is I've never relied on such a thing | 21:19 |
mtreinish | this is 100% sqlalchemy generated, so I dunno how it came up with that | 21:19 |
SpamapS | http://paste.openstack.org/show/480044/ | 21:19 |
SpamapS | if I manually add the join explicitly | 21:19 |
SpamapS | the explain is fantastic | 21:19 |
lifeless | SpamapS: is the query constrained in the where portion? | 21:20 |
SpamapS | lifeless: it is, thats why we need run_metadata | 21:20 |
lifeless | SpamapS: SQL engines are meant to treat them equivalently to joins... perhaps mysql doesn't? | 21:20 |
SpamapS | but it's not constrained by a join | 21:20 |
SpamapS | lifeless: mysql does do that. But that's not done here. | 21:21 |
SpamapS | but, the explain does show it as using the run_id as a ref, so there is some magic happening | 21:21 |
*** dims_ has joined #openstack-qa | 21:21 | |
SpamapS | still, being explicit makes the rows go from 296 million to 136512 | 21:22 |
lifeless | SpamapS: does the query have (in the where clause) - run_metadata.run_id = runs.id | 21:22 |
SpamapS | and the query returns in 0.62s | 21:22 |
SpamapS | lifeless: no | 21:22 |
*** dims has quit IRC | 21:22 | |
SpamapS | it looks like a cartesian product to me | 21:23 |
lifeless | SpamapS: could you try that - no explicit join, but add that = to the where ? | 21:23 |
lifeless | just out of interest :) | 21:23 |
mtreinish | SpamapS: it has to be, no table has that many rows | 21:23 |
mtreinish | well except for test_run_metadata, but that's not in the query | 21:23 |
SpamapS | lifeless: not surprisingly, that produces the same explain as the explicit inner join | 21:23 |
SpamapS | so... | 21:24 |
SpamapS | orm is confused | 21:24 |
lifeless | yes | 21:24 |
lifeless | I concur | 21:24 |
SpamapS | mtreinish: we should fix this specific query | 21: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 |
SpamapS | mtreinish: can you point me at the python that makes that monstrosity? | 21:26 |
mtreinish | SpamapS: I think it's: https://github.com/openstack-infra/subunit2sql/blob/master/subunit2sql/db/api.py#L1053-L1066 | 21:26 |
*** dims has joined #openstack-qa | 21:26 | |
*** rossella_s has quit IRC | 21:26 | |
mtreinish | SpamapS: to be fair you had the bad query the whole time :) | 21:26 |
*** dkranz has quit IRC | 21:27 | |
*** rossella_s has joined #openstack-qa | 21:27 | |
SpamapS | mtreinish: I KNOW | 21:27 |
SpamapS | mtreinish: I fully know, and I think I even came to this conclusion one night before face planting on the keyboard.. | 21:27 |
SpamapS | or I"m having dejavu | 21:27 |
mtreinish | haha | 21:27 |
mtreinish | I've done that before too :) | 21:28 |
SpamapS | mtreinish: I don't see the relationships in db/models.py ?? | 21:28 |
*** dims_ has quit IRC | 21:28 | |
SpamapS | I see the FK | 21:29 |
SpamapS | but not the _relationship_ | 21:29 |
mtreinish | SpamapS: which relationship? | 21:29 |
mtreinish | but it's likely we/me forgot to add that | 21:29 |
mtreinish | SpamapS: btw, 106M rows done... | 21:31 |
SpamapS | mtreinish: http://docs.sqlalchemy.org/en/latest/orm/tutorial.html#building-a-relationship | 21:31 |
mtreinish | yeah, I have that open already :) | 21:31 |
SpamapS | mtreinish: thats why | 21:32 |
SpamapS | FKs != relationships | 21:32 |
SpamapS | I don't know why it was able to join the other bits | 21:32 |
* SpamapS distrusts all ORMs | 21:32 | |
mtreinish | SpamapS: yeah, I don't blame you for that. It always seems like I miss a detail whenever I try to use it | 21:34 |
SpamapS | have to run out for a bit.. | 21:35 |
SpamapS | mtreinish: anyway, add relationships, try and see what query gets generated. ;) | 21:35 |
mtreinish | SpamapS: ok, I'll give it a try | 21:35 |
*** openstackgerrit has quit IRC | 21:36 | |
*** openstackgerrit has joined #openstack-qa | 21:37 | |
*** hitalia has joined #openstack-qa | 21:37 | |
*** vgridnev has quit IRC | 21:51 | |
*** dims_ has joined #openstack-qa | 21:53 | |
*** dims has quit IRC | 21:56 | |
openstackgerrit | Matthew Treinish proposed openstack-infra/subunit2sql: Add missing relationship from orm models https://review.openstack.org/250034 | 22:00 |
mtreinish | SpamapS: ^^^ I'm not sure if I did that correctly | 22:00 |
*** nicholasgoracke has joined #openstack-qa | 22:06 | |
openstackgerrit | Matthew Treinish proposed openstack-infra/subunit2sql: Add missing relationship from orm models https://review.openstack.org/250034 | 22:13 |
*** sabeen1 has joined #openstack-qa | 22:25 | |
*** safchain has joined #openstack-qa | 22:25 | |
*** Swami has joined #openstack-qa | 22:26 | |
*** sabeen3 has joined #openstack-qa | 22:29 | |
*** hitalia has quit IRC | 22:29 | |
*** sabeen1 has quit IRC | 22:29 | |
mtreinish | SpamapS: wow, it's already done with test_runs it's moved onto test_run_metadata | 22:30 |
*** jaypipes has quit IRC | 22:30 | |
mtreinish | SpamapS: although test_run_metadata is moving kinda slowly, I guess we'll have to wait for it to rebuild the cache | 22:32 |
*** david-lyle has quit IRC | 22:34 | |
*** moravec has joined #openstack-qa | 22:42 | |
*** jccnd has joined #openstack-qa | 22:47 | |
*** moravec has quit IRC | 22:50 | |
openstackgerrit | Matthew Treinish proposed openstack-infra/subunit2sql: Add missing relationship from orm models https://review.openstack.org/250034 | 22:51 |
mtreinish | SpamapS: ^^^ that at least passes tests, but I'm still not sure it's complete | 22:51 |
*** nicholasgoracke has quit IRC | 22:53 | |
*** safchain has quit IRC | 23:03 | |
*** ccneill has quit IRC | 23:05 | |
*** david-lyle has joined #openstack-qa | 23:07 | |
*** erlon has quit IRC | 23:09 | |
*** akshai has quit IRC | 23:17 | |
*** akshai has joined #openstack-qa | 23:20 | |
*** rbak has quit IRC | 23:24 | |
*** david-lyle has quit IRC | 23:24 | |
*** akshai has quit IRC | 23:25 | |
*** jecarey has quit IRC | 23:25 | |
openstackgerrit | Tim Buckley proposed openstack/stackviz: Use consistent dataset IDs in URLs. https://review.openstack.org/250063 | 23:30 |
openstackgerrit | Matthew Treinish proposed openstack-infra/subunit2sql: Add seperate page for v1.0.0 release notes https://review.openstack.org/250066 | 23:33 |
*** mmedvede has quit IRC | 23:36 | |
openstackgerrit | Alexander Gubanov proposed openstack/tempest: WIP: Add tests API microversion with instance tags https://review.openstack.org/233176 | 23:38 |
*** mmedvede has joined #openstack-qa | 23:40 | |
*** sabeen3 has quit IRC | 23:42 | |
openstackgerrit | Ramy Asselin proposed openstack-infra/elastic-recheck: Make uncategorized_fails.py configurable https://review.openstack.org/250072 | 23:50 |
*** davideagnello has quit IRC | 23:59 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!