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 : 647850 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 : ['3978343'] with mtr_portfolio_ids : ['28055888'] and first list_photo_ids : [] new path : /proc/647850/ 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 , BFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 6 ; length of list_pids : 6 ; length of list_args : 6 time to download the photos : 1.3701817989349365 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 Sat Nov 1 11:00:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 10774 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-11-01 11:00:32.399266: 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-11-01 11:00:32.430614: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493010000 Hz 2025-11-01 11:00:32.432849: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f89d0000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-11-01 11:00:32.432888: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-11-01 11:00:32.438133: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-11-01 11:00:32.684655: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x24bc2da0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-11-01 11:00:32.684706: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-11-01 11:00:32.686458: 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-11-01 11:00:32.686853: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-01 11:00:32.690541: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-01 11:00:32.704652: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-01 11:00:32.705070: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-01 11:00:32.726080: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-01 11:00:32.728464: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-01 11:00:32.755635: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-01 11:00:32.757488: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-01 11:00:32.757827: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-01 11:00:32.758809: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-11-01 11:00:32.758831: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-11-01 11:00:32.758842: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-11-01 11:00:32.760526: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9985 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-11-01 11:00:33.065885: 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-11-01 11:00:33.066023: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-01 11:00:33.066041: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-01 11:00:33.066061: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-01 11:00:33.066077: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-01 11:00:33.066091: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-01 11:00:33.066105: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-01 11:00:33.066119: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-01 11:00:33.067483: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-01 11:00:33.069105: 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-11-01 11:00:33.069147: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-01 11:00:33.069164: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-01 11:00:33.069181: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-01 11:00:33.069196: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-01 11:00:33.069212: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-01 11:00:33.069229: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-01 11:00:33.069245: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-01 11:00:33.070562: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-01 11:00:33.070621: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-11-01 11:00:33.070633: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-11-01 11:00:33.070646: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-11-01 11:00:33.072020: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9985 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-11-01 11:00:45.530927: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-01 11:00:45.746191: 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 : 6 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 32 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 11 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 14 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 20 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 28 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 5 Detection mask done ! Trying to reset tf kernel 648571 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 515 tf kernel not reseted sub process len(results) : 6 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 6 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 : 6997 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.0020895004272460938 nb_pixel_total : 63503 time to create 1 rle with old method : 0.0736851692199707 length of segment : 320 time for calcul the mask position with numpy : 0.0006349086761474609 nb_pixel_total : 30747 time to create 1 rle with old method : 0.038298606872558594 length of segment : 225 time for calcul the mask position with numpy : 0.0004956722259521484 nb_pixel_total : 30089 time to create 1 rle with old method : 0.03414297103881836 length of segment : 210 time for calcul the mask position with numpy : 0.00022292137145996094 nb_pixel_total : 12436 time to create 1 rle with old method : 0.014617919921875 length of segment : 124 time for calcul the mask position with numpy : 0.00021791458129882812 nb_pixel_total : 8741 time to create 1 rle with old method : 0.010262012481689453 length of segment : 133 time for calcul the mask position with numpy : 0.000354766845703125 nb_pixel_total : 15526 time to create 1 rle with old method : 0.018620729446411133 length of segment : 136 time for calcul the mask position with numpy : 0.0004220008850097656 nb_pixel_total : 21920 time to create 1 rle with old method : 0.03619074821472168 length of segment : 104 time for calcul the mask position with numpy : 0.0026183128356933594 nb_pixel_total : 93622 time to create 1 rle with old method : 0.10604047775268555 length of segment : 349 time for calcul the mask position with numpy : 0.0010309219360351562 nb_pixel_total : 33764 time to create 1 rle with old method : 0.04150867462158203 length of segment : 288 time for calcul the mask position with numpy : 0.0029921531677246094 nb_pixel_total : 112523 time to create 1 rle with old method : 0.1306161880493164 length of segment : 588 time for calcul the mask position with numpy : 0.0011866092681884766 nb_pixel_total : 67399 time to create 1 rle with old method : 0.0831458568572998 length of segment : 272 time for calcul the mask position with numpy : 0.0065877437591552734 nb_pixel_total : 170704 time to create 1 rle with new method : 0.019752025604248047 length of segment : 645 time for calcul the mask position with numpy : 0.0009448528289794922 nb_pixel_total : 25299 time to create 1 rle with old method : 0.028720378875732422 length of segment : 211 time for calcul the mask position with numpy : 0.0020914077758789062 nb_pixel_total : 54243 time to create 1 rle with old method : 0.06611323356628418 length of segment : 269 time for calcul the mask position with numpy : 0.0015649795532226562 nb_pixel_total : 36580 time to create 1 rle with old method : 0.04685616493225098 length of segment : 288 time for calcul the mask position with numpy : 0.0005044937133789062 nb_pixel_total : 17902 time to create 1 rle with old method : 0.020992517471313477 length of segment : 142 time for calcul the mask position with numpy : 0.003618001937866211 nb_pixel_total : 155389 time to create 1 rle with new method : 0.008701324462890625 length of segment : 503 time for calcul the mask position with numpy : 0.003383636474609375 nb_pixel_total : 143749 time to create 1 rle with old method : 0.16227197647094727 length of segment : 475 time for calcul the mask position with numpy : 0.0003476142883300781 nb_pixel_total : 13902 time to create 1 rle with old method : 0.017505407333374023 length of segment : 165 time for calcul the mask position with numpy : 0.0009675025939941406 nb_pixel_total : 30079 time to create 1 rle with old method : 0.03548407554626465 length of segment : 235 time for calcul the mask position with numpy : 0.000675201416015625 nb_pixel_total : 17354 time to create 1 rle with old method : 0.021787166595458984 length of segment : 162 time for calcul the mask position with numpy : 0.0010619163513183594 nb_pixel_total : 27321 time to create 1 rle with old method : 0.03229093551635742 length of segment : 132 time for calcul the mask position with numpy : 0.004272937774658203 nb_pixel_total : 160385 time to create 1 rle with new method : 0.01004934310913086 length of segment : 426 time for calcul the mask position with numpy : 0.0023767948150634766 nb_pixel_total : 101224 time to create 1 rle with old method : 0.1420304775238037 length of segment : 394 time for calcul the mask position with numpy : 0.002005338668823242 nb_pixel_total : 56070 time to create 1 rle with old method : 0.08561563491821289 length of segment : 541 time for calcul the mask position with numpy : 0.0012440681457519531 nb_pixel_total : 32772 time to create 1 rle with old method : 0.044385671615600586 length of segment : 223 time for calcul the mask position with numpy : 0.0006308555603027344 nb_pixel_total : 20527 time to create 1 rle with old method : 0.023825407028198242 length of segment : 154 time for calcul the mask position with numpy : 0.0012693405151367188 nb_pixel_total : 52528 time to create 1 rle with old method : 0.059194087982177734 length of segment : 336 time for calcul the mask position with numpy : 0.0037965774536132812 nb_pixel_total : 165709 time to create 1 rle with new method : 0.008682489395141602 length of segment : 622 time for calcul the mask position with numpy : 0.00040268898010253906 nb_pixel_total : 17408 time to create 1 rle with old method : 0.020265579223632812 length of segment : 153 time for calcul the mask position with numpy : 0.0003647804260253906 nb_pixel_total : 7154 time to create 1 rle with old method : 0.009105920791625977 length of segment : 115 time for calcul the mask position with numpy : 0.0023009777069091797 nb_pixel_total : 81306 time to create 1 rle with old method : 0.10044097900390625 length of segment : 560 time for calcul the mask position with numpy : 0.00125885009765625 nb_pixel_total : 47121 time to create 1 rle with old method : 0.053235769271850586 length of segment : 379 time for calcul the mask position with numpy : 0.003796100616455078 nb_pixel_total : 126743 time to create 1 rle with old method : 0.1500239372253418 length of segment : 498 time for calcul the mask position with numpy : 0.0027742385864257812 nb_pixel_total : 96138 time to create 1 rle with old method : 0.10931205749511719 length of segment : 634 time for calcul the mask position with numpy : 0.0003910064697265625 nb_pixel_total : 9933 time to create 1 rle with old method : 0.011914491653442383 length of segment : 102 time for calcul the mask position with numpy : 0.0021567344665527344 nb_pixel_total : 61893 time to create 1 rle with old method : 0.07253599166870117 length of segment : 454 time for calcul the mask position with numpy : 0.0006160736083984375 nb_pixel_total : 23871 time to create 1 rle with old method : 0.028246402740478516 length of segment : 339 time for calcul the mask position with numpy : 0.0016086101531982422 nb_pixel_total : 66896 time to create 1 rle with old method : 0.08140063285827637 length of segment : 237 time for calcul the mask position with numpy : 0.001285552978515625 nb_pixel_total : 25501 time to create 1 rle with old method : 0.03351330757141113 length of segment : 207 time for calcul the mask position with numpy : 0.001203775405883789 nb_pixel_total : 39410 time to create 1 rle with old method : 0.0451207160949707 length of segment : 269 time for calcul the mask position with numpy : 0.003929615020751953 nb_pixel_total : 105614 time to create 1 rle with old method : 0.11993622779846191 length of segment : 430 time for calcul the mask position with numpy : 0.006796598434448242 nb_pixel_total : 104550 time to create 1 rle with old method : 0.11795687675476074 length of segment : 454 time for calcul the mask position with numpy : 0.0021893978118896484 nb_pixel_total : 83116 time to create 1 rle with old method : 0.09546065330505371 length of segment : 296 time for calcul the mask position with numpy : 0.0002124309539794922 nb_pixel_total : 3889 time to create 1 rle with old method : 0.00472712516784668 length of segment : 69 time for calcul the mask position with numpy : 0.0020334720611572266 nb_pixel_total : 58390 time to create 1 rle with old method : 0.06676650047302246 length of segment : 349 time for calcul the mask position with numpy : 0.0002560615539550781 nb_pixel_total : 8556 time to create 1 rle with old method : 0.010219573974609375 length of segment : 96 time for calcul the mask position with numpy : 0.0035009384155273438 nb_pixel_total : 145521 time to create 1 rle with old method : 0.17737221717834473 length of segment : 443 time for calcul the mask position with numpy : 0.00019931793212890625 nb_pixel_total : 5106 time to create 1 rle with old method : 0.006196260452270508 length of segment : 78 time for calcul the mask position with numpy : 0.00044417381286621094 nb_pixel_total : 17311 time to create 1 rle with old method : 0.022565603256225586 length of segment : 164 time spent for convertir_results : 5.310283660888672 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 50 chid ids of type : 3594 Number RLEs to save : 14998 save missing photos in datou_result : time spend for datou_step_exec : 43.95486760139465 time spend to save output : 0.7855861186981201 total time spend for step 1 : 44.74045372009277 step2:crop_condition Sat Nov 1 11:01:14 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : 6 ! batch 1 Loaded 50 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 ! 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 : 26 About to insert : list_path_to_insert length 26 new photo from crops ! About to upload 26 photos upload in portfolio : 3736932 init cache_photo without model_param we have 26 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1761991282_647850 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157539_0.png', 0, 94, 131, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157538_0.png', 0, 136, 124, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157537_0.png', 0, 180, 209, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157536_0.png', 0, 193, 225, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157554_0.png', 0, 231, 234, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157555_0.png', 0, 201, 170, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157553_0.png', 0, 110, 161, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157559_0.png', 0, 203, 468, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157563_0.png', 0, 362, 615, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157557_0.png', 0, 593, 426, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157562_0.png', 0, 247, 334, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157561_0.png', 0, 184, 153, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157567_0.png', 0, 249, 373, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157565_0.png', 0, 102, 115, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157558_0.png', 0, 437, 345, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157573_0.png', 0, 386, 216, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157571_0.png', 0, 284, 329, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157572_0.png', 0, 159, 260, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157568_0.png', 0, 323, 479, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157577_0.png', 0, 606, 514, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157575_0.png', 0, 172, 260, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157579_0.png', 0, 74, 65, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157580_0.png', 0, 292, 343, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157576_0.png', 0, 423, 430, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480_rle_crop_4013157583_0.png', 0, 74, 78, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991287), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480_rle_crop_4013157584_0.png', 0, 138, 162, 0, 1761991287,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 26 photos in the portfolio 3736932 time of upload the photos Elapsed time : 6.545364856719971 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 ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 3736932 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1761991290_647850 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991291), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157549_0.png', 0, 174, 288, 0, 1761991291,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991291), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157574_0.png', 0, 216, 207, 0, 1761991291,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991291), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157578_0.png', 0, 407, 295, 0, 1761991291,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.0381054878234863 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 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 : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 3736932 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1761991292_647850 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991293), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157550_0.png', 0, 159, 137, 0, 1761991293,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991293), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157570_0.png', 0, 120, 102, 0, 1761991293,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991293), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157581_0.png', 0, 112, 96, 0, 1761991293,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.1780951023101807 we have finished the crop for the class : metal 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 ! map_result returned by crop_photo_return_map_crop : length : 15 About to insert : list_path_to_insert length 15 new photo from crops ! About to upload 15 photos upload in portfolio : 3736932 init cache_photo without model_param we have 15 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1761991298_647850 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157535_0.png', 0, 292, 317, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157547_0.png', 0, 176, 211, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157543_0.png', 0, 284, 203, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157541_0.png', 0, 250, 102, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157540_0.png', 0, 196, 129, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157548_0.png', 0, 255, 260, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157545_0.png', 0, 385, 267, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157544_0.png', 0, 294, 586, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157546_0.png', 0, 482, 645, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157542_0.png', 0, 373, 349, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157556_0.png', 0, 239, 132, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157560_0.png', 0, 306, 195, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157564_0.png', 0, 165, 151, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157566_0.png', 0, 343, 391, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991302), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157569_0.png', 0, 272, 526, 0, 1761991302,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 15 photos in the portfolio 3736932 time of upload the photos Elapsed time : 4.467519044876099 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 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 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 : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 3736932 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1761991305_647850 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991306), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157551_0.png', 0, 433, 503, 0, 1761991306,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991306), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157552_0.png', 0, 408, 475, 0, 1761991306,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1761991306), 0.0, 0.0, 14, '', 0, 0, '1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157582_0.png', 0, 443, 436, 0, 1761991306,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.0084037780761719 we have finished the crop for the class : pet_fonce 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 Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1390488393, 1390488320, 1390488318, 1390488314, 1390488312, 1390488309] Looping around the photos to save general results len do output : 50 /1391595904Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595905Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595906Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595907Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595908Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595909Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595910Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595911Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595912Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595913Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595914Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595915Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595916Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595917Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595918Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595919Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595920Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595922Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595923Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595924Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595925Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595926Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595927Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595928Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595930Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595931Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595932Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595933Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595934Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595936Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595937Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595938Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595996Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595997Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391595998Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596000Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596001Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596002Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596003Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596005Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596006Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596007Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596009Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596011Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596012Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596013Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596014Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596047Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596048Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1391596050Didn'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, '3978343') ('3318', '28055888', '1390488393', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488320', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488318', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488314', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488312', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488309', None, None, None, None, None, '3978343') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 156 time used for this insertion : 0.026035785675048828 save_final save missing photos in datou_result : time spend for datou_step_exec : 32.55785775184631 time spend to save output : 0.027975082397460938 total time spend for step 2 : 32.585832834243774 step3:rle_unique_nms_with_priority Sat Nov 1 11:01:46 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 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 50 chid ids of type : 3594 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++nb_obj : 15 nb_hashtags : 3 time to prepare the origin masks : 5.375885486602783 time for calcul the mask position with numpy : 0.4924962520599365 nb_pixel_total : 7517304 time to create 1 rle with new method : 0.793372631072998 time for calcul the mask position with numpy : 0.024890422821044922 nb_pixel_total : 36580 time to create 1 rle with old method : 0.040676116943359375 time for calcul the mask position with numpy : 0.02645397186279297 nb_pixel_total : 54243 time to create 1 rle with old method : 0.060092926025390625 time for calcul the mask position with numpy : 0.02710556983947754 nb_pixel_total : 25299 time to create 1 rle with old method : 0.027886152267456055 time for calcul the mask position with numpy : 0.026742935180664062 nb_pixel_total : 170704 time to create 1 rle with new method : 0.9954822063446045 time for calcul the mask position with numpy : 0.026546716690063477 nb_pixel_total : 67399 time to create 1 rle with old method : 0.07390332221984863 time for calcul the mask position with numpy : 0.02534937858581543 nb_pixel_total : 112523 time to create 1 rle with old method : 0.11928415298461914 time for calcul the mask position with numpy : 0.02566695213317871 nb_pixel_total : 33764 time to create 1 rle with old method : 0.036725759506225586 time for calcul the mask position with numpy : 0.025146484375 nb_pixel_total : 93622 time to create 1 rle with old method : 0.1204078197479248 time for calcul the mask position with numpy : 0.0288851261138916 nb_pixel_total : 21920 time to create 1 rle with old method : 0.026944398880004883 time for calcul the mask position with numpy : 0.028741836547851562 nb_pixel_total : 15526 time to create 1 rle with old method : 0.017391443252563477 time for calcul the mask position with numpy : 0.02658367156982422 nb_pixel_total : 8741 time to create 1 rle with old method : 0.010127544403076172 time for calcul the mask position with numpy : 0.03218793869018555 nb_pixel_total : 12436 time to create 1 rle with old method : 0.014332771301269531 time for calcul the mask position with numpy : 0.027934789657592773 nb_pixel_total : 30089 time to create 1 rle with old method : 0.03338956832885742 time for calcul the mask position with numpy : 0.02657294273376465 nb_pixel_total : 30747 time to create 1 rle with old method : 0.03385019302368164 time for calcul the mask position with numpy : 0.02548050880432129 nb_pixel_total : 63503 time to create 1 rle with old method : 0.06935739517211914 create new chi : 3.438098430633545 time to delete rle : 0.021689653396606445 batch 1 Loaded 31 chid ids of type : 3594 ++++++++++++++++++Number RLEs to save : 10484 TO DO : save crop sub photo not yet done ! save time : 0.5338106155395508 nb_obj : 7 nb_hashtags : 4 time to prepare the origin masks : 4.167564868927002 time for calcul the mask position with numpy : 0.9772534370422363 nb_pixel_total : 7888704 time to create 1 rle with new method : 0.8719236850738525 time for calcul the mask position with numpy : 0.026796340942382812 nb_pixel_total : 27321 time to create 1 rle with old method : 0.03400826454162598 time for calcul the mask position with numpy : 0.026911258697509766 nb_pixel_total : 17354 time to create 1 rle with old method : 0.018878936767578125 time for calcul the mask position with numpy : 0.026016950607299805 nb_pixel_total : 30079 time to create 1 rle with old method : 0.03455686569213867 time for calcul the mask position with numpy : 0.02489304542541504 nb_pixel_total : 13902 time to create 1 rle with old method : 0.015413284301757812 time for calcul the mask position with numpy : 0.02657032012939453 nb_pixel_total : 143749 time to create 1 rle with old method : 0.1573011875152588 time for calcul the mask position with numpy : 0.027024269104003906 nb_pixel_total : 155389 time to create 1 rle with new method : 0.908409595489502 time for calcul the mask position with numpy : 0.028298377990722656 nb_pixel_total : 17902 time to create 1 rle with old method : 0.020038127899169922 create new chi : 3.301621913909912 time to delete rle : 0.0008113384246826172 batch 1 Loaded 15 chid ids of type : 3594 ++++++++Number RLEs to save : 5788 TO DO : save crop sub photo not yet done ! save time : 0.30879950523376465 nb_obj : 11 nb_hashtags : 2 time to prepare the origin masks : 5.233786582946777 time for calcul the mask position with numpy : 0.7638123035430908 nb_pixel_total : 7604533 time to create 1 rle with new method : 0.5671722888946533 time for calcul the mask position with numpy : 0.03976178169250488 nb_pixel_total : 647 time to create 1 rle with old method : 0.0008738040924072266 time for calcul the mask position with numpy : 0.0445399284362793 nb_pixel_total : 75443 time to create 1 rle with old method : 0.08435726165771484 time for calcul the mask position with numpy : 0.04329204559326172 nb_pixel_total : 7154 time to create 1 rle with old method : 0.00819849967956543 time for calcul the mask position with numpy : 0.04471635818481445 nb_pixel_total : 17408 time to create 1 rle with old method : 0.021381378173828125 time for calcul the mask position with numpy : 0.04541444778442383 nb_pixel_total : 165709 time to create 1 rle with new method : 0.6831576824188232 time for calcul the mask position with numpy : 0.04210519790649414 nb_pixel_total : 52528 time to create 1 rle with old method : 0.0639193058013916 time for calcul the mask position with numpy : 0.0389094352722168 nb_pixel_total : 20527 time to create 1 rle with old method : 0.02293705940246582 time for calcul the mask position with numpy : 0.033377647399902344 nb_pixel_total : 32772 time to create 1 rle with old method : 0.036277055740356445 time for calcul the mask position with numpy : 0.027867555618286133 nb_pixel_total : 56070 time to create 1 rle with old method : 0.06502580642700195 time for calcul the mask position with numpy : 0.03433418273925781 nb_pixel_total : 101224 time to create 1 rle with old method : 0.10923337936401367 time for calcul the mask position with numpy : 0.028247594833374023 nb_pixel_total : 160385 time to create 1 rle with new method : 1.0235886573791504 create new chi : 3.973177671432495 time to delete rle : 0.002057313919067383 batch 1 Loaded 23 chid ids of type : 3594 +++++++++++++++Number RLEs to save : 9293 TO DO : save crop sub photo not yet done ! save time : 0.5059347152709961 nb_obj : 7 nb_hashtags : 4 time to prepare the origin masks : 4.77868390083313 time for calcul the mask position with numpy : 0.8467068672180176 nb_pixel_total : 7883425 time to create 1 rle with new method : 0.7003941535949707 time for calcul the mask position with numpy : 0.02839350700378418 nb_pixel_total : 25501 time to create 1 rle with old method : 0.02903461456298828 time for calcul the mask position with numpy : 0.026136398315429688 nb_pixel_total : 66896 time to create 1 rle with old method : 0.07423138618469238 time for calcul the mask position with numpy : 0.026079654693603516 nb_pixel_total : 23871 time to create 1 rle with old method : 0.026308059692382812 time for calcul the mask position with numpy : 0.027911901473999023 nb_pixel_total : 61893 time to create 1 rle with old method : 0.06855988502502441 time for calcul the mask position with numpy : 0.025608301162719727 nb_pixel_total : 9933 time to create 1 rle with old method : 0.01102447509765625 time for calcul the mask position with numpy : 0.02605152130126953 nb_pixel_total : 96138 time to create 1 rle with old method : 0.10267281532287598 time for calcul the mask position with numpy : 0.025117874145507812 nb_pixel_total : 126743 time to create 1 rle with old method : 0.15806198120117188 create new chi : 2.244478225708008 time to delete rle : 0.0012977123260498047 batch 1 Loaded 15 chid ids of type : 3594 +++++++++++Number RLEs to save : 7102 TO DO : save crop sub photo not yet done ! save time : 0.3970372676849365 nb_obj : 8 nb_hashtags : 4 time to prepare the origin masks : 3.2465131282806396 time for calcul the mask position with numpy : 1.3421096801757812 nb_pixel_total : 7745973 time to create 1 rle with new method : 1.4868719577789307 time for calcul the mask position with numpy : 0.04418683052062988 nb_pixel_total : 145521 time to create 1 rle with old method : 0.1623530387878418 time for calcul the mask position with numpy : 0.023859739303588867 nb_pixel_total : 8556 time to create 1 rle with old method : 0.009057998657226562 time for calcul the mask position with numpy : 0.025289297103881836 nb_pixel_total : 57771 time to create 1 rle with old method : 0.062193870544433594 time for calcul the mask position with numpy : 0.027289390563964844 nb_pixel_total : 3889 time to create 1 rle with old method : 0.0044155120849609375 time for calcul the mask position with numpy : 0.026862382888793945 nb_pixel_total : 83116 time to create 1 rle with old method : 0.09247303009033203 time for calcul the mask position with numpy : 0.02647876739501953 nb_pixel_total : 104550 time to create 1 rle with old method : 0.12269949913024902 time for calcul the mask position with numpy : 0.026866912841796875 nb_pixel_total : 105614 time to create 1 rle with old method : 0.1430349349975586 time for calcul the mask position with numpy : 0.025004863739013672 nb_pixel_total : 39410 time to create 1 rle with old method : 0.04225015640258789 create new chi : 3.74699068069458 time to delete rle : 0.0014748573303222656 batch 1 Loaded 17 chid ids of type : 3594 ++++++++++Number RLEs to save : 6925 TO DO : save crop sub photo not yet done ! save time : 0.37534523010253906 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 1.4722774028778076 time for calcul the mask position with numpy : 0.6914811134338379 nb_pixel_total : 8271983 time to create 1 rle with new method : 0.619020938873291 time for calcul the mask position with numpy : 0.02357935905456543 nb_pixel_total : 17311 time to create 1 rle with old method : 0.01871180534362793 time for calcul the mask position with numpy : 0.024059534072875977 nb_pixel_total : 5106 time to create 1 rle with old method : 0.005473613739013672 create new chi : 1.4250156879425049 time to delete rle : 0.00039839744567871094 batch 1 Loaded 5 chid ids of type : 3594 +++Number RLEs to save : 2644 TO DO : save crop sub photo not yet done ! save time : 0.2070636749267578 map_output_result : {1390488393: (0.0, 'Should be the crop_list due to order', 0), 1390488320: (0.0, 'Should be the crop_list due to order', 0), 1390488318: (0.0, 'Should be the crop_list due to order', 0), 1390488314: (0.0, 'Should be the crop_list due to order', 0), 1390488312: (0.0, 'Should be the crop_list due to order', 0), 1390488309: (0.0, 'Should be the crop_list due to order', 0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1390488393, 1390488320, 1390488318, 1390488314, 1390488312, 1390488309] Looping around the photos to save general results len do output : 6 /1390488393.Didn't retrieve data . /1390488320.Didn't retrieve data . /1390488318.Didn't retrieve data . /1390488314.Didn't retrieve data . /1390488312.Didn't retrieve data . /1390488309.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, '3978343') ('3318', '28055888', '1390488393', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488320', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488318', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488314', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488312', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488309', None, None, None, None, None, '3978343') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 18 time used for this insertion : 0.010978460311889648 save_final save missing photos in datou_result : time spend for datou_step_exec : 45.656060457229614 time spend to save output : 0.011363983154296875 total time spend for step 3 : 45.66742444038391 step4:ventilate_hashtags_in_portfolio Sat Nov 1 11:02: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 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 : 28055888 get user id for portfolio 28055888 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`=28055888 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('flou','metal','pet_fonce','mal_croppe','pet_clair','pehd','autre','papier','environnement','background','carton')) 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`=28055888 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('flou','metal','pet_fonce','mal_croppe','pet_clair','pehd','autre','papier','environnement','background','carton')) 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`=28055888 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('flou','metal','pet_fonce','mal_croppe','pet_clair','pehd','autre','papier','environnement','background','carton')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/28059851,28059852,28059853,28059854,28059855,28059856,28059857,28059858,28059859,28059860,28059861?tags=flou,metal,pet_fonce,mal_croppe,pet_clair,pehd,autre,papier,environnement,background,carton Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1390488393, 1390488320, 1390488318, 1390488314, 1390488312, 1390488309] Looping around the photos to save general results len do output : 1 /28055888. 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, '3978343') ('3318', '28055888', '1390488393', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488320', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488318', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488314', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488312', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488309', None, None, None, None, None, '3978343') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 7 time used for this insertion : 0.014462471008300781 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.7913565635681152 time spend to save output : 0.014699220657348633 total time spend for step 4 : 1.8060557842254639 step5:final Sat Nov 1 11:02:34 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 : {1390488393: ('0.05735753440072017',), 1390488320: ('0.05735753440072017',), 1390488318: ('0.05735753440072017',), 1390488314: ('0.05735753440072017',), 1390488312: ('0.05735753440072017',), 1390488309: ('0.05735753440072017',)} new output for save of step final : {1390488393: ('0.05735753440072017',), 1390488320: ('0.05735753440072017',), 1390488318: ('0.05735753440072017',), 1390488314: ('0.05735753440072017',), 1390488312: ('0.05735753440072017',), 1390488309: ('0.05735753440072017',)} [1390488393, 1390488320, 1390488318, 1390488314, 1390488312, 1390488309] Looping around the photos to save general results len do output : 6 /1390488393.Didn't retrieve data . /1390488320.Didn't retrieve data . /1390488318.Didn't retrieve data . /1390488314.Didn't retrieve data . /1390488312.Didn't retrieve data . /1390488309.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, '3978343') ('3318', '28055888', '1390488393', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488320', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488318', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488314', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488312', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488309', None, None, None, None, None, '3978343') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 18 time used for this insertion : 0.010672330856323242 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.13862299919128418 time spend to save output : 0.0110015869140625 total time spend for step 5 : 0.14962458610534668 step6:blur_detection Sat Nov 1 11:02:34 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/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291.jpg resize: (2160, 3840) 1390488393 -6.96447684603469 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290.jpg resize: (2160, 3840) 1390488320 -6.969263873150096 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860.jpg resize: (2160, 3840) 1390488318 -6.892473739226211 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207.jpg resize: (2160, 3840) 1390488314 -7.077859705365145 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638.jpg resize: (2160, 3840) 1390488312 -6.9915222690526955 treat image : temp/1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480.jpg resize: (2160, 3840) 1390488309 -6.093045940036438 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157539_0.png resize: (131, 94) 1391595904 -3.410717689676593 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157538_0.png resize: (124, 136) 1391595905 -4.914004485795701 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157537_0.png resize: (209, 180) 1391595906 -5.036938516061845 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157536_0.png resize: (225, 193) 1391595907 -3.6714389707403177 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157554_0.png resize: (234, 231) 1391595908 -4.821264645819786 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157555_0.png resize: (170, 201) 1391595909 -4.309314627366913 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157553_0.png resize: (161, 110) 1391595910 -1.854170638908776 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157559_0.png resize: (468, 203) 1391595911 -3.381095836512833 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157563_0.png resize: (615, 362) 1391595912 -4.954731673032931 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157557_0.png resize: (426, 593) 1391595913 -4.640737416094418 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157562_0.png resize: (334, 247) 1391595914 -4.546658749330459 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157561_0.png resize: (153, 184) 1391595915 -3.090364478508787 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157567_0.png resize: (373, 249) 1391595916 -4.282763301396975 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157565_0.png resize: (115, 102) 1391595917 -4.419214013245324 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157558_0.png resize: (345, 437) 1391595918 -5.044769152853274 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157573_0.png resize: (216, 386) 1391595919 -3.8854509506424004 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157571_0.png resize: (329, 284) 1391595920 -3.625225174042457 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157572_0.png resize: (260, 159) 1391595922 -4.23881636709983 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157568_0.png resize: (479, 323) 1391595923 -4.715723412576578 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157577_0.png resize: (514, 606) 1391595924 -2.3315839877643394 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157575_0.png resize: (260, 172) 1391595925 -3.1182469247462636 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157579_0.png resize: (65, 74) 1391595926 -4.7521945755658725 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157580_0.png resize: (343, 292) 1391595927 -4.888221322898031 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157576_0.png resize: (430, 423) 1391595928 -4.703383451269161 treat image : temp/1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480_rle_crop_4013157583_0.png resize: (78, 74) 1391595930 -1.2941718800351374 treat image : temp/1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480_rle_crop_4013157584_0.png resize: (162, 138) 1391595931 -3.9507999775664864 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157549_0.png resize: (288, 174) 1391595932 -4.97388484777218 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157574_0.png resize: (207, 216) 1391595933 -3.1776793172028426 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157578_0.png resize: (295, 407) 1391595934 -2.937457087737695 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157550_0.png resize: (137, 159) 1391595936 -4.943541643310434 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157570_0.png resize: (102, 120) 1391595937 -3.7500090537162265 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157581_0.png resize: (96, 112) 1391595938 -4.444956385954162 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157535_0.png resize: (317, 292) 1391595996 -5.338100835271489 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157547_0.png resize: (211, 176) 1391595997 -4.177274784828049 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157543_0.png resize: (203, 284) 1391595998 -3.9619972880579812 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157541_0.png resize: (102, 250) 1391596000 -1.5303888511328276 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157540_0.png resize: (129, 196) 1391596001 -4.626644501467608 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157548_0.png resize: (260, 255) 1391596002 -4.626064008143684 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157545_0.png resize: (267, 385) 1391596003 -4.575931734292156 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157544_0.png resize: (586, 294) 1391596005 -4.586126843405078 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157546_0.png resize: (645, 482) 1391596006 -4.489071744398292 treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157542_0.png resize: (349, 373) 1391596007 -4.375797792156547 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157556_0.png resize: (132, 239) 1391596009 -3.6155456879785293 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157560_0.png resize: (195, 306) 1391596011 -3.932621949328739 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157564_0.png resize: (151, 165) 1391596012 -3.6418363376050333 treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157566_0.png resize: (391, 343) 1391596013 -4.918522201186984 treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157569_0.png resize: (526, 272) 1391596014 -4.497246185700511 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157551_0.png resize: (503, 433) 1391596047 -4.7661036449356775 treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157552_0.png resize: (475, 408) 1391596048 -6.3543886562890535 treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157582_0.png resize: (436, 443) 1391596050 -6.000914968419171 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 : 56 time used for this insertion : 0.010605096817016602 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 56 time used for this insertion : 0.01173710823059082 save missing photos in datou_result : time spend for datou_step_exec : 21.6639347076416 time spend to save output : 0.028990745544433594 total time spend for step 6 : 21.692925453186035 step7:brightness Sat Nov 1 11:02:55 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291.jpg treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290.jpg treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860.jpg treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207.jpg treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638.jpg treat image : temp/1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480.jpg treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157539_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157538_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157537_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157536_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157554_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157555_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157553_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157559_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157563_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157557_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157562_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157561_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157567_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157565_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157558_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157573_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157571_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157572_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157568_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157577_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157575_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157579_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157580_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157576_0.png treat image : temp/1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480_rle_crop_4013157583_0.png treat image : temp/1761991227_647850_1390488309_8815639b1b5f8ea502c555a7bf3e1455_85823480_rle_crop_4013157584_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157549_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157574_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157578_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157550_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157570_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157581_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157535_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157547_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157543_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157541_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157540_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157548_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157545_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157544_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157546_0.png treat image : temp/1761991227_647850_1390488393_8e694272ba513594c89dbadc547f22b3_86111291_rle_crop_4013157542_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157556_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157560_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157564_0.png treat image : temp/1761991227_647850_1390488318_32c067f8f639cd1fc6ccef11b4c4f08f_21855860_rle_crop_4013157566_0.png treat image : temp/1761991227_647850_1390488314_366ca1b7c9005549564373e1adce7545_19246207_rle_crop_4013157569_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157551_0.png treat image : temp/1761991227_647850_1390488320_3788f1cca5489fb242328ab8fbc6de2b_37025290_rle_crop_4013157552_0.png treat image : temp/1761991227_647850_1390488312_819902f2c85f2d973aba59db25d8b8f2_15563638_rle_crop_4013157582_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 : 56 time used for this insertion : 0.014325141906738281 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 56 time used for this insertion : 0.012138605117797852 save missing photos in datou_result : time spend for datou_step_exec : 5.967444658279419 time spend to save output : 0.0313563346862793 total time spend for step 7 : 5.998800992965698 step8:velours_tree Sat Nov 1 11:03:01 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure 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.09539675712585449 time spend to save output : 4.1484832763671875e-05 total time spend for step 8 : 0.09543824195861816 step9:send_mail_cod Sat Nov 1 11:03:02 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_P28055888_01-11-2025_11_03_02.pdf 28059851 imagette280598511761991382 28059852 change filename to text .change filename to text .change filename to text .imagette280598521761991382 28059853 change filename to text .change filename to text .change filename to text .imagette280598531761991382 28059854 imagette280598541761991382 28059855 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 .imagette280598551761991382 28059856 imagette280598561761991384 28059857 imagette280598571761991384 28059858 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette280598581761991384 28059860 imagette280598601761991386 28059861 change filename to text .change filename to text .change filename to text .imagette280598611761991386 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=28055888 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/28059851,28059852,28059853,28059854,28059855,28059856,28059857,28059858,28059859,28059860,28059861?tags=flou,metal,pet_fonce,mal_croppe,pet_clair,pehd,autre,papier,environnement,background,carton args[1390488393] : ((1390488393, -6.96447684603469, 492609224), (1390488393, 0.2857420491562691, 2107752395), '0.05735753440072017') We are sending mail with results at report@fotonower.com args[1390488320] : ((1390488320, -6.969263873150096, 492609224), (1390488320, 0.08088832015340432, 2107752395), '0.05735753440072017') We are sending mail with results at report@fotonower.com args[1390488318] : ((1390488318, -6.892473739226211, 492609224), (1390488318, 0.26847530356372146, 2107752395), '0.05735753440072017') We are sending mail with results at report@fotonower.com args[1390488314] : ((1390488314, -7.077859705365145, 492609224), (1390488314, 0.2380976375488399, 2107752395), '0.05735753440072017') We are sending mail with results at report@fotonower.com args[1390488312] : ((1390488312, -6.9915222690526955, 492609224), (1390488312, 0.237231558917102, 2107752395), '0.05735753440072017') We are sending mail with results at report@fotonower.com args[1390488309] : ((1390488309, -6.093045940036438, 492609224), (1390488309, -0.060609702031714896, 2107752395), '0.05735753440072017') We are sending mail with results at report@fotonower.com refus_total : 0.05735753440072017 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=28055888 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_P28055888_01-11-2025_11_03_02.pdf results_Auto_P28055888_01-11-2025_11_03_02.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055888_01-11-2025_11_03_02.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','28055888','results_Auto_P28055888_01-11-2025_11_03_02.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055888_01-11-2025_11_03_02.pdf','pdf','','0.58','0.05735753440072017') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/28055888

