We just ran into this issue on moving from 5.5.40 -> 5.5.41 as well on Ubuntu (new package released this morning for 14.04). Forcing it back to 5.5.35 (official release version) works around it as well. I look forward to this making it into release versions soon. It was mildly unexpected to say the least. Do we need to add something to the documentation noting a maximum version of mysql for the existing releases?
On Thu, Jan 15, 2015 at 12:35 PM, Erik Weber <terbol...@gmail.com> wrote: > I solved it by referencing the relevant queries to the cloud database. > > A backward compatible fix has been submitted and merged. > > Erik > > Den torsdag 15. januar 2015 skrev Raja Pullela <raja.pull...@citrix.com> > følgende: > > > Hi Erik, don't believe an issue was created on mysql... still needs to be > > investigated to why the SQL script will work on one version and not on > the > > other? You can downgrade to 5.6.21 and try it again, in case you are > > interested? > > > > Raja > > > > -----Original Message----- > > From: Erik Weber [mailto:terbol...@gmail.com <javascript:;>] > > Sent: Thursday, January 15, 2015 12:40 PM > > To: dev > > Subject: Re: weird db setup issue > > > > I can't answer for Sebastien, but in my case it was 5.6.22 (installed > from > > mysql-community repo on centos7). > > > > Do you have a link to the mysql bug? > > > > -- > > Erik > > > > On Wed, Jan 14, 2015 at 4:10 PM, Raja Pullela <raja.pull...@citrix.com > > <javascript:;>> > > wrote: > > > > > Sebastien, > > > > > > Can you check your MySQL version ? Is it 5.6.22 or above ? > > > There was an issue with MySQL 5.6.22 - where in the SQL file mentioned > > > returns an error, runs fine on MySQL 5.6.21 and below. > > > You can downgrade/install the MySQL that is packaged with 4.5.0 OR > > > update the SQL to include the "use cloud" before the SQL command. > > > > > > Raja > > > -----Original Message----- > > > From: Erik Weber [mailto:terbol...@gmail.com <javascript:;>] > > > Sent: Wednesday, January 14, 2015 4:53 PM > > > To: dev > > > Subject: Re: weird db setup issue > > > > > > This happens on a new installation of Citrix CloudPlatform 4.5.0 as > well. > > > > > > If anyone has time, we should check if this happens on ACS 4.5 and fix > > > it > > > > > > -- > > > Erik > > > > > > On Fri, Dec 5, 2014 at 9:27 PM, Sebastien Goasguen <run...@gmail.com > > <javascript:;>> > > > wrote: > > > > > > > > > > > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.ya...@shapeblue.com > > <javascript:;>> > > > wrote: > > > > > > > > > Hi Sebastien, > > > > > > > > > > Which build/version of CloudStack are you using? > > > > > > > > this is 4.3.1 from packages, ubuntu 14.04 > > > > > > > > but I think it's an issue with my setup. that schema file has not > > > > changed in more than a year and is the same in all branches. > > > > > > > > I will keep investigating. > > > > > > > > adding use cloud (like Erik mentioned) solved the issue. > > > > > > > > > > > > > >> On 05-Dec-2014, at 7:22 pm, Erik Weber <terbol...@gmail.com > > <javascript:;>> wrote: > > > > >> > > > > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen > > > > >> <run...@gmail.com <javascript:;>> > > > > wrote: > > > > >> > > > > >>> Hi, > > > > >>> > > > > >>> I am trying to dockerize the whole cloudstack installation > process. > > > > >>> > > > > >>> When running cloudstack-setup-database I hit this weird issue: > > > > >>> > > > > >>> Detected local IP address as 172.17.0.25, will use as cluster > > > > management > > > > >>> server node IP[ OK ] > > > > >>> Preparing /etc/cloudstack/management/db.properties > > > > >>> [ OK ] > > > > >>> Applying > /usr/share/cloudstack-management/setup/create-database.sql > > > > >>> [ OK ] > > > > >>> Applying /usr/share/cloudstack-management/setup/create-schema.sql > > > > >>> [ OK ] > > > > >>> Applying > > > > >>> /usr/share/cloudstack-management/setup/create-database-premium.s > > > > >>> ql > > > > [ OK > > > > >>> ] > > > > >>> Applying > > > > /usr/share/cloudstack-management/setup/create-schema-premium.sql > > > > >>> > > > > >>> We apologize for below error: > > > > >>> *************************************************************** > > > > >>> Encountering an error when executing mysql script > > > > >>> ---------------------------------------------------------------- > > > > >>> -- > > > > >>> ---- > > > > >>> table: > > > > >>> /usr/share/cloudstack-management/setup/create-schema-premium.sql > > > > >>> > > > > >>> Error: > > > > >>> ERROR 1046 (3D000) at line 285: No database selected > > > > >>> > > > > >>> > > > > >>> Does this ring a bell to anyone ? why would the first schema be > > > > >>> created successfully and not create-schema-premium ? > > > > >>> > > > > >>> > > > > >> - the create-database* scripts doesn't need a selected database > > > > >> - the create-schema.sql script starts by selecting the database > > > > >> (use > > > > cloud;) > > > > >> > > > > >> create-schema-premium.sql doesn't have the same selection at > > > > >> start, and > > > > I'm > > > > >> no sql guru but it could be a foreign key or something else > > > > >> without an explicit schema that fails. > > > > >> you should probably be able to workaround it by adding a "use > > cloud;" > > > > early > > > > >> in the create-schema-premium.sql file > > > > >> > > > > >> that's my two cent. > > > > >> > > > > >> -- > > > > >> Erik > > > > > > > > > > Regards, > > > > > Rohit Yadav > > > > > Software Architect, ShapeBlue > > > > > M. +91 88 262 30892 | rohit.ya...@shapeblue.com <javascript:;> > > > > > Blog: bhaisaab.org | Twitter: @_bhaisaab > > > > > > > > > > > > > > > > > > > > Find out more about ShapeBlue and our range of CloudStack related > > > > services > > > > > > > > > > IaaS Cloud Design & Build< > > > > http://shapeblue.com/iaas-cloud-design-and-build//> > > > > > CSForge – rapid IaaS deployment > > > > > framework<http://shapeblue.com/csforge/> > > > > > CloudStack > > > > > Consulting<http://shapeblue.com/cloudstack-consultancy/> > > > > > CloudStack Software Engineering< > > > > http://shapeblue.com/cloudstack-software-engineering/> > > > > > CloudStack Infrastructure Support< > > > > http://shapeblue.com/cloudstack-infrastructure-support/> > > > > > CloudStack Bootcamp Training Courses< > > > > http://shapeblue.com/cloudstack-training/> > > > > > > > > > > This email and any attachments to it may be confidential and are > > > > intended solely for the use of the individual to whom it is > addressed. > > > > Any views or opinions expressed are solely those of the author and > > > > do not necessarily represent those of Shape Blue Ltd or related > > > > companies. If you are not the intended recipient of this email, you > > > > must neither take any action based upon its contents, nor copy or > > > > show it to anyone. Please contact the sender if you believe you have > > > > received > > > this email in error. > > > > Shape Blue Ltd is a company incorporated in England & Wales. > > > > ShapeBlue Services India LLP is a company incorporated in India and > > > > is operated under license from Shape Blue Ltd. Shape Blue Brasil > > > > Consultoria Ltda is a company incorporated in Brasil and is operated > > > > under license from Shape Blue Ltd. ShapeBlue SA Pty Ltd is a company > > > > registered by The Republic of South Africa and is traded under > > > > license from Shape Blue Ltd. ShapeBlue is a registered trademark. > > > > > > > > > > > > > > -- *Nate Gordon*Director of Technology | Appcore - the business of cloud computing® Office +1.800.735.7104 | Direct +1.515.612.7787 nate.gor...@appcore.com | www.appcore.com ---------------------------------------------------------------------- The information in this message is intended for the named recipients only. It may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or the taking of any action in reliance on the contents of this message is strictly prohibited. If you have received this e-mail in error, do not print it or disseminate it or its contents. In such event, please notify the sender by return e-mail and delete the e-mail file immediately thereafter. Thank you.
