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 : 875688 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 : ['2560867'] with mtr_portfolio_ids : ['20314474'] and first list_photo_ids : [] new path : /proc/875688/ 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.21933460235595703 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 Fri Feb 7 01:20:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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 : 10330 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-02-07 01:20:32.985737: 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-02-07 01:20:33.015090: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-02-07 01:20:33.017665: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f3d0c000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-02-07 01:20:33.017708: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-02-07 01:20:33.022578: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-02-07 01:20:33.319287: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x1025db00 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-02-07 01:20:33.319368: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-02-07 01:20:33.320836: 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-02-07 01:20:33.321326: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-07 01:20:33.324147: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-07 01:20:33.336221: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-07 01:20:33.336805: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-07 01:20:33.352560: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-07 01:20:33.355785: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-07 01:20:33.381247: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-07 01:20:33.385011: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-07 01:20:33.385113: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-07 01:20:33.387244: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-02-07 01:20:33.387274: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-02-07 01:20:33.387289: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-02-07 01:20:33.390444: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9426 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-02-07 01:20:33.738781: 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-02-07 01:20:33.738957: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-07 01:20:33.739005: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-07 01:20:33.739046: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-07 01:20:33.739085: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-07 01:20:33.739120: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-07 01:20:33.739151: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-07 01:20:33.739181: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-07 01:20:33.741113: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-07 01:20:33.743290: 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-02-07 01:20:33.743436: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-07 01:20:33.743482: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-07 01:20:33.743517: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-07 01:20:33.743556: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-07 01:20:33.743596: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-07 01:20:33.743634: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-07 01:20:33.743673: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-07 01:20:33.745578: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-07 01:20:33.745642: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-02-07 01:20:33.745658: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-02-07 01:20:33.745670: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-02-07 01:20:33.748522: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9426 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-02-07 01:20:42.994488: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-07 01:20:43.184492: 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: -118.11406 max: 148.37344 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 5 time for calcul the mask position with numpy : 0.00010728836059570312 nb_pixel_total : 395 time to create 1 rle with old method : 0.0007786750793457031 length of segment : 28 time for calcul the mask position with numpy : 6.747245788574219e-05 nb_pixel_total : 826 time to create 1 rle with old method : 0.0015573501586914062 length of segment : 47 time for calcul the mask position with numpy : 4.935264587402344e-05 nb_pixel_total : 71 time to create 1 rle with old method : 0.00020456314086914062 length of segment : 17 time for calcul the mask position with numpy : 5.984306335449219e-05 nb_pixel_total : 830 time to create 1 rle with old method : 0.0015532970428466797 length of segment : 33 time for calcul the mask position with numpy : 4.744529724121094e-05 nb_pixel_total : 71 time to create 1 rle with old method : 0.00020599365234375 length of segment : 13 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -118.26641 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 : 4.649162292480469e-05 nb_pixel_total : 224 time to create 1 rle with old method : 0.00039649009704589844 length of segment : 34 time for calcul the mask position with numpy : 4.553794860839844e-05 nb_pixel_total : 563 time to create 1 rle with old method : 0.0007641315460205078 length of segment : 68 time for calcul the mask position with numpy : 4.982948303222656e-05 nb_pixel_total : 362 time to create 1 rle with old method : 0.0005712509155273438 length of segment : 15 time for calcul the mask position with numpy : 5.4836273193359375e-05 nb_pixel_total : 789 time to create 1 rle with old method : 0.0011157989501953125 length of segment : 51 time for calcul the mask position with numpy : 0.0002942085266113281 nb_pixel_total : 8549 time to create 1 rle with old method : 0.010031700134277344 length of segment : 340 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -116.17266 max: 150.93594 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 2 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 1247 time to create 1 rle with old method : 0.0018115043640136719 length of segment : 39 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 352 time to create 1 rle with old method : 0.001542806625366211 length of segment : 49 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -106.05547 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 2 time for calcul the mask position with numpy : 4.029273986816406e-05 nb_pixel_total : 296 time to create 1 rle with old method : 0.0004305839538574219 length of segment : 18 time for calcul the mask position with numpy : 3.361701965332031e-05 nb_pixel_total : 21 time to create 1 rle with old method : 6.508827209472656e-05 length of segment : 7 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: 148.10781 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 7 time for calcul the mask position with numpy : 5.6743621826171875e-05 nb_pixel_total : 131 time to create 1 rle with old method : 0.00029778480529785156 length of segment : 12 time for calcul the mask position with numpy : 5.984306335449219e-05 nb_pixel_total : 479 time to create 1 rle with old method : 0.0007913112640380859 length of segment : 68 time for calcul the mask position with numpy : 0.00011944770812988281 nb_pixel_total : 1725 time to create 1 rle with old method : 0.0027861595153808594 length of segment : 159 time for calcul the mask position with numpy : 6.318092346191406e-05 nb_pixel_total : 556 time to create 1 rle with old method : 0.0010197162628173828 length of segment : 21 time for calcul the mask position with numpy : 4.5299530029296875e-05 nb_pixel_total : 218 time to create 1 rle with old method : 0.0004000663757324219 length of segment : 23 time for calcul the mask position with numpy : 9.179115295410156e-05 nb_pixel_total : 2336 time to create 1 rle with old method : 0.0039215087890625 length of segment : 81 time for calcul the mask position with numpy : 0.00011110305786132812 nb_pixel_total : 681 time to create 1 rle with old method : 0.0013194084167480469 length of segment : 53 Processing 1 images image shape: (400, 400, 3) min: 10.00000 max: 219.00000 molded_images shape: (1, 640, 640, 3) min: -79.84922 max: 91.75078 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: -112.98125 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 13 time for calcul the mask position with numpy : 0.000133514404296875 nb_pixel_total : 1925 time to create 1 rle with old method : 0.004358768463134766 length of segment : 38 time for calcul the mask position with numpy : 7.939338684082031e-05 nb_pixel_total : 167 time to create 1 rle with old method : 0.0003612041473388672 length of segment : 14 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 175 time to create 1 rle with old method : 0.00028324127197265625 length of segment : 16 time for calcul the mask position with numpy : 5.125999450683594e-05 nb_pixel_total : 338 time to create 1 rle with old method : 0.000545501708984375 length of segment : 28 time for calcul the mask position with numpy : 4.553794860839844e-05 nb_pixel_total : 73 time to create 1 rle with old method : 0.0001556873321533203 length of segment : 10 time for calcul the mask position with numpy : 4.2438507080078125e-05 nb_pixel_total : 138 time to create 1 rle with old method : 0.00023412704467773438 length of segment : 15 time for calcul the mask position with numpy : 6.318092346191406e-05 nb_pixel_total : 1167 time to create 1 rle with old method : 0.0015783309936523438 length of segment : 40 time for calcul the mask position with numpy : 6.031990051269531e-05 nb_pixel_total : 514 time to create 1 rle with old method : 0.0010120868682861328 length of segment : 13 time for calcul the mask position with numpy : 5.173683166503906e-05 nb_pixel_total : 198 time to create 1 rle with old method : 0.00040793418884277344 length of segment : 14 time for calcul the mask position with numpy : 4.9591064453125e-05 nb_pixel_total : 67 time to create 1 rle with old method : 0.00016951560974121094 length of segment : 10 time for calcul the mask position with numpy : 4.6253204345703125e-05 nb_pixel_total : 144 time to create 1 rle with old method : 0.00033164024353027344 length of segment : 11 time for calcul the mask position with numpy : 5.316734313964844e-05 nb_pixel_total : 322 time to create 1 rle with old method : 0.0007343292236328125 length of segment : 18 time for calcul the mask position with numpy : 7.534027099609375e-05 nb_pixel_total : 1207 time to create 1 rle with old method : 0.0021753311157226562 length of segment : 34 Processing 1 images image shape: (400, 400, 3) min: 1.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -119.73906 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.00011992454528808594 nb_pixel_total : 858 time to create 1 rle with old method : 0.0021779537200927734 length of segment : 43 time for calcul the mask position with numpy : 0.0009014606475830078 nb_pixel_total : 27964 time to create 1 rle with old method : 0.037511587142944336 length of segment : 243 time for calcul the mask position with numpy : 0.0004718303680419922 nb_pixel_total : 23090 time to create 1 rle with old method : 0.03148841857910156 length of segment : 282 time for calcul the mask position with numpy : 6.842613220214844e-05 nb_pixel_total : 140 time to create 1 rle with old method : 0.000354766845703125 length of segment : 13 time for calcul the mask position with numpy : 4.482269287109375e-05 nb_pixel_total : 268 time to create 1 rle with old method : 0.000492095947265625 length of segment : 21 time for calcul the mask position with numpy : 4.2438507080078125e-05 nb_pixel_total : 222 time to create 1 rle with old method : 0.0004208087921142578 length of segment : 22 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -110.86797 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 : 8.177757263183594e-05 nb_pixel_total : 626 time to create 1 rle with old method : 0.001291513442993164 length of segment : 22 time for calcul the mask position with numpy : 0.000102996826171875 nb_pixel_total : 1919 time to create 1 rle with old method : 0.0036106109619140625 length of segment : 66 time for calcul the mask position with numpy : 6.794929504394531e-05 nb_pixel_total : 724 time to create 1 rle with old method : 0.0011920928955078125 length of segment : 28 time for calcul the mask position with numpy : 0.0006201267242431641 nb_pixel_total : 32061 time to create 1 rle with old method : 0.04372000694274902 length of segment : 498 time for calcul the mask position with numpy : 0.00016260147094726562 nb_pixel_total : 1537 time to create 1 rle with old method : 0.002049684524536133 length of segment : 146 time for calcul the mask position with numpy : 0.0001976490020751953 nb_pixel_total : 3058 time to create 1 rle with old method : 0.0047452449798583984 length of segment : 187 time for calcul the mask position with numpy : 0.00017309188842773438 nb_pixel_total : 2838 time to create 1 rle with old method : 0.0038039684295654297 length of segment : 129 time for calcul the mask position with numpy : 9.250640869140625e-05 nb_pixel_total : 1099 time to create 1 rle with old method : 0.001729726791381836 length of segment : 23 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: 150.39687 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 11 time for calcul the mask position with numpy : 7.05718994140625e-05 nb_pixel_total : 760 time to create 1 rle with old method : 0.0010900497436523438 length of segment : 91 time for calcul the mask position with numpy : 8.606910705566406e-05 nb_pixel_total : 1409 time to create 1 rle with old method : 0.001916646957397461 length of segment : 70 time for calcul the mask position with numpy : 9.226799011230469e-05 nb_pixel_total : 1656 time to create 1 rle with old method : 0.0022563934326171875 length of segment : 87 time for calcul the mask position with numpy : 4.363059997558594e-05 nb_pixel_total : 233 time to create 1 rle with old method : 0.0003459453582763672 length of segment : 24 time for calcul the mask position with numpy : 8.7738037109375e-05 nb_pixel_total : 1600 time to create 1 rle with old method : 0.002237558364868164 length of segment : 75 time for calcul the mask position with numpy : 0.0001685619354248047 nb_pixel_total : 5176 time to create 1 rle with old method : 0.006781578063964844 length of segment : 202 time for calcul the mask position with numpy : 0.0003085136413574219 nb_pixel_total : 2804 time to create 1 rle with old method : 0.0036139488220214844 length of segment : 182 time for calcul the mask position with numpy : 0.00011682510375976562 nb_pixel_total : 1821 time to create 1 rle with old method : 0.0024230480194091797 length of segment : 87 time for calcul the mask position with numpy : 0.0001800060272216797 nb_pixel_total : 2256 time to create 1 rle with old method : 0.002954244613647461 length of segment : 160 time for calcul the mask position with numpy : 0.00019288063049316406 nb_pixel_total : 3114 time to create 1 rle with old method : 0.004875659942626953 length of segment : 146 time for calcul the mask position with numpy : 0.0004000663757324219 nb_pixel_total : 8677 time to create 1 rle with old method : 0.010705232620239258 length of segment : 276 Processing 1 images image shape: (280, 400, 3) min: 6.00000 max: 213.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 90.12188 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 2 time for calcul the mask position with numpy : 5.078315734863281e-05 nb_pixel_total : 590 time to create 1 rle with old method : 0.0008933544158935547 length of segment : 54 time for calcul the mask position with numpy : 0.0010981559753417969 nb_pixel_total : 106354 time to create 1 rle with old method : 0.12064981460571289 length of segment : 281 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: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 12 time for calcul the mask position with numpy : 0.00017690658569335938 nb_pixel_total : 5172 time to create 1 rle with old method : 0.009908199310302734 length of segment : 82 time for calcul the mask position with numpy : 0.00012302398681640625 nb_pixel_total : 608 time to create 1 rle with old method : 0.0008559226989746094 length of segment : 23 time for calcul the mask position with numpy : 0.00010180473327636719 nb_pixel_total : 1673 time to create 1 rle with old method : 0.0022923946380615234 length of segment : 41 time for calcul the mask position with numpy : 7.677078247070312e-05 nb_pixel_total : 179 time to create 1 rle with old method : 0.0003769397735595703 length of segment : 19 time for calcul the mask position with numpy : 8.368492126464844e-05 nb_pixel_total : 601 time to create 1 rle with old method : 0.0011315345764160156 length of segment : 32 time for calcul the mask position with numpy : 6.103515625e-05 nb_pixel_total : 89 time to create 1 rle with old method : 0.0001983642578125 length of segment : 13 time for calcul the mask position with numpy : 6.985664367675781e-05 nb_pixel_total : 1418 time to create 1 rle with old method : 0.001844167709350586 length of segment : 48 time for calcul the mask position with numpy : 7.367134094238281e-05 nb_pixel_total : 2107 time to create 1 rle with old method : 0.0026030540466308594 length of segment : 52 time for calcul the mask position with numpy : 8.559226989746094e-05 nb_pixel_total : 428 time to create 1 rle with old method : 0.0010390281677246094 length of segment : 36 time for calcul the mask position with numpy : 0.00013208389282226562 nb_pixel_total : 2740 time to create 1 rle with old method : 0.0048024654388427734 length of segment : 99 time for calcul the mask position with numpy : 8.368492126464844e-05 nb_pixel_total : 821 time to create 1 rle with old method : 0.0018486976623535156 length of segment : 35 time for calcul the mask position with numpy : 4.982948303222656e-05 nb_pixel_total : 89 time to create 1 rle with old method : 0.00021219253540039062 length of segment : 18 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: 150.60781 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 8 time for calcul the mask position with numpy : 9.083747863769531e-05 nb_pixel_total : 604 time to create 1 rle with old method : 0.0014064311981201172 length of segment : 30 time for calcul the mask position with numpy : 0.00012493133544921875 nb_pixel_total : 1116 time to create 1 rle with old method : 0.0023832321166992188 length of segment : 71 time for calcul the mask position with numpy : 0.00012612342834472656 nb_pixel_total : 1609 time to create 1 rle with old method : 0.0034668445587158203 length of segment : 64 time for calcul the mask position with numpy : 6.198883056640625e-05 nb_pixel_total : 355 time to create 1 rle with old method : 0.0005469322204589844 length of segment : 21 time for calcul the mask position with numpy : 0.00010418891906738281 nb_pixel_total : 182 time to create 1 rle with old method : 0.0005035400390625 length of segment : 20 time for calcul the mask position with numpy : 5.888938903808594e-05 nb_pixel_total : 199 time to create 1 rle with old method : 0.0005750656127929688 length of segment : 22 time for calcul the mask position with numpy : 6.0558319091796875e-05 nb_pixel_total : 236 time to create 1 rle with old method : 0.0007033348083496094 length of segment : 12 time for calcul the mask position with numpy : 5.7220458984375e-05 nb_pixel_total : 641 time to create 1 rle with old method : 0.0008425712585449219 length of segment : 52 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: 147.22109 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 8 time for calcul the mask position with numpy : 5.53131103515625e-05 nb_pixel_total : 232 time to create 1 rle with old method : 0.0006122589111328125 length of segment : 18 time for calcul the mask position with numpy : 5.650520324707031e-05 nb_pixel_total : 267 time to create 1 rle with old method : 0.0005688667297363281 length of segment : 27 time for calcul the mask position with numpy : 5.0067901611328125e-05 nb_pixel_total : 220 time to create 1 rle with old method : 0.0004737377166748047 length of segment : 13 time for calcul the mask position with numpy : 0.00010347366333007812 nb_pixel_total : 965 time to create 1 rle with old method : 0.002033233642578125 length of segment : 41 time for calcul the mask position with numpy : 9.775161743164062e-05 nb_pixel_total : 172 time to create 1 rle with old method : 0.0004475116729736328 length of segment : 37 time for calcul the mask position with numpy : 7.653236389160156e-05 nb_pixel_total : 205 time to create 1 rle with old method : 0.0005137920379638672 length of segment : 24 time for calcul the mask position with numpy : 5.316734313964844e-05 nb_pixel_total : 127 time to create 1 rle with old method : 0.0003719329833984375 length of segment : 17 time for calcul the mask position with numpy : 6.175041198730469e-05 nb_pixel_total : 228 time to create 1 rle with old method : 0.0004584789276123047 length of segment : 22 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: 128.91250 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 2 time for calcul the mask position with numpy : 8.225440979003906e-05 nb_pixel_total : 120 time to create 1 rle with old method : 0.0003604888916015625 length of segment : 14 time for calcul the mask position with numpy : 0.0006103515625 nb_pixel_total : 30709 time to create 1 rle with old method : 0.06244969367980957 length of segment : 235 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.84063 max: 148.83437 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.14984130859375e-05 nb_pixel_total : 424 time to create 1 rle with old method : 0.0007295608520507812 length of segment : 30 time for calcul the mask position with numpy : 5.078315734863281e-05 nb_pixel_total : 924 time to create 1 rle with old method : 0.0015044212341308594 length of segment : 38 time for calcul the mask position with numpy : 3.814697265625e-05 nb_pixel_total : 119 time to create 1 rle with old method : 0.00024771690368652344 length of segment : 21 time for calcul the mask position with numpy : 8.58306884765625e-05 nb_pixel_total : 1389 time to create 1 rle with old method : 0.0020856857299804688 length of segment : 85 time for calcul the mask position with numpy : 5.745887756347656e-05 nb_pixel_total : 885 time to create 1 rle with old method : 0.0013875961303710938 length of segment : 32 time for calcul the mask position with numpy : 3.075599670410156e-05 nb_pixel_total : 21 time to create 1 rle with old method : 7.605552673339844e-05 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.27031 max: 151.10000 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.412101745605469e-05 nb_pixel_total : 296 time to create 1 rle with old method : 0.0005490779876708984 length of segment : 44 time for calcul the mask position with numpy : 4.458427429199219e-05 nb_pixel_total : 401 time to create 1 rle with old method : 0.0005214214324951172 length of segment : 36 time for calcul the mask position with numpy : 5.626678466796875e-05 nb_pixel_total : 701 time to create 1 rle with old method : 0.0011587142944335938 length of segment : 48 time for calcul the mask position with numpy : 5.054473876953125e-05 nb_pixel_total : 387 time to create 1 rle with old method : 0.0006101131439208984 length of segment : 35 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -119.12188 max: 150.99453 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 1 time for calcul the mask position with numpy : 4.553794860839844e-05 nb_pixel_total : 474 time to create 1 rle with old method : 0.0006921291351318359 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: -103.90000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 0 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: 148.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 : 0.00010418891906738281 nb_pixel_total : 1842 time to create 1 rle with old method : 0.0035877227783203125 length of segment : 158 time for calcul the mask position with numpy : 5.1975250244140625e-05 nb_pixel_total : 219 time to create 1 rle with old method : 0.00048351287841796875 length of segment : 23 time for calcul the mask position with numpy : 5.555152893066406e-05 nb_pixel_total : 497 time to create 1 rle with old method : 0.0010988712310791016 length of segment : 20 time for calcul the mask position with numpy : 5.7697296142578125e-05 nb_pixel_total : 477 time to create 1 rle with old method : 0.0009272098541259766 length of segment : 69 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 343 time to create 1 rle with old method : 0.0007154941558837891 length of segment : 43 time for calcul the mask position with numpy : 0.0009174346923828125 nb_pixel_total : 61392 time to create 1 rle with old method : 0.11310100555419922 length of segment : 335 Processing 1 images image shape: (400, 400, 3) min: 19.00000 max: 214.00000 molded_images shape: (1, 640, 640, 3) min: -81.60234 max: 86.62578 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: -115.87578 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 12 time for calcul the mask position with numpy : 9.369850158691406e-05 nb_pixel_total : 152 time to create 1 rle with old method : 0.0003955364227294922 length of segment : 12 time for calcul the mask position with numpy : 9.918212890625e-05 nb_pixel_total : 1772 time to create 1 rle with old method : 0.0036423206329345703 length of segment : 41 time for calcul the mask position with numpy : 7.915496826171875e-05 nb_pixel_total : 734 time to create 1 rle with old method : 0.001695394515991211 length of segment : 36 time for calcul the mask position with numpy : 6.556510925292969e-05 nb_pixel_total : 506 time to create 1 rle with old method : 0.0011756420135498047 length of segment : 19 time for calcul the mask position with numpy : 4.9114227294921875e-05 nb_pixel_total : 138 time to create 1 rle with old method : 0.0003402233123779297 length of segment : 13 time for calcul the mask position with numpy : 4.649162292480469e-05 nb_pixel_total : 71 time to create 1 rle with old method : 0.0002009868621826172 length of segment : 10 time for calcul the mask position with numpy : 4.696846008300781e-05 nb_pixel_total : 126 time to create 1 rle with old method : 0.000316619873046875 length of segment : 13 time for calcul the mask position with numpy : 4.76837158203125e-05 nb_pixel_total : 95 time to create 1 rle with old method : 0.0002868175506591797 length of segment : 22 time for calcul the mask position with numpy : 4.935264587402344e-05 nb_pixel_total : 197 time to create 1 rle with old method : 0.0004627704620361328 length of segment : 14 time for calcul the mask position with numpy : 7.224082946777344e-05 nb_pixel_total : 1054 time to create 1 rle with old method : 0.002153635025024414 length of segment : 34 time for calcul the mask position with numpy : 6.699562072753906e-05 nb_pixel_total : 957 time to create 1 rle with old method : 0.0019669532775878906 length of segment : 37 time for calcul the mask position with numpy : 7.271766662597656e-05 nb_pixel_total : 1045 time to create 1 rle with old method : 0.002142667770385742 length of segment : 38 Processing 1 images image shape: (400, 400, 3) min: 3.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -109.25859 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 10 time for calcul the mask position with numpy : 5.698204040527344e-05 nb_pixel_total : 194 time to create 1 rle with old method : 0.0003597736358642578 length of segment : 14 time for calcul the mask position with numpy : 4.5299530029296875e-05 nb_pixel_total : 751 time to create 1 rle with old method : 0.0010192394256591797 length of segment : 34 time for calcul the mask position with numpy : 0.00034499168395996094 nb_pixel_total : 24378 time to create 1 rle with old method : 0.03106522560119629 length of segment : 212 time for calcul the mask position with numpy : 0.0006229877471923828 nb_pixel_total : 28784 time to create 1 rle with old method : 0.0423274040222168 length of segment : 236 time for calcul the mask position with numpy : 7.963180541992188e-05 nb_pixel_total : 235 time to create 1 rle with old method : 0.0006403923034667969 length of segment : 17 time for calcul the mask position with numpy : 7.772445678710938e-05 nb_pixel_total : 340 time to create 1 rle with old method : 0.0006160736083984375 length of segment : 29 time for calcul the mask position with numpy : 3.552436828613281e-05 nb_pixel_total : 283 time to create 1 rle with old method : 0.0003979206085205078 length of segment : 20 time for calcul the mask position with numpy : 7.05718994140625e-05 nb_pixel_total : 236 time to create 1 rle with old method : 0.00042748451232910156 length of segment : 24 time for calcul the mask position with numpy : 4.124641418457031e-05 nb_pixel_total : 265 time to create 1 rle with old method : 0.0004105567932128906 length of segment : 19 time for calcul the mask position with numpy : 0.0005557537078857422 nb_pixel_total : 27494 time to create 1 rle with old method : 0.033082008361816406 length of segment : 249 Processing 1 images image shape: (400, 400, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -111.98516 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 10 time for calcul the mask position with numpy : 8.106231689453125e-05 nb_pixel_total : 2412 time to create 1 rle with old method : 0.003053426742553711 length of segment : 84 time for calcul the mask position with numpy : 7.033348083496094e-05 nb_pixel_total : 1712 time to create 1 rle with old method : 0.002209901809692383 length of segment : 39 time for calcul the mask position with numpy : 3.647804260253906e-05 nb_pixel_total : 243 time to create 1 rle with old method : 0.000396728515625 length of segment : 14 time for calcul the mask position with numpy : 9.34600830078125e-05 nb_pixel_total : 1979 time to create 1 rle with old method : 0.0025339126586914062 length of segment : 84 time for calcul the mask position with numpy : 3.838539123535156e-05 nb_pixel_total : 251 time to create 1 rle with old method : 0.0003781318664550781 length of segment : 24 time for calcul the mask position with numpy : 0.00010919570922851562 nb_pixel_total : 1302 time to create 1 rle with old method : 0.0015943050384521484 length of segment : 122 time for calcul the mask position with numpy : 6.127357482910156e-05 nb_pixel_total : 1764 time to create 1 rle with old method : 0.0022983551025390625 length of segment : 47 time for calcul the mask position with numpy : 3.62396240234375e-05 nb_pixel_total : 297 time to create 1 rle with old method : 0.0004520416259765625 length of segment : 16 time for calcul the mask position with numpy : 3.218650817871094e-05 nb_pixel_total : 129 time to create 1 rle with old method : 0.00020360946655273438 length of segment : 16 time for calcul the mask position with numpy : 0.0006222724914550781 nb_pixel_total : 28073 time to create 1 rle with old method : 0.03587698936462402 length of segment : 545 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: 149.71719 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 9 time for calcul the mask position with numpy : 6.842613220214844e-05 nb_pixel_total : 1670 time to create 1 rle with old method : 0.0024635791778564453 length of segment : 83 time for calcul the mask position with numpy : 0.0002455711364746094 nb_pixel_total : 4187 time to create 1 rle with old method : 0.0057141780853271484 length of segment : 195 time for calcul the mask position with numpy : 0.00021386146545410156 nb_pixel_total : 59 time to create 1 rle with old method : 0.0001366138458251953 length of segment : 24 time for calcul the mask position with numpy : 8.916854858398438e-05 nb_pixel_total : 401 time to create 1 rle with old method : 0.0006163120269775391 length of segment : 59 time for calcul the mask position with numpy : 4.3392181396484375e-05 nb_pixel_total : 292 time to create 1 rle with old method : 0.00046896934509277344 length of segment : 40 time for calcul the mask position with numpy : 5.936622619628906e-05 nb_pixel_total : 1609 time to create 1 rle with old method : 0.0021703243255615234 length of segment : 78 time for calcul the mask position with numpy : 7.2479248046875e-05 nb_pixel_total : 888 time to create 1 rle with old method : 0.001308441162109375 length of segment : 71 time for calcul the mask position with numpy : 3.62396240234375e-05 nb_pixel_total : 100 time to create 1 rle with old method : 0.00015115737915039062 length of segment : 29 time for calcul the mask position with numpy : 5.1975250244140625e-05 nb_pixel_total : 429 time to create 1 rle with old method : 0.0005919933319091797 length of segment : 25 Processing 1 images image shape: (280, 400, 3) min: 8.00000 max: 216.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 85.89922 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 2 time for calcul the mask position with numpy : 0.0010263919830322266 nb_pixel_total : 106688 time to create 1 rle with old method : 0.12462091445922852 length of segment : 281 time for calcul the mask position with numpy : 6.532669067382812e-05 nb_pixel_total : 627 time to create 1 rle with old method : 0.0008490085601806641 length of segment : 51 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: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 16 time for calcul the mask position with numpy : 0.00016188621520996094 nb_pixel_total : 5605 time to create 1 rle with old method : 0.006962776184082031 length of segment : 84 time for calcul the mask position with numpy : 7.176399230957031e-05 nb_pixel_total : 100 time to create 1 rle with old method : 0.00021958351135253906 length of segment : 15 time for calcul the mask position with numpy : 3.981590270996094e-05 nb_pixel_total : 146 time to create 1 rle with old method : 0.0002384185791015625 length of segment : 13 time for calcul the mask position with numpy : 5.173683166503906e-05 nb_pixel_total : 604 time to create 1 rle with old method : 0.0008656978607177734 length of segment : 32 time for calcul the mask position with numpy : 6.532669067382812e-05 nb_pixel_total : 611 time to create 1 rle with old method : 0.000997781753540039 length of segment : 24 time for calcul the mask position with numpy : 5.602836608886719e-05 nb_pixel_total : 842 time to create 1 rle with old method : 0.0014569759368896484 length of segment : 34 time for calcul the mask position with numpy : 0.00014829635620117188 nb_pixel_total : 4026 time to create 1 rle with old method : 0.004891157150268555 length of segment : 192 time for calcul the mask position with numpy : 5.91278076171875e-05 nb_pixel_total : 180 time to create 1 rle with old method : 0.00028252601623535156 length of segment : 22 time for calcul the mask position with numpy : 4.220008850097656e-05 nb_pixel_total : 357 time to create 1 rle with old method : 0.0006368160247802734 length of segment : 29 time for calcul the mask position with numpy : 9.34600830078125e-05 nb_pixel_total : 1628 time to create 1 rle with old method : 0.0022230148315429688 length of segment : 40 time for calcul the mask position with numpy : 8.7738037109375e-05 nb_pixel_total : 2509 time to create 1 rle with old method : 0.003364086151123047 length of segment : 90 time for calcul the mask position with numpy : 8.249282836914062e-05 nb_pixel_total : 1955 time to create 1 rle with old method : 0.0024805068969726562 length of segment : 50 time for calcul the mask position with numpy : 3.552436828613281e-05 nb_pixel_total : 76 time to create 1 rle with old method : 0.0001277923583984375 length of segment : 17 time for calcul the mask position with numpy : 0.00012636184692382812 nb_pixel_total : 5616 time to create 1 rle with old method : 0.006932258605957031 length of segment : 83 time for calcul the mask position with numpy : 5.14984130859375e-05 nb_pixel_total : 368 time to create 1 rle with old method : 0.0005908012390136719 length of segment : 25 time for calcul the mask position with numpy : 0.00012946128845214844 nb_pixel_total : 1672 time to create 1 rle with old method : 0.004193782806396484 length of segment : 39 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: 149.83828 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 14 time for calcul the mask position with numpy : 6.437301635742188e-05 nb_pixel_total : 380 time to create 1 rle with old method : 0.0006012916564941406 length of segment : 20 time for calcul the mask position with numpy : 6.175041198730469e-05 nb_pixel_total : 330 time to create 1 rle with old method : 0.0004858970642089844 length of segment : 29 time for calcul the mask position with numpy : 7.82012939453125e-05 nb_pixel_total : 526 time to create 1 rle with old method : 0.0007398128509521484 length of segment : 32 time for calcul the mask position with numpy : 6.29425048828125e-05 nb_pixel_total : 782 time to create 1 rle with old method : 0.0010941028594970703 length of segment : 27 time for calcul the mask position with numpy : 5.245208740234375e-05 nb_pixel_total : 559 time to create 1 rle with old method : 0.0008742809295654297 length of segment : 22 time for calcul the mask position with numpy : 4.601478576660156e-05 nb_pixel_total : 269 time to create 1 rle with old method : 0.0004031658172607422 length of segment : 18 time for calcul the mask position with numpy : 4.3392181396484375e-05 nb_pixel_total : 270 time to create 1 rle with old method : 0.00037479400634765625 length of segment : 26 time for calcul the mask position with numpy : 6.437301635742188e-05 nb_pixel_total : 1088 time to create 1 rle with old method : 0.0014104843139648438 length of segment : 87 time for calcul the mask position with numpy : 4.982948303222656e-05 nb_pixel_total : 257 time to create 1 rle with old method : 0.00034928321838378906 length of segment : 22 time for calcul the mask position with numpy : 3.9577484130859375e-05 nb_pixel_total : 308 time to create 1 rle with old method : 0.0004718303680419922 length of segment : 16 time for calcul the mask position with numpy : 7.271766662597656e-05 nb_pixel_total : 2302 time to create 1 rle with old method : 0.0028824806213378906 length of segment : 69 time for calcul the mask position with numpy : 4.6253204345703125e-05 nb_pixel_total : 84 time to create 1 rle with old method : 0.00018835067749023438 length of segment : 9 time for calcul the mask position with numpy : 0.0001068115234375 nb_pixel_total : 3846 time to create 1 rle with old method : 0.004884004592895508 length of segment : 72 time for calcul the mask position with numpy : 4.124641418457031e-05 nb_pixel_total : 164 time to create 1 rle with old method : 0.00026798248291015625 length of segment : 16 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.81094 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 9 time for calcul the mask position with numpy : 3.910064697265625e-05 nb_pixel_total : 240 time to create 1 rle with old method : 0.0004448890686035156 length of segment : 14 time for calcul the mask position with numpy : 3.5762786865234375e-05 nb_pixel_total : 184 time to create 1 rle with old method : 0.00036334991455078125 length of segment : 15 time for calcul the mask position with numpy : 0.0002448558807373047 nb_pixel_total : 11042 time to create 1 rle with old method : 0.013835430145263672 length of segment : 246 time for calcul the mask position with numpy : 4.57763671875e-05 nb_pixel_total : 370 time to create 1 rle with old method : 0.0006642341613769531 length of segment : 26 time for calcul the mask position with numpy : 5.984306335449219e-05 nb_pixel_total : 932 time to create 1 rle with old method : 0.001458883285522461 length of segment : 53 time for calcul the mask position with numpy : 4.482269287109375e-05 nb_pixel_total : 117 time to create 1 rle with old method : 0.00022673606872558594 length of segment : 22 time for calcul the mask position with numpy : 0.00013589859008789062 nb_pixel_total : 2009 time to create 1 rle with old method : 0.0033621788024902344 length of segment : 47 time for calcul the mask position with numpy : 5.91278076171875e-05 nb_pixel_total : 586 time to create 1 rle with old method : 0.0008187294006347656 length of segment : 46 time for calcul the mask position with numpy : 6.604194641113281e-05 nb_pixel_total : 2015 time to create 1 rle with old method : 0.0028231143951416016 length of segment : 46 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: 141.35000 image_metas shape: (1, 17) min: 0.00000 max: 640.00000 nb d'objets trouves : 6 time for calcul the mask position with numpy : 4.8160552978515625e-05 nb_pixel_total : 781 time to create 1 rle with old method : 0.001188516616821289 length of segment : 33 time for calcul the mask position with numpy : 3.314018249511719e-05 nb_pixel_total : 157 time to create 1 rle with old method : 0.0002543926239013672 length of segment : 13 time for calcul the mask position with numpy : 0.00016808509826660156 nb_pixel_total : 8445 time to create 1 rle with old method : 0.011472225189208984 length of segment : 186 time for calcul the mask position with numpy : 4.100799560546875e-05 nb_pixel_total : 155 time to create 1 rle with old method : 0.00025177001953125 length of segment : 19 time for calcul the mask position with numpy : 5.054473876953125e-05 nb_pixel_total : 720 time to create 1 rle with old method : 0.0009167194366455078 length of segment : 71 time for calcul the mask position with numpy : 3.4332275390625e-05 nb_pixel_total : 206 time to create 1 rle with old method : 0.00028586387634277344 length of segment : 21 Detection mask done ! Trying to reset tf kernel 876205 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 9 tf kernel not reseted sub process len(results) : 196 len(list_Values) 196 None max_time_sub_proc : 3600 parent process len(results) : 0 len(list_Values) 196 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 : 5160 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 196 chid ids of type : 4228 Number RLEs to save : 12408 save missing photos in datou_result : time spend for datou_step_exec : 26.875494480133057 time spend to save output : 2.4346365928649902 total time spend for step 1 : 29.310131072998047 step2:brightness Fri Feb 7 01:20:59 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/1738887629_875688_1335326594_871d11b4b522a49f2735dc3694716420.jpg treat image : temp/1738887629_875688_1335326450_883b75641dcef5cf40ac3c5e8ac3df1a.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.011466741561889648 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.3366978168487549 save missing photos in datou_result : time spend for datou_step_exec : 0.5343778133392334 time spend to save output : 0.35292530059814453 total time spend for step 2 : 0.8873031139373779 step3:blur_detection Fri Feb 7 01:21:00 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/1738887629_875688_1335326594_871d11b4b522a49f2735dc3694716420.jpg resize: (1080, 1920) 1335326594 -7.761100609889072 treat image : temp/1738887629_875688_1335326450_883b75641dcef5cf40ac3c5e8ac3df1a.jpg resize: (1080, 1920) 1335326450 -7.813762315279938 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.03298330307006836 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.04063892364501953 save missing photos in datou_result : time spend for datou_step_exec : 1.7199931144714355 time spend to save output : 0.08582663536071777 total time spend for step 3 : 1.8058197498321533 step4:rle_unique_nms_with_priority Fri Feb 7 01:21:01 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 196 chid ids of type : 4228 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++nb_obj : 91 nb_hashtags : 8 time to prepare the origin masks : 1.1146440505981445 time for calcul the mask position with numpy : 0.028718948364257812 nb_pixel_total : 1768597 time to create 1 rle with new method : 0.05488324165344238 time for calcul the mask position with numpy : 0.008732080459594727 nb_pixel_total : 1725 time to create 1 rle with old method : 0.002076387405395508 time for calcul the mask position with numpy : 0.008984804153442383 nb_pixel_total : 826 time to create 1 rle with old method : 0.001020669937133789 time for calcul the mask position with numpy : 0.008639097213745117 nb_pixel_total : 395 time to create 1 rle with old method : 0.0004932880401611328 time for calcul the mask position with numpy : 0.009083032608032227 nb_pixel_total : 59 time to create 1 rle with old method : 0.000125885009765625 time for calcul the mask position with numpy : 0.008640289306640625 nb_pixel_total : 789 time to create 1 rle with old method : 0.000995635986328125 time for calcul the mask position with numpy : 0.00913238525390625 nb_pixel_total : 224 time to create 1 rle with old method : 0.0003020763397216797 time for calcul the mask position with numpy : 0.008626461029052734 nb_pixel_total : 71 time to create 1 rle with old method : 0.00010228157043457031 time for calcul the mask position with numpy : 0.00864720344543457 nb_pixel_total : 14 time to create 1 rle with old method : 3.504753112792969e-05 time for calcul the mask position with numpy : 0.00861048698425293 nb_pixel_total : 8549 time to create 1 rle with old method : 0.009813070297241211 time for calcul the mask position with numpy : 0.008384227752685547 nb_pixel_total : 352 time to create 1 rle with old method : 0.0004291534423828125 time for calcul the mask position with numpy : 0.008495569229125977 nb_pixel_total : 296 time to create 1 rle with old method : 0.0003604888916015625 time for calcul the mask position with numpy : 0.008437633514404297 nb_pixel_total : 362 time to create 1 rle with old method : 0.00043463706970214844 time for calcul the mask position with numpy : 0.008378744125366211 nb_pixel_total : 1247 time to create 1 rle with old method : 0.0014581680297851562 time for calcul the mask position with numpy : 0.008362770080566406 nb_pixel_total : 563 time to create 1 rle with old method : 0.0007984638214111328 time for calcul the mask position with numpy : 0.008506298065185547 nb_pixel_total : 218 time to create 1 rle with old method : 0.0002689361572265625 time for calcul the mask position with numpy : 0.008363962173461914 nb_pixel_total : 479 time to create 1 rle with old method : 0.0007271766662597656 time for calcul the mask position with numpy : 0.009660720825195312 nb_pixel_total : 21 time to create 1 rle with old method : 3.838539123535156e-05 time for calcul the mask position with numpy : 0.008374929428100586 nb_pixel_total : 131 time to create 1 rle with old method : 0.00016307830810546875 time for calcul the mask position with numpy : 0.008415699005126953 nb_pixel_total : 2336 time to create 1 rle with old method : 0.002782583236694336 time for calcul the mask position with numpy : 0.008382797241210938 nb_pixel_total : 486 time to create 1 rle with old method : 0.0005853176116943359 time for calcul the mask position with numpy : 0.008440256118774414 nb_pixel_total : 556 time to create 1 rle with old method : 0.0006840229034423828 time for calcul the mask position with numpy : 0.008454084396362305 nb_pixel_total : 724 time to create 1 rle with old method : 0.0008683204650878906 time for calcul the mask position with numpy : 0.00836181640625 nb_pixel_total : 760 time to create 1 rle with old method : 0.0008783340454101562 time for calcul the mask position with numpy : 0.008387327194213867 nb_pixel_total : 3058 time to create 1 rle with old method : 0.0035750865936279297 time for calcul the mask position with numpy : 0.008971691131591797 nb_pixel_total : 32061 time to create 1 rle with old method : 0.03913450241088867 time for calcul the mask position with numpy : 0.008910655975341797 nb_pixel_total : 27544 time to create 1 rle with old method : 0.035830020904541016 time for calcul the mask position with numpy : 0.009361982345581055 nb_pixel_total : 2838 time to create 1 rle with old method : 0.0037109851837158203 time for calcul the mask position with numpy : 0.009124040603637695 nb_pixel_total : 8677 time to create 1 rle with old method : 0.01065516471862793 time for calcul the mask position with numpy : 0.009122133255004883 nb_pixel_total : 140 time to create 1 rle with old method : 0.00018858909606933594 time for calcul the mask position with numpy : 0.008430242538452148 nb_pixel_total : 1409 time to create 1 rle with old method : 0.0015919208526611328 time for calcul the mask position with numpy : 0.008448362350463867 nb_pixel_total : 70 time to create 1 rle with old method : 0.00010538101196289062 time for calcul the mask position with numpy : 0.008399009704589844 nb_pixel_total : 60 time to create 1 rle with old method : 0.00010824203491210938 time for calcul the mask position with numpy : 0.008426189422607422 nb_pixel_total : 1167 time to create 1 rle with old method : 0.0013282299041748047 time for calcul the mask position with numpy : 0.008424997329711914 nb_pixel_total : 23090 time to create 1 rle with old method : 0.025991201400756836 time for calcul the mask position with numpy : 0.008409500122070312 nb_pixel_total : 60 time to create 1 rle with old method : 8.678436279296875e-05 time for calcul the mask position with numpy : 0.008305788040161133 nb_pixel_total : 3114 time to create 1 rle with old method : 0.003526926040649414 time for calcul the mask position with numpy : 0.00828099250793457 nb_pixel_total : 2804 time to create 1 rle with old method : 0.003188610076904297 time for calcul the mask position with numpy : 0.008320331573486328 nb_pixel_total : 1537 time to create 1 rle with old method : 0.00183868408203125 time for calcul the mask position with numpy : 0.008386373519897461 nb_pixel_total : 1925 time to create 1 rle with old method : 0.0023131370544433594 time for calcul the mask position with numpy : 0.008376598358154297 nb_pixel_total : 57 time to create 1 rle with old method : 0.00011873245239257812 time for calcul the mask position with numpy : 0.008353710174560547 nb_pixel_total : 1919 time to create 1 rle with old method : 0.0021753311157226562 time for calcul the mask position with numpy : 0.00840306282043457 nb_pixel_total : 322 time to create 1 rle with old method : 0.0003952980041503906 time for calcul the mask position with numpy : 0.008383750915527344 nb_pixel_total : 233 time to create 1 rle with old method : 0.0003275871276855469 time for calcul the mask position with numpy : 0.008419513702392578 nb_pixel_total : 858 time to create 1 rle with old method : 0.0010251998901367188 time for calcul the mask position with numpy : 0.008357048034667969 nb_pixel_total : 5176 time to create 1 rle with old method : 0.006144285202026367 time for calcul the mask position with numpy : 0.008533954620361328 nb_pixel_total : 144 time to create 1 rle with old method : 0.00020122528076171875 time for calcul the mask position with numpy : 0.010307073593139648 nb_pixel_total : 67 time to create 1 rle with old method : 0.00010657310485839844 time for calcul the mask position with numpy : 0.008455038070678711 nb_pixel_total : 141 time to create 1 rle with old method : 0.00022149085998535156 time for calcul the mask position with numpy : 0.008488655090332031 nb_pixel_total : 626 time to create 1 rle with old method : 0.0007572174072265625 time for calcul the mask position with numpy : 0.009227514266967773 nb_pixel_total : 1656 time to create 1 rle with old method : 0.002213716506958008 time for calcul the mask position with numpy : 0.0084991455078125 nb_pixel_total : 48 time to create 1 rle with old method : 0.00010776519775390625 time for calcul the mask position with numpy : 0.008407831192016602 nb_pixel_total : 175 time to create 1 rle with old method : 0.0002143383026123047 time for calcul the mask position with numpy : 0.008529901504516602 nb_pixel_total : 167 time to create 1 rle with old method : 0.0002429485321044922 time for calcul the mask position with numpy : 0.008762598037719727 nb_pixel_total : 7 time to create 1 rle with old method : 1.9311904907226562e-05 time for calcul the mask position with numpy : 0.008863210678100586 nb_pixel_total : 1099 time to create 1 rle with old method : 0.0012998580932617188 time for calcul the mask position with numpy : 0.00840616226196289 nb_pixel_total : 138 time to create 1 rle with old method : 0.0001785755157470703 time for calcul the mask position with numpy : 0.00873708724975586 nb_pixel_total : 338 time to create 1 rle with old method : 0.00042128562927246094 time for calcul the mask position with numpy : 0.008421659469604492 nb_pixel_total : 514 time to create 1 rle with old method : 0.0006206035614013672 time for calcul the mask position with numpy : 0.008420705795288086 nb_pixel_total : 73 time to create 1 rle with old method : 0.00010466575622558594 time for calcul the mask position with numpy : 0.008419275283813477 nb_pixel_total : 601 time to create 1 rle with old method : 0.0007979869842529297 time for calcul the mask position with numpy : 0.008983373641967773 nb_pixel_total : 105864 time to create 1 rle with old method : 0.11718058586120605 time for calcul the mask position with numpy : 0.00847768783569336 nb_pixel_total : 1673 time to create 1 rle with old method : 0.0018897056579589844 time for calcul the mask position with numpy : 0.008470773696899414 nb_pixel_total : 267 time to create 1 rle with old method : 0.0003426074981689453 time for calcul the mask position with numpy : 0.008393287658691406 nb_pixel_total : 641 time to create 1 rle with old method : 0.0007691383361816406 time for calcul the mask position with numpy : 0.008450031280517578 nb_pixel_total : 1418 time to create 1 rle with old method : 0.0016300678253173828 time for calcul the mask position with numpy : 0.010254621505737305 nb_pixel_total : 428 time to create 1 rle with old method : 0.0005385875701904297 time for calcul the mask position with numpy : 0.008527994155883789 nb_pixel_total : 30709 time to create 1 rle with old method : 0.034087419509887695 time for calcul the mask position with numpy : 0.008417844772338867 nb_pixel_total : 608 time to create 1 rle with old method : 0.0007157325744628906 time for calcul the mask position with numpy : 0.008515119552612305 nb_pixel_total : 179 time to create 1 rle with old method : 0.00024008750915527344 time for calcul the mask position with numpy : 0.008411169052124023 nb_pixel_total : 297 time to create 1 rle with old method : 0.00036263465881347656 time for calcul the mask position with numpy : 0.00866842269897461 nb_pixel_total : 604 time to create 1 rle with old method : 0.0007460117340087891 time for calcul the mask position with numpy : 0.00836491584777832 nb_pixel_total : 1116 time to create 1 rle with old method : 0.001322031021118164 time for calcul the mask position with numpy : 0.008362054824829102 nb_pixel_total : 89 time to create 1 rle with old method : 0.00011420249938964844 time for calcul the mask position with numpy : 0.008389472961425781 nb_pixel_total : 89 time to create 1 rle with old method : 0.00012230873107910156 time for calcul the mask position with numpy : 0.00838470458984375 nb_pixel_total : 232 time to create 1 rle with old method : 0.0002868175506591797 time for calcul the mask position with numpy : 0.008376598358154297 nb_pixel_total : 172 time to create 1 rle with old method : 0.00023102760314941406 time for calcul the mask position with numpy : 0.00842738151550293 nb_pixel_total : 821 time to create 1 rle with old method : 0.0009982585906982422 time for calcul the mask position with numpy : 0.008412837982177734 nb_pixel_total : 120 time to create 1 rle with old method : 0.00015211105346679688 time for calcul the mask position with numpy : 0.008375167846679688 nb_pixel_total : 2107 time to create 1 rle with old method : 0.002450227737426758 time for calcul the mask position with numpy : 0.008404016494750977 nb_pixel_total : 1609 time to create 1 rle with old method : 0.001886129379272461 time for calcul the mask position with numpy : 0.008401632308959961 nb_pixel_total : 220 time to create 1 rle with old method : 0.0002510547637939453 time for calcul the mask position with numpy : 0.008419990539550781 nb_pixel_total : 205 time to create 1 rle with old method : 0.00024890899658203125 time for calcul the mask position with numpy : 0.008440732955932617 nb_pixel_total : 199 time to create 1 rle with old method : 0.00024080276489257812 time for calcul the mask position with numpy : 0.008405685424804688 nb_pixel_total : 5172 time to create 1 rle with old method : 0.005866050720214844 time for calcul the mask position with numpy : 0.008348464965820312 nb_pixel_total : 2740 time to create 1 rle with old method : 0.0032057762145996094 time for calcul the mask position with numpy : 0.008356571197509766 nb_pixel_total : 965 time to create 1 rle with old method : 0.0011372566223144531 time for calcul the mask position with numpy : 0.00836038589477539 nb_pixel_total : 182 time to create 1 rle with old method : 0.0002167224884033203 time for calcul the mask position with numpy : 0.008341789245605469 nb_pixel_total : 590 time to create 1 rle with old method : 0.0007066726684570312 time for calcul the mask position with numpy : 0.008376121520996094 nb_pixel_total : 127 time to create 1 rle with old method : 0.00017547607421875 time for calcul the mask position with numpy : 0.008379936218261719 nb_pixel_total : 228 time to create 1 rle with old method : 0.0002818107604980469 time for calcul the mask position with numpy : 0.008403301239013672 nb_pixel_total : 236 time to create 1 rle with old method : 0.00028777122497558594 create new chi : 1.2266995906829834 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.006827354431152344 batch 1 Loaded 92 chid ids of type : 4230 Number RLEs to save : 12492 TO DO : save crop sub photo not yet done ! save time : 1.6245439052581787 nb_obj : 103 nb_hashtags : 7 time to prepare the origin masks : 2.022547483444214 time for calcul the mask position with numpy : 0.023039817810058594 nb_pixel_total : 1736311 time to create 1 rle with new method : 0.047351837158203125 time for calcul the mask position with numpy : 0.007161378860473633 nb_pixel_total : 1842 time to create 1 rle with old method : 0.0020792484283447266 time for calcul the mask position with numpy : 0.00661468505859375 nb_pixel_total : 61392 time to create 1 rle with old method : 0.06795573234558105 time for calcul the mask position with numpy : 0.006363630294799805 nb_pixel_total : 924 time to create 1 rle with old method : 0.0012009143829345703 time for calcul the mask position with numpy : 0.006028413772583008 nb_pixel_total : 424 time to create 1 rle with old method : 0.0005085468292236328 time for calcul the mask position with numpy : 0.006012439727783203 nb_pixel_total : 387 time to create 1 rle with old method : 0.0004658699035644531 time for calcul the mask position with numpy : 0.006002902984619141 nb_pixel_total : 401 time to create 1 rle with old method : 0.0004773139953613281 time for calcul the mask position with numpy : 0.006047964096069336 nb_pixel_total : 296 time to create 1 rle with old method : 0.000385284423828125 time for calcul the mask position with numpy : 0.00602269172668457 nb_pixel_total : 26 time to create 1 rle with old method : 7.987022399902344e-05 time for calcul the mask position with numpy : 0.005982160568237305 nb_pixel_total : 119 time to create 1 rle with old method : 0.00016117095947265625 time for calcul the mask position with numpy : 0.006003141403198242 nb_pixel_total : 3 time to create 1 rle with old method : 2.7179718017578125e-05 time for calcul the mask position with numpy : 0.005990743637084961 nb_pixel_total : 474 time to create 1 rle with old method : 0.0005943775177001953 time for calcul the mask position with numpy : 0.006045341491699219 nb_pixel_total : 1389 time to create 1 rle with old method : 0.0016617774963378906 time for calcul the mask position with numpy : 0.006368398666381836 nb_pixel_total : 701 time to create 1 rle with old method : 0.0008449554443359375 time for calcul the mask position with numpy : 0.006165981292724609 nb_pixel_total : 219 time to create 1 rle with old method : 0.00027298927307128906 time for calcul the mask position with numpy : 0.007330656051635742 nb_pixel_total : 477 time to create 1 rle with old method : 0.0005540847778320312 time for calcul the mask position with numpy : 0.005969524383544922 nb_pixel_total : 343 time to create 1 rle with old method : 0.0004119873046875 time for calcul the mask position with numpy : 0.006071329116821289 nb_pixel_total : 497 time to create 1 rle with old method : 0.0006124973297119141 time for calcul the mask position with numpy : 0.006104469299316406 nb_pixel_total : 627 time to create 1 rle with old method : 0.0008573532104492188 time for calcul the mask position with numpy : 0.007756710052490234 nb_pixel_total : 28073 time to create 1 rle with old method : 0.03660416603088379 time for calcul the mask position with numpy : 0.007760047912597656 nb_pixel_total : 59 time to create 1 rle with old method : 0.0001380443572998047 time for calcul the mask position with numpy : 0.007899761199951172 nb_pixel_total : 28784 time to create 1 rle with old method : 0.04210042953491211 time for calcul the mask position with numpy : 0.006392240524291992 nb_pixel_total : 677 time to create 1 rle with old method : 0.0008351802825927734 time for calcul the mask position with numpy : 0.006269931793212891 nb_pixel_total : 194 time to create 1 rle with old method : 0.0002536773681640625 time for calcul the mask position with numpy : 0.0060825347900390625 nb_pixel_total : 1979 time to create 1 rle with old method : 0.002263307571411133 time for calcul the mask position with numpy : 0.006119251251220703 nb_pixel_total : 235 time to create 1 rle with old method : 0.00030493736267089844 time for calcul the mask position with numpy : 0.0060939788818359375 nb_pixel_total : 197 time to create 1 rle with old method : 0.00025200843811035156 time for calcul the mask position with numpy : 0.011902809143066406 nb_pixel_total : 20 time to create 1 rle with old method : 6.628036499023438e-05 time for calcul the mask position with numpy : 0.011213064193725586 nb_pixel_total : 1041 time to create 1 rle with old method : 0.0015537738800048828 time for calcul the mask position with numpy : 0.011905193328857422 nb_pixel_total : 13 time to create 1 rle with old method : 4.57763671875e-05 time for calcul the mask position with numpy : 0.01006460189819336 nb_pixel_total : 292 time to create 1 rle with old method : 0.0003871917724609375 time for calcul the mask position with numpy : 0.010153055191040039 nb_pixel_total : 125 time to create 1 rle with old method : 0.00016832351684570312 time for calcul the mask position with numpy : 0.010204315185546875 nb_pixel_total : 24378 time to create 1 rle with old method : 0.027590036392211914 time for calcul the mask position with numpy : 0.010247468948364258 nb_pixel_total : 43 time to create 1 rle with old method : 7.963180541992188e-05 time for calcul the mask position with numpy : 0.010044574737548828 nb_pixel_total : 401 time to create 1 rle with old method : 0.0004930496215820312 time for calcul the mask position with numpy : 0.010119915008544922 nb_pixel_total : 4187 time to create 1 rle with old method : 0.004976511001586914 time for calcul the mask position with numpy : 0.010096311569213867 nb_pixel_total : 429 time to create 1 rle with old method : 0.0005176067352294922 time for calcul the mask position with numpy : 0.010089635848999023 nb_pixel_total : 1772 time to create 1 rle with old method : 0.0021185874938964844 time for calcul the mask position with numpy : 0.010123252868652344 nb_pixel_total : 1302 time to create 1 rle with old method : 0.0015413761138916016 time for calcul the mask position with numpy : 0.008765697479248047 nb_pixel_total : 2412 time to create 1 rle with old method : 0.0027289390563964844 time for calcul the mask position with numpy : 0.006075620651245117 nb_pixel_total : 243 time to create 1 rle with old method : 0.0003261566162109375 time for calcul the mask position with numpy : 0.0060307979583740234 nb_pixel_total : 100 time to create 1 rle with old method : 0.0001361370086669922 time for calcul the mask position with numpy : 0.006018638610839844 nb_pixel_total : 36 time to create 1 rle with old method : 8.130073547363281e-05 time for calcul the mask position with numpy : 0.0060651302337646484 nb_pixel_total : 1670 time to create 1 rle with old method : 0.001981019973754883 time for calcul the mask position with numpy : 0.00606989860534668 nb_pixel_total : 888 time to create 1 rle with old method : 0.0010647773742675781 time for calcul the mask position with numpy : 0.006056070327758789 nb_pixel_total : 251 time to create 1 rle with old method : 0.00031876564025878906 time for calcul the mask position with numpy : 0.006018638610839844 nb_pixel_total : 138 time to create 1 rle with old method : 0.00018358230590820312 time for calcul the mask position with numpy : 0.006054878234863281 nb_pixel_total : 297 time to create 1 rle with old method : 0.0003757476806640625 time for calcul the mask position with numpy : 0.005999088287353516 nb_pixel_total : 76 time to create 1 rle with old method : 0.0001533031463623047 time for calcul the mask position with numpy : 0.006061553955078125 nb_pixel_total : 1712 time to create 1 rle with old method : 0.0019443035125732422 time for calcul the mask position with numpy : 0.006051540374755859 nb_pixel_total : 82 time to create 1 rle with old method : 0.00011944770812988281 time for calcul the mask position with numpy : 0.006062984466552734 nb_pixel_total : 152 time to create 1 rle with old method : 0.0002124309539794922 time for calcul the mask position with numpy : 0.006476402282714844 nb_pixel_total : 734 time to create 1 rle with old method : 0.0008921623229980469 time for calcul the mask position with numpy : 0.006064176559448242 nb_pixel_total : 126 time to create 1 rle with old method : 0.0001728534698486328 time for calcul the mask position with numpy : 0.006009578704833984 nb_pixel_total : 506 time to create 1 rle with old method : 0.0006277561187744141 time for calcul the mask position with numpy : 0.006013393402099609 nb_pixel_total : 71 time to create 1 rle with old method : 0.0001049041748046875 time for calcul the mask position with numpy : 0.0060405731201171875 nb_pixel_total : 1 time to create 1 rle with old method : 2.002716064453125e-05 time for calcul the mask position with numpy : 0.006004810333251953 nb_pixel_total : 604 time to create 1 rle with old method : 0.0007190704345703125 time for calcul the mask position with numpy : 0.0068356990814208984 nb_pixel_total : 106688 time to create 1 rle with old method : 0.11830639839172363 time for calcul the mask position with numpy : 0.0067806243896484375 nb_pixel_total : 50 time to create 1 rle with old method : 0.0001468658447265625 time for calcul the mask position with numpy : 0.007021188735961914 nb_pixel_total : 1628 time to create 1 rle with old method : 0.0019071102142333984 time for calcul the mask position with numpy : 0.006041765213012695 nb_pixel_total : 240 time to create 1 rle with old method : 0.0002994537353515625 time for calcul the mask position with numpy : 0.006083488464355469 nb_pixel_total : 8445 time to create 1 rle with old method : 0.009461641311645508 time for calcul the mask position with numpy : 0.0061795711517333984 nb_pixel_total : 368 time to create 1 rle with old method : 0.0004734992980957031 time for calcul the mask position with numpy : 0.006018638610839844 nb_pixel_total : 270 time to create 1 rle with old method : 0.00033473968505859375 time for calcul the mask position with numpy : 0.006098508834838867 nb_pixel_total : 155 time to create 1 rle with old method : 0.00023102760314941406 time for calcul the mask position with numpy : 0.007085561752319336 nb_pixel_total : 180 time to create 1 rle with old method : 0.00023293495178222656 time for calcul the mask position with numpy : 0.006602048873901367 nb_pixel_total : 611 time to create 1 rle with old method : 0.0007236003875732422 time for calcul the mask position with numpy : 0.006281137466430664 nb_pixel_total : 357 time to create 1 rle with old method : 0.00044536590576171875 time for calcul the mask position with numpy : 0.0061092376708984375 nb_pixel_total : 157 time to create 1 rle with old method : 0.00021648406982421875 time for calcul the mask position with numpy : 0.006044149398803711 nb_pixel_total : 3846 time to create 1 rle with old method : 0.0044269561767578125 time for calcul the mask position with numpy : 0.0061113834381103516 nb_pixel_total : 146 time to create 1 rle with old method : 0.00019550323486328125 time for calcul the mask position with numpy : 0.0060482025146484375 nb_pixel_total : 559 time to create 1 rle with old method : 0.0006964206695556641 time for calcul the mask position with numpy : 0.00607609748840332 nb_pixel_total : 1088 time to create 1 rle with old method : 0.0013246536254882812 time for calcul the mask position with numpy : 0.006087541580200195 nb_pixel_total : 11042 time to create 1 rle with old method : 0.012424468994140625 time for calcul the mask position with numpy : 0.006218671798706055 nb_pixel_total : 782 time to create 1 rle with old method : 0.0009584426879882812 time for calcul the mask position with numpy : 0.006015300750732422 nb_pixel_total : 76 time to create 1 rle with old method : 0.00010514259338378906 time for calcul the mask position with numpy : 0.006015777587890625 nb_pixel_total : 306 time to create 1 rle with old method : 0.00038814544677734375 time for calcul the mask position with numpy : 0.006096839904785156 nb_pixel_total : 380 time to create 1 rle with old method : 0.00047659873962402344 time for calcul the mask position with numpy : 0.006087779998779297 nb_pixel_total : 100 time to create 1 rle with old method : 0.0001342296600341797 time for calcul the mask position with numpy : 0.006078004837036133 nb_pixel_total : 4026 time to create 1 rle with old method : 0.004739046096801758 time for calcul the mask position with numpy : 0.006132602691650391 nb_pixel_total : 206 time to create 1 rle with old method : 0.00025844573974609375 time for calcul the mask position with numpy : 0.0060040950775146484 nb_pixel_total : 842 time to create 1 rle with old method : 0.0009849071502685547 time for calcul the mask position with numpy : 0.006025791168212891 nb_pixel_total : 526 time to create 1 rle with old method : 0.0006229877471923828 time for calcul the mask position with numpy : 0.006119966506958008 nb_pixel_total : 586 time to create 1 rle with old method : 0.0007026195526123047 time for calcul the mask position with numpy : 0.007391691207885742 nb_pixel_total : 1955 time to create 1 rle with old method : 0.0023193359375 time for calcul the mask position with numpy : 0.00608372688293457 nb_pixel_total : 2009 time to create 1 rle with old method : 0.0022954940795898438 time for calcul the mask position with numpy : 0.006125450134277344 nb_pixel_total : 298 time to create 1 rle with old method : 0.00042557716369628906 time for calcul the mask position with numpy : 0.006125450134277344 nb_pixel_total : 370 time to create 1 rle with old method : 0.00044274330139160156 time for calcul the mask position with numpy : 0.006097555160522461 nb_pixel_total : 84 time to create 1 rle with old method : 0.00012612342834472656 time for calcul the mask position with numpy : 0.006102561950683594 nb_pixel_total : 2050 time to create 1 rle with old method : 0.002370119094848633 time for calcul the mask position with numpy : 0.006125211715698242 nb_pixel_total : 330 time to create 1 rle with old method : 0.0004432201385498047 time for calcul the mask position with numpy : 0.0061299800872802734 nb_pixel_total : 781 time to create 1 rle with old method : 0.0009739398956298828 time for calcul the mask position with numpy : 0.008357048034667969 nb_pixel_total : 139 time to create 1 rle with old method : 0.0002605915069580078 time for calcul the mask position with numpy : 0.008371591567993164 nb_pixel_total : 5605 time to create 1 rle with old method : 0.0063321590423583984 time for calcul the mask position with numpy : 0.00923466682434082 nb_pixel_total : 2509 time to create 1 rle with old method : 0.004149675369262695 time for calcul the mask position with numpy : 0.008808612823486328 nb_pixel_total : 932 time to create 1 rle with old method : 0.0014181137084960938 time for calcul the mask position with numpy : 0.010088205337524414 nb_pixel_total : 164 time to create 1 rle with old method : 0.00019550323486328125 time for calcul the mask position with numpy : 0.008350133895874023 nb_pixel_total : 720 time to create 1 rle with old method : 0.0008714199066162109 time for calcul the mask position with numpy : 0.008377790451049805 nb_pixel_total : 269 time to create 1 rle with old method : 0.00032830238342285156 time for calcul the mask position with numpy : 0.00838613510131836 nb_pixel_total : 27 time to create 1 rle with old method : 4.887580871582031e-05 time for calcul the mask position with numpy : 0.008618354797363281 nb_pixel_total : 105 time to create 1 rle with old method : 0.0001494884490966797 time for calcul the mask position with numpy : 0.008356332778930664 nb_pixel_total : 184 time to create 1 rle with old method : 0.00024271011352539062 time for calcul the mask position with numpy : 0.008374691009521484 nb_pixel_total : 257 time to create 1 rle with old method : 0.00031065940856933594 create new chi : 1.2010595798492432 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.0014448165893554688 batch 1 Loaded 104 chid ids of type : 4230 Number RLEs to save : 12245 TO DO : save crop sub photo not yet done ! save time : 2.4046175479888916 map_output_result : {1335326594: (0.0, 'Should be the crop_list due to order', 0.0), 1335326450: (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 [1335326594, 1335326450] Looping around the photos to save general results len do output : 2 /1335326594.Didn't retrieve data . /1335326450.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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.011890888214111328 save_final save missing photos in datou_result : time spend for datou_step_exec : 10.1472909450531 time spend to save output : 0.012209892272949219 total time spend for step 4 : 10.15950083732605 step5:crop_condition Fri Feb 7 01:21:12 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 196 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 ! 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 : 82 About to insert : list_path_to_insert length 82 new photo from crops ! About to upload 82 photos upload in portfolio : 4869462 init cache_photo without model_param we have 82 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1738887674_875688 we have uploaded 82 photos in the portfolio 4869462 time of upload the photos Elapsed time : 22.30496120452881 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 ! map_result returned by crop_photo_return_map_crop : length : 21 About to insert : list_path_to_insert length 21 new photo from crops ! About to upload 21 photos upload in portfolio : 4869462 init cache_photo without model_param we have 21 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1738887696_875688 we have uploaded 21 photos in the portfolio 4869462 time of upload the photos Elapsed time : 4.317737340927124 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 ! 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 : 13 About to insert : list_path_to_insert length 13 new photo from crops ! About to upload 13 photos upload in portfolio : 4869462 init cache_photo without model_param we have 13 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1738887701_875688 we have uploaded 13 photos in the portfolio 4869462 time of upload the photos Elapsed time : 2.998905658721924 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 ! map_result returned by crop_photo_return_map_crop : length : 21 About to insert : list_path_to_insert length 21 new photo from crops ! About to upload 21 photos upload in portfolio : 4869462 init cache_photo without model_param we have 21 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1738887705_875688 we have uploaded 21 photos in the portfolio 4869462 time of upload the photos Elapsed time : 4.522746801376343 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 Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 4869462 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1738887709_875688 we have uploaded 1 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.6040914058685303 we have finished the crop for the class : pet_fonce delete rles for these photos Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1335326594, 1335326450] Looping around the photos to save general results len do output : 138 /1335329929Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329930Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329932Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329933Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329934Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329935Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329936Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329937Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329938Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329939Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329940Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329941Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329942Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329944Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329945Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329946Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329947Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329948Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329949Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329950Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329951Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329952Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329953Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329954Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329955Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329956Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329957Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329958Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329959Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329960Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329961Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329962Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329963Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329964Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329965Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329966Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329967Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329968Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329969Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329970Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329971Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329972Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329973Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329974Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329975Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329976Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329977Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329978Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329979Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329980Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329981Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329982Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329983Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329984Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329985Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329986Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329987Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329988Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329989Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329991Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329993Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329995Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329997Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335329999Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330001Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330003Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330005Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330007Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330009Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330011Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330013Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330015Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330017Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330019Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330021Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330023Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330025Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330029Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330031Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330033Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330034Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330035Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330036Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330037Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330038Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330039Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330040Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330041Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330042Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330043Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330044Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330045Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330046Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330047Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330048Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330049Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330051Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330052Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330053Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330055Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330057Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330059Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330060Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330065Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330066Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330067Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330068Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330069Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330070Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330071Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330072Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330073Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330074Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330075Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330076Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330077Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330083Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330084Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330085Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330086Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330087Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330088Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330089Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330090Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330091Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330092Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330093Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330094Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330095Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330097Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330098Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330099Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330100Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330101Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330102Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330103Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330105Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1335330106Didn'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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 416 time used for this insertion : 0.03303265571594238 save_final save missing photos in datou_result : time spend for datou_step_exec : 38.174344301223755 time spend to save output : 0.036958932876586914 total time spend for step 5 : 38.21130323410034 step6:thcl Fri Feb 7 01:21:50 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.008316516876220703 time to convert the images to numpy array : 0.02834630012512207 time to import caffe and check if the image exist : 0.007813215255737305 time to convert the images to numpy array : 0.034615278244018555 time to import caffe and check if the image exist : 0.012214899063110352 time to convert the images to numpy array : 0.03119206428527832 time to import caffe and check if the image exist : 0.01672506332397461 time to convert the images to numpy array : 0.03070235252380371 time to import caffe and check if the image exist : 0.012439489364624023 time to convert the images to numpy array : 0.03578519821166992 time to import caffe and check if the image exist : 0.01026606559753418 time to convert the images to numpy array : 0.038146257400512695 time to import caffe and check if the image exist : 0.009337902069091797 time to convert the images to numpy array : 0.039826393127441406 time to import caffe and check if the image exist : 0.010506629943847656 time to convert the images to numpy array : 0.03730320930480957 time to import caffe and check if the image exist : 0.012097597122192383 time to convert the images to numpy array : 0.038980960845947266 time to import caffe and check if the image exist : 0.014904022216796875 time to convert the images to numpy array : 0.03774380683898926 total time to convert the images to numpy array : 0.29917311668395996 list photo_ids error: [] list photo_ids correct : [1335330053, 1335330055, 1335330057, 1335330059, 1335330060, 1335330065, 1335330066, 1335330067, 1335330068, 1335330069, 1335330070, 1335330071, 1335330072, 1335330073, 1335329929, 1335329930, 1335329932, 1335329933, 1335329934, 1335329935, 1335329936, 1335329937, 1335329938, 1335329939, 1335329940, 1335329941, 1335329942, 1335329944, 1335330074, 1335330075, 1335330076, 1335330077, 1335330083, 1335330084, 1335330085, 1335330086, 1335330087, 1335330088, 1335330089, 1335330090, 1335330091, 1335330092, 1335329959, 1335329960, 1335329961, 1335329962, 1335329963, 1335329964, 1335329965, 1335329966, 1335329967, 1335329968, 1335329969, 1335329970, 1335329971, 1335329972, 1335330013, 1335330015, 1335330017, 1335330019, 1335330021, 1335330023, 1335330025, 1335330029, 1335330031, 1335330033, 1335330034, 1335330035, 1335330036, 1335330037, 1335330038, 1335330039, 1335330040, 1335330041, 1335330042, 1335330043, 1335330044, 1335330045, 1335330046, 1335330047, 1335330048, 1335330049, 1335330051, 1335330052, 1335329987, 1335329988, 1335329989, 1335329991, 1335329993, 1335329995, 1335329997, 1335329999, 1335330001, 1335330003, 1335330005, 1335330007, 1335330009, 1335330011, 1335330093, 1335330094, 1335330095, 1335330097, 1335330098, 1335330099, 1335330100, 1335330101, 1335330102, 1335330103, 1335330105, 1335330106, 1335329973, 1335329974, 1335329975, 1335329976, 1335329977, 1335329978, 1335329979, 1335329980, 1335329981, 1335329982, 1335329983, 1335329984, 1335329985, 1335329986, 1335329945, 1335329946, 1335329947, 1335329948, 1335329949, 1335329950, 1335329951, 1335329952, 1335329953, 1335329954, 1335329955, 1335329956, 1335329957, 1335329958] number of photos to traite : 138 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 : 10109 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 : 9890 max_wait_temp : 1 max_wait : 0 dict_keys(['pool5', 'prob']) time used to do the prepocess of the images : 0.658254861831665 time used to do the prediction : 0.5617356300354004 save descriptor for thcl : 3237 time to traite the descriptors : 0.8493142127990723 Catched exception ! Connect or reconnect ! storage_type for insertDescriptorsMulti : 3 To insert : 1335330053 To insert : 1335330055 To insert : 1335330057 To insert : 1335330059 To insert : 1335330060 To insert : 1335330065 To insert : 1335330066 To insert : 1335330067 To insert : 1335330068 To insert : 1335330069 To insert : 1335330070 To insert : 1335330071 To insert : 1335330072 To insert : 1335330073 To insert : 1335329929 To insert : 1335329930 To insert : 1335329932 To insert : 1335329933 To insert : 1335329934 To insert : 1335329935 To insert : 1335329936 To insert : 1335329937 To insert : 1335329938 To insert : 1335329939 To insert : 1335329940 To insert : 1335329941 To insert : 1335329942 To insert : 1335329944 To insert : 1335330074 To insert : 1335330075 To insert : 1335330076 To insert : 1335330077 To insert : 1335330083 To insert : 1335330084 To insert : 1335330085 To insert : 1335330086 To insert : 1335330087 To insert : 1335330088 To insert : 1335330089 To insert : 1335330090 To insert : 1335330091 To insert : 1335330092 To insert : 1335329959 To insert : 1335329960 To insert : 1335329961 To insert : 1335329962 To insert : 1335329963 To insert : 1335329964 To insert : 1335329965 To insert : 1335329966 To insert : 1335329967 To insert : 1335329968 To insert : 1335329969 To insert : 1335329970 To insert : 1335329971 To insert : 1335329972 To insert : 1335330013 To insert : 1335330015 To insert : 1335330017 To insert : 1335330019 To insert : 1335330021 To insert : 1335330023 To insert : 1335330025 To insert : 1335330029 To insert : 1335330031 To insert : 1335330033 To insert : 1335330034 To insert : 1335330035 To insert : 1335330036 To insert : 1335330037 To insert : 1335330038 To insert : 1335330039 To insert : 1335330040 To insert : 1335330041 To insert : 1335330042 To insert : 1335330043 To insert : 1335330044 To insert : 1335330045 To insert : 1335330046 To insert : 1335330047 To insert : 1335330048 To insert : 1335330049 To insert : 1335330051 To insert : 1335330052 To insert : 1335329987 To insert : 1335329988 To insert : 1335329989 To insert : 1335329991 To insert : 1335329993 To insert : 1335329995 To insert : 1335329997 To insert : 1335329999 To insert : 1335330001 To insert : 1335330003 To insert : 1335330005 To insert : 1335330007 To insert : 1335330009 To insert : 1335330011 To insert : 1335330093 To insert : 1335330094 To insert : 1335330095 To insert : 1335330097 To insert : 1335330098 To insert : 1335330099 To insert : 1335330100 To insert : 1335330101 To insert : 1335330102 To insert : 1335330103 To insert : 1335330105 To insert : 1335330106 To insert : 1335329973 To insert : 1335329974 To insert : 1335329975 To insert : 1335329976 To insert : 1335329977 To insert : 1335329978 To insert : 1335329979 To insert : 1335329980 To insert : 1335329981 To insert : 1335329982 To insert : 1335329983 To insert : 1335329984 To insert : 1335329985 To insert : 1335329986 To insert : 1335329945 To insert : 1335329946 To insert : 1335329947 To insert : 1335329948 To insert : 1335329949 To insert : 1335329950 To insert : 1335329951 To insert : 1335329952 To insert : 1335329953 To insert : 1335329954 To insert : 1335329955 To insert : 1335329956 To insert : 1335329957 To insert : 1335329958 time to insert the descriptors : 25.162709712982178 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 : 204 time used for this insertion : 0.020607471466064453 save missing photos in datou_result : time spend for datou_step_exec : 31.485257625579834 time spend to save output : 0.06722664833068848 total time spend for step 6 : 31.552484273910522 step7:ventilate_hashtags_in_portfolio Fri Feb 7 01:22:21 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 : 20314474 get user id for portfolio 20314474 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`=20314474 AND mptpi.`type`=4230 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','refus','Film_plastique','autre','pet_clair','pet_fonce','pehd','carton','papier','environnement','Carton','PEHD','PET_fonce','Tetrapak','flou','metal','Papier','PET_clair')) 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`=20314474 AND mptpi.`type`=4230 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','refus','Film_plastique','autre','pet_clair','pet_fonce','pehd','carton','papier','environnement','Carton','PEHD','PET_fonce','Tetrapak','flou','metal','Papier','PET_clair')) 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`=20314474 AND mptpi.`type`=4231 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','refus','Film_plastique','autre','pet_clair','pet_fonce','pehd','carton','papier','environnement','Carton','PEHD','PET_fonce','Tetrapak','flou','metal','Papier','PET_clair')) 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`=20314474 AND mptpi.`type`=4231 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','refus','Film_plastique','autre','pet_clair','pet_fonce','pehd','carton','papier','environnement','Carton','PEHD','PET_fonce','Tetrapak','flou','metal','Papier','PET_clair')) AND mptpi.`min_score`=0.6 To do lien utilise dans velours : https://www.fotonower.com/velours/20314689,20314690,20314691,20314692,20314706,20314701,20314700,20314699,20314705,20314698,20314702,20314703,20314704?tags=mal_croppe,refus,film_plastique,autre,pet_clair,pet_fonce,pehd,carton,papier,environnement,tetrapak,flou,metal&datou_id_consolidate=4235&port_consolidate=20314474 Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1335326594, 1335326450] Looping around the photos to save general results len do output : 1 /20314474. 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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.012558698654174805 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.6311020851135254 time spend to save output : 0.012789011001586914 total time spend for step 7 : 2.6438910961151123 step8:final Fri Feb 7 01:22:24 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 : {1335326594: ('0.2589695579663814',), 1335326450: ('0.2589695579663814',)} new output for save of step final : {1335326594: ('0.2589695579663814',), 1335326450: ('0.2589695579663814',)} [1335326594, 1335326450] Looping around the photos to save general results len do output : 2 /1335326594.Didn't retrieve data . /1335326450.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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.011702299118041992 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.11318254470825195 time spend to save output : 0.011856317520141602 total time spend for step 8 : 0.12503886222839355 step9:velours_tree Fri Feb 7 01:22:24 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 : 20314689,20314690,20314691,20314692,20314706,20314701,20314700,20314699,20314705,20314698,20314702,20314703,20314704 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=20314689 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=20314690 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=20314691 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=20314692 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=20314706 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=20314701 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=20314700 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=20314699 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=20314705 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=20314698 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=20314702 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=20314703 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=20314704 ORDER BY ph.size desc - Loading descriptors... Size : 2048 len(descriptors) : 138 Compute structured hierarchical clustering... ward : AgglomerativeClustering(n_clusters=6) ward.labels_ : [0 3 0 0 0 1 2 0 1 1 4 4 4 4 2 4 4 4 4 0 1 0 2 0 1 1 4 2 0 2 2 2 4 1 2 2 1 0 3 1 0 0 2 0 1 4 5 4 1 2 4 4 0 1 0 2 2 2 0 3 2 4 0 0 2 1 1 2 4 2 0 4 1 4 2 2 2 4 1 0 0 2 3 1 2 2 2 2 4 3 4 3 1 3 2 2 2 2 4 0 2 3 2 5 4 1 0 5 5 5 5 1 2 0 0 0 0 0 3 2 2 3 3 5 5 2 0 0 2 0 3 2 2 5 0 0 3 4] Elapsed time: 0.05057072639465332 graph_id used : 76629 - Beta version, working pretty good on 11-5-16 ! https://www.fotonower.com/velours/20314689,20314690,20314691,20314692,20314706,20314701,20314700,20314699,20314705,20314698,20314702,20314703,20314704?tags=mal_croppe,refus,film_plastique,autre,pet_clair,pet_fonce,pehd,carton,papier,environnement,tetrapak,flou,metal&datou_id_consolidate=4235&port_consolidate=20314474&tree_id=76629 Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : velours_tree we use saveGeneral [1335326594, 1335326450] Looping around the photos to save general results len do output : 1 /20314474Didn'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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.012842178344726562 save_final save missing photos in datou_result : time spend for datou_step_exec : 11.798147678375244 time spend to save output : 0.01320958137512207 total time spend for step 9 : 11.811357259750366 step10:send_mail_cod Fri Feb 7 01:22:36 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 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_P20314474_07-02-2025_01_22_36.pdf 20314671 imagette203146711738887756 20314672 imagette203146721738887756 20314673 imagette203146731738887756 20314674 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 .imagette203146741738887756 20314688 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 .imagette203146881738887757 20314683 change filename to text .imagette203146831738887758 20314682 imagette203146821738887758 20314681 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 .imagette203146811738887758 20314687 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 .imagette203146871738887759 20314684 imagette203146841738887760 20314685 imagette203146851738887760 20314686 imagette203146861738887760 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=20314474 and hashtag_type = 4230 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/20314689,20314690,20314691,20314692,20314706,20314701,20314700,20314699,20314705,20314698,20314702,20314703,20314704?tags=mal_croppe,refus,film_plastique,autre,pet_clair,pet_fonce,pehd,carton,papier,environnement,tetrapak,flou,metal&datou_id_consolidate=4235&port_consolidate=20314474&tree_id=76629 your option no_mail is active, we will not send the real mail to your client args[1335326594] : ((1335326594, -7.761100609889072, 492609224), (1335326594, -0.38051610469166675, 496442774), '0.2589695579663814') apple ((1335326594, -7.761100609889072, 492609224), (1335326594, -0.38051610469166675, 496442774), '0.2589695579663814') We are sending mail with results at cod@fotonower.com args[1335326450] : ((1335326450, -7.813762315279938, 492609224), (1335326450, -0.35459254815886443, 496442774), '0.2589695579663814') apple ((1335326450, -7.813762315279938, 492609224), (1335326450, -0.35459254815886443, 496442774), '0.2589695579663814') We are sending mail with results at cod@fotonower.com refus_total : 0.2589695579663814 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=20314474 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_P20314474_07-02-2025_01_22_36.pdf results_Qualipapia_P20314474_07-02-2025_01_22_36.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20314474_07-02-2025_01_22_36.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','20314474','results_Qualipapia_P20314474_07-02-2025_01_22_36.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20314474_07-02-2025_01_22_36.pdf','pdf','','0.16','0.2589695579663814') Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1335326594, 1335326450] 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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 2 time used for this insertion : 0.014890193939208984 save_final save missing photos in datou_result : time spend for datou_step_exec : 4.577501535415649 time spend to save output : 0.015097379684448242 total time spend for step 10 : 4.592598915100098 step11:split_time_score Fri Feb 7 01:22:41 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'}] (('20', 2),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 06022025 20314474 Nombre de photos uploadées : 2 / 23040 (0%) 06022025 20314474 Nombre de photos taguées (types de déchets): 2 / 2 (100%) 06022025 20314474 Nombre de photos taguées (volume) : 0 / 2 (0%) elapsed_time : load_data_split_time_score 2.6226043701171875e-06 elapsed_time : order_list_meta_photo_and_scores 7.867813110351562e-06 ?? elapsed_time : fill_and_build_computed_from_old_data 0.0002460479736328125 elapsed_time : insert_dashboard_record_day_entry 0.026566505432128906 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20297627 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20297627 order by id desc limit 1 Qualite : 0.1437886216255483 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20297628_06-02-2025_13_32_26.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20297628 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`=20297628 AND mptpi.`type`=4230 To do Qualite : 0.1437886216255483 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20297628_06-02-2025_13_32_26.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20297628 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`=20297628 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20297629 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20298032 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20298033 order by id desc limit 1 Qualite : 0.1283856179969406 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20298034_06-02-2025_17_41_50.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20298034 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`=20298034 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20298035 order by id desc limit 1 Qualite : 0.15398963015225456 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20298036_06-02-2025_18_00_03.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20298036 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`=20298036 AND mptpi.`type`=4230 To do Qualite : 0.23439323561320993 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20300744_06-02-2025_18_42_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20300744 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`=20300744 AND mptpi.`type`=4230 To do Qualite : 0.21397048530398904 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20300745_06-02-2025_18_20_24.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20300745 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`=20300745 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305751 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305752 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305753 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305754 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305755 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305780 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305781 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305782 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305783 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305784 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305785 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305786 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305787 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305788 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305789 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305790 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311741 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311742 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309441 order by id desc limit 1 Qualite : 0.21829823758037809 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20305792_06-02-2025_20_38_42.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305792 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`=20305792 AND mptpi.`type`=4230 To do Qualite : 0.24527143931636783 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20305793_06-02-2025_20_21_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20305793 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`=20305793 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309442 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309443 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309444 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309445 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309446 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309447 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309448 order by id desc limit 1 Qualite : 0.20351072599550035 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20307171_06-02-2025_20_48_02.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20307171 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`=20307171 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20307172 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308356 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308357 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308358 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308359 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308360 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308361 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308362 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308363 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308364 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308365 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308366 order by id desc limit 1 Qualite : 0.186778754333038 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20308367_06-02-2025_21_35_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308367 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`=20308367 AND mptpi.`type`=4230 To do Qualite : 0.18142782694266635 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20308368_06-02-2025_21_25_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20308368 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`=20308368 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309449 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309450 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309451 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309452 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309453 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309454 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309455 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309456 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309457 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309458 order by id desc limit 1 Qualite : 0.17501760183289164 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20309459_06-02-2025_21_47_10.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20309459 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`=20309459 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311743 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311744 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311745 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310713 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310714 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310715 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310716 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310717 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310718 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310719 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310720 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310721 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310722 order by id desc limit 1 Qualite : 0.18614081699614712 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20310723_06-02-2025_22_46_35.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310723 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`=20310723 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20310724 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311768 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311783 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311784 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311785 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311786 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311787 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311788 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311789 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311790 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311791 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311792 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311793 order by id desc limit 1 Qualite : 0.20198839558319584 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20311794_06-02-2025_23_51_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311794 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`=20311794 AND mptpi.`type`=4230 To do Qualite : 0.23592222524593415 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20311795_06-02-2025_23_34_07.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20311795 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`=20311795 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313881 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313883 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313885 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313886 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313887 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313888 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313889 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313890 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313892 order by id desc limit 1 Qualite : 0.23392751387831337 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313894_07-02-2025_00_43_36.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313894 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`=20313894 AND mptpi.`type`=4230 To do Qualite : 0.22631795928320772 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313895_07-02-2025_00_49_19.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313895 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`=20313895 AND mptpi.`type`=4230 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313896 order by id desc limit 1 Qualite : 0.20958892165571463 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313897_07-02-2025_00_35_03.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313897 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`=20313897 AND mptpi.`type`=4230 To do Qualite : 0.24353721895156324 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313898_07-02-2025_00_33_21.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313898 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`=20313898 AND mptpi.`type`=4230 To do Qualite : 0.233141044949768 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313899_07-02-2025_00_27_07.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313899 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`=20313899 AND mptpi.`type`=4230 To do Qualite : 0.233083818434412 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313900_07-02-2025_00_22_47.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313900 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`=20313900 AND mptpi.`type`=4230 To do Qualite : 0.2386101662580131 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20313901_07-02-2025_00_19_48.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20313901 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`=20313901 AND mptpi.`type`=4230 To do Qualite : 0.22755099009181698 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20314473_07-02-2025_01_19_01.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20314473 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`=20314473 AND mptpi.`type`=4230 To do Qualite : 0.2589695579663814 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20314474_07-02-2025_01_22_36.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20314474 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`=20314474 AND mptpi.`type`=4230 To do Qualite : 0.19669894780452696 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20314475_07-02-2025_01_14_04.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20314475 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`=20314475 AND mptpi.`type`=4230 To do Qualite : 0.23988734533008302 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Qualipapia_P20314476_07-02-2025_01_19_32.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20314476 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`=20314476 AND mptpi.`type`=4230 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'06022025': {'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 [1335326594, 1335326450] Looping around the photos to save general results len do output : 1 /20314474Didn'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, '2560867') ('4234', '20314474', '1335326594', None, None, None, None, None, '2560867') ('4234', None, None, None, None, None, None, None, '2560867') ('4234', '20314474', '1335326450', None, None, None, None, None, '2560867') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.013448953628540039 save_final save missing photos in datou_result : time spend for datou_step_exec : 72.393075466156 time spend to save output : 0.013585090637207031 total time spend for step 11 : 72.40666055679321 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 35.31user 20.84system 3:27.59elapsed 27%CPU (0avgtext+0avgdata 2491308maxresident)k 872040inputs+12528outputs (1936major+2017163minor)pagefaults 0swaps