java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available

项目中连续启动三天就会报此错误,重启后就好了,过几天又出现此问题,以下是配置和错误信息,求大牛们解答

spring.datasource.username=xxx 密码和连接ip...
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.platform=mysql
spring.datasource.initialize=false
spring.datasource.data=classpath:sql/data-init.sql
spring.datasource.schema=classpath:sql/schema-mysql.sql
spring.datasource.sqlScriptEncoding=UTF-8
spring.datasource.continueOnError=true
spring.datasource.test-while-idle=true
spring.datasource.validation-query=SELECT 1
spring.datasource.xa.data-source-class-name=com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
spring.jpa.generate-ddl=false
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=false
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
spring.datasource.test-on-borrow=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.read-only=false
spring.datasource.hikari.connection-timeout=60000
spring.datasource.hikari.idle-timeout=60000
spring.datasource.hikari.validation-timeout=3000
spring.datasource.hikari.max-lifetime=60000
spring.datasource.hikari.login-timeout=5
spring.datasource.hikari.maximum-pool-size=60
spring.datasource.hikari.minimum-idle=10
2019-03-12 08:10:46,139 ERROR [https-jsse-nio-443-exec-9] o.s.b.w.s.s.ErrorPageFilter [ErrorPageFilter.java:190] Forwarding to error page from request [/api/storages/volumeType/findVolumeTypeByBo] due to exception [Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection]
org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:450)
    at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:378)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:474)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:289)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
    at com.sugon.cloudview.cmz.storage.serviceImpl.VolumeTypeServiceImpl$$EnhancerBySpringCGLIB$$ab504fe9.findVolumeTypeByBo(<generated>)
    at com.sugon.cloudview.cmz.storage.api.StorageApi.findVolumeTypeByBo(StorageApi.java:371)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877)
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783)
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:610)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:650)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:806)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1498)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:109)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:136)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getConnectionForTransactionManagement(LogicalConnectionManagedImpl.java:254)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.begin(LogicalConnectionManagedImpl.java:262)
    at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.begin(JdbcResourceLocalTransactionCoordinatorImpl.java:214)
    at org.hibernate.engine.transaction.internal.TransactionImpl.begin(TransactionImpl.java:56)
    at org.springframework.orm.jpa.vendor.HibernateJpaDialect.beginTransaction(HibernateJpaDialect.java:164)
    at org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:400)
    ... 70 common frames omitted
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 60000ms.
    at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:669)
    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:183)
    at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:148)
    at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
    at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:35)
    at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:106)
    ... 77 common frames omitted
0

1个回答

https://blog.csdn.net/xingyunpi/article/details/7216599
你看看这篇博文,他和你遇到的问题大致一样。

