|
|
在查询量大的时候会报以下错误。
是驱动问题吗？还是？
O2版本9.0.1mysql版本5.7.26
2024-04-26 08:22:43.049 [com.x.query.assemble.surface-poolIndex-20-id-48460] ERROR com.alibaba.druid.pool.DruidPooledStatement - CommunicationsException, druid version 1.2.14, jdbcUrl : jdbc:mysql://127.0.0.1:3306/usuio2oa?autoReconnect=true&allowPublicKeyRetrieval=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8, testWhileIdle true, idle millis 10063, minIdle 0, poolingCount 0, timeBetweenEvictionRunsMillis 60000, lastValidIdleMillis 10063, driver com.mysql.cj.jdbc.Driver, exceptionSorter com.alibaba.druid.pool.vendor.MySqlExceptionSorter
2024-04-26 08:22:43.049 [com.x.query.assemble.surface-poolIndex-20-id-48460] ERROR com.alibaba.druid.pool.DruidDataSource - {conn-17159} discard
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure
The last packet successfully received from the server was 10,000 milliseconds ago. The last packet sent successfully to the server was 10,000 milliseconds ago.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:175) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3225) ~[druid-1.2.14.jar:?]
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459) ~[druid-1.2.14.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3222) ~[druid-1.2.14.jar:?]
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:166) ~[druid-1.2.14.jar:?]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213) ~[druid-1.2.14.jar:?]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:302) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1169) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:423) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:477) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:259) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:248) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~[openjpa-3.2.2.jar:3.2.2]
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~[openjpa-3.2.2.jar:3.2.2]
at com.x.query.core.express.plan.CmsPlan.lambda$listBundleFilterEntry$2(CmsPlan.java:183) ~[x_query_core_express.jar:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.run(CompletableFuture.java:1700) ~[?:?]
at java.util.concurrent.CompletableFuture$AsyncSupply.exec(CompletableFuture.java:1692) ~[?:?]
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290) ~[?:?]
at java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1020) ~[?:?]
at java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1656) ~[?:?]
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1594) ~[?:?]
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183) ~[?:?]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
|
|
[信息未更新]
