python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 10 -a ' -a 3459 -l 10 ' -s datou_current_3459 -M 0 -S 0 -U 95,95,80 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 : 400430 load datou : 3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! 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 : chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? [(photo_id, hashtag_id, hashtag_type, x0, x1, y0, y1, score, seg_temp, polygons), ...] was removed should we ? chemin de la photo was removed should we ? [ (photo_id_loc, hashtag_id, hashtag_type, x0, x1, y0, y1, score, None), ...] was removed should we ? chemin de la photo was removed should we ? id de la photo (peut être local ou global) was removed should we ? chemin de la photo was removed should we ? (x0, y0, x1, y1) was removed should we ? chemin de la photo was removed should we ? [ (photo_id, hashtag_id_0, score_0), (photo_id, hashtag_id_1, score_1), ...] was removed should we ? output optionnel thcl was removed should we ? id de la photo (peut être local ou global) was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? [ (photo_id, hashtag_id_0, score_0), (photo_id, hashtag_id_1, score_1), ...] was removed should we ? id de la photo (peut être local ou global) was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] 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 ? [ (photo_id_loc, hashtag_id, hashtag_type, x0, x1, y0, y1, score, None), ...] was removed should we ? chemin de la photo was removed should we ? id de la photo (peut être local ou global) was removed should we ? chemin de la photo was removed should we ? (x0, y0, x1, y1) 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 ? None was removed should we ? donnée sous forme de nombre 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 ? FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (4999, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 16384, 25088, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'res5b', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2020, 10, 23, 14, 27, 22), datetime.datetime(2020, 10, 23, 14, 27, 22)) FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5288, 'learn_papier_nantes_300421', 512, 512, 'learn_papier_nantes_300421', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 30, 17, 9, 41), datetime.datetime(2021, 4, 30, 17, 9, 41)) FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5309, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 16384, 25088, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 5, 10, 19, 20, 46), datetime.datetime(2021, 5, 10, 19, 20, 46)) load thcls load THCL from format json or kwargs add thcl : 2456 in CacheModelConfig load THCL from format json or kwargs add thcl : 2868 in CacheModelConfig load THCL from format json or kwargs add thcl : 2896 in CacheModelConfig load pdts add pdt : 4999 in CacheModelConfig add pdt : 5288 in CacheModelConfig add pdt : 5309 in CacheModelConfig Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec updating current state to 1 we have a portfolio with more photos than limit : 29>10 please execute split_portfolio.py -i 21277895 -l 10 size over we load limit photo not treated list_input_json: [] Current got : datou_id : 3459, datou_cur_ids : ['2657788'] with mtr_portfolio_ids : ['21277895'] and first list_photo_ids : [] new path : /proc/400430/ 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 ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! List Step Type Loaded in datou : mask_detect, crop_condition, thcl, merge_mask_thcl_custom, rle_unique_nms_with_priority, crop_condition, ventilate_hashtags_in_portfolio, final, velours_tree, send_mail_cod, split_time_score list_input_json : [] origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! BFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 10 ; length of list_pids : 10 ; length of list_args : 10 time to download the photos : 1.137373685836792 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 : 11 step1:mask_detect Tue Mar 11 11:36:32 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 Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 4862 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-03-11 11:36:35.238080: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-03-11 11:36:35.267144: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-03-11 11:36:35.268815: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fd038000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-03-11 11:36:35.268862: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-03-11 11:36:35.272279: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-03-11 11:36:35.413320: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x3f041d50 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-03-11 11:36:35.413396: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-03-11 11:36:35.414481: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-03-11 11:36:35.414892: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-11 11:36:35.418596: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-11 11:36:35.421546: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-11 11:36:35.422414: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-11 11:36:35.425960: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-11 11:36:35.427713: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-11 11:36:35.434406: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-11 11:36:35.435928: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-11 11:36:35.436085: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-11 11:36:35.436865: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-03-11 11:36:35.436887: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-03-11 11:36:35.436898: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-03-11 11:36:35.438071: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 4410 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-03-11 11:36:35.784669: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-03-11 11:36:35.784802: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-11 11:36:35.784828: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-11 11:36:35.784850: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-11 11:36:35.784872: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-11 11:36:35.784893: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-11 11:36:35.784914: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-11 11:36:35.784936: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-11 11:36:35.786143: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-11 11:36:35.787456: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-03-11 11:36:35.787516: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-11 11:36:35.787537: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-11 11:36:35.787557: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-11 11:36:35.787576: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-11 11:36:35.787594: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-11 11:36:35.787612: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-11 11:36:35.787630: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-11 11:36:35.788787: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-11 11:36:35.788828: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-03-11 11:36:35.788839: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-03-11 11:36:35.788848: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-03-11 11:36:35.790091: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 4410 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) Using TensorFlow backend. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:396: calling crop_and_resize_v1 (from tensorflow.python.ops.image_ops_impl) with box_ind is deprecated and will be removed in a future version. Instructions for updating: box_ind is deprecated, use box_indices instead WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:703: to_int32 (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:729: to_float (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. Inside mask_sub_process Inside mask_detect About to load cache.load_thcl_param To do loadFromThcl(), then load ParamDescType : thcl2896 thcls : [{'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'}] thcl {'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5309 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5309, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 16384, 25088, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 5, 10, 19, 20, 46), datetime.datetime(2021, 5, 10, 19, 20, 46)) {'thcl': {'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'carton_brun', 'carton_gris', 'cartonnette', 'kraft', 'autre_refus', 'metal', 'plastique', 'teint_dans_la_masse', 'environnement'], 'list_hashtags_csv': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'svm_hashtag_type_desc': 5309, 'photo_desc_type': 5309, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'carton_brun', 'carton_gris', 'cartonnette', 'kraft', 'autre_refus', 'metal', 'plastique', 'teint_dans_la_masse', 'environnement'] Configurations: BACKBONE resnet101 BACKBONE_SHAPES [[160 160] [ 80 80] [ 40 40] [ 20 20] [ 10 10]] BACKBONE_STRIDES [4, 8, 16, 32, 64] BATCH_SIZE 1 BBOX_STD_DEV [0.1 0.1 0.2 0.2] DETECTION_MAX_INSTANCES 100 DETECTION_MIN_CONFIDENCE 0.3 DETECTION_NMS_THRESHOLD 0.3 GPU_COUNT 1 IMAGES_PER_GPU 1 IMAGE_MAX_DIM 640 IMAGE_MIN_DIM 640 IMAGE_PADDING True IMAGE_SHAPE [640 640 3] LEARNING_MOMENTUM 0.9 LEARNING_RATE 0.001 LOSS_WEIGHTS {'rpn_class_loss': 1.0, 'rpn_bbox_loss': 1.0, 'mrcnn_class_loss': 1.0, 'mrcnn_bbox_loss': 1.0, 'mrcnn_mask_loss': 1.0} MASK_POOL_SIZE 14 MASK_SHAPE [28, 28] MAX_GT_INSTANCES 100 MEAN_PIXEL [123.7 116.8 103.9] MINI_MASK_SHAPE (56, 56) NAME learn_convoyeur_qualipapia_nantes_poly_100521_1 NUM_CLASSES 10 POOL_SIZE 7 POST_NMS_ROIS_INFERENCE 1000 POST_NMS_ROIS_TRAINING 2000 ROI_POSITIVE_RATIO 0.33 RPN_ANCHOR_RATIOS [0.5, 1, 2] RPN_ANCHOR_SCALES (16, 32, 64, 128, 256) RPN_ANCHOR_STRIDE 1 RPN_BBOX_STD_DEV [0.1 0.1 0.2 0.2] RPN_NMS_THRESHOLD 0.7 RPN_TRAIN_ANCHORS_PER_IMAGE 256 STEPS_PER_EPOCH 1000 TRAIN_ROIS_PER_IMAGE 200 USE_MINI_MASK True USE_RPN_ROIS True VALIDATION_STEPS 50 WEIGHT_DECAY 0.0001 model_param file didn't exist model_name : learn_convoyeur_qualipapia_nantes_poly_100521_1 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-03-11 11:36:40.488695: W tensorflow/core/framework/cpu_allocator_impl.cc:81] Allocation of 51380224 exceeds 10% of free system memory. 2025-03-11 11:36:44.780840: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-11 11:36:45.082524: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-11 11:36:47.171026: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:47.171825: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.43G (3680383744 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:47.992527: W tensorflow/core/common_runtime/bfc_allocator.cc:311] Garbage collection: deallocate free memory regions (i.e., allocations) so that we can re-allocate a larger region to avoid OOM due to memory fragmentation. If you see this message frequently, you are running near the threshold of the available device memory and re-allocation may incur great performance overhead. You may try smaller batch sizes to observe the performance impact. Set TF_ENABLE_GPU_GARBAGE_COLLECTION=false if you'd like to disable this feature. 2025-03-11 11:36:48.065216: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.065291: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 3.29GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.066201: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.066221: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 3.29GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.072760: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.072790: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 1.78GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.073468: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.073486: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 1.78GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.130366: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.130423: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.26GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.131165: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.131185: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.26GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.139275: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.139308: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 417.62MiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.139980: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.139997: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 417.62MiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.155499: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.155566: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 188.27MiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.156675: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.156701: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 188.27MiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-03-11 11:36:48.157809: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.158915: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.163727: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.164870: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.165968: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.167071: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.168762: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.168786: W tensorflow/core/kernels/gpu_utils.cc:49] Failed to allocate memory for convolution redzone checking; skipping this check. This is benign and only means that we won't check cudnn for out-of-bounds reads and writes. This message will only be printed once. 2025-03-11 11:36:48.178981: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.179721: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.188888: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.189572: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.190271: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.190950: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.191643: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-03-11 11:36:48.192358: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 3.81G (4089315328 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory local folder : /data/models_weight/learn_convoyeur_qualipapia_nantes_poly_100521_1 /data/models_weight/learn_convoyeur_qualipapia_nantes_poly_100521_1/mask_model.h5 size_local : 256031040 size in s3 : 256031040 create time local : 2021-08-09 05:45:48 create time in s3 : 2021-08-06 18:59:51 mask_model.h5 already exist and didn't need to update list_images length : 10 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 10 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 13 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 Detection mask done ! Trying to reset tf kernel 400984 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 3448 tf kernel not reseted sub process len(results) : 10 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 10 len(list_Values) 0 process is alive finish correctly or not : True after detect begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 4641 list_Values should be empty [] To do loadFromThcl(), then load ParamDescType : thcl2896 Catched exception ! Connect or reconnect ! thcls : [{'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'}] thcl {'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5309 ['background', 'carton_brun', 'carton_gris', 'cartonnette', 'kraft', 'autre_refus', 'metal', 'plastique', 'teint_dans_la_masse', 'environnement'] time for calcul the mask position with numpy : 0.019382953643798828 nb_pixel_total : 810457 time to create 1 rle with new method : 0.09373307228088379 length of segment : 1505 time for calcul the mask position with numpy : 0.002038717269897461 nb_pixel_total : 126728 time to create 1 rle with old method : 0.14173483848571777 length of segment : 637 time for calcul the mask position with numpy : 0.00030350685119628906 nb_pixel_total : 9164 time to create 1 rle with old method : 0.01051473617553711 length of segment : 307 time for calcul the mask position with numpy : 0.0003714561462402344 nb_pixel_total : 23780 time to create 1 rle with old method : 0.028155803680419922 length of segment : 180 time for calcul the mask position with numpy : 0.004016876220703125 nb_pixel_total : 302477 time to create 1 rle with new method : 0.010561466217041016 length of segment : 889 time for calcul the mask position with numpy : 0.0007097721099853516 nb_pixel_total : 33973 time to create 1 rle with old method : 0.03957056999206543 length of segment : 259 time for calcul the mask position with numpy : 0.0006909370422363281 nb_pixel_total : 29003 time to create 1 rle with old method : 0.03301286697387695 length of segment : 376 time for calcul the mask position with numpy : 0.0001780986785888672 nb_pixel_total : 3873 time to create 1 rle with old method : 0.004528999328613281 length of segment : 70 time for calcul the mask position with numpy : 0.01179957389831543 nb_pixel_total : 443685 time to create 1 rle with new method : 0.03513169288635254 length of segment : 1633 time for calcul the mask position with numpy : 9.369850158691406e-05 nb_pixel_total : 817 time to create 1 rle with old method : 0.0011446475982666016 length of segment : 43 time for calcul the mask position with numpy : 0.00016117095947265625 nb_pixel_total : 2921 time to create 1 rle with old method : 0.003548145294189453 length of segment : 102 time for calcul the mask position with numpy : 8.869171142578125e-05 nb_pixel_total : 2737 time to create 1 rle with old method : 0.0032939910888671875 length of segment : 79 time for calcul the mask position with numpy : 0.0002541542053222656 nb_pixel_total : 11735 time to create 1 rle with old method : 0.01502537727355957 length of segment : 105 time for calcul the mask position with numpy : 8.153915405273438e-05 nb_pixel_total : 2302 time to create 1 rle with old method : 0.0029833316802978516 length of segment : 64 time for calcul the mask position with numpy : 0.009415149688720703 nb_pixel_total : 374234 time to create 1 rle with new method : 0.020392417907714844 length of segment : 1594 time for calcul the mask position with numpy : 0.00021600723266601562 nb_pixel_total : 4138 time to create 1 rle with old method : 0.004987239837646484 length of segment : 119 time for calcul the mask position with numpy : 0.002501964569091797 nb_pixel_total : 92349 time to create 1 rle with old method : 0.10409951210021973 length of segment : 364 time for calcul the mask position with numpy : 0.00313568115234375 nb_pixel_total : 153766 time to create 1 rle with new method : 0.009037256240844727 length of segment : 485 time for calcul the mask position with numpy : 0.0006070137023925781 nb_pixel_total : 15558 time to create 1 rle with old method : 0.017802715301513672 length of segment : 158 time for calcul the mask position with numpy : 0.000942230224609375 nb_pixel_total : 59879 time to create 1 rle with old method : 0.06755352020263672 length of segment : 175 time for calcul the mask position with numpy : 8.749961853027344e-05 nb_pixel_total : 1103 time to create 1 rle with old method : 0.0014574527740478516 length of segment : 56 time for calcul the mask position with numpy : 0.00038814544677734375 nb_pixel_total : 6883 time to create 1 rle with old method : 0.008492708206176758 length of segment : 136 time for calcul the mask position with numpy : 0.00025844573974609375 nb_pixel_total : 4513 time to create 1 rle with old method : 0.005671977996826172 length of segment : 76 time for calcul the mask position with numpy : 0.02336597442626953 nb_pixel_total : 732952 time to create 1 rle with new method : 0.06606149673461914 length of segment : 2198 time for calcul the mask position with numpy : 0.0008008480072021484 nb_pixel_total : 23758 time to create 1 rle with old method : 0.028609275817871094 length of segment : 383 time for calcul the mask position with numpy : 0.003854036331176758 nb_pixel_total : 308219 time to create 1 rle with new method : 0.00930929183959961 length of segment : 1117 time for calcul the mask position with numpy : 0.0015714168548583984 nb_pixel_total : 50597 time to create 1 rle with old method : 0.059329986572265625 length of segment : 494 time for calcul the mask position with numpy : 0.014416217803955078 nb_pixel_total : 549065 time to create 1 rle with new method : 0.13156890869140625 length of segment : 1515 time for calcul the mask position with numpy : 0.00012612342834472656 nb_pixel_total : 1670 time to create 1 rle with old method : 0.0021295547485351562 length of segment : 68 time for calcul the mask position with numpy : 0.002418994903564453 nb_pixel_total : 140722 time to create 1 rle with old method : 0.1581413745880127 length of segment : 765 time for calcul the mask position with numpy : 0.0012564659118652344 nb_pixel_total : 82427 time to create 1 rle with old method : 0.09332895278930664 length of segment : 385 time for calcul the mask position with numpy : 8.440017700195312e-05 nb_pixel_total : 1827 time to create 1 rle with old method : 0.002314329147338867 length of segment : 59 time for calcul the mask position with numpy : 0.002902984619140625 nb_pixel_total : 121267 time to create 1 rle with old method : 0.13808369636535645 length of segment : 873 time for calcul the mask position with numpy : 0.0024187564849853516 nb_pixel_total : 142228 time to create 1 rle with old method : 0.1607804298400879 length of segment : 452 time for calcul the mask position with numpy : 0.0009279251098632812 nb_pixel_total : 80824 time to create 1 rle with old method : 0.10152554512023926 length of segment : 355 time for calcul the mask position with numpy : 0.0003705024719238281 nb_pixel_total : 13091 time to create 1 rle with old method : 0.015510320663452148 length of segment : 151 time for calcul the mask position with numpy : 0.009568452835083008 nb_pixel_total : 346882 time to create 1 rle with new method : 0.018976211547851562 length of segment : 1549 time for calcul the mask position with numpy : 0.0018055438995361328 nb_pixel_total : 63409 time to create 1 rle with old method : 0.07529449462890625 length of segment : 291 time for calcul the mask position with numpy : 0.0010340213775634766 nb_pixel_total : 38350 time to create 1 rle with old method : 0.046102285385131836 length of segment : 456 time for calcul the mask position with numpy : 0.003474712371826172 nb_pixel_total : 153424 time to create 1 rle with new method : 0.0052564144134521484 length of segment : 468 time for calcul the mask position with numpy : 0.01749706268310547 nb_pixel_total : 744349 time to create 1 rle with new method : 0.07000350952148438 length of segment : 1537 time for calcul the mask position with numpy : 0.0005650520324707031 nb_pixel_total : 32104 time to create 1 rle with old method : 0.04246211051940918 length of segment : 284 time for calcul the mask position with numpy : 0.0038106441497802734 nb_pixel_total : 297051 time to create 1 rle with new method : 0.010141134262084961 length of segment : 1142 time for calcul the mask position with numpy : 0.00014901161193847656 nb_pixel_total : 1666 time to create 1 rle with old method : 0.002168416976928711 length of segment : 63 time for calcul the mask position with numpy : 0.019840002059936523 nb_pixel_total : 993305 time to create 1 rle with new method : 0.24847173690795898 length of segment : 1744 time for calcul the mask position with numpy : 0.0033736228942871094 nb_pixel_total : 228247 time to create 1 rle with new method : 0.008209943771362305 length of segment : 791 time for calcul the mask position with numpy : 0.00021409988403320312 nb_pixel_total : 5816 time to create 1 rle with old method : 0.007658958435058594 length of segment : 94 time for calcul the mask position with numpy : 0.0003383159637451172 nb_pixel_total : 8769 time to create 1 rle with old method : 0.010920286178588867 length of segment : 123 time for calcul the mask position with numpy : 0.0005457401275634766 nb_pixel_total : 14028 time to create 1 rle with old method : 0.0173947811126709 length of segment : 195 time for calcul the mask position with numpy : 0.0008256435394287109 nb_pixel_total : 19534 time to create 1 rle with old method : 0.02357172966003418 length of segment : 359 time for calcul the mask position with numpy : 0.021167993545532227 nb_pixel_total : 951813 time to create 1 rle with new method : 0.09623193740844727 length of segment : 1059 time for calcul the mask position with numpy : 0.0012989044189453125 nb_pixel_total : 76962 time to create 1 rle with old method : 0.08823037147521973 length of segment : 380 time for calcul the mask position with numpy : 0.004114866256713867 nb_pixel_total : 297463 time to create 1 rle with new method : 0.010753154754638672 length of segment : 951 time for calcul the mask position with numpy : 0.0024192333221435547 nb_pixel_total : 126848 time to create 1 rle with old method : 0.15164566040039062 length of segment : 553 time for calcul the mask position with numpy : 0.006020069122314453 nb_pixel_total : 384402 time to create 1 rle with new method : 0.011986732482910156 length of segment : 1137 time for calcul the mask position with numpy : 0.0060825347900390625 nb_pixel_total : 376117 time to create 1 rle with new method : 0.023630380630493164 length of segment : 2135 time for calcul the mask position with numpy : 0.0007243156433105469 nb_pixel_total : 51963 time to create 1 rle with old method : 0.05865955352783203 length of segment : 214 time for calcul the mask position with numpy : 0.0004525184631347656 nb_pixel_total : 17191 time to create 1 rle with old method : 0.019570589065551758 length of segment : 153 time for calcul the mask position with numpy : 0.0012311935424804688 nb_pixel_total : 53346 time to create 1 rle with old method : 0.06346440315246582 length of segment : 157 time for calcul the mask position with numpy : 6.556510925292969e-05 nb_pixel_total : 512 time to create 1 rle with old method : 0.0007398128509521484 length of segment : 20 time for calcul the mask position with numpy : 0.013675451278686523 nb_pixel_total : 693556 time to create 1 rle with new method : 0.052194833755493164 length of segment : 1278 time for calcul the mask position with numpy : 0.0014681816101074219 nb_pixel_total : 75810 time to create 1 rle with old method : 0.09164071083068848 length of segment : 784 time for calcul the mask position with numpy : 0.001580953598022461 nb_pixel_total : 91035 time to create 1 rle with old method : 0.10404849052429199 length of segment : 181 time for calcul the mask position with numpy : 0.005928516387939453 nb_pixel_total : 296869 time to create 1 rle with new method : 0.012971639633178711 length of segment : 858 time spent for convertir_results : 9.163930892944336 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 81 chid ids of type : 3663 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++Number RLEs to save : 37183 save missing photos in datou_result : time spend for datou_step_exec : 34.0986545085907 time spend to save output : 71.32584595680237 total time spend for step 1 : 105.42450046539307 step2:crop_condition Tue Mar 11 11:38:17 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 ! VR 22-3-18 : For now we do not clean correctly the datou structure Loading chi in step crop with photo_hashtag_type : 3663 Loading chi in step crop for list_pids : 10 ! batch 1 Loaded 81 chid ids of type : 3663 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ begin to crop the class : teint_dans_la_masse param for this class : {'min_score': 0.7} filtre for class : teint_dans_la_masse hashtag_id of this class : 2107752385 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 10 About to insert : list_path_to_insert length 10 new photo from crops ! we have finished the crop for the class : teint_dans_la_masse begin to crop the class : autre_refus param for this class : {'min_score': 0.5} filtre for class : autre_refus hashtag_id of this class : 2107752406 we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! we have finished the crop for the class : autre_refus begin to crop the class : carton_gris param for this class : {'min_score': 0.5} filtre for class : carton_gris hashtag_id of this class : 2107753020 begin to crop the class : cartonnette param for this class : {'min_score': 0.5} filtre for class : cartonnette hashtag_id of this class : 702398920 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 5 About to insert : list_path_to_insert length 5 new photo from crops ! we have finished the crop for the class : cartonnette begin to crop the class : carton_brun param for this class : {'min_score': 0.7} filtre for class : carton_brun hashtag_id of this class : 2107753024 we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! we have finished the crop for the class : carton_brun begin to crop the class : plastique param for this class : {'min_score': 0.5} filtre for class : plastique hashtag_id of this class : 492725882 begin to crop the class : kraft param for this class : {'min_score': 0.5} filtre for class : kraft hashtag_id of this class : 493202403 begin to crop the class : metal param for this class : {'min_score': 0.5} filtre for class : metal hashtag_id of this class : 492628673 delete rles for these photos Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 17 /-3704933956Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925765Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925777Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925776Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925778Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3705023844Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925791Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925799Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925813Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925821Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925792Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925788Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925796Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925797Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925818Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925824Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3704925808Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . before output type Here is an output not treated by saveGeneral : Here is an output not treated by saveGeneral : Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 61 time used for this insertion : 0.028902053833007812 save_final save missing photos in datou_result : time spend for datou_step_exec : 18.995731115341187 time spend to save output : 0.14592194557189941 total time spend for step 2 : 19.141653060913086 step3:thcl Tue Mar 11 11:38:36 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 VR 22-3-18 : For now we do not clean correctly the datou structure Beginning of datou step Thcl ! nombre de thcls : 2 we are using the classfication for multi_thcl [2456, 2868] time to import caffe and check if the image exist : 0.008850812911987305 time to convert the images to numpy array : 2.1457672119140625e-06 time to import caffe and check if the image exist : 0.009554624557495117 time to convert the images to numpy array : 0.0044438838958740234 time to import caffe and check if the image exist : 0.008455038070678711 time to convert the images to numpy array : 0.010094404220581055 time to import caffe and check if the image exist : 0.009843587875366211 time to convert the images to numpy array : 0.017240285873413086 time to import caffe and check if the image exist : 0.008781194686889648 time to convert the images to numpy array : 0.019077062606811523 time to import caffe and check if the image exist : 0.01318669319152832 time to convert the images to numpy array : 0.018777132034301758 time to import caffe and check if the image exist : 0.013237953186035156 time to convert the images to numpy array : 0.028148889541625977 time to import caffe and check if the image exist : 0.012563705444335938 time to convert the images to numpy array : 0.030676841735839844 time to import caffe and check if the image exist : 0.011477947235107422 time to convert the images to numpy array : 0.03711533546447754 time to import caffe and check if the image exist : 0.013556957244873047 time to convert the images to numpy array : 0.03722548484802246 total time to convert the images to numpy array : 0.3730487823486328 list photo_ids error: [] list photo_ids correct : [-3704925808, -3704933956, -3704925765, -3704925796, -3704925797, -3704925813, -3704925821, -3704925778, -3705023844, -3704925792, -3704925788, -3704925818, -3704925824, -3704925777, -3704925776, -3704925791, -3704925799] number of photos to traite : 17 try to delete the photos incorrect in DB tagging for thcl : 2456 To do loadFromThcl(), then load ParamDescType : thcl2456 thcls : [{'id': 2456, 'mtr_user_id': 31, 'name': 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'papier,refus', 'svm_portfolios_learning': '3028087,3028251', 'photo_hashtag_type': 3049, 'photo_desc_type': 4999, 'type_classification': 'caffe', 'hashtag_id_list': '492668766,538914404'}] thcl {'id': 2456, 'mtr_user_id': 31, 'name': 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'papier,refus', 'svm_portfolios_learning': '3028087,3028251', 'photo_hashtag_type': 3049, 'photo_desc_type': 4999, 'type_classification': 'caffe', 'hashtag_id_list': '492668766,538914404'} Update svm_hashtag_type_desc : 4999 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (4999, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 16384, 25088, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'res5b', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2020, 10, 23, 14, 27, 22), datetime.datetime(2020, 10, 23, 14, 27, 22)) To loadFromThcl() : net_4999 begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 9515 max_wait_temp : 1 max_wait : 0 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (4999, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 16384, 25088, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'res5b', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2020, 10, 23, 14, 27, 22), datetime.datetime(2020, 10, 23, 14, 27, 22)) None mean_file_type : mean_file_path : prototxt_file_path : model : learn_qualipapia_papier_refus_from_vlg_data_aug Inside get_net Inside get_net before cache_data_model model_param file didn't exist Inside get_net before CDM.load_model_par_type model_name : learn_qualipapia_papier_refus_from_vlg_data_aug model_type : caffe list file need : ['caffemodel', 'deploy_conv_normal.prototxt', 'deploy_fc.prototxt', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file exist in s3 : ['caffemodel', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file manque in s3 : ['deploy_conv_normal.prototxt', 'deploy_fc.prototxt'] local folder : /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/caffemodel size_local : 44972172 size in s3 : 44972172 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:49 caffemodel already exist and didn't need to update /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/deploy.prototxt size_local : 17311 size in s3 : 17311 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:49 deploy.prototxt already exist and didn't need to update /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/mean.npy size_local : 1572992 size in s3 : 1572992 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:51 mean.npy already exist and didn't need to update /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/synset_words.txt size_local : 57 size in s3 : 57 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:49 synset_words.txt already exist and didn't need to update Inside get_net after CDM.load_model_par_type After if not only_with_local_cache: /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/ Here before set mode gpu Doing nothing but we could set mode gpu after set mode gpu prototxt_filename : /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/deploy.prototxt caffemodel_filename : /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/caffemodel now we set caffe to gpu mode before predict begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 8912 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.1674652099609375 time used to do the prediction : 0.16761279106140137 we don't save the descriptors for this thcl 2456 tagging for thcl : 2868 To do loadFromThcl(), then load ParamDescType : thcl2868 thcls : [{'id': 2868, 'mtr_user_id': 31, 'name': 'learn_papier_nantes_300421', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3752117,3752118,3752123,3752106,3752116,3752124,3752119,3581575,3486029,3752122', 'photo_hashtag_type': 3632, 'photo_desc_type': 5288, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'}] thcl {'id': 2868, 'mtr_user_id': 31, 'name': 'learn_papier_nantes_300421', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3752117,3752118,3752123,3752106,3752116,3752124,3752119,3581575,3486029,3752122', 'photo_hashtag_type': 3632, 'photo_desc_type': 5288, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'} Update svm_hashtag_type_desc : 5288 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5288, 'learn_papier_nantes_300421', 512, 512, 'learn_papier_nantes_300421', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 30, 17, 9, 41), datetime.datetime(2021, 4, 30, 17, 9, 41)) To loadFromThcl() : net_5288 begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 8910 max_wait_temp : 1 max_wait : 0 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5288, 'learn_papier_nantes_300421', 512, 512, 'learn_papier_nantes_300421', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 30, 17, 9, 41), datetime.datetime(2021, 4, 30, 17, 9, 41)) None mean_file_type : mean_file_path : prototxt_file_path : model : learn_papier_nantes_300421 Inside get_net Inside get_net before cache_data_model model_param file didn't exist Inside get_net before CDM.load_model_par_type model_name : learn_papier_nantes_300421 model_type : caffe list file need : ['caffemodel', 'deploy_conv_normal.prototxt', 'deploy_fc.prototxt', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file exist in s3 : ['caffemodel', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file manque in s3 : ['deploy_conv_normal.prototxt', 'deploy_fc.prototxt'] local folder : /data/models_weight/learn_papier_nantes_300421 /data/models_weight/learn_papier_nantes_300421/caffemodel size_local : 44791983 size in s3 : 44791983 create time local : 2021-08-09 05:55:59 create time in s3 : 2021-08-06 19:22:13 caffemodel already exist and didn't need to update /data/models_weight/learn_papier_nantes_300421/deploy.prototxt size_local : 17255 size in s3 : 17255 create time local : 2021-08-09 05:55:59 create time in s3 : 2021-08-06 19:22:12 deploy.prototxt already exist and didn't need to update /data/models_weight/learn_papier_nantes_300421/mean.npy size_local : 1572992 size in s3 : 1572992 create time local : 2021-08-09 05:55:59 create time in s3 : 2021-08-06 19:22:14 mean.npy already exist and didn't need to update /data/models_weight/learn_papier_nantes_300421/synset_words.txt size_local : 331 size in s3 : 331 create time local : 2021-08-09 05:56:00 create time in s3 : 2021-08-06 19:22:12 synset_words.txt already exist and didn't need to update Inside get_net after CDM.load_model_par_type After if not only_with_local_cache: /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/ Here before set mode gpu Doing nothing but we could set mode gpu after set mode gpu prototxt_filename : /data/models_weight/learn_papier_nantes_300421/deploy.prototxt caffemodel_filename : /data/models_weight/learn_papier_nantes_300421/caffemodel now we set caffe to gpu mode before predict begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 8910 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.2170429229736328 time used to do the prediction : 0.06464600563049316 we don't save the descriptors for this thcl 2868 Inside saveOutput : final : False verbose : 0 time used to find the portfolios of the photos test new format of the output of the step_thcl begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 0 time used for this insertion : 2.0503997802734375e-05 save missing photos in datou_result : time spend for datou_step_exec : 7.967570543289185 time spend to save output : 0.00043392181396484375 total time spend for step 3 : 7.968004465103149 step4:merge_mask_thcl_custom Tue Mar 11 11:38:44 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 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 2 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step merge_mask_thcl_custom batch 1 Loaded 81 chid ids of type : 3663 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++As expected we have just one thcl present End of step merge_mask_thcl_custom Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : merge_mask_thcl_custom we use saveGeneral [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 10 /1342938009Didn't retrieve data .Didn't retrieve data . /1342937360Didn't retrieve data .Didn't retrieve data . /1342937303Didn't retrieve data .Didn't retrieve data . /1342936931Didn't retrieve data .Didn't retrieve data . /1342936917Didn't retrieve data .Didn't retrieve data . /1342936672Didn't retrieve data .Didn't retrieve data . /1342936671Didn't retrieve data .Didn't retrieve data . /1342936550Didn't retrieve data .Didn't retrieve data . /1342936525Didn't retrieve data .Didn't retrieve data . /1342936327Didn't retrieve data .Didn't retrieve data . before output type Here is an output not treated by saveGeneral : Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.4167490005493164 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.20093369483947754 time spend to save output : 0.4173426628112793 total time spend for step 4 : 0.6182763576507568 step5:rle_unique_nms_with_priority Tue Mar 11 11:38:45 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 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms nb_obj : 6 nb_hashtags : 2 time to prepare the origin masks : 2.635732412338257 time for calcul the mask position with numpy : 0.0369718074798584 nb_pixel_total : 951475 time to create 1 rle with new method : 0.21836018562316895 time for calcul the mask position with numpy : 0.013764381408691406 nb_pixel_total : 9136 time to create 1 rle with old method : 0.011531829833984375 time for calcul the mask position with numpy : 0.01556706428527832 nb_pixel_total : 224095 time to create 1 rle with new method : 0.9445090293884277 time for calcul the mask position with numpy : 0.011471748352050781 nb_pixel_total : 23759 time to create 1 rle with old method : 0.029036760330200195 time for calcul the mask position with numpy : 0.013214349746704102 nb_pixel_total : 529 time to create 1 rle with old method : 0.0014369487762451172 time for calcul the mask position with numpy : 0.008640289306640625 nb_pixel_total : 45347 time to create 1 rle with old method : 0.0854804515838623 time for calcul the mask position with numpy : 0.24277091026306152 nb_pixel_total : 819259 time to create 1 rle with new method : 0.12309956550598145 create new chi : 1.7888286113739014 time to delete rle : 0.026606082916259766 batch 1 Loaded 8 chid ids of type : 3726 Number RLEs to save : 6786 TO DO : save crop sub photo not yet done ! save time : 15.199857950210571 nb_obj : 8 nb_hashtags : 2 time to prepare the origin masks : 0.8891100883483887 time for calcul the mask position with numpy : 0.2175288200378418 nb_pixel_total : 1501824 time to create 1 rle with new method : 0.07549047470092773 time for calcul the mask position with numpy : 0.006087541580200195 nb_pixel_total : 2279 time to create 1 rle with old method : 0.002680063247680664 time for calcul the mask position with numpy : 0.0058460235595703125 nb_pixel_total : 2333 time to create 1 rle with old method : 0.0026819705963134766 time for calcul the mask position with numpy : 0.005861520767211914 nb_pixel_total : 2909 time to create 1 rle with old method : 0.0032989978790283203 time for calcul the mask position with numpy : 0.0059163570404052734 nb_pixel_total : 816 time to create 1 rle with old method : 0.0009698867797851562 time for calcul the mask position with numpy : 0.006182193756103516 nb_pixel_total : 33814 time to create 1 rle with old method : 0.038280487060546875 time for calcul the mask position with numpy : 0.00929880142211914 nb_pixel_total : 496789 time to create 1 rle with new method : 0.12739968299865723 time for calcul the mask position with numpy : 0.00609135627746582 nb_pixel_total : 3866 time to create 1 rle with old method : 0.004571676254272461 time for calcul the mask position with numpy : 0.007015228271484375 nb_pixel_total : 28970 time to create 1 rle with old method : 0.03316855430603027 create new chi : 0.5683932304382324 time to delete rle : 0.0004832744598388672 batch 1 Loaded 9 chid ids of type : 3726 Number RLEs to save : 5123 TO DO : save crop sub photo not yet done ! save time : 21.48184847831726 nb_obj : 7 nb_hashtags : 4 time to prepare the origin masks : 0.8491532802581787 time for calcul the mask position with numpy : 0.015413045883178711 nb_pixel_total : 1414040 time to create 1 rle with new method : 0.16249942779541016 time for calcul the mask position with numpy : 0.009744644165039062 nb_pixel_total : 1101 time to create 1 rle with old method : 0.0027039051055908203 time for calcul the mask position with numpy : 0.00859975814819336 nb_pixel_total : 91829 time to create 1 rle with old method : 0.11560368537902832 time for calcul the mask position with numpy : 0.007206916809082031 nb_pixel_total : 15499 time to create 1 rle with old method : 0.01815629005432129 time for calcul the mask position with numpy : 0.007480144500732422 nb_pixel_total : 4131 time to create 1 rle with old method : 0.005506753921508789 time for calcul the mask position with numpy : 0.006796598434448242 nb_pixel_total : 2204 time to create 1 rle with old method : 0.003330230712890625 time for calcul the mask position with numpy : 0.009920120239257812 nb_pixel_total : 383954 time to create 1 rle with new method : 0.14111113548278809 time for calcul the mask position with numpy : 0.00735020637512207 nb_pixel_total : 160842 time to create 1 rle with new method : 0.032538414001464844 create new chi : 0.5655717849731445 time to delete rle : 0.0007259845733642578 batch 1 Loaded 7 chid ids of type : 3726 Number RLEs to save : 6948 TO DO : save crop sub photo not yet done ! save time : 12.395888090133667 nb_obj : 6 nb_hashtags : 2 time to prepare the origin masks : 0.741351842880249 time for calcul the mask position with numpy : 0.021662473678588867 nb_pixel_total : 1105629 time to create 1 rle with new method : 0.32121920585632324 time for calcul the mask position with numpy : 0.0067594051361083984 nb_pixel_total : 70696 time to create 1 rle with old method : 0.08372735977172852 time for calcul the mask position with numpy : 0.0064122676849365234 nb_pixel_total : 23689 time to create 1 rle with old method : 0.02658534049987793 time for calcul the mask position with numpy : 0.006273031234741211 nb_pixel_total : 6845 time to create 1 rle with old method : 0.007786750793457031 time for calcul the mask position with numpy : 0.0067861080169677734 nb_pixel_total : 124675 time to create 1 rle with old method : 0.15585684776306152 time for calcul the mask position with numpy : 0.013980865478515625 nb_pixel_total : 737565 time to create 1 rle with new method : 0.07350921630859375 time for calcul the mask position with numpy : 0.007298946380615234 nb_pixel_total : 4501 time to create 1 rle with old method : 0.005551815032958984 create new chi : 0.7515723705291748 time to delete rle : 0.0008580684661865234 batch 1 Loaded 9 chid ids of type : 3726 Number RLEs to save : 9741 TO DO : save crop sub photo not yet done ! save time : 22.61817240715027 nb_obj : 13 nb_hashtags : 3 time to prepare the origin masks : 2.9037137031555176 time for calcul the mask position with numpy : 0.13048863410949707 nb_pixel_total : 979869 time to create 1 rle with new method : 0.13290071487426758 time for calcul the mask position with numpy : 0.012118339538574219 nb_pixel_total : 870 time to create 1 rle with old method : 0.0013110637664794922 time for calcul the mask position with numpy : 0.01333928108215332 nb_pixel_total : 51856 time to create 1 rle with old method : 0.07450008392333984 time for calcul the mask position with numpy : 0.013965129852294922 nb_pixel_total : 82262 time to create 1 rle with old method : 0.10577178001403809 time for calcul the mask position with numpy : 0.013255119323730469 nb_pixel_total : 144836 time to create 1 rle with old method : 0.17645049095153809 time for calcul the mask position with numpy : 0.019684314727783203 nb_pixel_total : 8258 time to create 1 rle with old method : 0.014206647872924805 time for calcul the mask position with numpy : 0.012266397476196289 nb_pixel_total : 5546 time to create 1 rle with old method : 0.009582757949829102 time for calcul the mask position with numpy : 0.020626544952392578 nb_pixel_total : 19244 time to create 1 rle with old method : 0.02487802505493164 time for calcul the mask position with numpy : 0.013379573822021484 nb_pixel_total : 1804 time to create 1 rle with old method : 0.0022864341735839844 time for calcul the mask position with numpy : 0.01395106315612793 nb_pixel_total : 13058 time to create 1 rle with old method : 0.0161135196685791 time for calcul the mask position with numpy : 0.011817455291748047 nb_pixel_total : 1661 time to create 1 rle with old method : 0.0021619796752929688 time for calcul the mask position with numpy : 0.012034177780151367 nb_pixel_total : 7047 time to create 1 rle with old method : 0.01011204719543457 time for calcul the mask position with numpy : 0.02326345443725586 nb_pixel_total : 597014 time to create 1 rle with new method : 0.2609078884124756 time for calcul the mask position with numpy : 0.012675046920776367 nb_pixel_total : 160275 time to create 1 rle with new method : 0.0463254451751709 create new chi : 1.2157444953918457 time to delete rle : 0.003983736038208008 batch 1 Loaded 18 chid ids of type : 3726 Number RLEs to save : 11124 TO DO : save crop sub photo not yet done ! save time : 15.20922064781189 nb_obj : 9 nb_hashtags : 2 time to prepare the origin masks : 1.7470450401306152 time for calcul the mask position with numpy : 0.02505779266357422 nb_pixel_total : 1075919 time to create 1 rle with new method : 0.05226469039916992 time for calcul the mask position with numpy : 0.009279251098632812 nb_pixel_total : 53881 time to create 1 rle with old method : 0.10022521018981934 time for calcul the mask position with numpy : 0.009398698806762695 nb_pixel_total : 63305 time to create 1 rle with old method : 0.1128699779510498 time for calcul the mask position with numpy : 0.008047819137573242 nb_pixel_total : 146 time to create 1 rle with old method : 0.0005776882171630859 time for calcul the mask position with numpy : 0.008321285247802734 nb_pixel_total : 32236 time to create 1 rle with old method : 0.050211429595947266 time for calcul the mask position with numpy : 0.007463693618774414 nb_pixel_total : 2564 time to create 1 rle with old method : 0.0044329166412353516 time for calcul the mask position with numpy : 0.008492708206176758 nb_pixel_total : 9204 time to create 1 rle with old method : 0.014868021011352539 time for calcul the mask position with numpy : 0.013837337493896484 nb_pixel_total : 645002 time to create 1 rle with new method : 0.6658856868743896 time for calcul the mask position with numpy : 0.007857561111450195 nb_pixel_total : 153082 time to create 1 rle with new method : 0.32257890701293945 time for calcul the mask position with numpy : 0.008521318435668945 nb_pixel_total : 38261 time to create 1 rle with old method : 0.04381895065307617 create new chi : 1.5216054916381836 time to delete rle : 0.00109100341796875 batch 1 Loaded 13 chid ids of type : 3726 Number RLEs to save : 8806 TO DO : save crop sub photo not yet done ! save time : 11.934409618377686 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.5040478706359863 time for calcul the mask position with numpy : 0.0249178409576416 nb_pixel_total : 1066893 time to create 1 rle with new method : 0.20954084396362305 time for calcul the mask position with numpy : 0.007980585098266602 nb_pixel_total : 13140 time to create 1 rle with old method : 0.018793344497680664 time for calcul the mask position with numpy : 0.013725996017456055 nb_pixel_total : 5750 time to create 1 rle with old method : 0.01011967658996582 time for calcul the mask position with numpy : 0.020121097564697266 nb_pixel_total : 986163 time to create 1 rle with new method : 0.0321195125579834 time for calcul the mask position with numpy : 0.007714509963989258 nb_pixel_total : 1654 time to create 1 rle with old method : 0.00196075439453125 create new chi : 0.3479905128479004 time to delete rle : 0.000629425048828125 batch 1 Loaded 5 chid ids of type : 3726 Number RLEs to save : 5415 TO DO : save crop sub photo not yet done ! save time : 5.475648641586304 nb_obj : 6 nb_hashtags : 2 time to prepare the origin masks : 0.6131720542907715 time for calcul the mask position with numpy : 0.020869970321655273 nb_pixel_total : 902089 time to create 1 rle with new method : 0.3529379367828369 time for calcul the mask position with numpy : 0.009112358093261719 nb_pixel_total : 104509 time to create 1 rle with old method : 0.15654873847961426 time for calcul the mask position with numpy : 0.008796453475952148 nb_pixel_total : 74708 time to create 1 rle with old method : 0.0899510383605957 time for calcul the mask position with numpy : 0.019426584243774414 nb_pixel_total : 950063 time to create 1 rle with new method : 0.050313472747802734 time for calcul the mask position with numpy : 0.008979082107543945 nb_pixel_total : 19489 time to create 1 rle with old method : 0.024129629135131836 time for calcul the mask position with numpy : 0.008832693099975586 nb_pixel_total : 14005 time to create 1 rle with old method : 0.015980958938598633 time for calcul the mask position with numpy : 0.009589433670043945 nb_pixel_total : 8737 time to create 1 rle with old method : 0.010097742080688477 create new chi : 0.786794900894165 time to delete rle : 0.0008363723754882812 batch 1 Loaded 8 chid ids of type : 3726 Number RLEs to save : 6182 TO DO : save crop sub photo not yet done ! save time : 8.742565870285034 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.5431702136993408 time for calcul the mask position with numpy : 0.026840925216674805 nb_pixel_total : 1249976 time to create 1 rle with new method : 0.23314213752746582 time for calcul the mask position with numpy : 0.008861303329467773 nb_pixel_total : 51853 time to create 1 rle with old method : 0.05907845497131348 time for calcul the mask position with numpy : 0.011504411697387695 nb_pixel_total : 374949 time to create 1 rle with new method : 0.16440057754516602 time for calcul the mask position with numpy : 0.012334346771240234 nb_pixel_total : 270589 time to create 1 rle with new method : 0.25713253021240234 time for calcul the mask position with numpy : 0.01192331314086914 nb_pixel_total : 126233 time to create 1 rle with old method : 0.17241549491882324 create new chi : 0.9898407459259033 time to delete rle : 0.0012598037719726562 batch 1 Loaded 5 chid ids of type : 3726 Number RLEs to save : 9055 TO DO : save crop sub photo not yet done ! save time : 8.430662870407104 nb_obj : 10 nb_hashtags : 2 time to prepare the origin masks : 1.116623878479004 time for calcul the mask position with numpy : 0.04372739791870117 nb_pixel_total : 1184637 time to create 1 rle with new method : 0.10890746116638184 time for calcul the mask position with numpy : 0.008003473281860352 nb_pixel_total : 10998 time to create 1 rle with old method : 0.012640953063964844 time for calcul the mask position with numpy : 0.006979703903198242 nb_pixel_total : 44753 time to create 1 rle with old method : 0.04827427864074707 time for calcul the mask position with numpy : 0.00745081901550293 nb_pixel_total : 510 time to create 1 rle with old method : 0.0006527900695800781 time for calcul the mask position with numpy : 0.0074100494384765625 nb_pixel_total : 242 time to create 1 rle with old method : 0.0006377696990966797 time for calcul the mask position with numpy : 0.00880289077758789 nb_pixel_total : 75750 time to create 1 rle with old method : 0.09304976463317871 time for calcul the mask position with numpy : 0.0071523189544677734 nb_pixel_total : 1519 time to create 1 rle with old method : 0.0027191638946533203 time for calcul the mask position with numpy : 0.013743400573730469 nb_pixel_total : 684616 time to create 1 rle with new method : 0.10373187065124512 time for calcul the mask position with numpy : 0.007472515106201172 nb_pixel_total : 53178 time to create 1 rle with old method : 0.05742144584655762 time for calcul the mask position with numpy : 0.006949901580810547 nb_pixel_total : 247 time to create 1 rle with old method : 0.0004127025604248047 time for calcul the mask position with numpy : 0.007066011428833008 nb_pixel_total : 17150 time to create 1 rle with old method : 0.21148061752319336 create new chi : 0.775794506072998 time to delete rle : 0.0008006095886230469 batch 1 Loaded 13 chid ids of type : 3726 Number RLEs to save : 7288 TO DO : save crop sub photo not yet done ! save time : 4.885602951049805 map_output_result : {1342938009: (0.0, 'Should be the crop_list due to order', 0), 1342937360: (0.0, 'Should be the crop_list due to order', 0), 1342937303: (0.0, 'Should be the crop_list due to order', 0), 1342936931: (0.0, 'Should be the crop_list due to order', 0), 1342936917: (0.0, 'Should be the crop_list due to order', 0), 1342936672: (0.0, 'Should be the crop_list due to order', 0), 1342936671: (0.0, 'Should be the crop_list due to order', 0), 1342936550: (0.0, 'Should be the crop_list due to order', 0), 1342936525: (0.0, 'Should be the crop_list due to order', 0), 1342936327: (0.0, 'Should be the crop_list due to order', 0)} 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 [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 10 /1342938009.Didn't retrieve data . /1342937360.Didn't retrieve data . /1342937303.Didn't retrieve data . /1342936931.Didn't retrieve data . /1342936917.Didn't retrieve data . /1342936672.Didn't retrieve data . /1342936671.Didn't retrieve data . /1342936550.Didn't retrieve data . /1342936525.Didn't retrieve data . /1342936327.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 ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.014522790908813477 save_final save missing photos in datou_result : time spend for datou_step_exec : 148.66194653511047 time spend to save output : 0.017403841018676758 total time spend for step 5 : 148.67935037612915 step6:crop_condition Tue Mar 11 11:41:13 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 ! VR 22-3-18 : For now we do not clean correctly the datou structure every photo are already treated, don't need to treat again BBBBBBBBFBFBFBFBFBFBFBFBFFFFFFFFInside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 16 /1342943167Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342943171Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342943176Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342943179Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944586Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944587Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944589Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944593Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944594Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342943210Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944657Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342943228Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944683Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944684Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342943258Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1342944702Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . before output type Here is an output not treated by saveGeneral : Here is an output not treated by saveGeneral : Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 58 time used for this insertion : 0.023360490798950195 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.28953003883361816 time spend to save output : 0.024298429489135742 total time spend for step 6 : 0.3138284683227539 step7:ventilate_hashtags_in_portfolio Tue Mar 11 11:41:14 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 ! To do loadFromThcl(), then load ParamDescType : thcl2725 thcls : [{'id': 2725, 'mtr_user_id': 31, 'name': 'learn_qualipapia_rle_210302_2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3460440,3460441,3460446,3460434,3460439,3467416,3460442,3460443,3486028,3460445', 'photo_hashtag_type': 3410, 'photo_desc_type': 5186, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'}] thcl {'id': 2725, 'mtr_user_id': 31, 'name': 'learn_qualipapia_rle_210302_2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3460440,3460441,3460446,3460434,3460439,3467416,3460442,3460443,3486028,3460445', 'photo_hashtag_type': 3410, 'photo_desc_type': 5186, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'} Update svm_hashtag_type_desc : 5186 Iterating over portfolio : 21277895 get user id for portfolio 21277895 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`=21277895 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('environnement','flou','Carton_gris','papier','Carton_brun','plastique','mal_croppe','autre_refus','cartonnette','kraft','Teint_Dans_La_Masse','metal')) AND mptpi.`min_score`=0.5 To do 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`=21277895 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('environnement','flou','Carton_gris','papier','Carton_brun','plastique','mal_croppe','autre_refus','cartonnette','kraft','Teint_Dans_La_Masse','metal')) 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`=21277895 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('environnement','flou','Carton_gris','papier','Carton_brun','plastique','mal_croppe','autre_refus','cartonnette','kraft','Teint_Dans_La_Masse','metal')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/21278365,21278366,21278367,21278368,21278369,21278370,21278371,21278372,21278373,21278374,21278375,21278376?tags=environnement,flou,Carton_gris,papier,Carton_brun,plastique,mal_croppe,autre_refus,cartonnette,kraft,Teint_Dans_La_Masse,metal Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 1 /21277895. 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 ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.014150381088256836 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.0807831287384033 time spend to save output : 0.014612913131713867 total time spend for step 7 : 2.095396041870117 step8:final Tue Mar 11 11:41:16 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 ! Catched exception ! Connect or reconnect ! Inside saveOutput : final : False verbose : 0 original output for save of step final : {1342938009: ('0.04075112371931678',), 1342937360: ('0.04075112371931678',), 1342937303: ('0.04075112371931678',), 1342936931: ('0.04075112371931678',), 1342936917: ('0.04075112371931678',), 1342936672: ('0.04075112371931678',), 1342936671: ('0.04075112371931678',), 1342936550: ('0.04075112371931678',), 1342936525: ('0.04075112371931678',), 1342936327: ('0.04075112371931678',)} new output for save of step final : {1342938009: ('0.04075112371931678',), 1342937360: ('0.04075112371931678',), 1342937303: ('0.04075112371931678',), 1342936931: ('0.04075112371931678',), 1342936917: ('0.04075112371931678',), 1342936672: ('0.04075112371931678',), 1342936671: ('0.04075112371931678',), 1342936550: ('0.04075112371931678',), 1342936525: ('0.04075112371931678',), 1342936327: ('0.04075112371931678',)} [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 10 /1342938009.Didn't retrieve data . /1342937360.Didn't retrieve data . /1342937303.Didn't retrieve data . /1342936931.Didn't retrieve data . /1342936917.Didn't retrieve data . /1342936672.Didn't retrieve data . /1342936671.Didn't retrieve data . /1342936550.Didn't retrieve data . /1342936525.Didn't retrieve data . /1342936327.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 ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.18215489387512207 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.11138534545898438 time spend to save output : 0.18285846710205078 total time spend for step 8 : 0.29424381256103516 step9:velours_tree Tue Mar 11 11:41:16 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 VR 22-3-18 : For now we do not clean correctly the datou structure can't find the photo_desc_type Inside saveOutput : final : False verbose : 0 ouput is None No outpout to save, returning out of save general time spend for datou_step_exec : 0.19541049003601074 time spend to save output : 5.3882598876953125e-05 total time spend for step 9 : 0.1954643726348877 step10:send_mail_cod Tue Mar 11 11:41:16 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 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_Auto_P21277895_11-03-2025_11_41_16.pdf 21278366 imagette212783661741689676 21278370 imagette212783701741689676 21278371 imagette212783711741689676 21278372 change filename to text .change filename to text .imagette212783721741689676 21278373 change filename to text .change filename to text .change filename to text .change filename to text .imagette212783731741689677 21278374 imagette212783741741689677 21278376 imagette212783761741689677 21278367 imagette212783671741689677 21278369 change filename to text .change filename to text .change filename to text .imagette212783691741689677 21278375 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 .imagette212783751741689677 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=21277895 and hashtag_type = 3726 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/21278365,21278366,21278367,21278368,21278369,21278370,21278371,21278372,21278373,21278374,21278375,21278376?tags=environnement,flou,Carton_gris,papier,Carton_brun,plastique,mal_croppe,autre_refus,cartonnette,kraft,Teint_Dans_La_Masse,metal your option no_mail is active, we will not send the real mail to your client args[1342938009] : ('0.04075112371931678',) no score found for photo 1342938009 We are sending mail with results at report@fotonower.com args[1342937360] : ('0.04075112371931678',) no score found for photo 1342937360 We are sending mail with results at report@fotonower.com args[1342937303] : ('0.04075112371931678',) no score found for photo 1342937303 We are sending mail with results at report@fotonower.com args[1342936931] : ('0.04075112371931678',) no score found for photo 1342936931 We are sending mail with results at report@fotonower.com args[1342936917] : ('0.04075112371931678',) no score found for photo 1342936917 We are sending mail with results at report@fotonower.com args[1342936672] : ('0.04075112371931678',) no score found for photo 1342936672 We are sending mail with results at report@fotonower.com args[1342936671] : ('0.04075112371931678',) no score found for photo 1342936671 We are sending mail with results at report@fotonower.com args[1342936550] : ('0.04075112371931678',) no score found for photo 1342936550 We are sending mail with results at report@fotonower.com args[1342936525] : ('0.04075112371931678',) no score found for photo 1342936525 We are sending mail with results at report@fotonower.com args[1342936327] : ('0.04075112371931678',) no score found for photo 1342936327 We are sending mail with results at report@fotonower.com refus_total : 0.04075112371931678 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=21277895 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 1000 SELECT photo_id, url FROM MTRBack.photos ph WHERE photo_id IN (1342938009,1342935876,1342937360,1342937303,1342936931,1342936917,1342936672,1342936671,1342936550,1342936525,1342936327,1342936322,1342936084,1342936070,1342935897,1342933295,1342935752,1342935748,1342935744,1342935743) Found this number of photos: 20 begin to download photo : 1342938009 begin to download photo : 1342936917 begin to download photo : 1342936327 begin to download photo : 1342933295 download finish for photo 1342938009 begin to download photo : 1342935876 download finish for photo 1342933295 begin to download photo : 1342935752 download finish for photo 1342936917 begin to download photo : 1342936672 download finish for photo 1342936327 begin to download photo : 1342936322 download finish for photo 1342935752 begin to download photo : 1342935748 download finish for photo 1342936672 begin to download photo : 1342936671 download finish for photo 1342935876 begin to download photo : 1342937360 download finish for photo 1342936322 begin to download photo : 1342936084 download finish for photo 1342936671 begin to download photo : 1342936550 download finish for photo 1342935748 begin to download photo : 1342935744 download finish for photo 1342936084 begin to download photo : 1342936070 download finish for photo 1342937360 begin to download photo : 1342937303 download finish for photo 1342936550 begin to download photo : 1342936525 download finish for photo 1342935744 begin to download photo : 1342935743 download finish for photo 1342936070 begin to download photo : 1342935897 download finish for photo 1342936525 download finish for photo 1342937303 begin to download photo : 1342936931 download finish for photo 1342935743 download finish for photo 1342935897 download finish for photo 1342936931 start upload file to ovh https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21277895_11-03-2025_11_41_16.pdf results_Auto_P21277895_11-03-2025_11_41_16.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21277895_11-03-2025_11_41_16.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('3459','21277895','results_Auto_P21277895_11-03-2025_11_41_16.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21277895_11-03-2025_11_41_16.pdf','pdf','','0.22','0.04075112371931678') Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] 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 ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 10 time used for this insertion : 0.014322757720947266 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.2103047370910645 time spend to save output : 0.014844894409179688 total time spend for step 10 : 3.225149631500244 step11:split_time_score Tue Mar 11 11:41:20 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 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 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! 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'}] (('10', 29),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 11032025 21277895 Nombre de photos uploadées : 29 / 23040 (0%) 11032025 21277895 Nombre de photos taguées (types de déchets): 0 / 29 (0%) 11032025 21277895 Nombre de photos taguées (volume) : 0 / 29 (0%) elapsed_time : load_data_split_time_score 4.76837158203125e-06 elapsed_time : order_list_meta_photo_and_scores 1.5497207641601562e-05 ????????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.001817941665649414 elapsed_time : insert_dashboard_record_day_entry 0.028753280639648438 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps Qualite : 0.038386490015462016 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21263611_11-03-2025_07_25_24.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21263611 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21263611 AND mptpi.`type`=3726 To do Qualite : 0.05056784075918166 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21264436_11-03-2025_07_39_18.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21264436 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21264436 AND mptpi.`type`=3726 To do Qualite : 0.03480265453910918 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21266837_11-03-2025_08_41_15.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21266837 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21266837 AND mptpi.`type`=3726 To do Qualite : 0.018221849066882945 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21266838_11-03-2025_08_32_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21266838 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21266838 AND mptpi.`type`=3726 To do Qualite : 0.02757936120289834 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21266839_11-03-2025_08_32_12.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21266839 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21266839 AND mptpi.`type`=3726 To do Qualite : 0.03619114713077011 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21267464_11-03-2025_08_44_58.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21267464 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21267464 AND mptpi.`type`=3726 To do Qualite : 0.023686734530282163 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21268164_11-03-2025_08_56_54.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21268164 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21268164 AND mptpi.`type`=3726 To do Qualite : 0.06472864279672208 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21268999_11-03-2025_09_08_02.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21268999 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21268999 AND mptpi.`type`=3726 To do Qualite : 0.022725751476265443 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21271629_11-03-2025_09_55_19.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21271629 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21271629 AND mptpi.`type`=3726 To do Qualite : 0.04417561650941215 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21274019_11-03-2025_10_44_50.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21274019 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21274019 AND mptpi.`type`=3726 To do Qualite : 0.020702355079917915 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21274022_11-03-2025_10_43_52.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21274022 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21274022 AND mptpi.`type`=3726 To do Qualite : 0.06354226399793901 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21275684_11-03-2025_11_05_49.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21275684 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21275684 AND mptpi.`type`=3726 To do Qualite : 0.04075112371931678 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21277895_11-03-2025_11_41_16.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21277895 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 ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21277895 AND mptpi.`type`=3726 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21277896 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21277897 order by id desc limit 1 NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'11032025': {'nb_upload': 29, '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 [1342938009, 1342937360, 1342937303, 1342936931, 1342936917, 1342936672, 1342936671, 1342936550, 1342936525, 1342936327] Looping around the photos to save general results len do output : 1 /21277895Didn'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 ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342938009', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937360', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342937303', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936931', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936917', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936672', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936671', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936550', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936525', None, None, None, None, None, '2657788') ('3459', None, None, None, None, None, None, None, '2657788') ('3459', '21277895', '1342936327', None, None, None, None, None, '2657788') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.014424324035644531 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.65364146232605 time spend to save output : 0.014670848846435547 total time spend for step 11 : 2.6683123111724854 caffe_path_current : About to save ! 2 After save, about to update current ! update_current_state 46.96user 33.89system 5:01.34elapsed 26%CPU (0avgtext+0avgdata 2600332maxresident)k 1064312inputs+28400outputs (10142major+2433039minor)pagefaults 0swaps