|
|
两个问题，而且后台一直报错。能告知一下这类如何修改？或者说主要是什么原因引起的？
1.数据库连接问题
2023-08-09 09:37:04.622 [ContextQuartzScheduler-x_program_center_Worker-2] 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 [ContextQuartzScheduler-x_program_center_Worker-2] 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) ~[mysql-connector-java-8.0.22.jar:8.0.22]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.22.jar:8.0.22]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) ~[mysql-connector-java-8.0.22.jar:8.0.22]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003) ~[mysql-connector-java-8.0.22.jar:8.0.22]
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:413) ~[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.program.center.schedule.CollectLog.listUnexpectedErrorLog(CollectLog.java:200) ~[classes/:?]
at com.x.program.center.schedule.CollectLog.collectUnexpectedErrorLog(CollectLog.java:80) ~[classes/:?]
at com.x.program.center.schedule.CollectLog.execute(CollectLog.java:50) ~[classes/:?]
at org.quartz.core.JobRunShell.run(JobRunShell.java:202) ~[quartz-2.3.1.jar:?]
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573) ~[quartz-2.3.1.jar:?]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
2.未执行完的问题
2023-08-09 09:23:58.283 [ApplicationServerQueuedThreadPool-465] 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) ~[gson-2.8.9.jar:?]
at com.google.gson.Gson.fromJson(Gson.java:928) ~[gson-2.8.9.jar:?]
at com.google.gson.Gson.fromJson(Gson.java:877) ~[gson-2.8.9.jar:?]
at com.google.gson.Gson.fromJson(Gson.java:848) ~[gson-2.8.9.jar:?]
at com.x.base.core.project.tools.BaseTools.readConfigObject(BaseTools.java:92) ~[x_base_core_project.jar:?]
at com.x.base.core.project.config.Config.mpweixin(Config.java:1046) ~[x_base_core_project.jar:?]
at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.v3MpweixinMessage(ActionCreate.java:283) ~[classes/:?]
at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.v3AssembleMessage(ActionCreate.java:121) ~[classes/:?]
at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.v3Assemble(ActionCreate.java:89) ~[classes/:?]
at com.x.message.assemble.communicate.jaxrs.connector.ActionCreate.execute(ActionCreate.java:54) ~[classes/:?]
at com.x.message.assemble.communicate.jaxrs.connector.ConnectorAction.create(ConnectorAction.java:39) ~[classes/:?]
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) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~[jaxrs-ri-2.35.jar:2.35.]
|
|
[信息未更新]
