I was able to apply `setup/db/db/schema-4910to41000.sql` by doing the following (I am assuming that is how I should have done it).
# mysql -u root -p cloud < schema-4910to41000.sql The first attempt, I had the following error.: ERROR 1060 (42S21) at line 22: Duplicate column name 'update_state' I removed the following line and re-applied the sql and it seems that everything is working now. ALTER TABLE `cloud`.`domain_router` ADD COLUMN update_state varchar(64) DEFAULT NULL; Cheers, Will On Wed, Dec 21, 2016 at 2:16 PM, Will Stevens <williamstev...@gmail.com> wrote: > It looks like this file `setup/db/db/schema-4910to41000.sql` has modified > this. > > ALTER TABLE `cloud`.`network_offerings` ADD COLUMN supports_public_access > boolean default false; > > So I guess I need to apply this SQL update somehow. Since I am going from > Master to Master, how should I do this? Any tips or hints for me? > > On Wed, Dec 21, 2016 at 2:11 PM, 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? >> > >
