M/N upgrade fail to restart nova-scheduler.

[Sofer Athlan-Guyot]

Hi,

after a M/N major upgrade the nova-scheduler fails to start with:

      2016-08-19 16:16:08.712 15444 ERROR nova ProgrammingError: (pymysql.err.ProgrammingError) (1146, u"Table 'nova_api.aggregates' doesn't exist") [SQL: u'SELECT aggregates.created_at AS aggregates_created_at, aggregates.updated_at AS aggregates_updated_at, aggregates.id AS aggregates_id, aggregates.uuid AS aggregates_uuid, aggregates.name AS aggregates_name, aggregate_hosts_1.created_at AS aggregate_hosts_1_created_at, aggregate_hosts_1.updated_at AS aggregate_hosts_1_updated_at, aggregate_hosts_1.id AS aggregate_hosts_1_id, aggregate_hosts_1.host AS aggregate_hosts_1_host, aggregate_hosts_1.aggregate_id AS aggregate_hosts_1_aggregate_id, aggregate_metadata_1.created_at AS aggregate_metadata_1_created_at, aggregate_metadata_1.updated_at AS aggregate_metadata_1_updated_at, aggregate_metadata_1.id AS aggregate_metadata_1_id, aggregate_metadata_1.`key` AS aggregate_metadata_1_key, aggregate_metadata_1.value AS aggregate_metadata_1_value, aggregate_metadata_1.aggregate_id AS aggregate_metadata_1_aggregate_id \nFROM aggregates LEFT OUTER JOIN aggregate_hosts AS aggregate_hosts_1 ON aggregates.id = aggregate_hosts_1.aggregate_id LEFT OUTER JOIN aggregate_metadata AS aggregate_metadata_1 ON aggregates.id = aggregate_metadata_1.aggregate_id']
2016-08-19 16:16:08.712 15444 ERROR nova

Running

    nova-manage api_db sync

make it works again.

[Sofer Athlan-Guyot (sofer-athlan-guyot)]

Dunno why the link was not done, but the fix is up for review https://review.openstack.org/#/c/358006/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/358006
Committed: https://git.openstack.org/cgit/openstack/tripleo-heat-templates/commit/?id=cb894b4509b17bf2f6030b6698afe93dce9008af
Submitter: Jenkins
Branch: master

commit cb894b4509b17bf2f6030b6698afe93dce9008af
Author: Sofer Athlan-Guyot <email address hidden>
Date: Fri Aug 19 18:34:15 2016 +0200

    M/N upgrade fail to restart nova-scheduler.

    The nova api db need to be synchronized as well.

    Change-Id: I2628b24ff1153c84cbf388455666ae42570cb10f
    Closes-Bug: 1615042

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tripleo-heat-templates 5.0.0.0b3 development milestone.