应用市场无法打开 折这是什么情况

uutt@qq.com

2022-04-26 23:16:35.795 [ContextQuartzScheduler-x_program_center_Worker-1] ERROR com.x.program.center.schedule.CollectMarket - id:e5ef0ed2-10d2-4f9c-bac0-2a7a645347dc, name:com.x.program.center.schedule.CollectMarket, message:commit error, exception:java.lang.Exception.
java.lang.Exception: commit error
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1064) ~[x_base_core_project.jar:?]
        at com.x.program.center.schedule.CollectMarket.execute(CollectMarket.java:113) [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: org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:713) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1060) ~[x_base_core_project.jar:?]
        ... 3 more
Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
        at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2475) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2310) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2201) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2118) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1603) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:690) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1060) ~[x_base_core_project.jar:?]
        ... 3 more
Caused by: org.apache.openjpa.persistence.PersistenceException: Packet for query is too large (5,204,328 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable. {prepstmnt 1192212705 INSERT INTO CTE_ATTACHMENT (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xapplication, xicon, xlastUpdateTime, xname, xperson, xtype) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=0, state=S1000]
        at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5320) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5280) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:555) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:109) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:109) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:755) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2310) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2201) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2118) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1603) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:690) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1060) ~[x_base_core_project.jar:?]
        ... 3 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Packet for query is too large (5,204,328 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable. {prepstmnt 1192212705 INSERT INTO CTE_ATTACHMENT (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xapplication, xicon, xlastUpdateTime, xname, xperson, xtype) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=0, state=S1000]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:58) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1188) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:308) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1860) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:272) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:555) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:109) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:109) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:755) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2310) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2201) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2118) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:84) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1603) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:1035) ~[openjpa-3.2.0.jar:3.2.0]
        at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:690) ~[openjpa-3.2.0.jar:3.2.0]
        at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1060) ~[x_base_core_project.jar:?]

uutt@qq.com

只有搜索

论坛管理员

您的O2OA是什么版本？您是连接了O2云但是应用市场里没有东西是吗？连接O2云后同步应用市场需要一点时间，如果还是不行，麻烦提供一下您的O2云账号

uutt@qq.com

版本为7.0.5   应用市场打开只有搜索栏  其他什么也  o2云账号是uuttt

启蒙星

数据库查询报错了：org.apache.openjpa.lib.jdbc.ReportingSQLException: Packet for query is too large (5,204,328 > 4,194,304)，请对数据库做相应优化