琪琪 发表于 2024-3-27 16:17:39

系统升级后,创建流程,保存提示 commit error

本帖最后由 琪琪 于 2024-3-28 08:41 编辑

系统从7.1.3 升级到9.0.2,创建编辑流程不能保存,提示commit error. 报错如下:




ava.lang.Exception: commit error
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1228) ~
      at com.x.processplatform.assemble.designer.jaxrs.process.ActionEdit.execute(ActionEdit.java:82) ~
      at com.x.processplatform.assemble.designer.jaxrs.process.ProcessAction.put(ProcessAction.java:103) ~
      at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
      at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
      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) ~
      at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~
      at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~
      at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~
      at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~
      at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~
      at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~
      at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~
      at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633) ~
      at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~
      at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~
      at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~
      at com.x.base.core.project.jaxrs.ManagerUserJaxrsFilter.doFilter(ManagerUserJaxrsFilter.java:51) ~
      at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~
      at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~
      at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561) ~
      at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~
      at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~
      at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~
      at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~
      at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) ~
      at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~
      at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~
      at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~
      at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~
      at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) ~
      at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~
      at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~
      at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~
      at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~
      at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:716) ~
      at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~
      at org.eclipse.jetty.server.Server.handle(Server.java:516) ~
      at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~
      at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) ~
      at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) ~
      at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) ~
      at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) ~
      at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) ~
      at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) ~
      at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) ~
      at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) ~
      at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) ~
      at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) ~
      at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) ~
      at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) ~
      at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) ~
      at java.lang.Thread.run(Thread.java:829) ~[?:?]
Caused by: org.apache.openjpa.persistence.RollbackException: Optimistic locking errors were detected when flushing to the data store.The following objects may have been concurrently modified in another transaction:
      at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:713) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 69 more
Caused by: org.apache.openjpa.persistence.OptimisticLockException: Optimistic locking errors were detected when flushing to the data store.The following objects may have been concurrently modified in another transaction:
      at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2464) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 69 more
Caused by: org.apache.openjpa.persistence.OptimisticLockException: An optimistic lock violation was detected when flushing object instance "com.x.processplatform.core.entity.element.Route-4e3f6f32-28ec-4d04-a9ab-797711665e54" to the data store.This indicates that the object was concurrently modified in another transaction.
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:126) ~
      at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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:110) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 69 more
