shardingsphere分表 数据权限表不存在的问题

Blade 已结 2 1390
ivan_lee
ivan_lee 剑圣 2020-08-18 15:17

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

  1. 自定义服务中集成了shardingsphere用以分表,该服务的库是单独的数据库,在idea中运行  所有数据接口正常,但打包部署的程序 所有接口报错,其错误是在该服务中找不到数据权限的表

  2. 两种环境 所使用的基础环境都是一致的,同一个数据库,redis ,ncaos 等  唯一差别是在nacos中读取到的配置所在命名空间不一样,但所有配置是一致的

  3. 图片.png图片.png


2.

图片.png

3.

图片.png

图片.png


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

在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(<generated>)
        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(<generated>)
        at cn.jzcloud.ukbase.province.controller.ProvinceModeConfigController.list(ProvinceModeConfigController.java:53)
        at cn.jzcloud.ukbase.province.controller.ProvinceModeConfigController$$FastClassBySpringCGLIB$$4753f320.invoke(<generated>)
        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(<generated>)
        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

四、请提供详细的错误堆栈信息,这很重要。


五、若有更多详细信息,请在下面提供。

 该服务未做任何数据权限 的相关配置,代码中所有方法也没有任务数据权限的相关注解


2条回答
  •  smallchill
    smallchill (最佳回答者)
    2020-08-18 17:04

    如果在开发环境可以正常运行而服务器不行,那基本可以说明代码没问题是配置或环境导致的问题。你尝试如下操作下:

     1. 将服务器的所有配置包括命名空间也配置的与本地开发环境一致,看看是否可行

     2. 如果不行则将本地环境连接至服务器nacos,获取服务器的配置,看看本地运行是否可行

     3. 如果不可行则在本地部署一套,看看idea与本地部署读取本地同样的配置是否有问题

     4. 如果都不行,那就需要好好检查下,看看报错的api调用到的是哪个库,对应的库是否有这个scope表,如果没有则需要做远程调用

     5. 具体帖子参考:https://sns.bladex.cn/q-1448.html

    作者追问:2020-08-18 17:04

    从日志来看, 本地环境中,走的就是远程调用,但在docker内运行的,就在当前服务中查询了!

    回答: 2020-08-18 17:04

    看样子是,这个需要去打日志来排查,为何部署的时候没有去远程调用。

    推荐先打jar包,然后本地运行看看,等本地的jar运行通过了,再打docker到服务器运行

    0 讨论(1)
  • 2020-08-18 17:50

    谢谢  问题已解决!

    该服务和api模块都没有依懒 blade-scope-api,但在api 父模块有依懒,所以在idea中是正常的,一打包就不能远程调用了



    0 讨论(0)
提交回复