Reply
Explorer
Posts: 9
Registered: ‎09-28-2014

Error starting cloudera-scm-server

Hi, I am building a 10 node development cluster with Cm and Mysql as the database.

The Server is failing when trying to start. Kindly let me know what the issue could be.

 

Below is the error log:

 

 

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows.
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)
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)
... 17 more
Caused by: java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows.
at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:232)
at com.cloudera.enterprise.dbutil.DbUtil$1SchemaVersionWork.execute(DbUtil.java:171)
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)
at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1982)
at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1979)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:284)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2000)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1986)
at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:183)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkVersionDoFail(EntityManagerFactoryBean.java:158)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:104)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:50)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 22 more
2014-09-28 16:41:00,319 INFO [main:mortbay.log@67] Logging to org.slf4j.impl.Log4jLoggerAdapter(org.mortbay.log) via org.mortbay.log.Slf4jLog
2014-09-28 16:41:00,321 INFO [main:mortbay.log@67] Registered SubjectType HDFS
2014-09-28 16:41:00,326 INFO [main:mortbay.log@67] Registered SubjectType HDFS-NAMENODE
2014-09-28 16:41:00,329 INFO [main:mortbay.log@67] Registered SubjectType HDFS-DATANODE
2014-09-28 16:41:00,329 INFO [main:mortbay.log@67] Registered SubjectType HDFS-SECONDARYNAMENODE
2014-09-28 16:41:00,330 INFO [main:mortbay.log@67] Registered SubjectType HDFS-JOURNALNODE
2014-09-28 16:41:00,330 INFO [main:mortbay.log@67] Registered SubjectType HDFS-HTTPFS
2014-09-28 16:41:00,330 INFO [main:mortbay.log@67] Registered SubjectType HDFS-FAILOVERCONTROLLER
2014-09-28 16:41:00,331 INFO [main:mortbay.log@67] Registered SubjectType HDFS-NFSGATEWAY
2014-09-28 16:41:00,331 INFO [main:mortbay.log@67] Registered SubjectType HBASE
2014-09-28 16:41:00,331 INFO [main:mortbay.log@67] Registered SubjectType HBASE-MASTER
2014-09-28 16:41:00,332 INFO [main:mortbay.log@67] Registered SubjectType HBASE-REGIONSERVER
2014-09-28 16:41:00,332 INFO [main:mortbay.log@67] Registered SubjectType HBASE-HBASETHRIFTSERVER
2014-09-28 16:41:00,332 INFO [main:mortbay.log@67] Registered SubjectType HBASE-HBASERESTSERVER
2014-09-28 16:41:00,333 INFO [main:mortbay.log@67] Registered SubjectType MAPREDUCE
2014-09-28 16:41:00,333 INFO [main:mortbay.log@67] Registered SubjectType MAPREDUCE-JOBTRACKER
2014-09-28 16:41:00,335 INFO [main:mortbay.log@67] Registered SubjectType MAPREDUCE-TASKTRACKER
2014-09-28 16:41:00,336 INFO [main:mortbay.log@67] Registered SubjectType MAPREDUCE-FAILOVERCONTROLLER
2014-09-28 16:41:00,337 INFO [main:mortbay.log@67] Registered SubjectType MGMT
2014-09-28 16:41:00,337 INFO [main:mortbay.log@67] Registered SubjectType MGMT-ACTIVITYMONITOR
2014-09-28 16:41:00,337 INFO [main:mortbay.log@67] Registered SubjectType MGMT-SERVICEMONITOR
2014-09-28 16:41:00,338 INFO [main:mortbay.log@67] Registered SubjectType MGMT-HOSTMONITOR
2014-09-28 16:41:00,338 INFO [main:mortbay.log@67] Registered SubjectType MGMT-EVENTSERVER
2014-09-28 16:41:00,339 INFO [main:mortbay.log@67] Registered SubjectType MGMT-ALERTPUBLISHER
2014-09-28 16:41:00,339 INFO [main:mortbay.log@67] Registered SubjectType MGMT-REPORTSMANAGER
2014-09-28 16:41:00,339 INFO [main:mortbay.log@67] Registered SubjectType MGMT-NAVIGATOR
2014-09-28 16:41:00,340 INFO [main:mortbay.log@67] Registered SubjectType MGMT-NAVIGATORMETASERVER
2014-09-28 16:41:00,340 INFO [main:mortbay.log@67] Registered SubjectType HOST
2014-09-28 16:41:00,340 INFO [main:mortbay.log@67] Registered SubjectType ZOOKEEPER
2014-09-28 16:41:00,340 INFO [main:mortbay.log@67] Registered SubjectType ZOOKEEPER-SERVER
2014-09-28 16:41:00,340 INFO [main:mortbay.log@67] Registered SubjectType FLUME
2014-09-28 16:41:00,341 INFO [main:mortbay.log@67] Registered SubjectType FLUME-AGENT
2014-09-28 16:41:00,341 INFO [main:mortbay.log@67] Registered SubjectType IMPALA
2014-09-28 16:41:00,341 INFO [main:mortbay.log@67] Registered SubjectType IMPALA-IMPALAD
2014-09-28 16:41:00,342 INFO [main:mortbay.log@67] Registered SubjectType IMPALA-STATESTORE
2014-09-28 16:41:00,342 INFO [main:mortbay.log@67] Registered SubjectType IMPALA-CATALOGSERVER
2014-09-28 16:41:00,342 INFO [main:mortbay.log@67] Registered SubjectType IMPALA-LLAMA
2014-09-28 16:41:00,342 INFO [main:mortbay.log@67] Registered SubjectType YARN
2014-09-28 16:41:00,343 INFO [main:mortbay.log@67] Registered SubjectType YARN-RESOURCEMANAGER
2014-09-28 16:41:00,343 INFO [main:mortbay.log@67] Registered SubjectType YARN-NODEMANAGER
2014-09-28 16:41:00,344 INFO [main:mortbay.log@67] Registered SubjectType YARN-JOBHISTORY
2014-09-28 16:41:00,344 INFO [main:mortbay.log@67] Registered SubjectType OOZIE
2014-09-28 16:41:00,344 INFO [main:mortbay.log@67] Registered SubjectType OOZIE-OOZIE_SERVER
2014-09-28 16:41:00,344 INFO [main:mortbay.log@67] Registered SubjectType HIVE
2014-09-28 16:41:00,345 INFO [main:mortbay.log@67] Registered SubjectType HIVE-HIVEMETASTORE
2014-09-28 16:41:00,345 INFO [main:mortbay.log@67] Registered SubjectType HIVE-WEBHCAT
2014-09-28 16:41:00,345 INFO [main:mortbay.log@67] Registered SubjectType HIVE-HIVESERVER2
2014-09-28 16:41:00,346 INFO [main:mortbay.log@67] Registered SubjectType HUE
2014-09-28 16:41:00,346 INFO [main:mortbay.log@67] Registered SubjectType HUE-HUE_SERVER
2014-09-28 16:41:00,346 INFO [main:mortbay.log@67] Registered SubjectType HUE-BEESWAX_SERVER
2014-09-28 16:41:00,347 INFO [main:mortbay.log@67] Registered SubjectType HUE-KT_RENEWER
2014-09-28 16:41:00,347 INFO [main:mortbay.log@67] Registered SubjectType SENTRY
2014-09-28 16:41:00,347 INFO [main:mortbay.log@67] Registered SubjectType SENTRY-SENTRY_SERVER
2014-09-28 16:41:00,347 INFO [main:mortbay.log@67] Registered SubjectType SQOOP
2014-09-28 16:41:00,348 INFO [main:mortbay.log@67] Registered SubjectType SQOOP-SQOOP_SERVER
2014-09-28 16:41:00,348 INFO [main:mortbay.log@67] Registered SubjectType SOLR
2014-09-28 16:41:00,348 INFO [main:mortbay.log@67] Registered SubjectType SOLR-SOLR_SERVER
2014-09-28 16:41:00,348 INFO [main:mortbay.log@67] Registered SubjectType KS_INDEXER
2014-09-28 16:41:00,349 INFO [main:mortbay.log@67] Registered SubjectType KS_INDEXER-HBASE_INDEXER
2014-09-28 16:41:00,409 INFO [main:support.ClassPathXmlApplicationContext@456] Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@7bfbfeae: startup date [Sun Sep 28 16:41:00 EDT 2014]; root of context hierarchy
2014-09-28 16:41:00,476 INFO [main:xml.XmlBeanDefinitionReader@315] Loading XML bean definitions from class path resource [webapp/WEB-INF/spring/beanRefFactory.xml]
2014-09-28 16:41:00,646 INFO [main:support.DefaultListableBeanFactory@557] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@30a491e9: defining beans [bootstrapContext,rootContext]; root of factory hierarchy
2014-09-28 16:41:00,681 INFO [main:support.GenericApplicationContext@456] Refreshing org.springframework.context.support.GenericApplicationContext@7525c6bd: startup date [Sun Sep 28 16:41:00 EDT 2014]; root of context hierarchy
2014-09-28 16:41:00,683 INFO [main:support.DefaultListableBeanFactory@557] Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@715dcdeb: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy
2014-09-28 16:41:00,792 INFO [main:enterprise.CommonMain@105] Reading database properties from /etc/cloudera-scm-server/db.properties
2014-09-28 16:41:00,797 INFO [main:enterprise.CommonMain@166] Statistics not enabled, c3p0 JMX disabled
2014-09-28 16:41:00,982 INFO [main:common.Version@37] HCANN000001: Hibernate Commons Annotations {4.0.2.Final}
2014-09-28 16:41:00,990 INFO [main:hibernate.Version@41] HHH000412: Hibernate Core {4.2.2.Final}
2014-09-28 16:41:00,993 INFO [main:cfg.Environment@239] HHH000206: hibernate.properties not found
2014-09-28 16:41:00,994 INFO [main:cfg.Environment@342] HHH000021: Bytecode provider name : javassist
2014-09-28 16:41:01,377 INFO [main:cfg.Configuration@728] HHH000221: Reading mappings from resource: cmf.hbm.xml
2014-09-28 16:41:01,670 INFO [main:internal.ConnectionProviderInitiator@188] HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider
2014-09-28 16:41:01,671 INFO [main:internal.C3P0ConnectionProvider@128] HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/cman?useUnicode=true&characterEncoding=UTF-8
2014-09-28 16:41:01,672 INFO [main:internal.C3P0ConnectionProvider@129] HHH000046: Connection properties: {user=cman, password=****, autocommit=true, release_mode=auto}
2014-09-28 16:41:01,672 INFO [main:internal.C3P0ConnectionProvider@132] HHH000006: Autocommit mode: true
2014-09-28 16:41:01,750 INFO [main:log.MLog@80] MLog clients using log4j logging.
2014-09-28 16:41:01,875 INFO [main:c3p0.C3P0Registry@204] Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10]
2014-09-28 16:41:01,929 INFO [main:internal.C3P0ConnectionProvider@214] HHH000149: JDBC isolation level: READ_COMMITTED
2014-09-28 16:41:01,975 INFO [main:impl.AbstractPoolBackedDataSource@462] Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@85183d77 [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@21731cbd [ acquireIncrement -> 3, acquireRetryAttempts -> 5, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, debugUnreturnedConnectionStackTraces -> false, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1br1c1q941gpt36p1o3apug|6b0f6d29, idleConnectionTestPeriod -> 300, initialPoolSize -> 3, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 50, maxStatements -> 2500, maxStatementsPerConnection -> 0, minPoolSize -> 5, nestedDataSource -> com.mchange.v2.c3p0.DriverManagerDataSource@8da4ce69 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 1br1c1q941gpt36p1o3apug|21ab613c, jdbcUrl -> jdbc:mysql://localhost/cman?useUnicode=true&characterEncoding=UTF-8, properties -> {user=******, password=******, autocommit=true, release_mode=auto} ], preferredTestQuery -> null, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false; userOverrides: {} ], dataSourceName -> null, factoryClassLocation -> null, identityToken -> 1br1c1q941gpt36p1o3apug|4d338bcf, numHelperThreads -> 3 ]
2014-09-28 16:41:02,189 INFO [main:dialect.Dialect@130] HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect
2014-09-28 16:41:02,199 INFO [main:internal.LobCreatorBuilder@120] HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException
2014-09-28 16:41:02,350 INFO [main:internal.TransactionFactoryInitiator@73] HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory
2014-09-28 16:41:02,355 INFO [main:ast.ASTQueryTranslatorFactory@48] HHH000397: Using ASTQueryTranslatorFactory
2014-09-28 16:41:02,480 INFO [main:spi.UpdateTimestampsCache@61] HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2014-09-28 16:41:02,483 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2014-09-28 16:41:02,485 INFO [main:internal.StandardQueryCache@86] HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2014-09-28 16:41:02,486 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2014-09-28 16:41:02,516 INFO [main:util.Version@27] HV000001: Hibernate Validator 5.0.1.Final
2014-09-28 16:41:03,189 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHost]; using defaults.
2014-09-28 16:41:03,308 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCredential]; using defaults.
2014-09-28 16:41:03,312 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService]; using defaults.
2014-09-28 16:41:03,351 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRoleConfigGroup]; using defaults.
2014-09-28 16:41:03,359 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCmPeer]; using defaults.
2014-09-28 16:41:03,363 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster]; using defaults.
2014-09-28 16:41:03,371 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfigContainer]; using defaults.
2014-09-28 16:41:03,393 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHostTemplate]; using defaults.
2014-09-28 16:41:03,401 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbClientConfig]; using defaults.
2014-09-28 16:41:03,408 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUser]; using defaults.
2014-09-28 16:41:03,413 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbGlobalSetting]; using defaults.
2014-09-28 16:41:03,416 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRevision]; using defaults.
2014-09-28 16:41:03,421 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUserSetting]; using defaults.
2014-09-28 16:41:03,425 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCommandSchedule]; using defaults.
2014-09-28 16:41:03,441 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbProcess]; using defaults.
2014-09-28 16:41:03,621 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUserRole]; using defaults.
2014-09-28 16:41:03,624 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbParcel]; using defaults.
2014-09-28 16:41:03,632 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRole]; using defaults.
2014-09-28 16:41:03,641 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRelease]; using defaults.
2014-09-28 16:41:03,646 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfig]; using defaults.
2014-09-28 16:41:03,692 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService.configsForDb]; using defaults.
2014-09-28 16:41:03,695 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster.activatedReleases]; using defaults.
2014-09-28 16:41:03,698 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHostTemplate.roleConfigGroups]; using defaults.
2014-09-28 16:41:03,699 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRoleConfigGroup.roles]; using defaults.
2014-09-28 16:41:03,700 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHost.roles]; using defaults.
2014-09-28 16:41:03,701 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService.roleConfigGroups]; using defaults.
2014-09-28 16:41:03,702 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfigContainer.configsForDb]; using defaults.
2014-09-28 16:41:03,703 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbProcess.parcels]; using defaults.
2014-09-28 16:41:03,703 WARN [main:ehcache.AbstractEhcacheRegionFactory@180] HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster.hostTemplates]; using defaults.
2014-09-28 16:41:04,422 INFO [main:enterprise.CommonMain@261] Statistics not enabled, JMX will not be registered
2014-09-28 16:41:04,543 INFO [main:bootstrap.EntityManagerFactoryBean@135] MYSQL database engine and table mapping: {InnoDB=[SCHEMA_VERSION]}
2014-09-28 16:41:04,551 INFO [main:dbutil.DbUtil@219] Schema version table already exists.
2014-09-28 16:41:04,552 ERROR [main:dbutil.DbUtil@231] Schema version table SCHEMA_VERSION exists but contains no rows.
2014-09-28 16:41:04,553 INFO [main:support.DefaultListableBeanFactory@422] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@715dcdeb: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy
2014-09-28 16:41:04,553 ERROR [main:cmf.Main@204] Server failed.
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.cloudera.server.cmf.TrialState': Cannot resolve reference to bean 'entityManagerFactoryBean' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows.
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
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:362)
at com.cloudera.server.cmf.Main.<init>(Main.java:216)
at com.cloudera.server.cmf.Main.main(Main.java:199)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows.
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)
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)
... 17 more
Caused by: java.sql.SQLException: Schema version table SCHEMA_VERSION exists but contains no rows.
at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:232)
at com.cloudera.enterprise.dbutil.DbUtil$1SchemaVersionWork.execute(DbUtil.java:171)
at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:54)
at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1982)
at org.hibernate.internal.SessionImpl$2.accept(SessionImpl.java:1979)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:284)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:2000)
at org.hibernate.internal.SessionImpl.doWork(SessionImpl.java:1986)
at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:183)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkVersionDoFail(EntityManagerFactoryBean.java:158)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:104)
at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:50)
at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)
... 22 more

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Error starting cloudera-scm-server

