刚安装好webase时候,默认里面有一个admin 链管理员,但是这个admin 并没有私钥,有signid;在front 那边导出txt,得到是admin完整内容(包含私钥),这个使用将txt 导入webase 里面,是可以导入成功的,就有了两个admin(本质是同一个,只是起了不同的名字)
由于这个情况,sign 有异常,通过手动将数据库空老的admin删除,业务正常;想要复现,通过手动再次导入txt(admin的包含私钥),这个时候就导入不进去了,应该业务有做了验证。
以下是日志记录,看情况应该sql 查询出了问题影响了,从接口走,sign服务是正常操作的,所以排除了sign自身的问题。
该问题不确定是否为bug,只能说特定情况下操作可能出现不严谨,导致异常。
2020-09-24 20:19:04.965 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:19:04.965 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:19:04.966 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73ed4a53] was not registered for synchronization because synchronization is not active
2020-09-24 20:19:04.966 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:19:04.966 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:19:04.966 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:19:04.967 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:19:04.967 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:19:04.968 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73ed4a53]
2020-09-24 20:19:14.968 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:19:14.968 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:19:14.968 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@66df8ab2] was not registered for synchronization because synchronization is not active
2020-09-24 20:19:14.968 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:19:14.969 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:19:14.969 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:19:14.969 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:19:14.969 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:19:14.970 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@66df8ab2]
2020-09-24 20:19:24.970 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:19:24.970 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:19:24.970 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@29f270d1] was not registered for synchronization because synchronization is not active
2020-09-24 20:19:24.970 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:19:24.971 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:19:24.971 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:19:24.971 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:19:24.972 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:19:24.972 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@29f270d1]
2020-09-24 20:19:34.972 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:19:34.972 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:19:34.972 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3cfc776] was not registered for synchronization because synchronization is not active
2020-09-24 20:19:34.972 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:19:34.973 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:19:34.973 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:19:34.974 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:19:34.975 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:19:34.975 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3cfc776]
2020-09-24 20:19:44.975 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:19:44.975 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:19:44.975 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@39ce7367] was not registered for synchronization because synchronization is not active
2020-09-24 20:19:44.975 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:19:44.976 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:19:44.976 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:19:44.976 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:19:44.977 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:19:44.977 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@39ce7367]
2020-09-24 20:19:54.977 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:19:54.977 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:19:54.977 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fada5a] was not registered for synchronization because synchronization is not active
2020-09-24 20:19:54.977 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:19:54.978 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:19:54.978 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:19:54.978 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:19:54.979 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:19:54.979 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@fada5a]
2020-09-24 20:20:04.979 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:20:04.979 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:20:04.980 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@20baed4f] was not registered for synchronization because synchronization is not active
2020-09-24 20:20:04.980 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:20:04.980 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:20:04.981 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:20:04.981 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:20:04.982 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:20:04.982 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@20baed4f]
2020-09-24 20:20:14.982 [pool-3-thread-1] DEBUG SynUsrTask() - start syncUsrCacheTask task
2020-09-24 20:20:14.982 [pool-3-thread-1] DEBUG SqlSessionUtils() - Creating a new SqlSession
2020-09-24 20:20:14.982 [pool-3-thread-1] DEBUG SqlSessionUtils() - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3ed2928b] was not registered for synchronization because synchronization is not active
2020-09-24 20:20:14.982 [pool-3-thread-1] DEBUG DataSourceUtils() - Fetching JDBC Connection from DataSource
2020-09-24 20:20:14.983 [pool-3-thread-1] DEBUG SpringManagedTransaction() - JDBC Connection [ProxyConnection[PooledConnection[com.mysql.cj.jdbc.ConnectionImpl@3709748f]]] will not be managed by Spring
2020-09-24 20:20:14.983 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Preparing: select user_id as userId, sign_user_id as signUserId, app_id as appId, address, public_key as publicKey, private_key as privateKey, description, status, encrypt_type as encryptType, gmt_modify as gmtModify from tb_user where status ='0' order by gmt_modify desc limit 0,1
2020-09-24 20:20:14.983 [pool-3-thread-1] DEBUG findLatestUpdateUser() - ==> Parameters:
2020-09-24 20:20:14.984 [pool-3-thread-1] DEBUG findLatestUpdateUser() - <== Total: 0
2020-09-24 20:20:14.985 [pool-3-thread-1] DEBUG SqlSessionUtils() - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3ed2928b]