一、该问题的重现步骤是什么？
自定义服务中集成了shardingsphere用以分表，该服务的库是单独的数据库，在idea中运行 所有数据接口正常，但打包部署的程序 所有接口报错，其错误是在该服务中找不到数据权限的表
两种环境 所使用的基础环境都是一致的，同一个数据库，redis ，ncaos 等 唯一差别是在nacos中读取到的配置所在命名空间不一样，但所有配置是一致的
2.
3.
二、你期待的结果是什么？实际看到的又是什么？
在idea上运行的正常请求
================ Request Start ================
===> GET: /provinceModeConfig/list Parameters: {"query":{"current":1,"size":100,"ascs":null,"descs":null},"provinceModeConfig":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"year":2020,"provinceCode":null,"modeCode":null,"subjectCode":null,"batchYear":null,"collegeYear":null,"majorYear":null,"scoreYear":null,"planYear":null}}
===Headers=== Cookie: saber-access-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJ1c2VyX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicmVhbF9uYW1lIjoi566h55CG5ZGYIiwicm9sZV9jbl9uYW1lIjoiIiwidGVuYW50X2lkcyI6IjAwMDAwMCw4OTQ2MzgsNTQyMjY4LDc1MjM5NSwxNjQ0MTMsNTk1MTQ1LDQ2MTMyMCw0NDM0MDIsMjExOTEyLDE3NzcxNiw4MzI2MzYsNDg2NTkzLDk1MzgzMSw4MjkxOTcsNjQxMDQ5LDk3MTMzMiwzNDk1NjksOTIzNzE3LDQ3OTg5OSIsImF2YXRhciI6Imh0dHBzOi8vZnMtc2VudGltZW50Lm9zcy1jbi1iZWlqaW5nLmFsaXl1bmNzLmNvbS91cGxvYWQvMjAyMDA3MjMvYjJiMGU4Mjc1Mjg2Nzk1MmQyNDU1MmNkYTM0NGMxMDEucG5nIiwiYXV0aG9yaXRpZXMiOlsiYWRtaW5pc3RyYXRvciJdLCJjbGllbnRfaWQiOiJzYWJlciIsInJvbGVfbmFtZSI6ImFkbWluaXN0cmF0b3IiLCJsaWNlbnNlIjoicG93ZXJlZCBieSBibGFkZXgiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwic2NvcGUiOlsiYWxsIl0sIm5pY2tfbmFtZSI6IueuoeeQhuWRmCIsImV4cCI6MTU5Nzc0MTU1MywiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEsMTEyMzU5ODgxMzczODY3NTIwMiwxMTIzNTk4ODEzNzM4Njc1MjAzIiwianRpIjoiY2VhNjA4YzktZjk4Ny00NDBkLWIxZWQtNTNiNjkzY2VlNGQyIiwiYWNjb3VudCI6ImFkbWluaXN0cmF0b3IifQ.l2qHa-2_NgRL0HAaj3Nu1SNo58uP3y4e-ZSK6MKXDP0; saber-refresh-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJ1c2VyX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicmVhbF9uYW1lIjoi566h55CG5ZGYIiwicm9sZV9jbl9uYW1lIjoiIiwidGVuYW50X2lkcyI6IjAwMDAwMCw4OTQ2MzgsNTQyMjY4LDc1MjM5NSwxNjQ0MTMsNTk1MTQ1LDQ2MTMyMCw0NDM0MDIsMjExOTEyLDE3NzcxNiw4MzI2MzYsNDg2NTkzLDk1MzgzMSw4MjkxOTcsNjQxMDQ5LDk3MTMzMiwzNDk1NjksOTIzNzE3LDQ3OTg5OSIsImF2YXRhciI6Imh0dHBzOi8vZnMtc2VudGltZW50Lm9zcy1jbi1iZWlqaW5nLmFsaXl1bmNzLmNvbS91cGxvYWQvMjAyMDA3MjMvYjJiMGU4Mjc1Mjg2Nzk1MmQyNDU1MmNkYTM0NGMxMDEucG5nIiwiYXV0aG9yaXRpZXMiOlsiYWRtaW5pc3RyYXRvciJdLCJjbGllbnRfaWQiOiJzYWJlciIsInJvbGVfbmFtZSI6ImFkbWluaXN0cmF0b3IiLCJsaWNlbnNlIjoicG93ZXJlZCBieSBibGFkZXgiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwic2NvcGUiOlsiYWxsIl0sIm5pY2tfbmFtZSI6IueuoeeQhuWRmCIsImF0aSI6ImNlYTYwOGM5LWY5ODctNDQwZC1iMWVkLTUzYjY5M2NlZTRkMiIsImV4cCI6MTU5ODM0Mjc1MywiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEsMTEyMzU5ODgxMzczODY3NTIwMiwxMTIzNTk4ODEzNzM4Njc1MjAzIiwianRpIjoiYjdmMTJhOWQtN2Y5NC00MjIwLTg0NDQtNWEyZDFhMWEwNzNkIiwiYWNjb3VudCI6ImFkbWluaXN0cmF0b3IifQ.0zVXIGW123elEEZHhcttpjmn1zZXdlkgBKsNpErP1U0; auth-access-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiZXhwIjoxNTk3NzQxNjM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6ImQwYjA5ZGFhLWFiYTItNGViNy04OTVjLWI4ZjE2MTdmYWRlYyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.GDkUDiCVxoDVqn_5Cv2M6kOnNLno6Kvf0cBDHgZyieI; auth-refresh-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiYXRpIjoiZDBiMDlkYWEtYWJhMi00ZWI3LTg5NWMtYjhmMTYxN2ZhZGVjIiwiZXhwIjoxNTk4MzQyODM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6IjUyY2E5YmUwLTM5MmYtNGI5YS04ZWY2LWRhODFhMmUyYWJjNyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.RWUNxsjOFQy6IiopNQtPNzHOYmr2sltyWrLvLJPPY0g
===Headers=== content-length: 0
===Headers=== X-Forwarded-Prefix: /edu-uk-base
===Headers=== Accept: application/json, text/plain, */*
===Headers=== Referer: http://192.168.20.6/ukBase/
===Headers=== X-Forwarded-Host: 192.168.20.6
===Headers=== User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36
===Headers=== X-Forwarded-Proto: http
===Headers=== Accept-Encoding: gzip, deflate
===Headers=== X-Forwarded-Port: 80
===Headers=== Authorization: Basic dWtCYXNlX2FkbWluOnVrQmFzZWRxdWlkb0Fvd2pGOHF3RnhmR3E0NGtNQmVnQw==
===Headers=== host: 192.168.20.118:8231
===Headers=== Forwarded: proto=http;host=192.168.20.6;for="192.168.20.6:58342"
===Headers=== X-Forwarded-For: 192.168.20.118,192.168.20.6
===Headers=== Accept-Language: zh-CN,zh;q=0.9
===Headers=== X-Real-IP: 192.168.20.118
===Headers=== Blade-Auth: bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiZXhwIjoxNTk3NzQxNjM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6ImQwYjA5ZGFhLWFiYTItNGViNy04OTVjLWI4ZjE2MTdmYWRlYyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.GDkUDiCVxoDVqn_5Cv2M6kOnNLno6Kvf0cBDHgZyieI
================ Request End ================
2020-08-18 16:41:32.447 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : --> GET http://192.168.20.8:8106/client/data-scope/by-mapper?mapperId=cn.jzcloud.ukbase.province.mapper.ProvinceModeConfigMapper.selectPage&roleId=1288351142643765250
2020-08-18 16:41:32.447 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : Authorization: Basic dWtCYXNlX2FkbWluOnVrQmFzZWRxdWlkb0Fvd2pGOHF3RnhmR3E0NGtNQmVnQw==
2020-08-18 16:41:32.447 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : Blade-Auth: bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiZXhwIjoxNTk3NzQxNjM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6ImQwYjA5ZGFhLWFiYTItNGViNy04OTVjLWI4ZjE2MTdmYWRlYyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.GDkUDiCVxoDVqn_5Cv2M6kOnNLno6Kvf0cBDHgZyieI
2020-08-18 16:41:32.447 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : X-Real-IP: 192.168.20.118
2020-08-18 16:41:32.447 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : Accept: */*
2020-08-18 16:41:32.447 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : --> END GET
2020-08-18 16:41:32.459 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : <-- 200 OK http://192.168.20.8:8106/client/data-scope/by-mapper?mapperId=cn.jzcloud.ukbase.province.mapper.ProvinceModeConfigMapper.selectPage&roleId=1288351142643765250 (11ms)
2020-08-18 16:41:32.459 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : Connection: keep-alive
2020-08-18 16:41:32.459 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : Content-Length: 0
2020-08-18 16:41:32.459 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : Date: Tue, 18 Aug 2020 08:41:34 GMT
2020-08-18 16:41:32.459 INFO 24388 --- [blade-system-66] o.s.core.cloud.http.OkHttpSlf4jLogger : <-- END HTTP (0-byte body)
2020-08-18 16:41:32.465 DEBUG 24388 --- [ XNIO-1 task-17] o.s.core.tenant.BladeTenantSqlParser : Original SQL: SELECT id,year,province_code,mode_code,subject_code,batch_year,college_year,major_year,score_year,plan_year,create_user,create_dept,create_time,update_user,update_time,status,is_deleted FROM uk_province_mode_config
WHERE year=? AND is_deleted=0
2020-08-18 16:41:32.466 DEBUG 24388 --- [ XNIO-1 task-17] o.s.core.tenant.BladeTenantSqlParser : parser sql: SELECT id, year, province_code, mode_code, subject_code, batch_year, college_year, major_year, score_year, plan_year, create_user, create_dept, create_time, update_user, update_time, status, is_deleted FROM uk_province_mode_config WHERE year = ? AND is_deleted = 0
============== Sql Start ==============
Execute ID ：cn.jzcloud.ukbase.province.mapper.ProvinceModeConfigMapper.selectPage
Execute SQL ：org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement@349272ba
Execute Time：3 ms
============== Sql End ==============
2020-08-18 16:41:32.479 INFO 24388 --- [ XNIO-1 task-17] o.s.core.log.aspect.RequestLogAspect :
================ Response Start ================
===Result=== {"code":200,"success":true,"data":{"records":[{"id":"1290162472217456642","createUser":"1288351584920539138","createDept":"1288351150503890946","createTime":"2020-08-03 13:47:58","updateUser":"1288351584920539138","updateTime":"2020-08-08 17:15:46","status":1,"isDeleted":0,"year":2020,"provinceCode":"11","modeCode":"normal","subjectCode":"seven_three","batchYear":2019,"collegeYear":2019,"majorYear":2020,"scoreYear":2019,"planYear":2019},{"id":"1290211451957391361","createUser":"1288351584920539138","createDept":"1288351150503890946","createTime":"2020-08-03 17:02:36","updateUser":"1288351584920539138","updateTime":"2020-08-03 17:02:36","status":1,"isDeleted":0,"year":2020,"provinceCode":"51","modeCode":"normal_mode","subjectCode":"normal","batchYear":2020,"collegeYear":2019,"majorYear":2019,"scoreYear":2020,"planYear":2020}],"total":2,"size":100,"current":1,"orders":[],"optimizeCountSql":true,"hitCount":false,"searchCount":true,"pages":1},"msg":"操作成功"}
<=== GET: /provinceModeConfig/list (42 ms)
================ Response End ================在docker 中运行程序 报错信息如下
================ Request Start ================
===> GET: /provinceModeConfig/list Parameters: {"query":{"current":1,"size":100,"ascs":null,"descs":null},"provinceModeConfig":{"id":null,"createUser":null,"createDept":null,"createTime":null,"updateUser":null,"updateTime":null,"status":null,"isDeleted":null,"year":2020,"provinceCode":null,"modeCode":null,"subjectCode":null,"batchYear":null,"collegeYear":null,"majorYear":null,"scoreYear":null,"planYear":null}}
===Headers=== Cookie: auth-access-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiZXhwIjoxNTk3NzQxNjM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6ImQwYjA5ZGFhLWFiYTItNGViNy04OTVjLWI4ZjE2MTdmYWRlYyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.GDkUDiCVxoDVqn_5Cv2M6kOnNLno6Kvf0cBDHgZyieI; auth-refresh-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiYXRpIjoiZDBiMDlkYWEtYWJhMi00ZWI3LTg5NWMtYjhmMTYxN2ZhZGVjIiwiZXhwIjoxNTk4MzQyODM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6IjUyY2E5YmUwLTM5MmYtNGI5YS04ZWY2LWRhODFhMmUyYWJjNyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.RWUNxsjOFQy6IiopNQtPNzHOYmr2sltyWrLvLJPPY0g; saber-access-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJ1c2VyX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicmVhbF9uYW1lIjoi566h55CG5ZGYIiwicm9sZV9jbl9uYW1lIjoiIiwidGVuYW50X2lkcyI6IjAwMDAwMCw4OTQ2MzgsNTQyMjY4LDc1MjM5NSwxNjQ0MTMsNTk1MTQ1LDQ2MTMyMCw0NDM0MDIsMjExOTEyLDE3NzcxNiw4MzI2MzYsNDg2NTkzLDk1MzgzMSw4MjkxOTcsNjQxMDQ5LDk3MTMzMiwzNDk1NjksOTIzNzE3LDQ3OTg5OSIsImF2YXRhciI6Imh0dHBzOi8vZnMtc2VudGltZW50Lm9zcy1jbi1iZWlqaW5nLmFsaXl1bmNzLmNvbS91cGxvYWQvMjAyMDA3MjMvYjJiMGU4Mjc1Mjg2Nzk1MmQyNDU1MmNkYTM0NGMxMDEucG5nIiwiYXV0aG9yaXRpZXMiOlsiYWRtaW5pc3RyYXRvciJdLCJjbGllbnRfaWQiOiJzYWJlciIsInJvbGVfbmFtZSI6ImFkbWluaXN0cmF0b3IiLCJsaWNlbnNlIjoicG93ZXJlZCBieSBibGFkZXgiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwic2NvcGUiOlsiYWxsIl0sIm5pY2tfbmFtZSI6IueuoeeQhuWRmCIsImV4cCI6MTU5Nzc0NDU1NCwiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEsMTEyMzU5ODgxMzczODY3NTIwMiwxMTIzNTk4ODEzNzM4Njc1MjAzIiwianRpIjoiMWZiYTU5OGMtZDhmMy00NjViLWI0YWEtNWNkYzAyZGIxOWZiIiwiYWNjb3VudCI6ImFkbWluaXN0cmF0b3IifQ.GLeOAsEH3EmCLHl0B_5j4Oo-OO_kKp4rbVpGVluiu-U; saber-refresh-token=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwMDAwMDAiLCJ1c2VyX25hbWUiOiJhZG1pbmlzdHJhdG9yIiwicmVhbF9uYW1lIjoi566h55CG5ZGYIiwicm9sZV9jbl9uYW1lIjoiIiwidGVuYW50X2lkcyI6IjAwMDAwMCw4OTQ2MzgsNTQyMjY4LDc1MjM5NSwxNjQ0MTMsNTk1MTQ1LDQ2MTMyMCw0NDM0MDIsMjExOTEyLDE3NzcxNiw4MzI2MzYsNDg2NTkzLDk1MzgzMSw4MjkxOTcsNjQxMDQ5LDk3MTMzMiwzNDk1NjksOTIzNzE3LDQ3OTg5OSIsImF2YXRhciI6Imh0dHBzOi8vZnMtc2VudGltZW50Lm9zcy1jbi1iZWlqaW5nLmFsaXl1bmNzLmNvbS91cGxvYWQvMjAyMDA3MjMvYjJiMGU4Mjc1Mjg2Nzk1MmQyNDU1MmNkYTM0NGMxMDEucG5nIiwiYXV0aG9yaXRpZXMiOlsiYWRtaW5pc3RyYXRvciJdLCJjbGllbnRfaWQiOiJzYWJlciIsInJvbGVfbmFtZSI6ImFkbWluaXN0cmF0b3IiLCJsaWNlbnNlIjoicG93ZXJlZCBieSBibGFkZXgiLCJ1c2VyX2lkIjoiMTEyMzU5ODgyMTczODY3NTIwMSIsInJvbGVfaWQiOiIxMTIzNTk4ODE2NzM4Njc1MjAxIiwic2NvcGUiOlsiYWxsIl0sIm5pY2tfbmFtZSI6IueuoeeQhuWRmCIsImF0aSI6IjFmYmE1OThjLWQ4ZjMtNDY1Yi1iNGFhLTVjZGMwMmRiMTlmYiIsImV4cCI6MTU5ODM0Mjc1MywiZGVwdF9pZCI6IjExMjM1OTg4MTM3Mzg2NzUyMDEsMTEyMzU5ODgxMzczODY3NTIwMiwxMTIzNTk4ODEzNzM4Njc1MjAzIiwianRpIjoiYjdmMTJhOWQtN2Y5NC00MjIwLTg0NDQtNWEyZDFhMWEwNzNkIiwiYWNjb3VudCI6ImFkbWluaXN0cmF0b3IifQ.gfPBCWmFHemCTeEGT5yqv3_48SORSbmNO7wVS_hcmmU
===Headers=== content-length: 0
===Headers=== X-Forwarded-Prefix: /edu-uk-base
===Headers=== Accept: application/json, text/plain, */*
===Headers=== Referer: http://192.168.20.6/ukBase/
===Headers=== X-Forwarded-Host: 192.168.20.6
===Headers=== User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36
===Headers=== X-Forwarded-Proto: http
===Headers=== Accept-Encoding: gzip, deflate
===Headers=== X-Forwarded-Port: 80
===Headers=== Authorization: Basic dWtCYXNlX2FkbWluOnVrQmFzZWRxdWlkb0Fvd2pGOHF3RnhmR3E0NGtNQmVnQw==
===Headers=== host: 192.168.20.6:8231
===Headers=== Forwarded: proto=http;host=192.168.20.6;for="192.168.20.6:51778"
===Headers=== X-Forwarded-For: 192.168.20.118,192.168.20.6
===Headers=== Accept-Language: zh-CN,zh;q=0.9
===Headers=== X-Real-IP: 192.168.20.118
===Headers=== Blade-Auth: bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ0ZW5hbnRfaWQiOiIwNzYwODMiLCJ1c2VyX25hbWUiOiJhZG1pbl9qenp5IiwicmVhbF9uYW1lIjoi5bCPeeeuoeeQhuWRmCIsInJvbGVfY25fbmFtZSI6IiIsInRlbmFudF9pZHMiOiIwNzYwODMiLCJhdmF0YXIiOiJodHRwczovL2ZzLXNlbnRpbWVudC5vc3MtY24tYmVpamluZy5hbGl5dW5jcy5jb20vdXBsb2FkLzIwMjAwNzMwL2Y1MTAzYzBkZTM3M2ZiNDhmZjY0ZDBiNjU5MzUyN2I0LmpwZyIsImF1dGhvcml0aWVzIjpbImFkbWluIl0sImNsaWVudF9pZCI6InVrQmFzZV9hZG1pbiIsInJvbGVfbmFtZSI6ImFkbWluIiwibGljZW5zZSI6InBvd2VyZWQgYnkgYmxhZGV4IiwidXNlcl9pZCI6IjEyODgzNTE1ODQ5MjA1MzkxMzgiLCJyb2xlX2lkIjoiMTI4ODM1MTE0MjY0Mzc2NTI1MCIsInNjb3BlIjpbImFsbCJdLCJuaWNrX25hbWUiOiLlsI95566h55CG5ZGYIiwiZXhwIjoxNTk3NzQxNjM1LCJkZXB0X2lkIjoiMTI4ODM1MTE1MDUwMzg5MDk0NiIsImp0aSI6ImQwYjA5ZGFhLWFiYTItNGViNy04OTVjLWI4ZjE2MTdmYWRlYyIsImFjY291bnQiOiJhZG1pbl9qenp5In0.GDkUDiCVxoDVqn_5Cv2M6kOnNLno6Kvf0cBDHgZyieI
================ Request End ================
2020-08-18 17:02:14.871 INFO 1 --- [ XNIO-1 task-6] o.s.core.log.aspect.RequestLogAspect :
================ Response Start ================
<=== GET: /provinceModeConfig/list (21 ms)
================ Response End ================
2020-08-18 17:02:14.876 ERROR 1 --- [ XNIO-1 task-6] o.s.c.l.e.BladeRestExceptionTranslator : 服务器异常
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?))]; nested exception is java.sql.SQLSyntaxErrorException: Table 'edu_uk_base.blade_scope_data' doesn't exist
### The error may exist in cn/jzcloud/ukbase/province/mapper/ProvinceModeConfigMapper.java (best guess)
### The error may involve cn.jzcloud.ukbase.province.mapper.ProvinceModeConfigMapper.selectPage
### The error occurred while executing a query
### Cause: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?))]; nested exception is java.sql.SQLSyntaxErrorException: Table 'edu_uk_base.blade_scope_data' doesn't exist
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
at com.sun.proxy.$Proxy180.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:134)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:96)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
at com.sun.proxy.$Proxy213.selectPage(Unknown Source)
at com.baomidou.mybatisplus.extension.service.IService.page(IService.java:294)
at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:752)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:120)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
at cn.jzcloud.ukbase.province.service.impl.ProvinceModeConfigServiceImpl$$EnhancerBySpringCGLIB$$5403186f.page()
at cn.jzcloud.ukbase.province.controller.ProvinceModeConfigController.list(ProvinceModeConfigController.java:53)
at cn.jzcloud.ukbase.province.controller.ProvinceModeConfigController$$FastClassBySpringCGLIB$$4753f320.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:752)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88)
at org.springblade.core.log.aspect.RequestLogAspect.aroundApi(RequestLogAspect.java:111)
at sun.reflect.GeneratedMethodAccessor196.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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:691)
at cn.jzcloud.ukbase.province.controller.ProvinceModeConfigController$$EnhancerBySpringCGLIB$$f64e5ba1.list()
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
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)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at com.github.xiaoymin.knife4j.spring.filter.SecurityBasicAuthFilter.doFilter(SecurityBasicAuthFilter.java:90)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springblade.core.tool.request.BladeRequestFilter.doFilter(BladeRequestFilter.java:49)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springblade.core.log.filter.LogTraceFilter.doFilter(LogTraceFilter.java:39)
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.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
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:119)
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:119)
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.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:94)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
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.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
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:119)
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:132)
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.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
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:249)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?))]; nested exception is java.sql.SQLSyntaxErrorException: Table 'edu_uk_base.blade_scope_data' doesn't exist
### The error may exist in cn/jzcloud/ukbase/province/mapper/ProvinceModeConfigMapper.java (best guess)
### The error may involve cn.jzcloud.ukbase.province.mapper.ProvinceModeConfigMapper.selectPage
### The error occurred while executing a query
### Cause: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?))]; nested exception is java.sql.SQLSyntaxErrorException: Table 'edu_uk_base.blade_scope_data' doesn't exist
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:149)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at sun.reflect.GeneratedMethodAccessor197.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 118 common frames omitted
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select resource_code, scope_column, scope_field, scope_type, scope_value from blade_scope_data where scope_class = ? and id in (select scope_id from blade_role_scope where scope_category = 1 and role_id in (?))]; nested exception is java.sql.SQLSyntaxErrorException: Table 'edu_uk_base.blade_scope_data' doesn't exist
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:235)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1443)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:669)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:700)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:712)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:763)
at org.springblade.core.datascope.handler.BladeScopeModelHandler.getDataScopeByMapper(BladeScopeModelHandler.java:63)
at org.springblade.core.datascope.handler.BladeDataScopeHandler.sqlCondition(BladeDataScopeHandler.java:51)
at org.springblade.core.datascope.interceptor.DataScopeInterceptor.intercept(DataScopeInterceptor.java:114)
at org.springblade.core.mp.plugins.QueryInterceptorExecutor.exec(QueryInterceptorExecutor.java:46)
at org.springblade.core.mp.plugins.BladePaginationInterceptor.intercept(BladePaginationInterceptor.java:48)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy276.prepare(Unknown Source)
at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
at com.sun.proxy.$Proxy276.prepare(Unknown Source)
at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:92)
at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doQuery(MybatisSimpleExecutor.java:66)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
... 123 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Table 'edu_uk_base.blade_scope_data' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3240)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:3237)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:181)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
at org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor.getQueryResult(PreparedStatementExecutor.java:115)
at org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor.access$200(PreparedStatementExecutor.java:51)
at org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor$2.executeSQL(PreparedStatementExecutor.java:107)
at org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor$2.executeSQL(PreparedStatementExecutor.java:103)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute0(SQLExecuteCallback.java:69)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteCallback.execute(SQLExecuteCallback.java:58)
at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:126)
at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.parallelExecute(ShardingExecuteEngine.java:103)
at org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:83)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:73)
at org.apache.shardingsphere.core.execute.sql.execute.SQLExecuteTemplate.executeGroup(SQLExecuteTemplate.java:56)
at org.apache.shardingsphere.shardingjdbc.executor.AbstractStatementExecutor.executeCallback(AbstractStatementExecutor.java:128)
at org.apache.shardingsphere.shardingjdbc.executor.PreparedStatementExecutor.executeQuery(PreparedStatementExecutor.java:110)
at org.apache.shardingsphere.shardingjdbc.jdbc.core.statement.ShardingPreparedStatement.executeQuery(ShardingPreparedStatement.java:112)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:678)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:617)
... 145 common frames omitted 三、你正在使用的是什么产品，什么版本？在什么操作系统上？
bladeX2.5.1
开发在win10
docker 在centos7.4
四、请提供详细的错误堆栈信息，这很重要。
五、若有更多详细信息，请在下面提供。
该服务未做任何数据权限 的相关配置，代码中所有方法也没有任务数据权限的相关注解
如果在开发环境可以正常运行而服务器不行，那基本可以说明代码没问题是配置或环境导致的问题。你尝试如下操作下：
1. 将服务器的所有配置包括命名空间也配置的与本地开发环境一致，看看是否可行
2. 如果不行则将本地环境连接至服务器nacos，获取服务器的配置，看看本地运行是否可行
3. 如果不可行则在本地部署一套，看看idea与本地部署读取本地同样的配置是否有问题
4. 如果都不行，那就需要好好检查下，看看报错的api调用到的是哪个库，对应的库是否有这个scope表，如果没有则需要做远程调用
5. 具体帖子参考：https://sns.bladex.cn/q-1448.html
从日志来看， 本地环境中，走的就是远程调用，但在docker内运行的，就在当前服务中查询了！
看样子是，这个需要去打日志来排查，为何部署的时候没有去远程调用。
推荐先打jar包，然后本地运行看看，等本地的jar运行通过了，再打docker到服务器运行
扫一扫访问 Blade技术社区 移动端
加载中...
苏公网安备 32041102000998号