Member since 
    
	
		
		
		07-08-2015
	
	
	
	
	
	
	
	
	
	
	
	
	
	
			
      
                2
            
            
                Posts
            
        
                4
            
            
                Kudos Received
            
        
                1
            
            
                Solution
            
        My Accepted Solutions
| Title | Views | Posted | 
|---|---|---|
| 10091 | 07-09-2015 06:08 AM | 
			
    
	
		
		
		07-09-2015
	
		
		06:08 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
	
		4 Kudos
		
	
				
		
	
		
					
							 In case anyone else sees something like this in the future, I resolved this by running the "FLUSH TABLES" command in the MySQL database. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
			
    
	
		
		
		07-08-2015
	
		
		08:17 AM
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		
	
				
		
			
					
				
		
	
		
					
							 I'm trying to install CDH 5.4.2 on CentOS 6.6 using installation path B with external MySQL databases.     The scm_prepare_database script runs successfully without any warnings and the mysql connector jar is in place.     Here is the output from trying to run "service cloudera-scm-server start" for the first time. It looks like something is happening to prevent CM from actually creating the tables it needs. I've used the same database settings numerous times without any issues for past test installs in this environment.     [root@rdl-hadoop01 cloudera-scm-server]# service cloudera-scm-server start  Starting cloudera-scm-server:                              [  OK  ]  [root@rdl-hadoop01 cloudera-scm-server]# service cloudera-scm-server status  cloudera-scm-server dead but pid file exists  [root@rdl-hadoop01 cloudera-scm-server]# cat cloudera-scm-server.log  ...  2015-07-08 10:57:02,870 INFO main:com.cloudera.cmon.TimeSeriesEntityType: Registered TimeSeriesEntityType HBASE_INDEXER  2015-07-08 10:57:02,918 INFO main:org.springframework.context.support.ClassPathXmlApplicationContext: Refreshing org.springframework.context.support.ClassPathXmlApplicationContext@70ad2036: startup date [Wed Jul 08 10:57:02 EDT 2015]; root of context hierarchy  2015-07-08 10:57:02,973 INFO main:org.springframework.beans.factory.xml.XmlBeanDefinitionReader: Loading XML bean definitions from class path resource [webapp/WEB-INF/spring/beanRefFactory.xml]  2015-07-08 10:57:03,131 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3debe8ab: defining beans [bootstrapContext,rootContext]; root of factory hierarchy  2015-07-08 10:57:03,161 INFO main:org.springframework.context.support.GenericApplicationContext: Refreshing org.springframework.context.support.GenericApplicationContext@4ed14172: startup date [Wed Jul 08 10:57:03 EDT 2015]; root of context hierarchy  2015-07-08 10:57:03,164 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3d8dfe67: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy  2015-07-08 10:57:03,253 INFO main:com.cloudera.enterprise.CommonMain: Reading database properties from /etc/cloudera-scm-server/db.properties  2015-07-08 10:57:03,258 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, c3p0 JMX disabled  2015-07-08 10:57:03,428 INFO main:org.hibernate.annotations.common.Version: HCANN000001: Hibernate Commons Annotations {4.0.2.Final}  2015-07-08 10:57:03,434 INFO main:org.hibernate.Version: HHH000412: Hibernate Core {4.2.2.Final}  2015-07-08 10:57:03,437 INFO main:org.hibernate.cfg.Environment: HHH000206: hibernate.properties not found  2015-07-08 10:57:03,438 INFO main:org.hibernate.cfg.Environment: HHH000021: Bytecode provider name : javassist  2015-07-08 10:57:03,887 INFO main:org.hibernate.cfg.Configuration: HHH000221: Reading mappings from resource: cmf.hbm.xml  2015-07-08 10:57:04,178 INFO main:org.hibernate.service.jdbc.connections.internal.ConnectionProviderInitiator: HHH000130: Instantiating explicit connection provider: org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider  2015-07-08 10:57:04,179 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH010002: C3P0 using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://MYSQLHOST:3306/hdp_dev_scm?useUnicode=true&characterEncoding=UTF-8  2015-07-08 10:57:04,179 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000046: Connection properties: {user=hdp_dev_scm, password=****, autocommit=true, release_mode=auto}  2015-07-08 10:57:04,179 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000006: Autocommit mode: true  2015-07-08 10:57:04,207 INFO main:com.mchange.v2.log.MLog: MLog clients using log4j logging.  2015-07-08 10:57:04,333 INFO main:com.mchange.v2.c3p0.C3P0Registry: Initializing c3p0-0.9.1.1 [built 15-March-2007 01:32:31; debug? true; trace: 10]  2015-07-08 10:57:04,384 INFO main:org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider: HHH000149: JDBC isolation level: READ_COMMITTED  2015-07-08 10:57:04,433 INFO main:com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource: Initializing c3p0 pool... com.mchange.v2.c3p0.PoolBackedDataSource@7005751b [ connectionPoolDataSource -> com.mchange.v2.c3p0.WrapperConnectionPoolDataSource@8cefcef1 [ 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 -> 2unnas9aukghyq1khek1k|a80dee3, 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@83e835d5 [ description -> null, driverClass -> null, factoryClassLocation -> null, identityToken -> 2unnas9aukghyq1khek1k|1bf7423c, jdbcUrl -> jdbc:mysql://MYSQLHOST:3306/hdp_dev_scm?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 -> 2unnas9aukghyq1khek1k|41d24c6f, numHelperThreads -> 3 ]  2015-07-08 10:57:04,706 INFO main:org.hibernate.dialect.Dialect: HHH000400: Using dialect: org.hibernate.dialect.MySQL5InnoDBDialect  2015-07-08 10:57:04,716 INFO main:org.hibernate.engine.jdbc.internal.LobCreatorBuilder: HHH000424: Disabling contextual LOB creation as createClob() method threw error : java.lang.reflect.InvocationTargetException  2015-07-08 10:57:04,892 INFO main:org.hibernate.engine.transaction.internal.TransactionFactoryInitiator: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jdbc.JdbcTransactionFactory  2015-07-08 10:57:04,897 INFO main:org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory: HHH000397: Using ASTQueryTranslatorFactory  2015-07-08 10:57:05,033 INFO main:org.hibernate.cache.spi.UpdateTimestampsCache: HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache  2015-07-08 10:57:05,035 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.  2015-07-08 10:57:05,038 INFO main:org.hibernate.cache.internal.StandardQueryCache: HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache  2015-07-08 10:57:05,038 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.  2015-07-08 10:57:05,072 INFO main:org.hibernate.validator.internal.util.Version: HV000001: Hibernate Validator 5.0.1.Final  2015-07-08 10:57:05,769 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHost]; using defaults.  2015-07-08 10:57:05,882 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCredential]; using defaults.  2015-07-08 10:57:05,886 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService]; using defaults.  2015-07-08 10:57:05,924 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRoleConfigGroup]; using defaults.  2015-07-08 10:57:05,932 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCmPeer]; using defaults.  2015-07-08 10:57:05,936 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster]; using defaults.  2015-07-08 10:57:05,945 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfigContainer]; using defaults.  2015-07-08 10:57:05,966 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHostTemplate]; using defaults.  2015-07-08 10:57:05,973 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbClientConfig]; using defaults.  2015-07-08 10:57:05,981 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUser]; using defaults.  2015-07-08 10:57:05,986 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbGlobalSetting]; using defaults.  2015-07-08 10:57:05,989 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRevision]; using defaults.  2015-07-08 10:57:05,994 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUserSetting]; using defaults.  2015-07-08 10:57:05,998 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCommandSchedule]; using defaults.  2015-07-08 10:57:06,013 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbProcess]; using defaults.  2015-07-08 10:57:06,195 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRoleStalenessStatus]; using defaults.  2015-07-08 10:57:06,199 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbUserRole]; using defaults.  2015-07-08 10:57:06,202 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbParcel]; using defaults.  2015-07-08 10:57:06,210 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRole]; using defaults.  2015-07-08 10:57:06,218 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRelease]; using defaults.  2015-07-08 10:57:06,222 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfig]; using defaults.  2015-07-08 10:57:06,269 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService.configsForDb]; using defaults.  2015-07-08 10:57:06,271 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster.activatedReleases]; using defaults.  2015-07-08 10:57:06,274 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHostTemplate.roleConfigGroups]; using defaults.  2015-07-08 10:57:06,275 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbRoleConfigGroup.roles]; using defaults.  2015-07-08 10:57:06,276 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbHost.roles]; using defaults.  2015-07-08 10:57:06,276 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbService.roleConfigGroups]; using defaults.  2015-07-08 10:57:06,277 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbConfigContainer.configsForDb]; using defaults.  2015-07-08 10:57:06,278 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbProcess.parcels]; using defaults.  2015-07-08 10:57:06,279 WARN main:org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory: HHH020003: Could not find a specific ehcache configuration for cache named [com.cloudera.cmf.model.DbCluster.hostTemplates]; using defaults.  2015-07-08 10:57:06,983 INFO main:com.cloudera.enterprise.CommonMain: Statistics not enabled, JMX will not be registered  2015-07-08 10:57:07,121 INFO main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: MYSQL database engine and table mapping: {}  2015-07-08 10:57:07,139 WARN main:org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 1146, SQLState: 42S02  2015-07-08 10:57:07,139 ERROR main:org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Table 'hdp_dev_scm.cm_version' doesn't exist  2015-07-08 10:57:07,141 WARN main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Failed to determine prior version, assuming no upgrade: org.hibernate.exception.SQLGrammarException: could not extract ResultSet  2015-07-08 10:57:07,149 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table already exists.  2015-07-08 10:57:07,151 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3d8dfe67: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy  2015-07-08 10:57:07,152 ERROR main:com.cloudera.server.cmf.Main: 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 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hdp_dev_scm.schema_version' doesn't exist  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:344)  at com.cloudera.server.cmf.Main.<init>(Main.java:220)  at com.cloudera.server.cmf.Main.main(Main.java:194)  Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hdp_dev_scm.schema_version' doesn't exist  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: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hdp_dev_scm.schema_version' doesn't exist  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)  at java.lang.reflect.Constructor.newInstance(Constructor.java:526)  at com.mysql.jdbc.Util.handleNewInstance(Util.java:389)  at com.mysql.jdbc.Util.getInstance(Util.java:372)  at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:980)  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2531)  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2489)  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)  at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)  at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)  at com.cloudera.enterprise.dbutil.DbUtil.getSchemaVersion(DbUtil.java:231)  at com.cloudera.enterprise.dbutil.DbUtil$1SchemaVersionWork.execute(DbUtil.java:178)  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:190)  at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkVersionDoFail(EntityManagerFactoryBean.java:258)  at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:120)  at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:60)  at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)  ... 22 more  [root@rdl-hadoop01 cloudera-scm-server]#     One odd thing is that the log output shows that it can't find tables only to say the table already exists a few lines later. This is being done on a freshly installed OS with wiped drives and the database was dropped/recreated for this install.     ...  2015-07-08 10:57:07,139 ERROR main:org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Table 'hdp_dev_scm.cm_version' doesn't exist  2015-07-08 10:57:07,141 WARN main:com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean: Failed to determine prior version, assuming no upgrade: org.hibernate.exception.SQLGrammarException: could not extract ResultSet  2015-07-08 10:57:07,149 INFO main:com.cloudera.enterprise.dbutil.DbUtil: Schema version table already exists.  2015-07-08 10:57:07,151 INFO main:org.springframework.beans.factory.support.DefaultListableBeanFactory: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@3d8dfe67: defining beans [commandLineConfigurationBean,entityManagerFactoryBean,com.cloudera.server.cmf.TrialState,com.cloudera.server.cmf.TrialManager,com.cloudera.cmf.crypto.LicenseLoader]; root of factory hierarchy  2015-07-08 10:57:07,152 ERROR main:com.cloudera.server.cmf.Main: 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 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'hdp_dev_scm.schema_version' doesn't exist  ...     Based on past log output, it seems like this is the step where it should start applying the ddl files to create everything needed in the database. 
						
					
					... View more
				
			
			
			
			
			
			
			
			
			
		
		
			
				
						
							Labels:
						
						
		
	
					
			
		
	
	
	
	
				
		
	
	
 
        


