man page needed for "nova-manage db online_data_migrations"

[Matt Riedemann]

This came up in the openstack-operators mailing list:

http://lists.openstack.org/pipermail/openstack-operators/2017-March/012864.html

There is confusion around the online_data_migrations CLI for knowing when it's complete. There are sort of two answers:

1. There is no summary table output.

2. The command exits with 0 meaning there were no migrations performed. This is probably the best case to follow when checking/scripting for this.

We need a man page explaining this in the nova docs:

https://github.com/openstack/nova/blob/master/doc/source/man/nova-manage.rst

[Matt Riedemann (mriedem)]

Here is an example of online_data_migrations running during a grenade job:

http://logs.openstack.org/52/440652/2/check/gate-grenade-dsvm-neutron-ubuntu-xenial/74bea3f/logs/grenade.sh.txt.gz#_2017-03-02_20_38_11_797

2017-03-02 20:38:11.797 | + /opt/stack/new/grenade/projects/60_nova/upgrade.sh:main:74 : /usr/local/bin/nova-manage --config-file /etc/nova/nova.conf db online_data_migrations
2017-03-02 20:38:14.031 | Running batches of 50 until complete
2017-03-02 20:38:14.044 | /usr/local/lib/python2.7/dist-packages/pymysql/cursors.py:166: Warning: (3090, u"Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.")
2017-03-02 20:38:14.045 | result = self._query(query)
2017-03-02 20:38:14.306 | 2 rows matched query migrate_instances_add_request_spec, 0 migrated
2017-03-02 20:38:14.331 | +---------------------------------------------+--------------+-----------+
2017-03-02 20:38:14.332 | | Migration | Total Needed | Completed |
2017-03-02 20:38:14.332 | +---------------------------------------------+--------------+-----------+
2017-03-02 20:38:14.332 | | aggregate_uuids_online_data_migration | 0 | 0 |
2017-03-02 20:38:14.332 | | delete_build_requests_with_no_instance_uuid | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_aggregate_reset_autoincrement | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_aggregates | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_flavor_reset_autoincrement | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_flavors | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_instance_groups_to_api_db | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_instance_keypairs | 0 | 0 |
2017-03-02 20:38:14.332 | | migrate_instances_add_request_spec | 2 | 0 |
2017-03-02 20:38:14.332 | | migrate_keypairs_to_api_db | 0 | 0 |
2017-03-02 20:38:14.332 | +---------------------------------------------+--------------+-----------+

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/464634

[OpenStack Infra (hudson-openstack)]

Change abandoned by Sean Dague (<email address hidden>) on branch: master
Review: https://review.openstack.org/464634
Reason: This review is > 4 weeks without comment, and is not mergable in it's current state. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and leaving a 'recheck' comment to get fresh test results.

[Sean Dague (sdague)]

There are no currently open reviews on this bug, changing the status back to the previous state and unassigning. If there are active reviews related to this bug, please include links in comments.

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/500124

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/493442
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=9e1e1a52de48877fd4eb9bcd783e7c187e09a2ab
Submitter: Jenkins
Branch: master

commit 9e1e1a52de48877fd4eb9bcd783e7c187e09a2ab
Author: Hesam Chobanlou <email address hidden>
Date: Mon Aug 14 02:09:30 2017 -0400

    add online_data_migrations to nova docs

    adding cli documentation for online_data_migrations to clarify
    when the command is complete.

    Closes-Bug: #1670738

    Change-Id: If50bd044091250611a7d3d67438d732279510d5b

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/500124
Committed: https://git.openstack.org/cgit/openstack/nova/commit/?id=62a80f48a6e0d02f8899c19a509314be87d54c32
Submitter: Jenkins
Branch: master

commit 62a80f48a6e0d02f8899c19a509314be87d54c32
Author: Matt Riedemann <email address hidden>
Date: Fri Sep 1 12:17:18 2017 -0400

    doc: fix online_data_migrations option in upgrades doc

    There is no --limit option on the online_data_migrations
    command, it's called --max-count.

    This fixes that typo in the upgrades doc and also fixes
    another grammar nit that was bugging me.

    Change-Id: Ib76ced58314e025f617c1b4d964cd0c62d908a37
    Related-Bug: #1670738

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/nova 17.0.0.0b1 development milestone.