You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "Ernie Janse van Rensburg (JIRA)" <ji...@apache.org> on 2018/02/09 13:39:00 UTC
[jira] [Created] (CLOUDSTACK-10278) Adding a SQL table column is
not Idempotent
Ernie Janse van Rensburg created CLOUDSTACK-10278:
-----------------------------------------------------
Summary: Adding a SQL table column is not Idempotent
Key: CLOUDSTACK-10278
URL: https://issues.apache.org/jira/browse/CLOUDSTACK-10278
Project: CloudStack
Issue Type: Bug
Security Level: Public (Anyone can view this level - this is the default.)
Components: Install and Setup
Affects Versions: 4.10.0.0, 4.11.0.0
Reporter: Ernie Janse van Rensburg
The SQL code to add a new column to a table in the META-INF/db/schema-41000to41100.sql script is not written in an idempotent way. When the upgrade is re-run, the code above causes a SQL error as reported on the user mailing list:
ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:)
Error executing: ALTER TABLE cloud.network_offerings ADD COLUMN for_vpc
INT(1) NOT NULL DEFAULT 0
This is a more generic problem for every version due to to the fact that it is not idempotent
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)