HikariPool-1
来源:互联网 发布:学说普通话软件 编辑:程序博客网 时间:2024/06/17 02:53
1.确认配置:
hikariDataSource.setIdleTimeout(60000);
hikariDataSource.setConnectionTimeout(60000);
hikariDataSource.setValidationTimeout(3000);
hikariDataSource.setLoginTimeout(5);
hikariDataSource.setMaxLifetime(60000);
2. 确认sqlSession 有没有被最终关闭。catch后加入finally{SqlSession.close()}
3. I managed to fix it finally. The problem is not related to HikariCP.The problem persisted because of some complex methods in REST controllers executing multiple changes in DB through JPA repositories. For some reasons calls to these interfaces resulted in a growing number of "freezed" active connections, exhausting the pool. Either annotating these methods as@Transactional
or enveloping all the logic in a single call to transactional service method seem to solve the problem.
最后我设法修复这个问题,发现和HikariCP无关。问题依然存在的原因是一些复杂的方法在其他控制器通过JPA存储多个数据库的造成的。由于某种原因调用这些接口导致越来越多的“冻结”活动连接,耗尽连接池。注释所调用的事务服务中如@Transactional中包含事务的所有逻辑的方法中解决这个问题。
参考链接:https://stackoverflow.com/questions/32968530/hikaricp-connection-is-not-available
- HikariPool-1
- Unable to register MBean [HikariDataSource (HikariPool-2)] with key 'dataSource'
- 1
- 1
- 1
- 1
- 1
- 1
- 1》
- 1
- 1
- 1
- 1
- (1)
- 1
- 1
- 1
- 1
- bzoj4393[Usaco2015 Dec]Fruit Feast DP
- jsp学习之jsp指令
- [LibreOJ β Round #4]多项式
- AJAX POST请求中参数以form data和request payload形式在servlet中的获取方式
- 双目立体视觉知识分享~(一)
- HikariPool-1
- D3D 天空盒实现
- 嵌入式Linux入门10:应用层编程应用和分类
- How to Install Review Board on Ubuntu 16.04
- JSON在Javascript中的使用(eval和JSON.parse的区别)
- JavaScript总结2
- hdu 5769 后缀数组
- 一次完整的浏览器请求响应过程
- Bealegbone-black学习笔记