Earlier  
Later
New Search
Posted Nick Remark
#openstack-nova - 2019-05-07
11:39:53 openstackgerrit John Garbutt proposed openstack/nova-specs master: Add Unified Limits Spec https://review.opendev.org/602201
11:43:32 openstackgerrit Lee Yarwood proposed openstack/nova stable/rocky: Use migration_status during volume migrating and retyping https://review.opendev.org/657577
11:43:50 openstackgerrit Lee Yarwood proposed openstack/nova stable/queens: Use migration_status during volume migrating and retyping https://review.opendev.org/657579
11:50:31 openstackgerrit Balazs Gibizer proposed openstack/nova stable/stein: Log when port resource is leaked during port delete https://review.opendev.org/657581
11:54:46 openstackgerrit Balazs Gibizer proposed openstack/nova-specs master: Resource provider - request group mapping in allocation candidate https://review.opendev.org/597601
12:05:31 ygk_12345 hi all
12:05:48 ygk_12345 can someone help me how to get a vm's flavor from the nova database
12:06:08 mriedem instance_extras.flavor column
12:06:39 mriedem *instance_extra
12:06:40 mriedem https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/models.py#L386
12:08:03 gibi ygk_12345: mysql nova_cell1 -e 'select flavor from instance_extra;'
12:08:15 gibi ahh mriedem was faster
12:09:08 ygk_12345 gibi: ok thanks got it :)
12:09:29 ygk_12345 gibi: but is there a way to get that name of the flavor only in the output ?
12:09:51 mriedem ygk_12345: original_name is provided in the output i think
12:10:05 mriedem https://developer.openstack.org/api-ref/compute/?expanded=show-server-details-detail#show-server-details
12:10:10 mriedem flavor.original_name
12:10:16 mriedem that's available since microversion 2.47
12:10:51 ygk_12345 mriedem: is flavor a table ?
12:11:02 gibi and there is "name" key in the flavor json in the database
12:11:19 mriedem flavors is a table in the nova_api db yes
12:11:31 mriedem but the flavor used to create the instance is not necessarily still in that table,
12:11:37 mriedem or with the same values, i.e. extra specs
12:11:53 mriedem the copy of the flavor used to create or last resize the instance is in the instance_extra table
12:12:06 ygk_12345 gibi: yes I see but how to get it only in the query output. I am getting all the cluttered output
12:12:22 mriedem ygk_12345: it's stored as a json blob in the instance_extra table
12:12:27 gibi ygk_12345: ^^
12:12:28 mriedem so you'd have to deserialize it
12:12:51 mriedem gibi: were you planning on backporting https://review.opendev.org/#/q/topic:bug/1819923+(status:open+OR+status:merged) ? i'm wondering about ordering for https://review.opendev.org/#/c/651945/
12:13:32 ygk_12345 gibi: mriedem now I see in the nova_api db. I will extract it somehow. Thanks for your time guys
12:14:10 mriedem just remember what i said about the flavor used to create the server may not be in the flavors table anymore
12:15:26 gibi mriedem: yes, I'm planning to backport heal port allocation to stein
12:16:23 gibi mriedem: if https://review.opendev.org/#/c/651945/ merges then I will handle the conflicts
12:18:04 gibi or we might consider https://review.opendev.org/#/c/651945/ also as a backport
13:22:47 mriedem tssurya: i'm reviewing your locked_reason patch so hold up if you're making changes
13:22:57 tssurya mriedem: yea I am
13:23:07 tssurya ok will hold up :)
13:23:23 tssurya bauzas: hi-fi
13:23:34 bauzas \o
13:24:50 tssurya gibi: thanks for the review on the locked_reason patch, sorry for the big patch size, couldn't help it
13:25:22 gibi tssurya: no worries. at the end it was fairly easy to review
13:25:30 gibi tssurya: thanks for working on that feature
13:25:45 tssurya mriedem: while you are reviewing could you confirm if you are okay with the comment here? : https://review.opendev.org/#/c/648662/8/api-ref/source/servers-actions.inc@640
13:25:59 tssurya gibi: :)
13:49:50 openstackgerrit Balazs Gibizer proposed openstack/nova stable/stein: Reproduce bug #1819460 in functional test https://review.opendev.org/657600
13:49:51 openstackgerrit Balazs Gibizer proposed openstack/nova stable/stein: Handle placement error during re-schedule https://review.opendev.org/657602
13:49:51 openstackgerrit Balazs Gibizer proposed openstack/nova stable/stein: Fix exception type in test_boot_reschedule_fill_provider_mapping_raises https://review.opendev.org/657601
13:49:51 openstack bug 1819460 in OpenStack Compute (nova) stein "instance stuck in BUILD state due to unhandled exceptions in conductor" [Medium,Confirmed] https://launchpad.net/bugs/1819460
13:49:52 openstackgerrit Balazs Gibizer proposed openstack/nova stable/stein: Only call _fill_provider_mapping if claim succeeds https://review.opendev.org/657603
13:55:39 mriedem huh, auto_disk_config is a valid filter parameter for listing servers but not handled in the DB API at all from what i can tell
13:55:48 mriedem oh well, it's xen only anyway
14:02:09 openstackgerrit Dan Smith proposed openstack/nova master: Add a workaround config toggle to refuse ceph image upload https://review.opendev.org/657078
14:08:38 openstackgerrit Rodolfo Alonso Hernandez proposed openstack/os-vif stable/stein: Prevent "qbr" Linux Bridge from replying to ARP messages https://review.opendev.org/655678
14:17:43 mriedem tssurya: done
14:17:46 mriedem might be a record
14:18:42 tssurya mriedem: thanks! record for a hard rain of comments?
14:18:45 tssurya :D
14:18:50 openstackgerrit Rodolfo Alonso Hernandez proposed openstack/os-vif stable/rocky: Prevent "qbr" Linux Bridge from replying to ARP messages https://review.opendev.org/655692
14:19:14 mriedem tssurya: yeah
14:19:36 openstackgerrit Rodolfo Alonso Hernandez proposed openstack/os-vif stable/queens: Prevent "qbr" Linux Bridge from replying to ARP messages https://review.opendev.org/655694
14:19:54 tssurya mriedem: heh but thanks a lot for the time, I'll work on them
14:20:40 tssurya mriedem: btw am I causing these tests to fail ? http://logs.openstack.org/62/648662/8/check/openstack-tox-py36/7604398/testr_results.html.gz
14:20:48 tssurya I couldn't find the cause
14:21:27 mriedem no
14:21:36 mriedem http://status.openstack.org/elastic-recheck/#1823251
14:21:54 tssurya mriedem: oh cool thanks
14:29:08 mriedem dansmith: did you see my question/concern on the image type request filter patch regarding bfv instances?
14:29:13 mriedem i didn't -1 yet
14:29:38 dansmith no
14:30:59 mrch_ had anyone problems upping novacompute after upgrade queens>rocky (centos)?
14:37:42 openstackgerrit Rodolfo Alonso Hernandez proposed openstack/os-vif stable/rocky: Prevent "qbr" Linux Bridge from replying to ARP messages https://review.opendev.org/655692
14:38:19 openstackgerrit Rodolfo Alonso Hernandez proposed openstack/os-vif stable/queens: Prevent "qbr" Linux Bridge from replying to ARP messages https://review.opendev.org/655694
14:49:40 openstackgerrit Matt Riedemann proposed openstack/nova master: api-ref: fix mention of all_tenants filter for non-admins https://review.opendev.org/657620
14:50:54 mriedem sorrison: you know how you added the "os_compute_api:servers:allow_all_filters" policy rule? if using all_tenants as the filter parameter, that could still be filtered out for non-admins because all_tenants has it's own specific rules (os_compute_api:servers:index:get_all_tenants and os_compute_api:servers:detail:get_all_tenants)
14:51:20 mriedem it seems that os_compute_api:servers:allow_all_filters should also apply to the all_tenants filter, yeah?
15:01:05 openstackgerrit Dan Smith proposed openstack/nova master: Make libvirt expose supported image types https://review.opendev.org/653454
15:01:05 openstackgerrit Dan Smith proposed openstack/nova master: Expose Hyper-V supported image types https://review.opendev.org/655137
15:01:06 openstackgerrit Dan Smith proposed openstack/nova master: Add vmware driver image type capabilities https://review.opendev.org/655730
15:01:06 openstackgerrit Dan Smith proposed openstack/nova master: Add ironic driver image type capabilities https://review.opendev.org/655729
15:01:07 openstackgerrit Dan Smith proposed openstack/nova master: Add zvm driver image type capabilities https://review.opendev.org/655732
15:01:07 openstackgerrit Dan Smith proposed openstack/nova master: Add xenapi driver image type capabilities https://review.opendev.org/655731
15:01:08 openstackgerrit Dan Smith proposed openstack/nova master: Enable image type query support in nova-next https://review.opendev.org/656903
15:01:08 openstackgerrit Dan Smith proposed openstack/nova master: Add image type request filter https://review.opendev.org/656413
15:01:09 openstackgerrit Dan Smith proposed openstack/nova master: Add docs for image type support request filter https://review.opendev.org/657025
15:03:10 dansmith mriedem: I've been thinking about the tracing thing too
15:05:14 dansmith more about making the existing filters log what they're doing, but the timer thing is legit too
15:08:42 mriedem i'd think that osprofiler should be handling the time spent in each filter, but not sure how granular that is
15:10:42 dansmith meaning we need some sort of hook thing?
15:12:06 mriedem i'm not sure if the @profiler.trace_cls decorator on the SchedulerAPI (rpc) gives us what we'd want there
15:12:15 mriedem since select_destinations is a call it might, but not sure
15:12:41 openstackgerrit Surya Seetharaman proposed openstack/nova master: [Docs] Change the server query parameter display into a list docs. https://review.opendev.org/657624
15:14:42 mriedem there was a recent ML thread about nicer osprofiler visualizations but i can't find it
15:16:24 mriedem oh right, something like this http://logs.openstack.org/69/617269/3/check/tempest-smoke-py3-osprofiler-redis/d5563c0/osprofiler-traces/trace-58ed6da6-f2c8-418c-9c60-337bf00ad86a.html.gz
15:16:29 openstackgerrit Surya Seetharaman proposed openstack/nova master: [Docs] Change the server query parameter display into a list. https://review.opendev.org/657624
15:16:33 mriedem not sure how to easily find a server create trace in there
15:21:37 dansmith mriedem: well, I'll start something and you can add to it if you want
15:22:08 dansmith it'd be really nice if we could see what the reqspec looks like before/after in a generic way, but that's probably too detailed and too fragile, vs. each one just logging what it's doing
15:22:39 mriedem i guess http://logs.openstack.org/69/617269/3/check/tempest-smoke-py3-osprofiler-redis/d5563c0/osprofiler-traces/trace-46016681-2a3d-4ca2-adf7-c4941649d753.html.gz and filter on nova-scheduler
15:23:08 mriedem doesn't give me the time per filter though
15:23:39 mriedem just says that like select_destinations took 302ms

Earlier   Later