cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Weber <terbol...@gmail.com>
Subject Re: weird db setup issue
Date Thu, 15 Jan 2015 18:35:02 GMT
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.pullela@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:terbolous@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.pullela@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:terbolous@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 <runseb@gmail.com
> <javascript:;>>
> > wrote:
> >
> > >
> > > On Dec 5, 2014, at 9:20 AM, Rohit Yadav <rohit.yadav@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 <terbolous@gmail.com
> <javascript:;>> wrote:
> > > >>
> > > >> On Fri, Dec 5, 2014 at 2:32 PM, Sebastien Goasguen
> > > >> <runseb@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.yadav@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.
> > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message