|
OS: Ubuntu 20.04
O2OA version: 5.1.4, and master branch as of 20200818
Postgres version: 12.4
日志如下,其中 o2oa 开头的行为 o2oa 的日志,postgres 开头的行为 postgres 的日志。
数据库报错 relation XXX already exists。
换用 MariaDB,也会出现类似错误。似乎是数据持久层有点问题。
o2oa | ****************************************
o2oa | * application server start completed.
o2oa | * port: 20020.
o2oa | ****************************************
o2oa | ****************************************
o2oa | * web server start completed.
o2oa | * port: 80.
o2oa | ****************************************
postgres| 2020-08-18 12:26:22.523 CST [40] ERROR: relation "pp_e_process_startableidentitylist" already exists
postgres| 2020-08-18 12:26:22.523 CST [40] STATEMENT: CREATE INDEX PP_E_PROCESS_startableIdentityList ON PP_E_PROCESS_startableIdentityList (PROCESS_XID)
o2oa | 2020-08-18 12:26:22.525 ERROR [2426e60a-e4ad-4ec4-9375-f4420600e814] com.x.processplatform.assemble.surface.jaxrs.application.ApplicationAction - get entityManager for class com.x.processplatform.core.entity.element.Process error. > person:xadmin, method:GET, request:http://localhost:20020/x_processplatform_assemble_surface/jaxrs/application/list, remote host:172.18.0.1 address:172.18.0.1, head:Origin:http://localhost
o2oa | Cookie:x-token=XXXXXX
o2oa | Accept:text/html,application/json,*/*
o2oa | X-Requested-With:XMLHttpRequest
o2oa | User-Agent:Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:79.0) Gecko/20100101 Firefox/79.0
o2oa | x-token:XXXXXX
o2oa | Connection:keep-alive
o2oa | Referer:http://localhost/x_desktop/index.html
o2oa | Host:localhost:20020
o2oa | Accept-Encoding:gzip, deflate
o2oa | Authorization:XXXXXX
o2oa | Accept-Language:zh-CN,zh;q=0.8,zh-TW;q=0.7,zh-HK;q=0.5,en-US;q=0.3,en;q=0.2
o2oa | Content-Type:application/json; charset=UTF-8, body:.
o2oa | java.lang.Exception: get entityManager for class com.x.processplatform.core.entity.element.Process error.
o2oa | at com.x.base.core.container.factory.EntityManagerContainerFactory.createEntityManager(EntityManagerContainerFactory.java:109)
o2oa | at com.x.base.core.container.EntityManagerContainerBasic.get(EntityManagerContainerBasic.java:36)
o2oa | at com.x.processplatform.assemble.surface.jaxrs.application.ActionListWithPerson.listFromProcess(ActionListWithPerson.java:111)
o2oa | at com.x.processplatform.assemble.surface.jaxrs.application.ActionListWithPerson.list(ActionListWithPerson.java:76)
o2oa | at com.x.processplatform.assemble.surface.jaxrs.application.ActionListWithPerson.execute(ActionListWithPerson.java:46)
o2oa | at com.x.processplatform.assemble.surface.jaxrs.application.ApplicationAction.listWithPerson(ApplicationAction.java:61)
o2oa | at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
o2oa | at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
o2oa | at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
o2oa | at java.lang.reflect.Method.invoke(Method.java:498)
o2oa | at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
o2oa | at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
o2oa | at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
o2oa | at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
o2oa | at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
o2oa | at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
o2oa | at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
o2oa | at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
o2oa | at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
o2oa | at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
o2oa | at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
o2oa | at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
o2oa | at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
o2oa | at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
o2oa | at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
o2oa | at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
o2oa | at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
o2oa | at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
o2oa | at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
o2oa | at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
o2oa | at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
o2oa | at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
o2oa | at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
o2oa | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1617)
o2oa | at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:226)
o2oa | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
o2oa | at com.x.base.core.project.jaxrs.CipherManagerUserJaxrsFilter.doFilter(CipherManagerUserJaxrsFilter.java:39)
o2oa | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
o2oa | at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
o2oa | at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1604)
o2oa | at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:545)
o2oa | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
o2oa | at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
o2oa | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
o2oa | at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
o2oa | at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1607)
o2oa | at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
o2oa | at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1297)
o2oa | at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
o2oa | at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
o2oa | at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1577)
o2oa | at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
o2oa | at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1212)
o2oa | at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
o2oa | at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59)
o2oa | at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:767)
o2oa | at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
o2oa | at org.eclipse.jetty.server.Server.handle(Server.java:500)
o2oa | at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
o2oa | at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
o2oa | at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
o2oa | at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:270)
o2oa | at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
o2oa | at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
o2oa | at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
o2oa | at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
o2oa | at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
o2oa | at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
o2oa | at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
o2oa | at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:388)
o2oa | at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
o2oa | at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
o2oa | at java.lang.Thread.run(Thread.java:748)
o2oa | Caused by: <openjpa-3.1.0-rafcec21a1d489dff682a3ce7986fac6a1c80e8e0 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: ERROR: relation "pp_e_process_startableidentitylist" already exists {stmnt 1660899900 CREATE INDEX PP_E_PROCESS_startableIdentityList ON PP_E_PROCESS_startableIdentityList (PROCESS_XID)} [code=0, state=42P07]
o2oa | at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:625)
o2oa | at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:489)
o2oa | at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:177)
o2oa | at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:181)
o2oa | at org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:138)
o2oa | at org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:213)
o2oa | at org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:166)
o2oa | at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:262)
o2oa | at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:177)
o2oa | at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:167)
o2oa | at org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:64)
o2oa | at com.x.base.core.container.factory.EntityManagerContainerFactory.createEntityManager(EntityManagerContainerFactory.java:103)
o2oa | ... 72 more
o2oa | Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: ERROR: relation "pp_e_process_startableidentitylist" already exists {stmnt 1660899900 CREATE INDEX PP_E_PROCESS_startableIdentityList ON PP_E_PROCESS_startableIdentityList (PROCESS_XID)} [code=0, state=42P07]
o2oa | at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
o2oa | at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:203)
o2oa | at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:58)
o2oa | at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:955)
o2oa | at org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:123)
o2oa | at org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1377)
o2oa | at org.apache.openjpa.jdbc.schema.SchemaTool.createIndex(SchemaTool.java:1179)
o2oa | at org.apache.openjpa.jdbc.schema.SchemaTool.buildSchema(SchemaTool.java:689)
o2oa | at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:562)
o2oa | at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:401)
o2oa | at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:373)
o2oa | at org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:571)
o2oa | ... 83 more |
|