登陆超时问题

Blade 未结

关注举报

 1  580

69partner 剑圣 2022-12-01 20:10

我用的版本是2.8.2版本，在测试的时候，有时会出现无法登陆的情况 network状态一直为待处理，有那些原因可能会造成这个问题呢，使用的是cloud版本

 org.springblade.auth.service.BladeUserDetails@586034f: Username: admin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: administrator
2022-12-01 20:04:34.831  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 7.511ms
==============  Sql  End   ==============
 
2022-12-01 20:04:34.836  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 3.784ms
==============  Sql  End   ==============
 
2022-12-01 20:04:34.841  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 4.127ms
==============  Sql  End   ==============
 
2022-12-01 20:05:33.380  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 981.046ms
==============  Sql  End   ==============
 
2022-12-01 20:05:33.430  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 11.491ms
==============  Sql  End   ==============
 
2022-12-01 20:05:33.436  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 3.743ms
==============  Sql  End   ==============
 
2022-12-01 20:05:33.442  INFO 30800 --- [  XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor    : 
 
==============  Sql Start  ==============
Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
Execute Time: 4.388ms
==============  Sql  End   ==============

出现这个问题的时候是不是有过较长时间没有操作系统，还是说刚刷新访问就出现这个问题。

如果是长时间没有操作导致的，确实是有这个问题，后续我们会重点排查一下。

	org.springblade.auth.service.BladeUserDetails@586034f: Username: admin; Password: [PROTECTED]; Enabled: true; AccountNonExpired: true; credentialsNonExpired: true; AccountNonLocked: true; Granted Authorities: administrator
	2022-12-01 20:04:34.831 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 7.511ms
	============== Sql End ==============

	2022-12-01 20:04:34.836 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 3.784ms
	============== Sql End ==============

	2022-12-01 20:04:34.841 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 4.127ms
	============== Sql End ==============

	2022-12-01 20:05:33.380 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 981.046ms
	============== Sql End ==============

	2022-12-01 20:05:33.430 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 11.491ms
	============== Sql End ==============

	2022-12-01 20:05:33.436 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 3.743ms
	============== Sql End ==============

	2022-12-01 20:05:33.442 INFO 30800 --- [ XNIO-1 task-4] o.s.core.mp.plugins.SqlLogInterceptor :

	============== Sql Start ==============
	Execute SQL : select client_id, CONCAT('{noop}', client_secret) as client_secret, resource_ids , scope, authorized_grant_types, web_server_redirect_uri, authorities, access_token_validity , refresh_token_validity, additional_information, autoapprove from blade_client where client_id = 'saber'
	Execute Time: 4.388ms
	============== Sql End ==============