search

dromara / lamp-cloud

lamp-cloud 支持jdk21、jdk17、jdk11、jdk8，ta基于 SpringCloud + SpringBoot 开发的微服务中后台快速开发平台，专注于多租户(SaaS架构)解决方案，亦可作为普通项目（非SaaS架构）的基础开发框架使用，目前已实现插拔式数据库隔离、SCHEMA隔离、字段隔离 等租户隔离方案。
http://tangyh.top
Apache License 2.0
5.47k stars 1.67k forks source link

后端启动的时候正常，前端刷新页面报系统繁忙，后台报Cause: java.sql.SQLSyntaxErrorException: Unknown column 'size' in 'field list' #198

Closed shawnxiang0511 closed 1 year ago

shawnxiang0511 commented 1 year ago

版本信息：

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

重现步骤

  1. 访问了什么接口？
  2. 传递什么参数？
  3. 后端控制台报了什么错？
  4. 前端控制台报了什么错？

支持一下

如果该issue帮助了你, 麻烦给项目点个star, 并给当前issue回复一下 “👍” 或者 “已解决”.

shawnxiang0511 commented 1 year ago

在AppendixServiceImpl.java这个类中如下方法中的“List list = list(wrap);”报错的

@Override
    @Transactional(readOnly = true)
    public AppendixResultVO getByBiz(Long bizId, String bizType) {
        ArgumentAssert.notNull(bizId, "请传入业务id");
        ArgumentAssert.notEmpty(bizType, "请传入功能点");
        LbQueryWrap<Appendix> wrap = Wraps.<Appendix>lbQ().eq(Appendix::getBizId, bizId)
                .eq(Appendix::getBizType, bizType);
        List<Appendix> list = list(wrap);
        if (CollUtil.isEmpty(list)) {
            return null;
        }
        return BeanPlusUtil.toBean(list.get(0), AppendixResultVO.class);
    }
shawnxiang0511 commented 1 year ago

Appendix这个实体类中注解有误吧，size_缺少下划线，就会报上述错误，加上下划线不报了

@TableField(value = "size_")
private Long size;

但是却报如下错误了：

freight_base: null TenantId: null UserId: 1452186486253289472 
 Consume Time：4 ms 2022-09-28 13:42:59 
 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：2 ms 2022-09-28 13:43:18 
 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_base: null TenantId: null UserId: 1452186486253289472 
 Consume Time：3 ms 2022-09-28 13:43:21 
 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 t.*, utr.is_default, utr.state as employee_state from def_tenant t left join def_user_tenant_rel utr on t.id = utr.tenant_id where utr.user_id = 1452186486253289472 ORDER BY utr.is_default desc, utr.state desc, t.state desc 

[freight-oauth-server:18773::] 2022-09-28 13:43:21.337:[ WARN] [113096] [68b26853f2fc436284329ecead2ff592] [XNIO-2 task-1:129468] [c.z.b.boot.handler.AbstractGlobalExceptionHandler.missingServletRequestParameterException:136] MissingServletRequestParameterException:

org.springframework.web.bind.MissingServletRequestParameterException: Required request parameter 'applicationId' for method parameter type Long is not present
    at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValueInternal(RequestParamMethodArgumentResolver.java:218)
    at org.springframework.web.method.annotation.RequestParamMethodArgumentResolver.handleMissingValue(RequestParamMethodArgumentResolver.java:193)
    at org.springframework.web.method.annotation.AbstractNamedValueMethodArgumentResolver.resolveArgument(AbstractNamedValueMethodArgumentResolver.java:114)
    at org.springframework.web.method.support.HandlerMethodArgumentResolverComposite.resolveArgument(HandlerMethodArgumentResolverComposite.java:122)
    at org.springframework.web.method.support.InvocableHandlerMethod.getMethodArgumentValues(InvocableHandlerMethod.java:179)
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:146)
    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:1449)
    at org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280)
    at java.lang.Thread.run(Thread.java:748)

[freight-oauth-server:18773::] 2022-09-28 13:47:08.323:[ INFO] [113096] [] [RingBuffer-Padding-Schedule-1:356454] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:158] Ready to padding buffer lastSecond:1664343737. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:47:08.328:[ WARN] [113096] [] [RingBuffer-Padding-Schedule-1:356459] [com.baidu.fsg.uid.buffer.RingBuffer.discardPutBuffer:208] Rejected putting buffer for uid:275928189656629248. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:47:08.329:[ INFO] [113096] [] [RingBuffer-Padding-Schedule-1:356460] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:180] End to padding buffer lastSecond:1664343738. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:52:08.334:[ INFO] [113096] [] [RingBuffer-Padding-Schedule-1:656465] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:158] Ready to padding buffer lastSecond:1664343738. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:52:08.336:[ WARN] [113096] [] [RingBuffer-Padding-Schedule-1:656467] [com.baidu.fsg.uid.buffer.RingBuffer.discardPutBuffer:208] Rejected putting buffer for uid:275928193951596544. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
[freight-oauth-server:18773::] 2022-09-28 13:52:08.337:[ INFO] [113096] [] [RingBuffer-Padding-Schedule-1:656468] [com.baidu.fsg.uid.buffer.RingBuffer.paddingBuffer:180] End to padding buffer lastSecond:1664343739. RingBuffer [bufferSize=8192, tail=8191, cursor=-1, paddingThreshold=4096]
zuihou commented 1 year ago

https://github.com/zuihou/lamp-cloud/issues/175

image

zuihou commented 1 year ago

Required request parameter 'applicationId' for method parameter type Long is not present

是指某个接口，缺少 applicationId 参数， 前端没传 applicationId 参数或传的方式不对，导致后段接口没接收到该参数， 控制台 network 观察具体什么接口报错。 观察该接口的入参。