I think that 4.9.3.1 was a very recent update to fix a security issue. We'll
need to check upgrade of 4.11.0.1 as well??
paul.an...@shapeblue.com
www.shapeblue.com
53 Chandos Place, Covent Garden, London WC2N 4HSUK
@shapeblue
-Original Message-
From: Rafael Weingärtner
Sent: 04 May 2018 17:10
To: users
Subject: Re: Issue upgrading 4.9 to 4.11 Database?
Just an update. I will try to fix this for 4.11.1.0
On Fri, May 4, 2018 at 11:36 AM, Rafael Weingärtner <
rafaelweingart...@gmail.com> wrote:
> So, there you are. This is a consequence of the DB upgrade method we
> are using :(((
> 4.9.3.1 was launched after 4.11. There is no upgrade path from 4.9.3.1
> to 4.11.
>
> What is the state of your version table?
>
> On Fri, May 4, 2018 at 11:28 AM, Adam Witwicki
>
> wrote:
>
>> ACS 4.9.3.1
>>
>> Thanks
>>
>> Adam
>>
>>
>> -Original Message-
>> From: Rafael Weingärtner
>> Sent: 04 May 2018 15:27
>> To: users
>> Subject: Re: Issue upgrading 4.9 to 4.11 Database?
>>
>> ** This mail originated from OUTSIDE the Oakford corporate network.
>> Treat hyperlinks and attachments in this email with caution. **
>>
>> I forgot that was only for people with Apache ID.
>> So is in Unknown column 'network_offerings.supports_public_access' in
>> 'field list' . It seems that some scripts were not executed.
>>
>> That field is created with script "schema-4930to41000.sql". What was
>> your ACS 4.9 version?
>>
>> On Fri, May 4, 2018 at 11:20 AM, Adam Witwicki
>>
>> wrote:
>>
>> > That URL required a username and password
>> >
>> > Here is the log @ pastebin https://pastebin.com/0xRnqPV3
>> >
>> > Thanks
>> >
>> > Adam
>> >
>> > -Original Message-
>> > From: Rafael Weingärtner
>> > Sent: 04 May 2018 15:17
>> > To: users
>> > Subject: Re: Issue upgrading 4.9 to 4.11 Database?
>> >
>> > ** This mail originated from OUTSIDE the Oakford corporate network.
>> > Treat hyperlinks and attachments in this email with caution. **
>> >
>> > Attachements are stripped...
>> > Instead, you can use: https://paste.apache.org/
>> >
>> > On Fri, May 4, 2018 at 11:02 AM, Adam Witwicki
>> >
>> > wrote:
>> >
>> > > Please find attached
>> > >
>> > >
>> > >
>> > > -Original Message-
>> > > From: Rafael Weingärtner
>> > > Sent: 04 May 2018 14:52
>> > > To: users
>> > > Subject: Re: Issue upgrading 4.9 to 4.11 Database?
>> > >
>> > > ** This mail originated from OUTSIDE the Oakford corporate network.
>> > > Treat hyperlinks and attachments in this email with caution. **
>> > >
>> > > We will need more log entries. However, this is looking like a DB
>> > > version issue.
>> > >
>> > > On Fri, May 4, 2018 at 10:49 AM, Adam Witwicki
>> > >
>> > > wrote:
>> > >
>> > > > Hello,
>> > > >
>> > > > The management service won't start after update, I get this in
>> > > > the log
>> > > >
>> > > > Failed startup of context o.e.j.w.WebAppContext@4148db48
>> > > > {/client,file:///usr/share/cloudstack-management/webapp/,
>> > > > UNAVAILABLE}{/usr/share/cloudstack-management/webapp}
>> > > > org.springframework.context.ApplicationContextException: Failed
>> > > > to start bean 'cloudStackLifeCycle'; nested exception is
>> > > com.cloud.utils.exception.CloudRuntimeException:
>> > > > DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@ed1d2cf:
>> > > > 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.for_vpc,
>> > > > network_offerings.egress_default_policy,
>> > > > network_offerings.concurrent_connections,
>> > > > network_offerings.keep_alive_enabled,
>> > > > network_offerings.supports_streched_l2,
>> >