You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2021/11/16 06:47:28 UTC
[GitHub] [dolphinscheduler] alanredsheep opened a new issue #6869: [Bug] [sql] failed to upgrade database from 1.3.9 to 2.0.0
alanredsheep opened a new issue #6869:
URL: https://github.com/apache/dolphinscheduler/issues/6869
### 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
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #6869: [Bug] [sql] failed to upgrade database from 1.3.9 to 2.0.0
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6869:
URL: https://github.com/apache/dolphinscheduler/issues/6869#issuecomment-969927270
Hi:
* Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
* In order for us to understand your request as soon as possible, please provide detailed information、version or pictures.
* If you haven't received a reply for a long time, you can subscribe to the developer's email，Mail subscription steps reference https://dolphinscheduler.apache.org/en-us/community/development/subscribe.html ,Then write the issue URL in the email content and send question to dev@dolphinscheduler.apache.org.
--
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
[GitHub] [dolphinscheduler] alanredsheep closed issue #6869: [Bug] [sql] failed to upgrade database from 1.3.9 to 2.0.0
Posted by GitBox <gi...@apache.org>.
alanredsheep closed issue #6869:
URL: https://github.com/apache/dolphinscheduler/issues/6869
--
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
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #6869: [Bug] [sql] failed to upgrade database from 1.3.9 to 2.0.0
Posted by 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