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 2022/09/16 11:15:01 UTC

[GitHub] [dolphinscheduler] lctlover opened a new issue, #11999: [Bug] [Module Name] 版本升级导致工作流无法正常下线

lctlover opened a new issue, #11999:
URL: https://github.com/apache/dolphinscheduler/issues/11999

   ### 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
   
   1.3.5升级到2.0.6版本
   其中包含有计划任务的工作流可以正常上线，但无法正常下线，会报错。
   删除该工作流的计划任务，可以正常下线上线。
   
   ### What you expected to happen
   
   none
   
   ### How to reproduce
   
   升级中包含计划任务的工作流，即可重现错误。
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   2.0.6
   
   ### Are you willing to submit PR?
   
   - [X] 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.apache.org

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

[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #11999: [Bug] The version upgrade of [Module Name] caused the workflow to not be offline normally

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

   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 [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`


-- 
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 #11999: [Bug] The version upgrade of [Module Name] caused the workflow to not be offline normally

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

   ### 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
   
   1.3.5 upgrade to 2.0.6 version
   The workflow that contains scheduled tasks can go online normally, but cannot go offline normally, and an error will be reported.
   Delete the scheduled tasks of the workflow, and you can go online and offline normally.
   
   ### What you expected to happen
   
   none
   
   ### How to reproduce
   
   The error can be reproduced by upgrading the workflow to include scheduled tasks.
   
   ### Anything else
   
   _No response_
   
   ### Version
   
   2.0.6
   
   ### Are you willing to submit PR?
   
   - [X] 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] lctlover commented on issue #11999: [Bug] The version upgrade of [Module Name] caused the workflow to not be offline normally

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

   I have solved this problem. There are three tables missing
   
    three tables from 2.0.6 dolphinscheduler_mysql.sql, and not drop sql,it will fix this problem.
   .
   
   CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
     `SCHED_NAME` varchar(120) NOT NULL,
     `TRIGGER_NAME` varchar(200) NOT NULL,
     `TRIGGER_GROUP` varchar(200) NOT NULL,
     `BLOB_DATA` blob,
     PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
     KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
     CONSTRAINT `QRTZ_BLOB_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   
   
   CREATE TABLE `QRTZ_JOB_DETAILS` (
     `SCHED_NAME` varchar(120) NOT NULL,
     `JOB_NAME` varchar(200) NOT NULL,
     `JOB_GROUP` varchar(200) NOT NULL,
     `DESCRIPTION` varchar(250) DEFAULT NULL,
     `JOB_CLASS_NAME` varchar(250) NOT NULL,
     `IS_DURABLE` varchar(1) NOT NULL,
     `IS_NONCONCURRENT` varchar(1) NOT NULL,
     `IS_UPDATE_DATA` varchar(1) NOT NULL,
     `REQUESTS_RECOVERY` varchar(1) NOT NULL,
     `JOB_DATA` blob,
     PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
     KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
     KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   
   
   CREATE TABLE `QRTZ_CRON_TRIGGERS` (
     `SCHED_NAME` varchar(120) NOT NULL,
     `TRIGGER_NAME` varchar(200) NOT NULL,
     `TRIGGER_GROUP` varchar(200) NOT NULL,
     `CRON_EXPRESSION` varchar(120) NOT NULL,
     `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
     PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
     CONSTRAINT `QRTZ_CRON_TRIGGERS_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `QRTZ_TRIGGERS` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   


-- 
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] JinyLeeChina commented on issue #11999: [Bug] The version upgrade of [Module Name] caused the workflow to not be offline normally

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

   @lctlover Has PR been submitted 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] lctlover closed issue #11999: [Bug] The version upgrade of [Module Name] caused the workflow to not be offline normally

Posted by GitBox <gi...@apache.org>.
lctlover closed issue #11999: [Bug] The version upgrade of [Module Name] caused the workflow to not be offline normally
URL: https://github.com/apache/dolphinscheduler/issues/11999


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