)]}'
{"doc/source/user/upgrade.rst":[{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"f4719543997b8b9f5bfd3021bf175ece2ce6939c","unresolved":false,"context_lines":[{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, this should be run for both ``cell0`` and"},{"line_number":75,"context_line":"     ``cell1``, while in multi-cell environment it should be run for each"},{"line_number":76,"context_line":"     additional cell also. If necessary, the ``--config-file`` argument can be"},{"line_number":77,"context_line":"     used to point to the correct ``nova.conf`` file for the given cell."},{"line_number":78,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"7faddb67_3ee53d39","line":75,"range":{"start_line":75,"start_character":22,"end_line":75,"end_character":24},"updated":"2019-07-23 18:08:43.000000000","message":"\"in a\" or \"environments\"","commit_id":"0f408a3765624df6cb5fc914ebfaa1c624d435cf"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"d499a652b770fff99b7afd39e9fe0c7e5d53624c","unresolved":false,"context_lines":[{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, this should be run for both ``cell0`` and"},{"line_number":75,"context_line":"     ``cell1``, while in multi-cell environment it should be run for each"},{"line_number":76,"context_line":"     additional cell also. If necessary, the ``--config-file`` argument can be"},{"line_number":77,"context_line":"     used to point to the correct ``nova.conf`` file for the given cell."},{"line_number":78,"context_line":""}],"source_content_type":"text/x-rst","patch_set":1,"id":"7faddb67_2cffa9ab","line":75,"range":{"start_line":75,"start_character":22,"end_line":75,"end_character":24},"in_reply_to":"7faddb67_3ee53d39","updated":"2019-08-20 16:31:03.000000000","message":"Done","commit_id":"0f408a3765624df6cb5fc914ebfaa1c624d435cf"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"f4719543997b8b9f5bfd3021bf175ece2ce6939c","unresolved":false,"context_lines":[{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, this should be run for both ``cell0`` and"},{"line_number":75,"context_line":"     ``cell1``, while in multi-cell environment it should be run for each"},{"line_number":76,"context_line":"     additional cell also. If necessary, the ``--config-file`` argument can be"},{"line_number":77,"context_line":"     used to point to the correct ``nova.conf`` file for the given cell."},{"line_number":78,"context_line":""},{"line_number":79,"context_line":"     These schema change operations should have minimal or no effect on"},{"line_number":80,"context_line":"     performance, and should not cause any operations to fail."}],"source_content_type":"text/x-rst","patch_set":1,"id":"7faddb67_be3fed85","line":77,"range":{"start_line":76,"start_character":27,"end_line":77,"end_character":72},"updated":"2019-07-23 18:08:43.000000000","message":"When I\u0027ve done this in devstack, I seem to remember that order matters, right? Like if I\u0027m specifically syncing cell1, don\u0027t you need to do something like this:\n\nnova-manage --config-file /etc/nova/nova.conf --config-file /etc/nova/nova_cell1.conf db sync\n\nBecause nova.conf (in devsack) defines the api db and cell0 db, and nova_cell1.conf just defines the cell1 db (not the api db) and is used to override the [database]/connection we are syncing.\n\nAnyway, if I\u0027m not off the mark, that might be useful information - though arguably something to actually call out in the CLI docs for the command itself if we\u0027re going to go into details because this isn\u0027t the only place in the nova docs that mentions the db sync command, e.g. https://docs.openstack.org/nova/latest/user/cells.html","commit_id":"0f408a3765624df6cb5fc914ebfaa1c624d435cf"},{"author":{"_account_id":6167,"name":"Ken\u0027ichi Ohmichi","email":"ken1ohmichi@gmail.com","username":"oomichi"},"change_message_id":"7a0b8f7da1fa40a8e0fbf91b9525bc0568b45c13","unresolved":false,"context_lines":[{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, this should be run for both ``cell0`` and"},{"line_number":75,"context_line":"     ``cell1``, while in a multi-cell environment it should be run for each"},{"line_number":76,"context_line":"     additional cell also. If necessary, the ``--config-file`` argument can be"},{"line_number":77,"context_line":"     used to point to the correct ``nova.conf`` file for the given cell."}],"source_content_type":"text/x-rst","patch_set":2,"id":"7faddb67_a3ee5b88","line":74,"range":{"start_line":74,"start_character":30,"end_line":74,"end_character":34},"updated":"2019-09-03 21:53:57.000000000","message":"The original doc says ``nova-manage db sync`` should be run clearly. It is better to mention ``nova-manage db sync`` clearly here instead of \"this\" because the other command ``nova-manage api_db sync`` also is mentioned at the above.","commit_id":"db744cdb465fa84399d2707a382eb09e3cb3ac4c"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"a1aa7a3484a00ec9d895b397a9e12b1cee009df8","unresolved":false,"context_lines":[{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, this should be run for both ``cell0`` and"},{"line_number":75,"context_line":"     ``cell1``, while in a multi-cell environment it should be run for each"},{"line_number":76,"context_line":"     additional cell also. If necessary, the ``--config-file`` argument can be"},{"line_number":77,"context_line":"     used to point to the correct ``nova.conf`` file for the given cell."}],"source_content_type":"text/x-rst","patch_set":2,"id":"3fa7e38b_0b9c73be","line":74,"range":{"start_line":74,"start_character":30,"end_line":74,"end_character":34},"in_reply_to":"7faddb67_a3ee5b88","updated":"2019-09-24 16:18:44.000000000","message":"Done","commit_id":"db744cdb465fa84399d2707a382eb09e3cb3ac4c"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"3021317ba4574f6d229d1d3faa1a025360b30e6e","unresolved":false,"context_lines":[{"line_number":70,"context_line":"     including all the python dependencies."},{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, ``nova-manage db sync`` should be run for both"},{"line_number":75,"context_line":"     ``cell0`` and ``cell1``, while in a multi-cell environment it should be"},{"line_number":76,"context_line":"     run for each additional cell also. If necessary, the ``--config-file``"},{"line_number":77,"context_line":"     argument can be used to point to the correct ``nova.conf`` file for the"},{"line_number":78,"context_line":"     given cell."}],"source_content_type":"text/x-rst","patch_set":3,"id":"3fa7e38b_6cc3a139","line":75,"range":{"start_line":73,"start_character":64,"end_line":75,"end_character":29},"updated":"2019-09-24 16:17:01.000000000","message":"So in devstack, nova.conf is used by the controller services at the \"top\" (api, superconductor and scheduler) and [database]/connection is set to cell0:\n\nhttps://zuul.opendev.org/t/openstack/build/78ec8a4854e94baab2bbddc81a5947bc/log/controller/logs/etc/nova/nova_conf.txt.gz#61\n\nSo syncing with just nova.conf in devstack will sync cell0 only, not cell1. To sync cell1, you have to provide the --config-file pointing at nova_cell1.conf which has [database]/connection pointed at cell1:\n\nhttps://zuul.opendev.org/t/openstack/build/78ec8a4854e94baab2bbddc81a5947bc/log/controller/logs/etc/nova/nova_cell1_conf.txt.gz#3\n\nLooking at a devstack run that equates to:\n\nhttps://zuul.opendev.org/t/openstack/build/78ec8a4854e94baab2bbddc81a5947bc/log/controller/logs/devstacklog.txt.gz#19900\n\nnova-manage --config-file /etc/nova/nova_cell1.conf db sync --local_cell\n\nand then to sync cell0:\n\nhttps://zuul.opendev.org/t/openstack/build/78ec8a4854e94baab2bbddc81a5947bc/log/controller/logs/devstacklog.txt.gz#20659\n\nnova-manage --config-file /etc/nova/nova.conf db sync\n\nMy guess is that most single cell deployments still use a single nova.conf with [database]/connection configured for the cell1 database and db sync with just that is fine since it will hit cell0 and cell1, and I think that\u0027s what you\u0027re trying to say here, right?","commit_id":"5cbb64e24d323c10ff00ec73908d0a8aeb05e138"},{"author":{"_account_id":15334,"name":"Stephen Finucane","display_name":"stephenfin","email":"stephenfin@redhat.com","username":"sfinucan"},"change_message_id":"9f488970131c3ee90e691b125d1dfea7727145c1","unresolved":false,"context_lines":[{"line_number":70,"context_line":"     including all the python dependencies."},{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, ``nova-manage db sync`` should be run for both"},{"line_number":75,"context_line":"     ``cell0`` and ``cell1``, while in a multi-cell environment it should be"},{"line_number":76,"context_line":"     run for each additional cell also. If necessary, the ``--config-file``"},{"line_number":77,"context_line":"     argument can be used to point to the correct ``nova.conf`` file for the"},{"line_number":78,"context_line":"     given cell."}],"source_content_type":"text/x-rst","patch_set":3,"id":"3fa7e38b_cc541556","line":75,"range":{"start_line":73,"start_character":64,"end_line":75,"end_character":29},"in_reply_to":"3fa7e38b_6cc3a139","updated":"2019-09-24 16:21:31.000000000","message":"Yeah, this patch came about as a result of tinkering with migrations on a local (DevStack-based) deployment, so that would make sense, yeah. We don\u0027t want to put DevStack-specific verbiage in here so dropping references to specific cells like dansmith suggests make sense.","commit_id":"5cbb64e24d323c10ff00ec73908d0a8aeb05e138"},{"author":{"_account_id":4393,"name":"Dan Smith","email":"dms@danplanet.com","username":"danms"},"change_message_id":"96306fdab9e82dd78f8de7cc9527a844113418ca","unresolved":false,"context_lines":[{"line_number":70,"context_line":"     including all the python dependencies."},{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. In a"},{"line_number":74,"context_line":"     single-cell environment, ``nova-manage db sync`` should be run for both"},{"line_number":75,"context_line":"     ``cell0`` and ``cell1``, while in a multi-cell environment it should be"},{"line_number":76,"context_line":"     run for each additional cell also. If necessary, the ``--config-file``"},{"line_number":77,"context_line":"     argument can be used to point to the correct ``nova.conf`` file for the"},{"line_number":78,"context_line":"     given cell."},{"line_number":79,"context_line":""}],"source_content_type":"text/x-rst","patch_set":3,"id":"3fa7e38b_4c96e541","line":76,"range":{"start_line":73,"start_character":64,"end_line":76,"end_character":38},"updated":"2019-09-24 16:14:55.000000000","message":"Personally I\u0027d rather not make this distinction. I\u0027d prefer something like:\n\n db sync should be run for all cell databases, including cell0\n\nor\n\n db sync should be run for cell0, and then all real cell databases (you have at least one of these)\n\nThe name \"cell0\" is kinda special, but there is nothing special about \"cell1\" so calling it out like this is asking for trouble/confusion, IMHO.","commit_id":"5cbb64e24d323c10ff00ec73908d0a8aeb05e138"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"16781580c0ee44969496334be0051a796dadd893","unresolved":false,"context_lines":[{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. ``nova-manage"},{"line_number":74,"context_line":"     db sync`` should be run for all cell databases, including ``cell0``. If"},{"line_number":75,"context_line":"     necessary, the ``--config-file`` argument can be used to point to the"},{"line_number":76,"context_line":"     correct ``nova.conf`` file for the given cell."},{"line_number":77,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"3fa7e38b_6c7e41b0","line":74,"range":{"start_line":74,"start_character":53,"end_line":74,"end_character":72},"updated":"2019-09-24 16:27:19.000000000","message":"Note that by default db sync does sync cell0, so \"including cell0\" seems like it\u0027s something people have to opt into but it\u0027s actually something you would opt out of (which is what devstack does with that --local_cell flag when syncing cell1).\n\nThe CLI docs also mention this:\n\nhttps://docs.openstack.org/nova/latest/cli/nova-manage.html#nova-database\n\n\"By default, this command will also attempt to upgrade the schema for the cell0 database if it is mapped\"","commit_id":"de0cd7503e749a4f97334fb046127ae4559c470c"},{"author":{"_account_id":14826,"name":"Mark Goddard","email":"markgoddard86@gmail.com","username":"mgoddard"},"change_message_id":"55720d576191632b8425d28ea33e68b5530cb0d7","unresolved":false,"context_lines":[{"line_number":71,"context_line":""},{"line_number":72,"context_line":"   * Using the newly installed nova code, run the DB sync. First run"},{"line_number":73,"context_line":"     ``nova-manage api_db sync``, then ``nova-manage db sync``. ``nova-manage"},{"line_number":74,"context_line":"     db sync`` should be run for all cell databases, including ``cell0``. If"},{"line_number":75,"context_line":"     necessary, the ``--config-file`` argument can be used to point to the"},{"line_number":76,"context_line":"     correct ``nova.conf`` file for the given cell."},{"line_number":77,"context_line":""}],"source_content_type":"text/x-rst","patch_set":4,"id":"3fa7e38b_f79fc662","line":74,"range":{"start_line":74,"start_character":53,"end_line":74,"end_character":72},"in_reply_to":"3fa7e38b_6c7e41b0","updated":"2019-10-03 08:21:55.000000000","message":"In a multi cell environment wouldn\u0027t it be better to use --local_cell if explicitly syncing cell0, to avoid syncing it once for every cell?","commit_id":"de0cd7503e749a4f97334fb046127ae4559c470c"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"a7812ac99041c1fbbd8f2a2c5c03facbfcfc929c","unresolved":false,"context_lines":[{"line_number":141,"context_line":""},{"line_number":142,"context_line":"   * This process can put significant extra write load on the"},{"line_number":143,"context_line":"     database.  Complete all online data migrations using:"},{"line_number":144,"context_line":"     ``nova-manage db online_data_migrations --max-count \u003cnumber\u003e``. Note"},{"line_number":145,"context_line":"     that you can use the ``--max-count`` argument to reduce the load this"},{"line_number":146,"context_line":"     operation will place on the database, which allows you to run a"},{"line_number":147,"context_line":"     small chunk of the migrations until all of the work is done. The chunk size"}],"source_content_type":"text/x-rst","patch_set":4,"id":"3fa7e38b_1ee396a6","line":144,"updated":"2019-10-03 16:34:40.000000000","message":"As Mark pointed out in the ML thread where I called out this change, this should also mention using --config-file to run online data migrations per cell DB.","commit_id":"de0cd7503e749a4f97334fb046127ae4559c470c"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"55b805397de067980d1bc09b8e5216dd065adaca","unresolved":false,"context_lines":[{"line_number":141,"context_line":""},{"line_number":142,"context_line":"   * This process can put significant extra write load on the"},{"line_number":143,"context_line":"     database.  Complete all online data migrations using:"},{"line_number":144,"context_line":"     ``nova-manage db online_data_migrations --max-count \u003cnumber\u003e``. Note"},{"line_number":145,"context_line":"     that you can use the ``--max-count`` argument to reduce the load this"},{"line_number":146,"context_line":"     operation will place on the database, which allows you to run a"},{"line_number":147,"context_line":"     small chunk of the migrations until all of the work is done. The chunk size"}],"source_content_type":"text/x-rst","patch_set":4,"id":"3fa7e38b_d95e78e8","line":144,"in_reply_to":"3fa7e38b_1ee396a6","updated":"2019-10-03 17:05:11.000000000","message":"I opened bug 1846527 in case someone gets to that before me.","commit_id":"de0cd7503e749a4f97334fb046127ae4559c470c"}]}