Reply
Explorer
Posts: 17
Registered: ‎04-18-2016

Cloudera Manager: Migrate scm database from postgres to mysql

Hi,
I tried migrating cloudera manager to a diferent host with a fresh mysql installed on it. 
I copied all data from old server /var/lib/cloudera-scm-server/ to new server.

Migrated all databases from old server postgres to new server Mysql.

But when i try to start cloudera-scm-server, I get this error:

 


2018-02-13 12:16:24,908 INFO [main:bootstrap.EntityManagerFactoryBean@138] MYSQL database engine and table mapping: {InnoDB=[host_template_to_role_conf_grp, users, services_aud, role_config_groups_aud, cluster_activated_releases, releases_aud, clusters_aud, CLUSTERS, metrics, hosts, credentials, configs_aud, processes, services, roles_aud, ROLES, external_accounts_aud, parcels, config_containers, user_roles, PROCESSES, COMMANDS, releases, snapshot_policies, CONFIGS, process_active_releases, role_config_groups, parcel_components, host_templates, CREDENTIALS, hosts_aud, clusters, SCHEMA_VERSION, external_accounts, SERVICES, roles, global_settings, audits, HOSTS, commands, SETTINGS, cm_peers, schema_version, cluster_managed_releases, diagnostics_events, USERS, cluster_undistributed_releases, USER_ROLES, cm_version, AUDITS, configs, cluster_activated_releases_aud, role_staleness_status, command_schedules, user_settings, client_configs, client_configs_to_hosts, revisions]}
2018-02-13 12:16:24,953 INFO [main:dbutil.DbUtil@207] Schema version table already exists.
2018-02-13 12:16:24,954 INFO [main:dbutil.DbUtil@223] DB Schema version 11.
2018-02-13 12:16:24,954 INFO [main:dbutil.DbUtil@348] Current database schema version: 11
2018-02-13 12:16:25,550 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00012_cmf_schema.mysql.ddl
2018-02-13 12:16:25,561 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 12
2018-02-13 12:16:25,578 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00013_cmf_schema.mysql.ddl
2018-02-13 12:16:25,589 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 13
2018-02-13 12:16:25,630 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00014_cmf_schema.mysql.ddl
2018-02-13 12:16:25,641 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 14
2018-02-13 12:16:25,658 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00015_cmf_schema.mysql.ddl
2018-02-13 12:16:25,672 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 15
2018-02-13 12:16:25,714 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00016_cmf_schema.mysql.ddl
2018-02-13 12:16:25,727 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 16
2018-02-13 12:16:25,776 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00017_cmf_schema.mysql.ddl
2018-02-13 12:16:25,787 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 17
2018-02-13 12:16:25,826 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00018_cmf_schema.mysql.ddl
2018-02-13 12:16:25,837 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 18
2018-02-13 12:16:25,899 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00019_cmf_schema.mysql.ddl
2018-02-13 12:16:25,910 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 19
2018-02-13 12:16:25,966 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00020_cmf_schema.mysql.ddl
2018-02-13 12:16:25,978 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 20
2018-02-13 12:16:26,005 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00021_cmf_schema.mysql.ddl
2018-02-13 12:16:26,022 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 21
2018-02-13 12:16:26,063 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00022_cmf_schema.mysql.ddl
2018-02-13 12:16:26,072 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 22
2018-02-13 12:16:26,102 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00023_cmf_schema.mysql.ddl
2018-02-13 12:16:26,112 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 23
2018-02-13 12:16:26,144 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00024_cmf_schema.mysql.ddl
2018-02-13 12:16:26,154 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 24
2018-02-13 12:16:26,196 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00025_cmf_schema.mysql.ddl
2018-02-13 12:16:26,207 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 25
2018-02-13 12:16:26,223 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00026_cmf_schema.mysql.ddl
2018-02-13 12:16:26,233 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 26
2018-02-13 12:16:26,326 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00027_cmf_schema.mysql.ddl
2018-02-13 12:16:26,338 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 27
2018-02-13 12:16:26,359 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: /usr/share/cmf/schema/mysql/00028_cmf_schema.mysql.ddl
2018-02-13 12:16:26,369 INFO [main:dbutil.SqlScriptRunnerFactory$SqlStringRunner@204] Processed: Updated Schema Version to 28
2018-02-13 12:16:26,436 FATAL [main:cmdline.SqlFile@68] SQL Error at 'UTF-8' line 15:
"alter table CLIENT_CONFIGS
add index FK_CLIENT_CONFIG_SERVICE (SERVICE_ID),
add constraint FK_CLIENT_CONFIG_SERVICE
foreign key (SERVICE_ID)
references SERVICES (SERVICE_ID)"
Can't write; duplicate key in table '#sql-4881_2c9'
2018-02-13 12:16:26,436 FATAL [main:cmdline.SqlFile@68] Rolling back SQL transaction.
2018-02-13 12:16:26,437 ERROR [main:dbutil.SqlFileRunner@85] Exception while executing ddl scripts.
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-4881_2c9'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
at org.hsqldb.cmdline.SqlFile.processSQL(Unknown Source)
at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source)
at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)
at com.cloudera.enterprise.dbutil.SqlFileRunner.runSqlFile(SqlFileRunner.java:68)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlStringRunner.run(SqlScriptRunnerFactory.java:203)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:131)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:131)
at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:355)
at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:309)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkSchemaDoUpgrade(EntityManagerFactoryBean.java:150)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:108)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:56)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:318)
at com.cloudera.server.cmf.Main.<init>(Main.java:201)
at com.cloudera.server.cmf.Main.main(Main.java:186)
2018-02-13 12:16:26,440 ERROR [main:bootstrap.EntityManagerFactoryBean@154] Unable to upgrade schema to latest version.
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-4881_2c9'
at com.cloudera.enterprise.dbutil.SqlFileRunner.runSqlFile(SqlFileRunner.java:86)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlStringRunner.run(SqlScriptRunnerFactory.java:203)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:131)
at com.cloudera.enterprise.dbutil.SqlScriptRunnerFactory$SqlScriptRunnerComposite.run(SqlScriptRunnerFactory.java:131)
at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:355)
at com.cloudera.enterprise.dbutil.DbUtil.upgradeSchema(DbUtil.java:309)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkSchemaDoUpgrade(EntityManagerFactoryBean.java:150)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:108)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:56)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)
at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:616)
at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:148)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:1003)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:907)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
at com.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:318)
at com.cloudera.server.cmf.Main.<init>(Main.java:201)
at com.cloudera.server.cmf.Main.main(Main.java:186)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Can't write; duplicate key in table '#sql-4881_2c9'
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.Util.getInstance(Util.java:408)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2480)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2438)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
at org.hsqldb.cmdline.SqlFile.processSQL(Unknown Source)
at org.hsqldb.cmdline.SqlFile.scanpass(Unknown Source)
at org.hsqldb.cmdline.SqlFile.execute(Unknown Source)
at com.cloudera.enterprise.dbutil.SqlFileRunner.runSqlFile(SqlFileRunner.java:68)
... 31 more

 

 

 As i can see its tying to overwirte a data with primary key constraints, please let me know why its trying to this. I have also configured database using scm_prepare_database.sh .

