python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 8 -a ' -a 3385 -l 20 --fifo' -s datou_current_sts -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 : 3172653 load datou : 3385 # 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 we have a portfolio with more photos than limit : 118>20 please execute split_portfolio.py -i 20199824 -l 20 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 3385, datou_cur_ids : ['2543260'] with mtr_portfolio_ids : ['20199824'] and first list_photo_ids : [] new path : /proc/3172653/ 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 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.015305519104003906 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:split_time_score Tue Feb 4 08:38:08 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'}] (('07', 50), ('08', 68)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 108} 04022025 20199824 Nombre de photos uploadées : 118 / 23040 (0%) 04022025 20199824 Nombre de photos taguées (types de déchets): 108 / 118 (91%) 04022025 20199824 Nombre de photos taguées (volume) : 108 / 118 (91%) elapsed_time : load_data_split_time_score 3.814697265625e-06 elapsed_time : order_list_meta_photo_and_scores 4.1484832763671875e-05 ?????????? elapsed_time : fill_and_build_computed_from_old_data 0.0038759708404541016 elapsed_time : insert_dashboard_record_day_entry 0.02219533920288086 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 elapsed_time : list_photo_by_hashtags 0.010134696960449219 Creating list_photo_total elapsed_time : select_descriptors 1.3661696910858154 04022025 20199824 Nombre de photos avec descriptors (type 5680) : 28 / 30 (93%) Missing descriptors for photos 0 and 1334463584 0:00:00|ON:Missing descriptors for photos 1334463584 and 1334463625 Missing descriptors for photos 1334463625 and 1334463947 Missing descriptors for photos 1334463947 and 1334464429 Missing descriptors for photos 1334464429 and 1334465020 Missing descriptors for photos 1334465020 and 1334465014 Missing descriptors for photos 1334465014 and 1334465009 Missing descriptors for photos 1334465009 and 1334465003 Missing descriptors for photos 1334465003 and 1334465039 Missing descriptors for photos 1334465039 and 1334465038 Missing descriptors for photos 1334465038 and 1334465055 Missing descriptors for photos 1334465055 and 1334465083 Missing descriptors for photos 1334465083 and 1334465081 Missing descriptors for photos 1334465081 and 1334465110 Missing descriptors for photos 1334465110 and 1334465188 Missing descriptors for photos 1334465188 and 1334465600 Missing descriptors for photos 1334465600 and 1334465980 Missing descriptors for photos 1334465980 and 1334465977 Missing descriptors for photos 1334465977 and 1334466413 Missing descriptors for photos 1334466413 and 1334466536 Missing descriptors for photos 1334466536 and 1334466765 Missing descriptors for photos 1334466765 and 1334466868 Missing descriptors for photos 1334466868 and 1334466895 Missing descriptors for photos 1334466895 and 1334466893 Missing descriptors for photos 1334466893 and 1334467382 Missing descriptors for photos 1334467382 and 1334467357 Missing descriptors for photos 1334467357 and 1334467476 Missing descriptors for photos 1334467476 and 1334468204 Missing descriptors for photos 1334468204 and 1334469558 Missing descriptors for photos 1334469558 and 1334470013 Missing descriptors for photos 1334470013 and 1334470011 Missing descriptors for photos 1334470011 and 1334470160 Missing descriptors for photos 1334470160 and 1334470158 Missing descriptors for photos 1334470158 and 1334470254 Missing descriptors for photos 1334470254 and 1334470379 Missing descriptors for photos 1334470379 and 1334470377 Missing descriptors for photos 1334470377 and 1334470430 Missing descriptors for photos 1334470430 and 1334470412 Missing descriptors for photos 1334470527 and 1334470554 Missing descriptors for photos 1334470554 and 1334470552 Missing descriptors for photos 1334470552 and 1334470828 Missing descriptors for photos 1334470828 and 1334470796 Missing descriptors for photos 1334470796 and 1334471186 Missing descriptors for photos 1334471186 and 1334471109 Missing descriptors for photos 1334471109 and 1334472693 Missing descriptors for photos 1334472693 and 1334472683 Missing descriptors for photos 1334472683 and 1334472859 Missing descriptors for photos 1334472859 and 1334473336 Missing descriptors for photos 1334473336 and 1334473333 Missing descriptors for photos 1334473333 and 1334474305 Missing descriptors for photos 1334474305 and 1334474214 Missing descriptors for photos 1334474214 and 1334474728 Missing descriptors for photos 1334475181 and 1334475176 Missing descriptors for photos 1334475176 and 1334475217 Missing descriptors for photos 1334475217 and 1334475215 Missing descriptors for photos 1334475247 and 1334475324 Missing descriptors for photos 1334475324 and 1334475322 Missing descriptors for photos 1334475322 and 1334475468 Missing descriptors for photos 1334475527 and 1334475524 Missing descriptors for photos 1334475524 and 1334475557 Missing descriptors for photos 1334475557 and 1334475555 Missing descriptors for photos 1334475555 and 1334475599 Missing descriptors for photos 1334475599 and 1334475597 Missing descriptors for photos 1334475597 and 1334475792 Missing descriptors for photos 1334475792 and 1334475718 Missing descriptors for photos 1334475718 and 1334475856 Missing descriptors for photos 1334475856 and 1334475855 Missing descriptors for photos 1334475855 and 1334476025 Missing descriptors for photos 1334476025 and 1334476008 Missing descriptors for photos 1334476104 and 1334476148 Missing descriptors for photos 1334476148 and 1334476131 1:18:30.999880|OFF:0:05:29.000107|ON:Missing descriptors for photos 1334477862 and 1334477861 Missing descriptors for photos 1334477895 and 1334477929 Missing descriptors for photos 1334477929 and 1334477927 Missing descriptors for photos 1334477927 and 1334477978 Missing descriptors for photos 1334477978 and 1334477975 Missing descriptors for photos 1334478917 and 1334478913 0:07:29.999790|OFF:0:00:29.999831|ON: WARNING condition_same_param while we were looking loading descriptors Missing descriptors for photos 1334480313 and 1334480278 04022025 Removing 7 photos because of the 'same image' condition Total on : 5160.99967 list_time_on Total off : 358.99993800000004 list_time_off dist_desc begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 118 time used for this insertion : 0.028921127319335938 photos_removed : len 7 elapsed_time : remove_photo_duplicate 0.06424450874328613 To do, maybe not at the correct place ! ......................................................................................................................force hashtag to JRM elapsed_time : CREATE_PORT_BATCH_BY_HOUR 0.007855415344238281 NUMBER BATCH : 5 list_ponderation used : [1e-05, 1e-05, 1e-05, 1e-05, 1e-05] , list_hashtag_class_create_as_list : ['jrm'] 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 result_one_balle_Type_JRM:{'day': '04022025', 'map_nb_amount': {0: 0, 1: 1, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 360.0009911060333, 'nb_balles_papier': 1e-05, 'begin_time_port': 'image_04022025_08_30_06_29887.jpg'} Production hashtag (incorrect ponderation at 20-10-18) : 1e-05 We have rejected 13 photos because of the batch_size condition ! NUMBER BATCH list_of_portfolios_to_create : 1 list_same_port_ids : [] https://marlene.fotonower.com/api/v1/secured/portfolio/new?name=JRM_diff_batch__04022025_08_30_06_029887&access_token=0fc1cdda0f63f39f777d9cb33b1aa204 # 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 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 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 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 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 ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 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`=20200963 AND mptpi.`type`=3726 To do elapsed_time : count_nb_balles_and_create_portfolio 1.4199838638305664 # DISPLAY ALL COLLECTED DATA : {'04022025': {'nb_upload': 118, 'nb_taggue_class': 108, 'nb_taggue_densite': 108, 'nb_descriptors': 28}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1334480313, 1334480278, 1334480243, 1334480240, 1334479790, 1334479788, 1334479682, 1334479667, 1334479240, 1334479150, 1334478917, 1334478913, 1334478415, 1334478321, 1334477978, 1334477975, 1334477929, 1334477927, 1334477896, 1334477895] Looping around the photos to save general results len do output : 1 /20199824Didn'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 ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334480313', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334480278', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334480243', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334480240', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334479790', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334479788', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334479682', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334479667', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334479240', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334479150', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334478917', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334478913', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334478415', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334478321', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334477978', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334477975', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334477929', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334477927', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334477896', None, None, None, None, None, '2543260') ('3385', None, None, None, None, None, None, None, '2543260') ('3385', '20199824', '1334477895', None, None, None, None, None, '2543260') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 21 time used for this insertion : 0.01420450210571289 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.978527545928955 time spend to save output : 0.014620304107666016 total time spend for step 1 : 2.993147850036621 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.03user 1.04system 0:05.73elapsed 36%CPU (0avgtext+0avgdata 101648maxresident)k 184inputs+272outputs (2major+63214minor)pagefaults 0swaps