osdir.com

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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 <
rafaelweingartner@xxxxxxxxx> 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 <awitwicki@xxxxxxxxxxxxx>
> wrote:
>
>> ACS 4.9.3.1
>>
>> Thanks
>>
>> Adam
>>
>>
>> -----Original Message-----
>> From: Rafael Weingärtner <rafaelweingartner@xxxxxxxxx>
>> Sent: 04 May 2018 15:27
>> To: users <users@xxxxxxxxxxxxxxxxxxxxx>
>> 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 <awitwicki@xxxxxxxxxxxxx>
>> 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 <rafaelweingartner@xxxxxxxxx>
>> > Sent: 04 May 2018 15:17
>> > To: users <users@xxxxxxxxxxxxxxxxxxxxx>
>> > 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
>> > <awitwicki@xxxxxxxxxxxxx>
>> > wrote:
>> >
>> > > Please find attached
>> > >
>> > >
>> > >
>> > > -----Original Message-----
>> > > From: Rafael Weingärtner <rafaelweingartner@xxxxxxxxx>
>> > > Sent: 04 May 2018 14:52
>> > > To: users <users@xxxxxxxxxxxxxxxxxxxxx>
>> > > 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
>> > > <awitwicki@xxxxxxxxxxxxx>
>> > > 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,
>> > > > network_offerings.supports_public_access,
>> > > > network_offerings.internal_lb, network_offerings.public_lb,
>> > > > network_offerings.service_package_id FROM network_offerings WHERE
>> > > > network_offerings.unique_name = _binary'QuickCloudNoServices'  AND
>> > > > network_offerings.removed IS NULL  ORDER BY RAND() LIMIT 1
>> > > >
>> > > >
>> > > > Thanks
>> > > >
>> > > > Adam
>> > > >
>> > > > Disclaimer Notice:
>> > > > This email has been sent by Oakford Technology Limited, while we
>> > > > have checked this e-mail and any attachments for viruses, we can
>> > > > not guarantee that they are virus-free. You must therefore take
>> > > > full responsibility for virus checking.
>> > > > This message and any attachments are confidential and should only
>> > > > be read by those to whom they are addressed. If you are not the
>> > > > intended recipient, please contact us, delete the message from
>> > > > your computer and destroy any copies. Any distribution or copying
>> > > > without our prior permission is prohibited.
>> > > > Internet communications are not always secure and therefore
>> > > > Oakford Technology Limited does not accept legal responsibility
>> > > > for this
>> > message.
>> > > > The recipient is responsible for verifying its authenticity before
>> > > > acting on the contents. Any views or opinions presented are solely
>> > > > those of the author and do not necessarily represent those of
>> > > > Oakford
>> > > Technology Limited.
>> > > > Registered address: Oakford Technology Limited, 10 Prince Maurice
>> > > > Court, Devizes, Wiltshire. SN10 2RT.
>> > > > Registered in England and Wales No. 5971519
>> > > >
>> > > >
>> > >
>> > >
>> > > --
>> > > Rafael Weingärtner
>> > > Disclaimer Notice:
>> > > This email has been sent by Oakford Technology Limited, while we
>> > > have checked this e-mail and any attachments for viruses, we can not
>> > > guarantee that they are virus-free. You must therefore take full
>> > > responsibility for virus checking.
>> > > This message and any attachments are confidential and should only be
>> > > read by those to whom they are addressed. If you are not the
>> > > intended recipient, please contact us, delete the message from your
>> > > computer and destroy any copies. Any distribution or copying without
>> > > our prior permission is prohibited.
>> > > Internet communications are not always secure and therefore Oakford
>> > > Technology Limited does not accept legal responsibility for this
>> message.
>> > > The recipient is responsible for verifying its authenticity before
>> > > acting on the contents. Any views or opinions presented are solely
>> > > those of the author and do not necessarily represent those of
>> > > Oakford
>> > Technology Limited.
>> > > Registered address: Oakford Technology Limited, 10 Prince Maurice
>> > > Court, Devizes, Wiltshire. SN10 2RT.
>> > > Registered in England and Wales No. 5971519
>> > >
>> > >
>> >
>> >
>> > --
>> > Rafael Weingärtner
>> > Disclaimer Notice:
>> > This email has been sent by Oakford Technology Limited, while we have
>> > checked this e-mail and any attachments for viruses, we can not
>> > guarantee that they are virus-free. You must therefore take full
>> > responsibility for virus checking.
>> > This message and any attachments are confidential and should only be
>> > read by those to whom they are addressed. If you are not the intended
>> > recipient, please contact us, delete the message from your computer
>> > and destroy any copies. Any distribution or copying without our prior
>> > permission is prohibited.
>> > Internet communications are not always secure and therefore Oakford
>> > Technology Limited does not accept legal responsibility for this
>> message.
>> > The recipient is responsible for verifying its authenticity before
>> > acting on the contents. Any views or opinions presented are solely
>> > those of the author and do not necessarily represent those of Oakford
>> Technology Limited.
>> > Registered address: Oakford Technology Limited, 10 Prince Maurice
>> > Court, Devizes, Wiltshire. SN10 2RT.
>> > Registered in England and Wales No. 5971519
>> >
>> >
>>
>>
>> --
>> Rafael Weingärtner
>> Disclaimer Notice:
>> This email has been sent by Oakford Technology Limited, while we have
>> checked this e-mail and any attachments for viruses, we can not guarantee
>> that they are virus-free. You must therefore take full responsibility for
>> virus checking.
>> This message and any attachments are confidential and should only be read
>> by those to whom they are addressed. If you are not the intended recipient,
>> please contact us, delete the message from your computer and destroy any
>> copies. Any distribution or copying without our prior permission is
>> prohibited.
>> Internet communications are not always secure and therefore Oakford
>> Technology Limited does not accept legal responsibility for this message.
>> The recipient is responsible for verifying its authenticity before acting
>> on the contents. Any views or opinions presented are solely those of the
>> author and do not necessarily represent those of Oakford Technology Limited.
>> Registered address: Oakford Technology Limited, 10 Prince Maurice Court,
>> Devizes, Wiltshire. SN10 2RT.
>> Registered in England and Wales No. 5971519
>>
>>
>
>
> --
> Rafael Weingärtner
>



-- 
Rafael Weingärtner