Earlier  
Later
New Search
Posted Nick Remark
#openstack-nova - 2017-04-07
20:04:18 mriedem i know you can't do that in db2, but i think mysql lets you get by with it
20:04:31 zzzeek mriedem: yes but the rules for if NULL is counted are not necessarily consistent across backends
20:06:12 mriedem https://www.postgresql.org/docs/9.0/static/indexes-unique.html
20:06:16 mriedem Null values are not considered equal.
20:06:16 zzzeek mriedem: A UNIQUE index creates a constraint such that all values in the index must be distinct. An error occurs if you try to add a new row with a key value that matches an existing row. For all engines, a UNIQUE index permits multiple NULL values for columns that can contain NULL.
20:06:32 zzzeek mriedem: yeah I think SQL server is the one that might be different
20:06:38 mriedem and db2
20:07:00 mriedem i at least know that db2 never allowed a unique constraint with nullable columns
20:07:09 mriedem it would allow a unique index though i think...
20:07:22 mriedem it's been a long time since i had to remember
20:07:40 zzzeek db2 makes oracle look like sqlite, installation-wise, so ive hardly ever run a DB2
20:07:44 mriedem anyway, it sounds like mysql and postgresql are ok with this
20:07:47 zzzeek yep
20:07:58 mriedem db2 install requires a phd i think
20:08:11 sdague mriedem: just half a shelf of manuals
20:08:21 mriedem certified db2 installer
20:08:45 mriedem i think i asked someone 5 years ago for a db2 server rpm for simple install and was laughed at
20:09:20 sdague which, is kind of dumb, because honestly the install steps are very repeatable
20:09:48 sdague they wrote them in the manual, why they didn't just write them in the rpm post-install always blew my mind
20:09:53 sdague brb
20:10:23 mriedem zzzeek: if i wanted to make a column unique=True in an alter during an offline migration, is that a pretty bad time sink?
20:10:28 mriedem for the compute_nodes table
20:10:51 mriedem so not something as big as the instances table, compute_nodes is what, 10s of thousands at biggest?
20:10:59 zzzeek mriedem: well it probably depends on the datatypes you're uniquing, it has to build an index
20:11:00 mriedem not sure where rax is at this point
20:11:12 zzzeek 10's of thousands is not much
20:11:16 mriedem uuid = Column(String(36), nullable=True)
20:11:59 zzzeek it should not be a huge time sink but, I dont have an ironclad guarantee on that
20:12:17 zzzeek if youre < 1M rows, nothing should be that big of a deal
20:12:30 mriedem i don't think cern is running 1M compute nodes yet
20:21:50 openstackgerrit Anusha Unnam proposed openstack/nova master: Add description to policies in server_password.py https://review.openstack.org/452259
20:26:02 mriedem dtp: some comments in https://review.openstack.org/#/c/453025/
20:27:37 dtp ok mriedem
20:29:24 openstackgerrit Anusha Unnam proposed openstack/nova master: fix admin context scenarios for cinderclient https://review.openstack.org/384799
20:32:53 openstackgerrit Pushkar Umaranikar proposed openstack/nova-specs master: Stop using Neutron admin token https://review.openstack.org/439890
20:33:28 openstackgerrit Pushkar Umaranikar proposed openstack/nova-specs master: Use service token to authorize neutron port binding https://review.openstack.org/439890
20:41:38 openstackgerrit Matt Riedemann proposed openstack/nova master: Add compute_nodes_uuid_idx unique index https://review.openstack.org/454887
20:41:46 mriedem dtp: ^ is the unique index for compute_nodes.uuid
20:41:50 openstackgerrit Brianna Poulos proposed openstack/nova-specs master: API Option for Signature Verification https://review.openstack.org/312225
20:42:06 dtp ok
20:42:33 openstackgerrit Anusha Unnam proposed openstack/nova master: Add description to policies in servers.py https://review.openstack.org/451966
20:47:18 mriedem dtp: you want me to start working the online data migration patch to live on top of this one?
20:47:24 mriedem the services.uuid patch i mean
20:47:33 dtp that's fine w/ me
20:49:21 openstackgerrit Eric Fried proposed openstack/nova master: PowerVM Driver: spawn/delete #1: no-ops https://review.openstack.org/438119
20:49:35 efried mriedem ^^ requirements bump to match latest g-r
20:49:59 efried mriedem Thanks for the detailed review on #2 as well. Working through it.
20:55:04 openstackgerrit Matt Riedemann proposed openstack/nova master: Remove dead db api code https://review.openstack.org/454889
20:55:05 mriedem dansmith: fun one for you ^
20:55:55 dansmith "fun"
21:05:13 student_ Hi there, I think I have an issue with the nova resources management, I do not have any instance running but it tells me "No valid host was found. There are not enough hosts available."
21:05:49 student_ I think it is a config problem with nova, when I am using "nova hypervisor list" command it brings me empty table
21:06:29 student_ it looks like it is waiting to populate, but I cannot create new instances so it is not working
21:06:53 student_ and I am using newton on Ubuntu 16.04
21:15:10 mriedem student_: nova hypervisor list being empty means your nova-compute services aren't registered
21:15:15 mriedem there is a problem with the compute nodes checking in to the controller
21:15:20 mriedem has nothing to do with running instances
21:15:40 mriedem this isn't really the channel for debugging that,
21:15:51 mriedem see the channel topic - #openstack is better for general questions like this
21:21:13 student_ mriedem they have send me here :|
21:21:43 mriedem well your compute node isn't checking in so i'd check your nova-compute logs for errors
21:21:56 mriedem and make sure it's configured correctly to talk to the controller
21:22:26 student_ mriedem I have only one server- controller node
21:22:36 student_ my nova-conductor.log http://paste.openstack.org/show/605649/ also nova-scheduler.log file http://paste.openstack.org/show/605647/
21:47:48 efried student_ First suspect is to check the compute log (might be called nova-compute.log or n-cpu.log) and see if an exception prevented that guy from starting up.
21:50:34 student_ efried thank you I will check it out
21:50:44 efried student_ Good luck.
21:56:19 openstackgerrit Matt Riedemann proposed openstack/nova master: Add uuid to Service model https://review.openstack.org/453025
21:56:20 openstackgerrit Matt Riedemann proposed openstack/nova master: Add online data migration for populating services.uuid https://review.openstack.org/454899
22:07:31 openstackgerrit Takashi NATSUME proposed openstack/nova master: Add a functional test for 'removeFloatingIp' action https://review.openstack.org/453026
22:41:24 openstackgerrit Takashi NATSUME proposed openstack/nova master: api-ref: Example verification for servers-actions.inc https://review.openstack.org/454565
22:50:48 openstackgerrit Eric Fried proposed openstack/nova master: PowerVM Driver: spawn/destroy #3: TaskFlow https://review.openstack.org/438729
22:51:14 efried harlowja ^^ Digging those timing listeners!
22:53:55 harlowja efried sweeet
22:54:20 harlowja should be possible to do other crazy things if u want
22:54:44 efried harlowja I can see that.
22:54:45 harlowja like i always imagined a (mostly) real-time-dashboard that would show the workflow progressing
22:54:55 efried So far we only wanted to do these two crazy things in particular
22:54:56 harlowja it'd be like the ulitmate debug/visualization
22:55:08 harlowja like, not only do u have the logs from nova
22:55:13 harlowja but here is the trace of the workflow
22:55:26 efried harlowja https://pastebin.com/raw/wPk9F9Cs
22:55:50 harlowja ya, timing stuffs
22:55:57 harlowja nice to have to diagnoiss problems
22:57:10 harlowja i always wanted to integrate it with osprofiler more
22:57:18 harlowja maybe somedday, ha
#openstack-nova - 2017-04-08
00:53:07 openstackgerrit STEW TY proposed openstack/nova master: Transform instance.rescue notifications https://review.openstack.org/385644
01:13:39 openstackgerrit Matt Riedemann proposed openstack/nova-specs master: Update "Reserve NUMA nodes with PCI devices attached" https://review.openstack.org/454117
01:31:23 openstackgerrit Matt Riedemann proposed openstack/nova master: Add compute_nodes_uuid_idx unique index https://review.openstack.org/454887
02:20:08 openstackgerrit Vladik Romanovsky proposed openstack/nova master: Support HTTP CONNECT in websocket proxy https://review.openstack.org/454226
02:20:09 openstackgerrit Vladik Romanovsky proposed openstack/nova master: Add spice-native type https://review.openstack.org/454940
06:41:03 alex_xu mriedem: just checked the email, thinking of we may need another microversion or just deprecate quota-class-set api.
08:01:34 openstackgerrit MarkMielke proposed openstack/nova master: Resource tracker should use Block Device Mappings https://review.openstack.org/430091
09:25:16 openstackgerrit Pushkar Umaranikar proposed openstack/nova-specs master: Use service catalog to get endpoint URLs https://review.openstack.org/454983
17:01:05 openstackgerrit Matt Riedemann proposed openstack/nova master: WIP: Remove temporary code from _delete_while_booting https://review.openstack.org/455007
17:14:38 openstackgerrit Pushkar Umaranikar proposed openstack/nova-specs master: Use service catalog to get endpoint URLs https://review.openstack.org/454983
17:20:47 openstackgerrit Pushkar Umaranikar proposed openstack/nova-specs master: Use service catalog to get endpoint URLs https://review.openstack.org/454983
21:10:22 openstackgerrit Matt Riedemann proposed openstack/nova-specs master: Deprecate os-virtual-interfaces (spec) https://review.openstack.org/455023
#openstack-nova - 2017-04-09
18:21:37 openstackgerrit Matt Riedemann proposed openstack/nova master: WIP: Remove temporary code from _delete_while_booting https://review.openstack.org/455007
18:21:38 openstackgerrit Matt Riedemann proposed openstack/nova master: Get BDMs when we need to in _handle_cell_delete https://review.openstack.org/455079

Earlier   Later