-
CDH断电后cloudera-scm-server启动报错
报错背景：
CDH未关闭的情况下，Linux断电，导致cloudera-scm-server无法启动。报错现象：
输入启动命令之后：/opt/cm-5.15.1/etc/init.d/cloudera-scm-server start，cloudera-scm-server 会启动，但是几秒中之后就会死掉，显示：cloudera-scm-server 已死，但 pid 文件存在。
于是查看日志文件：vim /opt/cm-5.15.1/log/cloudera-scm-server/cloudera-scm-server.log，
复制代码
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 javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection
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. g e t O b j e c t ( A b s t r a c t B e a n F a c t o r y . j a v a : 293 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . D e f a u l t S i n g l e t o n B e a n R e g i s t r y . g e t S i n g l e t o n ( D e f a u l t S i n g l e t o n B e a n R e g i s t r y . j a v a : 222 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . d o G e t B e a n ( A b s t r a c t B e a n F a c t o r y . j a v a : 290 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . g e t B e a n ( A b s t r a c t B e a n F a c t o r y . j a v a : 192 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . D e f a u l t L i s t a b l e B e a n F a c t o r y . p r e I n s t a n t i a t e S i n g l e t o n s ( D e f a u l t L i s t a b l e B e a n F a c t o r y . j a v a : 585 ) a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . s u p p o r t . A b s t r a c t A p p l i c a t i o n C o n t e x t . f i n i s h B e a n F a c t o r y I n i t i a l i z a t i o n ( A b s t r a c t A p p l i c a t i o n C o n t e x t . j a v a : 895 ) a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . s u p p o r t . A b s t r a c t A p p l i c a t i o n C o n t e x t . r e f r e s h ( A b s t r a c t A p p l i c a t i o n C o n t e x t . j a v a : 425 ) a t c o m . c l o u d e r a . s e r v e r . c m f . M a i n . b o o t s t r a p S p r i n g C o n t e x t ( M a i n . j a v a : 393 ) a t c o m . c l o u d e r a . s e r v e r . c m f . M a i n . < i n i t > ( M a i n . j a v a : 243 ) a t c o m . c l o u d e r a . s e r v e r . c m f . M a i n . m a i n ( M a i n . j a v a : 216 ) C a u s e d b y : o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . B e a n C r e a t i o n E x c e p t i o n : E r r o r c r e a t i n g b e a n w i t h n a m e ′ e n t i t y M a n a g e r F a c t o r y B e a n ′ : F a c t o r y B e a n t h r e w e x c e p t i o n o n o b j e c t c r e a t i o n ; n e s t e d e x c e p t i o n i s j a v a x . p e r s i s t e n c e . P e r s i s t e n c e E x c e p t i o n : o r g . h i b e r n a t e . e x c e p t i o n . G e n e r i c J D B C E x c e p t i o n : C o u l d n o t o p e n c o n n e c t i o n a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . F a c t o r y B e a n R e g i s t r y S u p p o r t . d o G e t O b j e c t F r o m F a c t o r y B e a n ( F a c t o r y B e a n R e g i s t r y S u p p o r t . j a v a : 149 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . F a c t o r y B e a n R e g i s t r y S u p p o r t . g e t O b j e c t F r o m F a c t o r y B e a n ( F a c t o r y B e a n R e g i s t r y S u p p o r t . j a v a : 102 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . g e t O b j e c t F o r B e a n I n s t a n c e ( A b s t r a c t B e a n F a c t o r y . j a v a : 1440 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . d o G e t B e a n ( A b s t r a c t B e a n F a c t o r y . j a v a : 247 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . g e t B e a n ( A b s t r a c t B e a n F a c t o r y . j a v a : 192 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . B e a n D e f i n i t i o n V a l u e R e s o l v e r . r e s o l v e R e f e r e n c e ( B e a n D e f i n i t i o n V a l u e R e s o l v e r . j a v a : 322 ) . . . 17 m o r e C a u s e d b y : j a v a x . p e r s i s t e n c e . P e r s i s t e n c e E x c e p t i o n : o r g . h i b e r n a t e . e x c e p t i o n . G e n e r i c J D B C E x c e p t i o n : C o u l d n o t o p e n c o n n e c t i o n a t o r g . h i b e r n a t e . e j b . A b s t r a c t E n t i t y M a n a g e r I m p l . c o n v e r t ( A b s t r a c t E n t i t y M a n a g e r I m p l . j a v a : 1387 ) a t o r g . h i b e r n a t e . e j b . A b s t r a c t E n t i t y M a n a g e r I m p l . c o n v e r t ( A b s t r a c t E n t i t y M a n a g e r I m p l . j a v a : 1310 ) a t o r g . h i b e r n a t e . e j b . A b s t r a c t E n t i t y M a n a g e r I m p l . t h r o w P e r s i s t e n c e E x c e p t i o n ( A b s t r a c t E n t i t y M a n a g e r I m p l . j a v a : 1397 ) a t o r g . h i b e r n a t e . e j b . T r a n s a c t i o n I m p l . b e g i n ( T r a n s a c t i o n I m p l . j a v a : 62 ) a t c o m . c l o u d e r a . e n t e r p r i s e . A b s t r a c t W r a p p e d E n t i t y M a n a g e r . b e g i n F o r R o l l b a c k A n d R e a d o n l y ( A b s t r a c t W r a p p e d E n t i t y M a n a g e r . j a v a : 89 ) a t c o m . c l o u d e r a . e n t e r p r i s e . d b u t i l . D b U t i l . i s I n n o D b E n a b l e d ( D b U t i l . j a v a : 554 ) a t c o m . c l o u d e r a . s e r v e r . c m f . b o o t s t r a p . E n t i t y M a n a g e r F a c t o r y B e a n . c h e c k M y s q l T a b l e E n g i n e T y p e ( E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 139 ) a t c o m . c l o u d e r a . s e r v e r . c m f . b o o t s t r a p . E n t i t y M a n a g e r F a c t o r y B e a n . g e t O b j e c t ( E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 122 ) a t c o m . c l o u d e r a . s e r v e r . c m f . b o o t s t r a p . E n t i t y M a n a g e r F a c t o r y B e a n . g e t O b j e c t ( E n t i t y M a n a g e r F a c t o r y B e a n . j a v a : 65 ) a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . F a c t o r y B e a n R e g i s t r y S u p p o r t . d o G e t O b j e c t F r o m F a c t o r y B e a n ( F a c t o r y B e a n R e g i s t r y S u p p o r t . j a v a : 142 ) . . . 22 m o r e C a u s e d b y : o r g . h i b e r n a t e . e x c e p t i o n . G e n e r i c J D B C E x c e p t i o n : C o u l d n o t o p e n c o n n e c t i o n a t o r g . h i b e r n a t e . e x c e p t i o n . i n t e r n a l . S t a n d a r d S Q L E x c e p t i o n C o n v e r t e r . c o n v e r t ( S t a n d a r d S Q L E x c e p t i o n C o n v e r t e r . j a v a : 54 ) a t o r g . h i b e r n a t e . e n g i n e . j d b c . s p i . S q l E x c e p t i o n H e l p e r . c o n v e r t ( S q l E x c e p t i o n H e l p e r . j a v a : 125 ) a t o r g . h i b e r n a t e . e n g i n e . j d b c . s p i . S q l E x c e p t i o n H e l p e r . c o n v e r t ( S q l E x c e p t i o n H e l p e r . j a v a : 110 ) a t o r g . h i b e r n a t e . e n g i n e . j d b c . i n t e r n a l . L o g i c a l C o n n e c t i o n I m p l . o b t a i n C o n n e c t i o n ( L o g i c a l C o n n e c t i o n I m p l . j a v a : 221 ) a t o r g . h i b e r n a t e . e n g i n e . j d b c . i n t e r n a l . L o g i c a l C o n n e c t i o n I m p l . g e t C o n n e c t i o n ( L o g i c a l C o n n e c t i o n I m p l . j a v a : 157 ) a t o r g . h i b e r n a t e . e n g i n e . t r a n s a c t i o n . i n t e r n a l . j d b c . J d b c T r a n s a c t i o n . d o B e g i n ( J d b c T r a n s a c t i o n . j a v a : 67 ) a t o r g . h i b e r n a t e . e n g i n e . t r a n s a c t i o n . s p i . A b s t r a c t T r a n s a c t i o n I m p l . b e g i n ( A b s t r a c t T r a n s a c t i o n I m p l . j a v a : 160 ) a t o r g . h i b e r n a t e . i n t e r n a l . S e s s i o n I m p l . b e g i n T r a n s a c t i o n ( S e s s i o n I m p l . j a v a : 1426 ) a t o r g . h i b e r n a t e . e j b . T r a n s a c t i o n I m p l . b e g i n ( T r a n s a c t i o n I m p l . j a v a : 59 ) . . . 28 m o r e C a u s e d b y : j a v a . s q l . S Q L E x c e p t i o n : C o n n e c t i o n s c o u l d n o t b e a c q u i r e d f r o m t h e u n d e r l y i n g d a t a b a s e ! a t c o m . m c h a n g e . v 2. s q l . S q l U t i l s . t o S Q L E x c e p t i o n ( S q l U t i l s . j a v a : 118 ) a t c o m . m c h a n g e . v 2. c 3 p 0. i m p l . C 3 P 0 P o o l e d C o n n e c t i o n P o o l . c h e c k o u t P o o l e d C o n n e c t i o n ( C 3 P 0 P o o l e d C o n n e c t i o n P o o l . j a v a : 692 ) a t c o m . m c h a n g e . v 2. c 3 p 0. i m p l . A b s t r a c t P o o l B a c k e d D a t a S o u r c e . g e t C o n n e c t i o n ( A b s t r a c t P o o l B a c k e d D a t a S o u r c e . j a v a : 140 ) a t o r g . h i b e r n a t e . s e r v i c e . j d b c . c o n n e c t i o n s . i n t e r n a l . C 3 P 0 C o n n e c t i o n P r o v i d e r . g e t C o n n e c t i o n ( C 3 P 0 C o n n e c t i o n P r o v i d e r . j a v a : 84 ) a t o r g . h i b e r n a t e . i n t e r n a l . A b s t r a c t S e s s i o n I m p l 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:393) at com.cloudera.server.cmf.Main.(Main.java:243) at com.cloudera.server.cmf.Main.main(Main.java:216) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactoryBean': FactoryBean threw exception on object creation; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection 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: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62) at com.cloudera.enterprise.AbstractWrappedEntityManager.beginForRollbackAndReadonly(AbstractWrappedEntityManager.java:89) at com.cloudera.enterprise.dbutil.DbUtil.isInnoDbEnabled(DbUtil.java:554) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkMysqlTableEngineType(EntityManagerFactoryBean.java:139) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:122) at com.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142) ... 22 more Caused by: org.hibernate.exception.GenericJDBCException: Could not open connection at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221) at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157) at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67) at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160) at org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426) at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59) ... 28 more Caused by: java.sql.SQLException: Connections could not be acquired from the underlying database! at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692) at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140) at org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:84) at org.hibernate.internal.AbstractSessionImpl 1.getObject(AbstractBeanFactory.java:293)atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)atorg.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)atorg.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)atorg.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)atcom.cloudera.server.cmf.Main.bootstrapSpringContext(Main.java:393)atcom.cloudera.server.cmf.Main.<init>(Main.java:243)atcom.cloudera.server.cmf.Main.main(Main.java:216)Causedby:org.springframework.beans.factory.BeanCreationException:Errorcreatingbeanwithname′entityManagerFactoryBean′:FactoryBeanthrewexceptiononobjectcreation;nestedexceptionisjavax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException:Couldnotopenconnectionatorg.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:149)atorg.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:102)atorg.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1440)atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:247)atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)...17moreCausedby:javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException:Couldnotopenconnectionatorg.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)atorg.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)atorg.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:1397)atorg.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:62)atcom.cloudera.enterprise.AbstractWrappedEntityManager.beginForRollbackAndReadonly(AbstractWrappedEntityManager.java:89)atcom.cloudera.enterprise.dbutil.DbUtil.isInnoDbEnabled(DbUtil.java:554)atcom.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.checkMysqlTableEngineType(EntityManagerFactoryBean.java:139)atcom.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:122)atcom.cloudera.server.cmf.bootstrap.EntityManagerFactoryBean.getObject(EntityManagerFactoryBean.java:65)atorg.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:142)...22moreCausedby:org.hibernate.exception.GenericJDBCException:Couldnotopenconnectionatorg.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)atorg.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:221)atorg.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)atorg.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.doBegin(JdbcTransaction.java:67)atorg.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractTransactionImpl.java:160)atorg.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1426)atorg.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:59)...28moreCausedby:java.sql.SQLException:Connectionscouldnotbeacquiredfromtheunderlyingdatabase!atcom.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:692)atcom.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)atorg.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:84)atorg.hibernate.internal.AbstractSessionImplNonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:292)
at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
… 33 more
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1469)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:644)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:554)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:758)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:685)
… 37 more
Caused by: java.sql.SQLException: Access denied for user ‘scm’@‘master’ (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:871)
at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1714)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1224)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2199)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2025)
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:778)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
at sun.reflect.GeneratedConstructorAccessor5.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:175)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access 700 ( B a s i c R e s o u r c e P o o l . j a v a : 44 ) a t c o m . m c h a n g e . v 2. r e s o u r c e p o o l . B a s i c R e s o u r c e P o o l 700(BasicResourcePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool 700(BasicResourcePool.java:44)atcom.mchange.v2.resourcepool.BasicResourcePoolScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
复制代码
报错原因：
日志里面写的很清楚，原因：Access denied for user ‘scm’@‘master’ (using password: YES)
翻译：用户“scm”@“主机”拒绝访问（使用密码：是）
为什么会拒绝访问呢？一头雾水啊！！！
分析以下，拒绝访问可能是没有权限访问，或者MySQL数据库没有启动。
首先排除MySQL数据库没有启动的原因，接下来就是寻找没有访问权限的原因了。
根据百度的结果，大部分造成此种结果的原因是没有提供MySQL的远程访问权限。
但是我很确定当时我已经设置了MySQL数据库开放远程访问权限。
走投无路，只能死马当作活马医了，重新开放权限。
报错解决：
[root@master sources]# mysql -uroot -proot复制代码
mysql> use mysql;mysql> select host,user,password from user;
mysql> update user set password=password(‘root’) where user=‘root’;
mysql> grant all privileges on . to ‘root’@‘master’ identified by ‘root’; --‘root’@'%'中 %代表所有主机
复制代码
但是执行到上面这一步的时候又报错：Access denied for user ‘root’@‘master’ (using password: YES)
这次我是彻底懵逼了，为了解决权限的错误执行的命令竟然报出权限的错误。
在网上找了很长时间也没有找到解决方案，于是我只能重装数据库了。
重装完成数据库之后，再次执行赋予远程登录的权限就成功了。
复制代码
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> select host,user,password from user;
±----------±-----±------------------------------------------+
| host | user | password |
±----------±-----±------------------------------------------+
| localhost | root | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| master | root | *D2338747885A51AACEED4A7276143CB759A5B844 |
| 127.0.0.1 | root | *D2338747885A51AACEED4A7276143CB759A5B844 |
| ::1 | root | *D2338747885A51AACEED4A7276143CB759A5B844 |
±----------±-----±------------------------------------------+
4 rows in set (0.00 sec)mysql> update user set password=password(‘root’) where user=‘root’;
Query OK, 3 rows affected (0.00 sec)
Rows matched: 4 Changed: 3 Warnings: 0mysql> grant all privileges on . to ‘root’@‘master’ identified by ‘root’;
Query OK, 0 rows affected (0.00 sec)mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)mysql> exit
Bye
复制代码
然后再执行数据库初始化/opt/cm-5.15.1/share/cmf/schema/scm_prepare_database.sh mysql cm -hmaster -uroot -proot --scm-host master scm scm scm
参数分别是: 数据库类型 数据库名称 -h数据库主机名 -u数据库用户名 -p数据库密码–scm-host cmserver主机名 scm scm scm
主节点：通过/bigdata/cm-5.15.1/etc/init.d/cloudera-scm-server start启动服务端
[root@master /]# /opt/cm-5.15.1/etc/init.d/cloudera-scm-server start
这个时候cloudera-scm-server就不会挂掉了
-
相关阅读:
经典算法学习之-----直接插入排序
初学Java，快速稳步提升编程水平的真相不来看看吗？
怎样把1.ts-10.ts的文件拼接成一个MP4文件
设计模式- 迭代器模式（Iterator Pattern）结构|原理|优缺点|场景|示例
消除过期的对象引用
【独家专访】“数网”同防筑牢屏障——新型电力系统网络安全保障体系需加快调整
Jeewx-api 1.4.9版本发布—第三方APP开发SDK，支持微信、钉钉、企业微信、小程序等
【附源码】Python计算机毕业设计宿舍管理系统设计
软件设计师软考题目解析12 --每日五题
【html总结--详细版】
- 原文地址：https://blog.csdn.net/weixin_43214644/article/details/126341079