1
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
那些搞不懂的数据库连接异常
Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30010ms. 原因:请求数据库连接时长时间未获取到时,会报这个错误 修改配置项:datasource.primary.connection-timeo...
Hikaricp连接池问题
HiKari源于日语“光”的意思,HiKariCP顾名思义就是 和光速一样快,HiKariCP是数据库连接池的一个后起之秀,号称性能最好,稳定性也不错,完美地PK掉其他连接池。这里提供一篇文章介绍主流Java数据库连接池比较及前瞻,文中重点介绍了当前主流开源数据库连接池(比如C3P0、DBCP、Tomcat Jdbc Pool、Druid和Hikaricp)的性能分析和功能比较,有一定的参考价值。...
mysql连接失败HikariPool错误_新的解决方式
异常 com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization. 解决 1. 由于操作系统与数据库不兼容导致的问题 如果当前使用的服务器系统是ubuntu18.4, 则应当查看当前的mysql版本, 因为ubuntu默认安装的mysql版本是5.7, 而mysql5...
spring boot整合mybatis遇到问题记录
问题一: 查询表数据,SQL语句正确,但是查询结果为null,结果报空指针异常 测试结果: logbak: 2018-10-18 14:23:45.990 com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting... logbak: 2018-10-18 14:23:46.541 com.zaxxer.hikari.Hika...
深入理解Java虚拟机学习笔记-3.JVM性能监控及故障分析工具
JVM性能监控及故障分析工具1.概要JDK官方提供了不少好用的JAVA故障处理工具,JDK的命令行工具在JDK的bin目录下供用户使用。2.  jps2.1 简介  jps是jdk提供的查看当前java进程的工具,简单看作为JavaVirtual Machine Process Status Tool。 命令格式:jps [options] [hostid] options 参数详解: 参数
Springboot第六章 数据访问
Spring+jdbc 使用idea 创建springboot项目的时候选中mysql 勾上mysql 和jdbc  然后我们进行演示 spring: datasource: driver-class-name: com.mysql.jdbc.Driver url: jdbc:mysql://104.224.142.102:3306/test username: ...
spring boot整合 mybatis 和 hikariCP
附件是spring boot整合mybatis和hikariCP的示例,本demo的spring boot是2.0以下版本,spring boot 2.0以上版本默认的数据库连接池就是hikariCP。
SpringBoot系列之Hikari连接池
springboot 2.0 中默认连接池是Hikari# jdbc_config   datasourcespring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.url=jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&amp;amp;characterEncod...
数据库的连接池的数量大于活跃中的线程数,即 size > busy, Unable to fetch a connection in 10 seconds
当数据库连接池被打满的时候,经常可以看到这样的报错: Timeout: Pool empty. Unable to fetch a connection in 10 seconds, none available[size:100; busy:15; idle:0; lastwait:10000]. 在这里,我们可能有个疑问,为什么size是100而busy是15,这不是说还有 100 - ...
Redis集群密码设置
Redis集群密码设置 1,如果是使用redis-trib.rb工具构建集群,集群构建完成前不要配置密码,集群构建完毕再通过config set + config rewrite命令逐个机器设置密码 2,如果对集群设置密码,那么requirepass和masterauth都需要设置,否则发生主从切换时,就会遇到授权问题,可以模拟并观察日志 3,各个节点的密码都必须一致,否则Redirecte...
kafka相关操作及问题汇总
1. kafka查看队列的消费情况 可以通过kafka-mamager来跟进。 2 kafka常用命令 #启动kafka cd /usr/hadoop/application/kafka/bin ./kafka-server-start.sh -daemon ../config/server.properties #创建Topic ./kafka-topics.sh --create -...
Hikari 数据库连接池配置详解
&amp;lt;!-- Hikari Datasource --&amp;gt; &amp;lt;bean id=&quot;dataSourceHikari&quot; class=&quot;com.zaxxer.hikari.HikariDataSource&quot; destroy-method=&quot;shutdown&quot;&amp;gt; &amp;lt;property name=&quot;driverClassName&quot; va
HikariCP连接池及其在springboot中的配置
        大家好,现在介绍一款非常强大,高效,并且号称“史上最快连接池”。由此可见他是有多受人喜欢,并且在springboot2.0之后,采用的默认数据库连接池就是Hikari。          我们知道的连接池有C3P0,DBCP,它们都比较成熟稳定,但性能不是十分好。 所以有了BoneCP这个连接池,它是一个高速、免费、开源的JAVA连接池,它的性能几乎是C3P0、DBCP的25倍,...