Did you install the new version of mysql ?

And did you have the following configuration settings

[mysqld]
transaction-isolation=READ-COMMITTED
# Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
# symbolic-links=0

key_buffer = 16M
key_buffer_size = 32M
max_allowed_packet = 16M
thread_stack = 256K
thread_cache_size = 64
query_cache_limit = 8M
query_cache_size = 64M
query_cache_type = 1
# Important: see Configuring the Databases and Setting max_connections
max_connections = 550

# log-bin should be on a disk with enough free space
log-bin=/x/home/mysql/logs/binary/mysql_binary_log

# For MySQL version 5.1.8 or later. Comment out binlog_format for older versions.
binlog_format = mixed

read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M

# InnoDB settings
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 64M
innodb_buffer_pool_size = 4G
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT
innodb_log_file_size = 512M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

in /etc/my.cnf or /etc/mysql/my.cnf file ?
Em Jay
Highlighted
Explorer
Posts: 9
Registered: ‎09-28-2014

Re: Error starting cloudera-scm-server

Hey Mani,

I have created this in /etc/my.cnf

The Mysql Server version: 5.1.73-log Source distribution

 

my.cnf file:

 

[mysqld]
transaction-isolation=READ-COMMITTED

#Disabling symbolic-links is recommended to prevent assorted security risks;
# to do so, uncomment this line:
#symbolic-links=0

