| Posted | Nick | Remark | |
|---|---|---|---|
| #openstack-nova - 2023-07-04 | |||
| 15:09:02 | bauzas | so you should have 3 DBs : one for the API, one for cell0 and one (at least) for *one* cell | |
| 15:09:25 | bauzas | you should have *at least* 3 (I mean) | |
| 15:10:48 | sahid | nova, nova_api and nova_cell0 | |
| 15:11:17 | sahid | https://etherpad.opendev.org/p/cells | |
| 15:12:20 | sahid | bauzas: the issue we have is that, we are trying to archive deleted instances | |
| 15:12:33 | sahid | but when executing the script they stay | |
| 15:12:57 | sahid | and nothing in shadow tables | |
| 15:16:05 | sean-k-mooney | the nova database there is the nova cell 1 database | |
| 15:16:32 | sean-k-mooney | sahid: some tools did that but we recommend actully not calling it nova but nova_cell1 | |
| 15:16:47 | sean-k-mooney | basicly it simpliced upgrades so they kept the old name | |
| 15:16:57 | bauzas | sahid: sean-k-mooney: mmm, I wonder why the cell1 doesn't have a name | |
| 15:17:28 | sean-k-mooney | the actuall db schame name is not used for anything | |
| 15:17:54 | sean-k-mooney | when we splict the monolitic nova db into the celldb and api db | |
| 15:18:13 | sean-k-mooney | most instaler did that by extracting the api tables into a differnt schema | |
| 15:18:24 | sean-k-mooney | and reusing the existing db as the cell1 db | |
| 15:19:27 | bauzas | ok, but then I wonder why nova-manage db archive_deleted_rows doesn't work | |
| 15:22:24 | sahid | bauzas, sean-k-mooney I should perhaps try to name cell1 the cell with empty name? | |
| 15:22:53 | sean-k-mooney | it should wrok waht is the error | |
| 15:23:09 | sean-k-mooney | where was it run | |
| 15:23:11 | sahid | no errors are reported | |
| 15:23:18 | sahid | but nothing change | |
| 15:23:23 | sean-k-mooney | it gets the info form the nova.conf | |
| 15:23:54 | sean-k-mooney | does the nova.conf have the api and cell db set | |
| 15:25:31 | sahid | it has section [database] that mentions as connection = .../nova_cell0 | |
| 15:25:34 | sahid | and .. | |
| 15:26:02 | sahid | [api_database] that mentions as connection = .../nova_api | |
| 15:26:30 | sahid | (for both of the section we have a slave_connection) | |
| 15:27:55 | bauzas | sahid: you shouldn't mention the cell0 connection string in the nova.conf | |
| 15:28:23 | bauzas | [database] should refer to to cell connection it's attached to | |
| 15:28:50 | sean-k-mooney | it depends on which service that nova.confi is for | |
| 15:29:16 | sean-k-mooney | if it was the api's nova.conf or sheduler then pointing at cell0 is fine | |
| 15:29:49 | sahid | it is for nova-api | |
| 15:30:18 | sean-k-mooney | ok so what command are you trying to run exactly | |
| 15:31:30 | bauzas | sean-k-mooney: correct, I was assuming sahid was referring to the compute's nova.conf | |
| 15:31:33 | sahid | I have tried several ways but basically, nova-manage archive_deleted_rows --all-cells --unit-complete --verbose | |
| 15:32:10 | sean-k-mooney | ack so provided you have the cells mapped properly that should lookup the other cells db via the api db | |
| 15:32:34 | sean-k-mooney | nomally we woudl run this using the conducotrs nova.conf | |
| 15:33:13 | bauzas | sahid: you need to have a right nova.conf that gives the right connection for API DB | |
| 15:33:13 | bauzas | https://docs.openstack.org/nova/latest/cli/nova-manage.html#db-archive-deleted-rows | |
| 15:33:15 | sean-k-mooney | sahid: are you using templated URLs | |
| 15:33:21 | bauzas | " Move deleted rows from production tables to shadow tables. Note that the corresponding rows in the instance_mappings, request_specs and instance_group_member tables of the API database are purged when instance records are archived and thus, api_database.connection is required in the config file." | |
| 15:33:38 | elodilles | i know that nova meeting will have start in less than 30 mins, but i have a question about nova gate: | |
| 15:33:49 | sean-k-mooney | sure | |
| 15:34:01 | elodilles | is there a reported bug about the nova-lvm gate issue? https://zuul.opendev.org/t/openstack/builds?job_name=nova-lvm&skip=0 | |
| 15:34:26 | sean-k-mooney | i was not aware there was one but apprelty so | |
| 15:34:28 | elodilles | it's 100% failing on master and newer stable branches | |
| 15:35:15 | sean-k-mooney | ok so it looks like | |
| 15:35:16 | elodilles | the issue is mostly the same as it was last week with the ceph job | |
| 15:35:20 | sean-k-mooney | the tempest test is not using sshable | |
| 15:35:22 | elodilles | but it's different | |
| 15:35:25 | sean-k-mooney | and we dont have that configued in the job | |
| 15:35:32 | sean-k-mooney | tempest.lib.exceptions.InvalidParam: Invalid Parameter passed: When validation.connect_method equals floating, validation_resources cannot be None | |
| 15:35:38 | sean-k-mooney | test_rebuild_volume_backed_server | |
| 15:35:46 | sean-k-mooney | so that should be a simple fix | |
| 15:36:17 | elodilles | (the patch that introduced is this i think: https://review.opendev.org/c/openstack/tempest/+/831018 ) | |
| 15:36:56 | elodilles | sean-k-mooney: so you mean we have to add a new config value to the job def | |
| 15:36:59 | sean-k-mooney | ya so that added the second image | |
| 15:37:12 | sean-k-mooney | but if the job was nto already setup for ssh vericaiton then it would fail | |
| 15:37:17 | sean-k-mooney | let me check the job config | |
| 15:37:29 | elodilles | sean-k-mooney: thanks in advance | |
| 15:38:20 | sean-k-mooney | so i tought this was seup in tempest-multinode-full-py3 or one of the parent of that job | |
| 15:38:24 | sean-k-mooney | that is the parent of nova-lvm | |
| 15:38:42 | elodilles | maybe we override something in nova-lvm? | |
| 15:39:27 | sean-k-mooney | https://github.com/openstack/nova/blob/master/.zuul.yaml#L267 | |
| 15:39:44 | sean-k-mooney | we have tempest validation turned off expiclty for some reason | |
| 15:39:55 | sean-k-mooney | but its definlty now required | |
| 15:39:58 | elodilles | "to save time" | |
| 15:39:59 | elodilles | :) | |
| 15:40:04 | sean-k-mooney | so im just going to remove that one sec | |
| 15:40:17 | elodilles | should i open a bug for this? | |
| 15:40:41 | sean-k-mooney | sure does not hurt its techncially a gate blocker | |
| 15:40:56 | elodilles | ack, will do it now | |
| 15:44:15 | opendevreview | sean mooney proposed openstack/nova master: enable validations in nova-lvm https://review.opendev.org/c/openstack/nova/+/887632 | |
| 15:44:33 | sean-k-mooney | i can update ^ with the bug refernce but that should do the trick | |
| 15:48:16 | elodilles | sean-k-mooney: here's the bug: https://bugs.launchpad.net/nova/+bug/2025813 | |
| 15:48:35 | elodilles | sean-k-mooney: and thanks for the patch! \o/ | |
| 15:48:39 | sean-k-mooney | cool ill update it now. there is no need for a release note since this is purly ci | |
| 15:48:56 | elodilles | yepp, this is CI only issue | |
| 15:49:12 | opendevreview | sean mooney proposed openstack/nova master: enable validations in nova-lvm https://review.opendev.org/c/openstack/nova/+/887632 | |
| 15:50:18 | sahid | bauzas, sean-k-mooney it's owrk I was using wrong conf file | |
| 15:50:26 | sahid | the needed one was nova-conductor | |
| 15:50:27 | sahid | thanks | |
| 15:50:44 | bauzas | sahid: ok, gtk | |
| 15:51:14 | bauzas | sahid: fwiw, you can use any one having a right connection URL :) | |
| 15:51:38 | bauzas | but yeah, given the super conductor in general uses the api db, you can use this one :) | |
| 15:53:27 | sean-k-mooney | ya the only gotcha is if you are using templated cell db urls and you have a differnet password per cell | |
| 15:53:37 | sean-k-mooney | in that case you cannot use --all-cells | |
| 15:53:47 | sean-k-mooney | and isntead need to run it per cell with the correct passowrd | |
| 15:54:10 | sean-k-mooney | however i dont belive anything other then tripleo even supprot that | |
| 15:54:25 | sean-k-mooney | so it should not be an issue for canonicals charm based installer | |
| 16:00:37 | bauzas | #startmeeting nova | |
| 16:00:37 | opendevmeet | Meeting started Tue Jul 4 16:00:37 2023 UTC and is due to finish in 60 minutes. The chair is bauzas. Information about MeetBot at http://wiki.debian.org/MeetBot. | |
| 16:00:37 | opendevmeet | Useful Commands: #action #agreed #help #info #idea #link #topic #startvote. | |
| 16:00:37 | opendevmeet | The meeting name has been set to 'nova' | |
| 16:00:41 | bauzas | hey folks | |
| 16:00:46 | Uggla_ | o/ | |
| 16:01:11 | bauzas | some people are on PTO today, so let's try to have a quick meeting | |
| 16:01:51 | elodilles | o/ | |
| 16:02:30 | gibi | o/ | |
| 16:03:01 | bauzas | #link https://wiki.openstack.org/wiki/Meetings/Nova#Agenda_for_next_meeting | |