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> 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 > 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