key_buffer = 16M
key_buffer_size = 32M
max_allowed_packet = 32M
thread_stack = 256K
thread_cache_size = 64
query_cache_limit = 8M
query_cache_size = 64M
query_cache_type = 1

max_connections = 550

# log_bin should be on a disk with enough free space
# NOTE: replace '/x/home/mysql/logs/binary' below with
# an appropriate path for your system.
log_bin=/data/app02/mysql/logs/binary/mysql_binary_log

# For MySQL version 5.1.8 or later. Comment out binlog_format for older versions.
binlog_format = mixed

read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M

# InnoDB settings
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 64M
innodb_buffer_pool_size = 4G
innodb_thread_concurrency = 8
innodb_flush_method = O_DIRECT
innodb_log_file_size = 512M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Error starting cloudera-scm-server

Did you create the following schema ?

mysql> create database amon DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on amon.* TO 'amon'@'%' IDENTIFIED BY 'amon_password';
Query OK, 0 rows affected (0.00 sec)

Create a database for the Service Monitor. For example:

mysql> create database smon DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on smon.* TO 'smon'@'%' IDENTIFIED BY 'smon_password';
Query OK, 0 rows affected (0.00 sec)

Create a database for the Report Manager. For example:

mysql> create database rman DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on rman.* TO 'rman'@'%' IDENTIFIED BY 'rman_password';
Query OK, 0 rows affected (0.00 sec)

