Nutz
  1. 主页/
  2. 问答
NutzCN Logo
问答 同样的sql语句为什么有些就会出错？
发布于 2520天前 作者 qq_36b64d67 1405 次浏览 复制 上一个帖子 下一个帖子
标签: 无

报错的语句拿到数据库里不报错，但是执行却报错，为什么呢？

2017-12-21 16:21:02 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_1
2017-12-21 16:21:02 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_1 modify RecordSorting int not null
2017-12-21 16:21:02 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_10 modify RecordSorting int not null
2017-12-21 16:21:02 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_3 modify RecordSorting int not null
2017-12-21 16:21:02 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_8 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_9 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_10 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_11 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_12 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_13 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_14 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_15 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_16 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_17 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_18 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_8 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_9 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_10 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_11 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_12 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_13 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_14 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_15 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_16 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_17 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_18 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_19 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_20 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_21 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_22 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_8 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_9 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_10 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_11 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_12 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_13 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_14 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_15 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_16 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_17 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_18 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_19 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_20 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_8 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_9 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_8 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_36 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_37 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_38 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_39 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_40_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_40_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_41_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_42_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_43_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_44_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_45_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_10 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_11 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_12 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_13 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_14 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_15 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_16 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_17 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_18 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_19 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_20 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_21 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_22 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_23 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_24 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_25 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_3 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_4 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_5 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_6 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_7 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_8 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_9 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_2
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_2.table_35_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_2.table_35_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_3
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_4
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_4.table_39_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_4.table_39_2 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_4.table_47_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_5
2017-12-21 16:21:03 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_1 modify RecordSorting int not null
2017-12-21 16:21:03 DEBUG NutDaoExecutor:97 - SQLException
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid use of NULL value
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3845)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2600)
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473)
	at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
	at com.alibaba.druid.wall.WallFilter.statement_execute(WallFilter.java:398)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
	at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:153)
	at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:497)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:357)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236)
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:1008)
	at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule.alertTables(RelatingManagementModule.java:1181)
	at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule.alert(RelatingManagementModule.java:1170)
	at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule$FM$alert$ac4f54c2a1c33e9acd432354e380fa11.invoke(RelatingManagementModule.java)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at com.yh.app.webser.common.mvc.UsbKeyCheckProcessor.process(UsbKeyCheckProcessor.java:42)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.integration.shiro.YHShiroProcessor.process(YHShiroProcessor.java:60)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:62)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.integration.shiro.NutShiroProcessor.process(NutShiroProcessor.java:126)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)
	at com.yh.app.webser.common.mvc.YHwebFilter.doFilter(YHwebFilter.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:745)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
2017-12-21 16:21:03  WARN FailProcessor:46 - Error@/relatingManagement/alert :
org.nutz.dao.DaoException: !Nutz SQL Error: 'alter table promotion_5.table_33_1 modify RecordSorting int not null'
PreparedStatement: 
'alter table promotion_5.table_33_1 modify RecordSorting int not null'
CaseMessage=Data truncation: Invalid use of NULL value
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:104)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
	at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
	at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
	at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:158)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithoutTransaction(NutDaoRunner.java:125)
	at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:92)
	at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:81)
	at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
	at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
	at org.nutz.dao.impl.DaoSupport.execute(DaoSupport.java:236)
	at org.nutz.dao.impl.NutDao.execute(NutDao.java:1008)
	at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule.alertTables(RelatingManagementModule.java:1181)
	at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule.alert(RelatingManagementModule.java:1170)
	at com.yh.app.webser.module.manage.platformfunction.RelatingManagementModule$FM$alert$ac4f54c2a1c33e9acd432354e380fa11.invoke(RelatingManagementModule.java)
	at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at com.yh.app.webser.common.mvc.UsbKeyCheckProcessor.process(UsbKeyCheckProcessor.java:42)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:30)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.integration.shiro.YHShiroProcessor.process(YHShiroProcessor.java:60)
	at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:62)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.integration.shiro.NutShiroProcessor.process(NutShiroProcessor.java:126)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
	at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
	at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
	at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
	at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
	at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
	at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)
	at com.yh.app.webser.common.mvc.YHwebFilter.doFilter(YHwebFilter.java:41)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:745)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Invalid use of NULL value
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3845)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2541)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2499)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:844)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:748)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2600)
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473)
	at com.alibaba.druid.filter.FilterEventAdapter.statement_execute(FilterEventAdapter.java:188)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
	at com.alibaba.druid.wall.WallFilter.statement_execute(WallFilter.java:398)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
	at com.alibaba.druid.filter.FilterAdapter.statement_execute(FilterAdapter.java:2473)
	at com.alibaba.druid.filter.FilterChainImpl.statement_execute(FilterChainImpl.java:2598)
	at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.execute(StatementProxyImpl.java:153)
	at com.alibaba.druid.pool.DruidPooledStatement.execute(DruidPooledStatement.java:497)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor._runStatement(NutDaoExecutor.java:357)
	at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:60)
	... 67 more
