OSDir

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

Re: Issue upgrading 4.9 to 4.11 Database?


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