bootstrap watcher failed when upgrade database schema

[Jeffrey Zhang]

ult for backward compatibility. SIGUSR1 will no longer be registered in a future release, so please use SIGUSR2 to generate reports.
2017-10-09 07:18:00.369 300 INFO alembic.runtime.migration [req-e9898ff5-2174-4bda-85cb-a5c944414bfc - - - - -] Context impl MySQLImpl.
2017-10-09 07:18:00.370 300 INFO alembic.runtime.migration [req-e9898ff5-2174-4bda-85cb-a5c944414bfc - - - - -] Will assume non-transactional DDL.
2017-10-09 07:18:00.373 300 CRITICAL python-watcher [req-e9898ff5-2174-4bda-85cb-a5c944414bfc - - - - -] Unhandled error: DbMigrationError: Watcher database schema is already under version control; use upgrade() instead
2017-10-09 07:18:00.373 300 ERROR python-watcher Traceback (most recent call last):
2017-10-09 07:18:00.373 300 ERROR python-watcher File "/var/lib/kolla/venv/bin/watcher-db-manage", line 10, in <module>
2017-10-09 07:18:00.373 300 ERROR python-watcher sys.exit(main())
2017-10-09 07:18:00.373 300 ERROR python-watcher File "/var/lib/kolla/venv/lib/python2.7/site-packages/watcher/cmd/dbmanage.py", line 157, in main
2017-10-09 07:18:00.373 300 ERROR python-watcher CONF.command.func()
2017-10-09 07:18:00.373 300 ERROR python-watcher File "/var/lib/kolla/venv/lib/python2.7/site-packages/watcher/cmd/dbmanage.py", line 58, in create_schema
2017-10-09 07:18:00.373 300 ERROR python-watcher migration.create_schema()
2017-10-09 07:18:00.373 300 ERROR python-watcher File "/var/lib/kolla/venv/lib/python2.7/site-packages/watcher/db/migration.py", line 56, in create_schema
2017-10-09 07:18:00.373 300 ERROR python-watcher return get_backend().create_schema()
2017-10-09 07:18:00.373 300 ERROR python-watcher File "/var/lib/kolla/venv/lib/python2.7/site-packages/watcher/db/sqlalchemy/migration.py", line 73, in create_schema
2017-10-09 07:18:00.373 300 ERROR python-watcher _("Watcher database schema is already under version control; "
2017-10-09 07:18:00.373 300 ERROR python-watcher DbMigrationError: Watcher database schema is already under version control; use upgrade() instead

[OpenStack Infra (hudson-openstack)]

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

[Eduardo Gonzalez (egonzalez90)]

Is this affecting stable/pike? watcher fix was merged in master https://review.openstack.org/#/c/504401/ and not pike branch, so maybe the issue in stable is other or we need to wait for watcher people cherry-pick to pike.

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/510427
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=4407e31540c0848cd0837de787eb647cd243c69c
Submitter: Jenkins
Branch: master

commit 4407e31540c0848cd0837de787eb647cd243c69c
Author: Jeffrey Zhang <email address hidden>
Date: Mon Oct 9 15:36:19 2017 +0800

    Use upgrade rather than create_schema for wather database

    watcher has moved to version control. upgrade should be used rather than
    create_schema

    Closes-Bug: #1722167
    Change-Id: I914471215ff88b6bdde48e2953cd1ced440de4b4

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/513609
Committed: https://git.openstack.org/cgit/openstack/kolla/commit/?id=5f38dfd551d0c604fe86d53ee9b455cc86f10f65
Submitter: Zuul
Branch: stable/pike

commit 5f38dfd551d0c604fe86d53ee9b455cc86f10f65
Author: Jeffrey Zhang <email address hidden>
Date: Mon Oct 9 15:36:19 2017 +0800

    Use upgrade rather than create_schema for wather database

    watcher has moved to version control. upgrade should be used rather than
    create_schema

    Closes-Bug: #1722167
    Change-Id: I914471215ff88b6bdde48e2953cd1ced440de4b4
    (cherry picked from commit 4407e31540c0848cd0837de787eb647cd243c69c)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/kolla 6.0.0.0b2 development milestone.

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/kolla 5.0.1 release.