问题描述:v1.4.1-beta数据库回迁后报错
Server版本:v1.4.1-beta
Agent版本与部署方式:不涉及agent
手机型号与系统版本:略
截图:略
相关日志:
2022-06-23 10:13:20.509 INFO [,ac4e3a1790a73f6e,7900bd887f965ff3,false] 1 --- [XNIO-1 task-1] o.c.sonic.common.config.WebAspectConfig : {"request":"[org.cloud.sonic.controller.models.http.UserInfo@32983dfe]","method":"POST","class":"org.cloud.sonic.controller.controller.UsersController.login","url":"http://172.24.0.4:3000/users/login"}
2022-06-23 10:13:20.513 INFO [,ac4e3a1790a73f6e,7900bd887f965ff3,false] 1 --- [XNIO-1 task-1] o.c.sonic.common.config.WebAspectConfig : error :
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
### The error may exist in org/cloud/sonic/controller/mapper/UsersMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,password,user_role,user_name,source FROM users WHERE (user_name = ?)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
2022-06-23 10:13:20.513 ERROR [,ac4e3a1790a73f6e,7900bd887f965ff3,false] 1 --- [XNIO-1 task-1] o.c.s.common.config.GlobalWebException :
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
### The error may exist in org/cloud/sonic/controller/mapper/UsersMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,password,user_role,user_name,source FROM users WHERE (user_name = ?)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
### The error may exist in org/cloud/sonic/controller/mapper/UsersMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,password,user_role,user_name,source FROM users WHERE (user_name = ?)
### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'user_role' in 'field list'
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)