Earlier  
Posted Nick Remark
#openstack-nova - 2021-07-01
09:51:14 sean-k-mooney stephenfin: so i have the os-vif patch mostly working now https://review.opendev.org/c/openstack/os-vif/+/798055 i need to rebase it on my patch to fix os-vif ci and add a release note and flip the default to false but can you give it a look and see what you think
09:51:23 stephenfin sure
09:51:34 stephenfin can do
09:57:08 opendevreview Stephen Finucane proposed openstack/nova master: Add --sleep option for archive_deleted_rows --until-complete https://review.opendev.org/c/openstack/nova/+/771749
10:29:41 opendevreview Merged openstack/nova-specs master: Add attachmentId to responses of the os-volume_attachments API https://review.opendev.org/c/openstack/nova-specs/+/794799
10:43:49 lyarwood sean-k-mooney: thanks for that
10:44:34 sean-k-mooney :) no worries did you see my top level comment to artom re changing id to internal_id in a followup if we feel that is needed
10:45:23 sean-k-mooney i didnt really think it was needed but i dont really object to it either if we want to disambiguate
10:46:52 sean-k-mooney if we did that i would not change the name in the db by the way i would jsut traslate in the api
10:50:00 lyarwood Yeah it's an awkward one to change
10:50:13 lyarwood and tbh I'd rather not and just spell it out in the API ref
10:50:30 sean-k-mooney yep i think docs is enough too
10:50:43 sean-k-mooney i certenly dont want to intoduce a db migration just for this
12:52:06 thelounge55 Hello Folks, I was trying to install wallaby openstack release. But experiencing some issue in nova that the table is not getting created in database. Does anybody has any idea how to resolve it ?
12:53:46 thelounge55 + manage_cells
12:53:46 thelounge55 + '[' 66 -gt 0 ']'
12:53:46 thelounge55 ++ nova-manage api_db version
12:53:46 thelounge55 + NOVA_VERSION=23.0.2
12:53:46 thelounge55 ++ grep -Eo '[0-9]+[.][0-9]+[.][0-9]+'
12:53:46 thelounge55 ```++ nova-manage --version
12:53:48 thelounge55 + nova-manage cell_v2 map_cell0
12:53:48 thelounge55 + '[' 23 -gt 14 ']'
12:53:49 sean-k-mooney how are you creating them? with nova-mageage direcly
12:53:50 thelounge55 Traceback (most recent call last):
12:53:50 thelounge55 An error has occurred:
12:53:52 thelounge55 cursor, statement, parameters, context
12:53:52 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/sqlalchemy/engine/base.py", line 1277, in _execute_context
12:53:54 thelounge55 cursor.execute(statement, parameters)
12:53:54 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/sqlalchemy/engine/default.py", line 608, in do_execute
12:53:56 thelounge55 result = self._query(query)
12:53:56 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/cursors.py", line 148, in execute
12:53:58 thelounge55 conn.query(q)
12:53:58 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/cursors.py", line 310, in _query
12:54:00 thelounge55 self._affected_rows = self._read_query_result(unbuffered=unbuffered)
12:54:00 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/connections.py", line 548, in query
12:54:02 thelounge55 result.read()
12:54:02 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/connections.py", line 775, in _read_query_result
12:54:04 thelounge55 first_packet = self.connection._read_packet()
12:54:04 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/connections.py", line 1156, in read
12:54:06 thelounge55 packet.raise_for_error()
12:54:06 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/connections.py", line 725, in _read_packet
12:54:08 thelounge55 err.raise_mysql_exception(self._data)
12:54:08 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/protocol.py", line 221, in raise_for_error
12:54:10 thelounge55 raise errorclass(errno, errval)
12:54:10 thelounge55 File "/var/lib/openstack/lib/python3.6/site-packages/pymysql/err.py", line 143, in raise_mysql_exception
12:54:12 thelounge55 The above exception was the direct cause of the following exception: ```
12:54:12 thelounge55 pymysql.err.ProgrammingError: (1146, "Table 'nova_api.cell_mappings' doesn't exist")
12:54:23 sean-k-mooney thelounge55: wehn posting more then about 10 lines you should do it to past.openststack.org first
12:54:34 sean-k-mooney * http://paste.openstack.org/
12:54:58 thelounge55 sean-k-mooney sorry my bad new to IRC
12:55:10 sean-k-mooney its ok
12:55:37 sean-k-mooney am did you do a "nova-manage db sync" and "nova-manage api_db sync"
12:56:44 thelounge55 sean-k-mooney i am using openstack-helm for my deployment where i see the script is trying to execute this `nova-manage cell_v2 map_cell0` and after this command it fails as we can see in logs
12:57:27 sean-k-mooney thelounge55: i know that openstack-helm used ot have broken code for cells at one point
12:57:52 sean-k-mooney they were settign config options that dont exist
12:58:25 thelounge55 sean-k-mooney then that might be related to it as i victoria release works out of the box
13:00:14 sean-k-mooney https://github.com/openstack/openstack-helm/commit/94642833dd97e9ff397ef1af26449a51572d5b68 this might be related
13:02:10 sean-k-mooney thelounge55: for what its worth openstack helm does not look that activly maintained
13:02:38 sean-k-mooney there are some commits i gues
13:03:03 sean-k-mooney so its not abandoned by any means
13:03:23 sean-k-mooney they just dont seam to follow our normal branching model so its hard to tell what version of openstack they support
13:04:59 sean-k-mooney thelounge55: anyway it look like the api db was not initalise before it tried to update teh cell mapping
13:05:15 sean-k-mooney so you proably just need to do teh api db sync to do that then continue
13:07:13 thelounge55 sean-k-mooney mmm you seems to be right but i was just cross checking if i have the necessary changes as mentioned in the commits. And yes i do have it so it shouldn't be the problem. But it could be possible that the wallaby release nova docker image is not good
13:08:18 sean-k-mooney unlikely that this woudl be related to the docker image
13:08:32 sean-k-mooney there may be other issues in the helml charts
13:09:18 thelounge55 sean-k-mooney yes possible . But i am playing with it yesterday and i am lost at the moment :D
13:09:22 sean-k-mooney openstack helm is one of the less used installer and the nova team is not really invovled in it at all so we dont really have much expeirince with it
13:09:51 sean-k-mooney have you connected to the db server and checked that the api db exists and if it has the tables
13:14:12 thelounge55 `Empty set (0.00 sec)`
13:14:12 thelounge55 `MariaDB [nova]> show tables; `
13:14:12 thelounge55 sean-k-mooney yeah i did try that but there is no tables got created in nova
13:14:30 sean-k-mooney and nova_api
13:14:46 sean-k-mooney i assume the same
13:15:12 sean-k-mooney this look like an openstack helm bug to me so there irc channel can proably help you more
13:17:07 thelounge55 sean-k-mooney nope there is one http://paste.openstack.org/show/807105/ which is got created nova_api
13:17:13 thelounge55 yeah it looks like its nova issue
13:17:32 sean-k-mooney well no its an openstack-helm issue
13:18:16 thelounge55 sean-k-mooney yeah i mean openstack-helm nova helm chart issue :D
13:18:40 sean-k-mooney but ya so what likely has wrong here is that openstack-helm did not initalise the db with the db schema before it tried ot populate teh tables with data
13:18:51 thelounge55 sean-k-mooney anyway thanks for help :)
13:19:32 sean-k-mooney https://github.com/openstack/openstack-helm/blob/master/nova/templates/job-db-init.yaml does not actully seam to init anything
13:20:15 sean-k-mooney but honestly i dont really know how those charts work
13:28:57 thelounge55 sean-k-mooney nvm thanks again :)
15:31:39 opendevreview Kashyap Chamarthy proposed openstack/nova-specs master: Re-propose "CPU selection with hypervisor consideration" https://review.opendev.org/c/openstack/nova-specs/+/799096
17:27:21 opendevreview Merged openstack/nova master: fix sr-iov support on Cavium ThunderX hosts. https://review.opendev.org/c/openstack/nova/+/777679
19:52:15 opendevreview Merged openstack/nova master: db: Fold in ForeignKey constraints https://review.opendev.org/c/openstack/nova/+/786297
19:52:42 opendevreview Merged openstack/nova master: db: Remove 'nova.db.base' module https://review.opendev.org/c/openstack/nova/+/786298
19:58:22 opendevreview sean mooney proposed openstack/os-vif master: update os-vif ci to account for devstack default changes https://review.opendev.org/c/openstack/os-vif/+/798038
19:58:23 opendevreview sean mooney proposed openstack/os-vif master: add configurable per port bridges https://review.opendev.org/c/openstack/os-vif/+/798055
20:13:48 opendevreview sean mooney proposed openstack/os-vif master: update os-vif ci to account for devstack default changes https://review.opendev.org/c/openstack/os-vif/+/798038
20:13:49 opendevreview sean mooney proposed openstack/os-vif master: add configurable per port bridges https://review.opendev.org/c/openstack/os-vif/+/798055
20:16:03 opendevreview Merged openstack/nova master: db: Copy docs from 'nova.db.*' to 'nova.db.sqlalchemy.*' https://review.opendev.org/c/openstack/nova/+/786299
20:16:32 opendevreview Merged openstack/nova master: db: Synchronize function signatures https://review.opendev.org/c/openstack/nova/+/786300
#openstack-nova - 2021-07-03
02:35:23 opendevreview Eric Xie proposed openstack/nova master: Add logs when cannot fit numa https://review.opendev.org/c/openstack/nova/+/798187
05:08:08 opendevreview Merged openstack/nova stable/wallaby: Update SRIOV port pci_slot when unshelving https://review.opendev.org/c/openstack/nova/+/790711
05:23:49 opendevreview Merged openstack/nova master: db: Clean up migration code https://review.opendev.org/c/openstack/nova/+/786301
#openstack-nova - 2021-07-04
18:41:45 opendevreview Ghanshyam proposed openstack/placement master: Fix oslo policy DeprecatedRule warnings https://review.opendev.org/c/openstack/placement/+/799418
21:01:22 opendevreview Ghanshyam proposed openstack/nova master: Fix oslo policy DeprecatedRule warnings https://review.opendev.org/c/openstack/nova/+/799422
23:05:19 opendevreview Ghanshyam proposed openstack/placement master: Fix oslo policy DeprecatedRule warnings https://review.opendev.org/c/openstack/placement/+/799418

Earlier   Later