[GitHub] [dolphinscheduler] liyanj commented on issue #8790: [Bug] [Process Definition] Duplicate key TaskDefinition

["liyanj (via GitHub)" <gi...@apache.org>]

liyanj commented on issue #8790:
URL: https://github.com/apache/dolphinscheduler/issues/8790#issuecomment-1486631285

   1. Get the latest version of process_definition, as below:
   SELECT version FROM t_ds_process_definition WHERE code = '9031660390016';
   
   2. Get the latest version of task_definition, as below:
   SELECT version FROM t_ds_task_definition WHERE code = '9031645384064';
   
   3. The problem is that there are multiple relations in table(t_ds_process_task_relation), as below:
   SELECT * FROM t_ds_process_task_relation WHERE process_definition_code = '9031660390016' AND post_task_code = '9031645384064'
   
   4. The SOLUTION is:
   Find the record with both the latest process_definition_version(MAX process_definition_version) and the latest post_task_version(MAX post_task_version), and retain this record. Then, delete all of other relation records about this process_definition and task_definition.
   5. DONE.
   


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