一、该问题的重现步骤是什么?
已导入
1.
2.
3.
二、你期待的结果是什么?实际看到的又是什么?
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
BladeX-Boot,windows10
四、请提供详细的错误堆栈信息,这很重要。
2021-01-30 00:54:51.194 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : original SQL: SELECT id,tenant_id,tenant_name,domain,background_url,linkman,contact_number,address,account_number,expire_time,datasource_id,license_key,create_user,create_dept,create_time,update_user,update_time,status,is_deleted FROM blade_tenant
WHERE is_deleted=0
AND (tenant_id = ?)
2021-01-30 00:54:51.194 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : SQL to parse, SQL: SELECT id,tenant_id,tenant_name,domain,background_url,linkman,contact_number,address,account_number,expire_time,datasource_id,license_key,create_user,create_dept,create_time,update_user,update_time,status,is_deleted FROM blade_tenant
WHERE is_deleted=0
AND (tenant_id = ?)
2021-01-30 00:54:51.194 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : parse the finished SQL: SELECT id, tenant_id, tenant_name, domain, background_url, linkman, contact_number, address, account_number, expire_time, datasource_id, license_key, create_user, create_dept, create_time, update_user, update_time, status, is_deleted FROM blade_tenant WHERE is_deleted = 0 AND (tenant_id = ?)
2021-01-30 00:54:51.195 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.mapper.TenantMapper.selectOne : ==> Preparing: SELECT id, tenant_id, tenant_name, domain, background_url, linkman, contact_number, address, account_number, expire_time, datasource_id, license_key, create_user, create_dept, create_time, update_user, update_time, status, is_deleted FROM blade_tenant WHERE is_deleted = 0 AND (tenant_id = ?)
2021-01-30 00:54:51.197 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.mapper.TenantMapper.selectOne : ==> Parameters: 000000(String)
2021-01-30 00:54:51.198 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.mapper.TenantMapper.selectOne : <== Total: 1
2021-01-30 00:54:51.199 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : original SQL: SELECT
*
FROM
blade_user
WHERE
tenant_id = ? and account = ? and password = ? and is_deleted = 0
2021-01-30 00:54:51.200 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : SQL to parse, SQL: SELECT
*
FROM
blade_user
WHERE
tenant_id = ? and account = ? and password = ? and is_deleted = 0
2021-01-30 00:54:51.200 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : parse the finished SQL: SELECT * FROM blade_user WHERE tenant_id = ? AND account = ? AND password = ? AND is_deleted = 0
2021-01-30 00:54:51.200 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.system.mapper.UserMapper.getUser : ==> Preparing: SELECT * FROM blade_user WHERE tenant_id = ? AND account = ? AND password = ? AND is_deleted = 0
2021-01-30 00:54:51.203 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.system.mapper.UserMapper.getUser : ==> Parameters: 000000(String), admin(String), 90b9aa7e25f80cf4f64e990b78a9fc5ebd6cecad(String)
2021-01-30 00:54:51.204 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.system.mapper.UserMapper.getUser : <== Total: 1
2021-01-30 00:54:51.204 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : original SQL: SELECT
role_alias
FROM
blade_role
WHERE
id IN
(
?
)
and is_deleted = 0
2021-01-30 00:54:51.205 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : SQL to parse, SQL: SELECT
role_alias
FROM
blade_role
WHERE
id IN
(
?
)
and is_deleted = 0
2021-01-30 00:54:51.205 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : parse the finished SQL: SELECT role_alias FROM blade_role WHERE id IN (?) AND is_deleted = 0
2021-01-30 00:54:51.205 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.m.RoleMapper.getRoleAliases : ==> Preparing: SELECT role_alias FROM blade_role WHERE id IN (?) AND is_deleted = 0
2021-01-30 00:54:51.207 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.m.RoleMapper.getRoleAliases : ==> Parameters: 1123598816738675201(Long)
2021-01-30 00:54:51.208 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.m.RoleMapper.getRoleAliases : <== Total: 1
2021-01-30 00:54:51.209 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : original SQL: SELECT id,user_id,user_ext FROM blade_user_web
============== Sql Start ==============
Execute ID :org.springblade.modules.system.mapper.TenantMapper.selectOne
Execute SQL :SELECT id, tenant_id, tenant_name, domain, background_url, linkman, contact_number, address, account_number, expire_time, datasource_id, license_key, create_user, create_dept, create_time, update_user, update_time, status, is_deleted FROM blade_tenant WHERE is_deleted = 0 AND (tenant_id = ?)
Execute Time:2 ms
============== Sql End ==============
============== Sql Start ==============
Execute ID :org.springblade.modules.system.mapper.UserMapper.getUser
Execute SQL :SELECT * FROM blade_user WHERE tenant_id = ? AND account = ? AND password = ? AND is_deleted = 0
Execute Time:2 ms
============== Sql End ==============
============== Sql Start ==============
Execute ID :org.springblade.modules.system.mapper.RoleMapper.getRoleAliases
Execute SQL :SELECT role_alias FROM blade_role WHERE id IN (?) AND is_deleted = 0
Execute Time:0 ms
============== Sql End ==============
============== Sql Start ==============
Execute ID :org.springblade.modules.system.mapper.UserWebMapper.selectList
Execute SQL :SELECT id, user_id, user_ext FROM blade_user_web WHERE (user_id = ?)
Execute Time:1 ms
============== Sql End ==============
WHERE (user_id = ?)
2021-01-30 00:54:51.210 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : SQL to parse, SQL: SELECT id,user_id,user_ext FROM blade_user_web
WHERE (user_id = ?)
2021-01-30 00:54:51.210 DEBUG 12908 --- [ XNIO-1 task-50] o.s.core.tenant.BladeTenantInterceptor : parse the finished SQL: SELECT id, user_id, user_ext FROM blade_user_web WHERE (user_id = ?)
2021-01-30 00:54:51.210 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.mapper.UserWebMapper.selectList : ==> Preparing: SELECT id, user_id, user_ext FROM blade_user_web WHERE (user_id = ?)
2021-01-30 00:54:51.213 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.mapper.UserWebMapper.selectList : ==> Parameters: 1123598821738675201(Long)
2021-01-30 00:54:51.214 DEBUG 12908 --- [ XNIO-1 task-50] o.s.m.s.mapper.UserWebMapper.selectList : <== Total: 0
2021-01-30 00:54:51.218 DEBUG 12908 --- [ async-task-7] o.s.core.tenant.BladeTenantInterceptor : original SQL: INSERT INTO blade_log_api ( id,
type,
title,
time,
tenant_id,
service_id,
server_ip,
server_host,
env,
remote_ip,
user_agent,
request_uri,
method,
method_class,
method_name,
params,
create_by,
create_time ) VALUES ( ?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
? )
2021-01-30 00:54:51.218 DEBUG 12908 --- [ async-task-7] o.s.core.tenant.BladeTenantInterceptor : SQL to parse, SQL: INSERT INTO blade_log_api ( id,
type,
title,
time,
tenant_id,
service_id,
server_ip,
server_host,
env,
remote_ip,
user_agent,
request_uri,
method,
method_class,
method_name,
params,
create_by,
create_time ) VALUES ( ?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
?,
? )
2021-01-30 00:54:51.218 DEBUG 12908 --- [ async-task-7] o.s.core.tenant.BladeTenantInterceptor : parse the finished SQL: INSERT INTO blade_log_api (id, type, title, time, tenant_id, service_id, server_ip, server_host, env, remote_ip, user_agent, request_uri, method, method_class, method_name, params, create_by, create_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2021-01-30 00:54:51.218 DEBUG 12908 --- [ async-task-7] o.s.m.system.mapper.LogApiMapper.insert : ==> Preparing: INSERT INTO blade_log_api (id, type, title, time, tenant_id, service_id, server_ip, server_host, env, remote_ip, user_agent, request_uri, method, method_class, method_name, params, create_by, create_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2021-01-30 00:54:51.221 DEBUG 12908 --- [ async-task-7] o.s.m.system.mapper.LogApiMapper.insert : ==> Parameters: 1355197727360745473(Long), 1(String), 登录用户验证(String), 21(String), (String), blade-api(String), 192.168.100.1:80(String), 都是弟弟(String), dev(String), 0:0:0:0:0:0:0:1(String), Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/80.0.3970.5 Safari/537.36(String), /blade-auth/oauth/token(String), POST(String), org.springblade.modules.auth.endpoint.BladeTokenEndPoint(String), token(String), password=21232f297a57a5a743894a0e4a801fc3&tenantId=000000&username=admin(String), (String), 2021-01-30 00:54:51.216(Timestamp)
2021-01-30 00:54:51.344 DEBUG 12908 --- [ async-task-7] o.s.m.system.mapper.LogApiMapper.insert : <== Updates: 1
============== Sql Start ==============
Execute ID :org.springblade.modules.system.mapper.LogApiMapper.insert
Execute SQL :INSERT INTO blade_log_api (id, type, title, time, tenant_id, service_id, server_ip, server_host, env, remote_ip, user_agent, request_uri, method, method_class, method_name, params, create_by, create_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Execute Time:124 ms
============== Sql End ==============
五、若有更多详细信息,请在下面提供。
扫一扫访问 Blade技术社区 移动端