2017-12-21 16:21:03 ERROR FailProcessor:49 - 执行期间错误：org.nutz.dao.DaoException: !Nutz SQL Error: 'alter table promotion_5.table_33_1 modify RecordSorting int not null'
PreparedStatement: 
'alter table promotion_5.table_33_1 modify RecordSorting int not null'
CaseMessage=Data truncation: Invalid use of NULL value
9 回复

报错的表的这个字段有null值吧

@wendal 是的，但是这个语句放到数据库中可以运行

那是你看错数据库了吧

@wendal 没有吧，我把这个语句放到数据库中那张表成功修改过来了都

然后再跑一次程序，这个语句能pass？

嗯，对的

@wendal 日志

2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_1
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_1 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_10 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_3 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_4 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_5 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_6 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_7 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_8 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_31_9 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_10 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_11 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_12 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_13 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_14 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_15 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_16 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_17 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_18 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_2 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_3 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_4 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_5 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_6 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_7 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_8 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_32_9 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_1 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_10 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_11 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_12 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_13 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_14 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_15 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_16 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_17 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_18 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_19 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_2 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_20 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_21 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_22 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_3 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_4 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_5 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_6 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_7 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_8 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_34_9 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_1 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_10 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_11 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_12 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_13 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_14 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_15 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_16 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_17 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_18 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_19 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_2 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_20 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_3 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_4 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_5 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_6 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_7 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_8 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_36_9 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_1 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_2 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_3 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_4 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_5 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_6 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_37_7 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_1 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_2 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_3 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_4 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_5 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_6 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_7 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_38_8 modify RecordSorting int not null
2017-12-21 16:41:03 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_36 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_37 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_38 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_39_39 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_40_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_40_3 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_41_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_42_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_43_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_44_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_45_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_10 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_11 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_12 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_13 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_14 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_15 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_16 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_17 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_18 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_19 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_2 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_20 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_21 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_22 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_23 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_24 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_25 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_3 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_4 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_5 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_6 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_7 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_8 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_1.table_46_9 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_2
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_2.table_35_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_2.table_35_2 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_3
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_4
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_4.table_39_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_4.table_39_2 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_4.table_47_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_5
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_1 modify RecordSorting int not null
2017-12-21 16:41:04 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_2 modify RecordSorting int not null
2017-12-21 16:41:05 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_3 modify RecordSorting int not null
2017-12-21 16:41:06 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_4 modify RecordSorting int not null
2017-12-21 16:41:06 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_5 modify RecordSorting int not null
2017-12-21 16:41:06 DEBUG NutDaoExecutor:388 - alter table promotion_5.table_33_6 modify RecordSorting int not null
2017-12-21 16:41:06 DEBUG NutDaoExecutor:388 - show TABLES from	promotion_6
2017-12-21 16:41:06 DEBUG NutDaoExecutor:388 - alter table promotion_6.table_50_1 modify RecordSorting int not null
2017-12-21 16:41:06 DEBUG NutDaoExecutor:388 - alter table promotion_6.table_50_2 modify RecordSorting int not null
2017-12-21 16:41:06 DEBUG NutIoc:157 - Get 'pageViewLanguageManager'<class com.yh.app.webser.common.cache.PageViewLanguageManager>

哦，不知道了

好吧

添加回复
请先登陆
回到顶部