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)
> >
>

Reply via email to