| Posted | Nick | Remark | |
|---|---|---|---|
| #openstack-nova - 2021-07-01 | |||
| 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 | |
| #openstack-nova - 2021-07-05 | |||
| 01:12:42 | opendevreview | Eric Xie proposed openstack/nova master: Add logs when cannot fit numa https://review.opendev.org/c/openstack/nova/+/798187 | |
| 08:42:15 | opendevreview | Yongli He proposed openstack/nova master: Smartnic support - cyborg drive https://review.opendev.org/c/openstack/nova/+/771362 | |
| 08:42:24 | opendevreview | Yongli He proposed openstack/nova master: smartnic support - new vnic type https://review.opendev.org/c/openstack/nova/+/771363 | |
| 08:42:46 | opendevreview | Yongli He proposed openstack/nova master: smartnic support - create arqs https://review.opendev.org/c/openstack/nova/+/758944 | |
| 08:42:53 | opendevreview | Yongli He proposed openstack/nova master: smartnic support - build instance with smartnic arqs https://review.opendev.org/c/openstack/nova/+/798249 | |