cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Will Stevens <williamstev...@gmail.com>
Subject Re: Error on Master
Date Wed, 21 Dec 2016 21:14:13 GMT
​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 <williamstevens@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 <williamstevens@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?
>>
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message