| Posted | Nick | Remark | |
|---|---|---|---|
| #openstack-nova - 2017-04-07 | |||
| 19:51:52 | mriedem | to keep ttx at bay | |
| 19:52:30 | cdent | \o/ | |
| 19:56:28 | mriedem | we can have an index on a nullable column right? | |
| 19:56:35 | mriedem | wondering if we should put an index on services.uuid | |
| 19:56:40 | mriedem | for the lookups that the api will be doing | |
| 19:57:22 | mriedem | we don't have one for compute_nodes though i guess | |
| 19:57:35 | mriedem | maybe we should, we look those up by a list of uuids from the scheduler, but would an index help there/ | |
| 19:57:36 | mriedem | ? | |
| 19:57:54 | mriedem | where is leakypipes when i need him | |
| 20:02:49 | mriedem | hmm, if we declared the field as unique=True we wouldn't have to index it, but these are not specified that way, presumably b/c they are nullable=True for existing entries that are None | |
| 20:03:55 | mriedem | zzzeek: can you have a unique=True and nullable=True column? | |
| 20:04:06 | mriedem | or does the nullable=True defeat the unique constraint? | |
| 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 | |