Thanks for the insight Alena :-) -- Erik
Den tirsdag 24. mars 2015 skrev Alena Prokharchyk <alena1...@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.ya...@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.ya...@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 >
