FATE icon indicating copy to clipboard operation
FATE copied to clipboard

When I use the interface "/v1/job/clean" to clean job,I find tracking_metric data will never be delete

Open yyf1986 opened this issue 2 years ago • 0 comments

Describe the bug When I use the interface "/v1/job/clean" to clean job,I find tracking_metric data will never be delete.

To Reproduce Steps to reproduce the behavior: curl -XPOST http://10.1.251.75:19380/v1/job/clean -d '{"job_id": "202308011443349429140"}'. then use mysql workbench to run SELECT * FROM fate_flow.t_tracking_metric_202308011 where f_job_id='202308011443349429140'; you will find the job 202308011443349429140 relevant data is not deleted Expected behavior when delete t_tracking_metric_202308011 the query is not right and no judgment is made on the delete result.

Screenshots [INFO] [2023-08-17 16:19:09,383] [Server] [177765:139990376834816] - [data_manager.delete_metric_data_from_db] [line:380]: delete tracking_metric_model 0 {'job_id': '202308011443349429140', 'role': 'guest', 'party_id': '50000', 'component_name': 'reader_0'}===== [INFO] [2023-08-17 16:19:09,384] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:67]: delete result:delete status: False======== [INFO] [2023-08-17 16:19:09,384] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:68]: delete 202308011443349429140 guest 50000 reader_0 metric data success [INFO] [2023-08-17 16:19:09,384] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:42]: start 202308011443349429140 host 60000 reader_0 session stop [INFO] [2023-08-17 16:19:09,386] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:45]: stop 202308011443349429140 host 60000 reader_0 session success [INFO] [2023-08-17 16:19:09,387] [Server] [177765:139990376834816] - [job_clean.clean_table] [line:27]: start delete 202308011443349429140 host 60000 reader_0 data table [INFO] [2023-08-17 16:19:09,390] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:60]: start delete 202308011443349429140 host 60000 reader_0 metric data [INFO] [2023-08-17 16:19:09,391] [Server] [177765:139990376834816] - [data_manager.delete_metric_data_from_db] [line:380]: delete tracking_metric_model 0 {'job_id': '202308011443349429140', 'role': 'host', 'party_id': '60000', 'component_name': 'reader_0'}===== [INFO] [2023-08-17 16:19:09,391] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:67]: delete result:delete status: False======== [INFO] [2023-08-17 16:19:09,392] [Server] [177765:139990376834816] - [job_clean.start_clean_job] [line:68]: delete 202308011443349429140 host 60000 reader_0 metric data success

yyf1986 avatar Aug 17 '23 08:08 yyf1986