[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #6869: [Bug] [sql] failed to upgrade database from 1.3.9 to 2.0.0

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

github-actions[bot] commented on issue #6869:
URL: https://github.com/apache/dolphinscheduler/issues/6869#issuecomment-969927117


   ### 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
   
   I upgraded database by using sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql.
   But it failed when I create a project. Here is the api-log.
   
   ```
   [ERROR] 2021-11-16 14:11:42.448 org.apache.dolphinscheduler.api.exceptions.ApiExceptionHandler:[46] - 创建项目错误
   org.springframework.jdbc.BadSqlGrammarException: 
   ### Error querying database.  Cause: org.postgresql.util.PSQLException: ERROR: column p.code does not exist
     Position: 40
   ### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml]
   ### The error may involve defaultParameterMap
   ### The error occurred while setting parameters
   ### SQL: select                   p.id, p.name, p.code, p.description, p.user_id, p.flag, p.create_time, p.update_time               ,         u.user_name as user_name         from t_ds_project p         join t_ds_user u on p.user_id = u.id         where p.name = ?         limit 1
   ### Cause: org.postgresql.util.PSQLException: ERROR: column p.code does not exist
     Position: 40
   ; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column p.code does not exist
   ```
   
   It seems t_ds_project.code is not in 1.3.9 but in 2.0.0, while it is not added in dolphinscheduler_ddl.sql.
   
   
   ### What you expected to happen
   
   I expected that I can upgrader database schema by sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql.
   
   ### How to reproduce
   
   Upgrade database scheme from 1.3.9 to 2.0.0-alpha by using sql/upgrade/1.4.0_schema/postgresql/dolphinscheduler_ddl.sql. 
   And then create a new project on web.
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   2.0.0-alpha
   
   ### 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: commits-unsubscribe@dolphinscheduler.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org