Create a database for the Host Monitor. For example:

mysql> create database hmon DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on hmon.* TO 'hmon'@'%' IDENTIFIED BY 'hmon_password';
Query OK, 0 rows affected (0.00 sec)

(Optional) Create a database for Cloudera Navigator. For example:

mysql> create database nav DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on nav.* TO 'nav'@'%' IDENTIFIED BY 'nav_password';
Query OK, 0 rows affected (0.00 sec)

Create the Database for the Hive Metastore and Impala Catalog Daemon
Create a separate metastore for each Hive service, if you have more than one.

Create a database for the Hive metastore. For example:

mysql> create database hive DEFAULT CHARACTER SET utf8;
Query OK, 1 row affected (0.00 sec)

mysql> grant all on hive.* TO 'hive'@'%' IDENTIFIED BY 'hive_password';
Query OK, 0 rows affected (0.00 sec)

Em Jay
Explorer
Posts: 9
Registered: ‎09-28-2014

Re: Error starting cloudera-scm-server

Yes Em Jay,

 

I have done and I verified all those from the Show tables; as well.

Are you from Cloudwick by any chance ? :)

 

-Akhil

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Error starting cloudera-scm-server

Yes I am from Cloudwick.

For some reason the cloudera manager service is not able to write anything to mysql database tables, that's what I can think looking at your error...

Can you check and see if the directory permissions for that database filesystem been changed ? Or can you try to provide grants on the tables one more time and flush privileges...

I can only think and say this is because of the write issue...

Thanks
Em Jay
Explorer
Posts: 9
Registered: ‎09-28-2014

Re: Error starting cloudera-scm-server

Cool :) Even I am from cloudwick.

 

I did a workaround by following the auromation method and then selecting the Mysql database and its working fine now. Do you think that would suffice ?

 

 

Expert Contributor
Posts: 126
Registered: ‎11-01-2013

Re: Error starting cloudera-scm-server

yea you might have missed something earlier...

Either ways you can do it, you can do it thru CM interface using the embedded DB or you can setup the database and schema and specify the usernames passwords it in CM configuration later...you need to configure tables and access rights properly before a automated service or a user access it !

Thanks
Em Jay
Explorer
Posts: 9
Registered: ‎09-28-2014

Re: Error starting cloudera-scm-server

I have done it twice and was left with the same issue Em Jay. 

Yes I have followed up the process as you have rightly mentioned. Thank you so much for the response. 

 

Regards,

Akhil