mysql数据库连接失败问题
在查询量大的时候会报以下错误。是驱动问题吗？还是？
O2版本9.0.1mysql版本5.7.26
2024-04-26 08:22:43.049 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 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) ~
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972) ~
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3225) ~
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:459) ~
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3222) ~
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:166) ~
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:213) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:302) ~
at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeQuery(LoggingConnectionDecorator.java:1169) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:300) ~
at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeQuery(JDBCStoreManager.java:1870) ~
at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:290) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.executeQuery(SelectImpl.java:531) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:456) ~
at org.apache.openjpa.jdbc.sql.SelectImpl.execute(SelectImpl.java:423) ~
at org.apache.openjpa.jdbc.sql.LogicalUnion$UnionSelect.execute(LogicalUnion.java:477) ~
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:259) ~
at org.apache.openjpa.jdbc.sql.LogicalUnion.execute(LogicalUnion.java:248) ~
at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.open(SelectResultObjectProvider.java:95) ~
at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.open(QueryImpl.java:2187) ~
at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:36) ~
at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911) ~
at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842) ~
at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601) ~
at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297) ~
at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314) ~
at com.x.query.core.express.plan.CmsPlan.lambda$listBundleFilterEntry$2(CmsPlan.java:183) ~
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
需要换驱动
参考：https://www.o2oa.net/cms/serverdeployment/117.html 论坛管理员 发表于 2024-4-28 10:34
需要换驱动
参考：https://www.o2oa.net/cms/serverdeployment/117.html
请问要换成哪个版本？
页:
[1]