tenant column has inconsistent length across all DB tables

[Unmesh Gurjar]

The 'tenant' column in different database tables of heat has different lengths. For example stack and snapshot (256), software_config and software_deployment (64).

The column length should be consistent to avoid truncation of the value.

[Sergey Kraynev (skraynev)]

Please look this change https://review.openstack.org/#/c/92406/, I suppose that it fixes your problem. Also this bug looks like duplicate for https://bugs.launchpad.net/heat/+bug/1316646, however it also may be ,marked as related bug.

[Unmesh Gurjar (unmesh-gurjar)]

Thanks skraynev for pointing it out! The earlier bug was for a DB migration failure and seems to be addressed (bug status: "Fix Released" for Juno). However, the review for reducing column length (which is not yet merged) is a separate issue and addresses this bug. Therefore, IMHO, the review #92406 should refer this bug. It would also ensure that this issue doesn't get lost/overlooked.

[Sergey Kraynev (skraynev)]

Yeah, I have seen the old bug (#1316646) and your description looks better for real issue for https://review.openstack.org/#/c/92406/.
I do not mind to re-reference this fix on your bug. If you really want to do it, just add comment about it on review ;)

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Change abandoned by Di XiaoLi (<email address hidden>) on branch: master
Review: https://review.openstack.org/295067
Reason: Abandon it since there is no update for a long time.