[商业版]使用Sharding-Proxy后，点击用户管理，机构管理，菜单管理报错。其他的点击没事

Blade 未结

关注

 1  1731

3061185685 2020-05-18 00:37

悬赏：30

一、该问题的重现步骤是什么？

1. 删除工作流模块(删除pom依赖，删除flow代码目录)

2. 启动Sharding-Proxy

3.修改mysql连接到Sharding-Proxy

4.启动前端访问后报错

二、你期待的结果是什么？实际看到的又是什么？

2020-05-18 00:29:51.632 INFO 2895 --- [ XNIO-1 task-6] o.s.core.log.aspect.RequestLogAspect :

================ Request Start ================

===> GET: /blade-system/menu/routes Parameters: {"topMenuId":null,"user":{"clientId":"saber","userId":1123598821738675201,"account":"admin","userName":"admin","nickName":"管理员","tenantId":"000000","deptId":"1123598813738675201","postId":"1123598817738675201","roleId":"1123598816738675201","roleName":"administrator"}}

===Headers=== sec-fetch-mode: cors

===Headers=== referer: http://localhost:1888/

===Headers=== sec-fetch-site: same-origin

===Headers=== blade-auth: bearer eyJ0eXAiOiJKc29uV2ViVG9rZW4iLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzYWJlciIsImV4cCI6MTU4OTczNjI5NCwibmJmIjoxNTg5NzMyNjk0fQ.KUwnQhxTe8bqdTdfFcqLRPoaAzETjTZ-Chhgp5L6kwo

===Headers=== cookie: saber-access-token=eyJ0eXAiOiJKc29uV2ViVG9rZW4iLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJyb2xlX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicG9zdF9pZCI6IjExMjM1OTg4MTc3Mzg2NzUyMDEiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwidXNlcl9uYW1lIjoiYWRtaW4iLCJuaWNrX25hbWUiOiLnrqHnkIblkZgiLCJ0b2tlbl90eXBlIjoiYWNjZXNzX3Rva2VuIiwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEiLCJhY2NvdW50IjoiYWRtaW4iLCJjbGllbnRfaWQiOiJzYWJlciIsImV4cCI6MTU4OTczNjI5NCwibmJmIjoxNTg5NzMyNjk0fQ.KUwnQhxTe8bqdTdfFcqLRPoaAzETjTZ-Chhgp5L6kwo; saber-refresh-token=eyJ0eXAiOiJKc29uV2ViVG9rZW4iLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJpc3N1c2VyIiwiYXVkIjoiYXVkaWVuY2UiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInRva2VuX3R5cGUiOiJyZWZyZXNoX3Rva2VuIiwiY2xpZW50X2lkIjoic2FiZXIiLCJleHAiOjE1OTAzMzc0OTQsIm5iZiI6MTU4OTczMjY5NH0.TiTz766WFE_3BRA6LJRuBvuu869XaO1AIXqbBtcGHdA

===Headers=== accept-language: zh-CN,zh;q=0.9,en;q=0.8

===Headers=== x-forwarded-proto: http

===Headers=== x-forwarded-port: 1888

===Headers=== x-forwarded-for: 127.0.0.1

===Headers=== accept: application/json, text/plain, */*

===Headers=== authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers=== x-forwarded-host: localhost:1888

===Headers=== host: localhost

===Headers=== connection: close

===Headers=== accept-encoding: gzip, deflate, br

===Headers=== user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36

===Headers=== sec-fetch-dest: empty

================ Request End ================

2020-05-18 00:29:51.633 INFO 2895 --- [ XNIO-1 task-7] o.s.core.log.aspect.RequestLogAspect :

================ Request Start ================

===> GET: /blade-system/dept/lazy-tree Parameters: {"tenantId":null,"bladeUser":{"clientId":"saber","userId":1123598821738675201,"account":"admin","userName":"admin","nickName":"管理员","tenantId":"000000","deptId":"1123598813738675201","postId":"1123598817738675201","roleId":"1123598816738675201","roleName":"administrator"},"parentId":0}

===Headers=== sec-fetch-mode: cors

===Headers=== referer: http://localhost:1888/

===Headers=== sec-fetch-site: same-origin

===Headers=== accept-language: zh-CN,zh;q=0.9,en;q=0.8

===Headers=== x-forwarded-proto: http

===Headers=== x-forwarded-port: 1888

===Headers=== x-forwarded-for: 127.0.0.1

===Headers=== accept: application/json, text/plain, */*

===Headers=== authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers=== x-forwarded-host: localhost:1888

===Headers=== host: localhost

===Headers=== connection: close

===Headers=== accept-encoding: gzip, deflate, br

===Headers=== user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36

===Headers=== sec-fetch-dest: empty

================ Request End ================

2020-05-18 00:29:51.633 INFO 2895 --- [ XNIO-1 task-5] o.s.core.log.aspect.RequestLogAspect :

================ Request Start ================