https://www.fotonower.com/image?json=false&list_photos_id=1390488393
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390488320
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390488318
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390488314
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390488312
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390488309
Bravo, la photo est bien prise.

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

exemples de contaminants: metal: https://www.fotonower.com/view/28059852?limit=200
exemples de contaminants: pet_fonce: https://www.fotonower.com/view/28059853?limit=200
exemples de contaminants: pet_clair: https://www.fotonower.com/view/28059855?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/28059858?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/28059861?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055888_01-11-2025_11_03_02.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/28059851,28059852,28059853,28059854,28059855,28059856,28059857,28059858,28059859,28059860,28059861?tags=flou,metal,pet_fonce,mal_croppe,pet_clair,pehd,autre,papier,environnement,background,carton.


L'équipe Fotonower 202 b'' Server: nginx Date: Sat, 01 Nov 2025 10:03:08 GMT Content-Length: 0 Connection: close X-Message-Id: S87ay2RxRQCVn0HnGyeldQ 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 [1390488393, 1390488320, 1390488318, 1390488314, 1390488312, 1390488309] 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, '3978343') ('3318', '28055888', '1390488393', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488320', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488318', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488314', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488312', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488309', None, None, None, None, None, '3978343') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.010204792022705078 save_final save missing photos in datou_result : time spend for datou_step_exec : 6.527353048324585 time spend to save output : 0.010453224182128906 total time spend for step 9 : 6.537806272506714 step10:split_time_score Sat Nov 1 11:03:08 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'}] (('11', 6),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 27102025 28055888 Nombre de photos uploadées : 6 / 23040 (0%) 27102025 28055888 Nombre de photos taguées (types de déchets): 0 / 6 (0%) 27102025 28055888 Nombre de photos taguées (volume) : 0 / 6 (0%) elapsed_time : load_data_split_time_score 1.6689300537109375e-06 elapsed_time : order_list_meta_photo_and_scores 5.0067901611328125e-06 ?????? elapsed_time : fill_and_build_computed_from_old_data 0.00023293495178222656 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.2084798812866211 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.0 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055805_01-11-2025_10_01_53.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055805 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28055805 AND mptpi.`type`=3726 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055847 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055879 order by id desc limit 1 Qualite : 0.05735753440072017 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055888_01-11-2025_11_03_02.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055888 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`=28055888 AND mptpi.`type`=3594 To do Qualite : 0.03962480709876543 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055890_01-11-2025_09_42_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055890 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`=28055890 AND mptpi.`type`=3594 To do Qualite : 0.02044935129260228 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055937_01-11-2025_10_50_53.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055937 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28055937 AND mptpi.`type`=3726 To do Qualite : 0.04044493322191266 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055969_01-11-2025_10_48_16.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055969 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28055969 AND mptpi.`type`=3726 To do Qualite : 0.07405177720096383 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28055984_01-11-2025_09_22_09.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28055984 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28055984 AND mptpi.`type`=3726 To do Qualite : 0.03461510175540124 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056036_01-11-2025_09_14_27.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056036 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`=28056036 AND mptpi.`type`=3594 To do Qualite : 0.02779737479820457 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056070_01-11-2025_09_17_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056070 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28056070 AND mptpi.`type`=3726 To do Qualite : 0.0567253390263973 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056130_01-11-2025_09_07_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056130 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28056130 AND mptpi.`type`=3726 To do Qualite : 0.021511983989197528 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056172_01-11-2025_09_03_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056172 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`=28056172 AND mptpi.`type`=3594 To do Qualite : 0.05237429002240157 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056181_01-11-2025_09_07_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056181 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28056181 AND mptpi.`type`=3726 To do Qualite : 0.0 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056184_01-11-2025_09_01_53.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056184 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28056184 AND mptpi.`type`=3726 To do Qualite : 0.11163449593537282 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28056188_01-11-2025_08_58_53.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28056188 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=28056188 AND mptpi.`type`=3726 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'27102025': {'nb_upload': 6, '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 [1390488393, 1390488320, 1390488318, 1390488314, 1390488312, 1390488309] Looping around the photos to save general results len do output : 1 /28055888Didn'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, '3978343') ('3318', '28055888', '1390488393', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488320', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488318', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488314', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488312', None, None, None, None, None, '3978343') ('3318', None, None, None, None, None, None, None, '3978343') ('3318', '28055888', '1390488309', None, None, None, None, None, '3978343') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 7 time used for this insertion : 0.010863304138183594 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.8160464763641357 time spend to save output : 0.01104879379272461 total time spend for step 10 : 3.8270952701568604 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 6 set_done_treatment 75.39user 66.25system 2:46.97elapsed 84%CPU (0avgtext+0avgdata 3821204maxresident)k 1048584inputs+79760outputs (7254major+6839914minor)pagefaults 0swaps