*** dimtruck is now known as zz_dimtruck | 00:02 | |
*** sshnaidm has quit IRC | 00:04 | |
*** rbrndt has quit IRC | 00:07 | |
*** anshul has quit IRC | 00:08 | |
*** zhangjn has joined #openstack-qa | 00:08 | |
*** zhangjn has quit IRC | 00:08 | |
*** zhangjn has joined #openstack-qa | 00:09 | |
*** apevec has quit IRC | 00:18 | |
*** zhangjn has quit IRC | 00:22 | |
*** zz_dimtruck is now known as dimtruck | 00:23 | |
openstackgerrit | Merged openstack/tempest: Make argument params of list methods consistent https://review.openstack.org/250115 | 00:23 |
---|---|---|
*** openstackstatus has quit IRC | 00:24 | |
*** openstackstatus has joined #openstack-qa | 00:25 | |
*** ChanServ sets mode: +v openstackstatus | 00:25 | |
*** Swami has quit IRC | 00:34 | |
*** mriedem_away is now known as mriedem | 00:42 | |
*** eil397 has quit IRC | 00:43 | |
*** ajmiller has quit IRC | 00:43 | |
*** hoangcx has joined #openstack-qa | 00:50 | |
*** hoangcx has left #openstack-qa | 00:50 | |
*** jacky_zhang has joined #openstack-qa | 00:52 | |
*** sabeen has quit IRC | 00:53 | |
*** jacky_zhang has quit IRC | 00:53 | |
*** salv-orl_ has joined #openstack-qa | 00:57 | |
*** zhangjn has joined #openstack-qa | 00:59 | |
*** salv-orl_ has quit IRC | 00:59 | |
*** salv-orlando has quit IRC | 01:00 | |
*** dimtruck is now known as zz_dimtruck | 01:07 | |
*** mriedem has quit IRC | 01:13 | |
*** pvaneck has quit IRC | 01:14 | |
mtreinish | SpamapS: hmm, I'm surprised how long the run_metadata run_id index is taking. It looks like it's still going | 01:18 |
mtreinish | that table isn't that big | 01:18 |
*** jacky_zhang has joined #openstack-qa | 01:19 | |
SpamapS | mtreinish: it still has to create a complete copy of the whole ibd though. | 01:21 |
*** openstackgerrit has quit IRC | 01:22 | |
*** openstackgerrit has joined #openstack-qa | 01:22 | |
mtreinish | SpamapS: oh, then yeah that's probably pretty big | 01:22 |
jacky_zhang | hi all, i found if we change the params to **kargs on PUT and POST function,some negative should unavailable,could we remove it ? | 01:34 |
jacky_zhang | some negative testing | 01:34 |
*** shuquan has joined #openstack-qa | 01:35 | |
*** zhangjn has quit IRC | 01:36 | |
*** zhangjn has joined #openstack-qa | 01:39 | |
*** jasonsb has quit IRC | 01:40 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make volume_quotas_client use **kwargs https://review.openstack.org/250137 | 01:41 |
*** pcrews has quit IRC | 01:41 | |
*** markvoelker has quit IRC | 01:46 | |
*** pcrews has joined #openstack-qa | 01:47 | |
*** yamamoto has joined #openstack-qa | 01:51 | |
*** jecarey has joined #openstack-qa | 01:56 | |
*** jecarey has quit IRC | 01:56 | |
*** jecarey has joined #openstack-qa | 01:57 | |
openstackgerrit | Ghanshyam Mann proposed openstack-dev/devstack: Add options to set compute microversions tests range https://review.openstack.org/247246 | 01:58 |
*** tochi has quit IRC | 01:59 | |
*** salv-orlando has joined #openstack-qa | 02:00 | |
gmann | sdague: please have a look. updated https://review.openstack.org/247246 | 02:00 |
gmann | sdague: mtreinish also please review - https://review.openstack.org/#/c/242296/ too | 02:01 |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add a rest api to get a test_runs time series by test https://review.openstack.org/231283 | 02:04 |
*** salv-orlando has quit IRC | 02:07 | |
openstackgerrit | Merged openstack-infra/subunit2sql: Fix test attachments DB import https://review.openstack.org/251499 | 02:08 |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make volume_types_client use **kwargs https://review.openstack.org/250228 | 02:18 |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add a rest api to get a test_runs time series by test https://review.openstack.org/231283 | 02:18 |
gmann | mtreinish: Thanks | 02:20 |
*** rfolco has joined #openstack-qa | 02:21 | |
gmann | mtreinish: this too if you have time or tomorrow - https://review.openstack.org/#/c/249560/ | 02:21 |
gmann | mtreinish: will helpful for use if lib in tempest | 02:21 |
gmann | if->of | 02:21 |
mtreinish | gmann: I'll take a look at that tomorrow, it's too late for me to review that :) | 02:24 |
gmann | mtreinish: sure. Thanks | 02:24 |
*** zhangjn has quit IRC | 02:28 | |
*** nic has quit IRC | 02:29 | |
*** mtanino has quit IRC | 02:30 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make argument params of list methods consistent https://review.openstack.org/250171 | 02:33 |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add test detail page https://review.openstack.org/231287 | 02:33 |
*** sabeen has joined #openstack-qa | 02:36 | |
*** akshai has quit IRC | 02:39 | |
*** shuquan has quit IRC | 02:45 | |
openstackgerrit | Ramy Asselin proposed openstack-infra/elastic-recheck: Make Elastic Recheck Watch more reusable https://review.openstack.org/251515 | 02:46 |
openstackgerrit | Ian Wienand proposed openstack-dev/devstack: Fix path setup in add_sudo_secure_path https://review.openstack.org/251444 | 02:47 |
SpamapS | mtreinish: run_metadata is done | 02:49 |
SpamapS | mtreinish: looks like it is doing runs now, so should be done soon | 02:50 |
*** rfolco has quit IRC | 02:51 | |
mtreinish | SpamapS: yep | 02:55 |
mtreinish | I'm also seeing some of the nodepool script queries pop up in the processlist waiting on the lock | 02:56 |
* SpamapS feels like emperor Palpatine now.. | 02:56 | |
SpamapS | "And then we will witness the power of a FULLY FUNCTIONING DEATHSTAR.. err.. SQL SCHEMA" | 02:56 |
*** yamahata has quit IRC | 02:58 | |
mtreinish | "our cruisers can't repel firepower of that magnitude" | 02:58 |
*** salv-orlando has joined #openstack-qa | 03:01 | |
SpamapS | ITS A TRAP | 03:02 |
SpamapS | mtreinish: it's kind of perplexing.. why would it take this long to build the indexes on runs. :-P | 03:08 |
SpamapS | I mean the whole table is like 40MB | 03:08 |
*** salv-orlando has quit IRC | 03:09 | |
mtreinish | haha, yeah I have no idea | 03:10 |
mtreinish | it would probably help if we could poke at the server as a real user, but meh | 03:10 |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add test detail page https://review.openstack.org/231287 | 03:11 |
mtreinish | timothyb89: ^^^ there's an annoying bug with that, it's loading the groupedRuns page instead of the new tests page | 03:12 |
mtreinish | it's treating test as the metadata key instead of it's own page | 03:12 |
timothyb89 | mtreinish: I'll take a look | 03:12 |
mtreinish | timothyb89: heh, it does lead to some fun db queries though | 03:14 |
openstackgerrit | Ramy Asselin proposed openstack-infra/elastic-recheck: Allow queue regex specification https://review.openstack.org/251622 | 03:14 |
openstackgerrit | Ian Wienand proposed openstack-dev/devstack: Neutron: Fix provider network example in doc https://review.openstack.org/251563 | 03:16 |
*** tochi has joined #openstack-qa | 03:17 | |
*** nicholasgoracke has joined #openstack-qa | 03:17 | |
timothyb89 | mtreinish: should the api server be responding right now? I can't seem to load anything | 03:19 |
*** zhangjn has joined #openstack-qa | 03:20 | |
mtreinish | timothyb89: there is another migration running, anything that talks to the runs table will be stuck waiting for a lock | 03:20 |
timothyb89 | mtreinish: ah, okay | 03:20 |
*** sabeen2 has joined #openstack-qa | 03:21 | |
*** sabeen has quit IRC | 03:22 | |
*** pcrews has quit IRC | 03:24 | |
*** pcrews has joined #openstack-qa | 03:25 | |
*** jasonsb has joined #openstack-qa | 03:27 | |
SpamapS | mtreinish: ugh, I bet I know why. | 03:32 |
SpamapS | mtreinish: cardinality of that runs.run_at is 1:1 with PK | 03:32 |
SpamapS | common problem with datetime indexes :-P | 03:33 |
*** yamahata has joined #openstack-qa | 03:36 | |
*** zhangjn has quit IRC | 03:42 | |
timothyb89 | mtreinish: I'm not 100% since I can't test, but I think this is the culprit: https://github.com/openstack/openstack-health/blob/master/app/js/on_config.js#L20 | 03:43 |
*** aopincar has joined #openstack-qa | 03:44 | |
timothyb89 | mtreinish: catchall path looks like its matching /test/xyz before the actual test controller gets to see it | 03:44 |
mtreinish | timothyb89: that looks likely. I figured something in the way glauco made grouped runs generic was eating anything that was key/value in the url | 03:44 |
mtreinish | but I wasn't sure where that would be | 03:45 |
timothyb89 | mtreinish: I'm not sure, but I think that just needs to be the last call to state() to let other paths take precedence | 03:46 |
mtreinish | timothyb89: lemme test that | 03:46 |
mtreinish | timothyb89: yeah I think that does it, the page doesn't work but it's loading the right format | 03:48 |
timothyb89 | mtreinish: it does seem to work, but now we aren't handling true 'route not found' errors cleanly... it might be a better solution to move that to its own prefixed path, maybe /g/*runMetadataKey/*name | 03:49 |
*** jecarey has quit IRC | 03:51 | |
mtreinish | timothyb89: that's a good idea, want to push that patch :) | 03:52 |
timothyb89 | mtreinish: working on it now :) | 03:52 |
mtreinish | it should be straightforward | 03:52 |
timothyb89 | yup, shouldn't even break any links | 03:53 |
openstackgerrit | fumihiko kakuma proposed openstack-dev/devstack: Specify the default v3.25 to RYU_BRANCH in case of the ryu plugin https://review.openstack.org/234033 | 03:55 |
openstackrecheck | openstack/keystone change: https://review.openstack.org/249988 failed because of: gate-tempest-dsvm-neutron-full: https://bugs.launchpad.net/bugs/1509004 | 03:55 |
openstack | Launchpad bug 1509004 in neutron ""test_dualnet_dhcp6_stateless_from_os" failures seen in the gate" [Medium,Confirmed] | 03:55 |
SpamapS | bah | 03:56 |
SpamapS | mtreinish: it just won't finish :-P | 03:56 |
mtreinish | SpamapS: heh, yeah it's taking it's time | 03:58 |
openstackgerrit | Tim Buckley proposed openstack/openstack-health: Add a unique prefix to the `groupedRuns` route. https://review.openstack.org/251632 | 03:58 |
mtreinish | SpamapS: it's not like we can throw more power at it either, this is the biggest instance available :) | 03:58 |
*** artom has quit IRC | 03:59 | |
*** nicholasgoracke has quit IRC | 04:03 | |
*** aopincar has quit IRC | 04:05 | |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add test detail page https://review.openstack.org/231287 | 04:12 |
*** artom has joined #openstack-qa | 04:13 | |
*** artom has quit IRC | 04:14 | |
*** artom has joined #openstack-qa | 04:16 | |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add test detail page https://review.openstack.org/231287 | 04:31 |
mtreinish | SpamapS: finally done! | 04:33 |
mtreinish | SpamapS: although we still need to fix the puppet-openstack_health module to pull in an up-to-date subunit2sql and restart the api server | 04:36 |
mtreinish | but that's for tomorrow | 04:36 |
*** artom has quit IRC | 04:43 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make argument params of list methods consistent https://review.openstack.org/250171 | 04:45 |
*** achanda has joined #openstack-qa | 04:51 | |
*** jecarey has joined #openstack-qa | 04:51 | |
*** jecarey has quit IRC | 04:56 | |
openstackgerrit | OpenStack Proposal Bot proposed openstack/tempest: Updated from global requirements https://review.openstack.org/251072 | 05:06 |
*** jecarey has joined #openstack-qa | 05:08 | |
*** jecarey has quit IRC | 05:09 | |
*** jecarey has joined #openstack-qa | 05:09 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make volume_types_client use **kwargs https://review.openstack.org/250228 | 05:10 |
*** yamahata has quit IRC | 05:10 | |
*** jecarey has quit IRC | 05:14 | |
openstackgerrit | Vincent Hou proposed openstack/tempest: Add tempest tests for volume retype with migration https://review.openstack.org/195443 | 05:24 |
*** yfried_ has joined #openstack-qa | 05:24 | |
openstackgerrit | Merged openstack-infra/subunit2sql: Add missing relationship from orm models https://review.openstack.org/250034 | 05:25 |
*** amotoki has joined #openstack-qa | 05:26 | |
*** zhangjn has joined #openstack-qa | 05:32 | |
*** nicholasgoracke has joined #openstack-qa | 05:35 | |
*** abehl has joined #openstack-qa | 05:38 | |
*** Poornima has joined #openstack-qa | 05:38 | |
*** vgridnev has joined #openstack-qa | 05:45 | |
*** shuquan has joined #openstack-qa | 05:58 | |
openstackgerrit | Merged openstack-dev/devstack: Force heat deferred_auth_method to password in standalone mode https://review.openstack.org/205564 | 05:58 |
*** shuquan has quit IRC | 06:00 | |
*** shuquan has joined #openstack-qa | 06:01 | |
openstackgerrit | Merged openstack-dev/devstack: Fix comment typos in inc/ and tests/ directories https://review.openstack.org/251309 | 06:01 |
openstackrecheck | openstack/glance change: https://review.openstack.org/234653 failed because of: gate-tempest-dsvm-full-ceph: https://bugs.launchpad.net/bugs/1464259 | 06:02 |
openstack | Launchpad bug 1464259 in Cinder "EC2VolumesTest fails with rbd backend" [Low,Triaged] | 06:02 |
*** yfried_ has quit IRC | 06:03 | |
*** shuquan has quit IRC | 06:06 | |
openstackgerrit | Maho Koshiya proposed openstack/tempest: Add OS-INHERIT of keystone v3 in api tempest https://review.openstack.org/250795 | 06:07 |
*** salv-orlando has joined #openstack-qa | 06:09 | |
*** dims has quit IRC | 06:09 | |
*** jecarey has joined #openstack-qa | 06:10 | |
*** itzikb has joined #openstack-qa | 06:10 | |
*** dims has joined #openstack-qa | 06:14 | |
*** salv-orlando has quit IRC | 06:14 | |
*** jecarey has quit IRC | 06:14 | |
openstackgerrit | Matthew Treinish proposed openstack-infra/subunit2sql: Properly date filter in get_test_run_dict_by_run_meta_key_value https://review.openstack.org/251673 | 06:23 |
openstackgerrit | Dmitry Ratushnyy proposed openstack/tempest: Implementation of Scenario tests for port-security extension https://review.openstack.org/178137 | 06:25 |
*** zhangjn has quit IRC | 06:25 | |
*** sabeen2 has quit IRC | 06:28 | |
*** pcrews has quit IRC | 06:34 | |
*** abehl has quit IRC | 06:36 | |
openstackrecheck | openstack/nova change: https://review.openstack.org/212102 failed gate-grenade-dsvm-multinode in the gate queue with an unrecognized error | 06:38 |
*** sc68cal has quit IRC | 06:40 | |
*** sc68cal has joined #openstack-qa | 06:44 | |
*** nicholasgoracke has quit IRC | 06:45 | |
*** yamahata has joined #openstack-qa | 06:50 | |
*** zhangjn has joined #openstack-qa | 06:57 | |
*** zhangjn has quit IRC | 06:58 | |
*** achanda_ has joined #openstack-qa | 07:00 | |
*** maht has quit IRC | 07:01 | |
*** hoangcx has joined #openstack-qa | 07:02 | |
*** hoangcx has left #openstack-qa | 07:02 | |
*** achanda has quit IRC | 07:03 | |
openstackgerrit | Masayuki Igawa proposed openstack/openstack-health: Fix api command name https://review.openstack.org/251681 | 07:04 |
*** aopincar has joined #openstack-qa | 07:05 | |
openstackgerrit | Ghanshyam Mann proposed openstack/tempest: Add tests to update group with few fields https://review.openstack.org/250314 | 07:05 |
openstackgerrit | Masayuki Igawa proposed openstack/openstack-health: Fix api command name https://review.openstack.org/251681 | 07:05 |
*** vgridnev has quit IRC | 07:06 | |
*** nadya_ has joined #openstack-qa | 07:07 | |
*** jecarey has joined #openstack-qa | 07:10 | |
*** neeti has joined #openstack-qa | 07:12 | |
*** nadya_ has quit IRC | 07:12 | |
*** jecarey has quit IRC | 07:15 | |
*** mateusz_ has joined #openstack-qa | 07:19 | |
*** tochi has quit IRC | 07:22 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make volume_types_client use **kwargs https://review.openstack.org/250228 | 07:28 |
*** abehl has joined #openstack-qa | 07:30 | |
*** vgridnev has joined #openstack-qa | 07:31 | |
*** achanda_ has quit IRC | 07:36 | |
openstackrecheck | openstack/nova change: https://review.openstack.org/245063 failed gate-grenade-dsvm-multinode in the gate queue with an unrecognized error | 07:37 |
*** yfried_ has joined #openstack-qa | 07:40 | |
*** mateusz has joined #openstack-qa | 07:45 | |
*** binbincong has joined #openstack-qa | 07:45 | |
*** mateusz is now known as Guest55420 | 07:45 | |
*** zhangjn has joined #openstack-qa | 07:46 | |
*** mateusz_ has quit IRC | 07:46 | |
openstackgerrit | Masayuki Igawa proposed openstack/tempest: Fix typo in tox.ini https://review.openstack.org/251691 | 07:53 |
openstackgerrit | Benny Kopilov proposed openstack/tempest: Test encrypted volumes for multi-backends Here are the test steps: https://review.openstack.org/251692 | 07:58 |
*** coolsvap has quit IRC | 08:09 | |
*** jlanoux has joined #openstack-qa | 08:10 | |
*** jecarey has joined #openstack-qa | 08:11 | |
*** safchain has joined #openstack-qa | 08:12 | |
openstackgerrit | Merged openstack-infra/subunit2sql: Add seperate page for v1.0.0 release notes https://review.openstack.org/250066 | 08:12 |
openstackgerrit | Pavlo Shchelokovskyy proposed openstack-dev/devstack: Auto-fill keystone_authtoken for Ironic https://review.openstack.org/238554 | 08:13 |
*** aopincar has quit IRC | 08:13 | |
*** Guest55420 has quit IRC | 08:15 | |
*** aopincar has joined #openstack-qa | 08:15 | |
*** Guest55420 has joined #openstack-qa | 08:15 | |
*** jecarey has quit IRC | 08:15 | |
*** zhangjn has quit IRC | 08:17 | |
*** nadya_ has joined #openstack-qa | 08:20 | |
*** Guest55420 has quit IRC | 08:21 | |
*** Guest55420 has joined #openstack-qa | 08:21 | |
*** achanda has joined #openstack-qa | 08:23 | |
*** yfried_ has quit IRC | 08:24 | |
*** yfried_ has joined #openstack-qa | 08:24 | |
openstackgerrit | Masayuki Igawa proposed openstack/os-testr: Add delete *.pyc command before executing ostestr https://review.openstack.org/251701 | 08:26 |
*** maht has joined #openstack-qa | 08:27 | |
*** hichihara has quit IRC | 08:27 | |
*** nadya__ has joined #openstack-qa | 08:28 | |
*** nadya_ has quit IRC | 08:28 | |
*** zhangjn has joined #openstack-qa | 08:28 | |
*** shardy has joined #openstack-qa | 08:29 | |
*** nadya_ has joined #openstack-qa | 08:34 | |
jlanoux | Hi andreaf. Do you think you can have a look at https://review.openstack.org/#/c/225575/ please? | 08:34 |
openstackgerrit | Merged openstack/tempest: Fix some inconsistency in docstrings https://review.openstack.org/249548 | 08:34 |
andreaf | jlanoux: sure | 08:35 |
*** Guest55420 has quit IRC | 08:35 | |
*** Guest55420 has joined #openstack-qa | 08:35 | |
*** ifarkas has joined #openstack-qa | 08:36 | |
*** nadya__ has quit IRC | 08:36 | |
*** rcernin has joined #openstack-qa | 08:37 | |
jlanoux | andreaf: thanks! | 08:38 |
*** sshnaidm has joined #openstack-qa | 08:40 | |
*** zhangjn has quit IRC | 08:44 | |
*** dtantsur|afk is now known as dtantsur | 08:44 | |
*** tochi has joined #openstack-qa | 08:44 | |
*** nadya_ has quit IRC | 08:45 | |
*** jlanoux has quit IRC | 08:45 | |
*** rossella_s has joined #openstack-qa | 08:45 | |
*** nadya_ has joined #openstack-qa | 08:45 | |
*** gszasz has joined #openstack-qa | 08:46 | |
*** jlanoux has joined #openstack-qa | 08:48 | |
*** mateusz has joined #openstack-qa | 08:51 | |
*** Guest55420 has quit IRC | 08:51 | |
*** mateusz is now known as Guest50778 | 08:51 | |
openstackgerrit | Merged openstack-infra/subunit2sql: Add dates to x-axis for subunit2sql graphs https://review.openstack.org/246641 | 08:54 |
*** zhangjn has joined #openstack-qa | 08:55 | |
*** yfried_ has quit IRC | 08:56 | |
*** yfried_ has joined #openstack-qa | 08:57 | |
openstackgerrit | Merged openstack-infra/subunit2sql: Add support to subunit2sql cli to specify a run_at time https://review.openstack.org/251456 | 08:57 |
openstackgerrit | Andrea Frittoli proposed openstack-infra/subunit2sql: Add docstring for run_at https://review.openstack.org/251717 | 08:57 |
*** nadya__ has joined #openstack-qa | 08:59 | |
*** gmann has quit IRC | 09:01 | |
openstackgerrit | Yaroslav Lobankov proposed openstack/tempest: Changing directory structure for Cinder clients https://review.openstack.org/251045 | 09:02 |
*** gmann has joined #openstack-qa | 09:02 | |
*** nadya_ has quit IRC | 09:03 | |
*** nadya__ has quit IRC | 09:04 | |
*** coolsvap has joined #openstack-qa | 09:04 | |
*** Guest50778 has quit IRC | 09:05 | |
*** jecarey has joined #openstack-qa | 09:12 | |
*** nadya_ has joined #openstack-qa | 09:13 | |
*** gmann has quit IRC | 09:13 | |
*** gfidente has joined #openstack-qa | 09:16 | |
*** gfidente has quit IRC | 09:16 | |
*** gfidente has joined #openstack-qa | 09:16 | |
*** jecarey has quit IRC | 09:17 | |
*** zhangjn has quit IRC | 09:24 | |
*** apevec has joined #openstack-qa | 09:28 | |
*** apevec has quit IRC | 09:28 | |
*** apevec has joined #openstack-qa | 09:28 | |
*** jordanP has joined #openstack-qa | 09:29 | |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make volume_types_client use **kwargs https://review.openstack.org/250228 | 09:30 |
jordanP | ylobankov, hi I am looking https://review.openstack.org/#/c/251045/ now. If jenkins is green, I'll +A | 09:32 |
jordanP | I guess you just rebased it | 09:32 |
ylobankov | jordanP: Hi Jordan. yes, you are right | 09:33 |
openstackgerrit | Daniel Mellado proposed openstack/tempest: Split out keystone tenant client https://review.openstack.org/248170 | 09:34 |
*** salv-orlando has joined #openstack-qa | 09:35 | |
*** salv-orlando has quit IRC | 09:35 | |
*** salv-orlando has joined #openstack-qa | 09:35 | |
*** achanda has quit IRC | 09:38 | |
bkopilov | Hi experts , need help with review to https://review.openstack.org/#/c/251092/ | 09:39 |
andreaf | jlanoux: review done | 09:51 |
*** itsuugo has quit IRC | 10:03 | |
*** itsuugo has joined #openstack-qa | 10:05 | |
*** aix has joined #openstack-qa | 10:05 | |
openstackgerrit | Dmitry Ratushnyy proposed openstack/tempest: Implementation of Scenario tests for port-security extension https://review.openstack.org/178137 | 10:07 |
openstackgerrit | Jacky_lei_zhang proposed openstack/tempest: Make volume_types_client use **kwargs https://review.openstack.org/250228 | 10:09 |
*** wuhg has joined #openstack-qa | 10:09 | |
*** zhangjn has joined #openstack-qa | 10:11 | |
openstackrecheck | openstack/nova change: https://review.openstack.org/218641 failed gate-tempest-dsvm-neutron-full in the gate queue with an unrecognized error | 10:11 |
*** wuhg has left #openstack-qa | 10:12 | |
*** zhangjn has quit IRC | 10:12 | |
*** jecarey has joined #openstack-qa | 10:14 | |
dmellado | andreaf: ping re name tenants/projects | 10:14 |
*** jecarey has quit IRC | 10:19 | |
*** rfolco has joined #openstack-qa | 10:19 | |
*** nicholasgoracke has joined #openstack-qa | 10:20 | |
binbincong | Hi all, I proposed some new keystone v3 negative cases, please help to take a look if you have time, thx. https://review.openstack.org/242932 https://review.openstack.org/250748 | 10:21 |
*** zhangjn has joined #openstack-qa | 10:22 | |
*** kiran-r has joined #openstack-qa | 10:22 | |
*** zhangjn has quit IRC | 10:23 | |
*** zhangjn has joined #openstack-qa | 10:27 | |
*** lewo has joined #openstack-qa | 10:28 | |
*** jlanoux has quit IRC | 10:29 | |
*** jlanoux has joined #openstack-qa | 10:32 | |
*** weshay_xchat has joined #openstack-qa | 10:33 | |
andreaf | dmellado: tenant is the v2 naming, v3 is the project naming - in places where we have shared code for v2/v3 I tend to use project which is the new name | 10:35 |
dmellado | andreaf: I was asked by oomichi to use the 'tenants' | 10:35 |
dmellado | that's why I'm not really sure about it | 10:35 |
dmellado | oomichi_: could you clarify? | 10:35 |
*** jlanoux_ has joined #openstack-qa | 10:37 | |
lewo | jordanP, hi. About tempest patch 232432, do you know another core dev who would be willing to review it? | 10:37 |
patchbot | lewo: https://review.openstack.org/#/c/232432/ - Add network quota exceeding test | 10:37 |
*** e0ne has joined #openstack-qa | 10:37 | |
dmellado | andreaf: I'll be also splitting more clients after this one, is there any naming convention I should be aware of too? | 10:38 |
andreaf | dmellado: the naming of service clients is specified by oomichi_ I believe | 10:39 |
*** jlanoux has quit IRC | 10:39 | |
jordanP | andreaf, oomichi_ could you have a quick look on https://review.openstack.org/#/c/232432/ when you have time please ? it's been stuck because of a -1. it's a short patch in an area that is not super tested in tempest | 10:39 |
andreaf | dmellado: my comment was only on an attribute of the creds_client | 10:39 |
*** hop|2 has joined #openstack-qa | 10:40 | |
andreaf | dmellado: that's not a service client, it's an overlay on top of the identity service clients, to have a common way of creating users and tenants | 10:41 |
andreaf | dmellado: so I don't think there is a conflict really | 10:41 |
dmellado | andreaf: would you mind if I rename that on a different patch? I'll write a tODO | 10:42 |
*** gmann_ has joined #openstack-qa | 10:42 | |
*** gmann_ has quit IRC | 10:43 | |
*** gmann_ has joined #openstack-qa | 10:43 | |
*** gmann_ has quit IRC | 10:43 | |
*** tosky has joined #openstack-qa | 10:44 | |
lewo | jordanP, Thanks. I didn't know if I had to recheck this patch: remove -1 and your review or keep them both... | 10:47 |
*** safchain has quit IRC | 10:48 | |
*** jacky_zhang has quit IRC | 10:48 | |
jordanP | recheck doesn't help | 10:48 |
jordanP | lewo, you could have resubmit another patchset | 10:48 |
*** safchain has joined #openstack-qa | 10:48 | |
jordanP | but if you do that just to remove a -1, it pisses the reviewer | 10:49 |
*** gmann_ has joined #openstack-qa | 10:49 | |
jordanP | so I advince against it | 10:49 |
jordanP | advice | 10:49 |
*** gmann_ has quit IRC | 10:49 | |
*** gmann_ has joined #openstack-qa | 10:50 | |
*** gmann has joined #openstack-qa | 10:50 | |
*** zhangjn has quit IRC | 10:51 | |
*** e0ne has quit IRC | 10:51 | |
andreaf | dmellado: sure, but the idea to use tenant_client = tenant_client or identity_client was so you could have a single create_project implementation | 10:55 |
andreaf | dmellado: the way the code is now you only need to have self.tenant_client = tenant_client | 10:55 |
dmellado | andreaf: I'll be taking a look, then you advice on only changing in there as self.projects_client = project_client instead? | 10:56 |
*** zhangjn has joined #openstack-qa | 11:03 | |
lewo | jordanP, I agree it's not a good practice. But it seems the -1 was not really useful since I had it due to CI bugs (the reviewer asked for more tests but several rechecks later, the CI was OK). | 11:04 |
*** zhangjn has quit IRC | 11:04 | |
openstackgerrit | Alexander Gubanov proposed openstack/tempest: Add new tempest test "RebuildInstanceWithVolume" https://review.openstack.org/182365 | 11:05 |
*** aix has quit IRC | 11:06 | |
*** nadya_ has quit IRC | 11:11 | |
*** yamahata has quit IRC | 11:12 | |
*** nadya_ has joined #openstack-qa | 11:15 | |
*** jecarey has joined #openstack-qa | 11:15 | |
*** aix has joined #openstack-qa | 11:18 | |
*** jecarey has quit IRC | 11:20 | |
*** yamamoto has quit IRC | 11:20 | |
*** tochi has quit IRC | 11:27 | |
openstackgerrit | Merged openstack-dev/devstack: Add flag for test_incremental_backup https://review.openstack.org/237661 | 11:27 |
*** jacky_zhang has joined #openstack-qa | 11:29 | |
*** openstackrecheck has quit IRC | 11:30 | |
*** dzamboni has joined #openstack-qa | 11:30 | |
*** flaper87 has quit IRC | 11:30 | |
*** flaper87 has joined #openstack-qa | 11:30 | |
*** aysyd has joined #openstack-qa | 11:31 | |
*** jlanoux_ has quit IRC | 11:31 | |
*** jlanoux has joined #openstack-qa | 11:31 | |
*** openstackrecheck has joined #openstack-qa | 11:32 | |
*** zhangjn has joined #openstack-qa | 11:32 | |
*** asselin has quit IRC | 11:34 | |
*** asselin has joined #openstack-qa | 11:35 | |
*** aysyd has quit IRC | 11:36 | |
*** mwagner_lap has quit IRC | 11:39 | |
*** flaper87 has quit IRC | 11:39 | |
*** jlanoux has quit IRC | 11:40 | |
*** svasheka has quit IRC | 11:43 | |
*** flaper87 has joined #openstack-qa | 11:47 | |
*** flaper87 has quit IRC | 11:47 | |
*** flaper87 has joined #openstack-qa | 11:47 | |
*** svasheka has joined #openstack-qa | 11:49 | |
*** aysyd has joined #openstack-qa | 11:49 | |
openstackgerrit | Oleksii Butenko proposed openstack/tempest: Create new tests for incremental backup in cinder https://review.openstack.org/235371 | 11:49 |
*** tosky has quit IRC | 11:53 | |
*** tosky has joined #openstack-qa | 11:53 | |
openstackgerrit | Piyush Pathak proposed openstack/tempest: Metadata definition namespaces Negative Test case https://review.openstack.org/239436 | 11:55 |
*** erlon has joined #openstack-qa | 11:56 | |
*** Poornima has quit IRC | 11:58 | |
*** zhangjn has quit IRC | 12:00 | |
*** yamamoto has joined #openstack-qa | 12:04 | |
*** yfried_ has quit IRC | 12:06 | |
*** yfried has joined #openstack-qa | 12:06 | |
openstackgerrit | Daniel Mellado proposed openstack/tempest: Split out keystone tenant client https://review.openstack.org/248170 | 12:07 |
*** achanda has joined #openstack-qa | 12:09 | |
*** nicholasgoracke has quit IRC | 12:10 | |
openstackgerrit | Piyush Pathak proposed openstack/tempest: Identity groups Negative Test case https://review.openstack.org/242965 | 12:12 |
*** tosky has quit IRC | 12:13 | |
*** tosky has joined #openstack-qa | 12:14 | |
openstackrecheck | openstack/nova change: https://review.openstack.org/245063 failed because of: gate-grenade-dsvm-multinode: unrecognized error, gate-grenade-dsvm: unrecognized error, gate-tempest-dsvm-neutron-full: https://bugs.launchpad.net/bugs/1311066 | 12:15 |
openstack | Launchpad bug 1311066 in OpenStack-Gate "Some nodes allocated in node pool are very very slow" [High,Confirmed] - Assigned to Ammar Raza (ammar-reza) | 12:15 |
*** jecarey has joined #openstack-qa | 12:16 | |
*** jlanoux has joined #openstack-qa | 12:17 | |
*** salv-orlando has quit IRC | 12:18 | |
*** sshnaidm has quit IRC | 12:19 | |
*** jecarey_ has joined #openstack-qa | 12:19 | |
*** jecarey has quit IRC | 12:20 | |
*** kiranr has joined #openstack-qa | 12:20 | |
*** jecarey has joined #openstack-qa | 12:21 | |
*** kiran-r has quit IRC | 12:21 | |
*** jaypipes has joined #openstack-qa | 12:22 | |
*** ChanServ sets mode: +o jaypipes | 12:22 | |
*** jecarey_ has quit IRC | 12:23 | |
*** e0ne has joined #openstack-qa | 12:25 | |
*** regXboi has joined #openstack-qa | 12:25 | |
*** jecarey has quit IRC | 12:25 | |
*** edmondsw has joined #openstack-qa | 12:29 | |
*** achanda has quit IRC | 12:31 | |
*** sshnaidm has joined #openstack-qa | 12:32 | |
*** e0ne has quit IRC | 12:34 | |
*** yfried_ has joined #openstack-qa | 12:37 | |
*** e0ne_ has joined #openstack-qa | 12:37 | |
openstackgerrit | Benny Kopilov proposed openstack/tempest: Test encrypted volumes for multi-backends Here are the test steps: https://review.openstack.org/251692 | 12:37 |
*** zhangjn has joined #openstack-qa | 12:37 | |
*** achanda has joined #openstack-qa | 12:38 | |
*** yfried has quit IRC | 12:41 | |
*** ansiwen has joined #openstack-qa | 12:46 | |
openstackgerrit | Piyush Pathak proposed openstack/tempest: Policies Negative Test cases for V3 version https://review.openstack.org/243042 | 12:46 |
*** sileht has joined #openstack-qa | 12:47 | |
*** jaypipes has quit IRC | 12:49 | |
*** jaypipes has joined #openstack-qa | 12:54 | |
*** ChanServ sets mode: +o jaypipes | 12:54 | |
*** achanda has quit IRC | 13:01 | |
*** mwagner_lap has joined #openstack-qa | 13:01 | |
*** weshay_xchat has quit IRC | 13:02 | |
*** gmann_ has joined #openstack-qa | 13:02 | |
*** weshay_xchat has joined #openstack-qa | 13:02 | |
gmann_ | sdague: please have a look on miroversion testing sets - https://review.openstack.org/#/c/242296/9 https://review.openstack.org/#/c/247246/ https://review.openstack.org/#/c/247278/ | 13:03 |
gmann_ | updated devstack one | 13:03 |
*** sshnaidm has quit IRC | 13:03 | |
*** gmann_ has quit IRC | 13:04 | |
*** achanda has joined #openstack-qa | 13:06 | |
*** dtantsur is now known as dtantsur|brb | 13:09 | |
*** salv-orlando has joined #openstack-qa | 13:13 | |
*** weshay_xchat is now known as weshay | 13:14 | |
*** sshnaidm has joined #openstack-qa | 13:16 | |
*** yfried_ is now known as yfried | 13:18 | |
*** kiranr has quit IRC | 13:19 | |
*** jecarey has joined #openstack-qa | 13:21 | |
*** stevemar has quit IRC | 13:22 | |
*** stevemar_znc has joined #openstack-qa | 13:23 | |
openstackgerrit | Oleksii Butenko proposed openstack-dev/devstack: Add flag for test_incremental_backup https://review.openstack.org/251863 | 13:25 |
*** jecarey has quit IRC | 13:26 | |
openstackgerrit | Markus Zoeller (markus_z) proposed openstack-infra/elastic-recheck: add query for random network.test_neutronv2 fails https://review.openstack.org/251868 | 13:34 |
*** jswarren has joined #openstack-qa | 13:35 | |
*** nicholasgoracke has joined #openstack-qa | 13:36 | |
*** yamamoto has quit IRC | 13:40 | |
*** nicholasgoracke has quit IRC | 13:41 | |
*** markvoelker_ has joined #openstack-qa | 13:49 | |
*** yamamoto has joined #openstack-qa | 13:50 | |
*** jacky_zhang has quit IRC | 13:51 | |
*** jacky_zhang has joined #openstack-qa | 13:52 | |
*** e0ne_ has quit IRC | 13:55 | |
*** neeti_ has joined #openstack-qa | 13:55 | |
*** hichihara has joined #openstack-qa | 13:55 | |
*** e0ne has joined #openstack-qa | 13:55 | |
*** achanda_ has joined #openstack-qa | 13:56 | |
*** neeti has quit IRC | 13:57 | |
*** yamamoto has quit IRC | 13:57 | |
*** yamamoto has joined #openstack-qa | 13:57 | |
*** abehl has quit IRC | 13:58 | |
*** achanda has quit IRC | 13:59 | |
*** abehl has joined #openstack-qa | 13:59 | |
*** dkranz has joined #openstack-qa | 14:00 | |
*** dkranz has quit IRC | 14:00 | |
*** dkranz has joined #openstack-qa | 14:00 | |
*** itzikb has quit IRC | 14:03 | |
*** Poornima has joined #openstack-qa | 14:07 | |
openstackgerrit | Alexander Gubanov proposed openstack/tempest: Add new tempest test "RebuildInstanceWithVolume" https://review.openstack.org/182365 | 14:08 |
*** Poornima has quit IRC | 14:16 | |
*** Poornima has joined #openstack-qa | 14:20 | |
*** ajmiller has joined #openstack-qa | 14:20 | |
*** akshai has joined #openstack-qa | 14:21 | |
*** ajmiller has quit IRC | 14:23 | |
*** amotoki_ has joined #openstack-qa | 14:24 | |
*** jacky_zhang has quit IRC | 14:25 | |
*** nicholasgoracke has joined #openstack-qa | 14:33 | |
*** davideagnello has quit IRC | 14:34 | |
*** markvoelker has joined #openstack-qa | 14:34 | |
*** markvoelker_ has quit IRC | 14:35 | |
*** mriedem has joined #openstack-qa | 14:36 | |
*** amotoki has quit IRC | 14:38 | |
*** nicholasgoracke has quit IRC | 14:39 | |
*** nicholasgoracke has joined #openstack-qa | 14:40 | |
*** nicholasgoracke has quit IRC | 14:40 | |
*** nicholasgoracke has joined #openstack-qa | 14:40 | |
*** achanda_ has quit IRC | 14:41 | |
*** weshay has quit IRC | 14:42 | |
openstackgerrit | Alexander Gubanov proposed openstack/tempest: WIP: Add tests for API microversion with instance tags https://review.openstack.org/233176 | 14:42 |
*** dtantsur|brb is now known as dtantsur | 14:43 | |
*** nicholasgoracke has quit IRC | 14:43 | |
*** nicholasgoracke has joined #openstack-qa | 14:44 | |
*** nicholasgoracke has quit IRC | 14:45 | |
*** artom has joined #openstack-qa | 14:47 | |
*** mtanino has joined #openstack-qa | 14:50 | |
openstackgerrit | Merged openstack/tempest-lib: Fix Bugs URL on CONTRIBUTING.rst https://review.openstack.org/248985 | 14:59 |
*** neeti_ has quit IRC | 15:00 | |
*** jecarey has joined #openstack-qa | 15:00 | |
*** hichihara has quit IRC | 15:00 | |
*** amotoki_ is now known as amotoki | 15:01 | |
*** jecarey_ has joined #openstack-qa | 15:01 | |
*** achanda has joined #openstack-qa | 15:04 | |
*** yamamoto_ has joined #openstack-qa | 15:04 | |
*** nicholasgoracke has joined #openstack-qa | 15:04 | |
*** jecarey has quit IRC | 15:05 | |
*** yamamoto has quit IRC | 15:05 | |
openstackgerrit | Mauro Rodrigues proposed openstack-dev/devstack: Check for network id before create probe for neutron's network https://review.openstack.org/251911 | 15:07 |
*** dims has quit IRC | 15:08 | |
dmellado | oomichi_: gmann ylobankov andreaf please have a look when you have some time https://review.openstack.org/#/c/248170/ | 15:09 |
ylobankov | oomichi_: ok, I'll take a look | 15:09 |
ylobankov | today | 15:10 |
mriedem | sdague: armax: do you see any issues with running the n-api-meta service in the neutron large ops job? | 15:10 |
mriedem | to add a wrinkle for perf testing? | 15:11 |
armax | mriedem: I haven’t looked at recently | 15:11 |
*** pglass has joined #openstack-qa | 15:11 | |
armax | mriedem: do you have pointers? | 15:11 |
*** Poornima has quit IRC | 15:11 | |
mriedem | http://logs.openstack.org/43/251543/1/check/gate-tempest-dsvm-neutron-large-ops/eb34603/ | 15:11 |
mriedem | the ops / perf people were saying they had high cpu load running the n-api-meta service but from what i can tell we only run that in the postgres job, which runs nova-network | 15:12 |
mriedem | we have 2 large ops jobs, but neither run n-api-meta | 15:12 |
mriedem | so i figured we could add that to the neutron large ops job so it's slightly different from the nova-net one | 15:12 |
mriedem | i don't actually know if anything is going to be hitting the n-api-meta service in the large ops job, it uses the nova fake virt driver | 15:13 |
mriedem | so unless neutron agent polls the metadata service or something, it might not make much of a difference | 15:13 |
armax | mriedem: ok, I’ll look, I am in a meeting right now | 15:18 |
openstackrecheck | openstack/tempest change: https://review.openstack.org/251045 failed because of: gate-tempest-dsvm-layer4: https://bugs.launchpad.net/bugs/1400905 | 15:19 |
openstack | Launchpad bug 1400905 in OpenStack-Gate "Hash Sum mismatch on apt mirrors" [Undecided,Confirmed] | 15:19 |
*** sabeen has joined #openstack-qa | 15:21 | |
*** weshay_xchat has joined #openstack-qa | 15:22 | |
*** gszasz has quit IRC | 15:22 | |
*** gszasz has joined #openstack-qa | 15:23 | |
*** ajmiller has joined #openstack-qa | 15:23 | |
krotscheck | mtreinish: Oh man, my usual code review heuristics are going haywire looking at openstack-health. Test? Testtest? testrunnertest? testrunnertesttest? | 15:26 |
krotscheck | All the overloading of test is test and test | 15:26 |
* krotscheck feels vaguely smurflike, only test | 15:26 | |
dmellado | lol | 15:27 |
*** aopincar has quit IRC | 15:27 | |
*** zz_dimtruck is now known as dimtruck | 15:28 | |
*** markvoelker_ has joined #openstack-qa | 15:28 | |
*** e0ne has quit IRC | 15:29 | |
*** rbrndt has joined #openstack-qa | 15:31 | |
*** markvoelker has quit IRC | 15:32 | |
*** markvoelker_ has quit IRC | 15:33 | |
*** zhangjn has quit IRC | 15:35 | |
openstackgerrit | Markus Zoeller (markus_z) proposed openstack-infra/elastic-recheck: add query for random network.test_neutronv2 fails https://review.openstack.org/251868 | 15:35 |
*** sabeen has quit IRC | 15:36 | |
*** achanda has quit IRC | 15:45 | |
*** e0ne has joined #openstack-qa | 15:47 | |
*** aix has quit IRC | 15:49 | |
*** dims has joined #openstack-qa | 15:55 | |
*** pcrews has joined #openstack-qa | 15:59 | |
openstackgerrit | Joseph Lanoux proposed openstack/tempest: Migrate scenario tests ssh-auth-strategy https://review.openstack.org/225575 | 15:59 |
*** markvoelker has joined #openstack-qa | 16:00 | |
openstackgerrit | Merged openstack-dev/devstack: Config graceful_shutdown_timeout option for services https://review.openstack.org/238983 | 16:01 |
openstackgerrit | Merged openstack-dev/devstack: Add test for package file ordering https://review.openstack.org/242949 | 16:01 |
openstackgerrit | Joseph Lanoux proposed openstack/tempest: Migrate scenario tests ssh-auth-strategy https://review.openstack.org/225575 | 16:02 |
*** sabeen1 has joined #openstack-qa | 16:02 | |
*** nadya_ has quit IRC | 16:03 | |
*** achanda has joined #openstack-qa | 16:03 | |
*** achanda has quit IRC | 16:03 | |
*** nadya_ has joined #openstack-qa | 16:03 | |
*** rcernin has quit IRC | 16:04 | |
mtreinish | krotscheck: heh, yeah it's an artifact of me not knowing how to name anything | 16:04 |
openstackgerrit | Merged openstack/tempest-lib: Allow passing --insecure to python client binaries https://review.openstack.org/246254 | 16:04 |
*** nadya_ has quit IRC | 16:07 | |
*** dims_ has joined #openstack-qa | 16:08 | |
*** artom_ has joined #openstack-qa | 16:08 | |
*** dims has quit IRC | 16:10 | |
*** achanda has joined #openstack-qa | 16:11 | |
*** artom has quit IRC | 16:11 | |
*** tsufiev has quit IRC | 16:11 | |
*** davideagnello has joined #openstack-qa | 16:13 | |
*** artom_ has quit IRC | 16:15 | |
*** abehl has quit IRC | 16:24 | |
*** hop|2 has quit IRC | 16:25 | |
*** tsufiev has joined #openstack-qa | 16:27 | |
*** yamamoto_ has quit IRC | 16:28 | |
openstackgerrit | Matthew Treinish proposed openstack/openstack-health: Add test detail page https://review.openstack.org/231287 | 16:28 |
openstackrecheck | openstack/nova change: https://review.openstack.org/245063 failed gate-grenade-dsvm-multinode in the gate queue with an unrecognized error | 16:28 |
*** dims has joined #openstack-qa | 16:30 | |
*** gszasz has quit IRC | 16:32 | |
*** dims_ has quit IRC | 16:33 | |
mtreinish | andreaf: any thoughts on: https://review.openstack.org/#/c/251673/ | 16:37 |
andreaf | mtreinish: I'll look in a moment | 16:38 |
openstackgerrit | Matthew Treinish proposed openstack-infra/subunit2sql: Fix indexes in db models https://review.openstack.org/251547 | 16:38 |
openstackgerrit | Merged openstack-infra/elastic-recheck: add query for random network.test_neutronv2 fails https://review.openstack.org/251868 | 16:39 |
kashyap | afazekas: Hi, is this commit still required for F21? https://github.com/openstack-dev/devstack/commit/c7e772c1 | 16:43 |
kashyap | afazekas: The Fedora bug for python-requests is fixed | 16:43 |
kashyap | ("The Fedora bug" == the one you linked in the commit message) | 16:44 |
afazekas | kashyap, is it released to the stable repos ? the bug status is closed RAWHIDE | 16:46 |
kashyap | afazekas: Good question, let me look | 16:46 |
kashyap | Have to download the SRPM from Rawhide, and extract the source to see it. | 16:47 |
kashyap | s/Rawhide/F23/ | 16:50 |
afazekas | kashyap, I will leave soon, don't forget it's needs to work with f21 as well | 16:50 |
kashyap | afazekas: F21 is EOL today. | 16:50 |
kashyap | afazekas: No hurry, this is not super important. | 16:51 |
afazekas | Is not eol as long as we have a gate job :) | 16:51 |
asselin | finally figured out why I can't debug e-r commands: <module 'cmd' from '/home/asselin/git/elastic-recheck/elastic_recheck/cmd/__init__.pyc'> conflicts with pdb.... | 16:51 |
*** woodster_ has joined #openstack-qa | 16:51 | |
kashyap | afazekas: Ah, that ought to be cleaned up too, no? | 16:51 |
*** openstackrecheck has quit IRC | 16:52 | |
*** openstackrecheck has joined #openstack-qa | 16:53 | |
afazekas | kashyap, f21 job is broken and will not be fixed since devstack now depends on package which just moved even to f22 just several day before.. | 16:53 |
kashyap | afazekas: Yeah, saw your patch. I mistakely sent a duplicate one (abandoned now). | 16:54 |
afazekas | kashyap, so enough if it in f22 | 16:54 |
kashyap | afazekas: Noted. | 16:54 |
*** amotoki has quit IRC | 16:55 | |
afazekas | kashyap, FYI 21 is failing since https://review.openstack.org/#/c/246601/ | 16:56 |
afazekas | bye | 16:57 |
ylobankov | oomichi_: done | 16:58 |
*** mriedem is now known as mriedem_meeting | 16:58 | |
*** hemnafk is now known as hemna | 16:59 | |
andreaf | mtreinish: run dates are either defined by the DB insertion time, or, with the new option, it can be overridden to the run start time. test_run dates are embedded into subunit so they're probably more accurate when filtering test level data | 17:00 |
mtreinish | andreaf: yeah, that's what I was thinking. It's a better filter and it actually works | 17:00 |
mtreinish | so just use that start_date | 17:01 |
openstackrecheck | openstack/nova change: https://review.openstack.org/212102 failed because of: gate-grenade-dsvm-multinode: https://bugs.launchpad.net/bugs/1400905 | 17:01 |
openstack | Launchpad bug 1400905 in OpenStack-Gate "Hash Sum mismatch on apt mirrors" [Undecided,Confirmed] | 17:01 |
sdague | mriedem_meeting: do they have anything more than "uses a lot of cpu"? | 17:04 |
*** jlanoux has quit IRC | 17:07 | |
openstackgerrit | Kashyap Chamarthy proposed openstack-dev/devstack: Remove support for Fedora 21 (EOL); add F22 where appropriate https://review.openstack.org/251980 | 17:08 |
*** dtantsur is now known as dtantsur|afk | 17:11 | |
*** yamahata has joined #openstack-qa | 17:14 | |
*** rossella_s has quit IRC | 17:15 | |
*** Swami has joined #openstack-qa | 17:16 | |
*** jecarey_ has quit IRC | 17:21 | |
*** stevemar_znc is now known as stevemar | 17:25 | |
*** yfried has quit IRC | 17:26 | |
armax | mriedem_meeting: nothing from neutron internals talks to the n-api-meta | 17:28 |
armax | so any traffic hitting the service would come from the cloudinit client | 17:29 |
dmellado | query ylobankov | 17:30 |
*** e0ne has quit IRC | 17:30 | |
ylobankov | dmellado: hi | 17:31 |
openstackgerrit | Merged openstack/os-testr: Add colored output feature to subunit-trace https://review.openstack.org/249005 | 17:35 |
openstackgerrit | Merged openstack/os-testr: Add delete *.pyc command before executing ostestr https://review.openstack.org/251701 | 17:36 |
*** maht_ has joined #openstack-qa | 17:36 | |
*** maht_ has quit IRC | 17:36 | |
*** krtaylor has quit IRC | 17:37 | |
openstackgerrit | Merged openstack/os-testr: Change to always parsing classes from test_id https://review.openstack.org/246636 | 17:37 |
*** nadya_ has joined #openstack-qa | 17:37 | |
*** nadya_ has quit IRC | 17:37 | |
*** nadya_ has joined #openstack-qa | 17:38 | |
*** nadya_ has quit IRC | 17:38 | |
*** nadya_ has joined #openstack-qa | 17:39 | |
*** maht has quit IRC | 17:39 | |
*** dzamboni has quit IRC | 17:43 | |
*** mriedem_meeting is now known as mriedem | 17:43 | |
mriedem | armax: the neutron-metadata-agent (proxy) does | 17:43 |
armax | only when there are request for the metadata services | 17:44 |
armax | it’s a proxy | 17:44 |
armax | but it doesn’t act unsolicited | 17:44 |
armax | to the best of my knowledge | 17:44 |
*** yamahata has quit IRC | 17:44 | |
*** achanda has quit IRC | 17:45 | |
*** nadya_ has quit IRC | 17:46 | |
openstackgerrit | John Kasperski proposed openstack-dev/devstack: Neutron: Fix IPv6 provider networks https://review.openstack.org/248927 | 17:51 |
*** achanda has joined #openstack-qa | 17:52 | |
*** sshnaidm has quit IRC | 17:52 | |
*** jasonsb has quit IRC | 17:56 | |
*** austin81 has joined #openstack-qa | 17:56 | |
SpamapS | mtreinish: ok, so the only query I see now is the one with the cartesian product | 17:58 |
SpamapS | mtreinish: turns out sqla _will_ actually do the joins on the FK's for you if you ask right, and it will error out if it can't find fk's to do it. | 17:59 |
SpamapS | mtreinish: so I'm going to redo my patch to be much, much simpler | 17:59 |
*** krtaylor has joined #openstack-qa | 18:02 | |
*** nicholasgoracke has quit IRC | 18:03 | |
openstackrecheck | Console logs not available after 13:21s for gate-requirements-integration-dsvm 251950,1,5852097 | 18:03 |
openstackgerrit | Merged openstack/stackviz: Allow sharing of selected item by page URL. https://review.openstack.org/248293 | 18:08 |
*** yamahata has joined #openstack-qa | 18:11 | |
*** gamado has quit IRC | 18:12 | |
*** eil397 has joined #openstack-qa | 18:14 | |
*** sabeen1 has quit IRC | 18:14 | |
*** aopincar has joined #openstack-qa | 18:17 | |
openstackrecheck | Console logs not available after 13:23s for gate-tempest-dsvm-full 251985,1,4076c60 | 18:18 |
openstackrecheck | openstack/cinder change: https://review.openstack.org/250944 failed gate-cinder-python34 in the gate queue with an unrecognized error | 18:18 |
openstackgerrit | Merged openstack/stackviz: Fix the timeline clipping path. https://review.openstack.org/248297 | 18:19 |
openstackgerrit | Merged openstack/stackviz: Directly link to timeline details for failed tests. https://review.openstack.org/249422 | 18:19 |
*** nicholasgoracke has joined #openstack-qa | 18:20 | |
*** jordanP has quit IRC | 18:20 | |
*** jecarey has joined #openstack-qa | 18:22 | |
mtreinish | SpamapS: ok, cool. I also pushed up: https://review.openstack.org/251673 which will help with that bad query too | 18:23 |
*** artom has joined #openstack-qa | 18:24 | |
SpamapS | mtreinish: err.. it will? | 18:25 |
SpamapS | mtreinish: the problem is the joining of two tables without a condition. | 18:25 |
*** pglass has quit IRC | 18:25 | |
*** jecarey has quit IRC | 18:26 | |
*** mfisher_ora has joined #openstack-qa | 18:28 | |
krotscheck | mtreinish: Looking through the health project - no oslo_db? | 18:31 |
*** yamahata has quit IRC | 18:33 | |
*** austin81 has left #openstack-qa | 18:34 | |
*** yamahata has joined #openstack-qa | 18:35 | |
*** jecarey has joined #openstack-qa | 18:37 | |
*** rcernin has joined #openstack-qa | 18:38 | |
*** safchain has quit IRC | 18:42 | |
*** TC01 has quit IRC | 18:43 | |
openstackgerrit | Merged openstack/tempest-lib: Make git log messsage to shorter https://review.openstack.org/227674 | 18:43 |
*** tosky has quit IRC | 18:47 | |
SpamapS | mtreinish: damn, found another method taking the int id and not the UUID, get_run_metadata | 18:48 |
*** alex_xu has quit IRC | 18:48 | |
*** ifarkas has quit IRC | 18:50 | |
*** artom_ has joined #openstack-qa | 18:51 | |
*** sabeen1 has joined #openstack-qa | 18:51 | |
*** alex_xu has joined #openstack-qa | 18:52 | |
*** artom has quit IRC | 18:54 | |
openstackgerrit | Clint 'SpamapS' Byrum proposed openstack-infra/subunit2sql: Fix get_run_metadata to take UUID https://review.openstack.org/252019 | 18:55 |
*** jasonsb has joined #openstack-qa | 18:56 | |
*** akshai has quit IRC | 18:56 | |
SpamapS | mtreinish: ^ | 18:56 |
openstackrecheck | Console logs not available after 13:29s for gate-tempest-dsvm-full 238309,6,7574e8c | 18:56 |
*** mriedem has quit IRC | 18:56 | |
*** jecarey has quit IRC | 18:57 | |
*** akshai has joined #openstack-qa | 18:57 | |
*** salv-orl_ has joined #openstack-qa | 18:58 | |
*** pglass has joined #openstack-qa | 18:58 | |
*** jecarey has joined #openstack-qa | 18:59 | |
*** rbrndt has quit IRC | 18:59 | |
*** salv-orlando has quit IRC | 19:00 | |
*** mriedem has joined #openstack-qa | 19:01 | |
*** pvaneck has joined #openstack-qa | 19:02 | |
*** patchbot has quit IRC | 19:03 | |
*** jecarey 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 | |
*** binbincong has quit IRC | 19:05 | |
*** binbincong has joined #openstack-qa | 19:06 | |
*** eliqiao has quit IRC | 19:08 | |
*** eliqiao has joined #openstack-qa | 19:09 | |
*** patchbot has joined #openstack-qa | 19:10 | |
*** patchbot has quit IRC | 19:12 | |
SpamapS | mtreinish: never mind, I get it now :) | 19:12 |
*** aopincar has quit IRC | 19:12 | |
openstackrecheck | Console logs not available after 13:32s for gate-cinder-pep8 251989,1,d0bdd4c | 19:13 |
*** patchbot has joined #openstack-qa | 19:13 | |
*** maht has joined #openstack-qa | 19:14 | |
openstackgerrit | Ian Wienand proposed openstack-dev/devstack: Turn off tracing when outputting errors https://review.openstack.org/250577 | 19:15 |
openstackgerrit | Merged openstack-infra/subunit2sql: Properly date filter in get_test_run_dict_by_run_meta_key_value https://review.openstack.org/251673 | 19:15 |
*** armax has quit IRC | 19:16 | |
*** jecarey has quit IRC | 19:18 | |
* SpamapS reorients energy toward counter inspection | 19:18 | |
*** jecarey has joined #openstack-qa | 19:18 | |
mriedem | mtreinish: sdague: we seem to be busted on the uncategorized bugs page http://status.openstack.org/elastic-recheck/data/uncategorized.html | 19:19 |
mriedem | notice it's showing things from 11/16 | 19:19 |
dims | sdague : where's a good spot to install the 2 debs? https://review.openstack.org/#/c/181165/18/files/debs/general,cm | 19:20 |
*** jecarey has quit IRC | 19:22 | |
openstackrecheck | Console logs not available after 13:32s for gate-grenade-dsvm-multinode 242568,5,5a5ef09 | 19:27 |
*** yfried has joined #openstack-qa | 19:28 | |
*** devananda has quit IRC | 19:33 | |
*** jecarey has joined #openstack-qa | 19:34 | |
*** jecarey has quit IRC | 19:35 | |
*** krtaylor has quit IRC | 19:35 | |
*** nic has joined #openstack-qa | 19:36 | |
openstackrecheck | Console logs not available after 13:23s for gate-cinder-python27 251478,2,8af113b | 19:40 |
*** yfried has quit IRC | 19:44 | |
*** devananda has joined #openstack-qa | 19:47 | |
*** rbrndt has joined #openstack-qa | 19:47 | |
*** yfried has joined #openstack-qa | 19:49 | |
*** armax has joined #openstack-qa | 19:51 | |
openstackgerrit | Davanum Srinivas (dims) proposed openstack-dev/devstack: Enable optional Python 3 support https://review.openstack.org/181165 | 19:52 |
openstackrecheck | Console logs not available after 13:28s for gate-keystone-pep8 208488,18,2aa626f | 19:54 |
*** austin81 has joined #openstack-qa | 19:54 | |
*** jecarey has joined #openstack-qa | 20:00 | |
*** aysyd has quit IRC | 20:00 | |
*** pglass has quit IRC | 20:01 | |
*** weshay_xchat has quit IRC | 20:02 | |
mtreinish | krotscheck: well subunit2sql uses oslo.db (which I'm not a fan of) but openstack-health depends on subunit2sql directly | 20:04 |
mtreinish | mriedem: does it, I just did a search for 2015-11-16 and didn't get any hits | 20:05 |
mriedem | mtreinish: the uncategorized page was last generated on 11/17 | 20:05 |
mriedem | i ran it locally and it was fine | 20:05 |
mriedem | so seems the job is dead | 20:05 |
mriedem | i've already put out the clark signal | 20:06 |
mtreinish | mriedem: it says "Generated at: 2015-12-01T19:50" for me | 20:06 |
* krotscheck wonders what that looks like. | 20:06 | |
mriedem | mtreinish: b/c clarkb must have fixed it | 20:06 |
mtreinish | SpamapS: the uuid vs id thing is going to kill both of us before too long | 20:07 |
*** salv-orl_ has quit IRC | 20:07 | |
openstackrecheck | Console logs not available after 13:25s for gate-tempest-dsvm-mongodb-zaqar 195443,44,6ef5eca | 20:08 |
*** erlon has quit IRC | 20:09 | |
sdague | dims: probably inside the conditional around USE_PYTHON3 | 20:10 |
*** artom_ has quit IRC | 20:12 | |
mtreinish | SpamapS: so I'm thinking we'll need to push yet another subunit2sql release shortly | 20:12 |
mtreinish | there have definitely been a lot, this will be the 4th in the past week | 20:14 |
*** weshay_xchat has joined #openstack-qa | 20:15 | |
*** eliqiao has quit IRC | 20:17 | |
*** eliqiao has joined #openstack-qa | 20:20 | |
openstackrecheck | Console logs not available after 13:26s for gate-tempest-dsvm-neutron-full 252008,1,1b0cc98 | 20:21 |
SpamapS | mtreinish: release early, release often | 20:26 |
mtreinish | andreaf, masayukig, oomichi_: if you get a sec: https://review.openstack.org/252019 would be good to land. I'd like to push a release with that included soonish | 20:28 |
andreaf | mtreinish: +A | 20:30 |
mtreinish | andreaf: cool thanks | 20:30 |
*** rfolco has quit IRC | 20:31 | |
openstackgerrit | Merged openstack-infra/subunit2sql: Fix get_run_metadata to take UUID https://review.openstack.org/252019 | 20:33 |
mtreinish | SpamapS: ^^^ ok I'll push a release soonish | 20:33 |
mtreinish | this time its 1.1.0, because we added a cli opt :) | 20:34 |
openstackrecheck | Console logs not available after 13:33s for gate-keystone-pep8 237047,6,2dd3265 | 20:35 |
*** akshai has quit IRC | 20:38 | |
*** sabeen1 has quit IRC | 20:39 | |
openstackgerrit | Eric Harney proposed openstack-dev/devstack: Enable volume manage/unmanage test for Cinder LVM https://review.openstack.org/252056 | 20:45 |
mtreinish | timothyb89, david-lyle, regXboi, jhesketh: if you get a sec: https://review.openstack.org/#/c/231283/ | 20:50 |
openstackrecheck | Console logs not available after 13:27s for gate-keystone-pep8 209600,15,76eb126 | 20:50 |
SpamapS | mtreinish: cool | 20:50 |
*** achanda has quit IRC | 20:50 | |
mtreinish | SpamapS, andreaf: https://pypi.python.org/pypi/subunit2sql/1.1.0 | 20:50 |
mtreinish | luckily this time there isn't a migration to wait for :) | 20:51 |
SpamapS | mtreinish: http://status.openstack.org/openstack-health/#/project/openstack%252Ftempest <-- loads in like 1s | 20:52 |
regXboi | mtreinish: so reviewed | 20:53 |
mtreinish | SpamapS: so funny thing, that's not using the latest subunit2sql | 20:53 |
mtreinish | regXboi: thanks | 20:53 |
SpamapS | mtreinish: blarg | 20:53 |
mtreinish | SpamapS: there's a bug in the puppet module that deploys it, it's still using subunit2sql 0.12.0 or something like that | 20:53 |
mtreinish | it doesn't run pip install with -U | 20:54 |
mtreinish | so I imagine it'll get better when we pull in the query fixes in recent releases :) | 20:54 |
SpamapS | doh | 20:54 |
* mtreinish goes to pester infra about the fix for that again | 20:55 | |
SpamapS | This one is mysteriously slow.. | 20:55 |
SpamapS | http://paste.openstack.org/show/480564/ | 20:55 |
mtreinish | SpamapS: yeah I noticed that yesterday when I was playing with things | 20:57 |
mtreinish | I couldn't figure out what was taking so long | 20:57 |
openstackgerrit | Merged openstack/openstack-health: Fix api command name https://review.openstack.org/251681 | 20:57 |
SpamapS | The explain looks really good | 20:57 |
timothyb89 | mtreinish: +A on that patch | 20:57 |
mtreinish | timothyb89: cool thanks | 20:57 |
mtreinish | heh, well that should pull in the latest subunit2sql now :) | 20:58 |
SpamapS | all indexes.. only one range scan | 20:58 |
mtreinish | but I still want to fix the module | 20:58 |
SpamapS | I guess the range scan could be really painful | 20:58 |
SpamapS | ah ok I think I see it | 20:58 |
mtreinish | SpamapS: oh, that's also the one I changed to not use the runs table at all | 20:58 |
SpamapS | mtreinish: thats the cartesian product again. Oops. | 20:59 |
SpamapS | I don't know why I missed it | 20:59 |
SpamapS | it's just a little better looking because it is using the range scan | 20:59 |
SpamapS | but it does a range scan for every other row that matches | 20:59 |
SpamapS | so, 284160 range scans | 20:59 |
SpamapS | each returning about 1407 rows | 21:00 |
*** gfidente has quit IRC | 21:00 | |
SpamapS | mtreinish: so the run_at index got that down to _ONLY_ 400 million rows ;) | 21:00 |
SpamapS | from I think it was like 9 billion | 21:00 |
mtreinish | hah, well that's much better than it was before | 21:00 |
SpamapS | mtreinish: so health will start doing the new query? | 21:00 |
mtreinish | SpamapS: it should after https://review.openstack.org/#/c/231283/ gets picked up by puppet | 21:01 |
mtreinish | well assuming the reqs bump there will make pip install 1.1.0 | 21:01 |
SpamapS | mtreinish: cool I'm going to stop staring at it | 21:01 |
mtreinish | instead of 1.0.2 | 21:01 |
SpamapS | really need to fix up counter-inspection in the ways jeblair suggested so we can move forward | 21:01 |
SpamapS | mtreinish: it will pick up 1.1.0 yeah | 21:02 |
openstackrecheck | Console logs not available after 13:24s for gate-grenade-dsvm-multinode 251045,4,baad5d8 | 21:04 |
openstackrecheck | openstack/cinder change: https://review.openstack.org/245241 failed because of: gate-grenade-dsvm: https://bugs.launchpad.net/bugs/1446583 | 21:04 |
openstack | Launchpad bug 1446583 in oslo.service "services no longer reliably stop in stable/liberty / master" [Critical,Fix released] - Assigned to Marian Horban (mhorban) | 21:04 |
*** SpamapS is now known as TheKettle | 21:04 | |
*** TheKettle is now known as SpamapS | 21:04 | |
openstackgerrit | Merged openstack/openstack-health: Add a rest api to get a test_runs time series by test https://review.openstack.org/231283 | 21:06 |
*** salv-orlando has joined #openstack-qa | 21:07 | |
*** maht has quit IRC | 21:12 | |
*** maht has joined #openstack-qa | 21:12 | |
*** salv-orlando has quit IRC | 21:19 | |
*** harlowja has quit IRC | 21:27 | |
*** harlowja has joined #openstack-qa | 21:28 | |
*** hemna is now known as hemnafk | 21:29 | |
*** salv-orlando has joined #openstack-qa | 21:31 | |
*** rcernin has quit IRC | 21:31 | |
*** salv-orl_ has joined #openstack-qa | 21:35 | |
*** salv-orl_ has quit IRC | 21:35 | |
*** salv-orlando has quit IRC | 21:36 | |
mtreinish | SpamapS: so the updated query is still taking it's time: http://paste.openstack.org/show/480568/ | 21:36 |
*** sabeen has joined #openstack-qa | 21:36 | |
*** salv-orl_ has joined #openstack-qa | 21:37 | |
mtreinish | took about 5 min... | 21:38 |
*** salv-orl_ has quit IRC | 21:40 | |
*** salv-orlando has joined #openstack-qa | 21:41 | |
*** sabeen3 has joined #openstack-qa | 21:41 | |
*** sabeen has quit IRC | 21:43 | |
*** krtaylor has joined #openstack-qa | 21:44 | |
*** salv-orlando has quit IRC | 21:45 | |
*** salv-orlando has joined #openstack-qa | 21:46 | |
SpamapS | mtreinish: 680220 rows in total.. 5 minutes still sounds high. | 21:46 |
SpamapS | mtreinish: could consider a run_id, key, value index | 21:46 |
SpamapS | mtreinish: OH, hm, that test_id, start_time index probably isn't helping much | 21:49 |
SpamapS | mtreinish: you can't do a ref + range scan | 21:49 |
SpamapS | mtreinish: in fact, would be better off with a test_id index. | 21:50 |
SpamapS | but not much | 21:50 |
SpamapS | mtreinish: yeah, that one is just a LOT of data | 21:50 |
*** nicholasgoracke has quit IRC | 21:50 | |
SpamapS | mtreinish: I think a run_id, key, value index will chop it down to < 1 minute | 21:51 |
mtreinish | SpamapS: so should I write a migration to add a composite index on run_id, key and value for the run_metadata table? | 21:53 |
*** salv-orlando has quit IRC | 21:54 | |
*** mfisher_ora has quit IRC | 21:54 | |
*** salv-orlando has joined #openstack-qa | 21:55 | |
*** weshay_xchat has quit IRC | 22:00 | |
*** nicholasgoracke has joined #openstack-qa | 22:01 | |
*** vgridnev has quit IRC | 22:11 | |
*** salv-orlando has quit IRC | 22:12 | |
*** salv-orlando has joined #openstack-qa | 22:13 | |
*** weshay_xchat has joined #openstack-qa | 22:13 | |
*** dtroyer has quit IRC | 22:14 | |
*** dtroyer has joined #openstack-qa | 22:15 | |
*** shardy has quit IRC | 22:15 | |
*** salv-orl_ has joined #openstack-qa | 22:18 | |
*** harlowja has quit IRC | 22:19 | |
*** dwalleck has joined #openstack-qa | 22:20 | |
*** harlowja has joined #openstack-qa | 22:21 | |
*** dwalleck has quit IRC | 22:22 | |
openstackgerrit | Martin Hickey proposed openstack-dev/devstack: Neutron FWaaS: Use generated configuration files if available https://review.openstack.org/252087 | 22:23 |
*** dwalleck_ has joined #openstack-qa | 22:23 | |
*** salv-orlando has quit IRC | 22:23 | |
*** mwagner_lap has quit IRC | 22:24 | |
*** dwalleck_ has quit IRC | 22:27 | |
*** dwalleck has joined #openstack-qa | 22:29 | |
*** dwalleck has quit IRC | 22:29 | |
*** dwalleck has joined #openstack-qa | 22:30 | |
SpamapS | mtreinish: I don't know if < 1 minute is fast enough | 22:30 |
SpamapS | mtreinish: but the optimizer may be smarter than I think. ;) | 22:31 |
mtreinish | SpamapS: well < 1min is faster than 5min :) | 22:36 |
mtreinish | and 5min is definitely too long for a page to load | 22:36 |
SpamapS | 5s is too long | 22:36 |
SpamapS | IMO | 22:36 |
mtreinish | well ignoring that there is a bug in the js, so the request it's making is wrong too (but that's a different matter) | 22:36 |
SpamapS | mtreinish: better would be to define buckets that are viewable, and instead of range queries, you just have single key reads | 22:38 |
SpamapS | mtreinish: but that's my "page load times to 0" thinking ;) | 22:39 |
mtreinish | SpamapS: I'm not sure I follow, what would that look like? | 22:42 |
openstackrecheck | Console logs not available after 13:25s for gate-tempest-dsvm-neutron-full-kilo 251045,4,4c87da6 | 22:43 |
SpamapS | mtreinish: so if you want to have a "day" view, you have a date field and do = '2015-11-11', | 22:44 |
*** edmondsw has quit IRC | 22:44 | |
mtreinish | SpamapS: oh, I get it now :) | 22:45 |
SpamapS | mtreinish: range queries _are fast_, but single reads _are faster_ ;) | 22:45 |
*** davideagnello has quit IRC | 22:45 | |
*** davideagnello has joined #openstack-qa | 22:45 | |
mtreinish | well that's something to experiment with, it shouldn't be too bad to test | 22:45 |
*** hemnafk is now known as hemna | 22:45 | |
SpamapS | mtreinish: but actually I think that compound index would cut the time more than 6x | 22:46 |
SpamapS | mtreinish: I'm playing with my super slow test box ;) | 22:46 |
*** davideagnello has quit IRC | 22:48 | |
*** davideagnello has joined #openstack-qa | 22:48 | |
SpamapS | mtreinish: actually, in reality...... | 22:48 |
SpamapS | mtreinish: does run_metadata need a .id ? | 22:48 |
SpamapS | mtreinish: feels like run_id+key+value == pk ;) | 22:49 |
SpamapS | though thats.. a really big pk | 22:49 |
SpamapS | mtreinish: anyway, even if you just make it a unique key... the optimizer does some nice tricks with unique keys. :) | 22:50 |
*** davideag_ has joined #openstack-qa | 22:50 | |
*** austin81 has left #openstack-qa | 22:52 | |
*** davideagnello has quit IRC | 22:53 | |
*** chmouel has quit IRC | 22:55 | |
*** chmouel has joined #openstack-qa | 22:56 | |
*** salv-orl_ has quit IRC | 22:56 | |
mtreinish | SpamapS: so make run_id + key + value a unique | 22:57 |
*** harlowja has quit IRC | 22:57 | |
mtreinish | which it should be | 22:57 |
SpamapS | mtreinish: yeah, it should be, and if you enforce that on the insert, then the optimizer will prefer that index in many cases | 22:58 |
SpamapS | for obvious reasons. :) | 22:58 |
*** mriedem has quit IRC | 22:58 | |
SpamapS | that said.. ultimately you're just slave to the range query on test_runs | 22:59 |
*** harlowja has joined #openstack-qa | 23:01 | |
*** dkranz has quit IRC | 23:02 | |
*** regXboi has quit IRC | 23:02 | |
*** jecarey has quit IRC | 23:08 | |
SpamapS | mtreinish: yeah, the problem isn't run_metadata | 23:08 |
SpamapS | mtreinish: ultimately, the problem is that start_time range scan | 23:09 |
*** nicholasgoracke has quit IRC | 23:09 | |
SpamapS | mtreinish: takes 45s to run SELECT COUNT(*) FROM tests INNER JOIN test_runs ON test_runs.test_id = tests.id WHERE test_runs.start_time >= '2015-11-11 21:22:59' AND test_runs.start_time <= '2015-12-01 21:22:59' | 23:09 |
mtreinish | SpamapS: :( there's too much data I guess | 23:10 |
*** dimtruck is now known as zz_dimtruck | 23:10 | |
*** binbincong has quit IRC | 23:10 | |
SpamapS | mtreinish: the migration, no doubt, had a huge impact on the speed of this query. With 36 byte varchars to join to tests, it would likely take 10 minutes just for this count. ;) | 23:13 |
*** binbincong has joined #openstack-qa | 23:13 | |
*** maht has quit IRC | 23:14 | |
SpamapS | mtreinish: one wonders why the query optimizer is going in the direction it is though. :-P | 23:14 |
*** maht has joined #openstack-qa | 23:14 | |
openstackrecheck | Console logs not available after 13:23s for gate-tempest-dsvm-neutron-full 238309,7,159984d | 23:16 |
*** maht has quit IRC | 23:16 | |
*** dwalleck has quit IRC | 23:16 | |
*** maht has joined #openstack-qa | 23:17 | |
SpamapS | mtreinish: another index that might help would be on test_runs, (run_id, start_time) | 23:17 |
mtreinish | SpamapS: I thought we had one like that | 23:18 |
mtreinish | oh, it's test_id not run_id :) | 23:19 |
SpamapS | right | 23:19 |
SpamapS | which is why the ALL table is tests | 23:19 |
*** david-lyle has quit IRC | 23:25 | |
*** jecarey has joined #openstack-qa | 23:25 | |
*** mwagner_lap has joined #openstack-qa | 23:27 | |
*** jecarey has quit IRC | 23:29 | |
openstackrecheck | Console logs not available after 13:29s for gate-swift-pep8 252085,1,0ac62ca | 23:30 |
*** e0ne has joined #openstack-qa | 23:34 | |
*** e0ne has quit IRC | 23:36 | |
*** e0ne has joined #openstack-qa | 23:36 | |
*** e0ne_ has joined #openstack-qa | 23:39 | |
*** tochi has joined #openstack-qa | 23:40 | |
*** e0ne has quit IRC | 23:41 | |
*** dstanek has quit IRC | 23:41 | |
*** dstanek has joined #openstack-qa | 23:41 | |
openstackrecheck | Console logs not available after 13:26s for gate-glance-python27 252086,1,f2adda8 | 23:44 |
*** e0ne has joined #openstack-qa | 23:49 | |
*** e0ne_ has quit IRC | 23:51 | |
*** weshay_xchat has quit IRC | 23:51 | |
*** e0ne_ has joined #openstack-qa | 23:52 | |
openstackgerrit | Ken'ichi Ohmichi proposed openstack/tempest: Make create/update_image use **kwargs https://review.openstack.org/251310 | 23:53 |
openstackgerrit | Ken'ichi Ohmichi proposed openstack/tempest: Add docstring for update_image_member https://review.openstack.org/251325 | 23:53 |
openstackgerrit | Ken'ichi Ohmichi proposed openstack/tempest: Rename add_image_member to create_image_member https://review.openstack.org/251321 | 23:53 |
openstackgerrit | Ken'ichi Ohmichi proposed openstack/tempest: Rename image_client to images_client https://review.openstack.org/251317 | 23:53 |
*** e0ne has quit IRC | 23:54 | |
*** rbrndt has quit IRC | 23:57 | |
*** salv-orlando has joined #openstack-qa | 23:59 |
Generated by irclog2html.py 2.14.0 by Marius Gedminas - find it at mg.pov.lt!