Hi Pierre-Luc, I found the cause of the issue. PR 1134 addresses a change for affinity groups and alters this file [1].
However, it was merged om Dec 3 while the 4.6.1 RC was send on Nov 30. No way it could have ended up in 4.6.1, so it ended up afterwards in 4.6.2 and 4.7.0 etc. We should have put it in schema-461to462.sql instead but that doesn’t help any more now. This means, any new install from 4.6.2 and higher is fine. Also, any upgrade from 4.6.0 and before to 4.6.2 and later is also fine. The problem is only when upgrading from 4.6.1 as this release doesn’t have the query in the file (the file appears in 4.6.2 and any later release). Workaround is to manually run the query as specified in [1]. Regards, Remi [1] https://github.com/apache/cloudstack/blob/master/setup/db/db/schema-460to461.sql On 23/01/16 03:05, "Pierre-Luc Dion" <pd...@cloudops.com> wrote: >For the affinity group issue, here is the DB output: > >mysql> select * from version; >+----+---------+---------------------+----------+ >| id | version | updated | step | >+----+---------+---------------------+----------+ >| 1 | 4.0.0 | 2015-11-17 23:16:34 | Complete | >| 2 | 4.1.0 | 2015-11-18 04:29:49 | Complete | >| 3 | 4.2.0 | 2015-11-18 04:29:50 | Complete | >| 4 | 4.2.1 | 2015-11-18 04:29:50 | Complete | >| 5 | 4.3.0 | 2015-11-18 05:29:57 | Complete | >| 6 | 4.4.0 | 2015-11-18 05:29:57 | Complete | >| 7 | 4.4.1 | 2015-11-18 05:29:57 | Complete | >| 8 | 4.4.2 | 2015-11-18 05:29:57 | Complete | >| 9 | 4.5.0 | 2015-11-18 05:29:57 | Complete | >| 10 | 4.5.1 | 2015-11-18 05:29:57 | Complete | >| 11 | 4.5.2 | 2015-11-18 05:29:57 | Complete | >| 12 | 4.6.0 | 2015-11-18 05:29:57 | Complete | >| 13 | 4.6.1 | 2015-12-01 00:52:11 | Complete | >| 14 | 4.7.0 | 2016-01-21 14:16:34 | Complete | >| 15 | 4.7.1 | 2016-01-21 14:16:34 | Complete | >+----+---------+---------------------+----------+ > >Hope this help, other then that, so far so good, using xenserver 6.2.0 >Still testing over the weekend... > > > > >On Fri, Jan 22, 2016 at 11:35 AM, Remi Bergsma <rberg...@schubergphilis.com> >wrote: > >> Looks like a bug, but not one that should block a release. >> >> Regards, Remi >> >> On 22 Jan 2016, at 17:26, Glenn Wagner <glenn.wag...@shapeblue.com<mailto: >> glenn.wag...@shapeblue.com>> wrote: >> >> Hi Guys, >> >> This does look like its an issue , this has been reported before >> Under >> >> https://issues.apache.org/jira/browse/CLOUDSTACK-9206 >> >> The work around is too use a predefined service offering with a lower CPU >> speed not custom >> >> Thanks >> Glenn >> >> >> >> >> [ShapeBlue]<http://www.shapeblue.com> >> Glenn Wagner >> Senior Consultant , ShapeBlue >> >> >> d: | s: +27 21 527 0091<tel:|%20s:%20+27%2021%20527%200091> >> | m: +27 73 917 4111<tel:+27%2073%20917%204111> >> >> e: glenn.wag...@shapeblue.com | t: >> <mailto:glenn.wag...@shapeblue.com%20|%20t:> >> | w: www.shapeblue.com<http://www.shapeblue.com> >> >> a: 2nd Floor, Oudehuis Centre, 122 Main Rd, Somerset West Cape Town >> 7130 South Africa >> >> >> [cid:imageec9cee.png@94dabaf1.4b82b04b] >> >> >> 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. >> 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. >> >> >> >> >> -----Original Message----- >> From: Tomasz Zięba [mailto:t.a.zi...@gmail.com] >> Sent: Friday, 22 January 2016 5:12 PM >> To: dev <dev@cloudstack.apache.org<mailto:dev@cloudstack.apache.org>> >> Subject: Re: [VOTE] Apache CloudStack 4.7.1 >> >> Hi all, >> >> -1 https://issues.apache.org/jira/browse/CLOUDSTACK-9251 >> >> Best Regards >> Tom >> >> >> 2016-01-20 23:27 GMT+01:00 Remi Bergsma <rberg...@schubergphilis.com >> <mailto:rberg...@schubergphilis.com>>: >> >> > Hi all, >> > >> > I've created a 4.7.1 release candidate, 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= >> > 4.7.1-RC20160120T2318 >> > >> > Commit: 5ea07dc93799f28dd6c268b17514867d92dc53f7 >> > >> > Source release (checksums and signatures are available at the same >> > location): >> > https://dist.apache.org/repos/dist/dev/cloudstack/4.7.1/ >> > >> > PGP release keys (signed using A47DDC4F): >> > https://dist.apache.org/repos/dist/release/cloudstack/KEYS >> > >> > Vote will be open for at least 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) >> > >> > >> >> >> -- >> Regards, >> Tomasz Zięba >> Twitter: @TZieba >> LinkedIn: pl.linkedin.com/pub/tomasz-zięba-ph-d/3b/7a8/ab6/ >> <http://pl.linkedin.com/pub/tomasz-zi%C4%99ba-ph-d/3b/7a8/ab6/>< >> http://pl.linkedin.com/pub/tomasz-zięba-ph-d/3b/7a8/ab6/> >> <http://pl.linkedin.com/pub/tomasz-zi%C4%99ba-ph-d/3b/7a8/ab6/> >> 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/> >>
