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 : 3887200 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 : ['3765525'] with mtr_portfolio_ids : ['27146277'] and first list_photo_ids : [] new path : /proc/3887200/ 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 , BFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 9 ; length of list_pids : 9 ; length of list_args : 9 time to download the photos : 1.3280789852142334 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 Tue Sep 23 19:40:30 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 5293 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-09-23 19:40:32.973536: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-09-23 19:40:33.000590: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3492910000 Hz 2025-09-23 19:40:33.002356: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fd5ac000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-09-23 19:40:33.002408: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-09-23 19:40:33.005058: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-09-23 19:40:33.157935: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x27d49ea0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-09-23 19:40:33.157971: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-09-23 19:40:33.158709: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-09-23 19:40:33.159036: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-23 19:40:33.164932: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-23 19:40:33.167412: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-09-23 19:40:33.167768: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-09-23 19:40:33.171153: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-09-23 19:40:33.172526: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-09-23 19:40:33.178285: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-23 19:40:33.179436: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-09-23 19:40:33.179527: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-23 19:40:33.180127: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-09-23 19:40:33.180143: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-09-23 19:40:33.180152: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-09-23 19:40:33.181221: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 4833 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-09-23 19:40:33.476894: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-09-23 19:40:33.477014: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-23 19:40:33.477037: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-23 19:40:33.477058: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-09-23 19:40:33.477078: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-09-23 19:40:33.477098: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-09-23 19:40:33.477117: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-09-23 19:40:33.477137: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-23 19:40:33.478388: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-09-23 19:40:33.479682: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-09-23 19:40:33.479718: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-09-23 19:40:33.479737: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-23 19:40:33.479754: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-09-23 19:40:33.479771: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-09-23 19:40:33.479788: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-09-23 19:40:33.479805: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-09-23 19:40:33.479822: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-23 19:40:33.480983: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-09-23 19:40:33.481024: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-09-23 19:40:33.481035: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-09-23 19:40:33.481045: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-09-23 19:40:33.482132: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 4833 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) Using TensorFlow backend. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:396: calling crop_and_resize_v1 (from tensorflow.python.ops.image_ops_impl) with box_ind is deprecated and will be removed in a future version. Instructions for updating: box_ind is deprecated, use box_indices instead WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:703: to_int32 (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:729: to_float (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. Inside mask_sub_process Inside mask_detect About to load cache.load_thcl_param To do loadFromThcl(), then load ParamDescType : thcl2847 thcls : [{'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}] thcl {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5275 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) {'thcl': {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'], 'list_hashtags_csv': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'svm_hashtag_type_desc': 5275, 'photo_desc_type': 5275, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'] Configurations: BACKBONE resnet101 BACKBONE_SHAPES [[160 160] [ 80 80] [ 40 40] [ 20 20] [ 10 10]] BACKBONE_STRIDES [4, 8, 16, 32, 64] BATCH_SIZE 1 BBOX_STD_DEV [0.1 0.1 0.2 0.2] DETECTION_MAX_INSTANCES 100 DETECTION_MIN_CONFIDENCE 0.3 DETECTION_NMS_THRESHOLD 0.3 GPU_COUNT 1 IMAGES_PER_GPU 1 IMAGE_MAX_DIM 640 IMAGE_MIN_DIM 640 IMAGE_PADDING True IMAGE_SHAPE [640 640 3] LEARNING_MOMENTUM 0.9 LEARNING_RATE 0.001 LOSS_WEIGHTS {'rpn_class_loss': 1.0, 'rpn_bbox_loss': 1.0, 'mrcnn_class_loss': 1.0, 'mrcnn_bbox_loss': 1.0, 'mrcnn_mask_loss': 1.0} MASK_POOL_SIZE 14 MASK_SHAPE [28, 28] MAX_GT_INSTANCES 100 MEAN_PIXEL [123.7 116.8 103.9] MINI_MASK_SHAPE (56, 56) NAME learn_RUBBIA_REFUS_AMIENS_23 NUM_CLASSES 9 POOL_SIZE 7 POST_NMS_ROIS_INFERENCE 1000 POST_NMS_ROIS_TRAINING 2000 ROI_POSITIVE_RATIO 0.33 RPN_ANCHOR_RATIOS [0.5, 1, 2] RPN_ANCHOR_SCALES (16, 32, 64, 128, 256) RPN_ANCHOR_STRIDE 1 RPN_BBOX_STD_DEV [0.1 0.1 0.2 0.2] RPN_NMS_THRESHOLD 0.7 RPN_TRAIN_ANCHORS_PER_IMAGE 256 STEPS_PER_EPOCH 1000 TRAIN_ROIS_PER_IMAGE 200 USE_MINI_MASK True USE_RPN_ROIS True VALIDATION_STEPS 50 WEIGHT_DECAY 0.0001 model_param file didn't exist model_name : learn_RUBBIA_REFUS_AMIENS_23 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-09-23 19:40:40.425229: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-09-23 19:40:40.605812: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-09-23 19:40:42.034058: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 4.00G (4294967296 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 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 : 9 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 24.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 9 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 44.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 26.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 15 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 23.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 19 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 20.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 19 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 28.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 9 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 69.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 2 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 37.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 37.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 Detection mask done ! Trying to reset tf kernel 3887811 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 87 tf kernel not reseted sub process len(results) : 9 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 9 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 : 4968 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.00019168853759765625 nb_pixel_total : 7099 time to create 1 rle with old method : 0.007840394973754883 length of segment : 105 time for calcul the mask position with numpy : 0.0013210773468017578 nb_pixel_total : 72739 time to create 1 rle with old method : 0.07881712913513184 length of segment : 462 time for calcul the mask position with numpy : 0.0005288124084472656 nb_pixel_total : 30758 time to create 1 rle with old method : 0.03229713439941406 length of segment : 330 time for calcul the mask position with numpy : 0.00011444091796875 nb_pixel_total : 4120 time to create 1 rle with old method : 0.004941463470458984 length of segment : 80 time for calcul the mask position with numpy : 0.00023436546325683594 nb_pixel_total : 14670 time to create 1 rle with old method : 0.016595840454101562 length of segment : 160 time for calcul the mask position with numpy : 0.00012993812561035156 nb_pixel_total : 5255 time to create 1 rle with old method : 0.005994558334350586 length of segment : 115 time for calcul the mask position with numpy : 0.00019741058349609375 nb_pixel_total : 8786 time to create 1 rle with old method : 0.009693384170532227 length of segment : 133 time for calcul the mask position with numpy : 0.00013494491577148438 nb_pixel_total : 8208 time to create 1 rle with old method : 0.00878143310546875 length of segment : 106 time for calcul the mask position with numpy : 0.00010728836059570312 nb_pixel_total : 3594 time to create 1 rle with old method : 0.004153013229370117 length of segment : 54 time for calcul the mask position with numpy : 0.00010228157043457031 nb_pixel_total : 4252 time to create 1 rle with old method : 0.0047681331634521484 length of segment : 92 time for calcul the mask position with numpy : 0.00033974647521972656 nb_pixel_total : 23423 time to create 1 rle with old method : 0.025127649307250977 length of segment : 188 time for calcul the mask position with numpy : 0.0001671314239501953 nb_pixel_total : 10483 time to create 1 rle with old method : 0.011296749114990234 length of segment : 140 time for calcul the mask position with numpy : 0.00044465065002441406 nb_pixel_total : 27878 time to create 1 rle with old method : 0.03010272979736328 length of segment : 302 time for calcul the mask position with numpy : 0.000232696533203125 nb_pixel_total : 10586 time to create 1 rle with old method : 0.011809110641479492 length of segment : 183 time for calcul the mask position with numpy : 0.00010967254638671875 nb_pixel_total : 4854 time to create 1 rle with old method : 0.005356311798095703 length of segment : 89 time for calcul the mask position with numpy : 8.392333984375e-05 nb_pixel_total : 3515 time to create 1 rle with old method : 0.003994941711425781 length of segment : 54 time for calcul the mask position with numpy : 7.700920104980469e-05 nb_pixel_total : 3942 time to create 1 rle with old method : 0.004486560821533203 length of segment : 54 time for calcul the mask position with numpy : 0.0001430511474609375 nb_pixel_total : 8463 time to create 1 rle with old method : 0.009245634078979492 length of segment : 107 time for calcul the mask position with numpy : 0.0001780986785888672 nb_pixel_total : 9194 time to create 1 rle with old method : 0.01040196418762207 length of segment : 143 time for calcul the mask position with numpy : 0.0002505779266357422 nb_pixel_total : 11383 time to create 1 rle with old method : 0.012341022491455078 length of segment : 186 time for calcul the mask position with numpy : 0.00074005126953125 nb_pixel_total : 54983 time to create 1 rle with old method : 0.05983281135559082 length of segment : 236 time for calcul the mask position with numpy : 0.00022172927856445312 nb_pixel_total : 6758 time to create 1 rle with old method : 0.008130311965942383 length of segment : 73 time for calcul the mask position with numpy : 0.0003871917724609375 nb_pixel_total : 13486 time to create 1 rle with old method : 0.018526554107666016 length of segment : 197 time for calcul the mask position with numpy : 0.0010716915130615234 nb_pixel_total : 65771 time to create 1 rle with old method : 0.07402253150939941 length of segment : 178 time for calcul the mask position with numpy : 0.0003688335418701172 nb_pixel_total : 8457 time to create 1 rle with old method : 0.009890317916870117 length of segment : 140 time for calcul the mask position with numpy : 0.00024437904357910156 nb_pixel_total : 7438 time to create 1 rle with old method : 0.008673429489135742 length of segment : 107 time for calcul the mask position with numpy : 0.0001590251922607422 nb_pixel_total : 6442 time to create 1 rle with old method : 0.00758814811706543 length of segment : 100 time for calcul the mask position with numpy : 0.0002148151397705078 nb_pixel_total : 5036 time to create 1 rle with old method : 0.0060656070709228516 length of segment : 102 time for calcul the mask position with numpy : 0.00012946128845214844 nb_pixel_total : 4718 time to create 1 rle with old method : 0.005458831787109375 length of segment : 63 time for calcul the mask position with numpy : 0.0003638267517089844 nb_pixel_total : 4972 time to create 1 rle with old method : 0.005834817886352539 length of segment : 171 time for calcul the mask position with numpy : 0.0001621246337890625 nb_pixel_total : 2669 time to create 1 rle with old method : 0.0029730796813964844 length of segment : 101 time for calcul the mask position with numpy : 0.0002655982971191406 nb_pixel_total : 6762 time to create 1 rle with old method : 0.007767677307128906 length of segment : 132 time for calcul the mask position with numpy : 0.00023174285888671875 nb_pixel_total : 6814 time to create 1 rle with old method : 0.007624387741088867 length of segment : 144 time for calcul the mask position with numpy : 0.0003826618194580078 nb_pixel_total : 9081 time to create 1 rle with old method : 0.010090827941894531 length of segment : 181 time spent for convertir_results : 1.4794058799743652 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 34 chid ids of type : 3594 Number RLEs to save : 5008 save missing photos in datou_result : time spend for datou_step_exec : 21.76952886581421 time spend to save output : 0.3659505844116211 total time spend for step 1 : 22.13547945022583 step2:crop_condition Tue Sep 23 19:40:52 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 : 9 ! batch 1 Loaded 34 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/1758649254_3887200 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 26 photos in the portfolio 3736932 time of upload the photos Elapsed time : 7.878496170043945 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/1758649262_3887200 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.0045928955078125 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 5 About to insert : list_path_to_insert length 5 new photo from crops ! About to upload 5 photos upload in portfolio : 3736932 init cache_photo without model_param we have 5 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1758649264_3887200 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 5 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.6774611473083496 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 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1385722189, 1385722170, 1385722168, 1385722167, 1385722165, 1385722162, 1385722130, 1385722126, 1385722122] Looping around the photos to save general results len do output : 34 /1385728126Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728127Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728128Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728129Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728130Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728131Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728132Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728133Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728134Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728135Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728136Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728137Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728138Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728139Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728140Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728141Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728142Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728143Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728144Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728145Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728146Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728147Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728148Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728149Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728150Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728151Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728152Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728153Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728154Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728156Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728157Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728158Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728159Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1385728160Didn'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, '3765525') ('3318', '27146277', '1385722189', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722170', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722168', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722167', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722165', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722162', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722130', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722126', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722122', None, None, None, None, None, '3765525') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 111 time used for this insertion : 0.020259618759155273 save_final save missing photos in datou_result : time spend for datou_step_exec : 13.402053117752075 time spend to save output : 0.02176642417907715 total time spend for step 2 : 13.423819541931152 step3:rle_unique_nms_with_priority Tue Sep 23 19:41:05 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 34 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++++++nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.16671013832092285 time for calcul the mask position with numpy : 0.1343364715576172 nb_pixel_total : 2066501 time to create 1 rle with new method : 0.08536648750305176 time for calcul the mask position with numpy : 0.008062124252319336 nb_pixel_total : 7099 time to create 1 rle with old method : 0.007498741149902344 create new chi : 0.24557709693908691 time to delete rle : 0.027953147888183594 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1290 TO DO : save crop sub photo not yet done ! save time : 0.1263740062713623 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.29678821563720703 time for calcul the mask position with numpy : 0.12410736083984375 nb_pixel_total : 1965983 time to create 1 rle with new method : 0.1402578353881836 time for calcul the mask position with numpy : 0.005717754364013672 nb_pixel_total : 4120 time to create 1 rle with old method : 0.004278659820556641 time for calcul the mask position with numpy : 0.006014108657836914 nb_pixel_total : 30758 time to create 1 rle with old method : 0.032077789306640625 time for calcul the mask position with numpy : 0.006407260894775391 nb_pixel_total : 72739 time to create 1 rle with old method : 0.07633566856384277 create new chi : 0.4052238464355469 time to delete rle : 0.0002760887145996094 batch 1 Loaded 7 chid ids of type : 3594 ++++Number RLEs to save : 2824 TO DO : save crop sub photo not yet done ! save time : 0.21132373809814453 nb_obj : 5 nb_hashtags : 1 time to prepare the origin masks : 0.09543538093566895 time for calcul the mask position with numpy : 0.09878921508789062 nb_pixel_total : 2033087 time to create 1 rle with new method : 0.07683086395263672 time for calcul the mask position with numpy : 0.005778074264526367 nb_pixel_total : 3594 time to create 1 rle with old method : 0.0038084983825683594 time for calcul the mask position with numpy : 0.00583648681640625 nb_pixel_total : 8208 time to create 1 rle with old method : 0.008600950241088867 time for calcul the mask position with numpy : 0.005774021148681641 nb_pixel_total : 8786 time to create 1 rle with old method : 0.009428977966308594 time for calcul the mask position with numpy : 0.005586862564086914 nb_pixel_total : 5255 time to create 1 rle with old method : 0.005502462387084961 time for calcul the mask position with numpy : 0.005701780319213867 nb_pixel_total : 14670 time to create 1 rle with old method : 0.015154361724853516 create new chi : 0.2572364807128906 time to delete rle : 0.0003032684326171875 batch 1 Loaded 11 chid ids of type : 3594 +++++++Number RLEs to save : 2216 TO DO : save crop sub photo not yet done ! save time : 0.1759796142578125 nb_obj : 8 nb_hashtags : 1 time to prepare the origin masks : 0.20708227157592773 time for calcul the mask position with numpy : 0.11690783500671387 nb_pixel_total : 1984667 time to create 1 rle with new method : 0.15126299858093262 time for calcul the mask position with numpy : 0.005952596664428711 nb_pixel_total : 3942 time to create 1 rle with old method : 0.004342555999755859 time for calcul the mask position with numpy : 0.0058820247650146484 nb_pixel_total : 3515 time to create 1 rle with old method : 0.003759622573852539 time for calcul the mask position with numpy : 0.00574803352355957 nb_pixel_total : 4854 time to create 1 rle with old method : 0.005238056182861328 time for calcul the mask position with numpy : 0.00589442253112793 nb_pixel_total : 10586 time to create 1 rle with old method : 0.011646509170532227 time for calcul the mask position with numpy : 0.005957841873168945 nb_pixel_total : 27878 time to create 1 rle with old method : 0.03035426139831543 time for calcul the mask position with numpy : 0.006219625473022461 nb_pixel_total : 10483 time to create 1 rle with old method : 0.011742830276489258 time for calcul the mask position with numpy : 0.0065021514892578125 nb_pixel_total : 23423 time to create 1 rle with old method : 0.025577545166015625 time for calcul the mask position with numpy : 0.006212472915649414 nb_pixel_total : 4252 time to create 1 rle with old method : 0.004554271697998047 create new chi : 0.4245438575744629 time to delete rle : 0.0004258155822753906 batch 1 Loaded 17 chid ids of type : 3594 ++++++++++++++Number RLEs to save : 3284 TO DO : save crop sub photo not yet done ! save time : 0.24381303787231445 nb_obj : 7 nb_hashtags : 3 time to prepare the origin masks : 0.1123497486114502 time for calcul the mask position with numpy : 0.13257598876953125 nb_pixel_total : 1903568 time to create 1 rle with new method : 0.07787275314331055 time for calcul the mask position with numpy : 0.005948543548583984 nb_pixel_total : 65765 time to create 1 rle with old method : 0.07020854949951172 time for calcul the mask position with numpy : 0.011368513107299805 nb_pixel_total : 13486 time to create 1 rle with old method : 0.014811515808105469 time for calcul the mask position with numpy : 0.0061719417572021484 nb_pixel_total : 6758 time to create 1 rle with old method : 0.011259794235229492 time for calcul the mask position with numpy : 0.007166862487792969 nb_pixel_total : 54983 time to create 1 rle with old method : 0.058977365493774414 time for calcul the mask position with numpy : 0.00628972053527832 nb_pixel_total : 11383 time to create 1 rle with old method : 0.012395381927490234 time for calcul the mask position with numpy : 0.005934476852416992 nb_pixel_total : 9194 time to create 1 rle with old method : 0.010037422180175781 time for calcul the mask position with numpy : 0.005730628967285156 nb_pixel_total : 8463 time to create 1 rle with old method : 0.009253263473510742 create new chi : 0.45673346519470215 time to delete rle : 0.0004048347473144531 batch 1 Loaded 15 chid ids of type : 3594 +++++++Number RLEs to save : 3316 TO DO : save crop sub photo not yet done ! save time : 0.25527358055114746 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.07034778594970703 time for calcul the mask position with numpy : 0.02573537826538086 nb_pixel_total : 2046227 time to create 1 rle with new method : 0.13525080680847168 time for calcul the mask position with numpy : 0.005623340606689453 nb_pixel_total : 5036 time to create 1 rle with old method : 0.005456447601318359 time for calcul the mask position with numpy : 0.006257295608520508 nb_pixel_total : 6442 time to create 1 rle with old method : 0.006769657135009766 time for calcul the mask position with numpy : 0.005517482757568359 nb_pixel_total : 7438 time to create 1 rle with old method : 0.00743865966796875 time for calcul the mask position with numpy : 0.0057446956634521484 nb_pixel_total : 8457 time to create 1 rle with old method : 0.008863449096679688 create new chi : 0.2129836082458496 time to delete rle : 0.00029087066650390625 batch 1 Loaded 9 chid ids of type : 3594 +++++Number RLEs to save : 1978 TO DO : save crop sub photo not yet done ! save time : 0.15075373649597168 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.04612255096435547 time for calcul the mask position with numpy : 0.1180424690246582 nb_pixel_total : 2068882 time to create 1 rle with new method : 0.06563615798950195 time for calcul the mask position with numpy : 0.005759239196777344 nb_pixel_total : 4718 time to create 1 rle with old method : 0.0049152374267578125 create new chi : 0.19804167747497559 time to delete rle : 0.000194549560546875 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1206 TO DO : save crop sub photo not yet done ! save time : 0.12505555152893066 nb_obj : 5 nb_hashtags : 2 time to prepare the origin masks : 0.08887434005737305 time for calcul the mask position with numpy : 0.13353633880615234 nb_pixel_total : 2043302 time to create 1 rle with new method : 0.13404631614685059 time for calcul the mask position with numpy : 0.0058252811431884766 nb_pixel_total : 9081 time to create 1 rle with old method : 0.009747982025146484 time for calcul the mask position with numpy : 0.005589485168457031 nb_pixel_total : 6814 time to create 1 rle with old method : 0.007325649261474609 time for calcul the mask position with numpy : 0.006401538848876953 nb_pixel_total : 6762 time to create 1 rle with old method : 0.007136821746826172 time for calcul the mask position with numpy : 0.005565166473388672 nb_pixel_total : 2669 time to create 1 rle with old method : 0.00276947021484375 time for calcul the mask position with numpy : 0.005575418472290039 nb_pixel_total : 4972 time to create 1 rle with old method : 0.005378246307373047 create new chi : 0.3391091823577881 time to delete rle : 0.00035834312438964844 batch 1 Loaded 11 chid ids of type : 3594 +++++Number RLEs to save : 2538 TO DO : save crop sub photo not yet done ! save time : 0.2037363052368164 No data in photo_id : 1385722122 map_output_result : {1385722189: (0.0, 'Should be the crop_list due to order', 0), 1385722170: (0.0, 'Should be the crop_list due to order', 0), 1385722168: (0.0, 'Should be the crop_list due to order', 0), 1385722167: (0.0, 'Should be the crop_list due to order', 0), 1385722165: (0.0, 'Should be the crop_list due to order', 0), 1385722162: (0.0, 'Should be the crop_list due to order', 0), 1385722130: (0.0, 'Should be the crop_list due to order', 0), 1385722126: (0.0, 'Should be the crop_list due to order', 0), 1385722122: (0.0, 'Should be the crop_list due to order', 0.0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1385722189, 1385722170, 1385722168, 1385722167, 1385722165, 1385722162, 1385722130, 1385722126, 1385722122] Looping around the photos to save general results len do output : 9 /1385722189.Didn't retrieve data . /1385722170.Didn't retrieve data . /1385722168.Didn't retrieve data . /1385722167.Didn't retrieve data . /1385722165.Didn't retrieve data . /1385722162.Didn't retrieve data . /1385722130.Didn't retrieve data . /1385722126.Didn't retrieve data . /1385722122.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, '3765525') ('3318', '27146277', '1385722189', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722170', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722168', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722167', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722165', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722162', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722130', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722126', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722122', None, None, None, None, None, '3765525') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 27 time used for this insertion : 0.016846895217895508 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.432668685913086 time spend to save output : 0.017190217971801758 total time spend for step 3 : 5.449858903884888 step4:ventilate_hashtags_in_portfolio Tue Sep 23 19:41:11 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 : 27146277 get user id for portfolio 27146277 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`=27146277 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_fonce','background','papier','metal','environnement','carton','pehd','mal_croppe','flou','pet_clair','autre')) 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`=27146277 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_fonce','background','papier','metal','environnement','carton','pehd','mal_croppe','flou','pet_clair','autre')) 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`=27146277 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_fonce','background','papier','metal','environnement','carton','pehd','mal_croppe','flou','pet_clair','autre')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/27146433,27146434,27146435,27146436,27146437,27146438,27146439,27146440,27146441,27146442,27146443?tags=pet_fonce,background,papier,metal,environnement,carton,pehd,mal_croppe,flou,pet_clair,autre Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1385722189, 1385722170, 1385722168, 1385722167, 1385722165, 1385722162, 1385722130, 1385722126, 1385722122] Looping around the photos to save general results len do output : 1 /27146277. 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, '3765525') ('3318', '27146277', '1385722189', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722170', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722168', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722167', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722165', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722162', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722130', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722126', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722122', None, None, None, None, None, '3765525') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 10 time used for this insertion : 0.014742612838745117 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6443431377410889 time spend to save output : 0.014965295791625977 total time spend for step 4 : 1.6593084335327148 step5:final Tue Sep 23 19:41:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : {1385722189: ('0.025537069187242797',), 1385722170: ('0.025537069187242797',), 1385722168: ('0.025537069187242797',), 1385722167: ('0.025537069187242797',), 1385722165: ('0.025537069187242797',), 1385722162: ('0.025537069187242797',), 1385722130: ('0.025537069187242797',), 1385722126: ('0.025537069187242797',), 1385722122: ('0.025537069187242797',)} new output for save of step final : {1385722189: ('0.025537069187242797',), 1385722170: ('0.025537069187242797',), 1385722168: ('0.025537069187242797',), 1385722167: ('0.025537069187242797',), 1385722165: ('0.025537069187242797',), 1385722162: ('0.025537069187242797',), 1385722130: ('0.025537069187242797',), 1385722126: ('0.025537069187242797',), 1385722122: ('0.025537069187242797',)} [1385722189, 1385722170, 1385722168, 1385722167, 1385722165, 1385722162, 1385722130, 1385722126, 1385722122] Looping around the photos to save general results len do output : 9 /1385722189.Didn't retrieve data . /1385722170.Didn't retrieve data . /1385722168.Didn't retrieve data . /1385722167.Didn't retrieve data . /1385722165.Didn't retrieve data . /1385722162.Didn't retrieve data . /1385722130.Didn't retrieve data . /1385722126.Didn't retrieve data . /1385722122.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, '3765525') ('3318', '27146277', '1385722189', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722170', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722168', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722167', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722165', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722162', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722130', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722126', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722122', None, None, None, None, None, '3765525') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 27 time used for this insertion : 0.01667618751525879 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.11876344680786133 time spend to save output : 0.017123937606811523 total time spend for step 5 : 0.13588738441467285 step6:blur_detection Tue Sep 23 19:41:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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/1758649228_3887200_1385722189_cd0a4349322f15151d3859807af095cb.jpg resize: (1080, 1920) 1385722189 0.5099637231972324 treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991.jpg resize: (1080, 1920) 1385722170 -0.7477576711333082 treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28.jpg resize: (1080, 1920) 1385722168 -2.671648253445745 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39.jpg resize: (1080, 1920) 1385722167 -0.08480709696620865 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358.jpg resize: (1080, 1920) 1385722165 0.4596081090001457 treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e.jpg resize: (1080, 1920) 1385722162 0.6452920066010667 treat image : temp/1758649228_3887200_1385722130_0dc593732e7ad56d552d5a3506d42832.jpg resize: (1080, 1920) 1385722130 -1.6700156253285339 treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602.jpg resize: (1080, 1920) 1385722126 0.41613327937079836 treat image : temp/1758649228_3887200_1385722122_1a3418405d7c206de6706a1f3ccb5e79.jpg resize: (1080, 1920) 1385722122 1.5534396542685236 treat image : temp/1758649228_3887200_1385722189_cd0a4349322f15151d3859807af095cb_rle_crop_3971939814_0.png resize: (105, 91) 1385728126 -0.648691402197668 treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991_rle_crop_3971939817_0.png resize: (80, 90) 1385728127 -1.5952945381641668 treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939819_0.png resize: (90, 107) 1385728128 -1.293538050761759 treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939822_0.png resize: (54, 87) 1385728129 -0.22932440685413402 treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939820_0.png resize: (133, 98) 1385728130 -0.8985744707550862 treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939821_0.png resize: (106, 100) 1385728131 -0.22068311631607015 treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939818_0.png resize: (164, 138) 1385728132 -1.5796305682113523 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939827_0.png resize: (186, 101) 1385728133 -1.7195403162754264 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939830_0.png resize: (53, 90) 1385728134 3.2324049092593654 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939824_0.png resize: (170, 236) 1385728135 -0.784099148403671 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939825_0.png resize: (140, 114) 1385728136 -1.0436467260556967 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939823_0.png resize: (87, 95) 1385728137 -1.3954884085345256 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939826_0.png resize: (183, 271) 1385728138 -2.4396402664232184 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939829_0.png resize: (53, 97) 1385728139 -0.7652868413992863 treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939828_0.png resize: (89, 72) 1385728140 -0.7704549688291468 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939833_0.png resize: (186, 115) 1385728141 -1.0460266985689344 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939837_0.png resize: (143, 637) 1385728142 -0.937942129436835 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939831_0.png resize: (107, 111) 1385728143 -0.0682392237641634 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939832_0.png resize: (143, 123) 1385728144 -1.3876369799412622 treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939839_0.png resize: (107, 95) 1385728145 -0.7121677663371033 treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939838_0.png resize: (114, 133) 1385728146 -2.599509242961102 treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939841_0.png resize: (102, 94) 1385728147 -2.107069968527848 treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939843_0.png resize: (162, 82) 1385728148 -2.5185197302374016 treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939846_0.png resize: (144, 59) 1385728149 2.117589913409256 treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939844_0.png resize: (101, 35) 1385728150 1.3167878139382463 treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939845_0.png resize: (132, 112) 1385728151 -2.0110748027118617 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939835_0.png resize: (70, 136) 1385728152 -1.4718945329965882 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939836_0.png resize: (150, 128) 1385728153 -1.3867299386335352 treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939840_0.png resize: (95, 101) 1385728154 -1.474649432179186 treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991_rle_crop_3971939816_0.png resize: (312, 181) 1385728156 -1.0390231478383085 treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991_rle_crop_3971939815_0.png resize: (454, 298) 1385728157 -0.0732003053569769 treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939834_0.png resize: (232, 366) 1385728158 -0.7983969276570306 treat image : temp/1758649228_3887200_1385722130_0dc593732e7ad56d552d5a3506d42832_rle_crop_3971939842_0.png resize: (63, 92) 1385728159 -0.6236646600646537 treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939847_0.png resize: (177, 99) 1385728160 -2.1516814979121826 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 : 43 time used for this insertion : 0.01900768280029297 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 43 time used for this insertion : 0.016996145248413086 save missing photos in datou_result : time spend for datou_step_exec : 6.892288446426392 time spend to save output : 0.040624380111694336 total time spend for step 6 : 6.932912826538086 step7:brightness Tue Sep 23 19:41:19 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/1758649228_3887200_1385722189_cd0a4349322f15151d3859807af095cb.jpg treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991.jpg treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28.jpg treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39.jpg treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358.jpg treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e.jpg treat image : temp/1758649228_3887200_1385722130_0dc593732e7ad56d552d5a3506d42832.jpg treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602.jpg treat image : temp/1758649228_3887200_1385722122_1a3418405d7c206de6706a1f3ccb5e79.jpg treat image : temp/1758649228_3887200_1385722189_cd0a4349322f15151d3859807af095cb_rle_crop_3971939814_0.png treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991_rle_crop_3971939817_0.png treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939819_0.png treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939822_0.png treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939820_0.png treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939821_0.png treat image : temp/1758649228_3887200_1385722168_3118fcfe696ce533095da33ed341bf28_rle_crop_3971939818_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939827_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939830_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939824_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939825_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939823_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939826_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939829_0.png treat image : temp/1758649228_3887200_1385722167_62092aed47386cc0b83e10f29767ae39_rle_crop_3971939828_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939833_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939837_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939831_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939832_0.png treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939839_0.png treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939838_0.png treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939841_0.png treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939843_0.png treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939846_0.png treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939844_0.png treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939845_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939835_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939836_0.png treat image : temp/1758649228_3887200_1385722162_4b8bb83ec08b907f6844ff593f6ef15e_rle_crop_3971939840_0.png treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991_rle_crop_3971939816_0.png treat image : temp/1758649228_3887200_1385722170_c079237d2a5d7b5323860b82775bd991_rle_crop_3971939815_0.png treat image : temp/1758649228_3887200_1385722165_4d7ed622d1661f6de77ce43c80b76358_rle_crop_3971939834_0.png treat image : temp/1758649228_3887200_1385722130_0dc593732e7ad56d552d5a3506d42832_rle_crop_3971939842_0.png treat image : temp/1758649228_3887200_1385722126_a6e211da2d5df58a8fa9a206591a8602_rle_crop_3971939847_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 : 43 time used for this insertion : 0.017118215560913086 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 43 time used for this insertion : 0.016236305236816406 save missing photos in datou_result : time spend for datou_step_exec : 2.0603439807891846 time spend to save output : 0.03767752647399902 total time spend for step 7 : 2.0980215072631836 step8:velours_tree Tue Sep 23 19:41:22 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.134688138961792 time spend to save output : 3.5762786865234375e-05 total time spend for step 8 : 0.13472390174865723 step9:send_mail_cod Tue Sep 23 19:41:22 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_P27146277_23-09-2025_19_41_22.pdf 27146433 imagette271464331758649282 27146434 imagette271464341758649282 27146435 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 .imagette271464351758649282 27146436 imagette271464361758649283 27146438 change filename to text .change filename to text .change filename to text .imagette271464381758649283 27146439 imagette271464391758649283 27146440 imagette271464401758649283 27146441 imagette271464411758649283 27146442 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette271464421758649283 27146443 imagette271464431758649284 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=27146277 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/27146433,27146434,27146435,27146436,27146437,27146438,27146439,27146440,27146441,27146442,27146443?tags=pet_fonce,background,papier,metal,environnement,carton,pehd,mal_croppe,flou,pet_clair,autre args[1385722189] : ((1385722189, 0.5099637231972324, 492688767), (1385722189, 0.20680723594576478, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722170] : ((1385722170, -0.7477576711333082, 492688767), (1385722170, 0.8138699419055885, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722168] : ((1385722168, -2.671648253445745, 492609224), (1385722168, 0.3940012229214449, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722167] : ((1385722167, -0.08480709696620865, 492688767), (1385722167, 0.26735829638176634, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722165] : ((1385722165, 0.4596081090001457, 492688767), (1385722165, 0.3160845335738696, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722162] : ((1385722162, 0.6452920066010667, 492688767), (1385722162, 0.3311181348350147, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722130] : ((1385722130, -1.6700156253285339, 492688767), (1385722130, 1.8754074307181454, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722126] : ((1385722126, 0.41613327937079836, 492688767), (1385722126, 0.8753911462273088, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com args[1385722122] : ((1385722122, 1.5534396542685236, 492688767), (1385722122, 0.48532050237505914, 2107752395), '0.025537069187242797') We are sending mail with results at report@fotonower.com refus_total : 0.025537069187242797 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27146277 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_P27146277_23-09-2025_19_41_22.pdf results_Auto_P27146277_23-09-2025_19_41_22.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27146277_23-09-2025_19_41_22.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','27146277','results_Auto_P27146277_23-09-2025_19_41_22.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27146277_23-09-2025_19_41_22.pdf','pdf','','0.15','0.025537069187242797') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/27146277

