select distinct(mdc.id) from MTRPhoto.dashboard_results dr, MTRPhoto.mtr_datou_current mdc where dr.created_at > "2025-04-13" and mdc.created_at < "2025-04-14 05:14:34" and dr.mtr_portfolio_id = mdc.mtr_portfolio_id and mdc.mtd_id not in (1038,1204,1669,2707,2852,2955,3025,4878,3086,3097,3100,3142,3161,3192,3193,3201,3256,3213,3378,3385,3681,3701,3726,3751,3750,3762,4891,4196,3750,3772,3800,3893,3921,3981,3980,4340,4042,4042,4042,4341,4101,4095,4093,4165,4177,4204,4220,4311,4189,4272,4278,4283,4285,4297,4306,4390,4315,4323,4327,4346,4327,4346,4421,4384,4398,4399,4327,4327,4738,4311,4746,4795,4810,4810,4849,4851,4850,4867,4867,4893,4916,533,4310,4219,4187) and dr.mtr_portfolio_id not in (select dr.mtr_portfolio_id from MTRPhoto.dashboard_results dr, MTRPhoto.mtr_datou_current mdc where dr.created_at > "2025-04-13" and dr.mtr_portfolio_id = mdc.mtr_portfolio_id and dr.dashboard_run_id in (select last_run_id from MTRPhoto.dashboard_entry_day)); nombre de datou_current selectionne : 0 delete batch current inutile (ne sont plus dans dashboard) [] Useless call to update_current_state SELECT id, mtd_id, updated_at FROM MTRPhoto.mtr_datou_current WHERE state = 1 AND updated_at < DATE_SUB(now(), INTERVAL 1000 SECOND) # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : step 11359 frcnn is not linked in the step_by_step architecture ! Step 11362 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11361 paddle_ocr have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : step 11937 tfhub_classification2 is not linked in the step_by_step architecture ! WARNING : step 11938 argmax is not linked in the step_by_step architecture ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 14034 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 14041 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 14042 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 14038 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 14038 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 14040 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 14040 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 14035 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 14035 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 14045 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 14045 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 14037 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 14036 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 14036 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 14044 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 14037 doesn't seem to be define in the database( WARNING : type of input 3 of step 14036 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 14034 doesn't seem to be define in the database( WARNING : type of input 2 of step 14038 doesn't seem to be define in the database( WARNING : output 1 of step 14034 have datatype=2 whereas input 1 of step 14040 have datatype=7 WARNING : type of output 2 of step 14040 doesn't seem to be define in the database( WARNING : type of input 1 of step 14035 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 14037 have datatype=10 whereas input 3 of step 14043 have datatype=6 WARNING : type of input 2 of step 14045 doesn't seem to be define in the database( WARNING : output 1 of step 14035 have datatype=7 whereas input 2 of step 14045 have datatype=None WARNING : type of output 3 of step 14045 doesn't seem to be define in the database( WARNING : type of input 1 of step 14037 doesn't seem to be define in the database( WARNING : output 0 of step 14037 have datatype=10 whereas input 0 of step 14046 have datatype=18 WARNING : type of input 5 of step 14043 doesn't seem to be define in the database( WARNING : output 0 of step 14046 have datatype=11 whereas input 5 of step 14043 have datatype=None WARNING : type of output 1 of step 14041 doesn't seem to be define in the database( WARNING : type of input 3 of step 14038 doesn't seem to be define in the database( WARNING : type of output 1 of step 14042 doesn't seem to be define in the database( WARNING : type of input 3 of step 14038 doesn't seem to be define in the database( WARNING : output 0 of step 14040 have datatype=1 whereas input 0 of step 14035 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11560 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11567 mask_detect have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11567 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11563 crop_condition is not consistent : 4 used against 2 in the step definition ! Step 11563 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11564 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11564 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11565 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11565 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11573 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11573 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11568 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11568 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11566 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11566 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11560 doesn't seem to be define in the database( WARNING : type of input 2 of step 11563 doesn't seem to be define in the database( WARNING : output 1 of step 11560 have datatype=2 whereas input 1 of step 11564 have datatype=7 WARNING : type of output 2 of step 11564 doesn't seem to be define in the database( WARNING : type of input 1 of step 11565 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11567 doesn't seem to be define in the database( WARNING : type of input 3 of step 11563 doesn't seem to be define in the database( WARNING : type of output 3 of step 11564 doesn't seem to be define in the database( WARNING : type of input 1 of step 11568 doesn't seem to be define in the database( WARNING : type of output 1 of step 11568 doesn't seem to be define in the database( WARNING : type of input 3 of step 11566 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11563 doesn't seem to be define in the database( WARNING : output 0 of step 11570 have datatype=6 whereas input 2 of step 11563 have datatype=None WARNING : type of input 2 of step 11563 doesn't seem to be define in the database( WARNING : output 0 of step 11569 have datatype=6 whereas input 2 of step 11563 have datatype=None WARNING : type of output 2 of step 11560 doesn't seem to be define in the database( WARNING : type of input 1 of step 11570 doesn't seem to be define in the database( WARNING : type of output 2 of step 11560 doesn't seem to be define in the database( WARNING : type of input 1 of step 11569 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11568 have datatype=10 whereas input 3 of step 11571 have datatype=6 WARNING : type of input 2 of step 11573 doesn't seem to be define in the database( WARNING : output 1 of step 11565 have datatype=7 whereas input 2 of step 11573 have datatype=None WARNING : type of output 3 of step 11573 doesn't seem to be define in the database( WARNING : type of input 3 of step 11568 doesn't seem to be define in the database( WARNING : output 0 of step 11568 have datatype=10 whereas input 0 of step 11587 have datatype=18 WARNING : type of input 5 of step 11571 doesn't seem to be define in the database( WARNING : output 0 of step 11587 have datatype=11 whereas input 5 of step 11571 have datatype=None WARNING : output 0 of step 11564 have datatype=1 whereas input 0 of step 11565 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 13185 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 13193 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13194 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 13189 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 13189 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13191 argmax have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13192 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 13186 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13186 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13197 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13197 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 13188 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13187 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 13187 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 13196 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13188 doesn't seem to be define in the database( WARNING : type of input 3 of step 13187 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 13185 doesn't seem to be define in the database( WARNING : type of input 2 of step 13189 doesn't seem to be define in the database( WARNING : output 0 of step 13185 have datatype=16 whereas input 0 of step 13192 have datatype=1 WARNING : output 1 of step 13185 have datatype=2 whereas input 1 of step 13192 have datatype=7 WARNING : output 0 of step 13191 have datatype=6 whereas input 2 of step 13192 have datatype=5 WARNING : type of output 2 of step 13192 doesn't seem to be define in the database( WARNING : type of input 1 of step 13186 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13188 have datatype=10 whereas input 3 of step 13195 have datatype=6 WARNING : type of input 2 of step 13197 doesn't seem to be define in the database( WARNING : output 1 of step 13186 have datatype=7 whereas input 2 of step 13197 have datatype=None WARNING : type of output 3 of step 13197 doesn't seem to be define in the database( WARNING : type of input 1 of step 13188 doesn't seem to be define in the database( WARNING : output 0 of step 13188 have datatype=10 whereas input 0 of step 13198 have datatype=18 WARNING : type of input 5 of step 13195 doesn't seem to be define in the database( WARNING : output 0 of step 13198 have datatype=11 whereas input 5 of step 13195 have datatype=None WARNING : type of output 1 of step 13193 doesn't seem to be define in the database( WARNING : type of input 3 of step 13189 doesn't seem to be define in the database( WARNING : type of output 1 of step 13194 doesn't seem to be define in the database( WARNING : type of input 3 of step 13189 doesn't seem to be define in the database( WARNING : output 0 of step 13192 have datatype=1 whereas input 0 of step 13186 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11512 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11521 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11520 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11516 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11516 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11519 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11519 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11513 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11513 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11577 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11577 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11515 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11514 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11514 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11523 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11515 doesn't seem to be define in the database( WARNING : type of input 3 of step 11514 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11512 doesn't seem to be define in the database( WARNING : type of input 2 of step 11516 doesn't seem to be define in the database( WARNING : output 1 of step 11512 have datatype=2 whereas input 1 of step 11519 have datatype=7 WARNING : type of output 2 of step 11519 doesn't seem to be define in the database( WARNING : type of input 1 of step 11513 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11515 have datatype=10 whereas input 3 of step 11522 have datatype=6 WARNING : type of input 2 of step 11577 doesn't seem to be define in the database( WARNING : output 1 of step 11513 have datatype=7 whereas input 2 of step 11577 have datatype=None WARNING : type of output 3 of step 11577 doesn't seem to be define in the database( WARNING : type of input 1 of step 11515 doesn't seem to be define in the database( WARNING : output 0 of step 11515 have datatype=10 whereas input 0 of step 11583 have datatype=18 WARNING : type of input 5 of step 11522 doesn't seem to be define in the database( WARNING : output 0 of step 11583 have datatype=11 whereas input 5 of step 11522 have datatype=None WARNING : type of output 1 of step 11521 doesn't seem to be define in the database( WARNING : type of input 3 of step 11516 doesn't seem to be define in the database( WARNING : type of output 1 of step 11520 doesn't seem to be define in the database( WARNING : type of input 3 of step 11516 doesn't seem to be define in the database( WARNING : output 0 of step 11519 have datatype=1 whereas input 0 of step 11513 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11536 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11545 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11544 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11540 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11540 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11543 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11543 merge_mask_thcl_custom have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 11537 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11579 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11579 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11539 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11538 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11538 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11547 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11539 doesn't seem to be define in the database( WARNING : type of input 3 of step 11538 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11536 doesn't seem to be define in the database( WARNING : type of input 2 of step 11540 doesn't seem to be define in the database( WARNING : output 1 of step 11536 have datatype=2 whereas input 1 of step 11543 have datatype=7 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11539 have datatype=10 whereas input 3 of step 11546 have datatype=6 WARNING : type of input 2 of step 11579 doesn't seem to be define in the database( WARNING : output 1 of step 11537 have datatype=7 whereas input 2 of step 11579 have datatype=None WARNING : type of output 3 of step 11579 doesn't seem to be define in the database( WARNING : type of input 1 of step 11539 doesn't seem to be define in the database( WARNING : output 0 of step 11539 have datatype=10 whereas input 0 of step 11585 have datatype=18 WARNING : type of input 5 of step 11546 doesn't seem to be define in the database( WARNING : output 0 of step 11585 have datatype=11 whereas input 5 of step 11546 have datatype=None WARNING : type of output 1 of step 11545 doesn't seem to be define in the database( WARNING : type of input 3 of step 11540 doesn't seem to be define in the database( WARNING : type of output 1 of step 11544 doesn't seem to be define in the database( WARNING : type of input 3 of step 11540 doesn't seem to be define in the database( WARNING : output 0 of step 11543 have datatype=1 whereas input 0 of step 11537 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 12489 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 12499 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12500 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 12492 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 12492 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! WARNING : number of outputs for step 12493 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12494 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 12502 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 12502 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 12496 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 12495 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 12495 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 2 of step 12492 doesn't seem to be define in the database( WARNING : output 1 of step 12489 have datatype=2 whereas input 1 of step 12493 have datatype=7 WARNING : type of output 2 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12494 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 12493 doesn't seem to be define in the database( WARNING : type of input 1 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12496 doesn't seem to be define in the database( WARNING : type of input 3 of step 12495 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12500 doesn't seem to be define in the database( WARNING : type of output 2 of step 12489 doesn't seem to be define in the database( WARNING : type of input 1 of step 12499 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 12496 have datatype=10 whereas input 3 of step 12498 have datatype=6 WARNING : type of input 5 of step 12498 doesn't seem to be define in the database( WARNING : output 0 of step 12501 have datatype=11 whereas input 5 of step 12498 have datatype=None WARNING : output 0 of step 12496 have datatype=10 whereas input 0 of step 12501 have datatype=18 WARNING : type of input 2 of step 12502 doesn't seem to be define in the database( WARNING : output 1 of step 12494 have datatype=7 whereas input 2 of step 12502 have datatype=None WARNING : type of output 3 of step 12502 doesn't seem to be define in the database( WARNING : type of input 2 of step 12496 doesn't seem to be define in the database( WARNING : type of output 1 of step 12499 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : type of output 1 of step 12500 doesn't seem to be define in the database( WARNING : type of input 3 of step 12492 doesn't seem to be define in the database( WARNING : output 0 of step 12493 have datatype=1 whereas input 0 of step 12494 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 10383 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 10391 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10392 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 10387 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 10387 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 10390 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 10390 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 10384 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11838 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11838 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 10386 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 10385 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 10385 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 10393 send_mail_cod have less outputs used (0) than in the step definition (1) : some outputs may be not used ! Step 10430 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 3 of step 10385 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 10383 doesn't seem to be define in the database( WARNING : type of input 2 of step 10387 doesn't seem to be define in the database( WARNING : output 1 of step 10383 have datatype=2 whereas input 1 of step 10390 have datatype=7 WARNING : type of output 2 of step 10390 doesn't seem to be define in the database( WARNING : type of input 1 of step 10384 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 10386 have datatype=10 whereas input 3 of step 10393 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 10391 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of output 1 of step 10392 doesn't seem to be define in the database( WARNING : type of input 3 of step 10387 doesn't seem to be define in the database( WARNING : type of input 5 of step 10393 doesn't seem to be define in the database( WARNING : output 0 of step 11836 have datatype=11 whereas input 5 of step 10393 have datatype=None WARNING : output 0 of step 10386 have datatype=10 whereas input 0 of step 11836 have datatype=18 WARNING : type of output 3 of step 11838 doesn't seem to be define in the database( WARNING : type of input 1 of step 10386 doesn't seem to be define in the database( WARNING : type of input 2 of step 11838 doesn't seem to be define in the database( WARNING : output 1 of step 10384 have datatype=7 whereas input 2 of step 11838 have datatype=None WARNING : output 0 of step 10390 have datatype=1 whereas input 0 of step 10384 have datatype=2 DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11939 matching_dashboard is not consistent : 1 used against 0 in the step definition ! Step 11940 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 0 of step 11939 doesn't seem to be define in the database( WARNING : type of input 2 of step 11940 doesn't seem to be define in the database( DataTypes for each output/input checked ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type seems boolean for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : difference : -10699 for current_id 2591988, if negative, datou_current will be reset difference : -11268 for current_id 2595013, if negative, datou_current will be reset difference : -11283 for current_id 2598020, if negative, datou_current will be reset difference : -12098 for current_id 2707471, if negative, datou_current will be reset difference : -12398 for current_id 2711410, if negative, datou_current will be reset difference : -12997 for current_id 2718850, if negative, datou_current will be reset difference : -13298 for current_id 2727237, if negative, datou_current will be reset difference : -13397 for current_id 2724868, if negative, datou_current will be reset difference : -15198 for current_id 2724906, if negative, datou_current will be reset difference : -14295 for current_id 2724909, if negative, datou_current will be reset difference : -5892 for current_id 2725035, if negative, datou_current will be reset difference : -5599 for current_id 2725038, if negative, datou_current will be reset difference : -4699 for current_id 2725043, if negative, datou_current will be reset difference : -4398 for current_id 2725045, if negative, datou_current will be reset difference : -2287 for current_id 2725050, if negative, datou_current will be reset difference : 121 for current_id 2725054, if negative, datou_current will be reset difference : 1014 for current_id 2725060, if negative, datou_current will be reset difference : 82 for current_id 2725132, if negative, datou_current will be reset difference : -1099 for current_id 2725136, if negative, datou_current will be reset difference : -1720 for current_id 2725137, if negative, datou_current will be reset difference : -2057 for current_id 2725139, if negative, datou_current will be reset difference : -2535 for current_id 2725141, if negative, datou_current will be reset difference : -2623 for current_id 2725145, if negative, datou_current will be reset difference : -3490 for current_id 2725146, if negative, datou_current will be reset difference : -3740 for current_id 2725150, if negative, datou_current will be reset difference : -4212 for current_id 2725152, if negative, datou_current will be reset difference : -4421 for current_id 2725157, if negative, datou_current will be reset difference : -4698 for current_id 2725159, if negative, datou_current will be reset difference : -6138 for current_id 2725160, if negative, datou_current will be reset difference : -7337 for current_id 2725174, if negative, datou_current will be reset difference : -10697 for current_id 2725193, if negative, datou_current will be reset difference : -13339 for current_id 2725211, if negative, datou_current will be reset difference : -13421 for current_id 2725213, if negative, datou_current will be reset difference : -14299 for current_id 2725220, if negative, datou_current will be reset difference : -14321 for current_id 2725224, if negative, datou_current will be reset difference : -14539 for current_id 2725227, if negative, datou_current will be reset difference : -5322 for current_id 2725253, if negative, datou_current will be reset difference : -5658 for current_id 2725263, if negative, datou_current will be reset difference : -15979 for current_id 2725372, if negative, datou_current will be reset difference : -5176 for current_id 2725568, if negative, datou_current will be reset difference : -3795 for current_id 2724942, if negative, datou_current will be reset difference : -10827 for current_id 2725794, if negative, datou_current will be reset difference : -12195 for current_id 2725021, if negative, datou_current will be reset difference : -11896 for current_id 2725027, if negative, datou_current will be reset difference : -9796 for current_id 2725031, if negative, datou_current will be reset difference : -6197 for current_id 2725039, if negative, datou_current will be reset difference : -6492 for current_id 2725046, if negative, datou_current will be reset difference : -4998 for current_id 2725051, if negative, datou_current will be reset difference : -1286 for current_id 2725433, if negative, datou_current will be reset difference : -3518 for current_id 2725451, if negative, datou_current will be reset difference : -3626 for current_id 2725459, if negative, datou_current will be reset difference : -4155 for current_id 2725460, if negative, datou_current will be reset difference : -4345 for current_id 2725471, if negative, datou_current will be reset difference : -4704 for current_id 2725496, if negative, datou_current will be reset difference : -5008 for current_id 2725513, if negative, datou_current will be reset difference : -5150 for current_id 2725523, if negative, datou_current will be reset difference : -5247 for current_id 2725544, if negative, datou_current will be reset difference : -5847 for current_id 2725559, if negative, datou_current will be reset difference : -5786 for current_id 2725560, if negative, datou_current will be reset difference : -5908 for current_id 2725569, if negative, datou_current will be reset difference : -5967 for current_id 2725570, if negative, datou_current will be reset difference : -6148 for current_id 2725577, if negative, datou_current will be reset difference : -6110 for current_id 2725578, if negative, datou_current will be reset difference : -6385 for current_id 2725595, if negative, datou_current will be reset difference : -6568 for current_id 2725596, if negative, datou_current will be reset difference : -6690 for current_id 2725609, if negative, datou_current will be reset difference : -6749 for current_id 2725610, if negative, datou_current will be reset difference : -7168 for current_id 2725623, if negative, datou_current will be reset difference : -7121 for current_id 2725624, if negative, datou_current will be reset difference : -10914 for current_id 2725641, if negative, datou_current will be reset difference : -7287 for current_id 2725655, if negative, datou_current will be reset difference : -7520 for current_id 2725656, if negative, datou_current will be reset difference : -11872 for current_id 2725669, if negative, datou_current will be reset difference : -11921 for current_id 2725670, if negative, datou_current will be reset difference : -12207 for current_id 2725691, if negative, datou_current will be reset difference : -7588 for current_id 2725703, if negative, datou_current will be reset difference : -12808 for current_id 2725719, if negative, datou_current will be reset difference : -12868 for current_id 2725723, if negative, datou_current will be reset difference : -12928 for current_id 2725728, if negative, datou_current will be reset difference : -7649 for current_id 2725748, if negative, datou_current will be reset difference : -14307 for current_id 2725757, if negative, datou_current will be reset difference : -12510 for current_id 2725773, if negative, datou_current will be reset difference : -11310 for current_id 2725842, if negative, datou_current will be reset difference : -11366 for current_id 2726562, if negative, datou_current will be reset difference : -11393 for current_id 2726642, if negative, datou_current will be reset difference : -7793 for current_id 2727131, if negative, datou_current will be reset difference : -7886 for current_id 2727380, if negative, datou_current will be reset difference : -13792 for current_id 2727914, if negative, datou_current will be reset difference : -7950 for current_id 2733054, if negative, datou_current will be reset difference : -8008 for current_id 2733174, if negative, datou_current will be reset difference : -8322 for current_id 2733178, if negative, datou_current will be reset difference : -12028 for current_id 2733635, if negative, datou_current will be reset difference : -9523 for current_id 2733663, if negative, datou_current will be reset difference : -12747 for current_id 2734128, if negative, datou_current will be reset difference : -7697 for current_id 2725025, if negative, datou_current will be reset difference : -5298 for current_id 2725040, if negative, datou_current will be reset difference : -3494 for current_id 2725047, if negative, datou_current will be reset difference : -1694 for current_id 2725052, if negative, datou_current will be reset difference : 819 for current_id 2725444, if negative, datou_current will be reset difference : 1093 for current_id 2725445, if negative, datou_current will be reset difference : -149 for current_id 2725457, if negative, datou_current will be reset difference : -748 for current_id 2725476, if negative, datou_current will be reset difference : -807 for current_id 2725484, if negative, datou_current will be reset difference : -1289 for current_id 2725508, if negative, datou_current will be reset difference : -1467 for current_id 2725514, if negative, datou_current will be reset difference : -1575 for current_id 2725522, if negative, datou_current will be reset difference : -1709 for current_id 2725551, if negative, datou_current will be reset difference : -2005 for current_id 2725552, if negative, datou_current will be reset difference : -2486 for current_id 2725571, if negative, datou_current will be reset difference : -2425 for current_id 2725572, if negative, datou_current will be reset difference : -2606 for current_id 2725585, if negative, datou_current will be reset difference : -2668 for current_id 2725586, if negative, datou_current will be reset difference : -3027 for current_id 2725607, if negative, datou_current will be reset difference : -2991 for current_id 2725608, if negative, datou_current will be reset difference : -3209 for current_id 2725619, if negative, datou_current will be reset difference : -3267 for current_id 2725620, if negative, datou_current will be reset difference : -7530 for current_id 2725649, if negative, datou_current will be reset difference : -7647 for current_id 2725650, if negative, datou_current will be reset difference : -8247 for current_id 2725660, if negative, datou_current will be reset difference : -8310 for current_id 2725674, if negative, datou_current will be reset difference : -8728 for current_id 2725696, if negative, datou_current will be reset difference : -10649 for current_id 2725753, if negative, datou_current will be reset difference : -9714 for current_id 2731517, if negative, datou_current will be reset difference : -4997 for current_id 2725041, if negative, datou_current will be reset difference : -687 for current_id 2725465, if negative, datou_current will be reset difference : -1228 for current_id 2725504, if negative, datou_current will be reset difference : -2127 for current_id 2725555, if negative, datou_current will be reset difference : -2067 for current_id 2725556, if negative, datou_current will be reset difference : -4220 for current_id 2727274, if negative, datou_current will be reset difference : -4343 for current_id 2727381, if negative, datou_current will be reset difference : -4468 for current_id 2733789, if negative, datou_current will be reset difference : 165 for current_id 2725442, if negative, datou_current will be reset difference : -1947 for current_id 2725549, if negative, datou_current will be reset difference : -1885 for current_id 2725550, if negative, datou_current will be reset difference : -15209 for current_id 2725960, if negative, datou_current will be reset difference : -4587 for current_id 2736323, if negative, datou_current will be reset difference : -11729 for current_id 2734874, if negative, datou_current will be reset difference : -9047 for current_id 2750087, if negative, datou_current will be reset difference : -11100 for current_id 2750094, if negative, datou_current will be reset difference : -12288 for current_id 2750127, if negative, datou_current will be reset difference : -9068 for current_id 2750248, if negative, datou_current will be reset difference : -9074 for current_id 2750256, if negative, datou_current will be reset difference : -12348 for current_id 2750268, if negative, datou_current will be reset difference : -12230 for current_id 2750293, if negative, datou_current will be reset difference : -12358 for current_id 2750298, if negative, datou_current will be reset Host key verification failed. difference : -9110 for current_id 2750342, if negative, datou_current will be reset difference : -9117 for current_id 2750452, if negative, datou_current will be reset difference : -9169 for current_id 2750453, if negative, datou_current will be reset difference : -9288 for current_id 2750454, if negative, datou_current will be reset difference : -9229 for current_id 2750455, if negative, datou_current will be reset difference : -9289 for current_id 2750458, if negative, datou_current will be reset difference : -9296 for current_id 2750459, if negative, datou_current will be reset difference : -9349 for current_id 2750460, if negative, datou_current will be reset difference : -9369 for current_id 2750461, if negative, datou_current will be reset difference : -9409 for current_id 2750463, if negative, datou_current will be reset difference : -9465 for current_id 2750466, if negative, datou_current will be reset difference : -9478 for current_id 2750467, if negative, datou_current will be reset difference : -9527 for current_id 2750468, if negative, datou_current will be reset difference : -9553 for current_id 2750469, if negative, datou_current will be reset difference : -9588 for current_id 2750472, if negative, datou_current will be reset difference : -9649 for current_id 2750473, if negative, datou_current will be reset difference : -9658 for current_id 2750475, if negative, datou_current will be reset difference : -9668 for current_id 2750476, if negative, datou_current will be reset difference : -9707 for current_id 2750477, if negative, datou_current will be reset difference : -9769 for current_id 2750478, if negative, datou_current will be reset difference : -9722 for current_id 2750479, if negative, datou_current will be reset difference : -9827 for current_id 2750480, if negative, datou_current will be reset difference : -9969 for current_id 2750481, if negative, datou_current will be reset difference : -9839 for current_id 2750482, if negative, datou_current will be reset difference : -10017 for current_id 2750483, if negative, datou_current will be reset difference : -10268 for current_id 2750484, if negative, datou_current will be reset difference : -10198 for current_id 2750485, if negative, datou_current will be reset difference : -10373 for current_id 2750486, if negative, datou_current will be reset difference : -11455 for current_id 2750487, if negative, datou_current will be reset difference : -11749 for current_id 2750505, if negative, datou_current will be reset difference : -15688 for current_id 2750513, if negative, datou_current will be reset difference : -5429 for current_id 2750517, if negative, datou_current will be reset difference : -5489 for current_id 2750518, if negative, datou_current will be reset difference : -5610 for current_id 2750519, if negative, datou_current will be reset difference : -5547 for current_id 2750520, if negative, datou_current will be reset difference : -5633 for current_id 2750521, if negative, datou_current will be reset difference : -5668 for current_id 2750522, if negative, datou_current will be reset difference : -5668 for current_id 2750523, if negative, datou_current will be reset difference : -5847 for current_id 2750524, if negative, datou_current will be reset difference : -5899 for current_id 2750525, if negative, datou_current will be reset difference : -5964 for current_id 2750526, if negative, datou_current will be reset difference : -6027 for current_id 2750527, if negative, datou_current will be reset difference : -6091 for current_id 2750528, if negative, datou_current will be reset difference : -6112 for current_id 2750529, if negative, datou_current will be reset difference : -5789 for current_id 2750530, if negative, datou_current will be reset difference : -6148 for current_id 2750531, if negative, datou_current will be reset difference : -6382 for current_id 2750532, if negative, datou_current will be reset difference : -6328 for current_id 2750533, if negative, datou_current will be reset difference : -6449 for current_id 2750534, if negative, datou_current will be reset difference : -6207 for current_id 2750538, if negative, datou_current will be reset difference : -5729 for current_id 2750539, if negative, datou_current will be reset difference : -6629 for current_id 2750540, if negative, datou_current will be reset difference : -12221 for current_id 2750544, if negative, datou_current will be reset difference : -12114 for current_id 2750545, if negative, datou_current will be reset difference : -5668 for current_id 2750547, if negative, datou_current will be reset difference : -5633 for current_id 2750548, if negative, datou_current will be reset difference : -5490 for current_id 2750549, if negative, datou_current will be reset difference : -12385 for current_id 2750550, if negative, datou_current will be reset difference : -5567 for current_id 2750551, if negative, datou_current will be reset difference : -12444 for current_id 2750552, if negative, datou_current will be reset difference : -8604 for current_id 2750555, if negative, datou_current will be reset About to reset 200 current_datou ! select a.hostname, a.PID, a.mtr_current_id, created_at from (select * from MTRAdmin.mem_info where mtr_current_id in (2591988,2595013,2598020,2707471,2711410,2718850,2727237,2724868,2724906,2724909,2725035,2725038,2725043,2725045,2725050,2725136,2725137,2725139,2725141,2725145,2725146,2725150,2725152,2725157,2725159,2725160,2725174,2725193,2725211,2725213,2725220,2725224,2725227,2725253,2725263,2725372,2725568,2724942,2725794,2725021,2725027,2725031,2725039,2725046,2725051,2725433,2725451,2725459,2725460,2725471,2725496,2725513,2725523,2725544,2725559,2725560,2725569,2725570,2725577,2725578,2725595,2725596,2725609,2725610,2725623,2725624,2725641,2725655,2725656,2725669,2725670,2725691,2725703,2725719,2725723,2725728,2725748,2725757,2725773,2725842,2726562,2726642,2727131,2727380,2727914,2733054,2733174,2733178,2733635,2733663,2734128,2725025,2725040,2725047,2725052,2725457,2725476,2725484,2725508,2725514,2725522,2725551,2725552,2725571,2725572,2725585,2725586,2725607,2725608,2725619,2725620,2725649,2725650,2725660,2725674,2725696,2725753,2731517,2725041,2725465,2725504,2725555,2725556,2727274,2727381,2733789,2725549,2725550,2725960,2736323,2734874,2750087,2750094,2750127,2750248,2750256,2750268,2750293,2750298,2750342,2750452,2750453,2750454,2750455,2750458,2750459,2750460,2750461,2750463,2750466,2750467,2750468,2750469,2750472,2750473,2750475,2750476,2750477,2750478,2750479,2750480,2750481,2750482,2750483,2750484,2750485,2750486,2750487,2750505,2750513,2750517,2750518,2750519,2750520,2750521,2750522,2750523,2750524,2750525,2750526,2750527,2750528,2750529,2750530,2750531,2750532,2750533,2750534,2750538,2750539,2750540,2750544,2750545,2750547,2750548,2750549,2750550,2750551,2750552,2750555) order by created_at desc limit 99999999) as a group by a.mtr_current_id order by a.created_at desc; can't kill processus 1533692 for datou current 2725433 on unknown host catherine time start.command timeout = 5 255 kill 2725451 done Catched exception ! Connect or reconnect ! kill 2725451 failed on rene Catched exception ! Connect or reconnect ! Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 100, in insert number = cursor.execute(query, args) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1114, "The table 'mtr_datou_current' is full") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/utils/delete_batch_current_inutile.py", line 114, in kill_processus context.DQ.update_current_state([str(current_id)], 99) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/datou_queries.py", line 170, in update_current_state self.gq.insert(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 112, in insert number = cursor.execute(query, args) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1114, "The table 'mtr_datou_current' is full") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 100, in insert number = cursor.execute(query, args) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1114, "The table 'mtr_datou_current' is full") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "prod/datou.py", line 306, in datouReset(context, limit, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 1279, in datouReset kill_processus(context, list_processus_to_reset) File "/home/admin/workarea/git/Velours/python/mtr/utils/delete_batch_current_inutile.py", line 117, in kill_processus context.DQ.update_current_state([str(current_id)],98) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/datou_queries.py", line 170, in update_current_state self.gq.insert(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 112, in insert number = cursor.execute(query, args) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1205, 'Lock wait timeout exceeded; try restarting transaction') Command exited with non-zero status 1 1.04user 0.62system 1:03.47elapsed 2%CPU (0avgtext+0avgdata 102784maxresident)k 0inputs+184outputs (3major+33973minor)pagefaults 0swaps