python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 3318 ' -s datou_3318 -M 0 -S 0 -U 95,95,120 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 600920 load datou : 3318 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! Unexpected type for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? [(photo_id, hashtag_id, hashtag_type, x0, x1, y0, y1, score, seg_temp, polygons), ...] was removed should we ? chemin de la photo was removed should we ? [ (photo_id_loc, hashtag_id, hashtag_type, x0, x1, y0, y1, score, None), ...] was removed should we ? chemin de la photo was removed should we ? id de la photo (peut être local ou global) was removed should we ? chemin de la photo was removed should we ? (x0, y0, x1, y1) was removed should we ? chemin de la photo was removed should we ? donnée sous forme de texte was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? id de la photo (peut être local ou global) was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? 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)) load thcls load THCL from format json or kwargs add thcl : 2847 in CacheModelConfig load pdts add pdt : 5275 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 : 3318, datou_cur_ids : ['3724028'] with mtr_portfolio_ids : ['26866559'] and first list_photo_ids : [] new path : /proc/600920/ 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 ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! List Step Type Loaded in datou : mask_detect, crop_condition, rle_unique_nms_with_priority, ventilate_hashtags_in_portfolio, final, blur_detection, brightness, velours_tree, send_mail_cod, split_time_score over limit max, limiting to limit_max 40 list_input_json : [] origin We have 1 , BFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 14 ; length of list_pids : 14 ; length of list_args : 14 time to download the photos : 2.0032448768615723 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 : 10 step1:mask_detect Mon Sep 15 19:40:32 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 10368 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-09-15 19:40:35.310287: 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-09-15 19:40:35.340597: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3492910000 Hz 2025-09-15 19:40:35.342186: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f10b4000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-09-15 19:40:35.342241: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-09-15 19:40:35.344962: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-09-15 19:40:35.496954: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x3eeee5e0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-09-15 19:40:35.497001: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-09-15 19:40:35.497978: 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-09-15 19:40:35.498367: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-15 19:40:35.500923: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-15 19:40:35.503330: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-09-15 19:40:35.503680: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-09-15 19:40:35.506288: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-09-15 19:40:35.507616: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-09-15 19:40:35.512859: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-15 19:40:35.514431: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-09-15 19:40:35.514538: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-15 19:40:35.515393: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-09-15 19:40:35.515417: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-09-15 19:40:35.515430: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-09-15 19:40:35.516767: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9460 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-09-15 19:40:35.844422: 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-09-15 19:40:35.844513: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-15 19:40:35.844533: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-15 19:40:35.844552: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-09-15 19:40:35.844570: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-09-15 19:40:35.844588: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-09-15 19:40:35.844606: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-09-15 19:40:35.844624: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-15 19:40:35.846175: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-09-15 19:40:35.847693: 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-09-15 19:40:35.847749: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-15 19:40:35.847768: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-15 19:40:35.847791: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-09-15 19:40:35.847817: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-09-15 19:40:35.847836: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-09-15 19:40:35.847854: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-09-15 19:40:35.847871: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-15 19:40:35.849431: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-09-15 19:40:35.849468: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-09-15 19:40:35.849479: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-09-15 19:40:35.849488: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-09-15 19:40:35.851078: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9460 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-09-15 19:40:44.214671: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-15 19:40:44.453250: 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 : 14 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 21.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: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 51.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: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 71.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: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 15.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: 1920.00000 nb d'objets trouves : 11 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 44.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: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 23.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: 1920.00000 nb d'objets trouves : 11 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 19.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: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 8.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: 1920.00000 nb d'objets trouves : 10 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 47.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: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 41.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: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 48.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: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 49.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: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 35.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: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 46.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: 1920.00000 nb d'objets trouves : 4 Detection mask done ! Trying to reset tf kernel 601682 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 1302 tf kernel not reseted sub process len(results) : 14 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 14 len(list_Values) 0 process is alive finish correctly or not : True after detect begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 6591 list_Values should be empty [] To do loadFromThcl(), then load ParamDescType : thcl2847 Catched exception ! Connect or reconnect ! 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 ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'] time for calcul the mask position with numpy : 0.0012042522430419922 nb_pixel_total : 18654 time to create 1 rle with old method : 0.023017168045043945 length of segment : 293 time for calcul the mask position with numpy : 0.00019788742065429688 nb_pixel_total : 5127 time to create 1 rle with old method : 0.006031513214111328 length of segment : 83 time for calcul the mask position with numpy : 0.0007243156433105469 nb_pixel_total : 31496 time to create 1 rle with old method : 0.036760568618774414 length of segment : 165 time for calcul the mask position with numpy : 0.0003883838653564453 nb_pixel_total : 7207 time to create 1 rle with old method : 0.00852656364440918 length of segment : 165 time for calcul the mask position with numpy : 0.00045180320739746094 nb_pixel_total : 19120 time to create 1 rle with old method : 0.023051738739013672 length of segment : 114 time for calcul the mask position with numpy : 0.0002560615539550781 nb_pixel_total : 8857 time to create 1 rle with old method : 0.01057744026184082 length of segment : 112 time for calcul the mask position with numpy : 0.001272439956665039 nb_pixel_total : 36455 time to create 1 rle with old method : 0.04336905479431152 length of segment : 316 time for calcul the mask position with numpy : 0.00040984153747558594 nb_pixel_total : 9780 time to create 1 rle with old method : 0.011601686477661133 length of segment : 115 time for calcul the mask position with numpy : 0.001302480697631836 nb_pixel_total : 58976 time to create 1 rle with old method : 0.06892895698547363 length of segment : 204 time for calcul the mask position with numpy : 0.0003380775451660156 nb_pixel_total : 6384 time to create 1 rle with old method : 0.007516622543334961 length of segment : 148 time for calcul the mask position with numpy : 0.00034165382385253906 nb_pixel_total : 9216 time to create 1 rle with old method : 0.015809297561645508 length of segment : 156 time for calcul the mask position with numpy : 0.0023314952850341797 nb_pixel_total : 72393 time to create 1 rle with old method : 0.08655238151550293 length of segment : 241 time for calcul the mask position with numpy : 0.0005321502685546875 nb_pixel_total : 1835 time to create 1 rle with old method : 0.0029077529907226562 length of segment : 125 time for calcul the mask position with numpy : 0.0005884170532226562 nb_pixel_total : 19970 time to create 1 rle with old method : 0.023279905319213867 length of segment : 161 time for calcul the mask position with numpy : 0.0004482269287109375 nb_pixel_total : 12670 time to create 1 rle with old method : 0.014638662338256836 length of segment : 174 time for calcul the mask position with numpy : 0.00030159950256347656 nb_pixel_total : 13442 time to create 1 rle with old method : 0.015742063522338867 length of segment : 132 time for calcul the mask position with numpy : 0.0002238750457763672 nb_pixel_total : 8489 time to create 1 rle with old method : 0.012907266616821289 length of segment : 97 time for calcul the mask position with numpy : 0.0006833076477050781 nb_pixel_total : 26261 time to create 1 rle with old method : 0.03007030487060547 length of segment : 194 time for calcul the mask position with numpy : 0.0002071857452392578 nb_pixel_total : 5486 time to create 1 rle with old method : 0.006663084030151367 length of segment : 82 time for calcul the mask position with numpy : 0.0003170967102050781 nb_pixel_total : 13787 time to create 1 rle with old method : 0.016039133071899414 length of segment : 90 time for calcul the mask position with numpy : 0.0028345584869384766 nb_pixel_total : 107366 time to create 1 rle with old method : 0.12137556076049805 length of segment : 537 time for calcul the mask position with numpy : 0.0005407333374023438 nb_pixel_total : 13992 time to create 1 rle with old method : 0.015984535217285156 length of segment : 241 time for calcul the mask position with numpy : 0.002480745315551758 nb_pixel_total : 116845 time to create 1 rle with old method : 0.13430547714233398 length of segment : 528 time for calcul the mask position with numpy : 0.00028228759765625 nb_pixel_total : 10251 time to create 1 rle with old method : 0.011670589447021484 length of segment : 183 time for calcul the mask position with numpy : 0.0010962486267089844 nb_pixel_total : 38708 time to create 1 rle with old method : 0.04403877258300781 length of segment : 359 time for calcul the mask position with numpy : 0.0003204345703125 nb_pixel_total : 6969 time to create 1 rle with old method : 0.008395195007324219 length of segment : 100 time for calcul the mask position with numpy : 0.0007517337799072266 nb_pixel_total : 45889 time to create 1 rle with old method : 0.05319571495056152 length of segment : 176 time for calcul the mask position with numpy : 0.002492666244506836 nb_pixel_total : 105353 time to create 1 rle with old method : 0.11892080307006836 length of segment : 528 time for calcul the mask position with numpy : 0.0007309913635253906 nb_pixel_total : 37222 time to create 1 rle with old method : 0.04344344139099121 length of segment : 181 time for calcul the mask position with numpy : 0.0007145404815673828 nb_pixel_total : 38493 time to create 1 rle with old method : 0.04444742202758789 length of segment : 280 time for calcul the mask position with numpy : 0.00021314620971679688 nb_pixel_total : 3524 time to create 1 rle with old method : 0.004287242889404297 length of segment : 78 time for calcul the mask position with numpy : 0.0004105567932128906 nb_pixel_total : 6871 time to create 1 rle with old method : 0.008185625076293945 length of segment : 167 time for calcul the mask position with numpy : 0.00024318695068359375 nb_pixel_total : 5798 time to create 1 rle with old method : 0.007161855697631836 length of segment : 85 time for calcul the mask position with numpy : 0.0003018379211425781 nb_pixel_total : 3397 time to create 1 rle with old method : 0.00413823127746582 length of segment : 142 time for calcul the mask position with numpy : 0.0002703666687011719 nb_pixel_total : 5955 time to create 1 rle with old method : 0.007084369659423828 length of segment : 130 time for calcul the mask position with numpy : 0.0027608871459960938 nb_pixel_total : 115514 time to create 1 rle with old method : 0.13080072402954102 length of segment : 540 time for calcul the mask position with numpy : 0.001546621322631836 nb_pixel_total : 86056 time to create 1 rle with old method : 0.10167908668518066 length of segment : 387 time for calcul the mask position with numpy : 0.0003020763397216797 nb_pixel_total : 4803 time to create 1 rle with old method : 0.0056514739990234375 length of segment : 166 time spent for convertir_results : 2.7396740913391113 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 38 chid ids of type : 3594 Number RLEs to save : 7975 save missing photos in datou_result : time spend for datou_step_exec : 25.74285578727722 time spend to save output : 0.5423851013183594 total time spend for step 1 : 26.28524088859558 step2:crop_condition Mon Sep 15 19:40:58 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure Loading chi in step crop with photo_hashtag_type : 3594 Loading chi in step crop for list_pids : 14 ! batch 1 Loaded 38 chid ids of type : 3594 +++++++++++++++++++++++++++++++++++++++++++++ begin to crop the class : papier param for this class : {'min_score': 0.7} filtre for class : papier hashtag_id of this class : 492668766 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 16 About to insert : list_path_to_insert length 16 new photo from crops ! About to upload 16 photos upload in portfolio : 3736932 init cache_photo without model_param we have 16 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1757958060_600920 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 16 photos in the portfolio 3736932 time of upload the photos Elapsed time : 4.554681062698364 we have finished the crop for the class : papier begin to crop the class : carton param for this class : {'min_score': 0.7} filtre for class : carton hashtag_id of this class : 492774966 we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 2 About to insert : list_path_to_insert length 2 new photo from crops ! About to upload 2 photos upload in portfolio : 3736932 init cache_photo without model_param we have 2 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1757958065_600920 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 2 photos in the portfolio 3736932 time of upload the photos Elapsed time : 0.8339743614196777 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 18 About to insert : list_path_to_insert length 18 new photo from crops ! About to upload 18 photos upload in portfolio : 3736932 init cache_photo without model_param we have 18 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1757958070_600920 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 18 photos in the portfolio 3736932 time of upload the photos Elapsed time : 4.691733360290527 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 2 About to insert : list_path_to_insert length 2 new photo from crops ! About to upload 2 photos upload in portfolio : 3736932 init cache_photo without model_param we have 2 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1757958075_600920 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 2 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.7433724403381348 we have finished the crop for the class : autre begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1383799878, 1383799862, 1383799851, 1383799817, 1383799802, 1383799796, 1383799743, 1383799713, 1383799642, 1383799640, 1383799637, 1383799631, 1383799619, 1383799614] Looping around the photos to save general results len do output : 38 /1383823166Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823168Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823169Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823170Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823171Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823172Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823173Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823174Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823175Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823176Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823177Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823178Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823179Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823180Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823181Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823182Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823184Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823185Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823193Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823194Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823195Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823196Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823197Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823198Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823199Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823200Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823201Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823202Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823203Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823204Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823205Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823206Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823207Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823208Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823209Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823210Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823213Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1383823214Didn'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 ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799878', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799862', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799851', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799817', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799802', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799796', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799743', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799713', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799642', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799640', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799637', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799631', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799619', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799614', None, None, None, None, None, '3724028') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 128 time used for this insertion : 0.023056507110595703 save_final save missing photos in datou_result : time spend for datou_step_exec : 18.123666763305664 time spend to save output : 0.02454090118408203 total time spend for step 2 : 18.148207664489746 step3:rle_unique_nms_with_priority Mon Sep 15 19:41:16 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 38 chid ids of type : 3594 +++++++++++++++++++++++++++++++++++++++++++++nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.10088753700256348 time for calcul the mask position with numpy : 0.08154678344726562 nb_pixel_total : 2054946 time to create 1 rle with new method : 0.1126711368560791 time for calcul the mask position with numpy : 0.007345438003540039 nb_pixel_total : 18654 time to create 1 rle with old method : 0.021241426467895508 create new chi : 0.23279094696044922 time to delete rle : 0.027927398681640625 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1666 TO DO : save crop sub photo not yet done ! save time : 0.1606612205505371 nb_obj : 5 nb_hashtags : 2 time to prepare the origin masks : 0.5063173770904541 time for calcul the mask position with numpy : 0.24378323554992676 nb_pixel_total : 2002104 time to create 1 rle with new method : 0.10091352462768555 time for calcul the mask position with numpy : 0.006598234176635742 nb_pixel_total : 8546 time to create 1 rle with old method : 0.013965368270874023 time for calcul the mask position with numpy : 0.008444786071777344 nb_pixel_total : 19120 time to create 1 rle with old method : 0.022467851638793945 time for calcul the mask position with numpy : 0.006837606430053711 nb_pixel_total : 7207 time to create 1 rle with old method : 0.008188486099243164 time for calcul the mask position with numpy : 0.007254838943481445 nb_pixel_total : 31496 time to create 1 rle with old method : 0.04079699516296387 time for calcul the mask position with numpy : 0.0067234039306640625 nb_pixel_total : 5127 time to create 1 rle with old method : 0.0060389041900634766 create new chi : 0.48374438285827637 time to delete rle : 0.00044345855712890625 batch 1 Loaded 11 chid ids of type : 3594 +++++Number RLEs to save : 2317 TO DO : save crop sub photo not yet done ! save time : 0.1986677646636963 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.036771535873413086 time for calcul the mask position with numpy : 0.02316880226135254 nb_pixel_total : 2037145 time to create 1 rle with new method : 0.0606236457824707 time for calcul the mask position with numpy : 0.0072917938232421875 nb_pixel_total : 36455 time to create 1 rle with old method : 0.043045997619628906 create new chi : 0.14558005332946777 time to delete rle : 0.00026416778564453125 batch 1 Loaded 3 chid ids of type : 3594 ++Number RLEs to save : 1712 TO DO : save crop sub photo not yet done ! save time : 0.16143226623535156 nb_obj : 6 nb_hashtags : 4 time to prepare the origin masks : 1.170893907546997 time for calcul the mask position with numpy : 0.16075921058654785 nb_pixel_total : 1915016 time to create 1 rle with new method : 0.21814751625061035 time for calcul the mask position with numpy : 0.006773710250854492 nb_pixel_total : 1835 time to create 1 rle with old method : 0.0021436214447021484 time for calcul the mask position with numpy : 0.006819725036621094 nb_pixel_total : 72393 time to create 1 rle with old method : 0.0803520679473877 time for calcul the mask position with numpy : 0.0072286128997802734 nb_pixel_total : 9216 time to create 1 rle with old method : 0.01050424575805664 time for calcul the mask position with numpy : 0.0074923038482666016 nb_pixel_total : 6384 time to create 1 rle with old method : 0.0075604915618896484 time for calcul the mask position with numpy : 0.007223606109619141 nb_pixel_total : 58976 time to create 1 rle with old method : 0.09134054183959961 time for calcul the mask position with numpy : 0.007055521011352539 nb_pixel_total : 9780 time to create 1 rle with old method : 0.011225700378417969 create new chi : 0.6346566677093506 time to delete rle : 0.0005030632019042969 batch 1 Loaded 13 chid ids of type : 3594 ++++++++++Number RLEs to save : 3058 TO DO : save crop sub photo not yet done ! save time : 0.2528519630432129 nb_obj : 4 nb_hashtags : 3 time to prepare the origin masks : 0.06216239929199219 time for calcul the mask position with numpy : 0.021397829055786133 nb_pixel_total : 2019029 time to create 1 rle with new method : 0.10337257385253906 time for calcul the mask position with numpy : 0.006455898284912109 nb_pixel_total : 8489 time to create 1 rle with old method : 0.009387493133544922 time for calcul the mask position with numpy : 0.006398916244506836 nb_pixel_total : 13442 time to create 1 rle with old method : 0.01485896110534668 time for calcul the mask position with numpy : 0.0064258575439453125 nb_pixel_total : 12670 time to create 1 rle with old method : 0.014255762100219727 time for calcul the mask position with numpy : 0.0065135955810546875 nb_pixel_total : 19970 time to create 1 rle with old method : 0.02219367027282715 create new chi : 0.21870779991149902 time to delete rle : 0.00038552284240722656 batch 1 Loaded 9 chid ids of type : 3594 +++++Number RLEs to save : 2208 TO DO : save crop sub photo not yet done ! save time : 0.18083739280700684 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.19754481315612793 time for calcul the mask position with numpy : 0.058872222900390625 nb_pixel_total : 1920700 time to create 1 rle with new method : 0.26731324195861816 time for calcul the mask position with numpy : 0.013064384460449219 nb_pixel_total : 107366 time to create 1 rle with old method : 0.12088537216186523 time for calcul the mask position with numpy : 0.006438493728637695 nb_pixel_total : 13787 time to create 1 rle with old method : 0.015465974807739258 time for calcul the mask position with numpy : 0.006344318389892578 nb_pixel_total : 5486 time to create 1 rle with old method : 0.0062596797943115234 time for calcul the mask position with numpy : 0.011727571487426758 nb_pixel_total : 26261 time to create 1 rle with old method : 0.029578447341918945 create new chi : 0.5466158390045166 time to delete rle : 0.000507354736328125 batch 1 Loaded 9 chid ids of type : 3594 ++++Number RLEs to save : 2886 TO DO : save crop sub photo not yet done ! save time : 0.22819161415100098 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.06798458099365234 time for calcul the mask position with numpy : 0.14997625350952148 nb_pixel_total : 1932512 time to create 1 rle with new method : 0.08865189552307129 time for calcul the mask position with numpy : 0.0065801143646240234 nb_pixel_total : 10251 time to create 1 rle with old method : 0.011643171310424805 time for calcul the mask position with numpy : 0.00731205940246582 nb_pixel_total : 116845 time to create 1 rle with old method : 0.13011455535888672 time for calcul the mask position with numpy : 0.006396293640136719 nb_pixel_total : 13992 time to create 1 rle with old method : 0.01564812660217285 create new chi : 0.4262361526489258 time to delete rle : 0.0005156993865966797 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 2984 TO DO : save crop sub photo not yet done ! save time : 0.22958683967590332 nb_obj : 6 nb_hashtags : 3 time to prepare the origin masks : 0.4683568477630615 time for calcul the mask position with numpy : 0.3658459186553955 nb_pixel_total : 1800966 time to create 1 rle with new method : 0.22442221641540527 time for calcul the mask position with numpy : 0.006570577621459961 nb_pixel_total : 38493 time to create 1 rle with old method : 0.04401683807373047 time for calcul the mask position with numpy : 0.007220029830932617 nb_pixel_total : 37222 time to create 1 rle with old method : 0.04450511932373047 time for calcul the mask position with numpy : 0.007483959197998047 nb_pixel_total : 105353 time to create 1 rle with old method : 0.12054300308227539 time for calcul the mask position with numpy : 0.0069162845611572266 nb_pixel_total : 45889 time to create 1 rle with old method : 0.051798105239868164 time for calcul the mask position with numpy : 0.00794529914855957 nb_pixel_total : 6969 time to create 1 rle with old method : 0.00871729850769043 time for calcul the mask position with numpy : 0.007332801818847656 nb_pixel_total : 38708 time to create 1 rle with old method : 0.0444338321685791 create new chi : 0.9583988189697266 time to delete rle : 0.0007364749908447266 batch 1 Loaded 13 chid ids of type : 3594 +++++++Number RLEs to save : 4328 TO DO : save crop sub photo not yet done ! save time : 0.30574822425842285 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04916071891784668 time for calcul the mask position with numpy : 0.022647857666015625 nb_pixel_total : 2063205 time to create 1 rle with new method : 0.03513622283935547 time for calcul the mask position with numpy : 0.007097482681274414 nb_pixel_total : 6871 time to create 1 rle with old method : 0.0076982975006103516 time for calcul the mask position with numpy : 0.0064389705657958984 nb_pixel_total : 3524 time to create 1 rle with old method : 0.004201412200927734 create new chi : 0.0835123062133789 time to delete rle : 0.00026917457580566406 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1570 TO DO : save crop sub photo not yet done ! save time : 0.14051556587219238 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.041120290756225586 time for calcul the mask position with numpy : 0.025449037551879883 nb_pixel_total : 2067802 time to create 1 rle with new method : 0.03292274475097656 time for calcul the mask position with numpy : 0.006933689117431641 nb_pixel_total : 5798 time to create 1 rle with old method : 0.006555318832397461 create new chi : 0.07897639274597168 time to delete rle : 0.0002162456512451172 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1250 TO DO : save crop sub photo not yet done ! save time : 0.12106561660766602 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.045316219329833984 time for calcul the mask position with numpy : 0.3629875183105469 nb_pixel_total : 2064248 time to create 1 rle with new method : 0.0957956314086914 time for calcul the mask position with numpy : 0.006348848342895508 nb_pixel_total : 5955 time to create 1 rle with old method : 0.007003307342529297 time for calcul the mask position with numpy : 0.0065233707427978516 nb_pixel_total : 3397 time to create 1 rle with old method : 0.0039904117584228516 create new chi : 0.4937593936920166 time to delete rle : 0.00031447410583496094 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1624 TO DO : save crop sub photo not yet done ! save time : 0.13949227333068848 No data in photo_id : 1383799631 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.08559536933898926 time for calcul the mask position with numpy : 0.06278467178344727 nb_pixel_total : 1867227 time to create 1 rle with new method : 1.0261459350585938 time for calcul the mask position with numpy : 0.007108926773071289 nb_pixel_total : 4803 time to create 1 rle with old method : 0.0065042972564697266 time for calcul the mask position with numpy : 0.0074460506439208984 nb_pixel_total : 86056 time to create 1 rle with old method : 0.10042810440063477 time for calcul the mask position with numpy : 0.007197141647338867 nb_pixel_total : 115514 time to create 1 rle with old method : 0.15985941886901855 create new chi : 1.3885860443115234 time to delete rle : 0.0006513595581054688 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 3266 TO DO : save crop sub photo not yet done ! save time : 0.25553417205810547 No data in photo_id : 1383799614 map_output_result : {1383799878: (0.0, 'Should be the crop_list due to order', 0), 1383799862: (0.0, 'Should be the crop_list due to order', 0), 1383799851: (0.0, 'Should be the crop_list due to order', 0), 1383799817: (0.0, 'Should be the crop_list due to order', 0), 1383799802: (0.0, 'Should be the crop_list due to order', 0), 1383799796: (0.0, 'Should be the crop_list due to order', 0), 1383799743: (0.0, 'Should be the crop_list due to order', 0), 1383799713: (0.0, 'Should be the crop_list due to order', 0), 1383799642: (0.0, 'Should be the crop_list due to order', 0), 1383799640: (0.0, 'Should be the crop_list due to order', 0), 1383799637: (0.0, 'Should be the crop_list due to order', 0), 1383799631: (0.0, 'Should be the crop_list due to order', 0.0), 1383799619: (0.0, 'Should be the crop_list due to order', 0), 1383799614: (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 [1383799878, 1383799862, 1383799851, 1383799817, 1383799802, 1383799796, 1383799743, 1383799713, 1383799642, 1383799640, 1383799637, 1383799631, 1383799619, 1383799614] Looping around the photos to save general results len do output : 14 /1383799878.Didn't retrieve data . /1383799862.Didn't retrieve data . /1383799851.Didn't retrieve data . /1383799817.Didn't retrieve data . /1383799802.Didn't retrieve data . /1383799796.Didn't retrieve data . /1383799743.Didn't retrieve data . /1383799713.Didn't retrieve data . /1383799642.Didn't retrieve data . /1383799640.Didn't retrieve data . /1383799637.Didn't retrieve data . /1383799631.Didn't retrieve data . /1383799619.Didn't retrieve data . /1383799614.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 ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799878', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799862', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799851', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799817', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799802', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799796', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799743', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799713', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799642', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799640', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799637', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799631', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799619', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799614', None, None, None, None, None, '3724028') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 42 time used for this insertion : 0.0205080509185791 save_final save missing photos in datou_result : time spend for datou_step_exec : 11.349861145019531 time spend to save output : 0.021280765533447266 total time spend for step 3 : 11.371141910552979 step4:ventilate_hashtags_in_portfolio Mon Sep 15 19:41:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step ventilate_hashtags_in_portfolio : To implement ! Iterating over portfolio : 26866559 get user id for portfolio 26866559 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`=26866559 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('autre','pet_clair','flou','environnement','papier','pehd','background','carton','pet_fonce','mal_croppe','metal')) AND mptpi.`min_score`=0.5 To do To do SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26866559 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('autre','pet_clair','flou','environnement','papier','pehd','background','carton','pet_fonce','mal_croppe','metal')) AND mptpi.`min_score`=0.5 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") 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`=26866559 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('autre','pet_clair','flou','environnement','papier','pehd','background','carton','pet_fonce','mal_croppe','metal')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/26866734,26866735,26866736,26866737,26866738,26866739,26866740,26866741,26866742,26866743,26866744?tags=autre,pet_clair,flou,environnement,papier,pehd,background,carton,pet_fonce,mal_croppe,metal Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1383799878, 1383799862, 1383799851, 1383799817, 1383799802, 1383799796, 1383799743, 1383799713, 1383799642, 1383799640, 1383799637, 1383799631, 1383799619, 1383799614] Looping around the photos to save general results len do output : 1 /26866559. 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 ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799878', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799862', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799851', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799817', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799802', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799796', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799743', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799713', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799642', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799640', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799637', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799631', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799619', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799614', None, None, None, None, None, '3724028') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.018584489822387695 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6844265460968018 time spend to save output : 0.018912076950073242 total time spend for step 4 : 1.703338623046875 step5:final Mon Sep 15 19:41:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 : {1383799878: ('0.03921062059082892',), 1383799862: ('0.03921062059082892',), 1383799851: ('0.03921062059082892',), 1383799817: ('0.03921062059082892',), 1383799802: ('0.03921062059082892',), 1383799796: ('0.03921062059082892',), 1383799743: ('0.03921062059082892',), 1383799713: ('0.03921062059082892',), 1383799642: ('0.03921062059082892',), 1383799640: ('0.03921062059082892',), 1383799637: ('0.03921062059082892',), 1383799631: ('0.03921062059082892',), 1383799619: ('0.03921062059082892',), 1383799614: ('0.03921062059082892',)} new output for save of step final : {1383799878: ('0.03921062059082892',), 1383799862: ('0.03921062059082892',), 1383799851: ('0.03921062059082892',), 1383799817: ('0.03921062059082892',), 1383799802: ('0.03921062059082892',), 1383799796: ('0.03921062059082892',), 1383799743: ('0.03921062059082892',), 1383799713: ('0.03921062059082892',), 1383799642: ('0.03921062059082892',), 1383799640: ('0.03921062059082892',), 1383799637: ('0.03921062059082892',), 1383799631: ('0.03921062059082892',), 1383799619: ('0.03921062059082892',), 1383799614: ('0.03921062059082892',)} [1383799878, 1383799862, 1383799851, 1383799817, 1383799802, 1383799796, 1383799743, 1383799713, 1383799642, 1383799640, 1383799637, 1383799631, 1383799619, 1383799614] Looping around the photos to save general results len do output : 14 /1383799878.Didn't retrieve data . /1383799862.Didn't retrieve data . /1383799851.Didn't retrieve data . /1383799817.Didn't retrieve data . /1383799802.Didn't retrieve data . /1383799796.Didn't retrieve data . /1383799743.Didn't retrieve data . /1383799713.Didn't retrieve data . /1383799642.Didn't retrieve data . /1383799640.Didn't retrieve data . /1383799637.Didn't retrieve data . /1383799631.Didn't retrieve data . /1383799619.Didn't retrieve data . /1383799614.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 ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799878', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799862', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799851', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799817', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799802', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799796', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799743', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799713', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799642', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799640', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799637', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799631', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799619', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799614', None, None, None, None, None, '3724028') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 42 time used for this insertion : 0.015221834182739258 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.1191108226776123 time spend to save output : 0.015928983688354492 total time spend for step 5 : 0.1350398063659668 step6:blur_detection Mon Sep 15 19:41:30 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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/1757958030_600920_1383799878_c853c4b13dc050f1bc77a1dc258e79cf.jpg resize: (1080, 1920) 1383799878 -1.1151968474364289 treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82.jpg resize: (1080, 1920) 1383799862 0.9033092655032252 treat image : temp/1757958030_600920_1383799851_36bfea1c89e4877637a257c46d7742f4.jpg resize: (1080, 1920) 1383799851 2.818620218750518 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2.jpg resize: (1080, 1920) 1383799817 -3.5555624855557637 treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae.jpg resize: (1080, 1920) 1383799802 2.996630399559226 treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523.jpg resize: (1080, 1920) 1383799796 -3.8962463164522516 treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68.jpg resize: (1080, 1920) 1383799743 0.06125698355845249 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca.jpg resize: (1080, 1920) 1383799713 -3.545712768386157 treat image : temp/1757958030_600920_1383799642_b70d8cc6d1f751eba59b4d3a142913e1.jpg resize: (1080, 1920) 1383799642 -1.0612751996382874 treat image : temp/1757958030_600920_1383799640_04a52b1e335ad96e6920db600abf8be8.jpg resize: (1080, 1920) 1383799640 -0.19870818359924158 treat image : temp/1757958030_600920_1383799637_7f628304f44da77a24b7fdd33faf4cc7.jpg resize: (1080, 1920) 1383799637 -0.5406185794964627 treat image : temp/1757958030_600920_1383799631_254e895a7c0b3cded48c305f718e7083.jpg resize: (1080, 1920) 1383799631 -0.544030468659259 treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5.jpg resize: (1080, 1920) 1383799619 -3.897895861991605 treat image : temp/1757958030_600920_1383799614_84e085a23c3a2519df686506fa492085.jpg resize: (1080, 1920) 1383799614 0.626547256875397 treat image : temp/1757958030_600920_1383799878_c853c4b13dc050f1bc77a1dc258e79cf_rle_crop_3958890073_0.png resize: (293, 227) 1383823166 -0.9351606877105134 treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890074_0.png resize: (83, 68) 1383823168 -0.903598814857888 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890083_0.png resize: (153, 77) 1383823169 -0.4603375335492649 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890080_0.png resize: (115, 123) 1383823170 -2.2112758065571745 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890085_0.png resize: (127, 204) 1383823171 -2.455974985378753 treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890089_0.png resize: (89, 146) 1383823172 -1.1861923224227566 treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890091_0.png resize: (82, 118) 1383823173 -3.569745704963224 treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68_rle_crop_3958890096_0.png resize: (182, 97) 1383823174 -0.5313098771997905 treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68_rle_crop_3958890094_0.png resize: (222, 84) 1383823175 -0.05550727252374684 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890098_0.png resize: (100, 134) 1383823176 -3.4365427748063517 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890102_0.png resize: (249, 259) 1383823177 -4.579730712679806 treat image : temp/1757958030_600920_1383799642_b70d8cc6d1f751eba59b4d3a142913e1_rle_crop_3958890104_0.png resize: (167, 99) 1383823178 -1.8473314721115506 treat image : temp/1757958030_600920_1383799642_b70d8cc6d1f751eba59b4d3a142913e1_rle_crop_3958890103_0.png resize: (78, 62) 1383823179 -0.6386766406791152 treat image : temp/1757958030_600920_1383799640_04a52b1e335ad96e6920db600abf8be8_rle_crop_3958890105_0.png resize: (85, 131) 1383823180 -0.9065891949415895 treat image : temp/1757958030_600920_1383799637_7f628304f44da77a24b7fdd33faf4cc7_rle_crop_3958890106_0.png resize: (142, 60) 1383823181 -2.8671913354505922 treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5_rle_crop_3958890110_0.png resize: (166, 52) 1383823182 -2.2969528798748993 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890084_0.png resize: (241, 466) 1383823184 -1.1958769337659143 treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890087_0.png resize: (174, 114) 1383823185 -1.1613686027533452 treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890075_0.png resize: (152, 266) 1383823193 -1.1394218957747433 treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890078_0.png resize: (111, 120) 1383823194 -1.7421943758027034 treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890077_0.png resize: (113, 240) 1383823195 -1.03194880997774 treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890076_0.png resize: (165, 79) 1383823196 -2.309556145737534 treat image : temp/1757958030_600920_1383799851_36bfea1c89e4877637a257c46d7742f4_rle_crop_3958890079_0.png resize: (166, 526) 1383823197 -2.4612829485479657 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890081_0.png resize: (158, 567) 1383823198 -3.7561511856322425 treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890086_0.png resize: (133, 241) 1383823199 -2.0089193129440996 treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890088_0.png resize: (131, 132) 1383823200 -0.27530782709941115 treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890090_0.png resize: (194, 179) 1383823201 -1.035008839378752 treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890092_0.png resize: (77, 223) 1383823202 -2.5424068452114503 treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890093_0.png resize: (532, 331) 1383823203 0.024301190105788194 treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68_rle_crop_3958890095_0.png resize: (527, 337) 1383823204 -0.23811773777213943 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890099_0.png resize: (170, 314) 1383823205 -3.9358467887526296 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890101_0.png resize: (180, 298) 1383823206 -1.0385335831877367 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890100_0.png resize: (526, 328) 1383823207 0.14445517682415268 treat image : temp/1757958030_600920_1383799637_7f628304f44da77a24b7fdd33faf4cc7_rle_crop_3958890107_0.png resize: (130, 71) 1383823208 -1.4898200759161453 treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5_rle_crop_3958890109_0.png resize: (377, 382) 1383823209 -3.6772599205087486 treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5_rle_crop_3958890108_0.png resize: (532, 357) 1383823210 0.2448381886563068 treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890082_0.png resize: (144, 83) 1383823213 -1.938867985521081 treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890097_0.png resize: (356, 155) 1383823214 -1.2184460777695636 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 : 52 time used for this insertion : 0.01497793197631836 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 52 time used for this insertion : 0.01609516143798828 save missing photos in datou_result : time spend for datou_step_exec : 11.67427134513855 time spend to save output : 0.03580498695373535 total time spend for step 6 : 11.710076332092285 step7:brightness Mon Sep 15 19:41: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 We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step calcul brightness treat image : temp/1757958030_600920_1383799878_c853c4b13dc050f1bc77a1dc258e79cf.jpg treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82.jpg treat image : temp/1757958030_600920_1383799851_36bfea1c89e4877637a257c46d7742f4.jpg treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2.jpg treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae.jpg treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523.jpg treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68.jpg treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca.jpg treat image : temp/1757958030_600920_1383799642_b70d8cc6d1f751eba59b4d3a142913e1.jpg treat image : temp/1757958030_600920_1383799640_04a52b1e335ad96e6920db600abf8be8.jpg treat image : temp/1757958030_600920_1383799637_7f628304f44da77a24b7fdd33faf4cc7.jpg treat image : temp/1757958030_600920_1383799631_254e895a7c0b3cded48c305f718e7083.jpg treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5.jpg treat image : temp/1757958030_600920_1383799614_84e085a23c3a2519df686506fa492085.jpg treat image : temp/1757958030_600920_1383799878_c853c4b13dc050f1bc77a1dc258e79cf_rle_crop_3958890073_0.png treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890074_0.png treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890083_0.png treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890080_0.png treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890085_0.png treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890089_0.png treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890091_0.png treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68_rle_crop_3958890096_0.png treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68_rle_crop_3958890094_0.png treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890098_0.png treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890102_0.png treat image : temp/1757958030_600920_1383799642_b70d8cc6d1f751eba59b4d3a142913e1_rle_crop_3958890104_0.png treat image : temp/1757958030_600920_1383799642_b70d8cc6d1f751eba59b4d3a142913e1_rle_crop_3958890103_0.png treat image : temp/1757958030_600920_1383799640_04a52b1e335ad96e6920db600abf8be8_rle_crop_3958890105_0.png treat image : temp/1757958030_600920_1383799637_7f628304f44da77a24b7fdd33faf4cc7_rle_crop_3958890106_0.png treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5_rle_crop_3958890110_0.png treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890084_0.png treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890087_0.png treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890075_0.png treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890078_0.png treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890077_0.png treat image : temp/1757958030_600920_1383799862_4c8de500d999c09085e48a37049faf82_rle_crop_3958890076_0.png treat image : temp/1757958030_600920_1383799851_36bfea1c89e4877637a257c46d7742f4_rle_crop_3958890079_0.png treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890081_0.png treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890086_0.png treat image : temp/1757958030_600920_1383799802_45a3825edbb97d6a8545af0850b5c1ae_rle_crop_3958890088_0.png treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890090_0.png treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890092_0.png treat image : temp/1757958030_600920_1383799796_24c567385801d9cd6aa63b6081eff523_rle_crop_3958890093_0.png treat image : temp/1757958030_600920_1383799743_82cfc7ffde95642ad5bfcc393169bf68_rle_crop_3958890095_0.png treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890099_0.png treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890101_0.png treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890100_0.png treat image : temp/1757958030_600920_1383799637_7f628304f44da77a24b7fdd33faf4cc7_rle_crop_3958890107_0.png treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5_rle_crop_3958890109_0.png treat image : temp/1757958030_600920_1383799619_7a522ff7227bdaef5b9ac729c1adebc5_rle_crop_3958890108_0.png treat image : temp/1757958030_600920_1383799817_150d2e00f69da182c6fa128a7aeb2cb2_rle_crop_3958890082_0.png treat image : temp/1757958030_600920_1383799713_1ec20933c6645d7af8199b9118a6e8ca_rle_crop_3958890097_0.png 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 : 52 time used for this insertion : 0.013990163803100586 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 52 time used for this insertion : 0.01599287986755371 save missing photos in datou_result : time spend for datou_step_exec : 3.582954168319702 time spend to save output : 0.03477287292480469 total time spend for step 7 : 3.617727041244507 step8:velours_tree Mon Sep 15 19:41:45 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure can't find the photo_desc_type Inside saveOutput : final : False verbose : 0 ouput is None No outpout to save, returning out of save general time spend for datou_step_exec : 0.20045065879821777 time spend to save output : 3.814697265625e-05 total time spend for step 8 : 0.20048880577087402 step9:send_mail_cod Mon Sep 15 19:41:45 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 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 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 3 We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure dans la step send mail cod work_area: /home/admin/workarea/git/Velours/python in order to get the selector url, please entre the license of selector results_Auto_P26866559_15-09-2025_19_41_45.pdf 26866734 change filename to text .change filename to text .imagette268667341757958105 26866735 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 .imagette268667351757958105 26866736 imagette268667361757958106 26866738 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 .imagette268667381757958106 26866739 imagette268667391757958107 26866740 imagette268667401757958107 26866741 change filename to text .change filename to text .imagette268667411757958107 26866742 imagette268667421757958108 26866743 imagette268667431757958108 26866744 imagette268667441757958108 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=26866559 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/26866734,26866735,26866736,26866737,26866738,26866739,26866740,26866741,26866742,26866743,26866744?tags=autre,pet_clair,flou,environnement,papier,pehd,background,carton,pet_fonce,mal_croppe,metal args[1383799878] : ((1383799878, -1.1151968474364289, 492688767), (1383799878, 0.40903033540926403, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799862] : ((1383799862, 0.9033092655032252, 492688767), (1383799862, 0.9234911366800844, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799851] : ((1383799851, 2.818620218750518, 492688767), (1383799851, 1.0445081207272098, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799817] : ((1383799817, -3.5555624855557637, 492609224), (1383799817, 0.18252768735927008, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799802] : ((1383799802, 2.996630399559226, 492688767), (1383799802, 0.5367133754899654, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799796] : ((1383799796, -3.8962463164522516, 492609224), (1383799796, 0.4072532131330592, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799743] : ((1383799743, 0.06125698355845249, 492688767), (1383799743, 0.4021845991648426, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799713] : ((1383799713, -3.545712768386157, 492609224), (1383799713, 0.20867477016153732, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799642] : ((1383799642, -1.0612751996382874, 492688767), (1383799642, 1.3332820236611114, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799640] : ((1383799640, -0.19870818359924158, 492688767), (1383799640, 0.6723332642196577, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799637] : ((1383799637, -0.5406185794964627, 492688767), (1383799637, 0.7675088952314066, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799631] : ((1383799631, -0.544030468659259, 492688767), (1383799631, 0.9727386309898259, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799619] : ((1383799619, -3.897895861991605, 492609224), (1383799619, 0.4186952552145649, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com args[1383799614] : ((1383799614, 0.626547256875397, 492688767), (1383799614, 0.6339991310670781, 2107752395), '0.03921062059082892') We are sending mail with results at report@fotonower.com refus_total : 0.03921062059082892 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=26866559 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_Auto_P26866559_15-09-2025_19_41_45.pdf results_Auto_P26866559_15-09-2025_19_41_45.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26866559_15-09-2025_19_41_45.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('3318','26866559','results_Auto_P26866559_15-09-2025_19_41_45.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26866559_15-09-2025_19_41_45.pdf','pdf','','0.27','0.03921062059082892') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/26866559

https://www.fotonower.com/image?json=false&list_photos_id=1383799878
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799862
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799851
La photo est trop floue, merci de reprendre une photo.(avec le score = 2.818620218750518)
https://www.fotonower.com/image?json=false&list_photos_id=1383799817
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799802
La photo est trop floue, merci de reprendre une photo.(avec le score = 2.996630399559226)
https://www.fotonower.com/image?json=false&list_photos_id=1383799796
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799743
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799713
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799642
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799640
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799637
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799631
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799619
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1383799614
Bravo, la photo est bien prise.

Dans ces conditions,le taux de refus est: 3.92%
Veuillez trouver les photos des contaminants.

exemples de contaminants: autre: https://www.fotonower.com/view/26866734?limit=200
exemples de contaminants: pet_clair: https://www.fotonower.com/view/26866735?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/26866738?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/26866741?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26866559_15-09-2025_19_41_45.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/26866734,26866735,26866736,26866737,26866738,26866739,26866740,26866741,26866742,26866743,26866744?tags=autre,pet_clair,flou,environnement,papier,pehd,background,carton,pet_fonce,mal_croppe,metal.


L'équipe Fotonower 202 b'' Server: nginx Date: Mon, 15 Sep 2025 17:41:49 GMT Content-Length: 0 Connection: close X-Message-Id: puDFARKbSsCS8pxCt_rjbA Access-Control-Allow-Origin: https://sendgrid.api-docs.io Access-Control-Allow-Methods: POST Access-Control-Allow-Headers: Authorization, Content-Type, On-behalf-of, x-sg-elas-acl Access-Control-Max-Age: 600 X-No-CORS-Reason: https://sendgrid.com/docs/Classroom/Basics/API/cors.html Strict-Transport-Security: max-age=31536000; includeSubDomains Content-Security-Policy: frame-ancestors 'none' Cache-Control: no-cache X-Content-Type-Options: no-sniff Referrer-Policy: strict-origin-when-cross-origin Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1383799878, 1383799862, 1383799851, 1383799817, 1383799802, 1383799796, 1383799743, 1383799713, 1383799642, 1383799640, 1383799637, 1383799631, 1383799619, 1383799614] 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 ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799878', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799862', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799851', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799817', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799802', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799796', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799743', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799713', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799642', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799640', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799637', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799631', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799619', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799614', None, None, None, None, None, '3724028') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 14 time used for this insertion : 0.016166210174560547 save_final save missing photos in datou_result : time spend for datou_step_exec : 4.347082614898682 time spend to save output : 0.016424179077148438 total time spend for step 9 : 4.36350679397583 step10:split_time_score Mon Sep 15 19:41:49 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('18', 14),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 15092025 26866559 Nombre de photos uploadées : 14 / 23040 (0%) 15092025 26866559 Nombre de photos taguées (types de déchets): 0 / 14 (0%) 15092025 26866559 Nombre de photos taguées (volume) : 0 / 14 (0%) elapsed_time : load_data_split_time_score 1.430511474609375e-06 elapsed_time : order_list_meta_photo_and_scores 1.0728836059570312e-05 ?????????????? elapsed_time : fill_and_build_computed_from_old_data 0.000652313232421875 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.19908881187438965 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps Qualite : 0.04883231298732941 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26842775_15-09-2025_09_52_36.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26842775 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26842775 AND mptpi.`type`=3594 To do Qualite : 0.04090774096579218 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26842777_15-09-2025_10_02_20.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26842777 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26842777 AND mptpi.`type`=3594 To do Qualite : 0.02615415219907407 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26842797_15-09-2025_09_51_15.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26842797 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26842797 AND mptpi.`type`=3594 To do Qualite : 0.10658130787037039 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26842799_15-09-2025_10_51_25.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26842799 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26842799 AND mptpi.`type`=3594 To do Qualite : 0.13058318865740742 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26853350_15-09-2025_14_41_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26853350 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26853350 AND mptpi.`type`=3594 To do Qualite : 0.05183220003858025 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26849842_15-09-2025_13_01_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26849842 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26849842 AND mptpi.`type`=3594 To do Qualite : 0.05108635756782001 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26850411_15-09-2025_13_33_16.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26850411 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26850411 AND mptpi.`type`=3594 To do Qualite : 0.13203800154320985 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26850414_15-09-2025_13_01_39.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26850414 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26850414 AND mptpi.`type`=3594 To do Qualite : 0.12830234857253087 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26850415_15-09-2025_12_51_36.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26850415 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26850415 AND mptpi.`type`=3594 To do Qualite : 0.05635190610532407 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26851600_15-09-2025_13_51_55.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26851600 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26851600 AND mptpi.`type`=3594 To do Qualite : 0.02000476894718793 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26853353_15-09-2025_14_31_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26853353 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26853353 AND mptpi.`type`=3594 To do Qualite : 0.025930003156565667 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26859102_15-09-2025_18_21_32.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26859102 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26859102 AND mptpi.`type`=3594 To do Qualite : 0.008096810115039281 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26859104_15-09-2025_17_01_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26859104 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26859104 AND mptpi.`type`=3594 To do Qualite : 0.2160451630015432 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26859106_15-09-2025_16_52_31.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26859106 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26859106 AND mptpi.`type`=3594 To do Qualite : 0.05999706264029181 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26859119_15-09-2025_16_41_32.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26859119 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26859119 AND mptpi.`type`=3594 To do Qualite : 0.13406235161443497 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26862025_15-09-2025_18_11_49.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26862025 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26862025 AND mptpi.`type`=3594 To do Qualite : 0.1366777584876543 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26862026_15-09-2025_18_02_12.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26862026 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26862026 AND mptpi.`type`=3594 To do Qualite : 0.06456046075837742 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26862027_15-09-2025_19_02_08.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26862027 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26862027 AND mptpi.`type`=3594 To do Qualite : 0.026405767746913583 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26862030_15-09-2025_17_41_48.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26862030 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26862030 AND mptpi.`type`=3594 To do Qualite : 0.03921062059082892 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26866559_15-09-2025_19_41_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 26866559 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=26866559 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'15092025': {'nb_upload': 14, 'nb_taggue_class': 0, 'nb_taggue_densite': 0}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1383799878, 1383799862, 1383799851, 1383799817, 1383799802, 1383799796, 1383799743, 1383799713, 1383799642, 1383799640, 1383799637, 1383799631, 1383799619, 1383799614] Looping around the photos to save general results len do output : 1 /26866559Didn'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 ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799878', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799862', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799851', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799817', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799802', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799796', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799743', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799713', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799642', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799640', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799637', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799631', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799619', None, None, None, None, None, '3724028') ('3318', None, None, None, None, None, None, None, '3724028') ('3318', '26866559', '1383799614', None, None, None, None, None, '3724028') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.014050006866455078 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.5242812633514404 time spend to save output : 0.014372587203979492 total time spend for step 10 : 1.53865385055542 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 14 set_done_treatment 44.31user 20.77system 1:25.67elapsed 75%CPU (0avgtext+0avgdata 2796832maxresident)k 550784inputs+20040outputs (270major+1593125minor)pagefaults 0swaps