python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 10 -a ' -a 4234 -l 5 ' -s datou_current_4234 -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 : 2838843 load datou : 4234 # 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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 ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? 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 ? 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 ? 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 : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5561, 'learn_rubbia_refus_2500', 2048, 2048, 'learn_rubbia_refus_2500', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 3, datetime.datetime(2021, 12, 2, 19, 10, 8), datetime.datetime(2021, 12, 2, 19, 10, 8)) load thcls load THCL from format json or kwargs add thcl : 2847 in CacheModelConfig load THCL from format json or kwargs add thcl : 3237 in CacheModelConfig load pdts add pdt : 5275 in CacheModelConfig add pdt : 5561 in CacheModelConfig Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec updating current state to 1 list_input_json: [] Current got : datou_id : 4234, datou_cur_ids : ['2627078'] with mtr_portfolio_ids : ['20951100'] and first list_photo_ids : [] new path : /proc/2838843/ 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 DataTypes for each output/input checked ! List Step Type Loaded in datou : mask_detect, brightness, blur_detection, rle_unique_nms_with_priority, crop_condition, thcl, ventilate_hashtags_in_portfolio, final, velours_tree, send_mail_cod, split_time_score list_input_json : [] origin We have 1 , BFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 2 ; length of list_pids : 2 ; length of list_args : 2 time to download the photos : 0.8709442615509033 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 Sat Mar 1 19:20:30 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 : 5525 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-03-01 19:20:33.150708: 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-01 19:20:33.175042: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-03-01 19:20:33.177280: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fbe54000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-03-01 19:20:33.177339: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-03-01 19:20:33.181398: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-03-01 19:20:33.422802: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0xf1fcd90 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-03-01 19:20:33.422887: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-03-01 19:20:33.424170: 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-01 19:20:33.424637: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-01 19:20:33.427815: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-01 19:20:33.430663: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-01 19:20:33.431156: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-01 19:20:33.434152: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-01 19:20:33.435506: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-01 19:20:33.441124: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-01 19:20:33.442572: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-01 19:20:33.442661: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-01 19:20:33.443468: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-03-01 19:20:33.443488: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-03-01 19:20:33.443499: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-03-01 19:20:33.444797: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 5051 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-01 19:20:33.708789: 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-01 19:20:33.708896: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-01 19:20:33.708925: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-01 19:20:33.708961: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-01 19:20:33.708987: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-01 19:20:33.709015: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-01 19:20:33.709039: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-01 19:20:33.709064: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-01 19:20:33.710723: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-01 19:20:33.712092: 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-01 19:20:33.712141: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-01 19:20:33.712157: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-01 19:20:33.712172: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-01 19:20:33.712186: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-01 19:20:33.712200: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-01 19:20:33.712214: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-01 19:20:33.712229: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-01 19:20:33.713235: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-01 19:20:33.713264: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-03-01 19:20:33.713273: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-03-01 19:20:33.713281: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-03-01 19:20:33.714362: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 5051 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 : thcl2847 thcls : [{'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}] thcl {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5275 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) {'thcl': {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'], 'list_hashtags_csv': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'svm_hashtag_type_desc': 5275, 'photo_desc_type': 5275, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', '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_RUBBIA_REFUS_AMIENS_23 NUM_CLASSES 9 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_RUBBIA_REFUS_AMIENS_23 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-03-01 19:20:41.473962: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-01 19:20:41.667148: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 local folder : /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23 /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23/mask_model.h5 size_local : 256009536 size in s3 : 256009536 create time local : 2021-08-09 09:43:22 create time in s3 : 2021-08-06 18:54:04 mask_model.h5 already exist and didn't need to update list_images length : 2 NEW PHOTO pour l'instant on ne peut pas sauvegarder la photo dans les tile Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -116.92656 max: 149.14297 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 5 time for calcul the mask position with numpy : 6.914138793945312e-05 nb_pixel_total : 339 time to create 1 rle with old method : 0.00069427490234375 length of segment : 33 time for calcul the mask position with numpy : 4.410743713378906e-05 nb_pixel_total : 25 time to create 1 rle with old method : 8.654594421386719e-05 length of segment : 7 time for calcul the mask position with numpy : 5.793571472167969e-05 nb_pixel_total : 701 time to create 1 rle with old method : 0.0019333362579345703 length of segment : 53 time for calcul the mask position with numpy : 5.245208740234375e-05 nb_pixel_total : 793 time to create 1 rle with old method : 0.0014903545379638672 length of segment : 57 time for calcul the mask position with numpy : 5.1021575927734375e-05 nb_pixel_total : 614 time to create 1 rle with old method : 0.0013933181762695312 length of segment : 42 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -122.32891 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 5 time for calcul the mask position with numpy : 3.814697265625e-05 nb_pixel_total : 47 time to create 1 rle with old method : 0.00011229515075683594 length of segment : 7 time for calcul the mask position with numpy : 6.151199340820312e-05 nb_pixel_total : 2441 time to create 1 rle with old method : 0.0030317306518554688 length of segment : 47 time for calcul the mask position with numpy : 6.413459777832031e-05 nb_pixel_total : 2615 time to create 1 rle with old method : 0.0033330917358398438 length of segment : 53 time for calcul the mask position with numpy : 5.1975250244140625e-05 nb_pixel_total : 997 time to create 1 rle with old method : 0.001352548599243164 length of segment : 30 time for calcul the mask position with numpy : 4.4345855712890625e-05 nb_pixel_total : 966 time to create 1 rle with old method : 0.0012722015380859375 length of segment : 34 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -120.50078 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 5 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 1164 time to create 1 rle with old method : 0.001739501953125 length of segment : 20 time for calcul the mask position with numpy : 9.226799011230469e-05 nb_pixel_total : 1887 time to create 1 rle with old method : 0.002462625503540039 length of segment : 70 time for calcul the mask position with numpy : 5.1975250244140625e-05 nb_pixel_total : 773 time to create 1 rle with old method : 0.0010848045349121094 length of segment : 32 time for calcul the mask position with numpy : 4.315376281738281e-05 nb_pixel_total : 626 time to create 1 rle with old method : 0.0008282661437988281 length of segment : 44 time for calcul the mask position with numpy : 3.719329833984375e-05 nb_pixel_total : 407 time to create 1 rle with old method : 0.0005674362182617188 length of segment : 21 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -122.93438 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 7 time for calcul the mask position with numpy : 4.839897155761719e-05 nb_pixel_total : 277 time to create 1 rle with old method : 0.00057220458984375 length of segment : 19 time for calcul the mask position with numpy : 0.00019812583923339844 nb_pixel_total : 10504 time to create 1 rle with old method : 0.018135547637939453 length of segment : 81 time for calcul the mask position with numpy : 5.507469177246094e-05 nb_pixel_total : 707 time to create 1 rle with old method : 0.0009319782257080078 length of segment : 36 time for calcul the mask position with numpy : 4.1484832763671875e-05 nb_pixel_total : 804 time to create 1 rle with old method : 0.0011119842529296875 length of segment : 34 time for calcul the mask position with numpy : 4.00543212890625e-05 nb_pixel_total : 403 time to create 1 rle with old method : 0.0006494522094726562 length of segment : 24 time for calcul the mask position with numpy : 5.888938903808594e-05 nb_pixel_total : 1604 time to create 1 rle with old method : 0.0021812915802001953 length of segment : 33 time for calcul the mask position with numpy : 4.9114227294921875e-05 nb_pixel_total : 516 time to create 1 rle with old method : 0.0006587505340576172 length of segment : 36 Processing 1 images image shape: (400, 320, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 131.17812 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 3 time for calcul the mask position with numpy : 4.935264587402344e-05 nb_pixel_total : 484 time to create 1 rle with old method : 0.00084686279296875 length of segment : 19 time for calcul the mask position with numpy : 5.364418029785156e-05 nb_pixel_total : 1175 time to create 1 rle with old method : 0.0014901161193847656 length of segment : 79 time for calcul the mask position with numpy : 5.626678466796875e-05 nb_pixel_total : 821 time to create 1 rle with old method : 0.0010390281677246094 length of segment : 83 Processing 1 images image shape: (400, 400, 3) min: 11.00000 max: 185.00000 molded_images shape: (1, 640, 640, 3) min: -98.69609 max: 69.18203 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 0 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -120.32500 max: 141.78359 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 10 time for calcul the mask position with numpy : 4.1961669921875e-05 nb_pixel_total : 326 time to create 1 rle with old method : 0.00047278404235839844 length of segment : 24 time for calcul the mask position with numpy : 4.3392181396484375e-05 nb_pixel_total : 838 time to create 1 rle with old method : 0.0011186599731445312 length of segment : 44 time for calcul the mask position with numpy : 3.6716461181640625e-05 nb_pixel_total : 433 time to create 1 rle with old method : 0.0006492137908935547 length of segment : 28 time for calcul the mask position with numpy : 3.647804260253906e-05 nb_pixel_total : 433 time to create 1 rle with old method : 0.0005652904510498047 length of segment : 56 time for calcul the mask position with numpy : 3.24249267578125e-05 nb_pixel_total : 210 time to create 1 rle with old method : 0.0003027915954589844 length of segment : 18 time for calcul the mask position with numpy : 0.0001404285430908203 nb_pixel_total : 6570 time to create 1 rle with old method : 0.00800776481628418 length of segment : 113 time for calcul the mask position with numpy : 3.838539123535156e-05 nb_pixel_total : 253 time to create 1 rle with old method : 0.0003604888916015625 length of segment : 23 time for calcul the mask position with numpy : 3.266334533691406e-05 nb_pixel_total : 202 time to create 1 rle with old method : 0.00036334991455078125 length of segment : 21 time for calcul the mask position with numpy : 6.318092346191406e-05 nb_pixel_total : 311 time to create 1 rle with old method : 0.00045108795166015625 length of segment : 18 time for calcul the mask position with numpy : 3.409385681152344e-05 nb_pixel_total : 357 time to create 1 rle with old method : 0.0005087852478027344 length of segment : 20 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -117.46172 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 11 time for calcul the mask position with numpy : 4.649162292480469e-05 nb_pixel_total : 395 time to create 1 rle with old method : 0.000579833984375 length of segment : 26 time for calcul the mask position with numpy : 3.2901763916015625e-05 nb_pixel_total : 145 time to create 1 rle with old method : 0.00023627281188964844 length of segment : 14 time for calcul the mask position with numpy : 3.838539123535156e-05 nb_pixel_total : 322 time to create 1 rle with old method : 0.0004603862762451172 length of segment : 34 time for calcul the mask position with numpy : 6.031990051269531e-05 nb_pixel_total : 784 time to create 1 rle with old method : 0.0011620521545410156 length of segment : 36 time for calcul the mask position with numpy : 0.00027370452880859375 nb_pixel_total : 11101 time to create 1 rle with old method : 0.013710737228393555 length of segment : 158 time for calcul the mask position with numpy : 4.5299530029296875e-05 nb_pixel_total : 407 time to create 1 rle with old method : 0.0006031990051269531 length of segment : 20 time for calcul the mask position with numpy : 3.7670135498046875e-05 nb_pixel_total : 144 time to create 1 rle with old method : 0.00025463104248046875 length of segment : 14 time for calcul the mask position with numpy : 6.365776062011719e-05 nb_pixel_total : 1852 time to create 1 rle with old method : 0.002397775650024414 length of segment : 51 time for calcul the mask position with numpy : 5.841255187988281e-05 nb_pixel_total : 565 time to create 1 rle with old method : 0.0007345676422119141 length of segment : 27 time for calcul the mask position with numpy : 6.175041198730469e-05 nb_pixel_total : 1267 time to create 1 rle with old method : 0.001734018325805664 length of segment : 38 time for calcul the mask position with numpy : 4.506111145019531e-05 nb_pixel_total : 188 time to create 1 rle with old method : 0.0002980232238769531 length of segment : 15 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -118.67656 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 8 time for calcul the mask position with numpy : 0.000263214111328125 nb_pixel_total : 15349 time to create 1 rle with old method : 0.0230712890625 length of segment : 130 time for calcul the mask position with numpy : 0.00010561943054199219 nb_pixel_total : 2093 time to create 1 rle with old method : 0.0026617050170898438 length of segment : 131 time for calcul the mask position with numpy : 5.435943603515625e-05 nb_pixel_total : 942 time to create 1 rle with old method : 0.0011827945709228516 length of segment : 55 time for calcul the mask position with numpy : 3.123283386230469e-05 nb_pixel_total : 206 time to create 1 rle with old method : 0.0003628730773925781 length of segment : 7 time for calcul the mask position with numpy : 0.0004153251647949219 nb_pixel_total : 23463 time to create 1 rle with old method : 0.02625727653503418 length of segment : 235 time for calcul the mask position with numpy : 5.364418029785156e-05 nb_pixel_total : 1291 time to create 1 rle with old method : 0.0015683174133300781 length of segment : 40 time for calcul the mask position with numpy : 0.0002300739288330078 nb_pixel_total : 15736 time to create 1 rle with old method : 0.01788949966430664 length of segment : 120 time for calcul the mask position with numpy : 6.461143493652344e-05 nb_pixel_total : 1411 time to create 1 rle with old method : 0.0017344951629638672 length of segment : 44 Processing 1 images image shape: (400, 320, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 134.15859 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 6 time for calcul the mask position with numpy : 0.00012040138244628906 nb_pixel_total : 2364 time to create 1 rle with old method : 0.0029833316802978516 length of segment : 177 time for calcul the mask position with numpy : 4.57763671875e-05 nb_pixel_total : 620 time to create 1 rle with old method : 0.0007693767547607422 length of segment : 42 time for calcul the mask position with numpy : 0.00022339820861816406 nb_pixel_total : 5885 time to create 1 rle with old method : 0.007302522659301758 length of segment : 258 time for calcul the mask position with numpy : 4.553794860839844e-05 nb_pixel_total : 644 time to create 1 rle with old method : 0.0008800029754638672 length of segment : 40 time for calcul the mask position with numpy : 8.368492126464844e-05 nb_pixel_total : 2668 time to create 1 rle with old method : 0.003510713577270508 length of segment : 121 time for calcul the mask position with numpy : 0.000179290771484375 nb_pixel_total : 3608 time to create 1 rle with old method : 0.004458904266357422 length of segment : 189 Processing 1 images image shape: (280, 400, 3) min: 4.00000 max: 175.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 56.38125 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 1 time for calcul the mask position with numpy : 0.0009958744049072266 nb_pixel_total : 106345 time to create 1 rle with old method : 0.11834597587585449 length of segment : 284 Processing 1 images image shape: (280, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 138.09219 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 22 time for calcul the mask position with numpy : 5.698204040527344e-05 nb_pixel_total : 243 time to create 1 rle with old method : 0.0005276203155517578 length of segment : 11 time for calcul the mask position with numpy : 6.270408630371094e-05 nb_pixel_total : 1146 time to create 1 rle with old method : 0.0021407604217529297 length of segment : 39 time for calcul the mask position with numpy : 9.918212890625e-05 nb_pixel_total : 3742 time to create 1 rle with old method : 0.0065670013427734375 length of segment : 60 time for calcul the mask position with numpy : 4.9591064453125e-05 nb_pixel_total : 516 time to create 1 rle with old method : 0.0010428428649902344 length of segment : 23 time for calcul the mask position with numpy : 0.00010371208190917969 nb_pixel_total : 2446 time to create 1 rle with old method : 0.004469871520996094 length of segment : 100 time for calcul the mask position with numpy : 4.1484832763671875e-05 nb_pixel_total : 118 time to create 1 rle with old method : 0.0002551078796386719 length of segment : 14 time for calcul the mask position with numpy : 5.269050598144531e-05 nb_pixel_total : 613 time to create 1 rle with old method : 0.0011124610900878906 length of segment : 34 time for calcul the mask position with numpy : 3.075599670410156e-05 nb_pixel_total : 97 time to create 1 rle with old method : 0.00016832351684570312 length of segment : 15 time for calcul the mask position with numpy : 7.724761962890625e-05 nb_pixel_total : 3747 time to create 1 rle with old method : 0.004263401031494141 length of segment : 82 time for calcul the mask position with numpy : 3.743171691894531e-05 nb_pixel_total : 225 time to create 1 rle with old method : 0.00036072731018066406 length of segment : 43 time for calcul the mask position with numpy : 4.649162292480469e-05 nb_pixel_total : 1110 time to create 1 rle with old method : 0.0013163089752197266 length of segment : 50 time for calcul the mask position with numpy : 2.956390380859375e-05 nb_pixel_total : 217 time to create 1 rle with old method : 0.00031113624572753906 length of segment : 19 time for calcul the mask position with numpy : 2.574920654296875e-05 nb_pixel_total : 64 time to create 1 rle with old method : 0.00011157989501953125 length of segment : 10 time for calcul the mask position with numpy : 2.7179718017578125e-05 nb_pixel_total : 159 time to create 1 rle with old method : 0.00023174285888671875 length of segment : 15 time for calcul the mask position with numpy : 3.6716461181640625e-05 nb_pixel_total : 625 time to create 1 rle with old method : 0.0008096694946289062 length of segment : 29 time for calcul the mask position with numpy : 6.413459777832031e-05 nb_pixel_total : 995 time to create 1 rle with old method : 0.0012307167053222656 length of segment : 131 time for calcul the mask position with numpy : 4.5299530029296875e-05 nb_pixel_total : 18 time to create 1 rle with old method : 4.100799560546875e-05 length of segment : 13 time for calcul the mask position with numpy : 7.009506225585938e-05 nb_pixel_total : 2200 time to create 1 rle with old method : 0.002655029296875 length of segment : 84 time for calcul the mask position with numpy : 6.246566772460938e-05 nb_pixel_total : 873 time to create 1 rle with old method : 0.0010654926300048828 length of segment : 123 time for calcul the mask position with numpy : 3.218650817871094e-05 nb_pixel_total : 154 time to create 1 rle with old method : 0.0002532005310058594 length of segment : 13 time for calcul the mask position with numpy : 3.4809112548828125e-05 nb_pixel_total : 555 time to create 1 rle with old method : 0.0006799697875976562 length of segment : 30 time for calcul the mask position with numpy : 6.723403930664062e-05 nb_pixel_total : 884 time to create 1 rle with old method : 0.0010230541229248047 length of segment : 126 Processing 1 images image shape: (280, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 136.34609 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 13 time for calcul the mask position with numpy : 5.91278076171875e-05 nb_pixel_total : 201 time to create 1 rle with old method : 0.00044417381286621094 length of segment : 13 time for calcul the mask position with numpy : 3.457069396972656e-05 nb_pixel_total : 137 time to create 1 rle with old method : 0.00023126602172851562 length of segment : 11 time for calcul the mask position with numpy : 3.4332275390625e-05 nb_pixel_total : 203 time to create 1 rle with old method : 0.00030517578125 length of segment : 18 time for calcul the mask position with numpy : 3.0279159545898438e-05 nb_pixel_total : 108 time to create 1 rle with old method : 0.00017380714416503906 length of segment : 17 time for calcul the mask position with numpy : 5.125999450683594e-05 nb_pixel_total : 352 time to create 1 rle with old method : 0.0005557537078857422 length of segment : 45 time for calcul the mask position with numpy : 3.266334533691406e-05 nb_pixel_total : 200 time to create 1 rle with old method : 0.0002923011779785156 length of segment : 21 time for calcul the mask position with numpy : 3.504753112792969e-05 nb_pixel_total : 293 time to create 1 rle with old method : 0.00042057037353515625 length of segment : 20 time for calcul the mask position with numpy : 3.123283386230469e-05 nb_pixel_total : 166 time to create 1 rle with old method : 0.0002605915069580078 length of segment : 17 time for calcul the mask position with numpy : 3.4332275390625e-05 nb_pixel_total : 213 time to create 1 rle with old method : 0.00033092498779296875 length of segment : 32 time for calcul the mask position with numpy : 4.172325134277344e-05 nb_pixel_total : 673 time to create 1 rle with old method : 0.0009210109710693359 length of segment : 34 time for calcul the mask position with numpy : 3.814697265625e-05 nb_pixel_total : 509 time to create 1 rle with old method : 0.0007970333099365234 length of segment : 20 time for calcul the mask position with numpy : 3.147125244140625e-05 nb_pixel_total : 77 time to create 1 rle with old method : 0.00018477439880371094 length of segment : 10 time for calcul the mask position with numpy : 3.4332275390625e-05 nb_pixel_total : 231 time to create 1 rle with old method : 0.00033736228942871094 length of segment : 24 Processing 1 images image shape: (280, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 148.83047 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 4 time for calcul the mask position with numpy : 5.841255187988281e-05 nb_pixel_total : 232 time to create 1 rle with old method : 0.00041866302490234375 length of segment : 42 time for calcul the mask position with numpy : 3.361701965332031e-05 nb_pixel_total : 141 time to create 1 rle with old method : 0.0002319812774658203 length of segment : 15 time for calcul the mask position with numpy : 4.220008850097656e-05 nb_pixel_total : 287 time to create 1 rle with old method : 0.0005331039428710938 length of segment : 22 time for calcul the mask position with numpy : 3.123283386230469e-05 nb_pixel_total : 144 time to create 1 rle with old method : 0.0002415180206298828 length of segment : 15 Processing 1 images image shape: (280, 320, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 142.91250 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 3 time for calcul the mask position with numpy : 6.175041198730469e-05 nb_pixel_total : 153 time to create 1 rle with old method : 0.0003483295440673828 length of segment : 44 time for calcul the mask position with numpy : 0.00043511390686035156 nb_pixel_total : 39071 time to create 1 rle with old method : 0.04536080360412598 length of segment : 243 time for calcul the mask position with numpy : 3.7670135498046875e-05 nb_pixel_total : 19 time to create 1 rle with old method : 6.198883056640625e-05 length of segment : 4 NEW PHOTO pour l'instant on ne peut pas sauvegarder la photo dans les tile Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -119.64922 max: 149.40078 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 4 time for calcul the mask position with numpy : 4.0531158447265625e-05 nb_pixel_total : 439 time to create 1 rle with old method : 0.0006070137023925781 length of segment : 37 time for calcul the mask position with numpy : 4.0531158447265625e-05 nb_pixel_total : 635 time to create 1 rle with old method : 0.0009598731994628906 length of segment : 56 time for calcul the mask position with numpy : 3.147125244140625e-05 nb_pixel_total : 72 time to create 1 rle with old method : 0.00011467933654785156 length of segment : 18 time for calcul the mask position with numpy : 4.100799560546875e-05 nb_pixel_total : 676 time to create 1 rle with old method : 0.0009932518005371094 length of segment : 62 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -122.17656 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 5 time for calcul the mask position with numpy : 7.200241088867188e-05 nb_pixel_total : 2509 time to create 1 rle with old method : 0.003053426742553711 length of segment : 50 time for calcul the mask position with numpy : 9.179115295410156e-05 nb_pixel_total : 2631 time to create 1 rle with old method : 0.003329038619995117 length of segment : 53 time for calcul the mask position with numpy : 4.887580871582031e-05 nb_pixel_total : 970 time to create 1 rle with old method : 0.0012385845184326172 length of segment : 52 time for calcul the mask position with numpy : 4.220008850097656e-05 nb_pixel_total : 702 time to create 1 rle with old method : 0.0009829998016357422 length of segment : 50 time for calcul the mask position with numpy : 8.559226989746094e-05 nb_pixel_total : 2501 time to create 1 rle with old method : 0.0033948421478271484 length of segment : 61 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -121.71953 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 6 time for calcul the mask position with numpy : 5.888938903808594e-05 nb_pixel_total : 1338 time to create 1 rle with old method : 0.0018985271453857422 length of segment : 26 time for calcul the mask position with numpy : 0.00012946128845214844 nb_pixel_total : 2364 time to create 1 rle with old method : 0.0030825138092041016 length of segment : 69 time for calcul the mask position with numpy : 0.00012993812561035156 nb_pixel_total : 5972 time to create 1 rle with old method : 0.0071790218353271484 length of segment : 105 time for calcul the mask position with numpy : 0.00024509429931640625 nb_pixel_total : 5442 time to create 1 rle with old method : 0.0070536136627197266 length of segment : 178 time for calcul the mask position with numpy : 0.00024056434631347656 nb_pixel_total : 3296 time to create 1 rle with old method : 0.004185199737548828 length of segment : 107 time for calcul the mask position with numpy : 0.0003058910369873047 nb_pixel_total : 1614 time to create 1 rle with old method : 0.0020220279693603516 length of segment : 60 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.23516 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 7 time for calcul the mask position with numpy : 4.029273986816406e-05 nb_pixel_total : 291 time to create 1 rle with old method : 0.00046539306640625 length of segment : 20 time for calcul the mask position with numpy : 0.0001494884490966797 nb_pixel_total : 9746 time to create 1 rle with old method : 0.011793851852416992 length of segment : 79 time for calcul the mask position with numpy : 5.030632019042969e-05 nb_pixel_total : 1027 time to create 1 rle with old method : 0.0013356208801269531 length of segment : 41 time for calcul the mask position with numpy : 3.600120544433594e-05 nb_pixel_total : 319 time to create 1 rle with old method : 0.00046253204345703125 length of segment : 22 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 1460 time to create 1 rle with old method : 0.002115011215209961 length of segment : 43 time for calcul the mask position with numpy : 5.1021575927734375e-05 nb_pixel_total : 822 time to create 1 rle with old method : 0.0010869503021240234 length of segment : 40 time for calcul the mask position with numpy : 5.7697296142578125e-05 nb_pixel_total : 1575 time to create 1 rle with old method : 0.0022788047790527344 length of segment : 36 Processing 1 images image shape: (400, 320, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 128.43984 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 4 time for calcul the mask position with numpy : 4.029273986816406e-05 nb_pixel_total : 471 time to create 1 rle with old method : 0.0006799697875976562 length of segment : 18 time for calcul the mask position with numpy : 4.649162292480469e-05 nb_pixel_total : 1156 time to create 1 rle with old method : 0.0014488697052001953 length of segment : 76 time for calcul the mask position with numpy : 5.221366882324219e-05 nb_pixel_total : 1242 time to create 1 rle with old method : 0.0016269683837890625 length of segment : 94 time for calcul the mask position with numpy : 6.794929504394531e-05 nb_pixel_total : 1540 time to create 1 rle with old method : 0.0020737648010253906 length of segment : 40 Processing 1 images image shape: (400, 400, 3) min: 4.00000 max: 183.00000 molded_images shape: (1, 640, 640, 3) min: -99.57891 max: 66.88125 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 0 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -121.09453 max: 140.65859 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 7 time for calcul the mask position with numpy : 4.696846008300781e-05 nb_pixel_total : 433 time to create 1 rle with old method : 0.0006847381591796875 length of segment : 31 time for calcul the mask position with numpy : 0.00037217140197753906 nb_pixel_total : 27099 time to create 1 rle with old method : 0.031881093978881836 length of segment : 246 time for calcul the mask position with numpy : 4.3392181396484375e-05 nb_pixel_total : 302 time to create 1 rle with old method : 0.0005180835723876953 length of segment : 15 time for calcul the mask position with numpy : 4.315376281738281e-05 nb_pixel_total : 614 time to create 1 rle with old method : 0.0008721351623535156 length of segment : 44 time for calcul the mask position with numpy : 5.078315734863281e-05 nb_pixel_total : 312 time to create 1 rle with old method : 0.0006494522094726562 length of segment : 20 time for calcul the mask position with numpy : 3.218650817871094e-05 nb_pixel_total : 280 time to create 1 rle with old method : 0.00038123130798339844 length of segment : 17 time for calcul the mask position with numpy : 4.100799560546875e-05 nb_pixel_total : 482 time to create 1 rle with old method : 0.000644683837890625 length of segment : 39 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -117.29375 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 9 time for calcul the mask position with numpy : 4.8160552978515625e-05 nb_pixel_total : 134 time to create 1 rle with old method : 0.00023102760314941406 length of segment : 19 time for calcul the mask position with numpy : 5.459785461425781e-05 nb_pixel_total : 511 time to create 1 rle with old method : 0.0007402896881103516 length of segment : 30 time for calcul the mask position with numpy : 0.0002899169921875 nb_pixel_total : 9113 time to create 1 rle with old method : 0.011349678039550781 length of segment : 281 time for calcul the mask position with numpy : 5.8650970458984375e-05 nb_pixel_total : 1 time to create 1 rle with old method : 3.147125244140625e-05 length of segment : 1 time for calcul the mask position with numpy : 5.2928924560546875e-05 nb_pixel_total : 385 time to create 1 rle with old method : 0.0008108615875244141 length of segment : 20 time for calcul the mask position with numpy : 6.031990051269531e-05 nb_pixel_total : 2013 time to create 1 rle with old method : 0.0025777816772460938 length of segment : 55 time for calcul the mask position with numpy : 3.910064697265625e-05 nb_pixel_total : 679 time to create 1 rle with old method : 0.0008912086486816406 length of segment : 29 time for calcul the mask position with numpy : 3.0517578125e-05 nb_pixel_total : 107 time to create 1 rle with old method : 0.0001804828643798828 length of segment : 13 length of segment : 0 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -118.61406 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 6 time for calcul the mask position with numpy : 0.0002448558807373047 nb_pixel_total : 14769 time to create 1 rle with old method : 0.025468826293945312 length of segment : 129 time for calcul the mask position with numpy : 8.916854858398438e-05 nb_pixel_total : 2091 time to create 1 rle with old method : 0.0025725364685058594 length of segment : 133 time for calcul the mask position with numpy : 4.6253204345703125e-05 nb_pixel_total : 911 time to create 1 rle with old method : 0.0011534690856933594 length of segment : 44 time for calcul the mask position with numpy : 4.482269287109375e-05 nb_pixel_total : 1236 time to create 1 rle with old method : 0.0015740394592285156 length of segment : 39 time for calcul the mask position with numpy : 3.0040740966796875e-05 nb_pixel_total : 159 time to create 1 rle with old method : 0.00029087066650390625 length of segment : 7 time for calcul the mask position with numpy : 4.5299530029296875e-05 nb_pixel_total : 1331 time to create 1 rle with old method : 0.0017516613006591797 length of segment : 41 Processing 1 images image shape: (400, 320, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 134.29531 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 6 time for calcul the mask position with numpy : 6.771087646484375e-05 nb_pixel_total : 1830 time to create 1 rle with old method : 0.0022706985473632812 length of segment : 81 time for calcul the mask position with numpy : 3.933906555175781e-05 nb_pixel_total : 652 time to create 1 rle with old method : 0.0008552074432373047 length of segment : 43 time for calcul the mask position with numpy : 3.886222839355469e-05 nb_pixel_total : 688 time to create 1 rle with old method : 0.0009086132049560547 length of segment : 44 time for calcul the mask position with numpy : 5.316734313964844e-05 nb_pixel_total : 1425 time to create 1 rle with old method : 0.0017762184143066406 length of segment : 69 time for calcul the mask position with numpy : 0.00016188621520996094 nb_pixel_total : 3917 time to create 1 rle with old method : 0.004895210266113281 length of segment : 203 time for calcul the mask position with numpy : 0.0001933574676513672 nb_pixel_total : 5871 time to create 1 rle with old method : 0.007155418395996094 length of segment : 249 Processing 1 images image shape: (280, 400, 3) min: 4.00000 max: 168.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 52.65859 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 0 Processing 1 images image shape: (280, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 138.04141 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 19 time for calcul the mask position with numpy : 4.315376281738281e-05 nb_pixel_total : 242 time to create 1 rle with old method : 0.00037288665771484375 length of segment : 14 time for calcul the mask position with numpy : 7.343292236328125e-05 nb_pixel_total : 3223 time to create 1 rle with old method : 0.0041544437408447266 length of segment : 54 time for calcul the mask position with numpy : 3.981590270996094e-05 nb_pixel_total : 559 time to create 1 rle with old method : 0.0007829666137695312 length of segment : 24 time for calcul the mask position with numpy : 4.863739013671875e-05 nb_pixel_total : 991 time to create 1 rle with old method : 0.001352071762084961 length of segment : 34 time for calcul the mask position with numpy : 3.0994415283203125e-05 nb_pixel_total : 155 time to create 1 rle with old method : 0.0002613067626953125 length of segment : 14 time for calcul the mask position with numpy : 3.62396240234375e-05 nb_pixel_total : 511 time to create 1 rle with old method : 0.0006768703460693359 length of segment : 31 time for calcul the mask position with numpy : 9.179115295410156e-05 nb_pixel_total : 3168 time to create 1 rle with old method : 0.0041103363037109375 length of segment : 96 time for calcul the mask position with numpy : 4.076957702636719e-05 nb_pixel_total : 258 time to create 1 rle with old method : 0.0003681182861328125 length of segment : 20 time for calcul the mask position with numpy : 3.266334533691406e-05 nb_pixel_total : 102 time to create 1 rle with old method : 0.0001735687255859375 length of segment : 14 time for calcul the mask position with numpy : 3.743171691894531e-05 nb_pixel_total : 220 time to create 1 rle with old method : 0.00031185150146484375 length of segment : 39 time for calcul the mask position with numpy : 8.654594421386719e-05 nb_pixel_total : 3392 time to create 1 rle with old method : 0.004150867462158203 length of segment : 107 time for calcul the mask position with numpy : 3.0994415283203125e-05 nb_pixel_total : 94 time to create 1 rle with old method : 0.00014209747314453125 length of segment : 12 time for calcul the mask position with numpy : 2.8848648071289062e-05 nb_pixel_total : 113 time to create 1 rle with old method : 0.0001804828643798828 length of segment : 15 time for calcul the mask position with numpy : 2.8371810913085938e-05 nb_pixel_total : 64 time to create 1 rle with old method : 0.00012111663818359375 length of segment : 10 time for calcul the mask position with numpy : 3.838539123535156e-05 nb_pixel_total : 590 time to create 1 rle with old method : 0.0007565021514892578 length of segment : 30 time for calcul the mask position with numpy : 3.2901763916015625e-05 nb_pixel_total : 625 time to create 1 rle with old method : 0.0007839202880859375 length of segment : 27 time for calcul the mask position with numpy : 2.8133392333984375e-05 nb_pixel_total : 71 time to create 1 rle with old method : 0.00013399124145507812 length of segment : 10 time for calcul the mask position with numpy : 6.29425048828125e-05 nb_pixel_total : 750 time to create 1 rle with old method : 0.0009739398956298828 length of segment : 120 time for calcul the mask position with numpy : 6.413459777832031e-05 nb_pixel_total : 924 time to create 1 rle with old method : 0.0011591911315917969 length of segment : 133 Processing 1 images image shape: (280, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 136.51797 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 10 time for calcul the mask position with numpy : 3.981590270996094e-05 nb_pixel_total : 197 time to create 1 rle with old method : 0.00031256675720214844 length of segment : 13 time for calcul the mask position with numpy : 2.9325485229492188e-05 nb_pixel_total : 148 time to create 1 rle with old method : 0.0002384185791015625 length of segment : 11 time for calcul the mask position with numpy : 2.9087066650390625e-05 nb_pixel_total : 82 time to create 1 rle with old method : 0.00014019012451171875 length of segment : 14 time for calcul the mask position with numpy : 3.170967102050781e-05 nb_pixel_total : 220 time to create 1 rle with old method : 0.0003228187561035156 length of segment : 18 time for calcul the mask position with numpy : 3.123283386230469e-05 nb_pixel_total : 199 time to create 1 rle with old method : 0.0002760887145996094 length of segment : 20 time for calcul the mask position with numpy : 2.86102294921875e-05 nb_pixel_total : 72 time to create 1 rle with old method : 0.00012731552124023438 length of segment : 11 time for calcul the mask position with numpy : 3.147125244140625e-05 nb_pixel_total : 242 time to create 1 rle with old method : 0.000396728515625 length of segment : 24 time for calcul the mask position with numpy : 3.7670135498046875e-05 nb_pixel_total : 614 time to create 1 rle with old method : 0.0008053779602050781 length of segment : 33 time for calcul the mask position with numpy : 2.7418136596679688e-05 nb_pixel_total : 70 time to create 1 rle with old method : 0.00012803077697753906 length of segment : 10 time for calcul the mask position with numpy : 3.24249267578125e-05 nb_pixel_total : 309 time to create 1 rle with old method : 0.0004572868347167969 length of segment : 14 Processing 1 images image shape: (280, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 146.43594 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 4 time for calcul the mask position with numpy : 7.295608520507812e-05 nb_pixel_total : 1917 time to create 1 rle with old method : 0.0023784637451171875 length of segment : 94 time for calcul the mask position with numpy : 0.00015115737915039062 nb_pixel_total : 1361 time to create 1 rle with old method : 0.0017006397247314453 length of segment : 101 time for calcul the mask position with numpy : 0.00026726722717285156 nb_pixel_total : 8604 time to create 1 rle with old method : 0.010869979858398438 length of segment : 249 time for calcul the mask position with numpy : 3.695487976074219e-05 nb_pixel_total : 142 time to create 1 rle with old method : 0.00022149085998535156 length of segment : 18 Processing 1 images image shape: (280, 320, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 140.72500 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 3 time for calcul the mask position with numpy : 6.532669067382812e-05 nb_pixel_total : 328 time to create 1 rle with old method : 0.0005588531494140625 length of segment : 70 time for calcul the mask position with numpy : 0.0001838207244873047 nb_pixel_total : 10021 time to create 1 rle with old method : 0.011943340301513672 length of segment : 272 time for calcul the mask position with numpy : 0.0004315376281738281 nb_pixel_total : 37389 time to create 1 rle with old method : 0.04326629638671875 length of segment : 296 Detection mask done ! Trying to reset tf kernel 2839379 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 236 tf kernel not reseted sub process len(results) : 193 len(list_Values) 193 None max_time_sub_proc : 3600 parent process len(results) : 0 len(list_Values) 193 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 : 5525 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Catched exception ! Connect or reconnect ! Number saved : None batch 1 Loaded 193 chid ids of type : 4228 Number RLEs to save : 10903 save missing photos in datou_result : time spend for datou_step_exec : 22.558417081832886 time spend to save output : 1.09940767288208 total time spend for step 1 : 23.657824754714966 step2:brightness Sat Mar 1 19:20:54 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 inside step calcul brightness treat image : temp/1740853230_2838843_1340418661_9cbc89ec8be6e94ba855c6c8f8436416.jpg treat image : temp/1740853230_2838843_1340418639_ab143d2b77b6a610d6975050037498a0.jpg Inside saveOutput : final : False verbose : 0 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 2 time used for this insertion : 0.013257265090942383 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 2 time used for this insertion : 0.4536280632019043 save missing photos in datou_result : time spend for datou_step_exec : 0.7843360900878906 time spend to save output : 0.4711177349090576 total time spend for step 2 : 1.2554538249969482 step3:blur_detection Sat Mar 1 19:20:55 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 inside step blur_detection methode: ratio et variance treat image : temp/1740853230_2838843_1340418661_9cbc89ec8be6e94ba855c6c8f8436416.jpg resize: (1080, 1920) 1340418661 -7.531012429400596 treat image : temp/1740853230_2838843_1340418639_ab143d2b77b6a610d6975050037498a0.jpg resize: (1080, 1920) 1340418639 -7.494508055384501 Inside saveOutput : final : False verbose : 0 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 2 time used for this insertion : 0.013915061950683594 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 2 time used for this insertion : 0.012403726577758789 save missing photos in datou_result : time spend for datou_step_exec : 1.807178258895874 time spend to save output : 0.03158855438232422 total time spend for step 3 : 1.8387668132781982 step4:rle_unique_nms_with_priority Sat Mar 1 19:20:57 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 batch 1 Loaded 193 chid ids of type : 4228 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++nb_obj : 100 nb_hashtags : 6 time to prepare the origin masks : 1.0606987476348877 time for calcul the mask position with numpy : 0.1823418140411377 nb_pixel_total : 1800864 time to create 1 rle with new method : 0.0921480655670166 time for calcul the mask position with numpy : 0.007928133010864258 nb_pixel_total : 1887 time to create 1 rle with old method : 0.0020525455474853516 time for calcul the mask position with numpy : 0.008240461349487305 nb_pixel_total : 821 time to create 1 rle with old method : 0.0008318424224853516 time for calcul the mask position with numpy : 0.00812840461730957 nb_pixel_total : 47 time to create 1 rle with old method : 0.00010442733764648438 time for calcul the mask position with numpy : 0.008233308792114258 nb_pixel_total : 42 time to create 1 rle with old method : 8.535385131835938e-05 time for calcul the mask position with numpy : 0.008287429809570312 nb_pixel_total : 25 time to create 1 rle with old method : 3.838539123535156e-05 time for calcul the mask position with numpy : 0.008362770080566406 nb_pixel_total : 997 time to create 1 rle with old method : 0.001130819320678711 time for calcul the mask position with numpy : 0.008211851119995117 nb_pixel_total : 149 time to create 1 rle with old method : 0.00023221969604492188 time for calcul the mask position with numpy : 0.008114099502563477 nb_pixel_total : 105 time to create 1 rle with old method : 0.0001342296600341797 time for calcul the mask position with numpy : 0.00809931755065918 nb_pixel_total : 339 time to create 1 rle with old method : 0.00034689903259277344 time for calcul the mask position with numpy : 0.008099794387817383 nb_pixel_total : 701 time to create 1 rle with old method : 0.0008440017700195312 time for calcul the mask position with numpy : 0.00827932357788086 nb_pixel_total : 186 time to create 1 rle with old method : 0.0002651214599609375 time for calcul the mask position with numpy : 0.008108139038085938 nb_pixel_total : 2441 time to create 1 rle with old method : 0.0026433467864990234 time for calcul the mask position with numpy : 0.008278369903564453 nb_pixel_total : 1175 time to create 1 rle with old method : 0.0012962818145751953 time for calcul the mask position with numpy : 0.008188486099243164 nb_pixel_total : 626 time to create 1 rle with old method : 0.0006504058837890625 time for calcul the mask position with numpy : 0.008002042770385742 nb_pixel_total : 773 time to create 1 rle with old method : 0.0007998943328857422 time for calcul the mask position with numpy : 0.008199930191040039 nb_pixel_total : 516 time to create 1 rle with old method : 0.0005197525024414062 time for calcul the mask position with numpy : 0.007950305938720703 nb_pixel_total : 277 time to create 1 rle with old method : 0.0002887248992919922 time for calcul the mask position with numpy : 0.008152246475219727 nb_pixel_total : 407 time to create 1 rle with old method : 0.00046324729919433594 time for calcul the mask position with numpy : 0.008147239685058594 nb_pixel_total : 403 time to create 1 rle with old method : 0.0004649162292480469 time for calcul the mask position with numpy : 0.00819849967956543 nb_pixel_total : 1164 time to create 1 rle with old method : 0.0012750625610351562 time for calcul the mask position with numpy : 0.007951021194458008 nb_pixel_total : 10504 time to create 1 rle with old method : 0.010909318923950195 time for calcul the mask position with numpy : 0.0077550411224365234 nb_pixel_total : 707 time to create 1 rle with old method : 0.0007233619689941406 time for calcul the mask position with numpy : 0.00753474235534668 nb_pixel_total : 117 time to create 1 rle with old method : 0.00015282630920410156 time for calcul the mask position with numpy : 0.007627010345458984 nb_pixel_total : 1604 time to create 1 rle with old method : 0.0017650127410888672 time for calcul the mask position with numpy : 0.0076618194580078125 nb_pixel_total : 484 time to create 1 rle with old method : 0.0005061626434326172 time for calcul the mask position with numpy : 0.007693052291870117 nb_pixel_total : 1267 time to create 1 rle with old method : 0.00131988525390625 time for calcul the mask position with numpy : 0.007661581039428711 nb_pixel_total : 1852 time to create 1 rle with old method : 0.0018925666809082031 time for calcul the mask position with numpy : 0.0078084468841552734 nb_pixel_total : 15349 time to create 1 rle with old method : 0.015556812286376953 time for calcul the mask position with numpy : 0.0074846744537353516 nb_pixel_total : 1146 time to create 1 rle with old method : 0.001466989517211914 time for calcul the mask position with numpy : 0.007958650588989258 nb_pixel_total : 22521 time to create 1 rle with old method : 0.02449202537536621 time for calcul the mask position with numpy : 0.00818943977355957 nb_pixel_total : 565 time to create 1 rle with old method : 0.0006184577941894531 time for calcul the mask position with numpy : 0.008119583129882812 nb_pixel_total : 407 time to create 1 rle with old method : 0.00044918060302734375 time for calcul the mask position with numpy : 0.00824737548828125 nb_pixel_total : 144 time to create 1 rle with old method : 0.00017333030700683594 time for calcul the mask position with numpy : 0.008094549179077148 nb_pixel_total : 145 time to create 1 rle with old method : 0.00017261505126953125 time for calcul the mask position with numpy : 0.008070707321166992 nb_pixel_total : 10824 time to create 1 rle with old method : 0.011734485626220703 time for calcul the mask position with numpy : 0.007911920547485352 nb_pixel_total : 43 time to create 1 rle with old method : 7.414817810058594e-05 time for calcul the mask position with numpy : 0.00786900520324707 nb_pixel_total : 620 time to create 1 rle with old method : 0.0006976127624511719 time for calcul the mask position with numpy : 0.007741451263427734 nb_pixel_total : 6570 time to create 1 rle with old method : 0.0071659088134765625 time for calcul the mask position with numpy : 0.0076830387115478516 nb_pixel_total : 188 time to create 1 rle with old method : 0.0002238750457763672 time for calcul the mask position with numpy : 0.007645130157470703 nb_pixel_total : 942 time to create 1 rle with old method : 0.0009710788726806641 time for calcul the mask position with numpy : 0.007851600646972656 nb_pixel_total : 751 time to create 1 rle with old method : 0.0009980201721191406 time for calcul the mask position with numpy : 0.0075075626373291016 nb_pixel_total : 2364 time to create 1 rle with old method : 0.002398967742919922 time for calcul the mask position with numpy : 0.0077817440032958984 nb_pixel_total : 5885 time to create 1 rle with old method : 0.006179094314575195 time for calcul the mask position with numpy : 0.007499217987060547 nb_pixel_total : 2093 time to create 1 rle with old method : 0.002163410186767578 time for calcul the mask position with numpy : 0.007896900177001953 nb_pixel_total : 322 time to create 1 rle with old method : 0.0003609657287597656 time for calcul the mask position with numpy : 0.00765538215637207 nb_pixel_total : 784 time to create 1 rle with old method : 0.0008614063262939453 time for calcul the mask position with numpy : 0.007960081100463867 nb_pixel_total : 114 time to create 1 rle with old method : 0.00016641616821289062 time for calcul the mask position with numpy : 0.007758378982543945 nb_pixel_total : 395 time to create 1 rle with old method : 0.0004851818084716797 time for calcul the mask position with numpy : 0.007988691329956055 nb_pixel_total : 433 time to create 1 rle with old method : 0.0005125999450683594 time for calcul the mask position with numpy : 0.00800180435180664 nb_pixel_total : 46 time to create 1 rle with old method : 7.963180541992188e-05 time for calcul the mask position with numpy : 0.008021354675292969 nb_pixel_total : 311 time to create 1 rle with old method : 0.00036144256591796875 time for calcul the mask position with numpy : 0.007817983627319336 nb_pixel_total : 433 time to create 1 rle with old method : 0.00046133995056152344 time for calcul the mask position with numpy : 0.007939815521240234 nb_pixel_total : 210 time to create 1 rle with old method : 0.0002276897430419922 time for calcul the mask position with numpy : 0.008018016815185547 nb_pixel_total : 202 time to create 1 rle with old method : 0.00021314620971679688 time for calcul the mask position with numpy : 0.008025884628295898 nb_pixel_total : 326 time to create 1 rle with old method : 0.00035953521728515625 time for calcul the mask position with numpy : 0.00803375244140625 nb_pixel_total : 248 time to create 1 rle with old method : 0.0002872943878173828 time for calcul the mask position with numpy : 0.008030414581298828 nb_pixel_total : 838 time to create 1 rle with old method : 0.0009496212005615234 time for calcul the mask position with numpy : 0.00804448127746582 nb_pixel_total : 206 time to create 1 rle with old method : 0.0002491474151611328 time for calcul the mask position with numpy : 0.008127689361572266 nb_pixel_total : 243 time to create 1 rle with old method : 0.0002830028533935547 time for calcul the mask position with numpy : 0.00812387466430664 nb_pixel_total : 134 time to create 1 rle with old method : 0.00016808509826660156 time for calcul the mask position with numpy : 0.008556604385375977 nb_pixel_total : 106345 time to create 1 rle with old method : 0.11083793640136719 time for calcul the mask position with numpy : 0.008253097534179688 nb_pixel_total : 7 time to create 1 rle with old method : 2.4318695068359375e-05 time for calcul the mask position with numpy : 0.008156538009643555 nb_pixel_total : 77 time to create 1 rle with old method : 9.441375732421875e-05 time for calcul the mask position with numpy : 0.008315086364746094 nb_pixel_total : 64 time to create 1 rle with old method : 8.320808410644531e-05 time for calcul the mask position with numpy : 0.008142948150634766 nb_pixel_total : 225 time to create 1 rle with old method : 0.00025534629821777344 time for calcul the mask position with numpy : 0.008003950119018555 nb_pixel_total : 613 time to create 1 rle with old method : 0.0006191730499267578 time for calcul the mask position with numpy : 0.007932662963867188 nb_pixel_total : 153 time to create 1 rle with old method : 0.0002143383026123047 time for calcul the mask position with numpy : 0.008052825927734375 nb_pixel_total : 200 time to create 1 rle with old method : 0.0002372264862060547 time for calcul the mask position with numpy : 0.008135557174682617 nb_pixel_total : 39071 time to create 1 rle with old method : 0.04028129577636719 time for calcul the mask position with numpy : 0.007956743240356445 nb_pixel_total : 213 time to create 1 rle with old method : 0.00023865699768066406 time for calcul the mask position with numpy : 0.007967233657836914 nb_pixel_total : 137 time to create 1 rle with old method : 0.00016450881958007812 time for calcul the mask position with numpy : 0.007829904556274414 nb_pixel_total : 3747 time to create 1 rle with old method : 0.004036903381347656 time for calcul the mask position with numpy : 0.0076673030853271484 nb_pixel_total : 509 time to create 1 rle with old method : 0.0005366802215576172 time for calcul the mask position with numpy : 0.00765538215637207 nb_pixel_total : 97 time to create 1 rle with old method : 0.00011539459228515625 time for calcul the mask position with numpy : 0.0077056884765625 nb_pixel_total : 995 time to create 1 rle with old method : 0.0010609626770019531 time for calcul the mask position with numpy : 0.007883787155151367 nb_pixel_total : 11 time to create 1 rle with old method : 3.9577484130859375e-05 time for calcul the mask position with numpy : 0.007940292358398438 nb_pixel_total : 121 time to create 1 rle with old method : 0.00017142295837402344 time for calcul the mask position with numpy : 0.008033514022827148 nb_pixel_total : 3742 time to create 1 rle with old method : 0.004124164581298828 time for calcul the mask position with numpy : 0.00809168815612793 nb_pixel_total : 625 time to create 1 rle with old method : 0.0007109642028808594 time for calcul the mask position with numpy : 0.008126258850097656 nb_pixel_total : 352 time to create 1 rle with old method : 0.00038433074951171875 time for calcul the mask position with numpy : 0.00820612907409668 nb_pixel_total : 2 time to create 1 rle with old method : 1.1920928955078125e-05 time for calcul the mask position with numpy : 0.008108854293823242 nb_pixel_total : 516 time to create 1 rle with old method : 0.0005674362182617188 time for calcul the mask position with numpy : 0.007854700088500977 nb_pixel_total : 12 time to create 1 rle with old method : 2.6702880859375e-05 time for calcul the mask position with numpy : 0.007967710494995117 nb_pixel_total : 2200 time to create 1 rle with old method : 0.0023365020751953125 time for calcul the mask position with numpy : 0.007955551147460938 nb_pixel_total : 118 time to create 1 rle with old method : 0.00013971328735351562 time for calcul the mask position with numpy : 0.008065938949584961 nb_pixel_total : 1110 time to create 1 rle with old method : 0.0012176036834716797 time for calcul the mask position with numpy : 0.007864713668823242 nb_pixel_total : 108 time to create 1 rle with old method : 0.0001373291015625 time for calcul the mask position with numpy : 0.007867574691772461 nb_pixel_total : 141 time to create 1 rle with old method : 0.00016379356384277344 time for calcul the mask position with numpy : 0.008083105087280273 nb_pixel_total : 10 time to create 1 rle with old method : 2.956390380859375e-05 time for calcul the mask position with numpy : 0.00810551643371582 nb_pixel_total : 1146 time to create 1 rle with old method : 0.0012807846069335938 time for calcul the mask position with numpy : 0.007888555526733398 nb_pixel_total : 131 time to create 1 rle with old method : 0.00016689300537109375 time for calcul the mask position with numpy : 0.007788181304931641 nb_pixel_total : 673 time to create 1 rle with old method : 0.0007708072662353516 time for calcul the mask position with numpy : 0.008003473281860352 nb_pixel_total : 232 time to create 1 rle with old method : 0.0003044605255126953 time for calcul the mask position with numpy : 0.007741212844848633 nb_pixel_total : 19 time to create 1 rle with old method : 2.8371810913085938e-05 time for calcul the mask position with numpy : 0.009072303771972656 nb_pixel_total : 293 time to create 1 rle with old method : 0.0002968311309814453 time for calcul the mask position with numpy : 0.00787806510925293 nb_pixel_total : 2446 time to create 1 rle with old method : 0.0026292800903320312 time for calcul the mask position with numpy : 0.007704973220825195 nb_pixel_total : 201 time to create 1 rle with old method : 0.00021219253540039062 time for calcul the mask position with numpy : 0.007483243942260742 nb_pixel_total : 203 time to create 1 rle with old method : 0.00024080276489257812 time for calcul the mask position with numpy : 0.007632017135620117 nb_pixel_total : 287 time to create 1 rle with old method : 0.00032782554626464844 time for calcul the mask position with numpy : 0.008042097091674805 nb_pixel_total : 166 time to create 1 rle with old method : 0.0001995563507080078 create new chi : 1.373082160949707 after preparing all the mask , begin to delete the rle from the crop_hashtag_id => VR 28-11-20 : il faut déplacer cela apres le save_crop_hashtag_ids_obj de la ligne 9514 ! we have 0 chi objets contains the rles time to delete rle : 0.010044336318969727 batch 1 Loaded 101 chid ids of type : 4230 Number RLEs to save : 10364 TO DO : save crop sub photo not yet done ! save time : 0.6445343494415283 nb_obj : 89 nb_hashtags : 5 time to prepare the origin masks : 1.8274433612823486 time for calcul the mask position with numpy : 0.031180381774902344 nb_pixel_total : 1896296 time to create 1 rle with new method : 0.05452466011047363 time for calcul the mask position with numpy : 0.006097078323364258 nb_pixel_total : 998 time to create 1 rle with old method : 0.0012700557708740234 time for calcul the mask position with numpy : 0.005763053894042969 nb_pixel_total : 1242 time to create 1 rle with old method : 0.0012941360473632812 time for calcul the mask position with numpy : 0.005645751953125 nb_pixel_total : 2364 time to create 1 rle with old method : 0.002698183059692383 time for calcul the mask position with numpy : 0.005713939666748047 nb_pixel_total : 78 time to create 1 rle with old method : 0.00011157989501953125 time for calcul the mask position with numpy : 0.005788326263427734 nb_pixel_total : 5442 time to create 1 rle with old method : 0.0058171749114990234 time for calcul the mask position with numpy : 0.005521297454833984 nb_pixel_total : 72 time to create 1 rle with old method : 0.00010061264038085938 time for calcul the mask position with numpy : 0.005765199661254883 nb_pixel_total : 702 time to create 1 rle with old method : 0.0007960796356201172 time for calcul the mask position with numpy : 0.00550532341003418 nb_pixel_total : 439 time to create 1 rle with old method : 0.000476837158203125 time for calcul the mask position with numpy : 0.005669355392456055 nb_pixel_total : 99 time to create 1 rle with old method : 0.0001659393310546875 time for calcul the mask position with numpy : 0.005951881408691406 nb_pixel_total : 635 time to create 1 rle with old method : 0.0006995201110839844 time for calcul the mask position with numpy : 0.005913496017456055 nb_pixel_total : 211 time to create 1 rle with old method : 0.0003147125244140625 time for calcul the mask position with numpy : 0.0057146549224853516 nb_pixel_total : 2509 time to create 1 rle with old method : 0.002832174301147461 time for calcul the mask position with numpy : 0.00566864013671875 nb_pixel_total : 179 time to create 1 rle with old method : 0.0002562999725341797 time for calcul the mask position with numpy : 0.005595684051513672 nb_pixel_total : 1156 time to create 1 rle with old method : 0.0012166500091552734 time for calcul the mask position with numpy : 0.0055391788482666016 nb_pixel_total : 970 time to create 1 rle with old method : 0.0010197162628173828 time for calcul the mask position with numpy : 0.005692720413208008 nb_pixel_total : 291 time to create 1 rle with old method : 0.00033473968505859375 time for calcul the mask position with numpy : 0.005576610565185547 nb_pixel_total : 1338 time to create 1 rle with old method : 0.0014424324035644531 time for calcul the mask position with numpy : 0.005529642105102539 nb_pixel_total : 5972 time to create 1 rle with old method : 0.006114959716796875 time for calcul the mask position with numpy : 0.0055048465728759766 nb_pixel_total : 1027 time to create 1 rle with old method : 0.0010764598846435547 time for calcul the mask position with numpy : 0.00549769401550293 nb_pixel_total : 9746 time to create 1 rle with old method : 0.009879112243652344 time for calcul the mask position with numpy : 0.005620002746582031 nb_pixel_total : 1540 time to create 1 rle with old method : 0.0016052722930908203 time for calcul the mask position with numpy : 0.005519390106201172 nb_pixel_total : 19 time to create 1 rle with old method : 4.76837158203125e-05 time for calcul the mask position with numpy : 0.005952596664428711 nb_pixel_total : 319 time to create 1 rle with old method : 0.0003428459167480469 time for calcul the mask position with numpy : 0.005712747573852539 nb_pixel_total : 225 time to create 1 rle with old method : 0.000354766845703125 time for calcul the mask position with numpy : 0.005777120590209961 nb_pixel_total : 1460 time to create 1 rle with old method : 0.0017371177673339844 time for calcul the mask position with numpy : 0.00580143928527832 nb_pixel_total : 471 time to create 1 rle with old method : 0.0005242824554443359 time for calcul the mask position with numpy : 0.007275104522705078 nb_pixel_total : 2013 time to create 1 rle with old method : 0.0022606849670410156 time for calcul the mask position with numpy : 0.00980687141418457 nb_pixel_total : 14769 time to create 1 rle with old method : 0.016497373580932617 time for calcul the mask position with numpy : 0.009776115417480469 nb_pixel_total : 485 time to create 1 rle with old method : 0.0005228519439697266 time for calcul the mask position with numpy : 0.00960993766784668 nb_pixel_total : 8700 time to create 1 rle with old method : 0.009849071502685547 time for calcul the mask position with numpy : 0.009770393371582031 nb_pixel_total : 911 time to create 1 rle with old method : 0.0011281967163085938 time for calcul the mask position with numpy : 0.00968313217163086 nb_pixel_total : 385 time to create 1 rle with old method : 0.0004260540008544922 time for calcul the mask position with numpy : 0.009546995162963867 nb_pixel_total : 27099 time to create 1 rle with old method : 0.0283966064453125 time for calcul the mask position with numpy : 0.009797334671020508 nb_pixel_total : 107 time to create 1 rle with old method : 0.00012993812561035156 time for calcul the mask position with numpy : 0.009509801864624023 nb_pixel_total : 1236 time to create 1 rle with old method : 0.0013883113861083984 time for calcul the mask position with numpy : 0.009279489517211914 nb_pixel_total : 155 time to create 1 rle with old method : 0.00020885467529296875 time for calcul the mask position with numpy : 0.009859800338745117 nb_pixel_total : 44 time to create 1 rle with old method : 8.58306884765625e-05 time for calcul the mask position with numpy : 0.00946044921875 nb_pixel_total : 652 time to create 1 rle with old method : 0.0007512569427490234 time for calcul the mask position with numpy : 0.009302377700805664 nb_pixel_total : 2055 time to create 1 rle with old method : 0.0022580623626708984 time for calcul the mask position with numpy : 0.009381771087646484 nb_pixel_total : 3917 time to create 1 rle with old method : 0.004245758056640625 time for calcul the mask position with numpy : 0.008959531784057617 nb_pixel_total : 1830 time to create 1 rle with old method : 0.002002716064453125 time for calcul the mask position with numpy : 0.005767822265625 nb_pixel_total : 2091 time to create 1 rle with old method : 0.0022470951080322266 time for calcul the mask position with numpy : 0.00568842887878418 nb_pixel_total : 134 time to create 1 rle with old method : 0.0001659393310546875 time for calcul the mask position with numpy : 0.005856513977050781 nb_pixel_total : 511 time to create 1 rle with old method : 0.0005574226379394531 time for calcul the mask position with numpy : 0.005894899368286133 nb_pixel_total : 1 time to create 1 rle with old method : 1.8596649169921875e-05 time for calcul the mask position with numpy : 0.00571131706237793 nb_pixel_total : 302 time to create 1 rle with old method : 0.00036644935607910156 time for calcul the mask position with numpy : 0.0059814453125 nb_pixel_total : 312 time to create 1 rle with old method : 0.0003440380096435547 time for calcul the mask position with numpy : 0.00579380989074707 nb_pixel_total : 280 time to create 1 rle with old method : 0.0003185272216796875 time for calcul the mask position with numpy : 0.005766153335571289 nb_pixel_total : 101 time to create 1 rle with old method : 0.00015544891357421875 time for calcul the mask position with numpy : 0.0058705806732177734 nb_pixel_total : 433 time to create 1 rle with old method : 0.0005304813385009766 time for calcul the mask position with numpy : 0.005795001983642578 nb_pixel_total : 1425 time to create 1 rle with old method : 0.0016393661499023438 time for calcul the mask position with numpy : 0.005737781524658203 nb_pixel_total : 614 time to create 1 rle with old method : 0.0006842613220214844 time for calcul the mask position with numpy : 0.005767345428466797 nb_pixel_total : 159 time to create 1 rle with old method : 0.00019884109497070312 time for calcul the mask position with numpy : 0.0057621002197265625 nb_pixel_total : 242 time to create 1 rle with old method : 0.00028133392333984375 time for calcul the mask position with numpy : 0.005813121795654297 nb_pixel_total : 155 time to create 1 rle with old method : 0.0002033710479736328 time for calcul the mask position with numpy : 0.005599021911621094 nb_pixel_total : 7 time to create 1 rle with old method : 2.8848648071289062e-05 time for calcul the mask position with numpy : 0.009835481643676758 nb_pixel_total : 64 time to create 1 rle with old method : 9.679794311523438e-05 time for calcul the mask position with numpy : 0.007356166839599609 nb_pixel_total : 220 time to create 1 rle with old method : 0.00025725364685058594 time for calcul the mask position with numpy : 0.005809307098388672 nb_pixel_total : 328 time to create 1 rle with old method : 0.00043272972106933594 time for calcul the mask position with numpy : 0.00569915771484375 nb_pixel_total : 511 time to create 1 rle with old method : 0.0006134510040283203 time for calcul the mask position with numpy : 0.005537748336791992 nb_pixel_total : 199 time to create 1 rle with old method : 0.00022077560424804688 time for calcul the mask position with numpy : 0.005599021911621094 nb_pixel_total : 70 time to create 1 rle with old method : 0.00010275840759277344 time for calcul the mask position with numpy : 0.005739688873291016 nb_pixel_total : 10021 time to create 1 rle with old method : 0.01063227653503418 time for calcul the mask position with numpy : 0.005563020706176758 nb_pixel_total : 148 time to create 1 rle with old method : 0.00017952919006347656 time for calcul the mask position with numpy : 0.00588536262512207 nb_pixel_total : 28006 time to create 1 rle with old method : 0.029903888702392578 time for calcul the mask position with numpy : 0.005743741989135742 nb_pixel_total : 8575 time to create 1 rle with old method : 0.009329557418823242 time for calcul the mask position with numpy : 0.005763053894042969 nb_pixel_total : 11 time to create 1 rle with old method : 4.839897155761719e-05 time for calcul the mask position with numpy : 0.005753517150878906 nb_pixel_total : 102 time to create 1 rle with old method : 0.00013780593872070312 time for calcul the mask position with numpy : 0.005666017532348633 nb_pixel_total : 309 time to create 1 rle with old method : 0.0003418922424316406 time for calcul the mask position with numpy : 0.0056612491607666016 nb_pixel_total : 192 time to create 1 rle with old method : 0.0002613067626953125 time for calcul the mask position with numpy : 0.00559234619140625 nb_pixel_total : 750 time to create 1 rle with old method : 0.0008060932159423828 time for calcul the mask position with numpy : 0.005795001983642578 nb_pixel_total : 3223 time to create 1 rle with old method : 0.003476381301879883 time for calcul the mask position with numpy : 0.005671501159667969 nb_pixel_total : 590 time to create 1 rle with old method : 0.0006308555603027344 time for calcul the mask position with numpy : 0.0058138370513916016 nb_pixel_total : 47 time to create 1 rle with old method : 0.00014019012451171875 time for calcul the mask position with numpy : 0.006049633026123047 nb_pixel_total : 242 time to create 1 rle with old method : 0.0003020763397216797 time for calcul the mask position with numpy : 0.005844593048095703 nb_pixel_total : 559 time to create 1 rle with old method : 0.0006279945373535156 time for calcul the mask position with numpy : 0.006109714508056641 nb_pixel_total : 72 time to create 1 rle with old method : 0.00010752677917480469 time for calcul the mask position with numpy : 0.006180286407470703 nb_pixel_total : 3392 time to create 1 rle with old method : 0.0038738250732421875 time for calcul the mask position with numpy : 0.00594639778137207 nb_pixel_total : 94 time to create 1 rle with old method : 0.00012993812561035156 time for calcul the mask position with numpy : 0.006218910217285156 nb_pixel_total : 1361 time to create 1 rle with old method : 0.001575469970703125 time for calcul the mask position with numpy : 0.006041049957275391 nb_pixel_total : 142 time to create 1 rle with old method : 0.00019168853759765625 time for calcul the mask position with numpy : 0.00611424446105957 nb_pixel_total : 82 time to create 1 rle with old method : 0.00011777877807617188 time for calcul the mask position with numpy : 0.006103038787841797 nb_pixel_total : 1917 time to create 1 rle with old method : 0.002249479293823242 time for calcul the mask position with numpy : 0.0061185359954833984 nb_pixel_total : 991 time to create 1 rle with old method : 0.001188039779663086 time for calcul the mask position with numpy : 0.0061228275299072266 nb_pixel_total : 258 time to create 1 rle with old method : 0.00032258033752441406 time for calcul the mask position with numpy : 0.00606226921081543 nb_pixel_total : 614 time to create 1 rle with old method : 0.0007159709930419922 time for calcul the mask position with numpy : 0.006042957305908203 nb_pixel_total : 3168 time to create 1 rle with old method : 0.003628969192504883 time for calcul the mask position with numpy : 0.0059125423431396484 nb_pixel_total : 197 time to create 1 rle with old method : 0.0002295970916748047 time for calcul the mask position with numpy : 0.005911588668823242 nb_pixel_total : 220 time to create 1 rle with old method : 0.00036716461181640625 create new chi : 0.8573436737060547 after preparing all the mask , begin to delete the rle from the crop_hashtag_id => VR 28-11-20 : il faut déplacer cela apres le save_crop_hashtag_ids_obj de la ligne 9514 ! we have 0 chi objets contains the rles time to delete rle : 0.001257181167602539 batch 1 Loaded 90 chid ids of type : 4230 Number RLEs to save : 10911 TO DO : save crop sub photo not yet done ! save time : 0.8653233051300049 map_output_result : {1340418661: (0.0, 'Should be the crop_list due to order', 0.0), 1340418639: (0.0, 'Should be the crop_list due to order', 0.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 [1340418661, 1340418639] Looping around the photos to save general results len do output : 2 /1340418661.Didn't retrieve data . /1340418639.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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.012055635452270508 save_final save missing photos in datou_result : time spend for datou_step_exec : 7.0084006786346436 time spend to save output : 0.012343645095825195 total time spend for step 4 : 7.020744323730469 step5:crop_condition Sat Mar 1 19:21:04 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 some photos are not treated, begin crop_condition Loading chi in step crop with photo_hashtag_type : 4230 Loading chi in step crop for list_pids : 2 ! batch 1 Loaded 191 chid ids of type : 4230 begin to crop the class : papier param for this class : {'min_score': 0.6} filtre for class : papier hashtag_id of this class : 492668766 Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 56 About to insert : list_path_to_insert length 56 new photo from crops ! About to upload 56 photos upload in portfolio : 4869462 init cache_photo without model_param we have 56 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740853265_2838843 we have uploaded 56 photos in the portfolio 4869462 time of upload the photos Elapsed time : 22.48634624481201 we have finished the crop for the class : papier begin to crop the class : carton param for this class : {'min_score': 0.6} filtre for class : carton hashtag_id of this class : 492774966 Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 32 About to insert : list_path_to_insert length 32 new photo from crops ! About to upload 32 photos upload in portfolio : 4869462 init cache_photo without model_param we have 32 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740853288_2838843 we have uploaded 32 photos in the portfolio 4869462 time of upload the photos Elapsed time : 12.433687448501587 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.6} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.6} filtre for class : pet_clair hashtag_id of this class : 2107755846 Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 4869462 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740853301_2838843 we have uploaded 3 photos in the portfolio 4869462 time of upload the photos Elapsed time : 1.0274484157562256 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.6} filtre for class : autre hashtag_id of this class : 494826614 Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 42 About to insert : list_path_to_insert length 42 new photo from crops ! About to upload 42 photos upload in portfolio : 4869462 init cache_photo without model_param we have 42 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740853303_2838843 we have uploaded 42 photos in the portfolio 4869462 time of upload the photos Elapsed time : 11.085726499557495 we have finished the crop for the class : autre begin to crop the class : pehd param for this class : {'min_score': 0.6} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.6} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles for these photos Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1340418661, 1340418639] Looping around the photos to save general results len do output : 133 /1340422058Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422060Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422061Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422062Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422063Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422064Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422065Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422066Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422067Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422068Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422069Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422070Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422071Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422072Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422073Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422074Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422075Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422076Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422077Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422078Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422079Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422082Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422086Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422089Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422091Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422095Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422098Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422100Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422103Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422107Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422112Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422116Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422117Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422118Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422119Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422120Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422121Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422122Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422123Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422124Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422125Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422126Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422127Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422128Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422129Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422130Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422131Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422132Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422133Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422134Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422135Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422136Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422137Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422138Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422140Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422141Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422163Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422164Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422165Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422167Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422171Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422172Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422173Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422174Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422175Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422176Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422177Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422178Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422179Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422180Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422181Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422182Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422183Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422184Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422185Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422186Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422187Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422188Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422189Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422190Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422191Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422192Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422193Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422194Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422195Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422196Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422197Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422198Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422200Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422201Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422202Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422207Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422208Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422209Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422210Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422211Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422212Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422213Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422214Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422215Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422216Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422217Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422218Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422219Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422220Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422221Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422222Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422223Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422224Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422225Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422226Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422227Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422228Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422229Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422230Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422231Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422232Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422233Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422234Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422235Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422236Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422237Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422238Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422239Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422240Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422241Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422242Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422243Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422244Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422245Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422246Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422247Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340422248Didn'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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 401 time used for this insertion : 0.030634164810180664 save_final save missing photos in datou_result : time spend for datou_step_exec : 49.85595989227295 time spend to save output : 0.035840749740600586 total time spend for step 5 : 49.89180064201355 step6:thcl Sat Mar 1 19:21:54 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 ! we are using the classfication for only one thcl 3237 time to import caffe and check if the image exist : 0.004117250442504883 time to convert the images to numpy array : 0.02317667007446289 time to import caffe and check if the image exist : 0.008469343185424805 time to convert the images to numpy array : 0.03310441970825195 time to import caffe and check if the image exist : 0.013758420944213867 time to convert the images to numpy array : 0.02991342544555664 time to import caffe and check if the image exist : 0.01176595687866211 time to convert the images to numpy array : 0.036295175552368164 time to import caffe and check if the image exist : 0.010619640350341797 time to convert the images to numpy array : 0.03835153579711914 time to import caffe and check if the image exist : 0.021331310272216797 time to convert the images to numpy array : 0.028935670852661133 time to import caffe and check if the image exist : 0.012975931167602539 time to convert the images to numpy array : 0.03830742835998535 time to import caffe and check if the image exist : 0.012073516845703125 time to convert the images to numpy array : 0.03951382637023926 time to import caffe and check if the image exist : 0.018438339233398438 time to convert the images to numpy array : 0.034262895584106445 time to import caffe and check if the image exist : 0.013271570205688477 time to convert the images to numpy array : 0.04065394401550293 total time to convert the images to numpy array : 0.3045389652252197 list photo_ids error: [] list photo_ids correct : [1340422242, 1340422243, 1340422244, 1340422245, 1340422246, 1340422247, 1340422248, 1340422058, 1340422060, 1340422061, 1340422062, 1340422063, 1340422064, 1340422065, 1340422066, 1340422067, 1340422068, 1340422069, 1340422070, 1340422071, 1340422072, 1340422163, 1340422164, 1340422165, 1340422167, 1340422171, 1340422172, 1340422173, 1340422174, 1340422175, 1340422176, 1340422177, 1340422178, 1340422179, 1340422180, 1340422127, 1340422128, 1340422129, 1340422130, 1340422131, 1340422132, 1340422133, 1340422134, 1340422135, 1340422136, 1340422137, 1340422138, 1340422140, 1340422141, 1340422073, 1340422074, 1340422075, 1340422076, 1340422077, 1340422078, 1340422079, 1340422082, 1340422086, 1340422089, 1340422091, 1340422095, 1340422098, 1340422100, 1340422228, 1340422229, 1340422230, 1340422231, 1340422232, 1340422233, 1340422234, 1340422235, 1340422236, 1340422237, 1340422238, 1340422239, 1340422240, 1340422241, 1340422195, 1340422196, 1340422197, 1340422198, 1340422200, 1340422201, 1340422202, 1340422207, 1340422208, 1340422209, 1340422210, 1340422211, 1340422212, 1340422213, 1340422214, 1340422215, 1340422216, 1340422217, 1340422218, 1340422219, 1340422220, 1340422221, 1340422222, 1340422223, 1340422224, 1340422225, 1340422226, 1340422227, 1340422181, 1340422182, 1340422183, 1340422184, 1340422185, 1340422186, 1340422187, 1340422188, 1340422189, 1340422190, 1340422191, 1340422192, 1340422193, 1340422194, 1340422103, 1340422107, 1340422112, 1340422116, 1340422117, 1340422118, 1340422119, 1340422120, 1340422121, 1340422122, 1340422123, 1340422124, 1340422125, 1340422126] number of photos to traite : 133 try to delete the photos incorrect in DB tagging for thcl : 3237 To do loadFromThcl(), then load ParamDescType : thcl3237 thcls : [{'id': 3237, 'mtr_user_id': 31, 'name': 'learn_rubbia_refus_2500', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton,Film_plastique,PEHD,PET_clair,PET_fonce,Papier,Tetrapak,flou,mal_croppe,metal,refus', 'svm_portfolios_learning': '4865689,4865690,4865686,4865684,4865685,4865688,4865691,4865693,4865692,4865687,4865683', 'photo_hashtag_type': 4158, 'photo_desc_type': 5561, 'type_classification': 'caffe', 'hashtag_id_list': '492774966,2107756122,628944319,2107755846,2107755900,492668766,609991870,492777938,2107755527,492628673,538914404'}] thcl {'id': 3237, 'mtr_user_id': 31, 'name': 'learn_rubbia_refus_2500', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton,Film_plastique,PEHD,PET_clair,PET_fonce,Papier,Tetrapak,flou,mal_croppe,metal,refus', 'svm_portfolios_learning': '4865689,4865690,4865686,4865684,4865685,4865688,4865691,4865693,4865692,4865687,4865683', 'photo_hashtag_type': 4158, 'photo_desc_type': 5561, 'type_classification': 'caffe', 'hashtag_id_list': '492774966,2107756122,628944319,2107755846,2107755900,492668766,609991870,492777938,2107755527,492628673,538914404'} Update svm_hashtag_type_desc : 5561 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5561, 'learn_rubbia_refus_2500', 2048, 2048, 'learn_rubbia_refus_2500', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 3, datetime.datetime(2021, 12, 2, 19, 10, 8), datetime.datetime(2021, 12, 2, 19, 10, 8)) To loadFromThcl() : net_5561 begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 5525 max_wait_temp : 1 max_wait : 0 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5561, 'learn_rubbia_refus_2500', 2048, 2048, 'learn_rubbia_refus_2500', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 3, datetime.datetime(2021, 12, 2, 19, 10, 8), datetime.datetime(2021, 12, 2, 19, 10, 8)) None mean_file_type : mean_file_path : prototxt_file_path : model : learn_rubbia_refus_2500 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_rubbia_refus_2500 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_rubbia_refus_2500 /data/models_weight/learn_rubbia_refus_2500/caffemodel size_local : 94358479 size in s3 : 94358479 create time local : 2021-12-03 18:29:39 create time in s3 : 2021-12-02 17:49:16 caffemodel already exist and didn't need to update /data/models_weight/learn_rubbia_refus_2500/deploy.prototxt size_local : 32544 size in s3 : 32544 create time local : 2021-12-03 18:29:39 create time in s3 : 2021-12-02 17:49:15 deploy.prototxt already exist and didn't need to update /data/models_weight/learn_rubbia_refus_2500/mean.npy size_local : 1572992 size in s3 : 1572992 create time local : 2021-12-03 18:29:40 create time in s3 : 2021-12-02 18:09:52 mean.npy already exist and didn't need to update /data/models_weight/learn_rubbia_refus_2500/synset_words.txt size_local : 334 size in s3 : 334 create time local : 2021-12-03 18:29:40 create time in s3 : 2021-12-02 18:10:06 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_rubbia_refus_2500/deploy.prototxt caffemodel_filename : /data/models_weight/learn_rubbia_refus_2500/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 : 5306 max_wait_temp : 1 max_wait : 0 dict_keys(['pool5', 'prob']) time used to do the prepocess of the images : 0.7982521057128906 time used to do the prediction : 0.6823382377624512 save descriptor for thcl : 3237 time to traite the descriptors : 0.8708984851837158 Catched exception ! Connect or reconnect ! storage_type for insertDescriptorsMulti : 3 To insert : 1340422242 To insert : 1340422243 To insert : 1340422244 To insert : 1340422245 To insert : 1340422246 To insert : 1340422247 To insert : 1340422248 To insert : 1340422058 To insert : 1340422060 To insert : 1340422061 To insert : 1340422062 To insert : 1340422063 To insert : 1340422064 To insert : 1340422065 To insert : 1340422066 To insert : 1340422067 To insert : 1340422068 To insert : 1340422069 To insert : 1340422070 To insert : 1340422071 To insert : 1340422072 To insert : 1340422163 To insert : 1340422164 To insert : 1340422165 To insert : 1340422167 To insert : 1340422171 To insert : 1340422172 To insert : 1340422173 To insert : 1340422174 To insert : 1340422175 To insert : 1340422176 To insert : 1340422177 To insert : 1340422178 To insert : 1340422179 To insert : 1340422180 To insert : 1340422127 To insert : 1340422128 To insert : 1340422129 To insert : 1340422130 To insert : 1340422131 To insert : 1340422132 To insert : 1340422133 To insert : 1340422134 To insert : 1340422135 To insert : 1340422136 To insert : 1340422137 To insert : 1340422138 To insert : 1340422140 To insert : 1340422141 To insert : 1340422073 To insert : 1340422074 To insert : 1340422075 To insert : 1340422076 To insert : 1340422077 To insert : 1340422078 To insert : 1340422079 To insert : 1340422082 To insert : 1340422086 To insert : 1340422089 To insert : 1340422091 To insert : 1340422095 To insert : 1340422098 To insert : 1340422100 To insert : 1340422228 To insert : 1340422229 To insert : 1340422230 To insert : 1340422231 To insert : 1340422232 To insert : 1340422233 To insert : 1340422234 To insert : 1340422235 To insert : 1340422236 To insert : 1340422237 To insert : 1340422238 To insert : 1340422239 To insert : 1340422240 To insert : 1340422241 To insert : 1340422195 To insert : 1340422196 To insert : 1340422197 To insert : 1340422198 To insert : 1340422200 To insert : 1340422201 To insert : 1340422202 To insert : 1340422207 To insert : 1340422208 To insert : 1340422209 To insert : 1340422210 To insert : 1340422211 To insert : 1340422212 To insert : 1340422213 To insert : 1340422214 To insert : 1340422215 To insert : 1340422216 To insert : 1340422217 To insert : 1340422218 To insert : 1340422219 To insert : 1340422220 To insert : 1340422221 To insert : 1340422222 To insert : 1340422223 To insert : 1340422224 To insert : 1340422225 To insert : 1340422226 To insert : 1340422227 To insert : 1340422181 To insert : 1340422182 To insert : 1340422183 To insert : 1340422184 To insert : 1340422185 To insert : 1340422186 To insert : 1340422187 To insert : 1340422188 To insert : 1340422189 To insert : 1340422190 To insert : 1340422191 To insert : 1340422192 To insert : 1340422193 To insert : 1340422194 To insert : 1340422103 To insert : 1340422107 To insert : 1340422112 To insert : 1340422116 To insert : 1340422117 To insert : 1340422118 To insert : 1340422119 To insert : 1340422120 To insert : 1340422121 To insert : 1340422122 To insert : 1340422123 To insert : 1340422124 To insert : 1340422125 To insert : 1340422126 time to insert the descriptors : 26.9572856426239 Inside saveOutput : final : False verbose : 0 time used to find the portfolios of the photos SAVE THCL : begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 200 time used for this insertion : 0.021363496780395508 save missing photos in datou_result : time spend for datou_step_exec : 34.1175639629364 time spend to save output : 0.11195087432861328 total time spend for step 6 : 34.229514837265015 step7:ventilate_hashtags_in_portfolio Sat Mar 1 19:22:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step ventilate_hashtags_in_portfolio : To implement ! Iterating over portfolio : 20951100 get user id for portfolio 20951100 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`=20951100 AND mptpi.`type`=4230 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('PEHD','papier','pehd','carton','environnement','Tetrapak','PET_fonce','Papier','PET_clair','mal_croppe','autre','Film_plastique','Carton','metal','flou','refus','pet_clair','pet_fonce')) AND mptpi.`min_score`=0.6 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`=20951100 AND mptpi.`type`=4230 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('PEHD','papier','pehd','carton','environnement','Tetrapak','PET_fonce','Papier','PET_clair','mal_croppe','autre','Film_plastique','Carton','metal','flou','refus','pet_clair','pet_fonce')) AND mptpi.`min_score`=0.6 To do Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") 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`=20951100 AND mptpi.`type`=4231 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('PEHD','papier','pehd','carton','environnement','Tetrapak','PET_fonce','Papier','PET_clair','mal_croppe','autre','Film_plastique','Carton','metal','flou','refus','pet_clair','pet_fonce')) AND mptpi.`min_score`=0.6 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`=20951100 AND mptpi.`type`=4231 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('PEHD','papier','pehd','carton','environnement','Tetrapak','PET_fonce','Papier','PET_clair','mal_croppe','autre','Film_plastique','Carton','metal','flou','refus','pet_clair','pet_fonce')) AND mptpi.`min_score`=0.6 To do lien utilise dans velours : https://www.fotonower.com/velours/20951257,20951262,20951267,20951259,20951260,20951272,20951271,20951264,20951265,20951266,20951268,20951269,20951270?tags=pehd,papier,carton,environnement,tetrapak,pet_fonce,pet_clair,mal_croppe,autre,film_plastique,metal,flou,refus&datou_id_consolidate=4235&port_consolidate=20951100 Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1340418661, 1340418639] Looping around the photos to save general results len do output : 1 /20951100. 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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.012602567672729492 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.333693027496338 time spend to save output : 0.013014554977416992 total time spend for step 7 : 2.346707582473755 step8:final Sat Mar 1 19:22:30 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 : {1340418661: ('0.21309613582432863',), 1340418639: ('0.21309613582432863',)} new output for save of step final : {1340418661: ('0.21309613582432863',), 1340418639: ('0.21309613582432863',)} [1340418661, 1340418639] Looping around the photos to save general results len do output : 2 /1340418661.Didn't retrieve data . /1340418639.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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.012442350387573242 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.12008953094482422 time spend to save output : 0.012705326080322266 total time spend for step 8 : 0.13279485702514648 step9:velours_tree Sat Mar 1 19:22:30 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 list_portfolios : 20951257,20951262,20951267,20951259,20951260,20951272,20951271,20951264,20951265,20951266,20951268,20951269,20951270 photo desc type : 5561 - Retrieving photos to tag... query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951257 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951262 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951267 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951259 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951260 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951272 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951271 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951264 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951265 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951266 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951268 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951269 ORDER BY ph.size desc query : SELECT ph.photo_id FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20951270 ORDER BY ph.size desc - Loading descriptors... Size : 2048 len(descriptors) : 133 Compute structured hierarchical clustering... ward : AgglomerativeClustering(n_clusters=6) ward.labels_ : [2 4 0 0 3 0 0 0 0 0 2 0 0 2 0 0 2 0 0 0 0 0 2 2 0 2 0 4 3 0 3 3 3 2 3 0 3 0 0 0 0 0 0 2 0 0 0 0 0 4 3 3 3 0 3 3 4 0 2 1 0 0 0 0 0 0 0 0 0 0 0 1 1 4 2 1 0 0 0 0 0 4 0 0 0 1 1 2 3 0 0 5 5 0 5 4 3 2 0 2 0 2 0 4 0 4 2 3 4 2 4 5 5 0 4 3 3 0 2 0 2 0 0 0 2 0 4 2 2 0 0 4 2] Elapsed time: 0.0173647403717041 graph_id used : 80903 - Beta version, working pretty good on 11-5-16 ! https://www.fotonower.com/velours/20951257,20951262,20951267,20951259,20951260,20951272,20951271,20951264,20951265,20951266,20951268,20951269,20951270?tags=pehd,papier,carton,environnement,tetrapak,pet_fonce,pet_clair,mal_croppe,autre,film_plastique,metal,flou,refus&datou_id_consolidate=4235&port_consolidate=20951100&tree_id=80903 Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : velours_tree we use saveGeneral [1340418661, 1340418639] Looping around the photos to save general results len do output : 1 /20951100Didn'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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.01247549057006836 save_final save missing photos in datou_result : time spend for datou_step_exec : 8.878495931625366 time spend to save output : 0.012784957885742188 total time spend for step 9 : 8.891280889511108 step10:send_mail_cod Sat Mar 1 19:22:39 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 complete output_args for input 1 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 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_Qualipapia_P20951100_01-03-2025_19_22_39.pdf 20951239 imagette209512391740853359 20951244 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette209512441740853359 20951249 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette209512491740853360 20951242 imagette209512421740853361 20951254 imagette209512541740853361 20951253 change filename to text .change filename to text .change filename to text .imagette209512531740853361 20951246 imagette209512461740853361 20951247 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette209512471740853361 20951248 imagette209512481740853362 20951250 imagette209512501740853362 20951251 imagette209512511740853362 20951252 imagette209512521740853362 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=20951100 and hashtag_type = 4230 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/20951257,20951262,20951267,20951259,20951260,20951272,20951271,20951264,20951265,20951266,20951268,20951269,20951270?tags=pehd,papier,carton,environnement,tetrapak,pet_fonce,pet_clair,mal_croppe,autre,film_plastique,metal,flou,refus&datou_id_consolidate=4235&port_consolidate=20951100&tree_id=80903 your option no_mail is active, we will not send the real mail to your client args[1340418661] : ((1340418661, -7.531012429400596, 492609224), (1340418661, -0.9665353510867042, 501862349), '0.21309613582432863') We are sending mail with results at cod@fotonower.com args[1340418639] : ((1340418639, -7.494508055384501, 492609224), (1340418639, -0.9891020306552651, 501862349), '0.21309613582432863') We are sending mail with results at cod@fotonower.com refus_total : 0.21309613582432863 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=20951100 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 1000 start upload file to ovh https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20951100_01-03-2025_19_22_39.pdf results_Qualipapia_P20951100_01-03-2025_19_22_39.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20951100_01-03-2025_19_22_39.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('4234','20951100','results_Qualipapia_P20951100_01-03-2025_19_22_39.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20951100_01-03-2025_19_22_39.pdf','pdf','','0.14','0.21309613582432863') Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1340418661, 1340418639] 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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 2 time used for this insertion : 0.01168966293334961 save_final save missing photos in datou_result : time spend for datou_step_exec : 4.144156455993652 time spend to save output : 0.011879682540893555 total time spend for step 10 : 4.156036138534546 step11:split_time_score Sat Mar 1 19:22:43 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 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 begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 3442, 'mtr_user_id': 31, 'name': 'classifieur_2camions_valcor_021122_v1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'deux_camions,camion_droite,camion_gauche,pas_de_camion', 'svm_portfolios_learning': '7659379,7659034,7657685,7657114', 'photo_hashtag_type': 4458, 'photo_desc_type': 5723, 'type_classification': 'tf_classification2', 'hashtag_id_list': '2107760533,2107760534,2107760535,2107760536'}] 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'}] (('18', 2),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 01032025 20951100 Nombre de photos uploadées : 2 / 23040 (0%) 01032025 20951100 Nombre de photos taguées (types de déchets): 2 / 2 (100%) 01032025 20951100 Nombre de photos taguées (volume) : 0 / 2 (0%) elapsed_time : load_data_split_time_score 4.0531158447265625e-06 elapsed_time : order_list_meta_photo_and_scores 1.049041748046875e-05 ?? elapsed_time : fill_and_build_computed_from_old_data 0.00029778480529785156 elapsed_time : insert_dashboard_record_day_entry 0.023360490798950195 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.23892758134565031 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948539_01-03-2025_10_46_56.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948539 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948539 AND mptpi.`type`=4230 To do Qualite : 0.24625960389241422 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948540_01-03-2025_10_34_55.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948540 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948540 AND mptpi.`type`=4230 To do Qualite : 0.20216657906345706 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948718_01-03-2025_11_24_06.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948718 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948718 AND mptpi.`type`=4230 To do Qualite : 0.2000221582417073 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948719_01-03-2025_11_32_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948719 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948719 AND mptpi.`type`=4230 To do Qualite : 0.2290304525818133 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948720_01-03-2025_12_57_53.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948720 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948720 AND mptpi.`type`=4230 To do Qualite : 0.19748340895258557 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948721_01-03-2025_11_14_34.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948721 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948721 AND mptpi.`type`=4230 To do Qualite : 0.20384795441780693 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20948722_01-03-2025_11_16_49.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20948722 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20948722 AND mptpi.`type`=4230 To do Qualite : 0.2061637751903161 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20949315_01-03-2025_13_47_37.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949315 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20949315 AND mptpi.`type`=4230 To do Qualite : 0.2563436286744535 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20949316_01-03-2025_13_34_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949316 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20949316 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949932 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949933 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949934 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949935 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949936 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949937 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949938 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949939 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949940 order by id desc limit 1 Qualite : 0.2172482883806568 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20949941_01-03-2025_15_46_57.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949941 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20949941 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949942 order by id desc limit 1 Qualite : 0.18540509980212977 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20949943_01-03-2025_15_34_54.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20949943 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20949943 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950047 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950048 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950049 order by id desc limit 1 Qualite : 0.23844159780447716 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950050_01-03-2025_16_17_18.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950050 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950050 AND mptpi.`type`=4230 To do Qualite : 0.22493991237329264 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950051_01-03-2025_16_32_13.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950051 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950051 AND mptpi.`type`=4230 To do Qualite : 0.188511470189505 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950052_01-03-2025_16_23_20.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950052 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950052 AND mptpi.`type`=4230 To do Qualite : 0.18109626908376963 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950260_01-03-2025_16_54_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950260 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950260 AND mptpi.`type`=4230 To do Qualite : 0.16586306959729208 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950261_01-03-2025_16_35_09.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950261 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950261 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950391 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950392 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950393 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950394 order by id desc limit 1 Qualite : 0.19328712984834084 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950395_01-03-2025_17_18_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950395 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950395 AND mptpi.`type`=4230 To do Qualite : 0.2392599817619378 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950396_01-03-2025_17_24_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950396 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950396 AND mptpi.`type`=4230 To do Qualite : 0.22411548065894654 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950397_01-03-2025_17_32_28.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950397 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950397 AND mptpi.`type`=4230 To do Qualite : 0.2172577121206167 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950398_01-03-2025_17_11_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950398 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950398 AND mptpi.`type`=4230 To do Qualite : 0.1877535365280539 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950604_01-03-2025_18_32_55.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950604 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950604 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950605 order by id desc limit 1 Qualite : 0.19067849606352008 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950606_01-03-2025_17_38_49.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950606 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950606 AND mptpi.`type`=4230 To do Qualite : 0.1888073545444506 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950607_01-03-2025_17_47_24.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950607 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950607 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950608 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950901 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950902 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950903 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950904 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950905 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950906 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950907 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950908 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950909 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950910 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950911 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950912 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950913 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950914 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950915 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950916 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950917 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950918 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950919 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950920 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950921 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950922 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950923 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950924 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950925 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950926 order by id desc limit 1 Qualite : 0.20176256870286613 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20950927_01-03-2025_18_46_37.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950927 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20950927 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20950928 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951089 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951090 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951091 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951092 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951093 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951094 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951095 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951096 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951097 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951098 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951099 order by id desc limit 1 Qualite : 0.21309613582432863 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20951100_01-03-2025_19_22_39.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951100 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20951100 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951101 order by id desc limit 1 Qualite : 0.23383995199841548 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20951102_01-03-2025_19_13_42.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20951102 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 11415 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11419 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11419 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11416 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11417 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11417 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11422 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 2 of step 11418 have datatype=6 We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11419 doesn't seem to be define in the database( WARNING : output 1 of step 11415 have datatype=7 whereas input 2 of step 11419 have datatype=None WARNING : type of output 3 of step 11419 doesn't seem to be define in the database( WARNING : type of input 1 of step 11416 doesn't seem to be define in the database( WARNING : type of output 1 of step 11416 doesn't seem to be define in the database( WARNING : type of input 3 of step 11417 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11416 have datatype=10 whereas input 0 of step 11420 have datatype=18 WARNING : type of input 5 of step 11418 doesn't seem to be define in the database( WARNING : output 0 of step 11420 have datatype=11 whereas input 5 of step 11418 have datatype=None WARNING : type of input 2 of step 11416 doesn't seem to be define in the database( WARNING : output 0 of step 11421 have datatype=5 whereas input 2 of step 11416 have datatype=None WARNING : output 0 of step 11418 have datatype=10 whereas input 0 of step 11422 have datatype=18 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`=20951102 AND mptpi.`type`=4230 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'01032025': {'nb_upload': 2, 'nb_taggue_class': 2, 'nb_taggue_densite': 0}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1340418661, 1340418639] Looping around the photos to save general results len do output : 1 /20951100Didn'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 ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418661', None, None, None, None, None, '2627078') ('4234', None, None, None, None, None, None, None, '2627078') ('4234', '20951100', '1340418639', None, None, None, None, None, '2627078') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.1334683895111084 save_final save missing photos in datou_result : time spend for datou_step_exec : 49.001171827316284 time spend to save output : 0.13381338119506836 total time spend for step 11 : 49.13498520851135 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 1 len(input) + len(total_photo_id_missing) : 2 set_done_treatment 32.12user 23.14system 3:08.96elapsed 29%CPU (0avgtext+0avgdata 2503780maxresident)k 991048inputs+11784outputs (11918major+1987574minor)pagefaults 0swaps