VNFD templates doesn't show in list after migration

[Sridhar Ramaswamy]

After migrating to latest tacker code with inline vnf features...

$ tacker-db-manage --config-file /etc/tacker/tacker.conf upgrade head
INFO [alembic.runtime.migration] Context impl MySQLImpl.
INFO [alembic.runtime.migration] Will assume non-transactional DDL.
INFO [alembic.runtime.migration] Running upgrade 0ad3bbce1c18 -> 0ad3bbce1c19, increase_vim_password_size
INFO [alembic.runtime.migration] Running upgrade 0ad3bbce1c19 -> 000632983ada, add template_source column

.. existing 'onboarded' VNFDs doesn't show in the 'tacker vnfd-list'

$ tacker vnfd-list

$

.. using --template-source all shows empty template_source for those onboarded VNFs.

$ tacker vnfd-list --template-source all
+--------------------------------------+---------------+-----------------+--------------+
| id | name | template_source | description |
+--------------------------------------+---------------+-----------------+--------------+
| 814d941a-9efb-42a5-b6cf-aa7adc9b96d8 | test-ns-vnfd1 | | Demo example |
| a4a66dfc-d6b4-4ec2-8ef0-93f6a787e40d | test-ns-vnfd2 | | Demo example |
+--------------------------------------+---------------+-----------------+--------------+

Solution:

the alembic migration script in [1] should add a default value of 'onboarded' to the column,

https://github.com/openstack/tacker/blob/master/tacker/db/migration/alembic_migrations/versions/000632983ada_add_template_source_column.py#L33

[Sridhar Ramaswamy (srics-r)]

Note, similar problem exists in Horizon UI as well with tacker-horizon patchset https://review.openstack.org/#/c/426802/

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/431339
Committed: https://git.openstack.org/cgit/openstack/tacker/commit/?id=19483d1be8195ebb4cc9d7034536e6b36ef47574
Submitter: Jenkins
Branch: master

commit 19483d1be8195ebb4cc9d7034536e6b36ef47574
Author: janki <email address hidden>
Date: Thu Feb 9 06:27:48 2017 +0530

    Add onboarded as default template-source

    After migrating to inline vnf features, the pre-exisitng vnfds donot show up
    in vnfd-list. This patch adds template-source default as onboarded in the migration
    script.

    Co-Authored-By: janki <email address hidden>
    Co-Authored-By: yong sheng gong <[e-mail]>
    Change-Id: If8ce2ce378a8e6e730c3f90363e28438ea31765c
    Closes-Bug: #1663063

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/tacker 0.7.0 release.