ren2672 发表于 2021-9-23 11:59:23

6.2 升级到6.3 出现如下错误

https://www.o2oa.net:443/x_file_assemble_control/jaxrs/file/c1cd465d-3d5d-403a-9c53-6893b2ac8c0e/download/stream上次升级到6.2时，比较顺利，6.3.2这次 明显流程模块和数据中心模块 对后台库格式要求变化？

论坛管理员 发表于 2021-9-24 10:58:05

您好：这个什么时候出现！
您使用的是什么数据库，这个估计和我们升级是没有关系的，建议检查一下您的数据库和数据库字符集设置！

ren2672 发表于 2021-9-24 13:00:07

数据库是mysql；在6.2中 是没有任何问题的，我后来网上查询到 utf8_unicode_ci、utf8_general_ci排序规则如果不同表，规则不同，则会出现上述情况。问题是这种情况一直存在6.2 中并没有出现此类错误，6.3中是否做了某种验证处理或别的什么？麻烦管理员大大看看。

论坛管理员 发表于 2021-9-24 15:59:56

您好：
是否可以提供更详细的报错！
做什么操作的时候，出现这个报错。
mysql 具体是什么版本！

ren2672 发表于 2021-9-24 16:09:36

升级后出现的报错，mysql5.7.26
web server start completed.
* port: 81.
****************************************
2021-09-23 11:51:06.013 ERROR com.x.component.assemble.control.jaxrs.component.ComponentAction - 标识为:仓管系统 的 Component 对象不存在. > person:xadmin, method:GET, request:http://127.0.0.1:20020/x_component_assemble_control/jaxrs/component/%E4%BB%93%E7%AE%A1%E7%B3%BB%E7%BB%9F?v=6.3, remote host:127.0.0.1 address:127.0.0.1, head:Origin:http://127.0.0.1:81
Cookie:x-token=G6vpFd-wW7BPCCpaw0uj9sXUozT4Y34APmXRhE-qmDU
Accept:text/html,application/json,*/*
X-Requested-With:XMLHttpRequest
Connection:keep-alive
x-token:G6vpFd-wW7BPCCpaw0uj9sXUozT4Y34APmXRhE-qmDU
User-Agent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36
Referer:http://127.0.0.1:81/x_desktop/index.html
Sec-Fetch-Site:same-site
Sec-Fetch-Dest:empty
Host:127.0.0.1:20020
Accept-Encoding:gzip, deflate, br
Sec-Fetch-Mode:cors
Authorization:G6vpFd-wW7BPCCpaw0uj9sXUozT4Y34APmXRhE-qmDU
Accept-Language:zh-CN
Content-Type:application/json; charset=UTF-8, body:.
2021-09-23 11:51:38.580 ERROR com.x.processplatform.assemble.designer.jaxrs.application.ApplicationAction - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' {prepstmnt 866084570 SELECT t0.xid, t1.xorderColumn, t1.xstartableGroupList FROM PP_E_PROCESS t0 INNER JOIN PP_E_PROCESS_startableGroupList t1 ON t0.xid = t1.PROCESS_XID WHERE ((t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ?) AND t0.xapplication IS NOT NULL AND (t0.xeditionEnable = ? OR t0.xeditionEnable IS NULL)) ORDER BY t0.xid ASC, t1.xorderColumn ASC} > person:xadmin, method:GET, request:http://127.0.0.1:20020/x_processplatform_assemble_designer/jaxrs/application/list/summary?v=6.3&ktwee7k0, remote host:127.0.0.1 address:127.0.0.1, head:Origin:http://127.0.0.1:81
Cookie:x-token=G6vpFd-wW7BPCCpaw0uj9jCrxVAA2CfbPmXRhE-qmDU
Accept:text/html,application/json,*/*
X-Requested-With:XMLHttpRequest
Connection:keep-alive
x-token:G6vpFd-wW7BPCCpaw0uj9jCrxVAA2CfbPmXRhE-qmDU
User-Agent:Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/86.0.4240.198 Safari/537.36
Referer:http://127.0.0.1:81/x_desktop/index.html
Sec-Fetch-Site:same-site
Sec-Fetch-Dest:empty
Host:127.0.0.1:20020
Accept-Encoding:gzip, deflate, br
Sec-Fetch-Mode:cors
Authorization:G6vpFd-wW7BPCCpaw0uj9jCrxVAA2CfbPmXRhE-qmDU
Accept-Language:zh-CN
Content-Type:application/json; charset=UTF-8, body:.
<openjpa-3.2.0-r6f721f6 fatal general error> org.apache.openjpa.persistence.PersistenceException: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' {prepstmnt 866084570 SELECT t0.xid, t1.xorderColumn, t1.xstartableGroupList FROM PP_E_PROCESS t0 INNER JOIN PP_E_PROCESS_startableGroupList t1 ON t0.xid = t1.PROCESS_XID WHERE ((t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ? OR t0.xapplication = ?) AND t0.xapplication IS NOT NULL AND (t0.xeditionEnable = ? OR t0.xeditionEnable IS NULL)) ORDER BY t0.xid ASC, t1.xorderColumn ASC}
    at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5320)
    at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5280)
    at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
    at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:115)
    at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:67)
    at org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:162)
    at org.apache.openjpa.kernel.QueryImpl$PackingResultObjectProvider.handleCheckedException(QueryImpl.java:2235)
    at org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:42)
    at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1314)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1061)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:911)
    at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:842)
    at org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:601)
    at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:297)
    at org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:314)
    at com.x.processplatform.assemble.designer.jaxrs.application.ActionListSummary.mapProcess(ActionListSummary.java:134)
    at com.x.processplatform.assemble.designer.jaxrs.application.ActionListSummary.list(ActionListSummary.java:107)
    at com.x.processplatform.assemble.designer.jaxrs.application.ActionListSummary.execute(ActionListSummary.java:38)
    at com.x.processplatform.assemble.designer.jaxrs.application.ApplicationAction.listSummary(ApplicationAction.java:49)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
    at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:143)
    at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
    at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
    at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
    at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
    at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
    at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
    at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
    at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
    at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
    at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
    at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
    at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
    at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
    at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
    at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
    at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
    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:39)
    at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
    at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609)
    at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
    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:766)
    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.base/java.lang.Thread.run(Thread.java:834)

