一、该问题的重现步骤是什么?
自定义服务中集成了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
四、请提供详细的错误堆栈信息,这很重要。
五、若有更多详细信息,请在下面提供。
该服务未做任何数据权限 的相关配置,代码中所有方法也没有任务数据权限的相关注解
扫一扫访问 Blade技术社区 移动端