Public bug reported: This came up in the mailing list while answering some questions about when/how various cells v2 and database related commands get run:
http://lists.openstack.org/pipermail/openstack- discuss/2019-October/009937.html Recent change https://review.opendev.org/#/c/671298/ was added to the upgrade guide to mention that you can use the --config-file option with the nova-manage db sync command to migrate the cell database schema per cell database, in most cases that being cell0 and cell1. The same is true for the online_data_migrations command since that does data migrations for both the API DB and cell DB, and you would need to run it per cell DB using the --config-file option with a config file whose [database]/connection is configured for a given cell, e.g. cell0 or cell1. So I think the CLI guide should probably be updated for nova-manage and the upgrades guide like in https://review.opendev.org/#/c/671298/. For the CLI guide, it might be useful to just have a generic section about using --config-file per cell database for commands that require a cell database but don't have a kind of --all-cells option like the archive_deleted_rows and purge commands. ** Affects: nova Importance: Undecided Status: New ** Tags: cells doc nova-manage upgrade ** Tags added: upgrade -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to OpenStack Compute (nova). https://bugs.launchpad.net/bugs/1846527 Title: online_data_migrations docs don't mention using --config-file to run the migrations per cell db Status in OpenStack Compute (nova): New Bug description: This came up in the mailing list while answering some questions about when/how various cells v2 and database related commands get run: http://lists.openstack.org/pipermail/openstack- discuss/2019-October/009937.html Recent change https://review.opendev.org/#/c/671298/ was added to the upgrade guide to mention that you can use the --config-file option with the nova-manage db sync command to migrate the cell database schema per cell database, in most cases that being cell0 and cell1. The same is true for the online_data_migrations command since that does data migrations for both the API DB and cell DB, and you would need to run it per cell DB using the --config-file option with a config file whose [database]/connection is configured for a given cell, e.g. cell0 or cell1. So I think the CLI guide should probably be updated for nova-manage and the upgrades guide like in https://review.opendev.org/#/c/671298/. For the CLI guide, it might be useful to just have a generic section about using --config-file per cell database for commands that require a cell database but don't have a kind of --all-cells option like the archive_deleted_rows and purge commands. To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1846527/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : yahoo-eng-team@lists.launchpad.net Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp