WARNING : number of outputs for step 13596 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11881 final have less inputs used (1) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11881 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13625 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 11884 send_mail_cod have less inputs used (3) than in the step definition (5) : 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 13596 have datatype=10 whereas input 3 of step 11884 have datatype=6 WARNING : type of output 1 of step 13596 doesn't seem to be define in the database( WARNING : type of input 3 of step 11881 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 0 of step 13625 have datatype=18 WARNING : type of output 1 of step 13625 doesn't seem to be define in the database( WARNING : type of input 5 of step 11884 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=22019963 AND mptpi.`type`=3726 To do This function is not protected ! # 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 ! 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 13596 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11881 final have less inputs used (1) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11881 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13625 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 11884 send_mail_cod have less inputs used (3) than in the step definition (5) : 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 13596 have datatype=10 whereas input 3 of step 11884 have datatype=6 WARNING : type of output 1 of step 13596 doesn't seem to be define in the database( WARNING : type of input 3 of step 11881 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 13596 have datatype=10 whereas input 0 of step 13625 have datatype=18 WARNING : type of output 1 of step 13625 doesn't seem to be define in the database( WARNING : type of input 5 of step 11884 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=22020684 AND mptpi.`type`=3726 To do elapsed_time : count_nb_balles_and_create_portfolio 0.6635725498199463 # DISPLAY ALL COLLECTED DATA : {'03042025': {'nb_upload': 535, 'nb_taggue_class': 2436, 'nb_taggue_densite': 2436}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1349791182, 1349791171, 1349791153, 1349791145, 1349791140, 1349791076, 1349791048, 1349791027, 1349791022, 1349791003, 1349790971, 1349790867, 1349790825, 1349790822, 1349790812, 1349790749, 1349790744, 1349790742, 1349790737, 1349790734, 1349790727, 1349790667, 1349790658, 1349790655, 1349790621, 1349790617, 1349790613, 1349790608, 1349790602, 1349790594, 1349790561, 1349790555, 1349790549, 1349790542, 1349790526, 1349790522, 1349790516, 1349790511, 1349790505, 1349790497, 1349790410, 1349790386, 1349790385, 1349790382, 1349790317, 1349790300, 1349790291, 1349790282, 1349790257, 1349790243, 1349790090, 1349790072, 1349790055, 1349790044, 1349789714, 1349789705, 1349789667, 1349789652, 1349789619, 1349789237, 1349789199, 1349789126, 1349789066, 1349788974, 1349788724, 1349788701, 1349788685, 1349788643, 1349788494, 1349788458, 1349788426, 1349788402, 1349788354, 1349788094, 1349788030, 1349787944, 1349787879, 1349787814, 1349787091, 1349787031, 1349786982, 1349786903, 1349786834, 1349786075, 1349786013, 1349785955, 1349785894, 1349785309, 1349785200, 1349785130, 1349785051, 1349784827, 1349784769, 1349784741, 1349784712, 1349784682, 1349784585, 1349784549, 1349784514, 1349784484] Looping around the photos to save general results len do output : 1 /21995993Didn't retrieve data . before output type Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791182', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791171', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791153', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791145', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791140', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791076', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791048', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791027', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791022', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349791003', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790971', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790867', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790825', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790822', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790812', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790749', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790744', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790742', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790737', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790734', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790727', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790667', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790658', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790655', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790621', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790617', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790613', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790608', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790602', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790594', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790561', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790555', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790549', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790542', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790526', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790522', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790516', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790511', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790505', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790497', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790410', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790386', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790385', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790382', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790317', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790300', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790291', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790282', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790257', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790243', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790090', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790072', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790055', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349790044', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789714', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789705', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789667', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789652', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789619', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789237', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789199', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789126', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349789066', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788974', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788724', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788701', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788685', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788643', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788494', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788458', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788426', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788402', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788354', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788094', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349788030', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349787944', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349787879', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349787814', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349787091', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349787031', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349786982', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349786903', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349786834', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349786075', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349786013', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349785955', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349785894', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349785309', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349785200', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349785130', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349785051', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784827', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784769', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784741', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784712', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784682', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784585', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784549', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784514', None, None, None, None, None, '2720383') ('4876', None, None, None, None, None, None, None, '2720383') ('4876', '21995993', '1349784484', None, None, None, None, None, '2720383') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 101 time used for this insertion : 0.02698826789855957 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.05303955078125 time spend to save output : 0.027864456176757812 total time spend for step 1 : 1.0809040069580078 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 1 set_done_treatment 1.68user 0.64system 0:03.58elapsed 64%CPU (0avgtext+0avgdata 104572maxresident)k 0inputs+128outputs (1major+60828minor)pagefaults 0swaps