===> GET: /blade-system/menu/top-menu Parameters: {"user":{"clientId":"saber","userId":1123598821738675201,"account":"admin","userName":"admin","nickName":"管理员","tenantId":"000000","deptId":"1123598813738675201","postId":"1123598817738675201","roleId":"1123598816738675201","roleName":"administrator"}}

===Headers=== sec-fetch-mode: cors

===Headers=== referer: http://localhost:1888/

===Headers=== sec-fetch-site: same-origin

===Headers=== accept-language: zh-CN,zh;q=0.9,en;q=0.8

===Headers=== x-forwarded-proto: http

===Headers=== x-forwarded-port: 1888

===Headers=== x-forwarded-for: 127.0.0.1

===Headers=== accept: application/json, text/plain, */*

===Headers=== authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers=== x-forwarded-host: localhost:1888

===Headers=== host: localhost

===Headers=== connection: close

===Headers=== accept-encoding: gzip, deflate, br

===Headers=== user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36

===Headers=== sec-fetch-dest: empty

================ Request End ================

2020-05-18 00:29:51.636 INFO 2895 --- [ XNIO-1 task-9] o.s.core.log.aspect.RequestLogAspect :

================ Request Start ================

===> GET: /blade-system/dict/dictionary Parameters: {"code":"flow"}

===Headers=== sec-fetch-mode: cors

===Headers=== referer: http://localhost:1888/

===Headers=== sec-fetch-site: same-origin

===Headers=== accept-language: zh-CN,zh;q=0.9,en;q=0.8

===Headers=== x-forwarded-proto: http

===Headers=== x-forwarded-port: 1888

===Headers=== x-forwarded-for: 127.0.0.1

===Headers=== accept: application/json, text/plain, */*

===Headers=== authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers=== x-forwarded-host: localhost:1888

===Headers=== host: localhost

===Headers=== connection: close

===Headers=== accept-encoding: gzip, deflate, br

===Headers=== user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36

===Headers=== sec-fetch-dest: empty

================ Request End ================

2020-05-18 00:29:51.637 INFO 2895 --- [ XNIO-1 task-8] o.s.core.log.aspect.RequestLogAspect :

================ Request Start ================

===> GET: /blade-user/page Parameters: {"query":{"current":1,"size":10,"ascs":null,"descs":null},"deptId":null,"bladeUser":{"clientId":"saber","userId":1123598821738675201,"account":"admin","userName":"admin","nickName":"管理员","tenantId":"000000","deptId":"1123598813738675201","postId":"1123598817738675201","roleId":"1123598816738675201","roleName":"administrator"},"user":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"tenantId":null,"code":null,"account":null,"password":null,"name":null,"realName":null,"avatar":null,"email":null,"phone":null,"birthday":null,"sex":null,"roleId":null,"deptId":"","postId":null}}

===Headers=== sec-fetch-mode: cors

===Headers=== referer: http://localhost:1888/

===Headers=== sec-fetch-site: same-origin

===Headers=== accept-language: zh-CN,zh;q=0.9,en;q=0.8

===Headers=== x-forwarded-proto: http

===Headers=== x-forwarded-port: 1888

===Headers=== x-forwarded-for: 127.0.0.1

