Will,
I tried to run some upgrade tests and could not reproduce your issue. If this happens again, let me know. Regards. ________________________________ From: Rohit Yadav <bhais...@apache.org> Sent: 22 December 2016 12:03:41 To: Will Stevens Cc: dev@cloudstack.apache.org Subject: Re: Error on Master Hi Will, I tried a fresh installation of latest master and I was able to deploy database. I'll run upgrade tests soon to verify if there are any issues. Regards. On Thu, Dec 22, 2016 at 12:41 AM, Will Stevens <williamstev...@gmail.com> wrote: > Has anyone seen this. > > I upgraded a system which was running master to a later version of master > and I get the following when I start the service after upgrading. > > 2016-12-21 18:55:13,388 WARN [o.a.c.s.m.c.ResourceApplicationContext] > (main:null) (logid:) Exception encountered during context initialization - > cancelling refresh attempt: > org.springframework.context.ApplicationContextException: > Failed to start bean 'cloudStackLifeCycle'; nested exception is > com.cloud.utils.exception.CloudRuntimeException: DB Exception on: > com.mysql.jdbc.JDBC4PreparedStatement@69cd2214: SELECT > network_offerings.id, network_offerings.name, > network_offerings.unique_name, network_offerings.display_text, > network_offerings.nw_rate, network_offerings.mc_rate, > network_offerings.traffic_type, network_offerings.specify_vlan, > network_offerings.system_only, network_offerings.service_offering_id, > network_offerings.tags, network_offerings.default, > network_offerings.availability, > network_offerings.state, network_offerings.removed, > network_offerings.created, network_offerings.guest_type, > network_offerings.dedicated_lb_service, > network_offerings.shared_source_nat_service, > network_offerings.specify_ip_ranges, network_offerings.sort_key, > network_offerings.uuid, network_offerings.redundant_router_service, > network_offerings.conserve_mode, network_offerings.elastic_ip_service, > network_offerings.eip_associate_public_ip, > network_offerings.elastic_lb_service, > network_offerings.inline, network_offerings.is_persistent, > network_offerings.egress_default_policy, > network_offerings.concurrent_connections, > network_offerings.keep_alive_enabled, network_offerings.supports_streched_l2, > network_offerings.supports_public_access, network_offerings.internal_lb, > network_offerings.public_lb FROM network_offerings WHERE > network_offerings.unique_name = _binary'System-Public-Network' AND > network_offerings.removed IS NULL ORDER BY RAND() LIMIT 1 > > > I tried running the SQL directly to see what I get and I get the following: > > mysql> SELECT network_offerings.id, network_offerings.name, > network_offerings.unique_name, network_offerings.display_text, > network_offerings.nw_rate, network_offerings.mc_rate, > network_offerings.traffic_type, network_offerings.specify_vlan, > network_offerings.system_only, network_offerings.service_offering_id, > network_offerings.tags, network_offerings.default, > network_offerings.availability, > network_offerings.state, network_offerings.removed, > network_offerings.created, network_offerings.guest_type, > network_offerings.dedicated_lb_service, > network_offerings.shared_source_nat_service, > network_offerings.specify_ip_ranges, network_offerings.sort_key, > network_offerings.uuid, network_offerings.redundant_router_service, > network_offerings.conserve_mode, network_offerings.elastic_ip_service, > network_offerings.eip_associate_public_ip, > network_offerings.elastic_lb_service, > network_offerings.inline, network_offerings.is_persistent, > network_offerings.egress_default_policy, > network_offerings.concurrent_connections, > network_offerings.keep_alive_enabled, network_offerings.supports_streched_l2, > network_offerings.supports_public_access, network_offerings.internal_lb, > network_offerings.public_lb FROM network_offerings WHERE > network_offerings.unique_name = _binary'System-Public-Network' AND > network_offerings.removed IS NULL ORDER BY RAND() LIMIT 1; > > ERROR 1054 (42S22): Unknown column 'network_offerings.supports_public_access' > in 'field list' > > Did I miss a step or something in my upgrade from master to the latest > master? I have done this upgrade a few times in the past without issues, > but maybe something has changed? > rohit.ya...@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue
