cloudera-scm-server启动时出现Caused by: javax.persistence.PersistenceException: org.hibernate.exception.G...

最新推荐文章于 2023-03-16 09:51:40 发布
最新推荐文章于 2023-03-16 09:51:40 发布
阅读量101 收藏
点赞数
原文链接：http://www.cnblogs.com/zlslch/p/7944257.html
版权

 

 

 

 　　问题现象

 

　　　　查看

[root@cmbigdata1 cloudera-scm-server]# pwd
/var/log/cloudera-scm-server
[root@cmbigdata1 cloudera-scm-server]# cat cloudera-scm-server.log

 

 　　　　是如下的问题：

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:549)
    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:106)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
    at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
    at org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:84)
    at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.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:1319)
    at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
    at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
    ... 37 more
2017-12-02 19:59:55,633 INFO main:com.cloudera.server.cmf.Main: Starting SCM Server. JVM Args: [-Dlog4j.configuration=file:/etc/cloudera-scm-server/log4j.properties, -Dfile.encoding=UTF-8, -Dcmf.root.logger=INFO,LOGFILE, -Dcmf.log.dir=/var/log/cloudera-scm-server, -Dcmf.log.file=cloudera-scm-server.log, -Dcmf.jetty.threshhold=WARN, -Dcmf.schema.dir=/usr/share/cmf/schema, -Djava.awt.headless=true, -Djava.net.preferI

 

 

 

[root@cmbigdata1 lib]# netstat -nltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN      1262/rpcbind        
tcp        0      0 0.0.0.0:4433                0.0.0.0:*                   LISTEN      1976/python2.6      
tcp        0      0 0.0.0.0:52338               0.0.0.0:*                   LISTEN      1390/rpc.statd      
tcp        0      0 127.0.0.1:7190              0.0.0.0:*                   LISTEN      1976/python2.6      
tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN      1579/sshd           
tcp        0      0 0.0.0.0:7191                0.0.0.0:*                   LISTEN      1976/python2.6      
tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN      1417/cupsd          
tcp        0      0 127.0.0.1:19001             0.0.0.0:*                   LISTEN      1894/python         
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      1683/master         
tcp        0      0 127.0.0.1:6010              0.0.0.0:*                   LISTEN      2263/sshd           
tcp        0      0 127.0.0.1:6011              0.0.0.0:*                   LISTEN      2689/sshd           
tcp        0      0 192.168.80.31:9000          0.0.0.0:*                   LISTEN      1739/python2.6      
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      3183/mysqld         
tcp        0      0 :::111                      :::*                        LISTEN      1262/rpcbind        
tcp        0      0 :::4434                     :::*                        LISTEN      1976/python2.6      
tcp        0      0 :::22                       :::*                        LISTEN      1579/sshd           
tcp        0      0 :::7191                     :::*                        LISTEN      1976/python2.6      
tcp        0      0 ::1:631                     :::*                        LISTEN      1417/cupsd          
tcp        0      0 ::1:25                      :::*                        LISTEN      1683/master         
tcp        0      0 :::59833                    :::*                        LISTEN      1390/rpc.statd      
tcp        0      0 ::1:6010                    :::*                        LISTEN      2263/sshd           
tcp        0      0 ::1:6011                    :::*                        LISTEN      2689/sshd

 

 

 

 

 

 

 

 

 

 

解决办法

 

[root@cmbigdata1 lib]# service mysqld start
Starting mysqld:                                           [  OK  ]
[root@cmbigdata1 lib]#

 

 

 

[root@cmbigdata1 lib]# netstat -nltp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address               Foreign Address             State       PID/Program name   
tcp        0      0 0.0.0.0:7180                0.0.0.0:*                   LISTEN      3309/java           
tcp        0      0 0.0.0.0:7182                0.0.0.0:*                   LISTEN      3309/java           
tcp        0      0 0.0.0.0:111                 0.0.0.0:*                   LISTEN      1262/rpcbind        
tcp        0      0 0.0.0.0:4433                0.0.0.0:*                   LISTEN      1976/python2.6      
tcp        0      0 0.0.0.0:52338               0.0.0.0:*                   LISTEN      1390/rpc.statd      
tcp        0      0 127.0.0.1:7190              0.0.0.0:*                   LISTEN      1976/python2.6      
tcp        0      0 0.0.0.0:22                  0.0.0.0:*                   LISTEN      1579/sshd           
tcp        0      0 0.0.0.0:7191                0.0.0.0:*                   LISTEN      1976/python2.6      
tcp        0      0 127.0.0.1:631               0.0.0.0:*                   LISTEN      1417/cupsd          
tcp        0      0 127.0.0.1:19001             0.0.0.0:*                   LISTEN      1894/python         
tcp        0      0 127.0.0.1:25                0.0.0.0:*                   LISTEN      1683/master         
tcp        0      0 127.0.0.1:6010              0.0.0.0:*                   LISTEN      2263/sshd           
tcp        0      0 127.0.0.1:6011              0.0.0.0:*                   LISTEN      2689/sshd           
tcp        0      0 192.168.80.31:9000          0.0.0.0:*                   LISTEN      1739/python2.6      
tcp        0      0 0.0.0.0:3306                0.0.0.0:*                   LISTEN      3183/mysqld         
tcp        0      0 :::111                      :::*                        LISTEN      1262/rpcbind        
tcp        0      0 :::4434                     :::*                        LISTEN      1976/python2.6      
tcp        0      0 :::22                       :::*                        LISTEN      1579/sshd           
tcp        0      0 :::7191                     :::*                        LISTEN      1976/python2.6      
tcp        0      0 ::1:631                     :::*                        LISTEN      1417/cupsd          
tcp        0      0 ::1:25                      :::*                        LISTEN      1683/master         
tcp        0      0 :::59833                    :::*                        LISTEN      1390/rpc.statd      
tcp        0      0 ::1:6010                    :::*                        LISTEN      2263/sshd           
tcp        0      0 ::1:6011                    :::*                        LISTEN      2689/sshd           
[root@cmbigdata1 lib]#

 　　　　其实，这个问题很简单，是mysql方面的问题，要么是mysql服务没启动，要么就是你的驱动jar包没安装好。

 

 

 

[root@cmbigdata1 lib]# pwd
/usr/share/cmf/lib
[root@cmbigdata1 lib]#

 

 

 

 

 

 

 

　建议

　　　　要将mysqld设置为开机自动启动：

　　chkconfig mysqld on

　　可能还会出现情况，就是JDBC driver cannot be found，这时把jar包复现到 /usr/share/cmf/lib 下就行了。 
　　重启cloudera-scm-server服务。 
　　等待1分钟，访问7180端口，应该就不会出问题了。

 

转载于:https://www.cnblogs.com/zlslch/p/7944257.html

weixin_30315723
关注
异常排查 PersistenceException：org.hibernate.exception.GenericJDBCException: could not execute statement
猴戏浅滩的博客
05-28 5616
具体异常信息如下： Unhandled exception: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692) at org.hib.
cloudera-scm-server启动报错org.hibernate.exception.GenericJDBCException: Could not open connection
qq_41858661的博客
09-08 584
cd /var/log/cloudera-scm-server vi cloudera-scm-server.log 找到报错信息 2021-09-08 10:27:05,790 ERROR main:com.cloudera.server.cmf.Main: Server failed. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.cloudera.serve.
CM 登陆失败，异常报错：cm Caused by: javax.persistence.PersistenceException: org.hibernate.exception.Gen
weixin_44154134的博客
05-27 752
报错内容： 1.登陆cm页面，发现无法登陆，并显示上面的异常信息 2.查看日志，发现都是跟数据库相关 cd /var/log/cloudera-scm-server less cloudera-scm-server.log 3.因cm使用的是自带的postgresql，查看cloudera-scm-server-db的状态，是否异常退出 service cloudera-scm-server-db status 4.结果发现数据库异常退出，启动db服务 service cloudera-scm-server
javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute query
七夜之家
12-17 1万+
<br />原因：权限采用联合主键,默认daoSupport的分页方法时不采用联合主键的，select count(o) from POJO o这句会出现问题导致这个异常。<br />修改方案：当前类重写分页方法,将"select count(o) from POJO o" count()中的o改为出其主键外的任一属性(eg:o.name)既可。<br />exception stack: <br />javax.persistence.PersistenceException: org.hibernate
javax.persistence.PersistenceException
程序猿劝退师的博客
12-03 5599
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.MappingException: Composite-id class must impl...
cloudera-manager-server-5.16.1-1.cm5161.p0.1.el7.x86_64.rpm
03-10
cloudera-manager-server-5.16.1-1.cm5161.p0.1.el7.x86_64.rpm centos7CM包下载
cloudera-manager-server-6.3.1-1466458.el7.x86_64.rpm
04-06
cloudera-manager-server-6.3.1-1466458.el7.x86_64.rpm
systemctl start cloudera-scm-server 启动失败报错!
nnjjzz的博客
03-16 1842
systemctl start cloudera-scm-server 启动失败报错!
cloudera-manager-server-db-2-6.3.1-1466458.el7.x86_64.rpm
04-06
cloudera-manager-server-db-2-6.3.1-1466458.el7.x86_64.rpm
JPA持久化异常：PersistenceException: org.hibernate.PersistentObjectException
热门推荐
Java仗剑走天涯
08-02 2万+
JPA持久化异常：PersistenceException: org.hibernate.PersistentObjectException
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prep
weixin_33895657的博客
05-12 5108
2019独角兽企业重金招聘Python工程师标准>>> ...
javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: ResultSet is f...
weixin_30342209的博客
02-11 670
Javajpa调用存储过程，抛出异常如下： javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: ResultSet is from UPDATE. No Data. at org.hibernate.ejb.AbstractEntityManagerImpl.c...
cloudera-scm-server一直启动失败的解决办法
厚积薄发
08-07 1万+
先说明下我使用的环境： centos7.x cdh6.3.2 jdk1.8 之前的配置都配好后执行systemctl start cloudera-scm-server命令报如下错误： [root@s30 ~]# systemctl status cloudera-scm-server ● cloudera-scm-server.service - Cloudera CM Server Service Loaded: loaded (/usr/lib/systemd/system/cloud..
javax.persistence.PersistenceException: No Persistence provider for EntityManage
weixin_30500105的博客
06-12 357
还发工具：IDEA14+jdk1.7。 文件结构以及hibernate对应的jar包：如附件中的各图所示。 persistence.xml代码： <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-insta...
hibernate报错：javax.persistence.PersistenceException: org.hibernate.PropertyAccessException: Null valu
qq_41621043的博客
08-20 6291
报错：javax.persistence.PersistenceException: org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.yunyi.entity.SY_MENU.orderIndex     at org.hiber...
JPA 开发中遇到的错误
weixin_30823227的博客
10-22 294
常见异常 1、异常信息：org.hibernate.hql.ast.QuerySyntaxException: person is not mapped异常环境：查询异常原因：查询语句中Person类没有大写2、java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to java.lang.String异常环境：查询、遍...
hibernate实现jpa文档，persistence.xml配置问题（javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Canno
jiangzezhou的专栏
06-04 7310
   hibernate实现jpa在hibernate3.6中各种包被整合到一起，但hibernate文档中不包括hibernate实现jpa的文档，该文档在官网中有：在documetation中Hibernate EntityManager User Guide里，不过没有找到下载方式，推荐选择pdf阅读方式在另存为就好了。附地址：http://www.hibernate.org/docs 
cm启动不会创建cloudera-scm-server.log
最新发布
11-16
当启动cm时出现无法创建cloudera-scm-server.log的情况可能是由于以下原因造成的： 1. 权限问题：可能是由于cm用户对日志文件所在目录没有写权限，或者日志文件已经被其他进程占用而无法被创建。可以尝试更改日志...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值