查看: 479|回复: 3

关于报错问题 请问下列具体是什么在报错

升级   3%

13

主题

17

回帖

209

积分

中级会员

Rank: 3Rank: 3

积分
209
发表于 2024-2-20 14:19:23 | 显示全部楼层 |阅读模式
The last packet successfully received from the server was 20,003 milliseconds ago. The last packet sent successfully to
the server was 20,003 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-co
nnector-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.executeUpdateInternal(ClientPreparedStatement.java:1061) ~[mysql-co
nnector-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1009) ~[mysql-co
nnector-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1320) ~[mysql-conne
ctor-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:994) ~[mysql-connector-j
-8.0.33.jar:8.0.33]
        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3238) ~[druid-1
.2.14.jar:?]
        at com.alibaba.druid.filter.FilterAdapter.preparedStatement_executeUpdate(FilterAdapter.java:1075) ~[druid-1.2.1
4.jar:?]
        at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeUpdate(FilterEventAdapter.java:486) ~[dr
uid-1.2.14.jar:?]
        at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeUpdate(FilterChainImpl.java:3236) ~[druid-1
.2.14.jar:?]
        at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeUpdate(PreparedStatementProxyImpl.java:179) ~[
druid-1.2.14.jar:?]
        at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:241) ~[dr
uid-1.2.14.jar:?]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpda
te(LoggingConnectionDecorator.java:1186) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) ~
[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1
860) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:2
72) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:
121) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementM
anagerImpl.java:80) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:1
02) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) ~[ope
njpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:555) ~[openjpa-3.2.
2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:109) ~[openjpa-3.2.
2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:109) ~[openjpa-3.2.2.ja
r:3.2.2]
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) ~[openjpa-3.2.2.jar
:3.2.2]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:755) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) ~[openjpa-3.2.2.jar:3
.2.2]
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2310) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2201) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2118) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1603) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) ~[openjpa-3.2.2.jar:3.2.2]
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:690) ~[openjpa-3.2.2.jar:3.2.2
]
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~[x_base_core_proje
ct.jar:?]
        at com.x.program.center.LogQueue.concrete(LogQueue.java:84) ~[classes/:?]
        at com.x.program.center.LogQueue.doAsScheduleLog(LogQueue.java:41) ~[classes/:?]
        at com.x.program.center.LogQueue.execute(LogQueue.java:31) ~[classes/:?]
        at com.x.program.center.LogQueue.execute(LogQueue.java:20) ~[classes/:?]
        at com.x.base.core.project.queue.AbstractQueue$1.run(AbstractQueue.java:44) ~[x_base_core_project.jar:?]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

The last packet successfully received from the server was 20,003 milliseconds ago. The last packet sent successfully to
the server was 20,003 milliseconds ago.
        at jdk.internal.reflect.GeneratedConstructorAccessor884.newInstance(Unknown Source) ~[?:?]
        at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
~[?:?]
        at java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[?:?]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62) ~[mysql-connector-j-8.0.33
.jar:8.0.33]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105) ~[mysql-connector-j-8.0.3
3.jar:8.0.33]
        at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:150) ~[mysql-connector-j-8.0.3
3.jar:8.0.33]
        at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:166) ~[mysql-con
nector-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:582) ~[mysql-connector-j-8.0.33.jar:8.
0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762) ~[mysql-connector-j-8.0.33.
jar:8.0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701) ~[mysql-connector-j-8.0.33.jar:8.
0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1052) ~[mysql-connector-j-8.0.33.j
ar:8.0.33]
        at com.mysql.cj.NativeSession.execSQL(NativeSession.java:657) ~[mysql-connector-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893) ~[mysql-connector
-j-8.0.33.jar:8.0.33]
        ... 39 more
