drop all alert indice on column last_sent created up to 4.1 version
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/40982cce Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/40982cce Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/40982cce Branch: refs/heads/disk_io_throttling Commit: 40982ccef22e2a6f61ae571017d711f60358ede8 Parents: 1eab817 Author: Min Chen <min.c...@citrix.com> Authored: Mon Jun 10 11:03:45 2013 -0700 Committer: Min Chen <min.c...@citrix.com> Committed: Mon Jun 10 11:04:50 2013 -0700 ---------------------------------------------------------------------- engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java | 1 + 1 file changed, 1 insertion(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/40982cce/engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java ---------------------------------------------------------------------- diff --git a/engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java b/engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java index d8f90ad..8378eec 100644 --- a/engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java +++ b/engine/schema/src/com/cloud/upgrade/dao/Upgrade410to420.java @@ -90,6 +90,7 @@ public class Upgrade410to420 implements DbUpgrade { //First drop if it exists. (Due to patches shipped to customers some will have the index and some wont.) List<String> indexList = new ArrayList<String>(); s_logger.debug("Dropping index i_alert__last_sent if it exists"); + indexList.add("last_sent"); // in 4.1, we created this index that is not in convention. indexList.add("i_alert__last_sent"); DbUpgradeUtils.dropKeysIfExist(conn, "alert", indexList, false);
