Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Mirai Hibernate Plugin报错

2

3

220

登录后回复

L
lvjinyu 最后由编辑

刚启动时正常，但有时就会突然这样，只要接收到消息就报错
内容:
2022-08-22 17:27:03 W/mirai-hibernate-plugin: SQLException in Recorder
java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 180006ms.
at mirai-hibernate-plugin-2.4.3.jar[shared]//com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:696)
at mirai-hibernate-plugin-2.4.3.jar[shared]//com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:181)
at mirai-hibernate-plugin-2.4.3.jar[shared]//com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:146)
at mirai-hibernate-plugin-2.4.3.jar[shared]//com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:100)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.hikaricp.internal.HikariCPConnectionProvider.getConnection(HikariCPConnectionProvider.java:76)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:38)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:107)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:137)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:50)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:90)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:75)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.lambda$list$0(JdbcSelectExecutorStandardImpl.java:100)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.executeQuery(DeferredResultSetAccess.java:171)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.jdbc.internal.DeferredResultSetAccess.getResultSet(DeferredResultSetAccess.java:146)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.lambda$processNext$0(JdbcValuesResultSetImpl.java:89)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.advance(JdbcValuesResultSetImpl.java:274)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.jdbc.internal.JdbcValuesResultSetImpl.processNext(JdbcValuesResultSetImpl.java:85)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.jdbc.internal.AbstractJdbcValues.next(AbstractJdbcValues.java:29)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.internal.RowProcessingStateStandardImpl.next(RowProcessingStateStandardImpl.java:89)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:142)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:32)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:437)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:166)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.list(JdbcSelectExecutorStandardImpl.java:91)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:31)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.lambda$new$0(ConcreteSqmSelectQueryPlan.java:102)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.withCacheableSqmInterpretation(ConcreteSqmSelectQueryPlan.java:305) at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.query.sqm.internal.ConcreteSqmSelectQueryPlan.performList(ConcreteSqmSelectQueryPlan.java:246)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.query.sqm.internal.QuerySqmImpl.doList(QuerySqmImpl.java:537)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:363)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.query.sqm.internal.QuerySqmImpl.list(QuerySqmImpl.java:987)
at mirai-hibernate-plugin-2.4.3.jar//xyz.cssxsh.mirai.hibernate.MiraiHibernateRecorder.get$lambda-7(MiraiHibernateRecorder.kt:139)
at mirai-hibernate-plugin-2.4.3.jar[shared]//org.hibernate.SessionFactory.fromSession(SessionFactory.java:197)
at mirai-hibernate-plugin-2.4.3.jar//xyz.cssxsh.mirai.hibernate.MiraiHibernateRecorder.get(MiraiHibernateRecorder.kt:117)
at mirai-hibernate-plugin-2.4.3.jar//xyz.cssxsh.mirai.hibernate.MiraiHibernateRecorder$record$4.invokeSuspend(MiraiHibernateRecorder.kt:64)
at kotlin.coroutines.jvm.internal.BaseContinuationImpl.resumeWith(ContinuationImpl.kt:33)
at kotlinx.coroutines.DispatchedTask.run(DispatchedTask.kt:106)
at kotlinx.coroutines.scheduling.CoroutineScheduler.runSafely(CoroutineScheduler.kt:570)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.executeTask(CoroutineScheduler.kt:749)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.runWorker(CoroutineScheduler.kt:677)
at kotlinx.coroutines.scheduling.CoroutineScheduler$Worker.run(CoroutineScheduler.kt:664)
1 条回复最后回复
回复引用 0
cssxsh 最后由 cssxsh 编辑
config/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.properties

能把资源池吃光，你的mirai 到底跑了多少机器人....
```
hibernate.hikari.minimumIdle: 10
hibernate.hikari.maximumPoolSize: 20
hibernate.hikari.idleTimeout: 120000
hibernate.hikari.connectionTimeout: 300000
hibernate.hikari.leakDetectionThreshold: 300000
```
L 1 条回复最后回复
回复引用 0
L
lvjinyu @cssxsh 最后由编辑

@cssxsh 就一个啊，不过进了个mirai交流群，时常会有机器人炸群，一次两三百来条消息
1 条回复最后回复
回复引用 0