数据中心修改数据表总是不成功，请给出详细修改步骤

Dffiltri

如图，数据中心修改数据表总是不成功，除非删除表重新新建表，而且表还不能用原来的名。原来删除的表还在数据库中存在；已经因此重装了一次系统了；请给出详细修改步骤，包括什么时候必须删除数据库内表。

Dffiltri

7.0.2版本，新建表也不行，崩溃，难道还得重装服务器？

启蒙星

通过程序对数据库表进行删除存在很大隐患，所以表需要手工到数据库删除，另外表的字段删除、字段名称变更、字段类型变更实际也不生效的，这些操作都涉及表的重构，表编译成功后需要重启才会生效，有报错请把后台的日志发一下

Dffiltri

这是错误日志；woi表因为最后一个字段忘记回车了，所以最后一个字段没有加上，然后修改，保存编译，重启服务器，删除数据库旧XWOI表，重启服务器，但是不行，错误旧出现了。然后又取消编译，再发布，再次编译，重启服务器还是不行；重启试了好多次。
ERROR2022-03-01 15:11:58.132
2022-03-01 15:11:58.132 [ApplicationServerQueuedThreadPool-102] ERROR com.x.query.assemble.designer.jaxrs.table.TableAction - id:a761cb2c-c75e-4c63-9df9-374960236eb0, name:com.x.query.assemble.designer.jaxrs.table.TableAction, message:com.x.query.dynamic.entity.woi, exception:java.lang.ClassNotFoundException, id:a761cb2c-c75e-4c63-9df9-374960236eb0, name:com.x.query.assemble.designer.jaxrs.table.TableAction, message:com.x.query.dynamic.entity.woi, exception:java.lang.ClassNotFoundException, person:xadmin, methodOST, request:http://127.0.0.1/x_query_assemble_designer/jaxrs/table/f14eb2df-9b3e-4453-b4a8-6fa77823e0f0/execute?v=7.0, remoteHost:127.0.0.1, emoteAddr:127.0.0.1, head:Origin:http://127.0.0.1
Cookie:x-token=aHop2LIhbk4xi1CVtssEUWXudaPotigPF3mE30JRK7Q
Accept:text/html,application/json,*/*
x-token:aHop2LIhbk4xi1CVtssEUWXudaPotigPF3mE30JRK7Q
User-Agent:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36
Referer:http://127.0.0.1/x_desktop/index.html
X-Forwarded-Proto:http
X-Forwarded-Host:127.0.0.1
Sec-Fetch-Site:same-origin
Sec-Fetch-Dest:empty
Host:127.0.0.1
Accept-Encoding:gzip, deflate, br
Sec-Fetch-Mode:cors
Via:1.1 Donahue
Authorization:aHop2LIhbk4xi1CVtssEUWXudaPotigPF3mE30JRK7Q
sec-ch-ua:" Not A;Brand";v="99", "Chromium";v="98", "Google Chrome";v="98"
sec-ch-ua-mobile:?0
sec-ch-ua-platform:"Windows"
X-Forwarded-For:127.0.0.1
Accept-Language:zh-CN
Content-Length:78
X-Real-IP:127.0.0.1
X-Forwarded-Server:127.0.0.1
Content-Type:application/json; charset=UTF-8, body:{
"data": "select o from woi o",
"type": "select",
"firstResult": 0,
"maxResults": 50
}..
java.lang.ClassNotFoundException: com.x.query.dynamic.entity.woi
at jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581) ~[?:?]
at jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178) ~[?:?]
at java.lang.ClassLoader.loadClass(ClassLoader.java:521) ~[?:?]
at org.eclipse.jetty.webapp.WebAppClassLoader.loadClass(WebAppClassLoader.java:544) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at java.lang.ClassLoader.loadClass(ClassLoader.java:521) ~[?:?]
at java.lang.Class.forName0(Native Method) ~[?:?]
at java.lang.Class.forName(Class.java:315) ~[?:?]
at com.x.query.assemble.designer.jaxrs.table.ActionExecute.execute(ActionExecute.java:39) ~[classes/:?]
at com.x.query.assemble.designer.jaxrs.table.TableAction.execute(TableAction.java:432) ~[classes/:?]
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) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$VoidOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:159) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:79) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:475) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:397) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:81) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ServerRuntime$1.run(ServerRuntime.java:255) ~[jaxrs-ri-2.35.jar:2.35.]
xrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:248) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors$1.call(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:292) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:274) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.internal.Errors.process(Errors.java:244) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:265) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:234) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:684) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:394) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:346) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:366) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:319) ~[jaxrs-ri-2.35.jar:2.35.]
at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:205) ~[jaxrs-ri-2.35.jar:2.35.]
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1633) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at com.x.base.core.project.jaxrs.CipherManagerUserJaxrsFilter.doFilter(CipherManagerUserJaxrsFilter.java:45) ~[x_base_core_project.jar:?]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124) ~[druid-1.2.8.jar:1.2.8]
at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1609) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:561) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1612) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
01020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1582) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:59) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:716) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.Server.handle(Server.java:516) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383) ~[jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) [jetty-all-9.4.33.v20201020-uber.jar:9.4.33.v20201020]
at java.lang.Thread.run(Thread.java:834) [?:?]
(Thread.java:834) [?:?]
INFO2022-03-01 15:12:37.797
2022-03-01 15:12:37.797 [ContextQuartzScheduler-x_program_center_Worker-2] 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.
INFO2022-03-01 15:12:37.806
2022-03-01 15:12:37.806 [ContextQuartzScheduler-x_program_center_Worker-2] 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.
INFO2022-03-01 15:12:37.883
2022-03-01 15:12:37.883 [ContextQuartzScheduler-x_program_center_Worker-2] 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.
.
INFO2022-03-01 15:12:38.818
2022-03-01 15:12:38.818 [ContextQuartzScheduler-x_calendar_assemble_control_Worker-1] INFO com.x.calendar.assemble.control.schedule.AlarmTrigger - The trigger for calendar alarm execute completed.Tue Mar 01 15:12:38 GMT+08:00 2022
INFO2022-03-01 15:12:38.888
2022-03-01 15:12:38.888 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-1] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> query 2000 task batch operation in database......
INFO2022-03-01 15:12:38.892
2022-03-01 15:12:38.892 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-1] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> not found any task batch operation, try to check unreview task in database......
INFO2022-03-01 15:12:38.896
2022-03-01 15:12:38.896 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-1] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> not found any unreview task in database.
INFO2022-03-01 15:12:38.896
2022-03-01 15:12:38.896 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-1] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> batch operations timer task excute completed.
ted.
INFO2022-03-01 15:14:37.796
2022-03-01 15:14:37.796 [ContextQuartzScheduler-x_program_center_Worker-2] 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.
INFO2022-03-01 15:14:37.812
2022-03-01 15:14:37.812 [ContextQuartzScheduler-x_program_center_Worker-2] 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.
INFO2022-03-01 15:14:37.859
2022-03-01 15:14:37.859 [ContextQuartzScheduler-x_program_center_Worker-2] 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.
.
INFO2022-03-01 15:14:38.812
2022-03-01 15:14:38.812 [ContextQuartzScheduler-x_calendar_assemble_control_Worker-2] INFO com.x.calendar.assemble.control.schedule.AlarmTrigger - The trigger for calendar alarm execute completed.Tue Mar 01 15:14:38 GMT+08:00 2022
INFO2022-03-01 15:14:38.875
2022-03-01 15:14:38.875 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-2] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> query 2000 task batch operation in database......
INFO2022-03-01 15:14:38.877
2022-03-01 15:14:38.877 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-2] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> not found any task batch operation, try to check unreview task in database......
INFO2022-03-01 15:14:38.882
2022-03-01 15:14:38.882 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-2] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> not found any unreview task in database.
INFO2022-03-01 15:14:38.882
2022-03-01 15:14:38.882 [ContextQuartzScheduler-x_teamwork_assemble_control_Worker-2] INFO com.x.teamwork.assemble.control.timertask.Timertask_BatchOperationTask - Timertask_BatchOperationTask -> batch operations timer task excute completed.
ted.

启蒙星

是windows操作系统吗？windows编译后确实有不生效的bug

启蒙星

附件中的zip包解压到store目录下，重启，然后重新编译表，再重启

Dffiltri

启蒙星 发表于 2022-3-1 15:50
附件中的zip包解压到store目录下，重启，然后重新编译表，再重启

是的，windows系统，太谢谢了，我下来试试

论坛管理员

1511812LL

请问楼主，最后这个问题解决了吗？是什么原因造成的？