[CLOUDSTACK-10278] Adding a SQL table column is not Idempotent

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.10.0.0, 4.11.0.0
• Component/s: Install and Setup
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Ernie Janse van Rensburg
• Reporter: Ernie Janse van Rensburg
• Created: 09/Feb/18 13:38
• Updated: 14/Oct/19 09:36

Description

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

 

Issue Links

• links to: GitHub Pull Request #2449
• links to: GitHub Pull Request #2479
• links to: GitHub Pull Request #2516