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 <rafaelweingart...@gmail.com> Sent: 04 May 2018 17:10 To: users <us...@cloudstack.apache.org> 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 > <awitwi...@oakfordis.com> > wrote: > >> ACS 4.9.3.1 >> >> Thanks >> >> Adam >> >> >> -----Original Message----- >> From: Rafael Weingärtner <rafaelweingart...@gmail.com> >> Sent: 04 May 2018 15:27 >> To: users <us...@cloudstack.apache.org> >> 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 >> <awitwi...@oakfordis.com> >> 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 <rafaelweingart...@gmail.com> >> > Sent: 04 May 2018 15:17 >> > To: users <us...@cloudstack.apache.org> >> > 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 >> > <awitwi...@oakfordis.com> >> > wrote: >> > >> > > Please find attached >> > > >> > > >> > > >> > > -----Original Message----- >> > > From: Rafael Weingärtner <rafaelweingart...@gmail.com> >> > > Sent: 04 May 2018 14:52 >> > > To: users <us...@cloudstack.apache.org> >> > > 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 >> > > <awitwi...@oakfordis.com> >> > > 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