VNF create with templates larger than 4096 byte fails

[Sridhar Ramaswamy]

When a VNF template of size > 4k is used in tacker the vnfd-create operation succeeds fine but vnf-create using that VNFD template fails with Internal Server Error,

$ tacker vnfd-create --name huge-vnf-template --vnfd-file sample-vnfd-no-monitor-huge.yaml

$ tacker vnf-create --name test-huge-vnf --vnfd-name huge-vnf-template

VNF stays indefinitely in PENDING_CREATE state and tacker log shows the follow error,

DBError: (pymysql.err.DataError) (1406, u"Data too long for column 'value' at row 1") [SQL: u'INSERT INTO deviceattributes (id,...

[Sridhar Ramaswamy (srics-r)]

This got fixed for VNFD templates using,

bug.. https://bugs.launchpad.net/tacker/+bug/1501072
patchset ... https://review.openstack.org/#/c/231088/

A similar fix is required at,

https://github.com/openstack/tacker/blob/master/tacker/db/vm/vm_db.py#L137

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

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

commit b5d7289421af9bf9ded4d38f18ab8cb84d96bdb1
Author: Bharath Thiruveedula <email address hidden>
Date: Mon Jan 25 00:05:06 2016 +0530

    Alter the 'value' column in 'deviceattributes' table

    Increase the size of 'value' column in 'deviceattributes' table
    from string(4096) to text(65535) to allocate large VNFD values.

    Change-Id: I10ff4696a75be6d0240ad35a806b9cd4b52690a1
    Closes-Bug: #1534844

[Thierry Carrez (ttx)]

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