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/10/27 03:15:52 UTC

[GitHub] [dolphinscheduler] SbloodyS opened a new issue #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

SbloodyS opened a new issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608


   ### 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
   
   ```
   [ERROR] 2021-10-27 11:02:06.120 org.apache.dolphinscheduler.api.exceptions.ApiExceptionHandler:[46] - 查询各状态流程实例数错误
   org.springframework.jdbc.BadSqlGrammarException: 
   ### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.process_definition_code' in 'on clause'
   ### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml]
   ### The error may involve defaultParameterMap
   ### The error occurred while setting parameters
   ### SQL: select t.state, count(0) as count         from t_ds_process_instance t         join t_ds_process_definition d on d.code=t.process_definition_code         join t_ds_project p on p.code=d.project_code         where 1 = 1         and t.is_sub_process = 0                       and t.start_time   >=   ? and t.start_time   <=   ?                                 and p.code in              (                   ?              )                    group by t.state
   ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.process_definition_code' in 'on clause'
   ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.process_definition_code' in 'on clause'
   ```
   
   ### What you expected to happen
   
   no error
   
   ### How to reproduce
   
   I got the following error when upgrade from 1.3.8 to 2.0.0-alpha using ./script/upgrade-dolphinscheduler.sh.
   
   ### Anything else
   
   _No response_
   
   ### 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] lenboo closed issue #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
lenboo closed issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608


   


-- 
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 #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608#issuecomment-952500923


   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/zh-cn/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] lenboo commented on issue #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
lenboo commented on issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608#issuecomment-962468778


   i will close it because of duplicate issue.


-- 
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] zhongjiajie commented on issue #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
zhongjiajie commented on issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608#issuecomment-952521768


   Maybe we should add `duplicate` label for this issue?


-- 
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] SbloodyS commented on issue #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
SbloodyS commented on issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608#issuecomment-952528475


   Thanks.I will retry upgrade until issue  #6597 close.


-- 
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 #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608#issuecomment-952500824


   ### 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
   
   ```
   [ERROR] 2021-10-27 11:02:06.120 org.apache.dolphinscheduler.api.exceptions.ApiExceptionHandler:[46] - 查询各状态流程实例数错误
   org.springframework.jdbc.BadSqlGrammarException: 
   ### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.process_definition_code' in 'on clause'
   ### The error may exist in class path resource [org/apache/dolphinscheduler/dao/mapper/ProcessInstanceMapper.xml]
   ### The error may involve defaultParameterMap
   ### The error occurred while setting parameters
   ### SQL: select t.state, count(0) as count         from t_ds_process_instance t         join t_ds_process_definition d on d.code=t.process_definition_code         join t_ds_project p on p.code=d.project_code         where 1 = 1         and t.is_sub_process = 0                       and t.start_time   >=   ? and t.start_time   <=   ?                                 and p.code in              (                   ?              )                    group by t.state
   ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.process_definition_code' in 'on clause'
   ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.process_definition_code' in 'on clause'
   ```
   
   ### What you expected to happen
   
   no error
   
   ### How to reproduce
   
   I got the following error when upgrade from 1.3.8 to 2.0.0-alpha using ./script/upgrade-dolphinscheduler.sh.
   
   ### Anything else
   
   _No response_
   
   ### 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] zhongjiajie commented on issue #6608: [Bug] [Master] upgrade to 2.0.0-alpha error

Posted by GitBox <gi...@apache.org>.
zhongjiajie commented on issue #6608:
URL: https://github.com/apache/dolphinscheduler/issues/6608#issuecomment-952521355


   @SbloodyS For now we do not have an out of box way to upgrade 1.3.x to 2.x, until issue https://github.com/apache/dolphinscheduler/issues/6597 close. Maybe you could track issue process, and we will close it and release DS 2.0 later


-- 
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