Reply
New Contributor
Posts: 2
Registered: ‎07-08-2015
Accepted Solution

MySQL errors on initial cloudera-scm-server start

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.

New Contributor
Posts: 2
Registered: ‎07-08-2015

Re: MySQL errors on initial cloudera-scm-server start

In case anyone else sees something like this in the future, I resolved this by running the "FLUSH TABLES" command in the MySQL database.

Highlighted
Explorer
Posts: 10
Registered: ‎09-25-2017

Re: MySQL errors on initial cloudera-scm-server start

This did not solve my same issue!
Announcements