2024-03-27 16:04:02.235 INFO com.x.query.service.processing.schedule.HighFreqWork - high freq index work start at:2024-03-27 16:04:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2024-03-27 16:04:48.470 INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.calendar.assemble.control.schedule.AlarmTrigger, cron: 0/30 * * * * ?, node: 127.0.0.1, application: com.x.base.core.project.x_calendar_assemble_control.
2024-03-27 16:04:48.556 INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.calendar.assemble.control.schedule.CheckEventComment, cron: 4 4 */2 * * ?, node: 127.0.0.1, application: com.x.base.core.project.x_calendar_assemble_control.
2024-03-27 16:04:49.606 INFO com.x.calendar.assemble.control.schedule.AlarmTrigger - The trigger for calendar alarm execute completed.Wed Mar 27 16:04:49 GMT+08:00 2024
2024-03-27 16:04:49.628 INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.processplatform.assemble.surface.schedule.CleanKeyLock, cron: 2 0/2 * * * ?, node: 127.0.0.1, application: com.x.base.core.project.x_processplatform_assemble_surface.
2024-03-27 16:04:49.664 INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.processplatform.assemble.surface.schedule.Expire, cron: 45 0/15 8-18 * * ?, node: 127.0.0.1, application: com.x.base.core.project.x_processplatform_assemble_surface.
2024-03-27 16:04:49.671 INFO com.x.calendar.assemble.control.schedule.CheckEventComment - The trigger for calendar alarm execute completed.Wed Mar 27 16:04:49 GMT+08:00 2024
2024-03-27 16:04:50.740 INFO com.x.processplatform.assemble.surface.schedule.Expire - 标识0个过期待办, 0个待办处于挂起状态, 耗时:56ms.
2024-03-27 16:04:51.276 INFO com.x.program.center.schedule.FireSchedule - fire schedule className: com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask, cron: 0 */2 * * * ?, node: 127.0.0.1, application: com.x.teamwork.assemble.control.x_teamwork_assemble_control.
2024-03-27 16:04:52.355 INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask ->query 2000 task batch operation in database......
2024-03-27 16:04:52.479 INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> not found any task batch operation, try to check unreview task in database......
2024-03-27 16:04:52.677 INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> not found any unreview task in database.
2024-03-27 16:04:52.677 INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> batch operations timer task excute completed.
2024-03-27 16:05:02.090 INFO com.x.query.service.processing.schedule.HighFreqDocument - high freq index document start at:2024-03-27 16:05:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2024-03-27 16:05:02.092 INFO com.x.query.service.processing.schedule.HighFreqWorkCompleted - high freq index workCompleted start at:2024-03-27 16:05:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2024-03-27 16:05:14.593 ERROR com.x.processplatform.assemble.designer.FormVersionQueue - id:1e02bb62-f50a-4f34-8ebe-4b2ec3daeb92, name:com.x.processplatform.assemble.designer.FormVersionQueue, message:commit error, exception:java.lang.Exception.
java.lang.Exception: commit error
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1228) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.cleanAndSave(FormVersionQueue.java:67) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.execute(FormVersionQueue.java:36) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.execute(FormVersionQueue.java:26) ~
      at com.x.base.core.project.queue.AbstractQueue$1.run(AbstractQueue.java:44) ~
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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
Caused by: org.apache.openjpa.persistence.PersistenceException: Unknown column 'xperson' in 'field list' {prepstmnt 200112198 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
      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(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown column 'xperson' in 'field list' {prepstmnt 200112198 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
      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.executeUpdate(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:1860) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:272) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ~
      at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
2024-03-27 16:06:02.027 INFO com.x.query.service.processing.schedule.HighFreqWork - high freq index work start at:2024-03-27 16:06:02, elapsed:0 minutes, total count:0, write:0, delete:0.
2024-03-27 16:06:06.347 ERROR com.x.processplatform.assemble.designer.FormVersionQueue - id:683121b6-0114-41bc-89c1-24c0ffbaa732, name:com.x.processplatform.assemble.designer.FormVersionQueue, message:commit error, exception:java.lang.Exception.
java.lang.Exception: commit error
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1228) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.cleanAndSave(FormVersionQueue.java:67) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.execute(FormVersionQueue.java:36) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.execute(FormVersionQueue.java:26) ~
      at com.x.base.core.project.queue.AbstractQueue$1.run(AbstractQueue.java:44) ~
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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
Caused by: org.apache.openjpa.persistence.PersistenceException: Unknown column 'xperson' in 'field list' {prepstmnt 574428935 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
      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(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown column 'xperson' in 'field list' {prepstmnt 574428935 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
      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.executeUpdate(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:1860) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:272) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ~
      at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
2024-03-27 16:06:08.650 ERROR com.x.processplatform.assemble.designer.FormVersionQueue - id:38104129-c281-46ee-b34a-6d306e18160d, name:com.x.processplatform.assemble.designer.FormVersionQueue, message:commit error, exception:java.lang.Exception.
java.lang.Exception: commit error
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1228) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.cleanAndSave(FormVersionQueue.java:67) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.execute(FormVersionQueue.java:36) ~
      at com.x.processplatform.assemble.designer.FormVersionQueue.execute(FormVersionQueue.java:26) ~
      at com.x.base.core.project.queue.AbstractQueue$1.run(AbstractQueue.java:44) ~
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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
Caused by: org.apache.openjpa.persistence.PersistenceException: Unknown column 'xperson' in 'field list' {prepstmnt 71437926 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
      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(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more
Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Unknown column 'xperson' in 'field list' {prepstmnt 71437926 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
      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.executeUpdate(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:1860) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:272) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:121) ~
      at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80) ~
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102) ~
      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) ~
      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) ~
      at com.x.base.core.container.EntityManagerContainer.commit(EntityManagerContainer.java:1224) ~
      ... 4 more





victor007 发表于 2024-3-28 09:07:40

Caused by: org.apache.openjpa.persistence.PersistenceException: Unknown column 'xperson' in 'field list' {prepstmnt 200112198 INSERT INTO PP_E_FORMVERSION (xid, xcreateTime, xsequence, xupdateTime, xdistributeFactor, xdata, xform, xperson) VALUES (?, ?, ?, ?, ?, ?, ?, ?)}
页: [1]
查看完整版本: 系统升级后,创建流程,保存提示 commit error