cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ernie Janse van Rensburg (JIRA)" <>
Subject [jira] [Created] (CLOUDSTACK-10278) Adding a SQL table column is not Idempotent
Date Fri, 09 Feb 2018 13:39:00 GMT
Ernie Janse van Rensburg created CLOUDSTACK-10278:

             Summary: Adding a SQL table column is not Idempotent
                 Key: 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:,
            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

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

View raw message