https://www.fotonower.com/image?json=false&list_photos_id=1385722189
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722170
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722168
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722167
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722165
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722162
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722130
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722126
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1385722122
La photo est trop floue, merci de reprendre une photo.(avec le score = 1.5534396542685236)

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

exemples de contaminants: papier: https://www.fotonower.com/view/27146435?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/27146438?limit=200
exemples de contaminants: pet_clair: https://www.fotonower.com/view/27146442?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27146277_23-09-2025_19_41_22.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/27146433,27146434,27146435,27146436,27146437,27146438,27146439,27146440,27146441,27146442,27146443?tags=pet_fonce,background,papier,metal,environnement,carton,pehd,mal_croppe,flou,pet_clair,autre.


L'équipe Fotonower 202 b'' Server: nginx Date: Tue, 23 Sep 2025 17:41:25 GMT Content-Length: 0 Connection: close X-Message-Id: IhKmZhCyRp-tz6dRMmG_UQ 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 [1385722189, 1385722170, 1385722168, 1385722167, 1385722165, 1385722162, 1385722130, 1385722126, 1385722122] 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, '3765525') ('3318', '27146277', '1385722189', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722170', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722168', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722167', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722165', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722162', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722130', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722126', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722122', None, None, None, None, None, '3765525') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.01360177993774414 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.807218074798584 time spend to save output : 0.013882875442504883 total time spend for step 9 : 3.821100950241089 step10:split_time_score Tue Sep 23 19:41:25 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('18', 9),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 23092025 27146277 Nombre de photos uploadées : 9 / 23040 (0%) 23092025 27146277 Nombre de photos taguées (types de déchets): 0 / 9 (0%) 23092025 27146277 Nombre de photos taguées (volume) : 0 / 9 (0%) elapsed_time : load_data_split_time_score 3.337860107421875e-06 elapsed_time : order_list_meta_photo_and_scores 1.0728836059570312e-05 ????????? elapsed_time : fill_and_build_computed_from_old_data 0.0005276203155517578 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.21880626678466797 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.26416298948688277 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27120440_23-09-2025_09_11_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27120440 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`=27120440 AND mptpi.`type`=3594 To do Qualite : 0.2631321855709877 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27120443_23-09-2025_09_01_57.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27120443 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`=27120443 AND mptpi.`type`=3594 To do Qualite : 0.04308416923868314 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27120447_23-09-2025_08_51_59.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27120447 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`=27120447 AND mptpi.`type`=3594 To do Qualite : 0.06695908224400872 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27120448_23-09-2025_08_42_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27120448 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`=27120448 AND mptpi.`type`=3594 To do Qualite : 0.08693784360532408 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27124555_23-09-2025_10_12_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27124555 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`=27124555 AND mptpi.`type`=3594 To do Qualite : 0.07001428674768517 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27144383_23-09-2025_19_31_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27144383 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`=27144383 AND mptpi.`type`=3594 To do Qualite : 0.032576613940329215 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27139071_23-09-2025_16_21_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27139071 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`=27139071 AND mptpi.`type`=3594 To do Qualite : 0.10417656703885254 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27135684_23-09-2025_15_02_10.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27135684 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`=27135684 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27142985 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27142988 order by id desc limit 1 Qualite : 0.08528746668069585 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27144388_23-09-2025_19_21_25.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27144388 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`=27144388 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27146275 order by id desc limit 1 Qualite : 0.025537069187242797 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27146277_23-09-2025_19_41_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27146277 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`=27146277 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'23092025': {'nb_upload': 9, '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 [1385722189, 1385722170, 1385722168, 1385722167, 1385722165, 1385722162, 1385722130, 1385722126, 1385722122] Looping around the photos to save general results len do output : 1 /27146277Didn'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, '3765525') ('3318', '27146277', '1385722189', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722170', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722168', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722167', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722165', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722162', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722130', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722126', None, None, None, None, None, '3765525') ('3318', None, None, None, None, None, None, None, '3765525') ('3318', '27146277', '1385722122', None, None, None, None, None, '3765525') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 10 time used for this insertion : 0.01671290397644043 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.776677131652832 time spend to save output : 0.01694345474243164 total time spend for step 10 : 3.7936205863952637 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 9 set_done_treatment 28.69user 14.96system 1:04.93elapsed 67%CPU (0avgtext+0avgdata 2832272maxresident)k 469520inputs+9752outputs (281major+1490305minor)pagefaults 0swaps