Caused by: java.net.SocketTimeoutException: Read timed out
        at java.net.SocketInputStream.socketRead0(Native Method) ~[?:?]
        at java.net.SocketInputStream.socketRead(SocketInputStream.java:115) ~[?:?]
        at java.net.SocketInputStream.read(SocketInputStream.java:168) ~[?:?]
        at java.net.SocketInputStream.read(SocketInputStream.java:140) ~[?:?]
        at sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484) ~[?:?]
        at sun.security.ssl.SSLSocketInputRecord.readHeader(SSLSocketInputRecord.java:478) ~[?:?]
        at sun.security.ssl.SSLSocketInputRecord.bytesInCompletePacket(SSLSocketInputRecord.java:70) ~[?:?]
        at sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1455) ~[?:?]
        at sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1066) ~[?:?]
        at java.io.FilterInputStream.read(FilterInputStream.java:133) ~[?:?]
        at com.mysql.cj.protocol.FullReadInputStream.readFully(FullReadInputStream.java:64) ~[mysql-connector-j-8.0.33.j
ar:8.0.33]
        at com.mysql.cj.protocol.a.SimplePacketReader.readHeaderLocal(SimplePacketReader.java:81) ~[mysql-connector-j-8.
0.33.jar:8.0.33]
        at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:63) ~[mysql-connector-j-8.0.33.
jar:8.0.33]
        at com.mysql.cj.protocol.a.SimplePacketReader.readHeader(SimplePacketReader.java:45) ~[mysql-connector-j-8.0.33.
jar:8.0.33]
        at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:52) ~[mysql-connect
or-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.protocol.a.TimeTrackingPacketReader.readHeader(TimeTrackingPacketReader.java:41) ~[mysql-connect
or-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:54) ~[mysql-connector-j-8.0.33.ja
r:8.0.33]
        at com.mysql.cj.protocol.a.MultiPacketReader.readHeader(MultiPacketReader.java:44) ~[mysql-connector-j-8.0.33.ja
r:8.0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.readMessage(NativeProtocol.java:576) ~[mysql-connector-j-8.0.33.jar:8.
0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.checkErrorMessage(NativeProtocol.java:762) ~[mysql-connector-j-8.0.33.
jar:8.0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.sendCommand(NativeProtocol.java:701) ~[mysql-connector-j-8.0.33.jar:8.
0.33]
        at com.mysql.cj.protocol.a.NativeProtocol.sendQueryPacket(NativeProtocol.java:1052) ~[mysql-connector-j-8.0.33.j
ar:8.0.33]
        at com.mysql.cj.NativeSession.execSQL(NativeSession.java:657) ~[mysql-connector-j-8.0.33.jar:8.0.33]
        at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:893) ~[mysql-connector
-j-8.0.33.jar:8.0.33]
        ... 39 more
java.lang.Exception: commit error
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1228)
        at com.x.program.center.LogQueue.concrete(LogQueue.java:84)
        at com.x.program.center.LogQueue.doAsScheduleLog(LogQueue.java:41)
        at com.x.program.center.LogQueue.execute(LogQueue.java:31)
        at com.x.program.center.LogQueue.execute(LogQueue.java:20)
        at com.x.base.core.project.queue.AbstractQueue$1.run(AbstractQueue.java:44)
Caused by: <openjpa-3.2.2-re5933d6 fatal store error> org.apache.openjpa.persistence.RollbackException: The transaction
has been rolled back.  See the nested exceptions for details on the errors that occurred.
FailedObject: com.x.program.center.core.entity.ScheduleLog@a15d463
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:713)
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224)
        ... 5 more
Caused by: <openjpa-3.2.2-re5933d6 fatal general error> org.apache.openjpa.persistence.PersistenceException: The transac
tion has been rolled back.  See the nested exceptions for details on the errors that occurred.
FailedObject: com.x.program.center.core.entity.ScheduleLog@a15d463
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2475)
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2310)
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2201)
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2118)
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84)
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1603)
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035)
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:690)
        ... 6 more
Caused by: <openjpa-3.2.2-re5933d6 fatal general error> org.apache.openjpa.persistence.PersistenceException: Communicati
ons link failure

The last packet successfully received from the server was 20,003 milliseconds ago. The last packet sent successfully to
the server was 20,003 milliseconds ago. {prepstmnt 319799473 INSERT INTO CTE_SCHEDULELOG (xid, xcreateTime, xsequence, x
updateTime, xdistributeFactor, xapplication, xclassName, xelapsed, xfireTime, xnode, xstackTrace, xsuccess, xtype) VALUE
S (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=0, state=08S01]
FailedObject: com.x.program.center.core.entity.ScheduleLog@a15d463
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5326)
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5286)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:
146)
        at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementM
anagerImpl.java:80)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:1
02)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:555)
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:109)
        at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)

        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:109)
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:755)
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
        ... 13 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Communications link failure

The last packet successfully received from the server was 20,003 milliseconds ago. The last packet sent successfully to
the server was 20,003 milliseconds ago. {prepstmnt 319799473 INSERT INTO CTE_SCHEDULELOG (xid, xcreateTime, xsequence, x
updateTime, xdistributeFactor, xapplication, xclassName, xelapsed, xfireTime, xnode, xstackTrace, xsuccess, xtype) VALUE
S (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=0, state=08S01]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58)
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpda
te(LoggingConnectionDecorator.java:1188)
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308)
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1
860)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:2
72)
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:
121)
        ... 23 more

回复

使用道具 举报

升级   100%

138

主题

1万

回帖

3万

积分

超级版主

Rank: 8Rank: 8

积分
37249
发表于 2024-2-21 10:10:07 | 显示全部楼层
您这是在做什么的时候报错,看起来像是数据库有问题
回复

使用道具 举报

升级   3%

13

主题

17

回帖

209

积分

中级会员

Rank: 3Rank: 3

积分
209
发表于 2024-2-27 17:42:25 | 显示全部楼层
论坛管理员 发表于 2024-2-21 10:10
您这是在做什么的时候报错,看起来像是数据库有问题

这个报错是日常都有,之前服务器用的内置数据库,结果损坏了,然后程序备份不完整,恢复出来就随时都有报错,请问有没有办法解决(现在使用的mysql
回复

使用道具 举报

升级   60.67%

30

主题

33

回帖

382

积分

中级会员

Rank: 3Rank: 3

积分
382
发表于 2024-2-28 08:33:13 | 显示全部楼层
我在搭建服务器的时候也是这个解析异常,环境Ubuntu22.04服务器版+MYSQL8.0, 不管用o2oa的7.3.3还是8.2.3,./start_linux.sh之后都是这个报错。同问。
回复

使用道具 举报

发表回复

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

联系客服 关注微信 下载APP 返回顶部 返回列表
viewthread