Spark 异常总结及解决办法
我的原创地址:https://dongkelun.com/2019/01/09/sparkExceptions/ 前言 总结Spark开发中遇到的异常及解决办法,之前也写过几篇,之所以不再一个异常写一篇博客,是因为现在Spark用的比较熟悉了一些,觉得没必要把异常信息写那么详细了,所以就把异常总结在一篇博客里了,这样既能备忘也方便查找。 1、之前的几篇 spark-submit报错:Excep...
etcd集群之序
序言1、为什么要用etcd集群?    集群很好理解,毕竟增加了高可用性了,那为什么要用etcd而不实用zookeeper呢?从运维的角度来看,zk难以维护,而etcd作为后起之秀,则大大减少的运维的成本。2、etcd是什么?    etcd主要用来作为共享的服务配置及服务发现,使用的是raft协议来保证在分布式系统下的数据一致性,而raft算法那么容易理解,对于每个过程也是很好处理的。3、如何使
数据库方言 when no Connection available
今天启动tomcat时报错了,'hibernate.dialect' must be set when no Connection available,这个错误没有连接的时候需要数据库方言,感觉可奇怪,在单位的电脑没问题,放在家里就错了,前几天没问题,今天就错了rn2015-2-24 12:56:28 org.apache.catalina.core.AprLifecycleListener initrn信息: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: E:\Common\binary\com.sun.java.jdk.win32.x86_1.6.0.013\bin;E:\Common\plugins\com.genuitec.eclipse.easie.tomcat.myeclipse_8.5.0.me201003121946\tomcat\binrn2015-2-24 12:56:28 org.apache.coyote.http11.Http11Protocol initrn信息: Initializing Coyote HTTP/1.1 on http-8080rn2015-2-24 12:56:28 org.apache.catalina.startup.Catalina loadrn信息: Initialization processed in 346 msrn2015-2-24 12:56:28 org.apache.catalina.core.StandardService startrn信息: Starting service Catalinarn2015-2-24 12:56:28 org.apache.catalina.core.StandardEngine startrn信息: Starting Servlet Engine: Apache Tomcat/6.0.13rn2015-2-24 12:56:29 org.apache.catalina.core.ApplicationContext logrn信息: Initializing Spring root WebApplicationContextrnlog4j:WARN No appenders could be found for logger (org.springframework.web.context.ContextLoader).rnlog4j:WARN Please initialize the log4j system properly.rnlog4j:WARN No appenders could be found for logger (org.springframework.core.CollectionFactory).rnlog4j:WARN Please initialize the log4j system properly.rn2015-2-24 12:56:32 org.apache.catalina.core.ApplicationContext logrn信息: Initializing Spring root WebApplicationContextrn2015-2-24 12:57:03 org.apache.catalina.core.StandardContext listenerStartrn严重: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListenerrn_org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in class path resource [beans.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available_rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1337)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)rn at java.security.AccessController.doPrivileged(Native Method)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)rn at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)rn at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:221)rn at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)rn at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)rn at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:423)rn at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:729)rn at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:381)rn at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)rn at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)rn at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)rn at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3827)rn at org.apache.catalina.core.StandardContext.start(StandardContext.java:4334)rn at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)rn at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)rn at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:525)rn at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:920)rn at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:883)rn at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:492)rn at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)rn at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)rn at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:117)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)rn at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)rn at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)rn at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)rn at org.apache.catalina.core.StandardService.start(StandardService.java:516)rn at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)rn at org.apache.catalina.startup.Catalina.start(Catalina.java:566)rn at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)rn at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)rn at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)rn at java.lang.reflect.Method.invoke(Method.java:597)rn at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:288)rn at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:413)rn_Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set when no Connection available_rn at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:107)rn at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:138)rn at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2163)rn at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2159)rn at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1383)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:814)rn at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:732)rn at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:211)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1368)rn at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1334)rn ... 39 morern2015-2-24 12:57:03 org.apache.catalina.core.StandardContext startrn严重: Error listenerStartrn2015-2-24 12:57:03 org.apache.catalina.core.StandardContext startrn严重: Context [/Test20150223] startup failed due to previous errorsrn2015-2-24 12:57:03 org.apache.catalina.core.ApplicationContext logrn信息: Closing Spring root WebApplicationContextrnlog4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.rn2015-2-24 12:57:03 org.apache.coyote.http11.Http11Protocol startrn信息: Starting Coyote HTTP/1.1 on http-8080rn2015-2-24 12:57:03 org.apache.jk.common.ChannelSocket initrn信息: JK: ajp13 listening on /0.0.0.0:8009rn2015-2-24 12:57:03 org.apache.jk.server.JkMain startrn信息: Jk running ID=0 time=0/16 config=nullrn2015-2-24 12:57:03 org.apache.catalina.startup.Catalina startrn信息: Server startup in 34874 msrn
多数据源1
package com.card.conf; import com.zaxxer.hikari.HikariConfig; import com.zaxxer.hikari.HikariDataSource; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import or
【elasticsearch学习】java编程
Elasticsearch NoNodeAvailableException None of the configured nodes are available 可能时版本不一致,具体查看log信息;  【TransportClient 】创建 The TransportClient connects remotely to an Elasticsearch cluster using...
使用 harbor 搭建 docker 私有镜像仓库
harbor 是由 vmware 中国团队开发并开源的企业级 docker registry 服务,是对官方开源的 Docker Registry 的扩展,增加了一些企业需要的功能,如安全、复制和管理。harbor 主要用于搭建私有 registry,提供了企业需要的安全和控制功能。同时,它也帮助减少带宽使用量,这对提供生产能力和性能有帮助。 harbor 的强大之处在于,同时提供了 reg
mysql进阶(二十五)解决数据库NO CONNECTION问题
解决数据库NO CONNECTION问题前言     数据库版本类型:Mysql5.5     在应用程序连接数据库时,提示数据库连接失败。打开数据库查看,显示如下。       究其原因,是因为mysql服务出现了问题,重启mysql服务,数据库成功连接。 参考文献      1.http://jingyan.baidu.com/album/0a52e3f4158211bf62ed72e6.ht
使用hMailServer搭建本地邮件服务器
使用hMailServer搭建本地邮件服务器
VMvare桥接网络连接不上解决办法
记一次学习中的突发状况。由于本人的pc时长要在不同的网络中进行切换,ip地址一般都是不固定的,所以我使用虚拟机的时候一般使用的都是让VMvare自动识别网络环境。直到今天遇到一种突发情况,VMvare怎么都起不来了,一直报错,如下图所示。 错误代码 Error: Connection activation failed: IP configuration could not be ...
openstack搭建问题
1、yum install centos-release-openstack-mitaka 问题:No package centos-release-openstack-mitaka available.Error: Nothing to do 解决:本来想安装mitaka版本,但是CentOS阿里仓库停止openstack mitaka源服务 建议学习新版本 原因:https://www.cnb...
Mycat系列—Haproxy+Mycat实现负载均衡
Haproxy+Mycat实现负载均衡
【Spring源码分析】38-RestTemplate详解
同步客户端执行HTTP请求,在底层HTTP客户端库(如JDK HttpURLConnection,Apache HttpComponents等)上公开简单的模板方法API。RestTemplate除了支持频率较低的情况的通用交换和执行方法之外,还通过HTTP方法提供常见方案的模板。注意:从5.0开始,非阻塞,反应式org.springframework.web.reactive.client.We...
使用consul遇到的第一个问题
项目中使用到了consul;自己先新建个项目了解一下consul; 情况如下: 新建个springboot项目,引入consul依赖和lombok依赖 &amp;lt;dependency&amp;gt; &amp;lt;groupId&amp;gt;org.projectlombok&amp;lt;/groupId&amp;gt; &amp;lt;artifactId&amp;gt;lombok&amp;lt;/artifactId&amp;g...
问题记录
区块链项目 1、向activemq推消息报错:Caused by: javax.jms.JMSException: Error while attempting to add new Connection to the pool 很明显是向activemq连接池添加新连接失败,排查过后,发现是配置没有读进来: 原来是同事多加了一个冒号,这样相当于默认值为空,当该配置没有读到的时候,不会报错(待验...
解决 sqlalchemy 报错:(1193, "Unknown system variable 'tx_isolation'")
1出现此报错的原因是使用的mysql8.0 以前用的是:tx_isolation 现在用是: transaction_isolation a.通过升级 sqlalchemy 的方法可以解决此问题, pip install -i https://pypi.tuna.tsinghua.edu.cn/simple --upgrade sqlalchemy --ignore-installed(亲测有效...
jemeter服务器性能测试实战总结
Table of Contents 服务器背景介绍 性能测试方法 测试结果和分析 第一个问题:service crash重启的问题 第二个问题:Tomcat JDBC Connection not enough的问题 第三个问题:Postgresql too many clients 的问题 本次测试是针对部署在云服务上的单个service的性能测试,此service是整个业务...
grpc服务异常情况的执行流程
请先阅读 grpc的dial正常执行流程   默认配置情况下(还有其它没有提到的配置都取默认值): 设置了balancer(etcd等)没有设置WithBlock,即dialOptions.block = false没有设置FailOnNonTempDialError,即dialOptions.copts.FailOnNonTempDialError = false
restlet 遇到运行不了resources API错误
连接时候遇到String url=&quot;http://192.168.1.136:8911/tcat/screenstart?delay=&quot;+i+&quot;&quot;; @POST     @Path(&quot;screenstart&quot;)    public String start(@FormParam(&quot;delay&quot;) String i) {       log.info(&quot;resource的delay&quot;+i);    ...
memcached客户端源码分析
memcached的java客户端有好几种,http://code.google.com/p/memcached/wiki/Clients 罗列了以下几种 spymemcached * http://www.couchbase.org/code/couchbase/java o An improved Java API maintained by Matt I...
kafka无法消费
自己动手写了一个kafka消费实例,但是执行时总是报错: 2018-06-19 15:40:24.146 INFO AbstractCoordinator - [Consumer clientId=consumer-1, groupId=dfp] Marking the coordinator localhost:9092 (id: 2147483647...
Flutter工程显示“no devices”
使用androidstudio打开flutter工程,在真机已经连接USB的情况下,依然显示&quot;no devices&quot;. 解决方法,在flutter sdk目录输入命令:flutter config --android-sdk 自己的android sdk路径 ...
No processor available, rejecting this connection是怎么回事啊?
在jbuider中启tomcat有时就会出现No processor available, rejecting this connection,这是为什么啊?原来没有,就是最近会经常出现。rn
Connection not available, Timed out waiting for 180000
[size=11px][b]亲们,我想请问这类问题是不是属于连接池设置有问题的?rn我的用户量有3000-4000,平均每天有2000-3000人同时在线,rn我的WEBSPHER的连接池设置的是rn连接超时:1800秒 rn最大连接数:180 rn最小连接数:80 rnWebContainer :最大是100,最小30。rn由于我对连接池设置数一直不清晰,所以请求亲们给矛帮助或者思路,让我知道是连接池上的问题还是需要从别的方向来解决 [/b][/size]
设置neo4j 3.0.1 版本开放外网链接权限
找到这个配置项#dbms.connector.http.listen_address=:7474 改为dbms.connector.http.listen_address=0.0.0.0:74742)外网连接时要求身份验证,即使输入正确的密码也会报错,解决方法在官网找到了: https://neo4j.com/developer/kb/explanation-of-error-websock
kubernetes(k8s)部署报错问题解决
报错一:浏览器访问dashboard页面报错如下: Error: 'dial tcp 172.17.34.2:9090: getsockopt: connection timeout’ Trying to reach: ‘http://172.17.34.2:9090/’ 解决方法:vi /usr/lib/systemd/system/docker.service [Service] 下添加 Ex...
JOOQ实战(一)
package jooptest; import com.panda.core.db.Dao; import com.panda.core.db.impl.DBService; import org.jooq.DSLContext; import org.jooq.Record; import org.jooq.Result; import org.jooq.impl.DSL; import o
c#.net客户端与redis集群
最全的教程部署redis cluster方式集群,及c# 写的访问集群的源码,自己的下载分数快不够,赚2分,教程地址:http://www.cnblogs.com/uucode/p/6486395.html