xingkongshensui 发表于 2023-8-9 09:56:17

后台错误处理

两个问题,而且后台一直报错。能告知一下这类如何修改?或者说主要是什么原因引起的?
1.数据库连接问题
2023-08-09 09:37:04.622 ERROR com.alibaba.druid.pool.DruidPooledStatement - CommunicationsException, druid version 1.2.14, jdbcUrl : jdbc:mysql://192.168.1.21:3306/O2OA?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8&useLegacyDatetimeCode=false&serverTimezone=GMT%2B8, testWhileIdle true, idle millis 10001, minIdle 0, poolingCount 3, timeBetweenEvictionRunsMillis 60000, lastValidIdleMillis 10001, driver com.mysql.cj.jdbc.Driver, exceptionSorter com.alibaba.druid.pool.vendor.MySqlExceptionSorter
2023-08-09 09:37:04.622 ERROR com.alibaba.druid.pool.DruidDataSource - {conn-10020} discard
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet successfully received from the server was 10,001 milliseconds ago. The last packet sent successfully to the server was 10,001 milliseconds ago.
        at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~
        at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~
        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:413) ~
        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.program.center.schedule.CollectLog.listUnexpectedErrorLog(CollectLog.java:200) ~
        at com.x.program.center.schedule.CollectLog.collectUnexpectedErrorLog(CollectLog.java:80) ~
        at com.x.program.center.schedule.CollectLog.execute(CollectLog.java:50) ~
        at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~
        at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
2.未执行完的问题

2023-08-09 09:23:58.283 ERROR com.x.message.assemble.communicate.jaxrs.connector.ActionCreate - id:02b39c61-c5f3-4d19-8b9c-d4474906d7c7, name:com.x.message.assemble.communicate.jaxrs.connector.ActionCreate, message:com.google.gson.stream.MalformedJsonException: Unterminated object at line 8 column 2 path $.enablePublish, exception:com.google.gson.JsonSyntaxException.
com.google.gson.JsonSyntaxException: com.google.gson.stream.MalformedJsonException: Unterminated object at line 8 column 2 path $.enablePublish
        at com.google.gson.Gson.fromJson(Gson.java:978) ~
        at com.google.gson.Gson.fromJson(Gson.java:928) ~
        at com.google.gson.Gson.fromJson(Gson.java:877) ~
        at com.google.gson.Gson.fromJson(Gson.java:848) ~
        at com.x.base.core.project.tools.BaseTools.readConfigObject(BaseTools.java:92) ~
        at com.x.base.core.project.config.Config.mpweixin(Config.java:1046) ~
        at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.v3MpweixinMessage(ActionCreate.java:283) ~
        at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.v3AssembleMessage(ActionCreate.java:121) ~
        at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.v3Assemble(ActionCreate.java:89) ~
        at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.execute(ActionCreate.java:54) ~
        at com.x.message.assemble.communicate.jaxrs.connector.ConnectorAction.create(ConnectorAction.java:39) ~
        at jdk.internal.reflect.GeneratedMethodAccessor1658.invoke(Unknown Source) ~[?:?]
        at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
        at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
        at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52) ~
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~
        at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~
        at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~
        at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~
        at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~
        at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~
        at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~
        at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~
        at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~
        at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~
        at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~




Ray 发表于 2023-8-9 17:38:32

第一个问题 : com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure 可以在网上搜索一下,一般是网络问题.
第二个问题 : com.google.gson.JsonSyntaxException: com.google.gson.stream.MalformedJsonException: Unterminated object at line 8 column 2 path 看对象是 com.x.base.core.project.config.Config.mpweixin(Config.java:1046) ~ 可能您的mpweixin.json 的文件格式不对,一般总是少了"," 无法或者少了]}之类的格式问题.
页: [1]
查看完整版本: 后台错误处理