Return-Path: X-Original-To: apmail-incubator-cloudstack-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-cloudstack-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0E7FFED4C for ; Sat, 23 Feb 2013 02:07:15 +0000 (UTC) Received: (qmail 99700 invoked by uid 500); 23 Feb 2013 02:07:14 -0000 Delivered-To: apmail-incubator-cloudstack-dev-archive@incubator.apache.org Received: (qmail 99652 invoked by uid 500); 23 Feb 2013 02:07:14 -0000 Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cloudstack-dev@incubator.apache.org Delivered-To: mailing list cloudstack-dev@incubator.apache.org Received: (qmail 99643 invoked by uid 99); 23 Feb 2013 02:07:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Feb 2013 02:07:14 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of min.chen@citrix.com designates 66.165.176.63 as permitted sender) Received: from [66.165.176.63] (HELO SMTP02.CITRIX.COM) (66.165.176.63) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 23 Feb 2013 02:07:08 +0000 X-IronPort-AV: E=Sophos;i="4.84,720,1355097600"; d="scan'208";a="8704279" Received: from sjcpmailmx01.citrite.net ([10.216.14.74]) by FTLPIPO02.CITRIX.COM with ESMTP/TLS/RC4-MD5; 23 Feb 2013 02:06:46 +0000 Received: from SJCPMAILBOX01.citrite.net ([10.216.4.72]) by SJCPMAILMX01.citrite.net ([10.216.14.74]) with mapi; Fri, 22 Feb 2013 18:06:46 -0800 From: Min Chen To: "cloudstack-dev@incubator.apache.org" Date: Fri, 22 Feb 2013 18:06:45 -0800 Subject: Re: Upgrade path for db Thread-Topic: Upgrade path for db Thread-Index: Ac4Ram6nD4Ol9D2uT+uPGqLh85DwFA== Message-ID: In-Reply-To: <93099572B72EB341B81A644E134F240B012F750D7A92@SJCPMAILBOX01.citrite.net> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.3.1.130117 acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org Yes, I am running into the same issue. The problem is that DatabaseCreator is not currently invoking DatabaseUpgradeChecker. I just checked in Commit 5b760f903f1a3145f62d05c1d3c142b710248026 to address this issue, but still have one issue pending solution, that is, how to tell DatabaseCreator to look into setup/db folder to look for those sql script in pom.xml. So far we haven't found a solution yet. A temporary workaround is to copy setup/db/db to your project basedir. Thanks -min On 2/22/13 3:13 PM, "Vijayendra Bhamidipati" wrote: >How exactly are db upgrade scripts kicked off during a fresh db install >on the master branch? > >When I deploy a fresh db off the ACS master using : mvn -e -P developer >-pl developer -Ddeploydb, I don't see the tables specified in >setup/db/db/schema-40to410.sql or setup/db/db/schema-410to420.sql getting >created. > >The version in the create-schema.sql is 4.0.0 and the same shows up in >the newly created db when I do a select * from version; > >How do I ensure that when deploying a fresh db, the tables specified in >schema40to410.sql and schema-410to420.sql get created? > >Regards, >Vijay