微信 userAgent 过长导致无法插入日志

### 基本信息

- ruoyi-vue-pro 版本：master
- 数据库：8.0
- 手机型号 一加7Pro 微信客户端

### 你猜测可能的原因
 使用微信访问网站时, userAgent 过长导致无法插入日志
```
Mozilla/5.0 (Linux; Android 11; GM1910 Build/RKQ1.201022.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3225 MMWEBSDK/20220402 Mobile Safari/537.36 MMWEBID/2527 MicroMessenger/8.0.22.2140(0x28001657) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64
```

数据库中 `user_agent` varchar(200) 而微信浏览器头的 user_agent 长度有 295,所以导致无法插入数据,
是否考虑 过滤 user_agent 中必要的信息,或者加大 数据库 user_agent的 长度

### 报错信息
```
yudao-server      | 2022-05-28 14:55:45.406 ERROR 7 --- [task-5] [TID: N/A] c.i.y.m.s.s.l.OperateLogServiceImpl      : [createOperateLogAsync][记录操作日志异常，日志为 (OperateLogCreateReqDTO(traceId=, userId=1, userType=2, module=管理后台 - 博客文章, name=更新Pcr文章, type=2, content=null, exts=null, requestMethod=POST, requestUrl=/admin-api/blog/article/updatePcr, userIp=27.19.141.149, userAgent=Mozilla/5.0 (Linux; Android 11; GM1910 Build/RKQ1.201022.002; wv) AppleWebKit/537.36 (KHTML, like Gecko) Version/4.0 Chrome/86.0.4240.99 XWEB/3225 MMWEBSDK/20220402 Mobile Safari/537.36 MMWEBID/2527 MicroMessenger/8.0.22.2140(0x28001657) WeChat/arm64 Weixin NetType/WIFI Language/zh_CN ABI/arm64, javaMethod=CommonResult cn.iocoder.yudao.module.blog.controller.admin.article.ArticleController.updatePcrArticle(), javaMethodArgs={}, startTime=Sat May 28 14:55:43 CST 2022, duration=1475, resultCode=0, resultMsg=, resultData=true))]
yudao-server      | 
yudao-server      | org.springframework.dao.DataIntegrityViolationException: 
yudao-server      | ### Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'user_agent' at row 1
yudao-server      | ### The error may exist in cn/iocoder/yudao/module/system/dal/mysql/logger/OperateLogMapper.java (best guess)
yudao-server      | ### The error may involve cn.iocoder.yudao.module.system.dal.mysql.logger.OperateLogMapper.insert-Inline
yudao-server      | ### The error occurred while setting parameters
yudao-server      | ### SQL: INSERT INTO system_operate_log  ( trace_id, user_id, user_type, module, name, type,   request_method, request_url, user_ip, user_agent, java_method, java_method_args, start_time, duration, result_code, result_msg, result_data, create_time, update_time, creator, updater )  VALUES  ( ?, ?, ?, ?, ?, ?,   ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
yudao-server      | ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'user_agent' at row 1
yudao-server      | ; Data truncation: Data too long for column 'user_agent' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'user_agent' at row 1
yudao-server      |     at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:104)
yudao-server      |     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
yudao-server      |     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
yudao-server      |     at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
yudao-server      |     at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
yudao-server      |     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
yudao-server      |     at com.sun.proxy.$Proxy148.insert(Unknown Source)
yudao-server      |     at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
yudao-server      |     at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:59)
yudao-server      |     at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
yudao-server      |     at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
yudao-server      |     at com.sun.proxy.$Proxy258.insert(Unknown Source)
yudao-server      |     at cn.iocoder.yudao.module.system.service.logger.OperateLogServiceImpl.createOperateLogAsync(OperateLogServiceImpl.java:50)
yudao-server      |     at cn.iocoder.yudao.module.system.service.logger.OperateLogServiceImpl$$FastClassBySpringCGLIB$$c685e117.invoke(<generated>)
yudao-server      |     at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
yudao-server      |     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)
yudao-server      |     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
yudao-server      |     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
yudao-server      |     at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:123)
yudao-server      |     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
yudao-server      |     at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)
yudao-server      |     at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115)
yudao-server      |     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
yudao-server      |     at com.alibaba.ttl.TtlRunnable.run(TtlRunnable.java:59)
yudao-server      |     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
yudao-server      |     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
yudao-server      |     at java.lang.Thread.run(Thread.java:750)
yudao-server      | Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'user_agent' at row 1
yudao-server      |     at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
yudao-server      |     at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
yudao-server      |     at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:371)
yudao-server      |     at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3461)
yudao-server      |     at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
yudao-server      |     at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3459)
yudao-server      |     at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:167)
yudao-server      |     at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:497)
yudao-server      |     at sun.reflect.GeneratedMethodAccessor199.invoke(Unknown Source)
yudao-server      |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
yudao-server      |     at java.lang.reflect.Method.invoke(Method.java:498)
yudao-server      |     at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)
yudao-server      |     at com.sun.proxy.$Proxy172.execute(Unknown Source)
yudao-server      |     at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
yudao-server      |     at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
yudao-server      |     at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
yudao-server      |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
yudao-server      |     at java.lang.reflect.Method.invoke(Method.java:498)
yudao-server      |     at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
yudao-server      |     at com.sun.proxy.$Proxy170.update(Unknown Source)
yudao-server      |     at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
yudao-server      |     at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
yudao-server      |     at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
yudao-server      |     at sun.reflect.GeneratedMethodAccessor270.invoke(Unknown Source)
yudao-server      |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
yudao-server      |     at java.lang.reflect.Method.invoke(Method.java:498)
yudao-server      |     at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
yudao-server      |     at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
yudao-server      |     at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
yudao-server      |     at com.sun.proxy.$Proxy169.update(Unknown Source)
yudao-server      |     at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:194)
yudao-server      |     at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:181)
yudao-server      |     at sun.reflect.GeneratedMethodAccessor306.invoke(Unknown Source)
yudao-server      |     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
yudao-server      |     at java.lang.reflect.Method.invoke(Method.java:498)
yudao-server      |     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
yudao-server      |     ... 21 common frames omitted

```

芋道源码/ruoyi-vue-pro

内容风险标识

评论 (7)

芋道源码/ruoyi-vue-pro .gitee-modal { width: 500px !important; }

内容风险标识