cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rohit Yadav <rohit.ya...@shapeblue.com>
Subject Re: [ACS 4.5.1 RC1] Caught SQLException on startup
Date Tue, 24 Mar 2015 06:37:01 GMT
Thanks for sharing Alena!

> On 24-Mar-2015, at 6:02 am, Alena Prokharchyk <alena1108@gmail.com> wrote:
>
> network_group table is long gone. I guess the only one reason for the
> keeping table related mysql statements in ConfigurationServerImpl.java - is
> to handle the upgrade scenarios. We should probably just disable the
> logging for this case.
>
> The situation with creating duplicated system/admin user is different. I
> believe the records for them get created as a part of the setup scripts
> when install from rpm. And as on dev environment those scripts don't get
> run, the records get inserted by ConfigurationServerImpl on a server
> startup. For the rpm deployment case, the latter insertion will result in
> duplicates, hence the silent exception catch. Ideally, the fix should be -
> create the users on a first server startup in the Java code only, so its
> common for dev and users environments.
>
> Not a high priority fix.
>
> On Mon, Mar 23, 2015 at 4:26 AM, Rohit Yadav <rohit.yadav@shapeblue.com>
> wrote:
>
>> Hi Erik,
>>
>> Yes, I've seen them before. The network_group table does not exist in
>> ACS, I've seen this issue as well but this is probably harmless and
>> perhaps has to do with maintaining migrations from old/other CCP
>> releases though I'm not sure.
>>
>> I'll try to see if we can address them, though they look harmless to me.
>>
>>
>> On Monday 23 March 2015 04:31 PM, Erik Weber wrote:
>>
>>> Anyone else see these during startup?
>>>
>>> 2015-03-23 11:59:32,712 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> Caught exception when inserting system account: Duplicate entry '1' for
>>> key
>>> 'PRIMARY'
>>> 2015-03-23 11:59:32,713 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> Caught SQLException when inserting system user: Duplicate entry '1' for
>>> key
>>> 'PRIMARY'
>>> 2015-03-23 11:59:32,714 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> Caught SQLException when creating admin account: Duplicate entry '2' for
>>> key 'PRIMARY'
>>> 2015-03-23 11:59:32,715 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> Caught SQLException when inserting admin user: Duplicate entry '2' for key
>>> 'PRIMARY'
>>> 2015-03-23 11:59:32,716 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> Caught (SQL?)Exception: no network_group  Table 'cloud.network_group'
>>> doesn't exist
>>> 2015-03-23 11:59:32,791 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> resource_count table has records missing for some accounts...going to
>>> insert them
>>> 2015-03-23 11:59:32,806 DEBUG [c.c.s.ConfigurationServerImpl] (main:null)
>>> Inserting resource count of type user_vm for account id=3
>>>
>>>
>>> The duplicate keys doesn't really worry me much, as that should mean it's
>>> already there, but the
>>> Table 'cloud.network_group' doesn't exist is a different story..
>>>
>>>
>> --
>> Regards,
>> Rohit Yadav
>> Software Architect, ShapeBlue
>> M. +91 8826230892 | rohit.yadav@shapeblue.com
>> Blog: bhaisaab.org | Twitter: @_bhaisaab
>> PS. If you see any footer below, I did not add it :)
>> 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.
>>
>
>
>
> --
> Alena Prokharchyk
> https://twitter.com/Lemonjet
> http://www.linkedin.com/pub/alena-prokharchyk/13/282/a7b

Regards,
Rohit Yadav
Software Architect, ShapeBlue
M. +91 88 262 30892 | rohit.yadav@shapeblue.com
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
View raw message