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

20010625l 发表于 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) ~

   at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpda
te(LoggingConnectionDecorator.java:1186) ~
   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) ~
   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) ~[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)
~
   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) ~
   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) ~
   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) ~[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) ~
   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: 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) ~
   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) ~
   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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)}
   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

论坛管理员 发表于 2024-2-21 10:10:07

您这是在做什么的时候报错，看起来像是数据库有问题

20010625l 发表于 2024-2-27 17:42:25

论坛管理员发表于 2024-2-21 10:10
您这是在做什么的时候报错，看起来像是数据库有问题

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

vipbarry 发表于 2024-2-28 08:33:13

我在搭建服务器的时候也是这个解析异常，环境Ubuntu22.04服务器版+MYSQL8.0, 不管用o2oa的7.3.3还是8.2.3，./start_linux.sh之后都是这个报错。同问。

页: [1]

藕粉社区's Archiver

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

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