git.net

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

RE: Issue upgrading 4.9 to 4.11 Database?


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.angus@xxxxxxxxxxxxx 
www.shapeblue.com
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue
  
 


-----Original Message-----
From: Rafael Weingärtner <rafaelweingartner@xxxxxxxxx> 
Sent: 04 May 2018 17:10
To: users <users@xxxxxxxxxxxxxxxxxxxxx>
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 < 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


( ! ) Warning: include(msgfooter.php): failed to open stream: No such file or directory in /var/www/git/apache-cloudstack-development/msg07351.html on line 332
Call Stack
#TimeMemoryFunctionLocation
10.0009377008{main}( ).../msg07351.html:0

( ! ) Warning: include(): Failed opening 'msgfooter.php' for inclusion (include_path='.:/var/www/git') in /var/www/git/apache-cloudstack-development/msg07351.html on line 332
Call Stack
#TimeMemoryFunctionLocation
10.0009377008{main}( ).../msg07351.html:0