Hi Pierre-Luc, The only reference I find is in the schema-460to461.sql file. But since you already run 4.6.1 it is not executed.
How did you upgrade to 4.6.1 before? Regards, Remi On 21/01/16 15:30, "Pierre-Luc Dion" <pd...@cloudops.com> wrote: >Did test upgrade from 4.6.1 to 4.7.1 and when I look into Affinity Groups > tab in the ui I see the following error message: > >DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@23f3ef77: SELECT >affinity_group_view.id, affinity_group_view.name, affinity_group_view.type, >affinity_group_view.description, affinity_group_view.uuid, >affinity_group_view.account_id, affinity_group_view.account_uuid, >affinity_group_view.account_name, affinity_group_view.account_type, >affinity_group_view.domain_id, affinity_group_view.domain_uuid, >affinity_group_view.domain_name, affinity_group_view.domain_path, >affinity_group_view.project_id, affinity_group_view.project_uuid, >affinity_group_view.project_name, affinity_group_view.vm_id, >affinity_group_view.vm_uuid, affinity_group_view.vm_name, >affinity_group_view.vm_display_name, affinity_group_view.vm_state, >affinity_group_view.acl_type FROM affinity_group_view WHERE >affinity_group_view.id IN (2,3) > >Could it be possible a db query is missing in the upgrade path ? > > >Performing the query directly in MySQL provide the following error: >ERROR 1054 (42S22): Unknown column 'affinity_group_view.project_id' in >'field list' > > >Thanks, > >PL > > >On Thu, Jan 21, 2016 at 7:31 AM, Boris Roman Schrijver < >bschrij...@schubergphilis.com> wrote: > >> Hi all, >> >> I’ve tested this release extensively over the past few weeks. It’s getting >> better and better! >> >> Vote: +1 (binding) >> >> All integration tests succeeded and deployment on both Xen and KVM went >> fine. Currently running this release in beta! >> >> >> >> Boris Roman Schrijver >> Mission Critical Engineer >> >> +31 20 7506500 >> +31 20 7506500 >> Boeingavenue 271 >> 1119 PD Schiphol-Rijk >> >> <https://www.schubergphilis.com/> >> >> >> >> >> >> >> >> >> >> On 20/01/16 23:27, "Remi Bergsma" <rberg...@schubergphilis.com> wrote: >> >> >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) >> > >>