Hi Rene, Thanks for reporting. I’ve just deployed a ACS 4.2.1 DB and upgraded to ACS 4.5.1, and found no exceptions.
Did you try this on a fresh installation of ACS 4.2.1 or was it CCP 4.2.1? (in production we have seen db upgrade issues if customers were using CCP 4.2.x or 4.3.x and upgrading to 4.4.x or later). The alter statements are on two different tables (cloud_usage and usage_vm_instance) so ideally won’t cause conflicts unless the columns were already altered due to one of the above issues. > On 05-May-2015, at 3:47 pm, Daan Hoogland <daan.hoogl...@gmail.com> wrote: > > Rene, but it is a problem in the release. It sound very strange that it > would not have been caught in any of the 4.4 releases or in 4.5.0. I am > hesitant but a -1 is on the surface of my keyboard. > > Op di 5 mei 2015 om 13:03 schreef Rene Moser <m...@renemoser.net>: > >> Hi >> >> Tested an update from 4.2.1 to 4.5.1 which failed because of 2 identical >> ALTER TABLE statements for cloud_usage in schema-421to430.sql and >> schema-430to440.sql >> >> >> https://github.com/apache/cloudstack/blob/4.5-RC20150504T1217/setup/db/db/schema-421to430.sql#L787 >> >> >> https://github.com/apache/cloudstack/blob/4.5-RC20150504T1217/setup/db/db/schema-430to440.sql#L464 >> >> Commenting it out in schema-430to440.sql fixed it the update. Not really >> sure if this would brake anything in other conditions. >> >> It is not really a problem of 4.5.1, so not vote against it. >> >> Yours >> René >> >> On 04.05.2015 13:20, Rohit Yadav wrote: >>> Hi All, >>> >>> I've created a 4.5.1 release, with the following artifacts up for a vote: >>> >>> Git Branch and Commit SH: >>> >> https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=shortlog;h=refs/heads/4.5 >>> Commit: 0eb4eb23701f0c6fec8bd5461cd9aa9f92c9576d >>> >>> List of changes: >>> >> https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;a=blob_plain;f=CHANGES.md;hb=4.5 >>> https://github.com/apache/cloudstack/commits/4.5-RC20150504T1217 >>> >>> Source release (checksums and signatures are available at the same >>> location): >>> https://dist.apache.org/repos/dist/dev/cloudstack/4.5.1/ >>> >>> PGP release keys (signed using 0EE3D884): >>> https://dist.apache.org/repos/dist/release/cloudstack/KEYS >>> >>> Vote will be open for 72 hours. >>> >>> For sanity in tallying the vote, can PMC members please be sure to >>> indicate "(binding)" with their vote? >>> >>> [ ] +1 approve >>> [ ] +0 no opinion >>> [ ] -1 disapprove (and reason why) >>> >>> For convenience of testing, you may use the following repositories and >>> location to download systemvm templates: >>> >>> http://packages.shapeblue.com/cloudstack/testing/ >>> http://packages.shapeblue.com/systemvmtemplate/4.5/ >>> >>> Regards. >>> >> >> Regards, Rohit Yadav Software Architect, ShapeBlue M. +91 88 262 30892 | rohit.ya...@shapeblue.com Blog: bhaisaab.org | Twitter: @_bhaisaab Find out more about ShapeBlue and our range of CloudStack related services IaaS Cloud Design & Build<http://shapeblue.com/iaas-cloud-design-and-build//> CSForge – rapid IaaS deployment framework<http://shapeblue.com/csforge/> CloudStack Consulting<http://shapeblue.com/cloudstack-consultancy/> CloudStack Software Engineering<http://shapeblue.com/cloudstack-software-engineering/> CloudStack Infrastructure Support<http://shapeblue.com/cloudstack-infrastructure-support/> CloudStack Bootcamp Training Courses<http://shapeblue.com/cloudstack-training/> This email and any attachments to it may be confidential and are intended solely for the use of the individual to whom it is addressed. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Shape Blue Ltd or related companies. If you are not the intended recipient of this email, you must neither take any action based upon its contents, nor copy or show it to anyone. Please contact the sender if you believe you have received this email in error. Shape Blue Ltd is a company incorporated in England & Wales. ShapeBlue Services India LLP is a company incorporated in India and is operated under license from Shape Blue Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is operated under license from Shape Blue Ltd. ShapeBlue SA Pty Ltd is a company registered by The Republic of South Africa and is traded under license from Shape Blue Ltd. ShapeBlue is a registered trademark.