Highlighted
Explorer
Posts: 17
Registered: ‎04-18-2016

Re: Cloudera Manager: Migrate scm database from postgres to mysql

Issue was with version mismatch of CM
Explorer
Posts: 17
Registered: ‎04-18-2016

Re: Cloudera Manager: Migrate scm database from postgres to mysql

It seems i was able to migrate from postgres to mysql server. But when i start cloudera-scm-server it gives me the following error:
2018-02-14 11:27:02,611 INFO ParcelUpdateService:com.cloudera.parcel.components.LocalParcelManagerImpl: Found files CDH-5.10.2-1.cdh5.10.2.p0.5-el7.parcel,KUDU-1.4.0-1.cdh5.12.1.p0.10-el7.parcel under /opt/cloudera/parcel-repo
2018-02-14 11:27:02,638 INFO MainThread:com.cloudera.server.cmf.Main: Server locale set to: en
2018-02-14 11:27:02,654 INFO MainThread:com.cloudera.server.cmf.components.EmbeddedDbManager: CM server is NOT using embedded postgresql database for itself.
2018-02-14 11:27:02,665 INFO MainThread:com.cloudera.cmf.service.CommandScheduleListener: Adding command schedule listener for global-collect-host-statistics
2018-02-14 11:27:02,672 INFO MainThread:com.cloudera.cmf.service.CommandScheduleListener: Initializing schedule for global-collect-host-statistics
2018-02-14 11:27:02,676 INFO MainThread:com.cloudera.cmf.command.datacollection.ClusterStatsCommandScheduler: No license - using free bundle settings
2018-02-14 11:27:02,686 INFO MainThread:com.cloudera.cmf.service.CommandScheduleListener: Replacing existing schedule for global-collect-host-statistics
2018-02-14 11:27:02,708 INFO MainThread:com.cloudera.cmf.service.CommandScheduleListener: Removed schedule DbCommandSchedule{id=23, commandName=global-collect-host-statistics}
2018-02-14 11:27:02,711 INFO MainThread:com.cloudera.cmf.service.CommandScheduleListener: Adding schedule - DbCommandSchedule{id=24, commandName=global-collect-host-statistics}
2018-02-14 11:27:02,742 INFO MainThread:com.cloudera.cmf.scheduler.CmfScheduler: Added command schedule '24' to the scheduler
2018-02-14 11:27:02,836 ERROR MainThread:com.cloudera.server.cmf.Main: Server failed.
java.lang.IllegalStateException
at com.google.common.base.Preconditions.checkState(Preconditions.java:133)
at com.cloudera.cmf.model.DbService.getOrCreateRoleConfigGroup(DbService.java:319)
at com.cloudera.cmf.service.RoleConfigGroupUtils.updateRoleConfigGroups(RoleConfigGroupUtils.java:125)
at com.cloudera.server.cmf.Main.updateRoleConfigGroups(Main.java:733)
at com.cloudera.server.cmf.Main.<init>(Main.java:312)
at com.cloudera.server.cmf.Main.main(Main.java:216)
2018-02-14 11:27:02,841 INFO Thread-11:org.springframework.context.support.ClassPathXmlApplicationContext: Closing ApplicationContext 'rootContext': startup date [Wed Feb 14 11:26:14 UTC 2018]; parent: org.springframework.context.support.GenericApplicationContext@2f06692f
2018-02-14 11:27:02,843 INFO Thread-11:org.springframework.beans.factory.support.DefaultListableBeanFactory: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@7a0467e9: defining beans [contextApplicationContextProvider,org.springframework.beans.factory.config.PropertyPlaceholderConfigurer#0,sessionRegistry,passwordEncoder,metricSchemaGeneration,viewFactory,predefinedPlots,predefinedViews,workAggregatesConfigListener,metricSchemaManagerBean,monitoringTypesInitializer,heartbeatCheckerImpl,clientProtocolImpl,agentLogFetcherImpl,serverLogFetcherImpl,ServerLogSearchResponse,logSearchEventsCollectorImpl,descriptorFactory,embeddedDbManager,scmDbValueStore,firehoseRequestService,cmServerState,licenseManagerImpl,authorizer,trialEventAuditor,licensedFeatureManager,serviceDataProviderBean,scmActive,currentUserManagerImpl,operationsManagerImpl,operationalReportsDisabledListener,featureFlagTracker,trialEventStalenessCheckTrigger,cmUpgradeHelper,userSettingTransactionManagerImpl,clouderaManagerMetricsForwarder,navigatorDisabledListener,actionablesProviderImpl,perfLogger,jythonObjectFactoryImpl,pythonInterpreterFactory,sessionServiceImpl,idleSessionManagerImpl,hostTemplateManagerImpl,cloudStatusDeterminer,beanConfiguration,sslHelper,securityUtils,processStalenessDetector,processStalenessInterceptor,scmParamTrackerStoreImpl,processHelper,releaseDetector,paramResolver,configHelper,runnerDescriptorProcessFactory,dynamicServiceHandlerFactory,configWriterFactory,compatibilityFactory,providesFactory,kerberosPrincProvider,auxConfigGeneratorFactory,configGeneratorFactory,peerConfigGeneratorFactory,HBaseZkConfigUpdateListener,hbaseRestServerSecurityListener,hbaseThriftServerSecurityListener,dssdToggleListener.PreCommit,dssdToggleListener.PostCommit,oozieLoadBalancerConfigUpdateListener,zkServerInitListener,HBaseIndexerAuthenticationConfigUpdateListener,solrAuthenticationConfigUpdateListener,solrLoadBalancerConfigUpdateListener,diagnosticsDataUploadHelper,commandManager,commandStorage,stalenessChecker,cmfSchedulerImpl,scheduleManagerImpl,callableFactory,dirtyParametersListener,parcelUpdateService,parcelDependencyManagerImpl,parcelDownloaderImpl,agentParcelProviderImpl,localParcelManagerImpl,periodicParcelTasks,parcelInstallerImpl,parcelRepoConfigUpdateListener,parcelStatusProviderImpl,parcelManagerImpl,csdLocalRepository,csdManager,csdRegistryImpl,csdTranslationManager,mdlRegistry,validatorConfiguration,parameterFactory,prototypeFactory,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,rulesEngine,getObjectMapper,agentAsyncClient,newHeartbeatRequester,commandRequestsBean,getSupportedLocale,newServiceHandlerRegistry,newEventStoreClientFactory,newAutoUpgradeHandlerRegistry,newUpgradeHandlerRegistry,newAgentResultFetcher,newCmfEntityManager,newDatabaseSizeGauge,newCdhExecutorFactory,databaseExecutor,builtInServiceTypes,builtInRoleTypes,builtInNamesForCrossEntityAggregateMetrics,builtInMetricEntityAttributes,builtInMetricEntityTypes,uniqueFieldValidator,requiresSubdirValidator,validServiceDependencyValidator,uniqueServiceTypeValidator,uniqueRoleTypeValidator,existingServiceTypeValidator,existingRoleTypeValidator,expressionValidator,autoConfigSharesValidValidator,messageInterpolator,sdlParser,mdlParser,parcelParser,alternativesParser,permissionsParser,manifestParser,stringInterpolator,serviceDescriptorValidator,serviceMonitoringDefinitionsDescriptorValidator,descriptorVisitor,referenceValidator,parcelDescriptorValidator,alternativesDescriptorValidator,permissionsDescriptorValidator,manifestDescriptorValidator,defaultValidatorConfiguration,springConstraintValidatorFactory,validatorFactoryBean,metricNameFormatValidator,nameForCrossEntityAggregateFormatValidator,objectMapper]; parent: org.springframework.beans.factory.support.DefaultListableBeanFactory@5ed70df9
2018-02-14 11:27:02,849 INFO Thread-11:com.cloudera.server.cmf.components.ScmActive: ScmActive shutting down.
2018-02-14 11:27:02,853 INFO metric-schema-updater:com.cloudera.cmon.components.MetricSchemaManager: Breaking from sleep in schema update thread.
2018-02-14 11:27:03,021 ERROR ParcelUpdateService:com.cloudera.parcel.components.ParcelDownloaderImpl: Unable to retrieve remote parcel repository manifest
java.util.concurrent.ExecutionException: java.net.ConnectException: Task org.jboss.netty.util.internal.DeadLockProofWorker$1@17010c08 rejected from java.util.concurrent.ThreadPoolExecutor@45bced04[Terminated, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] to https://archive.cloudera.com/cdh5/parcels/5.10/manifest.json
at com.ning.http.client.providers.netty.NettyResponseFuture.abort(NettyResponseFuture.java:297)
at com.ning.http.client.providers.netty.NettyConnectListener.operationComplete(NettyConnectListener.java:104)
at org.jboss.netty.channel.DefaultChannelFuture.notifyListener(DefaultChannelFuture.java:399)
at org.jboss.netty.channel.DefaultChannelFuture.addListener(DefaultChannelFuture.java:145)
at com.ning.http.client.providers.netty.NettyAsyncHttpProvider.doConnect(NettyAsyncHttpProvider.java:1041)
at com.ning.http.client.providers.netty.NettyAsyncHttpProvider.execute(NettyAsyncHttpProvider.java:858)
at com.ning.http.client.AsyncHttpClient.executeRequest(AsyncHttpClient.java:512)
at com.ning.http.client.AsyncHttpClient$BoundRequestBuilder.execute(AsyncHttpClient.java:234)
at com.cloudera.parcel.components.ParcelDownloaderImpl.getRepositoryInfoFuture(ParcelDownloaderImpl.java:534)
at com.cloudera.parcel.components.ParcelDownloaderImpl.getRepositoryInfo(ParcelDownloaderImpl.java:492)
at com.cloudera.parcel.components.ParcelDownloaderImpl.syncRemoteRepos(ParcelDownloaderImpl.java:344)
at com.cloudera.parcel.components.ParcelDownloaderImpl$1.run(ParcelDownloaderImpl.java:416)
at com.cloudera.parcel.components.ParcelDownloaderImpl$1.run(ParcelDownloaderImpl.java:411)
at com.cloudera.cmf.persist.ReadWriteDatabaseTaskCallable.call(ReadWriteDatabaseTaskCallable.java:36)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.net.ConnectException: Task org.jboss.netty.util.internal.DeadLockProofWorker$1@17010c08 rejected from java.util.concurrent.ThreadPoolExecutor@45bced04[Terminated, pool size = 0, active threads = 0, queued tasks = 0, completed tasks = 0] to https://archive.cloudera.com/cdh5/parcels/5.10/manifest.json
at com.ning.http.client.providers.netty.NettyConnectListener.operationComplete(NettyConnectListener.java:100)
... 16 more

 

I checked if repository was available and downloaded files from the repository to /opt/cloudera/parcel-repo and restarted cloudera-scm-server but to no use. Please suggest!

Announcements