===Headers=== accept: application/json, text/plain, */*

===Headers=== authorization: Basic c2FiZXI6c2FiZXJfc2VjcmV0

===Headers=== x-forwarded-host: localhost:1888

===Headers=== host: localhost

===Headers=== connection: close

===Headers=== accept-encoding: gzip, deflate, br

===Headers=== user-agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/81.0.4044.138 Safari/537.36

===Headers=== sec-fetch-dest: empty

================ Request End ================

2020-05-18 00:29:51.647 DEBUG 2895 --- [ XNIO-1 task-7] o.s.m.system.mapper.DeptMapper.lazyTree : ==> Preparing: SELECT dept.id, dept.parent_id, dept.dept_name AS title, dept.id AS "value", dept.id AS "key", ( SELECT CASE WHEN count(1) > 0 THEN 1 ELSE 0 END FROM blade_dept WHERE parent_id = dept.id and is_deleted = 0 ) AS "has_children" FROM blade_dept dept WHERE dept.parent_id = ? AND dept.is_deleted = 0 ORDER BY dept.sort

2020-05-18 00:29:51.648 DEBUG 2895 --- [ XNIO-1 task-7] o.s.core.tenant.BladeTenantSqlParser : Original SQL: SELECT

dept.id,

dept.parent_id,

dept.dept_name AS title,

dept.id AS "value",

dept.id AS "key",

(

SELECT

CASE WHEN count(1) > 0 THEN 1 ELSE 0 END

FROM

blade_dept

WHERE

parent_id = dept.id and is_deleted = 0

) AS "has_children"

FROM

blade_dept dept

WHERE

dept.parent_id = ? AND dept.is_deleted = 0

ORDER BY dept.sort

2020-05-18 00:29:51.650 DEBUG 2895 --- [ XNIO-1 task-7] o.s.core.tenant.BladeTenantSqlParser : parser sql: SELECT dept.id, dept.parent_id, dept.dept_name AS title, dept.id AS "value", dept.id AS "key", (SELECT CASE WHEN count(1) > 0 THEN 1 ELSE 0 END FROM blade_dept WHERE parent_id = dept.id AND is_deleted = 0) AS "has_children" FROM blade_dept dept WHERE dept.parent_id = ? AND dept.is_deleted = 0 ORDER BY dept.sort

2020-05-18 00:29:51.651 DEBUG 2895 --- [ XNIO-1 task-7] o.s.m.system.mapper.DeptMapper.lazyTree : ==> Preparing: SELECT dept.id, dept.parent_id, dept.dept_name AS title, dept.id AS "value", dept.id AS "key", (SELECT CASE WHEN count(1) > 0 THEN 1 ELSE 0 END FROM blade_dept WHERE parent_id = dept.id AND is_deleted = 0) AS "has_children" FROM blade_dept dept WHERE dept.parent_id = ? AND dept.is_deleted = 0 ORDER BY dept.sort

2020-05-18 00:29:51.652 DEBUG 2895 --- [ XNIO-1 task-6] o.s.m.system.mapper.MenuMapper.allMenu : ==> Preparing: select * from blade_menu where is_deleted = 0 and category = 1

2020-05-18 00:29:51.653 DEBUG 2895 --- [ XNIO-1 task-6] o.s.core.tenant.BladeTenantSqlParser : Original SQL: select * from blade_menu where is_deleted = 0 and category = 1

2020-05-18 00:29:51.653 DEBUG 2895 --- [ XNIO-1 task-6] o.s.core.tenant.BladeTenantSqlParser : parser sql: SELECT * FROM blade_menu WHERE is_deleted = 0 AND category = 1

2020-05-18 00:29:51.654 DEBUG 2895 --- [ XNIO-1 task-6] o.s.m.system.mapper.MenuMapper.allMenu : ==> Preparing: SELECT * FROM blade_menu WHERE is_deleted = 0 AND category = 1

2020-05-18 00:29:51.655 DEBUG 2895 --- [ XNIO-1 task-7] o.s.m.system.mapper.DeptMapper.lazyTree : ==> Parameters: 0(Long)

2020-05-18 00:29:51.659 DEBUG 2895 --- [ XNIO-1 task-6] o.s.m.system.mapper.MenuMapper.allMenu : ==> Parameters:

2020-05-18 00:29:51.665 INFO 2895 --- [ XNIO-1 task-7] o.s.core.log.aspect.RequestLogAspect :

================ Response Start ================

<=== GET: /blade-system/dept/lazy-tree (32 ms)

================ Response End ================

2020-05-18 00:29:51.666 ERROR 2895 --- [ XNIO-1 task-7] o.s.c.l.e.BladeRestExceptionTranslator : 服务器异常

org.springframework.jdbc.UncategorizedSQLException:

### Error querying database. Cause: java.sql.SQLException: 2Unknown exception: [null]

### The error may exist in file [/Users/yaorao/BladeX-Boot/target/classes/org/springblade/modules/system/mapper/DeptMapper.xml]

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: SELECT dept.id, dept.parent_id, dept.dept_name AS title, dept.id AS "value", dept.id AS "key", (SELECT CASE WHEN count(1) > 0 THEN 1 ELSE 0 END FROM blade_dept WHERE parent_id = dept.id AND is_deleted = 0) AS "has_children" FROM blade_dept dept WHERE dept.parent_id = ? AND dept.is_deleted = 0 ORDER BY dept.sort

### Cause: java.sql.SQLException: 2Unknown exception: [null]

; uncategorized SQLException; SQL state [C1000]; error code [10002]; 2Unknown exception: [null]; nested exception is java.sql.SQLException: 2Unknown exception: [null]

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88)

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)

at com.sun.proxy.$Proxy121.selectList(Unknown Source)

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:177)

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78)

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)

at com.sun.proxy.$Proxy138.lazyTree(Unknown Source)

at org.springblade.modules.system.service.impl.DeptServiceImpl.lazyTree(DeptServiceImpl.java:70)

at org.springblade.modules.system.service.impl.DeptServiceImpl$$FastClassBySpringCGLIB$$11fc28c6.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)

at org.springblade.modules.system.service.impl.DeptServiceImpl$$EnhancerBySpringCGLIB$$f770f901.lazyTree()

at org.springblade.modules.system.controller.DeptController.lazyTree(DeptController.java:123)

at org.springblade.modules.system.controller.DeptController$$FastClassBySpringCGLIB$$ff857828.invoke()

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)

at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:750)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)

at org.springblade.core.secure.aspect.AuthAspect.preAuth(AuthAspect.java:67)

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.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)

at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)

at org.springblade.core.log.aspect.RequestLogAspect.aroundApi(RequestLogAspect.java:111)

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.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644)

at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633)

at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)

at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)

at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)

at org.springblade.modules.system.controller.DeptController$$EnhancerBySpringCGLIB$$e73e45e6.lazyTree()

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:190)

at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:893)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:798)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)

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.github.xiaoymin.knife4j.spring.filter.ProductionSecurityFilter.doFilter(ProductionSecurityFilter.java:53)

at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)