版本信息：
JDK 版本(必填) : 1.8.0
源码版本(必填)：4.11.0 lamp-cloud-pro-datasource-column
MySQL(必填)： 5.7.9
Nacos(必填)：2.0.3
问题描述：
后端启动的时候正常，前端刷新页面报系统繁忙，后台报Cause: java.sql.SQLSyntaxErrorException: Unknown column 'size' in 'field list'
报错截图
"C:\Program Files\Java\jdk1.8.0_231\bin\java.exe" -agentlib:jdwp=transport=dt_socket,address=127.0.0.1:64284,suspend=y,server=n -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.application.admin.enabled=true -javaagent:C:\Users\shawn\AppData\Local\JetBrains\IntelliJIdea2022.2\captureAgent\debugger-agent.jar=file:/C:/Users/shawn/AppData/Local/Temp/capture2.props -Dfile.encoding=UTF-8 -classpath C:\Users\shawn\AppData\Local\Temp\classpath1402798730.jar com.zak.freight.OauthServerApplication
Connected to the target VM, address: '127.0.0.1:64284', transport: 'socket'
[freight-oauth-server:0000::] 2022-09-28 13:17:48.827:[ INFO] [86316] [] [main:5508] [c.a.n.p.auth.spi.client.ClientAuthPluginManager.init:56] [ClientAuthPluginManager] Load ClientAuthService com.alibaba.nacos.client.auth.impl.NacosClientAuthServiceImpl success.
[freight-oauth-server:0000::] 2022-09-28 13:17:48.828:[ INFO] [86316] [] [main:5509] [c.a.n.p.auth.spi.client.ClientAuthPluginManager.init:56] [ClientAuthPluginManager] Load ClientAuthService com.alibaba.nacos.client.auth.ram.RamClientAuthServiceImpl success.
当前服务: freight-oauth-server 激活环境: dev
[freight-oauth-server:0000::] 2022-09-28 13:17:56.091:[ WARN] [86316] [] [main:12772] [c.a.cloud.nacos.client.NacosPropertySourceBuilder.loadNacosData:87] Ignore the empty nacos configuration and get it based on dataId[freight-oauth-server] & group[DEFAULT_GROUP]
[freight-oauth-server:0000::] 2022-09-28 13:17:56.106:[ WARN] [86316] [] [main:12787] [c.a.cloud.nacos.client.NacosPropertySourceBuilder.loadNacosData:87] Ignore the empty nacos configuration and get it based on dataId[freight-oauth-server-dev.yml] & group[DEFAULT_GROUP]
[freight-oauth-server:0000::] 2022-09-28 13:17:56.107:[ INFO] [86316] [] [main:12788] [o.s.c.b.c.PropertySourceBootstrapConfiguration.initialize:109] Located property source: [BootstrapPropertySource {name='bootstrapProperties-freight-oauth-server-dev.yml,DEFAULT_GROUP'}, BootstrapPropertySource {name='bootstrapProperties-freight-oauth-server.yml,DEFAULT_GROUP'}, BootstrapPropertySource {name='bootstrapProperties-freight-oauth-server,DEFAULT_GROUP'}, BootstrapPropertySource {name='bootstrapProperties-rabbitmq.yml,DEFAULT_GROUP'}, BootstrapPropertySource {name='bootstrapProperties-database.yml,DEFAULT_GROUP'}, BootstrapPropertySource {name='bootstrapProperties-redis.yml,DEFAULT_GROUP'}, BootstrapPropertySource {name='bootstrapProperties-common.yml,DEFAULT_GROUP'}]
[freight-oauth-server:18773::] 2022-09-28 13:17:56.199:[ INFO] [86316] [] [main:12880] [com.zak.freight.OauthServerApplication.logStartupProfileInfo:651] The following 1 profile is active: "dev"
[freight-oauth-server:18773::] 2022-09-28 13:18:00.790:[ INFO] [86316] [] [main:17471] [o.s.d.r.config.RepositoryConfigurationDelegate.multipleStoresDetected:262] Multiple Spring Data modules found, entering strict repository configuration mode!
[freight-oauth-server:18773::] 2022-09-28 13:18:00.796:[ INFO] [86316] [] [main:17477] [o.s.d.r.config.RepositoryConfigurationDelegate.registerRepositoriesIn:132] Bootstrapping Spring Data Redis repositories in DEFAULT mode.
[freight-oauth-server:18773::] 2022-09-28 13:18:01.009:[ INFO] [86316] [] [main:17690] [o.s.d.r.config.RepositoryConfigurationDelegate.registerRepositoriesIn:201] Finished Spring Data repository scanning in 178 ms. Found 0 Redis repository interfaces.
[freight-oauth-server:18773::] 2022-09-28 13:18:01.861:[ INFO] [86316] [] [main:18542] [o.springframework.cloud.context.scope.GenericScope.setSerializationId:283] BeanFactory id=779a3730-54bb-3e72-a89d-409c51d5c99a
[freight-oauth-server:18773::] 2022-09-28 13:18:02.007:[ INFO] [86316] [] [main:18688] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'com.zak.basic.validator.config.ValidatorConfiguration' of type [com.zak.basic.validator.config.ValidatorConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.076:[ INFO] [86316] [] [main:18757] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'validator' of type [org.hibernate.validator.internal.engine.ValidatorImpl] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.623:[ INFO] [86316] [] [main:19304] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'org.springframework.cloud.commons.config.CommonsConfigAutoConfiguration' of type [org.springframework.cloud.commons.config.CommonsConfigAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.628:[ INFO] [86316] [] [main:19309] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'org.springframework.cloud.client.loadbalancer.LoadBalancerDefaultMappingsProviderAutoConfiguration' of type [org.springframework.cloud.client.loadbalancer.LoadBalancerDefaultMappingsProviderAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.631:[ INFO] [86316] [] [main:19312] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'loadBalancerClientsDefaultsMappingsProvider' of type [org.springframework.cloud.client.loadbalancer.LoadBalancerDefaultMappingsProviderAutoConfiguration$$Lambda$527/2121682524] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.648:[ INFO] [86316] [] [main:19329] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'defaultsBindHandlerAdvisor' of type [org.springframework.cloud.commons.config.DefaultsBindHandlerAdvisor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.678:[ INFO] [86316] [] [main:19359] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'spring.datasource.dynamic-com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties' of type [com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.692:[ INFO] [86316] [] [main:19373] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration' of type [com.baomidou.dynamic.datasource.spring.boot.autoconfigure.DynamicDataSourceAutoConfiguration$$EnhancerBySpringCGLIB$$aebdb2f7] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.725:[ INFO] [86316] [] [main:19406] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'datasourceColumnAutoConfiguration' of type [com.zak.freight.config.datasource.DatasourceColumnAutoConfiguration$$EnhancerBySpringCGLIB$$f472638] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.737:[ INFO] [86316] [] [main:19418] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'dsProcessor' of type [com.zak.freight.tenant.dynamic.processor.DsThreadProcessor] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:02.905:[ INFO] [86316] [] [main:19586] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'spring.cloud.sentinel-com.alibaba.cloud.sentinel.SentinelProperties' of type [com.alibaba.cloud.sentinel.SentinelProperties] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
INFO: Sentinel log output type is: file
INFO: Sentinel log charset is: utf-8
INFO: Sentinel log base directory is: C:\Users\shawn\logs\csp\
INFO: Sentinel log name use pid is: false
[freight-oauth-server:18773::] 2022-09-28 13:18:03.166:[ INFO] [86316] [] [main:19847] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'com.alibaba.cloud.sentinel.custom.SentinelAutoConfiguration' of type [com.alibaba.cloud.sentinel.custom.SentinelAutoConfiguration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:03.176:[ INFO] [86316] [] [main:19857] [o.s.c.s.PostProcessorRegistrationDelegate$BeanPostProcessorChecker.postProcessAfterInitialization:376] Bean 'com.zak.basic.swagger2.Swagger2Configuration' of type [com.zak.basic.swagger2.Swagger2Configuration] is not eligible for getting processed by all BeanPostProcessors (for example: not eligible for auto-proxying)
[freight-oauth-server:18773::] 2022-09-28 13:18:03.655:[ INFO] [86316] [] [main:20336] [org.xnio.<clinit>:95] XNIO version 3.8.6.Final
[freight-oauth-server:18773::] 2022-09-28 13:18:03.676:[ INFO] [86316] [] [main:20357] [org.xnio.nio.<clinit>:58] XNIO NIO Implementation Version 3.8.6.Final
[freight-oauth-server:18773::] 2022-09-28 13:18:03.746:[ INFO] [86316] [] [main:20427] [org.jboss.threads.<clinit>:52] JBoss Threads version 3.1.0.Final
[freight-oauth-server:18773::] 2022-09-28 13:18:03.881:[ INFO] [86316] [] [main:20562] [io.undertow.servlet.log:382] Initializing Spring embedded WebApplicationContext
[freight-oauth-server:18773::] 2022-09-28 13:18:03.881:[ INFO] [86316] [] [main:20562] [o.s.b.w.s.c.ServletWebServerApplicationContext.prepareWebApplicationContext:290] Root WebApplicationContext: initialization completed in 7639 ms
[freight-oauth-server:18773::] 2022-09-28 13:18:05.019:[ INFO] [86316] [] [main:21700] [c.alibaba.cloud.sentinel.SentinelWebMvcConfigurer.addInterceptors:52] [Sentinel Starter] register SentinelWebInterceptor with urlPatterns: [/**].
[freight-oauth-server:18773::] 2022-09-28 13:18:05.160:[ WARN] [86316] [] [main:21841] [c.z.b.m.LampRabbitMqConfiguration$RabbitMqConfiguration.<init>:34] 检测到freight.rabbitmq.enabled=false，排除了 RabbitMQ
[freight-oauth-server:18773::] 2022-09-28 13:18:08.111:[ INFO] [86316] [] [main:24792] [com.zak.basic.log.util.AddressUtil.<clinit>:48] bean [org.lionsoul.ip2region.DbConfig@4af5c14c]
[freight-oauth-server:18773::] 2022-09-28 13:18:08.112:[ INFO] [86316] [] [main:24793] [com.zak.basic.log.util.AddressUtil.<clinit>:49] bean [org.lionsoul.ip2region.DbSearcher@74d4f542]
[freight-oauth-server:18773::] 2022-09-28 13:18:08.165:[ INFO] [86316] [] [main:24846] [org.owasp.validator.html.Policy.getInstance:294] Attempting to load AntiSamy policy from an input stream.
[freight-oauth-server:18773::] 2022-09-28 13:18:08.562:[ WARN] [86316] [] [main:25243] [org.owasp.validator.html.Policy.<init>:56] The directive "noopenerAndNoreferrerAnchors" is not enabled by default. It is recommended to enable it to prevent reverse tabnabbing attacks.
[freight-oauth-server:18773::] 2022-09-28 13:18:08.589:[ INFO] [86316] [] [main:25270] [c.z.f.oauth.controller.OauthGeneralController.<clinit>:67] 扫描: com.zak ,共加载了40个枚举类, 分别为: DictClassifyEnum,LoginStatusEnum,TplEnum,TemplateEnum,ResourceOpenWithEnum,SourceType,TaskStatus,FileType,ProductType,OrgTypeEnum,MsgTemplateTypeEnum,DateType,LogType,ComponentEnum,ResourceTypeEnum,MsgTemplateCodeEnum,ActiveStatusEnum,DataTypeEnum,PopupTypeEnum,VxeComponentEnum,ProjectTypeEnum,FileStorageType,HttpMethod,GenTypeEnum,EntitySuperClassEnum,TenantConnectTypeEnum,UserStatusEnum,DefTenantRegisterTypeEnum,DefGenTestTreeType2Enum,DefGenTestSimpleType2Enum,Sex,NoticeRemindModeEnum,DefTenantStatusEnum,MsgInterfaceLoggingStatusEnum,FileOverrideStrategyEnum,SqlConditionEnum,GrantType,InterfaceExecModeEnum,RoleCategoryEnum,SuperClassEnum
[freight-oauth-server:18773::] 2022-09-28 13:18:10.908:[ INFO] [86316] [] [main:27589] [c.z.f.config.datasource.MybatisAutoConfiguration.getPaginationBeforeInnerInterceptor:44] 检查到配置了:DATASOURCE_COLUMN模式，已加载 column 部分插件
[freight-oauth-server:18773::] 2022-09-28 13:18:11.009:[ INFO] [86316] [] [main:27690] [c.b.dynamic.datasource.DynamicRoutingDataSource.checkEnv:238] dynamic-datasource detect P6SPY plugin and enabled it
[freight-oauth-server:18773::] 2022-09-28 13:18:11.149:[ WARN] [86316] [] [main:27830] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:11.745:[ INFO] [86316] [] [main:28426] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-1,0} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:11.750:[ INFO] [86316] [] [main:28431] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [0] success
[freight-oauth-server:18773::] 2022-09-28 13:18:11.751:[ INFO] [86316] [] [main:28432] [c.b.dynamic.datasource.DynamicRoutingDataSource.afterPropertiesSet:228] dynamic-datasource initial loaded [1] datasource,primary datasource named [0]
_ _ |_ _ _|_. ___ _ | _
| | |\/|_)(_| | |_\ |_)||_|_\
/ |
3.5.2
[freight-oauth-server:18773::] 2022-09-28 13:18:17.361:[ INFO] [86316] [] [main:34042] [o.s.cloud.openfeign.FeignClientFactoryBean.getTarget:418] For 'freight-base-server' URL not provided. Will try picking an instance via load-balancing.
[freight-oauth-server:18773::] 2022-09-28 13:18:17.529:[ WARN] [86316] [] [main:34210] [com.zak.basic.cache.RedisAutoConfigure.cacheOps:118] 检查到缓存采用了 Redis模式
[freight-oauth-server:18773::] 2022-09-28 13:18:17.538:[ INFO] [86316] [] [main:34219] [o.s.cloud.openfeign.FeignClientFactoryBean.getTarget:418] For 'freight-base-server' URL not provided. Will try picking an instance via load-balancing.
[freight-oauth-server:18773::] 2022-09-28 13:18:18.469:[ INFO] [86316] [] [main:35150] [o.s.cloud.openfeign.FeignClientFactoryBean.getTarget:418] For 'freight-oauth-server' URL not provided. Will try picking an instance via load-balancing.
[freight-oauth-server:18773::] 2022-09-28 13:18:21.191:[ INFO] [86316] [] [main:37872] [o.s.cloud.openfeign.FeignClientFactoryBean.getTarget:418] For 'freight-oauth-server' URL not provided. Will try picking an instance via load-balancing.
[freight-oauth-server:18773::] 2022-09-28 13:18:21.203:[ INFO] [86316] [] [main:37884] [o.s.cloud.openfeign.FeignClientFactoryBean.getTarget:418] For 'freight-oauth-server' URL not provided. Will try picking an instance via load-balancing.
[freight-oauth-server:18773::] 2022-09-28 13:18:21.214:[ INFO] [86316] [] [main:37895] [o.s.cloud.openfeign.FeignClientFactoryBean.getTarget:418] For 'freight-oauth-server' URL not provided. Will try picking an instance via load-balancing.
freight_base: null TenantId: null UserId: null
Consume Time：401 ms 2022-09-28 13:18:27
url: jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
Execute SQL：INSERT INTO worker_node( host_name,port, type, launch_date,modified,created) VALUES ('192.168.153.108','1664342307059-58466',2,'2022-09-28T13:18:26.598+0800','2022-09-28T13:18:27.061+0800', '2022-09-28T13:18:27.061+0800')
[freight-oauth-server:18773::] 2022-09-28 13:18:27.782:[ INFO] [86316] [] [main:44463] [c.baidu.fsg.uid.worker.DisposableWorkerIdAssigner.assignWorkerId:64] Add worker node:WorkerNodeEntity[created=Wed Sep 28 13:18:27 CST 2022,hostName=192.168.153.108,id=0,launchDate=Wed Sep 28 13:18:26 CST 2022,modified=Wed Sep 28 13:18:27 CST 2022,port=1664342307059-58466,type=2]
[freight-oauth-server:18773::] 2022-09-28 13:18:27.789:[ INFO] [86316] [] [main:44470] [com.baidu.fsg.uid.impl.DefaultUidGenerator.afterPropertiesSet:103] Initialized bits(1, 31, 22, 10) for workerID:0
[freight-oauth-server:18773::] 2022-09-28 13:18:27.793:[ INFO] [86316] [] [main:44474] [com.baidu.fsg.uid.impl.CachedUidGenerator.initRingBuffer:122] Initialized ring buffer size:8192, paddingFactor:50
[freight-oauth-server:18773::] 2022-09-28 13:18:27.796:[ INFO] [86316] [] [main:44477] [com.baidu.fsg.uid.impl.CachedUidGenerator.initRingBuffer:131] Initialized BufferPaddingExecutor. Using schdule:true, interval:300
[freight-oauth-server:18773::] 2022-09-28 13:18:27.797:[ INFO] [86316] [] [main:44478] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:158] Ready to padding buffer lastSecond:1664342307. RingBuffer [bufferSize=8192, tail=-1, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:18:27.804:[ WARN] [86316] [] [main:44485] [com.baidu.fsg.uid.buffer.RingBuffer.discardPutBuffer:208] Rejected putting buffer for uid:275922082213134336. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:18:27.804:[ INFO] [86316] [] [main:44485] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:180] End to padding buffer lastSecond:1664342316. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:18:27.806:[ INFO] [86316] [] [main:44487] [com.baidu.fsg.uid.impl.CachedUidGenerator.afterPropertiesSet:77] Initialized RingBuffer successfully.
[freight-oauth-server:18773::] 2022-09-28 13:18:29.165:[ INFO] [86316] [] [main:45846] [c.a.n.p.auth.spi.client.ClientAuthPluginManager.init:56] [ClientAuthPluginManager] Load ClientAuthService com.alibaba.nacos.client.auth.impl.NacosClientAuthServiceImpl success.
[freight-oauth-server:18773::] 2022-09-28 13:18:29.166:[ INFO] [86316] [] [main:45847] [c.a.n.p.auth.spi.client.ClientAuthPluginManager.init:56] [ClientAuthPluginManager] Load ClientAuthService com.alibaba.nacos.client.auth.ram.RamClientAuthServiceImpl success.
[freight-oauth-server:18773::] 2022-09-28 13:18:29.365:[ INFO] [86316] [] [main:46046] [com.alibaba.nacos.common.remote.client.lambda$createClient$0:95] [RpcClientFactory] create a new rpc client of 2104c960-4e9d-4c69-9e8c-ec7952ad2928
[freight-oauth-server:18773::] 2022-09-28 13:18:29.367:[ INFO] [86316] [] [main:46048] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] RpcClient init label, labels = {module=naming, source=sdk}
[freight-oauth-server:18773::] 2022-09-28 13:18:29.374:[ INFO] [86316] [] [main:46055] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] RpcClient init, ServerListFactory = com.alibaba.nacos.client.naming.core.ServerListManager
[freight-oauth-server:18773::] 2022-09-28 13:18:29.375:[ INFO] [86316] [] [main:46056] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Registry connection listener to current client:com.alibaba.nacos.client.naming.remote.gprc.redo.NamingGrpcRedoService
[freight-oauth-server:18773::] 2022-09-28 13:18:29.377:[ INFO] [86316] [] [main:46058] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Register server push request handler:com.alibaba.nacos.client.naming.remote.gprc.NamingPushRequestHandler
[freight-oauth-server:18773::] 2022-09-28 13:18:29.379:[ INFO] [86316] [] [main:46060] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Try to connect to server on start up, server: {serverIp = '192.168.153.122', server main port = 8848}
[freight-oauth-server:18773::] 2022-09-28 13:18:29.507:[ INFO] [86316] [] [main:46188] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Success to connect to server [192.168.153.122:8848] on start up, connectionId = 1664342309455_192.168.153.108_64329
[freight-oauth-server:18773::] 2022-09-28 13:18:29.508:[ INFO] [86316] [] [com.alibaba.nacos.client.remote.worker:46189] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Notify connected event to listeners.
[freight-oauth-server:18773::] 2022-09-28 13:18:29.508:[ INFO] [86316] [] [main:46189] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Register server push request handler:com.alibaba.nacos.common.remote.client.RpcClient$ConnectResetRequestHandler
[freight-oauth-server:18773::] 2022-09-28 13:18:29.512:[ INFO] [86316] [] [main:46193] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Register server push request handler:com.alibaba.nacos.common.remote.client.RpcClient$$Lambda$374/1629173206
[freight-oauth-server:18773::] 2022-09-28 13:18:29.876:[ INFO] [86316] [] [main:46557] [o.s.b.actuate.endpoint.web.EndpointLinksResolver.<init>:58] Exposing 20 endpoint(s) beneath base path '/actuator'
[freight-oauth-server:18773::] 2022-09-28 13:18:30.797:[ INFO] [86316] [] [main:47478] [s.d.s.w.WebMvcPropertySourcedRequestMappingHandlerMapping.initHandlerMethods:69] Mapped URL path [/v2/api-docs] onto method [springfox.documentation.swagger2.web.Swagger2ControllerWebMvc#getDocumentation(String, HttpServletRequest)]
[freight-oauth-server:18773::] 2022-09-28 13:18:31.559:[ WARN] [86316] [] [main:48240] [o.s.b.a.freemarker.FreeMarkerAutoConfiguration.checkTemplateLocationExists:65] Cannot find template location(s): [classpath:/templates/] (please add some templates, check your FreeMarker configuration, or set spring.freemarker.checkTemplateLocation=false)
[freight-oauth-server:18773::] 2022-09-28 13:18:33.041:[ INFO] [86316] [] [main:49722] [io.undertow.start:120] starting server: Undertow - 2.2.17.Final
[freight-oauth-server:18773::] 2022-09-28 13:18:33.166:[ INFO] [86316] [] [main:49847] [o.s.boot.web.embedded.undertow.UndertowWebServer.start:119] Undertow started on port(s) 18773 (http)
[freight-oauth-server:18773::] 2022-09-28 13:18:33.188:[ INFO] [86316] [] [main:49869] [c.a.cloud.nacos.registry.NacosServiceRegistry.register:75] nacos registry, DEFAULT_GROUP freight-oauth-server 192.168.153.108:18773 register finished
[freight-oauth-server:18773::] 2022-09-28 13:18:33.644:[ INFO] [86316] [] [nacos-grpc-client-executor-192.168.153.122-5:50325] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Receive server push request, request = NotifySubscriberRequest, requestId = 1825
[freight-oauth-server:18773::] 2022-09-28 13:18:33.653:[ INFO] [86316] [] [nacos-grpc-client-executor-192.168.153.122-5:50334] [com.alibaba.nacos.common.remote.client.printIfInfoEnabled:60] [2104c960-4e9d-4c69-9e8c-ec7952ad2928] Ack server push request, request = NotifySubscriberRequest, requestId = 1825
[freight-oauth-server:18773::] 2022-09-28 13:18:34.563:[ INFO] [86316] [] [main:51244] [s.d.s.web.plugins.DocumentationPluginsBootstrapper.start:93] Documentation plugins bootstrapped
[freight-oauth-server:18773::] 2022-09-28 13:18:34.574:[ INFO] [86316] [] [main:51255] [s.d.s.web.plugins.DocumentationPluginsBootstrapper.bootstrapDocumentationPlugins:79] Found 1 custom documentation plugin(s)
[freight-oauth-server:18773::] 2022-09-28 13:18:34.687:[ INFO] [86316] [] [main:51368] [s.d.spring.web.scanners.ApiListingReferenceScanner.scan:44] Scanning for api listing references
[freight-oauth-server:18773::] 2022-09-28 13:18:35.219:[ INFO] [86316] [] [main:51900] [s.d.s.w.r.operation.CachingOperationNameGenerator.startingWith:41] Generating unique operation named: registerUsingPOST_1
[freight-oauth-server:18773::] 2022-09-28 13:18:35.406:[ INFO] [86316] [] [main:52087] [s.d.s.w.r.operation.CachingOperationNameGenerator.startingWith:41] Generating unique operation named: checkUsingGET_1
[freight-oauth-server:18773::] 2022-09-28 13:18:35.666:[ INFO] [86316] [] [main:52347] [s.d.s.w.r.operation.CachingOperationNameGenerator.startingWith:41] Generating unique operation named: loginUsingPOST_1
[freight-oauth-server:18773::] 2022-09-28 13:18:35.751:[ INFO] [86316] [] [main:52432] [com.zak.freight.OauthServerApplication.logStarted:61] Started OauthServerApplication in 51.768 seconds (JVM running for 55.03)
freight_base: null TenantId: null UserId: null
Consume Time：36 ms 2022-09-28 13:18:36
url: jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
Execute SQL：SELECT id FROM def_tenant where status in ( '05' , '15' ) and connect_type = 'SYSTEM'
[freight-oauth-server:18773::] 2022-09-28 13:18:36.212:[ WARN] [86316] [] [main:52893] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:36.410:[ INFO] [86316] [] [main:53091] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-2,freight_base_1} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:36.412:[ INFO] [86316] [] [main:53093] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_1] success
[freight-oauth-server:18773::] 2022-09-28 13:18:36.414:[ WARN] [86316] [] [main:53095] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:36.593:[ INFO] [86316] [] [main:53274] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-3,freight_base_2} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:36.594:[ INFO] [86316] [] [main:53275] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_2] success
[freight-oauth-server:18773::] 2022-09-28 13:18:36.595:[ WARN] [86316] [] [main:53276] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:36.770:[ INFO] [86316] [] [main:53451] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-4,freight_base_270678644404256924} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:36.770:[ INFO] [86316] [] [main:53451] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_270678644404256924] success
[freight-oauth-server:18773::] 2022-09-28 13:18:36.772:[ WARN] [86316] [] [main:53453] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:36.946:[ INFO] [86316] [] [main:53627] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-5,freight_base_270678644404257001} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:36.946:[ INFO] [86316] [] [main:53627] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_270678644404257001] success
[freight-oauth-server:18773::] 2022-09-28 13:18:36.948:[ WARN] [86316] [] [main:53629] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:37.128:[ INFO] [86316] [] [main:53809] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-6,freight_base_270678644404257078} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:37.129:[ INFO] [86316] [] [main:53810] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_270678644404257078] success
[freight-oauth-server:18773::] 2022-09-28 13:18:37.130:[ WARN] [86316] [] [main:53811] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:37.310:[ INFO] [86316] [] [main:53991] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-7,freight_base_270678644404257155} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:37.310:[ INFO] [86316] [] [main:53991] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_270678644404257155] success
[freight-oauth-server:18773::] 2022-09-28 13:18:37.312:[ WARN] [86316] [] [main:53993] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:37.492:[ INFO] [86316] [] [main:54173] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-8,freight_base_272933966091124736} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:37.492:[ INFO] [86316] [] [main:54173] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_272933966091124736] success
[freight-oauth-server:18773::] 2022-09-28 13:18:37.493:[ WARN] [86316] [] [main:54174] [c.b.d.d.s.b.a.druid.DruidWallConfigUtil.toWallConfig:60] druid wall does not have param enabled
[freight-oauth-server:18773::] 2022-09-28 13:18:37.666:[ INFO] [86316] [] [main:54347] [com.alibaba.druid.pool.DruidDataSource.init:998] {dataSource-9,freight_base_272933966091124813} inited
[freight-oauth-server:18773::] 2022-09-28 13:18:37.666:[ INFO] [86316] [] [main:54347] [c.b.dynamic.datasource.DynamicRoutingDataSource.addDataSource:148] dynamic-datasource - add a datasource named [freight_base_272933966091124813] success
freight_base: null TenantId: null UserId: null
Consume Time：2 ms 2022-09-28 13:18:37
url: jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
Execute SQL：SELECT dc.id, dc.created_time, dc.created_by, dc.updated_time, dc.updated_by, dc.name, dc.username, dc.password, dc.url, dc.driver_class_name driverClassName, t.id as tenantId, tdc.db_prefix as dbPrefix from def_datasource_config dc INNER JOIN def_tenant_ds_c_rel tdc on dc.id = tdc.datasource_config_id INNER JOIN def_tenant t on t.id = tdc.tenant_id where t.status in ( '05' , '15' ) and t.connect_type = 'CUSTOM'
[freight-oauth-server:18773::] 2022-09-28 13:18:37.703:[ INFO] [86316] [] [main:54384] [c.a.cloud.nacos.refresh.NacosContextRefresher.registerNacosListenersForApplications:105] listening config: dataId=freight-oauth-server.yml, group=DEFAULT_GROUP
[freight-oauth-server:18773::] 2022-09-28 13:18:37.704:[ INFO] [86316] [] [main:54385] [c.a.cloud.nacos.refresh.NacosContextRefresher.registerNacosListenersForApplications:105] listening config: dataId=freight-oauth-server-dev.yml, group=DEFAULT_GROUP
[freight-oauth-server:18773::] 2022-09-28 13:18:37.706:[ INFO] [86316] [] [main:54387] [c.a.cloud.nacos.refresh.NacosContextRefresher.registerNacosListenersForApplications:105] listening config: dataId=common.yml, group=DEFAULT_GROUP
[freight-oauth-server:18773::] 2022-09-28 13:18:37.708:[ INFO] [86316] [] [main:54389] [c.a.cloud.nacos.refresh.NacosContextRefresher.registerNacosListenersForApplications:105] listening config: dataId=database.yml, group=DEFAULT_GROUP
[freight-oauth-server:18773::] 2022-09-28 13:18:37.709:[ INFO] [86316] [] [main:54390] [c.a.cloud.nacos.refresh.NacosContextRefresher.registerNacosListenersForApplications:105] listening config: dataId=freight-oauth-server, group=DEFAULT_GROUP
[freight-oauth-server:18773::] 2022-09-28 13:18:37.712:[ INFO] [86316] [] [main:54393] [com.zak.freight.OauthServerApplication.main:34]
----------------------------------------------------------
应用 'freight-oauth-server' 运行成功! 访问连接:
Swagger文档: http://192.168.153.108:18773/doc.html
数据库监控: http://127.0.0.1:18773/druid
----------------------------------------------------------
[freight-oauth-server:18773::] 2022-09-28 13:18:38.766:[ INFO] [86316] [] [RMI TCP Connection(5)-192.168.153.108:55447] [io.undertow.servlet.log:382] Initializing Spring DispatcherServlet 'dispatcherServlet'
[freight-oauth-server:18773::] 2022-09-28 13:18:38.767:[ INFO] [86316] [] [RMI TCP Connection(5)-192.168.153.108:55448] [org.springframework.web.servlet.DispatcherServlet.initServletBean:525] Initializing Servlet 'dispatcherServlet'
[freight-oauth-server:18773::] 2022-09-28 13:18:38.773:[ INFO] [86316] [] [RMI TCP Connection(5)-192.168.153.108:55454] [org.springframework.web.servlet.DispatcherServlet.initServletBean:547] Completed initialization in 6 ms
[freight-oauth-server:18773::] 2022-09-28 13:23:27.818:[ INFO] [86316] [] [RingBuffer-Padding-Schedule-1:344499] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:158] Ready to padding buffer lastSecond:1664342316. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:23:27.819:[ WARN] [86316] [] [RingBuffer-Padding-Schedule-1:344500] [com.baidu.fsg.uid.buffer.RingBuffer.discardPutBuffer:208] Rejected putting buffer for uid:275922086508101632. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:23:27.819:[ INFO] [86316] [] [RingBuffer-Padding-Schedule-1:344500] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:180] End to padding buffer lastSecond:1664342317. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:24:28.109:[ WARN] [86316] [c1c1cbd607f6440ebbbd5007ccddf5da] [XNIO-2 task-1:404790] [com.alibaba.druid.pool.DruidAbstractDataSource.testConnectionInternal:1494] discard long time none received connection. , jdbcUrl : jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 350382
[freight-oauth-server:18773::] 2022-09-28 13:24:28.113:[ WARN] [86316] [c1c1cbd607f6440ebbbd5007ccddf5da] [XNIO-2 task-1:404794] [com.alibaba.druid.pool.DruidAbstractDataSource.testConnectionInternal:1494] discard long time none received connection. , jdbcUrl : jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true, version : 1.2.8, lastPacketReceivedIdleMillis : 376556
freight_base: null TenantId: null UserId: 1452186486253289472
Consume Time：4 ms 2022-09-28 13:24:28
url: jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
Execute SQL：SELECT id,username,nick_name,email,mobile,id_card,wx_open_id,dd_open_id,readonly,sex,nation,education,state,work_describe,password_error_last_time,password_error_num,password_expire_time,password,salt,last_login_time,updated_time,updated_by,created_time,created_by FROM def_user WHERE id=1452186486253289472
freight_base: null TenantId: null UserId: 1452186486253289472
Consume Time：46 ms 2022-09-28 13:24:28
url: jdbc:mysql://192.168.153.122:3306/freight_ds_c_defaults?serverTimezone=Asia/Shanghai&characterEncoding=utf8&useUnicode=true&useSSL=false&autoReconnect=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true
Execute SQL：SELECT id,biz_id,biz_type,file_type,bucket,path,original_file_name,content_type,size,updated_time,updated_by,created_time,created_by FROM com_appendix WHERE (biz_id = 1452186486253289472 AND biz_type = 'DEF__USER__AVATAR')
[freight-oauth-server:18773::] 2022-09-28 13:24:28.584:[ WARN] [86316] [c1c1cbd607f6440ebbbd5007ccddf5da] [XNIO-2 task-1:405265] [c.z.b.boot.handler.AbstractGlobalExceptionHandler.otherExceptionHandler:231] Exception:
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'size' in 'field list'
### The error may exist in com/zak/freight/file/mapper/AppendixMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,biz_id,biz_type,file_type,bucket,path,original_file_name,content_type,size,updated_time,updated_by,created_time,created_by FROM com_appendix WHERE (biz_id = ? AND biz_type = ?)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'size' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'size' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy178.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:77)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy195.selectList(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at com.sun.proxy.$Proxy196.selectList(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.list(IService.java:370)
at com.zak.freight.file.service.AppendixServiceImpl.getByBiz(AppendixServiceImpl.java:111)
at com.zak.freight.file.service.AppendixServiceImpl$$FastClassBySpringCGLIB$$a7eb9fc3.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at com.baomidou.dynamic.datasource.aop.DynamicDataSourceAnnotationInterceptor.invoke(DynamicDataSourceAnnotationInterceptor.java:50)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
at com.zak.freight.file.service.impl.DefAppendixServiceImpl$$EnhancerBySpringCGLIB$$193176fb.getByBiz(<generated>)
at com.zak.freight.oauth.biz.OauthUserBiz.getUserById(OauthUserBiz.java:56)
at com.zak.freight.oauth.controller.UserInfoController.getUserInfoById(UserInfoController.java:43)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:645)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.zak.basic.xss.filter.XssFilter.doFilter(XssFilter.java:66)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:275)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:134)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:131)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:255)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:79)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:100)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:852)
at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:2019)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1558)
at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1423)
at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'size' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:663)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
at com.p6spy.engine.wrapper.PreparedStatementWrapper.execute(PreparedStatementWrapper.java:362)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at com.sun.proxy.$Proxy343.query(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy342.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
... 111 common frames omitted
重现步骤
- 访问了什么接口？
- 传递什么参数？
- 后端控制台报了什么错？
- 前端控制台报了什么错？
支持一下
如果该issue帮助了你, 麻烦给项目点个star, 并给当前issue回复一下 “👍” 或者 “已解决”.
3.8k Dec 31, 2022
3k Dec 31, 2022
1 Oct 26, 2022
17 Dec 2, 2022
1 Jan 6, 2022
7 Jun 10, 2022
24.8k Jan 6, 2023
15.7k Dec 31, 2022
5.6k Dec 30, 2022
4 Sep 13, 2022
2 Feb 8, 2022
7.9k Jan 6, 2023
5.9k Jan 5, 2023
2.5k Dec 29, 2022
1.9k Dec 31, 2022
1.6k Dec 21, 2022
1.3k Dec 21, 2022
81 Nov 20, 2022
8 Jun 9, 2021