This is an automated email from the ASF dual-hosted git repository. andrijapanic pushed a commit to branch remove-duplicate-region-index in repository https://gitbox.apache.org/repos/asf/cloudstack.git
commit a03eeb5c7a63511828299141e1fce369cb9ede0b Author: Andrija Panic <[email protected]> AuthorDate: Wed Feb 12 13:07:17 2020 +0100 remove duplicate index region --- .../src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql b/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql index fa631ef..7758f11 100644 --- a/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql +++ b/engine/schema/src/main/resources/META-INF/db/schema-41300to41400-cleanup.sql @@ -23,3 +23,6 @@ DELETE FROM `cloud`.`configuration` WHERE name = 'host.maintenance.retries'; -- Stop asking user (in the upgraded documentation) to remove a trailing slash for local KVM pool UPDATE `cloud`.`storage_pool` SET path="/var/lib/libvirt/images" WHERE path="/var/lib/libvirt/images/"; + +-- remove (one of) duplicate unique indexes from Region table +ALTER TABLE `region` DROP INDEX `id_3`;
