You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Erik Weber <te...@gmail.com> on 2015/03/23 12:01:46 UTC
[ACS 4.5.1 RC1] Caught SQLException on startup
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..
--
Erik
Re: [ACS 4.5.1 RC1] Caught SQLException on startup
Posted by Erik Weber <te...@gmail.com>.
Thanks for the insight Alena :-)
--
Erik
Den tirsdag 24. mars 2015 skrev Alena Prokharchyk <al...@gmail.com>
følgende:
> 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
> <javascript:;>>
> 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 <javascript:;>
> > 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
>
Re: [ACS 4.5.1 RC1] Caught SQLException on startup
Posted by Rohit Yadav <ro...@shapeblue.com>.
Thanks for sharing Alena!
> On 24-Mar-2015, at 6:02 am, Alena Prokharchyk <al...@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 <ro...@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.
Re: [ACS 4.5.1 RC1] Caught SQLException on startup
Posted by Alena Prokharchyk <al...@gmail.com>.
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 <ro...@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
Re: [ACS 4.5.1 RC1] Caught SQLException on startup
Posted by Rohit Yadav <ro...@shapeblue.com>.
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.