[GitHub] [incubator-dolphinscheduler] nauu opened a new issue #1239: [BUG] create user error by the missing field 'queue' in table 't_escheduler_user'

[GitBox <gi...@apache.org>]

nauu opened a new issue #1239: [BUG] create user error by the missing field 'queue' in table 't_escheduler_user'
URL: https://github.com/apache/incubator-dolphinscheduler/issues/1239
 
 
   when create a new user,  it occur exception "create user error".
   
   the API Server exception info as follow:
   ```
   org.springframework.jdbc.BadSqlGrammarException: 
   ### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'queue' in 'field list'
   ### The error may exist in cn/escheduler/dao/mapper/UserMapper.java (best guess)
   ### The error may involve cn.escheduler.dao.mapper.UserMapper.insert-Inline
   ### The error occurred while setting parameters
   ### SQL: INSERT INTO t_escheduler_user  (`user_name`, `user_password`, `email`, `phone`, `user_type`, `tenant_id`, `queue`, `create_time`, `update_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
   ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'queue' in 'field list'
   ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'queue' in 'field list'
   	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:234) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
   	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) ~[spring-jdbc-5.1.5.RELEASE.jar:5.1.5.RELEASE]
   	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) ~[mybatis-spring-2.0.1.jar:2.0.1]
   	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-2.0.1.jar:2.0.1]
   	at com.sun.proxy.$Proxy89.insert(Unknown Source) ~[na:na]
   	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278) ~[mybatis-spring-2.0.1.jar:2.0.1]
   	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62) ~[mybatis-3.5.1.jar:3.5.1]
   	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58) ~[mybatis-3.5.1.jar:3.5.1]
   	at com.sun.proxy.$Proxy103.insert(Unknown Source) ~[na:na]
   	at cn.escheduler.api.service.UsersService.createUser(UsersService.java:124) ~[classes/:na]
   	at cn.escheduler.api.service.UsersService$$FastClassBySpringCGLIB$$11005e8f.invoke(<generated>) ~[classes/:na]
   	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.1.5.RELEASE.jar:5.1.5.RELEASE]
   	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE]
   	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.1.5.RELEASE.jar:5.1.5.RELEASE]
   	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294) ~[spring-tx-5.1.5.RELEASE.jar:5.1.5.RELEASE]
   	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.1.5.RELEASE.jar:5.
   
   ```
   
   i found that , the table  t_escheduler_user dose't have the filed 'queue'.
   
   my code is forkd from the master
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services