From users-return-30535-archive-asf-public=cust-asf.ponee.io@cloudstack.apache.org Tue May 8 12:38:51 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 5517218063B for ; Tue, 8 May 2018 12:38:50 +0200 (CEST) Received: (qmail 20125 invoked by uid 500); 8 May 2018 10:38:48 -0000 Mailing-List: contact users-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@cloudstack.apache.org Delivered-To: mailing list users@cloudstack.apache.org Received: (qmail 20107 invoked by uid 99); 8 May 2018 10:38:47 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 May 2018 10:38:47 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 61C6A1A2D54 for ; Tue, 8 May 2018 10:38:47 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.001 X-Spam-Level: X-Spam-Status: No, score=-0.001 tagged_above=-999 required=6.31 tests=[RCVD_IN_DNSWL_NONE=-0.0001, SPF_PASS=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id 6HdCf-aNiLsf for ; Tue, 8 May 2018 10:38:42 +0000 (UTC) Received: from post2.oakfordhosting.com (post2.oakfordhosting.com [185.28.91.9]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 929185FB4C for ; Tue, 8 May 2018 10:38:41 +0000 (UTC) Received: from OTL-DE-EXCH1.OakfordUK.local ([81.142.101.129]) by post2.oakfordhosting.com with MailEnable ESMTP; Tue, 8 May 2018 11:38:37 +0100 Received: from OTL-DE-EXCH1.OakfordUK.local (192.168.100.16) by OTL-DE-EXCH1.OakfordUK.local (192.168.100.16) with Microsoft SMTP Server (TLS) id 15.0.1156.6; Tue, 8 May 2018 11:38:54 +0100 Received: from OTL-DE-EXCH1.OakfordUK.local ([::1]) by OTL-DE-EXCH1.OakfordUK.local ([::1]) with mapi id 15.00.1156.000; Tue, 8 May 2018 11:38:54 +0100 From: Adam Witwicki To: "users@cloudstack.apache.org" Subject: RE: Issue upgrading 4.9 to 4.11 Database? Thread-Topic: Issue upgrading 4.9 to 4.11 Database? Thread-Index: AdPjrnP2bEDpo4W9RbG6orHXCeabEP//8GQA///se+CAABqfgP//7lQQgAAUVQD//+7cwAACetiAAANJxAAAM0a7AP/7q64w//dPN7A= Date: Tue, 8 May 2018 10:38:54 +0000 Message-ID: <6385066928b54d4ea2756ebc3903da9e@OTL-DE-EXCH1.OakfordUK.local> References: <2572aeb1c2a64a7a9e8810d59039c48e@OTL-DE-EXCH1.OakfordUK.local> <22ca231a555049b0a3075dc9e5a3e283@OTL-DE-EXCH1.OakfordUK.local> <11991709580847b58925378b80d4f488@OTL-DE-EXCH1.OakfordUK.local> , In-Reply-To: Accept-Language: en-US, en-GB Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [192.168.100.90] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Envelope-Sender: awitwicki@oakfordis.com X-ME-Bayesian: 0.000000 It may have been my DB connection failing during the update, or running /us= r/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt= before cloudstack-setup-management Is up now Thanks Adam -----Original Message----- From: Adam Witwicki Sent: 08 May 2018 10:49 To: users@cloudstack.apache.org Subject: RE: Issue upgrading 4.9 to 4.11 Database? ** This mail originated from OUTSIDE the Oakford corporate network. Treat h= yperlinks and attachments in this email with caution. ** I'm getting the same error on a clean database trying to install Name : cloudstack-management Arch : x86_64 Version : 4.11.0.0 Release : shapeblue0.el7.centos Size : 100 M Repo : installed From repo : cloudstack-4.11 Summary : CloudStack management server UI Licence : ASL 2.0 Description : The CloudStack management server is the central point of coor= dination, : management, and intelligence in CloudStack. -----Original Message----- From: Rohit Yadav Sent: 05 May 2018 17:39 To: users Subject: Re: Issue upgrading 4.9 to 4.11 Database? ** This mail originated from OUTSIDE the Oakford corporate network. Treat h= yperlinks and attachments in this email with caution. ** Thanks for reporting and sharing, the fix would be to simply add the same u= pgrade path which would be applicable for 4.9.3.1. I'll post a fix on Monda= y. - Rohit ________________________________ From: Rafael Weing=E4rtner Sent: Friday, May 4, 2018 9:40:26 PM 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=E4rtner < rafaelweingartner@g= mail.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=E4rtner >> 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=E4rtner >> > 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=E4rtner >> > > 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, >> > > > 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 =3D >> > > > _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=E4rtner >> > > 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=E4rtner >> > 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=E4rtner >> 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 Te= chnology Limited. >> Registered address: Oakford Technology Limited, 10 Prince Maurice >> Court, Devizes, Wiltshire. SN10 2RT. >> Registered in England and Wales No. 5971519 >> >> > > > -- > Rafael Weing=E4rtner > -- Rafael Weing=E4rtner rohit.yadav@shapeblue.com www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue Disclaimer Notice: This email has been sent by Oakford Technology Limited, while we have check= ed this e-mail and any attachments for viruses, we can not guarantee that t= hey are virus-free. You must therefore take full responsibility for virus c= hecking. This message and any attachments are confidential and should only be read b= y 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 co= pies. Any distribution or copying without our prior permission is prohibite= d. Internet communications are not always secure and therefore Oakford Technol= ogy Limited does not accept legal responsibility for this message. The reci= pient is responsible for verifying its authenticity before acting on the co= ntents. 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, De= vizes, Wiltshire. SN10 2RT. Registered in England and Wales No. 5971519 Disclaimer Notice: This email has been sent by Oakford Technology Limited, while we have check= ed this e-mail and any attachments for viruses, we can not guarantee that t= hey are virus-free. You must therefore take full responsibility for virus c= hecking. This message and any attachments are confidential and should only be read b= y 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 co= pies. Any distribution or copying without our prior permission is prohibite= d. Internet communications are not always secure and therefore Oakford Technol= ogy Limited does not accept legal responsibility for this message. The reci= pient is responsible for verifying its authenticity before acting on the co= ntents. 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, De= vizes, Wiltshire. SN10 2RT. Registered in England and Wales No. 5971519