论坛管理员 发表于 2021-9-24 16:18:50

1.这个估计和我们升级是没有关系的，建议检查一下您的数据库和数据库字符集设置！
https://www.o2oa.net:443/x_file_assemble_control/jaxrs/file/e13770e4-b22e-4fcc-9b79-aa9ce4fd4385/download/stream

2.建议您再检查一下您的排序，一般情况下，是您修改过排序方式
https://www.o2oa.net:443/x_file_assemble_control/jaxrs/file/b280bcb0-98cc-4472-8fdd-e0ceebf3b824/download/stream

ren2672 发表于 2021-9-24 16:28:40

https://www.o2oa.net:443/x_file_assemble_control/jaxrs/file/95efc20e-e7ef-43c8-8b54-1b5c1179f19f/download/stream
https://www.o2oa.net:443/x_file_assemble_control/jaxrs/file/adf5d73c-e562-4303-9e31-ded82cac282a/download/stream
做如下改动，可以不报错，但对数据库表本身是否产生影响不清楚。

论坛管理员 发表于 2021-9-24 16:46:33

这个还是应该是修改了字符集以及排序规则导致的。
PP_E_PROCESS_startableGroupList 是6.3才新建的表。P_E_PROCESS是历史的表。
理论上还是因为P_E_PROCESS 创建后，PP_E_PROCESS_startableGroupList 创建前，修改过排序规则导致的。
这个具体您可以咨询你们公司的DBA.

ren2672 发表于 2021-9-24 16:46:53

系统使用之初，我没动过这些后台的排序规则之类的，都是默认生成的。现在的情况我如何更改为您说的字符集，一个个改吗？另外改完之后会对数据有影响吗？谢谢。

ren2672 发表于 2021-9-24 16:52:28

https://www.o2oa.net:443/x_file_assemble_control/jaxrs/file/f758d979-8d10-4e93-99e7-1daa97523698/download/stream
刚查了下我数据库当前字符集状态
页: [1] 2
查看完整版本: 6.2 升级到6.3 出现如下错误