Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
shawnxiang0511 opened this issue Sep 28, 2022 · 4 comments

Comments

@shawnxiang0511
Copy link

shawnxiang0511 commented Sep 28, 2022

版本信息:

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
Copy link
Author

shawnxiang0511 commented Sep 28, 2022

在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
Copy link
Author

shawnxiang0511 commented Sep 28, 2022

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
Copy link
Collaborator

zuihou commented Sep 28, 2022

#175

image

@zuihou
Copy link
Collaborator

zuihou commented Sep 28, 2022

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

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

@zuihou zuihou closed this as completed Sep 28, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants