graphnj opened a new issue #7196: URL: https://github.com/apache/dolphinscheduler/issues/7196
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues. ### What happened [INFO] 2021-12-05 18:42:23.832 org.apache.dolphinscheduler.api.aspect.AccessLogAspect:[76] - REQUEST TRANCE_ID:01aadf72-c476-4cae-9ebb-4decaaa17686, LOGIN_USER:NOT LOGIN, URI:/dolphinscheduler/login, METHOD:POST, HANDLER:org.apache.dolphinscheduler.api.controller.LoginController.login, ARGS:{userName=admin} [ERROR] 2021-12-05 18:42:23.838 org.apache.dolphinscheduler.api.exceptions.ApiExceptionHandler:[46] - 用户登录失败 org.springframework.jdbc.BadSqlGrammarException: ### Error querying database. Cause: org.postgresql.util.PSQLException: ERROR: column "state" does not exist Position: 124 ### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/UserMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: select id, user_name, user_password, user_type, email, phone, tenant_id, create_time, update_time, queue, state from t_ds_user where user_name=? and user_password = ? ### Cause: org.postgresql.util.PSQLException: ERROR: column "state" does not exist Position: 124 ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column "state" does not exist Position: 124 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) at com.sun.proxy.$Proxy101.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61) at com.sun.proxy.$Proxy106.queryUserByNamePassword(Unknown Source) at org.apache.dolphinscheduler.api.service.impl.UsersServiceImpl.queryUser(UsersServiceImpl.java:287) at org.apache.dolphinscheduler.api.service.impl.UsersServiceImpl$$FastClassBySpringCGLIB$$ac00af33.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) at org.apache.dolphinscheduler.api.service.impl.UsersServiceImpl$$EnhancerBySpringCGLIB$$1302d40b.queryUser(<generated>) at org.apache.dolphinscheduler.api.security.impl.pwd.PasswordAuthenticator.login(PasswordAuthenticator.java:32) at org.apache.dolphinscheduler.api.security.impl.AbstractAuthenticator.authenticate(AbstractAuthenticator.java:60) at org.apache.dolphinscheduler.api.controller.LoginController.login(LoginController.java:104) at org.apache.dolphinscheduler.api.controller.LoginController$$FastClassBySpringCGLIB$$a36f5ae2.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpo ### What you expected to happen login system normal. ### How to reproduce use dolphinscheduler:2.0.0 docker image, and exec docker-compose up -d. 其实应该先解决掉连接pg库127.0.0.1连不上，那个问题 ### Anything else _No response_ ### Version 2.0.0 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
