python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4189' -s datou_current_4189 -M 0 -S 0 -U 95,95,120 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 611554 load datou : 4189 # 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 for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? load thcls load pdts Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec no input labels no input values updating current state to 1 list_input_json: {} Current got : datou_id : 4189, datou_cur_ids : ['3819618'] with mtr_portfolio_ids : ['27442238'] and first list_photo_ids : [] new path : /proc/611554/ Inside batchDatouExec : verbose : 0 # 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 ! List Step Type Loaded in datou : split_time_score over limit max, limiting to limit_max 100 list_input_json : {} origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! we have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB time to download the photos : 0.07117319107055664 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:split_time_score Thu Oct 2 10:30:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec begin split time score 2022-04-13 10:29:59 0 TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 3379, 'mtr_user_id': 31, 'name': 'learn_classif_flux_maj_generique_effnet_v2_s_02062022', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'aluminium,ela,film_pedb,flux_dev,jrm,pcm,pcnc,pehd_pp,pet_clair,refus,tapis_vide', 'svm_portfolios_learning': '5515864,5515840,5515844,5515850,6244400,6237996,6237998,5515847,5515841,5515868,5515866', 'photo_hashtag_type': 4374, 'photo_desc_type': 5680, 'type_classification': 'tf_classification2', 'hashtag_id_list': '493546845,492741797,2107760237,2107760238,495916461,560181804,1284539308,2107760239,2107755846,538914404,2107748999'}] thcls : [{'id': 3513, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2_tf', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 4557, 'photo_desc_type': 5767, 'type_classification': 'tf_classification2', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('10', 161),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 95} L02102025 27442238 Nombre de photos uploadées : 161 / 23040 (0%) 02102025 27442238 Nombre de photos taguées (types de déchets): 95 / 161 (59%) 02102025 27442238 Nombre de photos taguées (volume) : 95 / 161 (59%) elapsed_time : load_data_split_time_score 3.0994415283203125e-06 elapsed_time : order_list_meta_photo_and_scores 4.267692565917969e-05 LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL?????????????????????????????????????????????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.008277654647827148 LCatched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.6364421844482422 LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL Creating list_photo_by_hashtags Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None elapsed_time : list_photo_by_hashtags 0.10416460037231445 Creating list_photo_total elapsed_time : select_descriptors 2.2653825283050537 02102025 27442238 Nombre de photos avec descriptors (type 5680) : 44 / 110 (40%) ERROR : Hum hum, what can we do for different size of descriptors (ignore the difference ) : 0 vs 1280 photo_id : 1387361204 photo_id_prec : 0 L0:00:00|ON:LLLLLLLLLLLLLLLLLLLLLLLLLMissing descriptors for photos 1387362560 and 1387362564 LMissing descriptors for photos 1387362564 and 1387362567 LMissing descriptors for photos 1387362567 and 1387362667 LLLLLLLMissing descriptors for photos 1387363178 and 1387363187 LMissing descriptors for photos 1387363187 and 1387363189 LMissing descriptors for photos 1387363189 and 1387363190 LMissing descriptors for photos 1387363190 and 1387363194 LMissing descriptors for photos 1387363194 and 1387363208 LMissing descriptors for photos 1387363208 and 1387363215 LLLMissing descriptors for photos 1387363379 and 1387363382 LMissing descriptors for photos 1387363382 and 1387363384 LMissing descriptors for photos 1387363384 and 1387363387 LMissing descriptors for photos 1387363387 and 1387363390 LMissing descriptors for photos 1387363390 and 1387363397 LMissing descriptors for photos 1387363397 and 1387363399 LMissing descriptors for photos 1387363399 and 1387363402 LMissing descriptors for photos 1387363402 and 1387363411 LMissing descriptors for photos 1387363411 and 1387363413 LMissing descriptors for photos 1387363413 and 1387363416 LMissing descriptors for photos 1387363416 and 1387363428 LMissing descriptors for photos 1387363428 and 1387363429 LMissing descriptors for photos 1387363429 and 1387363431 LMissing descriptors for photos 1387363431 and 1387363432 LMissing descriptors for photos 1387363432 and 1387363434 LMissing descriptors for photos 1387363434 and 1387363439 LMissing descriptors for photos 1387363439 and 1387363461 LMissing descriptors for photos 1387363461 and 1387363513 LMissing descriptors for photos 1387363513 and 1387363527 LMissing descriptors for photos 1387363527 and 1387363533 LMissing descriptors for photos 1387363533 and 1387363537 LMissing descriptors for photos 1387363537 and 1387363556 LMissing descriptors for photos 1387363556 and 1387363603 LMissing descriptors for photos 1387363603 and 1387363608 LMissing descriptors for photos 1387363608 and 1387363618 LMissing descriptors for photos 1387363618 and 1387363622 LMissing descriptors for photos 1387363622 and 1387363627 LMissing descriptors for photos 1387363627 and 1387363639 LLLMissing descriptors for photos 1387363697 and 1387363715 LMissing descriptors for photos 1387363715 and 1387363750 LMissing descriptors for photos 1387363750 and 1387363754 LMissing descriptors for photos 1387363754 and 1387363813 LMissing descriptors for photos 1387363813 and 1387363830 LMissing descriptors for photos 1387363830 and 1387363844 LMissing descriptors for photos 1387363844 and 1387363890 LMissing descriptors for photos 1387363890 and 1387364092 LLLLL0:13:00.048335|OFF:LLLLLLLLLLLLLLL0:01:59.827873|ON:LLLERROR : Hum hum, what can we do for different size of descriptors (ignore the difference ) : 1280 vs 0 photo_id : 1387364535 photo_id_prec : 1387364347 LMissing descriptors for photos 1387364535 and 1387364538 LMissing descriptors for photos 1387364538 and 1387364588 LMissing descriptors for photos 1387364588 and 1387364878 LMissing descriptors for photos 1387364878 and 1387364884 LMissing descriptors for photos 1387364884 and 1387364993 LMissing descriptors for photos 1387364993 and 1387365176 LMissing descriptors for photos 1387365176 and 1387365180 LMissing descriptors for photos 1387365180 and 1387365182 LMissing descriptors for photos 1387365182 and 1387365185 LMissing descriptors for photos 1387365185 and 1387365190 LMissing descriptors for photos 1387365190 and 1387365192 LMissing descriptors for photos 1387365192 and 1387365203 LMissing descriptors for photos 1387365203 and 1387365214 LMissing descriptors for photos 1387365214 and 1387365220 LMissing descriptors for photos 1387365220 and 1387365224 LMissing descriptors for photos 1387365224 and 1387365237 LMissing descriptors for photos 1387365237 and 1387365240 LMissing descriptors for photos 1387365240 and 1387365371 LMissing descriptors for photos 1387365371 and 1387365374 LMissing descriptors for photos 1387365374 and 1387365378 LMissing descriptors for photos 1387365378 and 1387365383 LMissing descriptors for photos 1387365383 and 1387365385 LMissing descriptors for photos 1387365385 and 1387365393 LMissing descriptors for photos 1387365393 and 1387365435 LMissing descriptors for photos 1387365435 and 1387365438 LMissing descriptors for photos 1387365438 and 1387365441 LMissing descriptors for photos 1387365441 and 1387365562 LMissing descriptors for photos 1387365562 and 1387365565 LMissing descriptors for photos 1387365565 and 1387365638 LMissing descriptors for photos 1387365638 and 1387365721 LMissing descriptors for photos 1387365721 and 1387365762 LMissing descriptors for photos 1387365762 and 1387365766 LMissing descriptors for photos 1387365766 and 1387365769 LMissing descriptors for photos 1387365769 and 1387365771 LMissing descriptors for photos 1387365771 and 1387365775 LMissing descriptors for photos 1387365775 and 1387365797 LMissing descriptors for photos 1387365797 and 1387365798 LMissing descriptors for photos 1387365798 and 1387365801 LMissing descriptors for photos 1387365801 and 1387365808 LMissing descriptors for photos 1387365808 and 1387365868 LMissing descriptors for photos 1387365868 and 1387365875 LMissing descriptors for photos 1387365875 and 1387365897 LMissing descriptors for photos 1387365897 and 1387365900 LMissing descriptors for photos 1387365900 and 1387365917 LMissing descriptors for photos 1387365917 and 1387365921 LMissing descriptors for photos 1387365921 and 1387365923 LMissing descriptors for photos 1387365923 and 1387365926 LMissing descriptors for photos 1387365926 and 1387365935 LMissing descriptors for photos 1387365935 and 1387365940 LMissing descriptors for photos 1387365940 and 1387365943 LMissing descriptors for photos 1387365943 and 1387365950 LMissing descriptors for photos 1387365950 and 1387365953 LMissing descriptors for photos 1387365953 and 1387365957 LMissing descriptors for photos 1387365957 and 1387365987 LMissing descriptors for photos 1387365987 and 1387366000 LMissing descriptors for photos 1387366000 and 1387366003 LMissing descriptors for photos 1387366003 and 1387366007 LMissing descriptors for photos 1387366007 and 1387366011 LMissing descriptors for photos 1387366011 and 1387366071 LMissing descriptors for photos 1387366071 and 1387366098 LMissing descriptors for photos 1387366098 and 1387366118 LMissing descriptors for photos 1387366118 and 1387366156 LMissing descriptors for photos 1387366156 and 1387366167 LMissing descriptors for photos 1387366167 and 1387366183 LMissing descriptors for photos 1387366183 and 1387366203 L 02102025 Removing 8 photos because of the 'same image' condition Total on : 780.048335 list_time_on Warning in study_and_display_distrib_list : min=max : 780.048335 780.048335 Total off : 119.827873 list_time_off dist_desc begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 161 time used for this insertion : 0.07634639739990234 photos_removed : len 8 elapsed_time : remove_photo_duplicate 0.1706383228302002 To do, maybe not at the correct place ! .L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.L.Lforce hashtag to JRM elapsed_time : CREATE_PORT_BATCH_BY_HOUR 0.024844646453857422 NUMBER BATCH : 2 list_ponderation used : [1e-05, 1e-05, 1e-05, 1e-05, 1e-05] , list_hashtag_class_create_as_list : ['jrm'] LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLresult_one_balle_Type_JRM:{'day': '02102025', 'map_nb_amount': {0: 2, 1: 30, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 780.0483350753784, 'nb_balles_papier': 0.0003200000000000002, 'begin_time_port': 'image_02102025_10_00_02_768368_0000.jpg'} Production hashtag (incorrect ponderation at 20-10-18) : 0.0003200000000000002 LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info LLresult_one_balle_Type_JRM:{'day': '02102025', 'map_nb_amount': {0: 0, 1: 4, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 660.0374569892883, 'nb_balles_papier': 4e-05, 'begin_time_port': 'image_02102025_10_15_02_644576_0001.jpg'} Production hashtag (incorrect ponderation at 20-10-18) : 4e-05 We have rejected 0 photos because of the batch_size condition ! NUMBER BATCH list_of_portfolios_to_create : 2 list_same_port_ids : [] list_same_port_ids : [] # 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 ! 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`=27443051 AND mptpi.`type`=3726 To do # 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 ! 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`=27443062 AND mptpi.`type`=3726 To do elapsed_time : count_nb_balles_and_create_portfolio 6.869344711303711 # DISPLAY ALL COLLECTED DATA : {'02102025': {'nb_upload': 161, 'nb_taggue_class': 95, 'nb_taggue_densite': 95, 'nb_descriptors': 44}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1387366203, 1387366183, 1387366167, 1387366156, 1387366118, 1387366098, 1387366071, 1387366011, 1387366007, 1387366003, 1387366000, 1387365987, 1387365957, 1387365953, 1387365950, 1387365943, 1387365940, 1387365935, 1387365926, 1387365923, 1387365921, 1387365917, 1387365900, 1387365897, 1387365875, 1387365868, 1387365808, 1387365801, 1387365798, 1387365797, 1387365775, 1387365771, 1387365769, 1387365766, 1387365762, 1387365721, 1387365638, 1387365565, 1387365562, 1387365441, 1387365438, 1387365435, 1387365393, 1387365385, 1387365383, 1387365378, 1387365374, 1387365371, 1387365240, 1387365237, 1387365224, 1387365220, 1387365214, 1387365203, 1387365192, 1387365190, 1387365185, 1387365182, 1387365180, 1387365176, 1387364993, 1387364884, 1387364878, 1387364588, 1387364538, 1387364535, 1387364347, 1387364343, 1387364267, 1387364264, 1387364255, 1387364253, 1387364227, 1387364204, 1387364168, 1387364163, 1387364157, 1387364155, 1387364099, 1387364096, 1387364092, 1387363890, 1387363844, 1387363830, 1387363813, 1387363754, 1387363750, 1387363715, 1387363697, 1387363695, 1387363639, 1387363627, 1387363622, 1387363618, 1387363608, 1387363603, 1387363556, 1387363537, 1387363533, 1387363527] Looping around the photos to save general results len do output : 1 /27442238Didn'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 ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366203', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366183', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366167', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366156', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366118', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366098', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366071', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366011', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366007', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366003', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387366000', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365987', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365957', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365953', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365950', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365943', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365940', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365935', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365926', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365923', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365921', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365917', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365900', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365897', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365875', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365868', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365808', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365801', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365798', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365797', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365775', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365771', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365769', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365766', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365762', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365721', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365638', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365565', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365562', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365441', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365438', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365435', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365393', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365385', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365383', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365378', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365374', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365371', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365240', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365237', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365224', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365220', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365214', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365203', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365192', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365190', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365185', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365182', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365180', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387365176', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364993', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364884', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364878', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364588', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364538', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364535', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364347', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364343', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364267', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364264', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364255', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364253', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364227', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364204', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364168', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364163', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364157', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364155', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364099', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364096', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387364092', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363890', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363844', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363830', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363813', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363754', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363750', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363715', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363697', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363695', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363639', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363627', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363622', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363618', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363608', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363603', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363556', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363537', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363533', None, None, None, None, None, '3819618') ('4189', None, None, None, None, None, None, None, '3819618') ('4189', '27442238', '1387363527', None, None, None, None, None, '3819618') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 101 time used for this insertion : 0.04375505447387695 save_final save missing photos in datou_result : time spend for datou_step_exec : 10.34372353553772 time spend to save output : 0.04466676712036133 total time spend for step 1 : 10.388390302658081 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.53user 0.55system 0:15.08elapsed 13%CPU (0avgtext+0avgdata 103860maxresident)k 440inputs+472outputs (2major+49376minor)pagefaults 0swaps