python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4910 ' -s datou_current_4910 -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 : 3073524 load datou : 4910 # 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 ! 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 13969 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13970 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 13967 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 13967 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13974 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13968 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 13971 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13972 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13973 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 13975 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 13969 have datatype=11 whereas input 0 of step 13967 have datatype=2 WARNING : type of output 1 of step 13970 doesn't seem to be define in the database( WARNING : type of input 3 of step 13968 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13970 doesn't seem to be define in the database( WARNING : type of input 1 of step 13967 doesn't seem to be define in the database( WARNING : output 0 of step 13974 have datatype=10 whereas input 3 of step 13973 have datatype=6 WARNING : type of input 1 of step 13974 doesn't seem to be define in the database( WARNING : output 1 of step 13967 have datatype=7 whereas input 1 of step 13974 have datatype=None WARNING : type of output 1 of step 13974 doesn't seem to be define in the database( WARNING : type of input 4 of step 13968 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13969 doesn't seem to be define in the database( WARNING : type of input 1 of step 13970 doesn't seem to be define in the database( DataTypes for each output/input checked ! 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 : id de la photo (peut être local ou global) was removed should we ? donnée sous forme de nombre was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? chemin de la photo was removed should we ? donnée sous forme de texte was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? id de la photo (peut être local ou global) was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? donnée sous forme de texte was removed should we ? 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 : 4910, datou_cur_ids : ['2578915'] with mtr_portfolio_ids : ['19962217'] and first list_photo_ids : [] new path : /proc/3073524/ 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) 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 13969 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13970 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 13967 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 13967 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13974 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13968 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 13971 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13972 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 13973 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 13975 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 13969 have datatype=11 whereas input 0 of step 13967 have datatype=2 WARNING : type of output 1 of step 13970 doesn't seem to be define in the database( WARNING : type of input 3 of step 13968 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13970 doesn't seem to be define in the database( WARNING : type of input 1 of step 13967 doesn't seem to be define in the database( WARNING : output 0 of step 13974 have datatype=10 whereas input 3 of step 13973 have datatype=6 WARNING : type of input 1 of step 13974 doesn't seem to be define in the database( WARNING : output 1 of step 13967 have datatype=7 whereas input 1 of step 13974 have datatype=None WARNING : type of output 1 of step 13974 doesn't seem to be define in the database( WARNING : type of input 4 of step 13968 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 13969 doesn't seem to be define in the database( WARNING : type of input 1 of step 13970 doesn't seem to be define in the database( DataTypes for each output/input checked ! List Step Type Loaded in datou : copy_chis, consolidate_hashtags_from_manual_portfolio, rle_unique_nms_with_priority, ventilate_hashtags_in_portfolio, final, blur_detection, brightness, send_mail_cod, 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 ! BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 27 ; length of list_pids : 27 ; length of list_args : 27 time to download the photos : 6.029457092285156 About to test input to load we should then remove the video here, and this would fix the bug of datou_current ! Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 9 step1:copy_chis Wed Feb 12 11:20:35 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 step datou_step_copy_crop batch 1 Loaded 907 chid ids of type : 4211 batch 1 Loaded 153 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 142 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 130 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 126 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 134 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 130 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 181 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 240 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : copy_chis we use saveGeneral [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 27 /1331076103Didn't retrieve data . /1331076121Didn't retrieve data . /1331076134Didn't retrieve data . /1331076148Didn't retrieve data . /1331076151Didn't retrieve data . /1331076155Didn't retrieve data . /1331076203Didn't retrieve data . /1331076226Didn't retrieve data . /1331076241Didn't retrieve data . /1331076281Didn't retrieve data . /1331076336Didn't retrieve data . /1331076344Didn't retrieve data . /1331076348Didn't retrieve data . /1331076351Didn't retrieve data . /1331076401Didn't retrieve data . /1331076407Didn't retrieve data . /1331076459Didn't retrieve data . /1331076461Didn't retrieve data . /1331076494Didn't retrieve data . /1331076500Didn't retrieve data . /1331076505Didn't retrieve data . /1331076506Didn't retrieve data . /1331076529Didn't retrieve data . /1331076539Didn't retrieve data . /1331076602Didn't retrieve data . /1331076605Didn't retrieve data . /1331076612Didn'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 ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076612', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076605', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076602', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076539', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076529', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076506', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076505', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076500', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076494', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076461', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076459', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076407', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076401', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076351', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076348', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076344', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076336', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076281', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076241', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076226', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076203', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076155', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076151', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076148', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076134', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076121', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076103', None, None, None, None, None, '2578915') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 54 time used for this insertion : 0.014826774597167969 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6138179302215576 time spend to save output : 0.015416860580444336 total time spend for step 1 : 1.629234790802002 step2:consolidate_hashtags_from_manual_portfolio Wed Feb 12 11:20:37 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step consolidate_hashtags_from_manual_portfolio Iterating over portfolio : 19962217 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`=19962217 AND mptpi.`type`=4211 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('barquette_opaque','carton','ela','environnement','etiquette','film_plastique','kraft','metal','papier','pehd','pet_clair','pet_opaque','textiles_sanitaires','pet_fonce','mal_croppe','flou','autre')) To do 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`=19962217 AND mptpi.`type`=4211 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('barquette_opaque','carton','ela','environnement','etiquette','film_plastique','kraft','metal','papier','pehd','pet_clair','pet_opaque','textiles_sanitaires','pet_fonce','mal_croppe','flou','autre')) To do TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050847 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 1577 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1062, "Duplicate entry '1331396233-492741797-4211-2190-2369-136-282' for key 'crop_hashtag_ids.chi_cross_index_new_timed'") begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050848 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 1048 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050849 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4806 chid ids of type : 4211 batch 2 Loaded 148 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050850 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4934 chid ids of type : 4211 batch 2 Loaded 36 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050851 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050852 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4871 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050853 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 976 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050854 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4733 chid ids of type : 4211 batch 2 Loaded 1125 chid ids of type : 4211 begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050855 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 604 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050856 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4875 chid ids of type : 4211 batch 2 Loaded 382 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050857 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 3507 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050858 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 2122 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050859 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4198 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050860 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 2869 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050861 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 176 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20050862 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 4637 chid ids of type : 4211 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! (1205, 'Lock wait timeout exceeded; try restarting transaction') begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20448626 AND mpp.hide_status=0 ORDER BY ph.size desc To test ! Use context local managing function ! Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : consolidate_hashtags_from_manual_portfolio we use saveGeneral [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 6 /Tassign value string error string indices must be integers invalid literal for int() with base 10: 'T' begin to insert list_values into mtr_datou_result : length of list_values in save_final : 27 time used for this insertion : 0.016343355178833008 save_final save missing photos in datou_result : time spend for datou_step_exec : 2151.8936700820923 time spend to save output : 0.017454147338867188 total time spend for step 2 : 2151.911124229431 step3:rle_unique_nms_with_priority Wed Feb 12 11:56: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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 907 chid ids of type : 4211 seulement à utiliser dans la step consolidation batch 1 Loaded 82 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03206348419189453 seulement à utiliser dans la step consolidation batch 1 Loaded 80 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03367757797241211 seulement à utiliser dans la step consolidation batch 1 Loaded 78 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.032013654708862305 seulement à utiliser dans la step consolidation batch 1 Loaded 61 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03151082992553711 seulement à utiliser dans la step consolidation batch 1 Loaded 85 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03314614295959473 seulement à utiliser dans la step consolidation batch 1 Loaded 35 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02823352813720703 seulement à utiliser dans la step consolidation batch 1 Loaded 49 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.031243324279785156 seulement à utiliser dans la step consolidation batch 1 Loaded 48 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.031017780303955078 seulement à utiliser dans la step consolidation batch 1 Loaded 33 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03003525733947754 seulement à utiliser dans la step consolidation batch 1 Loaded 45 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.028762340545654297 seulement à utiliser dans la step consolidation batch 1 Loaded 47 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02982783317565918 seulement à utiliser dans la step consolidation batch 1 Loaded 42 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02970290184020996 seulement à utiliser dans la step consolidation batch 1 Loaded 39 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029922962188720703 seulement à utiliser dans la step consolidation batch 1 Loaded 41 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.0308687686920166 seulement à utiliser dans la step consolidation batch 1 Loaded 46 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030603885650634766 seulement à utiliser dans la step consolidation batch 1 Loaded 43 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.031152009963989258 seulement à utiliser dans la step consolidation batch 1 Loaded 52 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03099226951599121 seulement à utiliser dans la step consolidation batch 1 Loaded 35 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029710769653320312 seulement à utiliser dans la step consolidation batch 1 Loaded 26 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.028254270553588867 seulement à utiliser dans la step consolidation batch 1 Loaded 25 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029414653778076172 seulement à utiliser dans la step consolidation batch 1 Loaded 16 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.0318756103515625 seulement à utiliser dans la step consolidation batch 1 Loaded 25 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.031720876693725586 seulement à utiliser dans la step consolidation batch 1 Loaded 50 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.031822919845581055 seulement à utiliser dans la step consolidation batch 1 Loaded 45 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030147314071655273 seulement à utiliser dans la step consolidation batch 1 Loaded 35 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030365467071533203 seulement à utiliser dans la step consolidation batch 1 Loaded 36 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029454708099365234 seulement à utiliser dans la step consolidation batch 1 Loaded 37 chid ids of type : 4211 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030150890350341797 map_output_result : {1331076612: (0.5450478598779573, 'Should be the crop_list due to order', 0.1811874879988492), 1331076605: (0.5450478598779573, 'Should be the crop_list due to order', 0.1408214806750616), 1331076602: (0.5450478598779573, 'Should be the crop_list due to order', 0.10992919056451611), 1331076539: (0.5450478598779573, 'Should be the crop_list due to order', 0.11548528800593895), 1331076529: (0.5450478598779573, 'Should be the crop_list due to order', 0.12737913201609508), 1331076506: (0.5450478598779573, 'Should be the crop_list due to order', 0.5218860839604889), 1331076505: (0.5450478598779573, 'Should be the crop_list due to order', 0.5808925160670537), 1331076500: (0.5450478598779573, 'Should be the crop_list due to order', 0.6454551035023702), 1331076494: (0.5450478598779573, 'Should be the crop_list due to order', 0.7831263608059517), 1331076461: (0.5450478598779573, 'Should be the crop_list due to order', 0.6022873130103625), 1331076459: (0.5450478598779573, 'Should be the crop_list due to order', 0.6753420916650339), 1331076407: (0.5450478598779573, 'Should be the crop_list due to order', 0.5274028374792249), 1331076401: (0.5450478598779573, 'Should be the crop_list due to order', 0.5277049887816195), 1331076351: (0.5450478598779573, 'Should be the crop_list due to order', 0.7282357622273645), 1331076348: (0.5450478598779573, 'Should be the crop_list due to order', 0.49546525207711467), 1331076344: (0.5450478598779573, 'Should be the crop_list due to order', 0.5201594808243295), 1331076336: (0.5450478598779573, 'Should be the crop_list due to order', 0.8174808735469522), 1331076281: (0.5450478598779573, 'Should be the crop_list due to order', 0.8495300418143212), 1331076241: (0.5450478598779573, 'Should be the crop_list due to order', 0.6663539461247303), 1331076226: (0.5450478598779573, 'Should be the crop_list due to order', 0.4656523844799976), 1331076203: (0.5450478598779573, 'Should be the crop_list due to order', 0.8325339604542502), 1331076155: (0.5450478598779573, 'Should be the crop_list due to order', 0.7438892498541725), 1331076151: (0.5450478598779573, 'Should be the crop_list due to order', 0.6738986038608495), 1331076148: (0.5450478598779573, 'Should be the crop_list due to order', 0.6079833962860434), 1331076134: (0.5450478598779573, 'Should be the crop_list due to order', 0.5094901061922297), 1331076121: (0.5450478598779573, 'Should be the crop_list due to order', 0.5279899528823828), 1331076103: (0.5450478598779573, 'Should be the crop_list due to order', 0.7387293315475466)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 27 /1331076612.Didn't retrieve data . /1331076605.Didn't retrieve data . /1331076602.Didn't retrieve data . /1331076539.Didn't retrieve data . /1331076529.Didn't retrieve data . /1331076506.Didn't retrieve data . /1331076505.Didn't retrieve data . /1331076500.Didn't retrieve data . /1331076494.Didn't retrieve data . /1331076461.Didn't retrieve data . /1331076459.Didn't retrieve data . /1331076407.Didn't retrieve data . /1331076401.Didn't retrieve data . /1331076351.Didn't retrieve data . /1331076348.Didn't retrieve data . /1331076344.Didn't retrieve data . /1331076336.Didn't retrieve data . /1331076281.Didn't retrieve data . /1331076241.Didn't retrieve data . /1331076226.Didn't retrieve data . /1331076203.Didn't retrieve data . /1331076155.Didn't retrieve data . /1331076151.Didn't retrieve data . /1331076148.Didn't retrieve data . /1331076134.Didn't retrieve data . /1331076121.Didn't retrieve data . /1331076103.Didn't retrieve data . before output type Used above Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076612', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076605', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076602', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076539', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076529', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076506', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076505', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076500', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076494', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076461', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076459', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076407', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076401', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076351', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076348', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076344', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076336', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076281', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076241', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076226', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076203', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076155', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076151', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076148', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076134', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076121', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076103', None, None, None, None, None, '2578915') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 81 time used for this insertion : 0.015166044235229492 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.843012809753418 time spend to save output : 0.015958070755004883 total time spend for step 3 : 3.858970880508423 step4:ventilate_hashtags_in_portfolio Wed Feb 12 11:56:33 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step ventilate_hashtags_in_portfolio : To implement ! Iterating over portfolio : 19962217 get user id for portfolio 19962217 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`=19962217 AND mptpi.`type`=4211 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('barquette_opaque','carton','ela','environnement','etiquette','film_plastique','kraft','metal','papier','pehd','pet_clair','pet_opaque','textiles_sanitaires','pet_fonce','mal_croppe','flou','autre')) AND mptpi.`min_score`=0.5 To do To do ! Use context local managing function ! 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`=19962217 AND mptpi.`type`=4211 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('barquette_opaque','carton','ela','environnement','etiquette','film_plastique','kraft','metal','papier','pehd','pet_clair','pet_opaque','textiles_sanitaires','pet_fonce','mal_croppe','flou','autre')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/20050847,20050848,20050849,20050850,20050851,20050852,20050853,20050854,20050855,20050856,20050857,20050858,20050859,20050860,20050861,20050862,20448626?tags=ela,metal,pehd,etiquette,textiles_sanitaires,film_plastique,kraft,mal_croppe,pet_fonce,pet_opaque,carton,environnement,papier,pet_clair,flou,barquette_opaque,autre Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 1 /19962217. 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 ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076612', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076605', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076602', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076539', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076529', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076506', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076505', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076500', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076494', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076461', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076459', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076407', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076401', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076351', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076348', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076344', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076336', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076281', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076241', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076226', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076203', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076155', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076151', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076148', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076134', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076121', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076103', None, None, None, None, None, '2578915') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 28 time used for this insertion : 0.015764951705932617 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.7121853828430176 time spend to save output : 0.016199827194213867 total time spend for step 4 : 0.7283852100372314 step5:final Wed Feb 12 11:56:33 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 2 VR 22-3-18 : For now we do not clean correctly the datou structure Beginning of datou step final ! Inside saveOutput : final : False verbose : 0 original output for save of step final : {1331076612: ('0.10110718328397628',), 1331076605: ('0.10110718328397628',), 1331076602: ('0.10110718328397628',), 1331076539: ('0.10110718328397628',), 1331076529: ('0.10110718328397628',), 1331076506: ('0.10110718328397628',), 1331076505: ('0.10110718328397628',), 1331076500: ('0.10110718328397628',), 1331076494: ('0.10110718328397628',), 1331076461: ('0.10110718328397628',), 1331076459: ('0.10110718328397628',), 1331076407: ('0.10110718328397628',), 1331076401: ('0.10110718328397628',), 1331076351: ('0.10110718328397628',), 1331076348: ('0.10110718328397628',), 1331076344: ('0.10110718328397628',), 1331076336: ('0.10110718328397628',), 1331076281: ('0.10110718328397628',), 1331076241: ('0.10110718328397628',), 1331076226: ('0.10110718328397628',), 1331076203: ('0.10110718328397628',), 1331076155: ('0.10110718328397628',), 1331076151: ('0.10110718328397628',), 1331076148: ('0.10110718328397628',), 1331076134: ('0.10110718328397628',), 1331076121: ('0.10110718328397628',), 1331076103: ('0.10110718328397628',)} new output for save of step final : {1331076612: ('0.10110718328397628',), 1331076605: ('0.10110718328397628',), 1331076602: ('0.10110718328397628',), 1331076539: ('0.10110718328397628',), 1331076529: ('0.10110718328397628',), 1331076506: ('0.10110718328397628',), 1331076505: ('0.10110718328397628',), 1331076500: ('0.10110718328397628',), 1331076494: ('0.10110718328397628',), 1331076461: ('0.10110718328397628',), 1331076459: ('0.10110718328397628',), 1331076407: ('0.10110718328397628',), 1331076401: ('0.10110718328397628',), 1331076351: ('0.10110718328397628',), 1331076348: ('0.10110718328397628',), 1331076344: ('0.10110718328397628',), 1331076336: ('0.10110718328397628',), 1331076281: ('0.10110718328397628',), 1331076241: ('0.10110718328397628',), 1331076226: ('0.10110718328397628',), 1331076203: ('0.10110718328397628',), 1331076155: ('0.10110718328397628',), 1331076151: ('0.10110718328397628',), 1331076148: ('0.10110718328397628',), 1331076134: ('0.10110718328397628',), 1331076121: ('0.10110718328397628',), 1331076103: ('0.10110718328397628',)} [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 27 /1331076612.Didn't retrieve data . /1331076605.Didn't retrieve data . /1331076602.Didn't retrieve data . /1331076539.Didn't retrieve data . /1331076529.Didn't retrieve data . /1331076506.Didn't retrieve data . /1331076505.Didn't retrieve data . /1331076500.Didn't retrieve data . /1331076494.Didn't retrieve data . /1331076461.Didn't retrieve data . /1331076459.Didn't retrieve data . /1331076407.Didn't retrieve data . /1331076401.Didn't retrieve data . /1331076351.Didn't retrieve data . /1331076348.Didn't retrieve data . /1331076344.Didn't retrieve data . /1331076336.Didn't retrieve data . /1331076281.Didn't retrieve data . /1331076241.Didn't retrieve data . /1331076226.Didn't retrieve data . /1331076203.Didn't retrieve data . /1331076155.Didn't retrieve data . /1331076151.Didn't retrieve data . /1331076148.Didn't retrieve data . /1331076134.Didn't retrieve data . /1331076121.Didn't retrieve data . /1331076103.Didn't retrieve data . before output type Used above Used above Managing all output in save final without adding information in the mtr_datou_result ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076612', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076605', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076602', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076539', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076529', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076506', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076505', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076500', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076494', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076461', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076459', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076407', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076401', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076351', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076348', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076344', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076336', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076281', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076241', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076226', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076203', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076155', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076151', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076148', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076134', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076121', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076103', None, None, None, None, None, '2578915') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 81 time used for this insertion : 0.01553201675415039 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.07124495506286621 time spend to save output : 0.01663517951965332 total time spend for step 5 : 0.08788013458251953 step6:blur_detection Wed Feb 12 11:56:33 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step blur_detection toutes les photos sont déjà traitées, on saute les calculs Inside saveOutput : final : False verbose : 0 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 27 time used for this insertion : 0.010721445083618164 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 27 time used for this insertion : 0.6002621650695801 save missing photos in datou_result : time spend for datou_step_exec : 0.7870650291442871 time spend to save output : 0.6152119636535645 total time spend for step 6 : 1.4022769927978516 step7:brightness Wed Feb 12 11:56:35 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step calcul brightness toutes les photos sont déjà traitées, on saute les calculs Inside saveOutput : final : False verbose : 0 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 27 time used for this insertion : 0.010808706283569336 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 27 time used for this insertion : 0.440554141998291 save missing photos in datou_result : time spend for datou_step_exec : 0.028643131256103516 time spend to save output : 0.4554939270019531 total time spend for step 7 : 0.48413705825805664 step8:send_mail_cod Wed Feb 12 11:56:35 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 complete output_args for input 1 complete output_args for input 2 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 3 We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure dans la step send mail cod work_area: /home/admin/workarea/git/Velours/python in order to get the selector url, please entre the license of selector results_COD_P19962217_12-02-2025_11_56_35.pdf 20050847 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508471739357795 20050848 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508481739357797 20050851 imagette200508511739357799 20050852 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508521739357799 20050853 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508531739357801 20050855 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508551739357803 20050856 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508561739357804 20050857 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508571739357809 20050859 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508591739357811 20050860 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette200508601739357813 20448626 imagette204486261739357815 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=19962217 and hashtag_type = 4211 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/20050847,20050848,20050849,20050850,20050851,20050852,20050853,20050854,20050855,20050856,20050857,20050858,20050859,20050860,20050861,20050862,20448626?tags=ela,metal,pehd,etiquette,textiles_sanitaires,film_plastique,kraft,mal_croppe,pet_fonce,pet_opaque,carton,environnement,papier,pet_clair,flou,barquette_opaque,autre your option no_mail is active, we will not send the real mail to your client args[1331076612] : ((1331076612, -6.802470455441481, 492609224), (1331076612, -0.04853401472291592, 2107752395), '0.10110718328397628') apple ((1331076612, -6.802470455441481, 492609224), (1331076612, -0.04853401472291592, 2107752395), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076605] : ((1331076605, -5.516026306625292, 492609224), (1331076605, -0.13931505145010384, 496442774), '0.10110718328397628') apple ((1331076605, -5.516026306625292, 492609224), (1331076605, -0.13931505145010384, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076602] : ((1331076602, -4.572950734307086, 492609224), (1331076602, -0.1879369615969, 496442774), '0.10110718328397628') apple ((1331076602, -4.572950734307086, 492609224), (1331076602, -0.1879369615969, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076539] : ((1331076539, -5.730132276933766, 492609224), (1331076539, -0.0908633514600419, 496442774), '0.10110718328397628') apple ((1331076539, -5.730132276933766, 492609224), (1331076539, -0.0908633514600419, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076529] : ((1331076529, -5.607742328389898, 492609224), (1331076529, -0.12434027765411661, 496442774), '0.10110718328397628') apple ((1331076529, -5.607742328389898, 492609224), (1331076529, -0.12434027765411661, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076506] : ((1331076506, -5.576793709936065, 492609224), (1331076506, -0.1672827696286201, 496442774), '0.10110718328397628') apple ((1331076506, -5.576793709936065, 492609224), (1331076506, -0.1672827696286201, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076505] : ((1331076505, -5.488280451403988, 492609224), (1331076505, -0.14250705679559136, 496442774), '0.10110718328397628') apple ((1331076505, -5.488280451403988, 492609224), (1331076505, -0.14250705679559136, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076500] : ((1331076500, -5.321499566990709, 492609224), (1331076500, -0.18686700065331893, 496442774), '0.10110718328397628') apple ((1331076500, -5.321499566990709, 492609224), (1331076500, -0.18686700065331893, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076494] : ((1331076494, -5.618032961428868, 492609224), (1331076494, -0.10888128513993352, 496442774), '0.10110718328397628') apple ((1331076494, -5.618032961428868, 492609224), (1331076494, -0.10888128513993352, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076461] : ((1331076461, -5.538502655097642, 492609224), (1331076461, -0.09291066395425511, 496442774), '0.10110718328397628') apple ((1331076461, -5.538502655097642, 492609224), (1331076461, -0.09291066395425511, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076459] : ((1331076459, -5.582588224440598, 492609224), (1331076459, -0.20814657756365182, 496442774), '0.10110718328397628') apple ((1331076459, -5.582588224440598, 492609224), (1331076459, -0.20814657756365182, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076407] : ((1331076407, -5.535468016032998, 492609224), (1331076407, -0.18016709003806136, 496442774), '0.10110718328397628') apple ((1331076407, -5.535468016032998, 492609224), (1331076407, -0.18016709003806136, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076401] : ((1331076401, -5.353135477911843, 492609224), (1331076401, -0.22225149102412972, 496442774), '0.10110718328397628') apple ((1331076401, -5.353135477911843, 492609224), (1331076401, -0.22225149102412972, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076351] : ((1331076351, -4.88759222732354, 492609224), (1331076351, -0.056598512780633006, 2107752395), '0.10110718328397628') apple ((1331076351, -4.88759222732354, 492609224), (1331076351, -0.056598512780633006, 2107752395), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076348] : ((1331076348, -5.327633628622377, 492609224), (1331076348, -0.15057767357491525, 496442774), '0.10110718328397628') apple ((1331076348, -5.327633628622377, 492609224), (1331076348, -0.15057767357491525, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076344] : ((1331076344, -5.492664775192926, 492609224), (1331076344, -0.17780146246892947, 496442774), '0.10110718328397628') apple ((1331076344, -5.492664775192926, 492609224), (1331076344, -0.17780146246892947, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076336] : ((1331076336, -4.984348274299388, 492609224), (1331076336, -0.2062420900420627, 496442774), '0.10110718328397628') apple ((1331076336, -4.984348274299388, 492609224), (1331076336, -0.2062420900420627, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076281] : ((1331076281, -5.73387204968593, 492609224), (1331076281, -0.16754286811795085, 496442774), '0.10110718328397628') apple ((1331076281, -5.73387204968593, 492609224), (1331076281, -0.16754286811795085, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076241] : ((1331076241, -5.144974488789048, 492609224), (1331076241, -0.1567963034020705, 496442774), '0.10110718328397628') apple ((1331076241, -5.144974488789048, 492609224), (1331076241, -0.1567963034020705, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076226] : ((1331076226, -4.976254476335138, 492609224), (1331076226, -0.16463590588659874, 496442774), '0.10110718328397628') apple ((1331076226, -4.976254476335138, 492609224), (1331076226, -0.16463590588659874, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076203] : ((1331076203, -1.561821834008411, 492688767), (1331076203, -0.23496326760653707, 496442774), '0.10110718328397628') apple ((1331076203, -1.561821834008411, 492688767), (1331076203, -0.23496326760653707, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076155] : ((1331076155, -5.732001446909176, 492609224), (1331076155, -0.13313482963306322, 496442774), '0.10110718328397628') apple ((1331076155, -5.732001446909176, 492609224), (1331076155, -0.13313482963306322, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076151] : ((1331076151, -5.387042823133611, 492609224), (1331076151, -0.1589934776544178, 496442774), '0.10110718328397628') apple ((1331076151, -5.387042823133611, 492609224), (1331076151, -0.1589934776544178, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076148] : ((1331076148, -5.623373347530507, 492609224), (1331076148, -0.04509504802546339, 2107752395), '0.10110718328397628') apple ((1331076148, -5.623373347530507, 492609224), (1331076148, -0.04509504802546339, 2107752395), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076134] : ((1331076134, -5.034152569317267, 492609224), (1331076134, -0.11104555018798289, 496442774), '0.10110718328397628') apple ((1331076134, -5.034152569317267, 492609224), (1331076134, -0.11104555018798289, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076121] : ((1331076121, -4.948620893403424, 492609224), (1331076121, -0.08409887414494016, 496442774), '0.10110718328397628') apple ((1331076121, -4.948620893403424, 492609224), (1331076121, -0.08409887414494016, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com args[1331076103] : ((1331076103, -5.394720419955984, 492609224), (1331076103, -0.27972502979809566, 496442774), '0.10110718328397628') apple ((1331076103, -5.394720419955984, 492609224), (1331076103, -0.27972502979809566, 496442774), '0.10110718328397628') We are sending mail with results at kexin@fotonower.com refus_total : 0.10110718328397628 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=19962217 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 1000 SELECT photo_id, url FROM MTRBack.photos ph WHERE photo_id IN (1331077300,1331396251,1331396234,1331396096,1331076621,1331076695,1331396086,1331076707,1331396083,1331077160,1331077204,1331077299,1331077386,1331393105,1331388906,1331394614,1331387710,1331387706,1331077376,1331077317) Found this number of photos: 20 begin to download photo : 1331077300 begin to download photo : 1331076695 begin to download photo : 1331077204 begin to download photo : 1331394614 download finish for photo 1331077204 begin to download photo : 1331077299 download finish for photo 1331076695 begin to download photo : 1331396086 download finish for photo 1331394614 begin to download photo : 1331387710 download finish for photo 1331077300 begin to download photo : 1331396251 download finish for photo 1331077299 begin to download photo : 1331077386 download finish for photo 1331387710 begin to download photo : 1331387706 download finish for photo 1331396086 begin to download photo : 1331076707 download finish for photo 1331396251 begin to download photo : 1331396234 download finish for photo 1331076707 begin to download photo : 1331396083 download finish for photo 1331077386 begin to download photo : 1331393105 download finish for photo 1331387706 begin to download photo : 1331077376 download finish for photo 1331396083 begin to download photo : 1331077160 download finish for photo 1331077376 begin to download photo : 1331077317 download finish for photo 1331396234 begin to download photo : 1331396096 download finish for photo 1331393105 begin to download photo : 1331388906 download finish for photo 1331077317 download finish for photo 1331396096 begin to download photo : 1331076621 download finish for photo 1331077160 download finish for photo 1331388906 download finish for photo 1331076621 start upload file to ovh https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_COD_P19962217_12-02-2025_11_56_35.pdf results_COD_P19962217_12-02-2025_11_56_35.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_COD_P19962217_12-02-2025_11_56_35.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('4910','19962217','results_COD_P19962217_12-02-2025_11_56_35.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_COD_P19962217_12-02-2025_11_56_35.pdf','pdf','','1.48','0.10110718328397628') Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 0 before output type Used above Managing all output in save final without adding information in the mtr_datou_result ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076612', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076605', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076602', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076539', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076529', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076506', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076505', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076500', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076494', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076461', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076459', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076407', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076401', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076351', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076348', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076344', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076336', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076281', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076241', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076226', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076203', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076155', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076151', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076148', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076134', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076121', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076103', None, None, None, None, None, '2578915') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 27 time used for this insertion : 0.02190256118774414 save_final save missing photos in datou_result : time spend for datou_step_exec : 25.567432641983032 time spend to save output : 0.022411823272705078 total time spend for step 8 : 25.589844465255737 step9:split_time_score Wed Feb 12 11:57:01 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', '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': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('15', 85), ('16', 78)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 24012025 19962217 Nombre de photos uploadées : 127 / 23040 (0%) 24012025 19962217 Nombre de photos taguées (types de déchets): 0 / 127 (0%) 24012025 19962217 Nombre de photos taguées (volume) : 0 / 127 (0%) elapsed_time : load_data_split_time_score 3.0994415283203125e-06 elapsed_time : order_list_meta_photo_and_scores 9.298324584960938e-06 ??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.007336139678955078 elapsed_time : insert_dashboard_record_day_entry 0.023544788360595703 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909479_11-02-2025_23_16_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909479 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19887057_24-01-2025_12_42_56.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19887057 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909480_11-02-2025_23_28_42.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909480 order by id desc limit 1 Qualite : 0.18893935783488489 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909481_25-01-2025_03_09_31.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909481 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19909481 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909482_28-01-2025_01_01_42.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909482 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909483_25-01-2025_12_42_31.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909483 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962164_27-01-2025_15_15_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962164 order by id desc limit 1 Qualite : 0.17856491410221498 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962165_27-01-2025_13_28_07.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962165 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962165 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962166_29-01-2025_21_20_30.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962166 order by id desc limit 1 Qualite : 0.20483862960693544 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962167_27-01-2025_13_02_55.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962167 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962167 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962168_27-01-2025_14_03_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962168 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962169_27-01-2025_17_15_10.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962169 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962170_28-01-2025_15_46_49.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962170 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962171_27-01-2025_13_54_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962171 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962172_27-01-2025_16_28_52.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962172 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962173_27-01-2025_14_20_43.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962173 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962174_27-01-2025_13_26_19.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962174 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962175_29-01-2025_21_31_26.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962175 order by id desc limit 1 Qualite : 0.1473185641967583 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962176_27-01-2025_13_17_26.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962176 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962176 AND mptpi.`type`=3594 To do Qualite : 0.19545839675569307 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962177_27-01-2025_13_07_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962177 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962177 AND mptpi.`type`=3594 To do Qualite : 0.1363945352687757 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962178_27-01-2025_12_38_49.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962178 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962178 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962179_02-02-2025_08_52_12.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962179 order by id desc limit 1 Qualite : 0.20544430301055594 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962204_27-01-2025_12_35_04.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962204 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962204 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962205_02-02-2025_09_03_04.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962205 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962207_02-02-2025_12_44_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962207 order by id desc limit 1 Qualite : 0.17502241058460422 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19897871_24-01-2025_18_23_34.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19897871 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19897871 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962208_09-02-2025_01_03_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962208 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962209_27-01-2025_11_37_24.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962209 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962211_11-02-2025_11_15_23.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962211 order by id desc limit 1 Qualite : 0.22944660647823942 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962212_27-01-2025_12_13_27.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962212 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962212 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962213_29-01-2025_22_05_18.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962213 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962214_27-01-2025_13_25_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962214 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962215_27-01-2025_12_59_48.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962215 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962216_27-01-2025_13_34_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962216 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_COD_P19962217_12-02-2025_11_56_35.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962217 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962218_27-01-2025_12_21_07.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962218 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962219_27-01-2025_12_15_40.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962219 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_COD_P19962220_11-02-2025_15_16_21.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962220 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_COD_P19962221_12-02-2025_10_44_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962221 order by id desc limit 1 Qualite : 0.16497000102124187 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962222_27-01-2025_13_09_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962222 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962222 AND mptpi.`type`=3594 To do Qualite : 0.21249730505628178 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962223_27-01-2025_12_02_18.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962223 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962223 AND mptpi.`type`=3594 To do Qualite : 0.14936887885298156 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19962224_27-01-2025_11_36_32.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19962224 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19962224 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909486_25-01-2025_02_19_27.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909486 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909487_25-01-2025_03_18_58.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909487 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909499_25-01-2025_01_21_28.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909499 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909505_25-01-2025_01_37_05.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909505 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909506_25-01-2025_03_55_30.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909506 order by id desc limit 1 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909507_25-01-2025_02_38_24.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909507 order by id desc limit 1 Qualite : 0.15738580530591867 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909508_25-01-2025_02_46_58.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909508 order by id desc limit 1 # 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 ! 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 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 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 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 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`=19909508 AND mptpi.`type`=3594 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P19909509_25-01-2025_12_15_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 19909509 order by id desc limit 1 NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'24012025': {'nb_upload': 127, 'nb_taggue_class': 0, 'nb_taggue_densite': 0}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1331076612, 1331076605, 1331076602, 1331076539, 1331076529, 1331076506, 1331076505, 1331076500, 1331076494, 1331076461, 1331076459, 1331076407, 1331076401, 1331076351, 1331076348, 1331076344, 1331076336, 1331076281, 1331076241, 1331076226, 1331076203, 1331076155, 1331076151, 1331076148, 1331076134, 1331076121, 1331076103] Looping around the photos to save general results len do output : 1 /19962217Didn'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 ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076612', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076605', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076602', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076539', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076529', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076506', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076505', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076500', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076494', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076461', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076459', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076407', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076401', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076351', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076348', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076344', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076336', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076281', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076241', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076226', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076203', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076155', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076151', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076148', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076134', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076121', None, None, None, None, None, '2578915') ('4910', None, None, None, None, None, None, None, '2578915') ('4910', None, '1331076103', None, None, None, None, None, '2578915') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 28 time used for this insertion : 0.017247915267944336 save_final save missing photos in datou_result : time spend for datou_step_exec : 14.873907566070557 time spend to save output : 0.01772022247314453 total time spend for step 9 : 14.891627788543701 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 27 set_done_treatment 9.30user 2.90system 36:51.72elapsed 0%CPU (0avgtext+0avgdata 139388maxresident)k 316576inputs+160520outputs (19941major+137140minor)pagefaults 0swaps