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 : 3491317 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 : ['3416127'] with mtr_portfolio_ids : ['25559193'] and first list_photo_ids : [] new path : /proc/3491317/ 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 , BFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 13 ; length of list_pids : 13 ; length of list_args : 13 time to download the photos : 1.669543981552124 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 Thu Jul 31 20: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 : 8538 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-07-31 20:40:33.732098: 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-07-31 20:40:33.763508: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493035000 Hz 2025-07-31 20:40:33.765065: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fd870000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-07-31 20:40:33.765117: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-07-31 20:40:33.767772: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-07-31 20:40:33.906119: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x11787f00 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-07-31 20:40:33.906153: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-07-31 20:40:33.907015: 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-07-31 20:40:33.907319: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-07-31 20:40:33.909407: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-07-31 20:40:33.911579: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-07-31 20:40:33.911905: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-07-31 20:40:33.914228: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-07-31 20:40:33.915315: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-07-31 20:40:33.919994: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-07-31 20:40:33.921403: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-07-31 20:40:33.921482: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-07-31 20:40:33.922181: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-07-31 20:40:33.922197: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-07-31 20:40:33.922206: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-07-31 20:40:33.923404: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 7883 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-07-31 20:40:34.187397: 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-07-31 20:40:34.187513: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-07-31 20:40:34.187531: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-07-31 20:40:34.187547: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-07-31 20:40:34.187563: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-07-31 20:40:34.187578: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-07-31 20:40:34.187593: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-07-31 20:40:34.187609: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-07-31 20:40:34.188754: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-07-31 20:40:34.189986: 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-07-31 20:40:34.190031: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-07-31 20:40:34.190050: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-07-31 20:40:34.190068: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-07-31 20:40:34.190085: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-07-31 20:40:34.190101: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-07-31 20:40:34.190118: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-07-31 20:40:34.190135: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-07-31 20:40:34.191280: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-07-31 20:40:34.191320: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-07-31 20:40:34.191329: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-07-31 20:40:34.191336: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-07-31 20:40:34.192551: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 7883 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-07-31 20:40:42.143112: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-07-31 20:40:42.325606: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 local folder : /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23 /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23/mask_model.h5 size_local : 256009536 size in s3 : 256009536 create time local : 2021-08-09 09:43:22 create time in s3 : 2021-08-06 18:54:04 mask_model.h5 already exist and didn't need to update list_images length : 13 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 17.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: 19.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 32.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: 14.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: 38.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 15.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 9 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 38.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 : 1 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 35.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 36.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 29.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 17.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 6.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 11 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 17.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 : 12 Detection mask done ! Trying to reset tf kernel 3492020 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 2450 tf kernel not reseted sub process len(results) : 13 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 13 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 : 7739 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.00038313865661621094 nb_pixel_total : 7532 time to create 1 rle with old method : 0.010906696319580078 length of segment : 100 time for calcul the mask position with numpy : 0.014945507049560547 nb_pixel_total : 654228 time to create 1 rle with new method : 0.036649465560913086 length of segment : 961 time for calcul the mask position with numpy : 0.01143789291381836 nb_pixel_total : 668743 time to create 1 rle with new method : 0.0363316535949707 length of segment : 1060 time for calcul the mask position with numpy : 0.013360977172851562 nb_pixel_total : 716477 time to create 1 rle with new method : 0.02347731590270996 length of segment : 969 time for calcul the mask position with numpy : 0.0003552436828613281 nb_pixel_total : 17607 time to create 1 rle with old method : 0.018975257873535156 length of segment : 180 time for calcul the mask position with numpy : 0.0016276836395263672 nb_pixel_total : 124095 time to create 1 rle with old method : 0.13278436660766602 length of segment : 415 time for calcul the mask position with numpy : 0.0015316009521484375 nb_pixel_total : 102107 time to create 1 rle with old method : 0.10955476760864258 length of segment : 537 time for calcul the mask position with numpy : 0.0001456737518310547 nb_pixel_total : 5832 time to create 1 rle with old method : 0.00664067268371582 length of segment : 98 time for calcul the mask position with numpy : 0.0001461505889892578 nb_pixel_total : 3218 time to create 1 rle with old method : 0.0036859512329101562 length of segment : 72 time for calcul the mask position with numpy : 0.0002524852752685547 nb_pixel_total : 15764 time to create 1 rle with old method : 0.017447471618652344 length of segment : 160 time for calcul the mask position with numpy : 0.0017120838165283203 nb_pixel_total : 118853 time to create 1 rle with old method : 0.12817859649658203 length of segment : 535 time for calcul the mask position with numpy : 8.58306884765625e-05 nb_pixel_total : 2290 time to create 1 rle with old method : 0.0028383731842041016 length of segment : 46 time for calcul the mask position with numpy : 6.175041198730469e-05 nb_pixel_total : 2140 time to create 1 rle with old method : 0.0026636123657226562 length of segment : 51 time for calcul the mask position with numpy : 0.0015954971313476562 nb_pixel_total : 111633 time to create 1 rle with old method : 0.1327979564666748 length of segment : 554 time for calcul the mask position with numpy : 0.0024480819702148438 nb_pixel_total : 87946 time to create 1 rle with old method : 0.09687423706054688 length of segment : 514 time for calcul the mask position with numpy : 0.00028777122497558594 nb_pixel_total : 7938 time to create 1 rle with old method : 0.008879423141479492 length of segment : 95 time for calcul the mask position with numpy : 0.00038170814514160156 nb_pixel_total : 8124 time to create 1 rle with old method : 0.009099006652832031 length of segment : 150 time for calcul the mask position with numpy : 0.01684403419494629 nb_pixel_total : 674776 time to create 1 rle with new method : 0.025719165802001953 length of segment : 932 time for calcul the mask position with numpy : 0.0008022785186767578 nb_pixel_total : 40723 time to create 1 rle with old method : 0.04413461685180664 length of segment : 219 time for calcul the mask position with numpy : 8.487701416015625e-05 nb_pixel_total : 1713 time to create 1 rle with old method : 0.0020639896392822266 length of segment : 57 time for calcul the mask position with numpy : 0.002176046371459961 nb_pixel_total : 113790 time to create 1 rle with old method : 0.12535572052001953 length of segment : 518 time for calcul the mask position with numpy : 0.0003807544708251953 nb_pixel_total : 13782 time to create 1 rle with old method : 0.01845097541809082 length of segment : 152 time for calcul the mask position with numpy : 0.0003533363342285156 nb_pixel_total : 12438 time to create 1 rle with old method : 0.015046119689941406 length of segment : 140 time for calcul the mask position with numpy : 0.0012509822845458984 nb_pixel_total : 63546 time to create 1 rle with old method : 0.07207036018371582 length of segment : 257 time for calcul the mask position with numpy : 0.00020623207092285156 nb_pixel_total : 8451 time to create 1 rle with old method : 0.010036230087280273 length of segment : 145 time for calcul the mask position with numpy : 0.0004620552062988281 nb_pixel_total : 22420 time to create 1 rle with old method : 0.02634286880493164 length of segment : 144 time for calcul the mask position with numpy : 0.0002837181091308594 nb_pixel_total : 14625 time to create 1 rle with old method : 0.020692825317382812 length of segment : 171 time for calcul the mask position with numpy : 0.0002906322479248047 nb_pixel_total : 5933 time to create 1 rle with old method : 0.007323026657104492 length of segment : 99 time for calcul the mask position with numpy : 0.0006072521209716797 nb_pixel_total : 22559 time to create 1 rle with old method : 0.027583837509155273 length of segment : 104 time for calcul the mask position with numpy : 0.0028302669525146484 nb_pixel_total : 114052 time to create 1 rle with old method : 0.12424397468566895 length of segment : 533 time for calcul the mask position with numpy : 0.0008847713470458984 nb_pixel_total : 25083 time to create 1 rle with old method : 0.028124570846557617 length of segment : 174 time for calcul the mask position with numpy : 0.0005035400390625 nb_pixel_total : 25554 time to create 1 rle with old method : 0.029091596603393555 length of segment : 138 time spent for convertir_results : 2.9448354244232178 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 32 chid ids of type : 3594 Number RLEs to save : 10280 save missing photos in datou_result : time spend for datou_step_exec : 30.067737102508545 time spend to save output : 0.5989847183227539 total time spend for step 1 : 30.6667218208313 step2:crop_condition Thu Jul 31 20:41:01 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 : 13 ! batch 1 Loaded 32 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 ! map_result returned by crop_photo_return_map_crop : length : 8 About to insert : list_path_to_insert length 8 new photo from crops ! About to upload 8 photos upload in portfolio : 3736932 init cache_photo without model_param we have 8 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1753987263_3491317 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 8 photos in the portfolio 3736932 time of upload the photos Elapsed time : 2.0637216567993164 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 ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 4 About to insert : list_path_to_insert length 4 new photo from crops ! About to upload 4 photos upload in portfolio : 3736932 init cache_photo without model_param we have 4 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1753987268_3491317 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 4 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.3199527263641357 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! 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 : 20 About to insert : list_path_to_insert length 20 new photo from crops ! About to upload 20 photos upload in portfolio : 3736932 init cache_photo without model_param we have 20 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1753987282_3491317 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 20 photos in the portfolio 3736932 time of upload the photos Elapsed time : 6.464781284332275 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 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 [1374643450, 1374643448, 1374643442, 1374643437, 1374643433, 1374643419, 1374643417, 1374643415, 1374643412, 1374643409, 1374643405, 1374643379, 1374643374] Looping around the photos to save general results len do output : 32 /1374644556Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644557Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644558Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644560Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644561Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644562Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644563Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644564Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644567Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644568Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644569Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644570Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644613Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644614Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644616Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644617Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644618Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644619Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644621Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644622Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644623Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644625Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644626Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644627Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644629Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644631Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644633Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644634Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644636Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644637Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644638Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1374644640Didn'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, '3416127') ('3318', '25559193', '1374643450', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643448', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643442', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643437', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643433', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643419', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643417', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643415', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643412', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643409', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643405', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643379', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643374', None, None, None, None, None, '3416127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 109 time used for this insertion : 0.02070331573486328 save_final save missing photos in datou_result : time spend for datou_step_exec : 26.567310094833374 time spend to save output : 0.022298812866210938 total time spend for step 2 : 26.589608907699585 step3:rle_unique_nms_with_priority Thu Jul 31 20:41:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 32 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.23430466651916504 time for calcul the mask position with numpy : 0.10316896438598633 nb_pixel_total : 2066068 time to create 1 rle with new method : 0.17798447608947754 time for calcul the mask position with numpy : 0.010746955871582031 nb_pixel_total : 7532 time to create 1 rle with old method : 0.010469675064086914 create new chi : 0.32665514945983887 time to delete rle : 0.02943873405456543 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1280 TO DO : save crop sub photo not yet done ! save time : 0.11196398735046387 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.38741350173950195 time for calcul the mask position with numpy : 0.15983915328979492 nb_pixel_total : 1419372 time to create 1 rle with new method : 0.1271522045135498 time for calcul the mask position with numpy : 0.013159990310668945 nb_pixel_total : 654228 time to create 1 rle with new method : 0.11680030822753906 create new chi : 0.4347264766693115 time to delete rle : 0.0004284381866455078 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 3002 TO DO : save crop sub photo not yet done ! save time : 0.1958317756652832 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.04871797561645508 time for calcul the mask position with numpy : 0.0686335563659668 nb_pixel_total : 1404857 time to create 1 rle with new method : 0.12971067428588867 time for calcul the mask position with numpy : 0.014076948165893555 nb_pixel_total : 668743 time to create 1 rle with new method : 0.1275463104248047 create new chi : 0.3573939800262451 time to delete rle : 0.0005545616149902344 batch 1 Loaded 3 chid ids of type : 3594 +++Number RLEs to save : 3200 TO DO : save crop sub photo not yet done ! save time : 0.22127246856689453 nb_obj : 3 nb_hashtags : 1 time to prepare the origin masks : 0.16811871528625488 time for calcul the mask position with numpy : 0.11191129684448242 nb_pixel_total : 1217328 time to create 1 rle with new method : 0.12786054611206055 time for calcul the mask position with numpy : 0.0070343017578125 nb_pixel_total : 122188 time to create 1 rle with old method : 0.17419815063476562 time for calcul the mask position with numpy : 0.008784770965576172 nb_pixel_total : 17607 time to create 1 rle with old method : 0.020369768142700195 time for calcul the mask position with numpy : 0.011485099792480469 nb_pixel_total : 716477 time to create 1 rle with new method : 0.20795440673828125 create new chi : 0.693457841873169 time to delete rle : 0.0009517669677734375 batch 1 Loaded 7 chid ids of type : 3594 ++++Number RLEs to save : 4051 TO DO : save crop sub photo not yet done ! save time : 0.259951114654541 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.05651044845581055 time for calcul the mask position with numpy : 0.09173369407653809 nb_pixel_total : 1965661 time to create 1 rle with new method : 0.19732236862182617 time for calcul the mask position with numpy : 0.007234334945678711 nb_pixel_total : 5832 time to create 1 rle with old method : 0.006749868392944336 time for calcul the mask position with numpy : 0.007238149642944336 nb_pixel_total : 102107 time to create 1 rle with old method : 0.12666583061218262 create new chi : 0.44776296615600586 time to delete rle : 0.0004131793975830078 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 2350 TO DO : save crop sub photo not yet done ! save time : 0.17360687255859375 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.12482786178588867 time for calcul the mask position with numpy : 0.1201772689819336 nb_pixel_total : 1935765 time to create 1 rle with new method : 0.38697123527526855 time for calcul the mask position with numpy : 0.008844137191772461 nb_pixel_total : 118853 time to create 1 rle with old method : 0.12920665740966797 time for calcul the mask position with numpy : 0.00858616828918457 nb_pixel_total : 15764 time to create 1 rle with old method : 0.01755976676940918 time for calcul the mask position with numpy : 0.008355379104614258 nb_pixel_total : 3218 time to create 1 rle with old method : 0.003644704818725586 create new chi : 0.6977908611297607 time to delete rle : 0.0010156631469726562 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 2614 TO DO : save crop sub photo not yet done ! save time : 0.18656277656555176 No data in photo_id : 1374643417 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.07170510292053223 time for calcul the mask position with numpy : 0.10464358329772949 nb_pixel_total : 1957537 time to create 1 rle with new method : 0.14311432838439941 time for calcul the mask position with numpy : 0.011745214462280273 nb_pixel_total : 111633 time to create 1 rle with old method : 0.12783288955688477 time for calcul the mask position with numpy : 0.0065593719482421875 nb_pixel_total : 2140 time to create 1 rle with old method : 0.002537250518798828 time for calcul the mask position with numpy : 0.006818056106567383 nb_pixel_total : 2290 time to create 1 rle with old method : 0.0028028488159179688 create new chi : 0.4183845520019531 time to delete rle : 0.0004553794860839844 batch 1 Loaded 7 chid ids of type : 3594 ++++Number RLEs to save : 2382 TO DO : save crop sub photo not yet done ! save time : 0.16826915740966797 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04932999610900879 time for calcul the mask position with numpy : 0.02059030532836914 nb_pixel_total : 1977716 time to create 1 rle with new method : 0.11244368553161621 time for calcul the mask position with numpy : 0.0068476200103759766 nb_pixel_total : 7938 time to create 1 rle with old method : 0.009088993072509766 time for calcul the mask position with numpy : 0.00733637809753418 nb_pixel_total : 87946 time to create 1 rle with old method : 0.09909510612487793 create new chi : 0.2629861831665039 time to delete rle : 0.0004162788391113281 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 2298 TO DO : save crop sub photo not yet done ! save time : 0.1654958724975586 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.05190157890319824 time for calcul the mask position with numpy : 0.01832747459411621 nb_pixel_total : 1390700 time to create 1 rle with new method : 0.17294692993164062 time for calcul the mask position with numpy : 0.012670040130615234 nb_pixel_total : 674776 time to create 1 rle with new method : 0.10410213470458984 time for calcul the mask position with numpy : 0.006674051284790039 nb_pixel_total : 8124 time to create 1 rle with old method : 0.009157180786132812 create new chi : 0.34288859367370605 time to delete rle : 0.000576019287109375 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 3244 TO DO : save crop sub photo not yet done ! save time : 0.2160637378692627 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.15811395645141602 time for calcul the mask position with numpy : 0.08704686164855957 nb_pixel_total : 1917374 time to create 1 rle with new method : 0.8922626972198486 time for calcul the mask position with numpy : 0.008582353591918945 nb_pixel_total : 113790 time to create 1 rle with old method : 0.13179588317871094 time for calcul the mask position with numpy : 0.007473945617675781 nb_pixel_total : 1713 time to create 1 rle with old method : 0.002035379409790039 time for calcul the mask position with numpy : 0.00766444206237793 nb_pixel_total : 40723 time to create 1 rle with old method : 0.04838299751281738 create new chi : 1.2003834247589111 time to delete rle : 0.0007522106170654297 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 2668 TO DO : save crop sub photo not yet done ! save time : 0.18965482711791992 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.15806293487548828 time for calcul the mask position with numpy : 0.28632545471191406 nb_pixel_total : 1975383 time to create 1 rle with new method : 0.12210917472839355 time for calcul the mask position with numpy : 0.01216745376586914 nb_pixel_total : 8451 time to create 1 rle with old method : 0.014023780822753906 time for calcul the mask position with numpy : 0.012610435485839844 nb_pixel_total : 63546 time to create 1 rle with old method : 0.07479596138000488 time for calcul the mask position with numpy : 0.006499767303466797 nb_pixel_total : 12438 time to create 1 rle with old method : 0.014217138290405273 time for calcul the mask position with numpy : 0.007003307342529297 nb_pixel_total : 13782 time to create 1 rle with old method : 0.01570916175842285 create new chi : 0.5799612998962402 time to delete rle : 0.0004963874816894531 batch 1 Loaded 9 chid ids of type : 3594 ++++Number RLEs to save : 2468 TO DO : save crop sub photo not yet done ! save time : 0.17181801795959473 nb_obj : 7 nb_hashtags : 3 time to prepare the origin masks : 0.3746960163116455 time for calcul the mask position with numpy : 0.0960700511932373 nb_pixel_total : 1865373 time to create 1 rle with new method : 0.12388825416564941 time for calcul the mask position with numpy : 0.006556510925292969 nb_pixel_total : 3588 time to create 1 rle with old method : 0.0045015811920166016 time for calcul the mask position with numpy : 0.006680488586425781 nb_pixel_total : 25083 time to create 1 rle with old method : 0.02999281883239746 time for calcul the mask position with numpy : 0.008153200149536133 nb_pixel_total : 114052 time to create 1 rle with old method : 0.13338375091552734 time for calcul the mask position with numpy : 0.0070345401763916016 nb_pixel_total : 22559 time to create 1 rle with old method : 0.026102542877197266 time for calcul the mask position with numpy : 0.006573915481567383 nb_pixel_total : 5900 time to create 1 rle with old method : 0.00689244270324707 time for calcul the mask position with numpy : 0.007561683654785156 nb_pixel_total : 14625 time to create 1 rle with old method : 0.017063140869140625 time for calcul the mask position with numpy : 0.007271766662597656 nb_pixel_total : 22420 time to create 1 rle with old method : 0.029839754104614258 create new chi : 0.529249906539917 time to delete rle : 0.0007648468017578125 batch 1 Loaded 15 chid ids of type : 3594 +++++++++++Number RLEs to save : 3714 TO DO : save crop sub photo not yet done ! save time : 0.23977112770080566 map_output_result : {1374643450: (0.0, 'Should be the crop_list due to order', 0), 1374643448: (0.0, 'Should be the crop_list due to order', 0), 1374643442: (0.0, 'Should be the crop_list due to order', 0), 1374643437: (0.0, 'Should be the crop_list due to order', 0), 1374643433: (0.0, 'Should be the crop_list due to order', 0), 1374643419: (0.0, 'Should be the crop_list due to order', 0), 1374643417: (0.0, 'Should be the crop_list due to order', 0.0), 1374643415: (0.0, 'Should be the crop_list due to order', 0), 1374643412: (0.0, 'Should be the crop_list due to order', 0), 1374643409: (0.0, 'Should be the crop_list due to order', 0), 1374643405: (0.0, 'Should be the crop_list due to order', 0), 1374643379: (0.0, 'Should be the crop_list due to order', 0), 1374643374: (0.0, 'Should be the crop_list due to order', 0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1374643450, 1374643448, 1374643442, 1374643437, 1374643433, 1374643419, 1374643417, 1374643415, 1374643412, 1374643409, 1374643405, 1374643379, 1374643374] Looping around the photos to save general results len do output : 13 /1374643450.Didn't retrieve data . /1374643448.Didn't retrieve data . /1374643442.Didn't retrieve data . /1374643437.Didn't retrieve data . /1374643433.Didn't retrieve data . /1374643419.Didn't retrieve data . /1374643417.Didn't retrieve data . /1374643415.Didn't retrieve data . /1374643412.Didn't retrieve data . /1374643409.Didn't retrieve data . /1374643405.Didn't retrieve data . /1374643379.Didn't retrieve data . /1374643374.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, '3416127') ('3318', '25559193', '1374643450', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643448', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643442', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643437', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643433', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643419', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643417', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643415', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643412', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643409', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643405', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643379', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643374', None, None, None, None, None, '3416127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 39 time used for this insertion : 0.013189554214477539 save_final save missing photos in datou_result : time spend for datou_step_exec : 11.008530139923096 time spend to save output : 0.013762235641479492 total time spend for step 3 : 11.022292375564575 step4:ventilate_hashtags_in_portfolio Thu Jul 31 20:41:39 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 : 25559193 get user id for portfolio 25559193 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`=25559193 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','pehd','metal','environnement','flou','background','papier','carton','pet_fonce','autre','mal_croppe')) 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`=25559193 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','pehd','metal','environnement','flou','background','papier','carton','pet_fonce','autre','mal_croppe')) 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`=25559193 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','pehd','metal','environnement','flou','background','papier','carton','pet_fonce','autre','mal_croppe')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/25559263,25559264,25559265,25559266,25559268,25559269,25559270,25559271,25559273,25559274,25559275?tags=pet_clair,pehd,metal,environnement,flou,background,papier,carton,pet_fonce,autre,mal_croppe Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1374643450, 1374643448, 1374643442, 1374643437, 1374643433, 1374643419, 1374643417, 1374643415, 1374643412, 1374643409, 1374643405, 1374643379, 1374643374] Looping around the photos to save general results len do output : 1 /25559193. 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, '3416127') ('3318', '25559193', '1374643450', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643448', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643442', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643437', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643433', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643419', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643417', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643415', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643412', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643409', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643405', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643379', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643374', None, None, None, None, None, '3416127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 14 time used for this insertion : 0.017160415649414062 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6263353824615479 time spend to save output : 0.01763629913330078 total time spend for step 4 : 1.6439716815948486 step5:final Thu Jul 31 20:41:40 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 : {1374643450: ('0.14059777124881292',), 1374643448: ('0.14059777124881292',), 1374643442: ('0.14059777124881292',), 1374643437: ('0.14059777124881292',), 1374643433: ('0.14059777124881292',), 1374643419: ('0.14059777124881292',), 1374643417: ('0.14059777124881292',), 1374643415: ('0.14059777124881292',), 1374643412: ('0.14059777124881292',), 1374643409: ('0.14059777124881292',), 1374643405: ('0.14059777124881292',), 1374643379: ('0.14059777124881292',), 1374643374: ('0.14059777124881292',)} new output for save of step final : {1374643450: ('0.14059777124881292',), 1374643448: ('0.14059777124881292',), 1374643442: ('0.14059777124881292',), 1374643437: ('0.14059777124881292',), 1374643433: ('0.14059777124881292',), 1374643419: ('0.14059777124881292',), 1374643417: ('0.14059777124881292',), 1374643415: ('0.14059777124881292',), 1374643412: ('0.14059777124881292',), 1374643409: ('0.14059777124881292',), 1374643405: ('0.14059777124881292',), 1374643379: ('0.14059777124881292',), 1374643374: ('0.14059777124881292',)} [1374643450, 1374643448, 1374643442, 1374643437, 1374643433, 1374643419, 1374643417, 1374643415, 1374643412, 1374643409, 1374643405, 1374643379, 1374643374] Looping around the photos to save general results len do output : 13 /1374643450.Didn't retrieve data . /1374643448.Didn't retrieve data . /1374643442.Didn't retrieve data . /1374643437.Didn't retrieve data . /1374643433.Didn't retrieve data . /1374643419.Didn't retrieve data . /1374643417.Didn't retrieve data . /1374643415.Didn't retrieve data . /1374643412.Didn't retrieve data . /1374643409.Didn't retrieve data . /1374643405.Didn't retrieve data . /1374643379.Didn't retrieve data . /1374643374.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, '3416127') ('3318', '25559193', '1374643450', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643448', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643442', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643437', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643433', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643419', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643417', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643415', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643412', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643409', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643405', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643379', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643374', None, None, None, None, None, '3416127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 39 time used for this insertion : 0.013179779052734375 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.11900186538696289 time spend to save output : 0.014178276062011719 total time spend for step 5 : 0.1331801414489746 step6:blur_detection Thu Jul 31 20:41:41 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step blur_detection methode: ratio et variance treat image : temp/1753987229_3491317_1374643450_fddf373e83e67f0a4137cd27c96abcbd.jpg resize: (1080, 1920) 1374643450 -2.9299267054521834 treat image : temp/1753987229_3491317_1374643448_1da1b0749a912687095d2e73b6ccb70f.jpg resize: (1080, 1920) 1374643448 -4.435013196484463 treat image : temp/1753987229_3491317_1374643442_186e97363aa73af11da165243ea493db.jpg resize: (1080, 1920) 1374643442 0.4442009731836256 treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295.jpg resize: (1080, 1920) 1374643437 -1.3216562333692508 treat image : temp/1753987229_3491317_1374643433_0e29e4e1ccf699817c2df78de5df4fb9.jpg resize: (1080, 1920) 1374643433 0.6336667307686028 treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c.jpg resize: (1080, 1920) 1374643419 -1.8258719355943345 treat image : temp/1753987229_3491317_1374643417_747725d9b93adbfbcb2c8c11ed05ec64.jpg resize: (1080, 1920) 1374643417 -1.9922507357262287 treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423.jpg resize: (1080, 1920) 1374643415 -4.126596865907225 treat image : temp/1753987229_3491317_1374643412_e147779237f362471a58ec35701d029f.jpg resize: (1080, 1920) 1374643412 -1.7603865372827117 treat image : temp/1753987229_3491317_1374643409_c3a5289c2ca6df3c09768a89a26a9f3e.jpg resize: (1080, 1920) 1374643409 -0.6188120501055495 treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492.jpg resize: (1080, 1920) 1374643405 -4.862418107327323 treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d.jpg resize: (1080, 1920) 1374643379 -0.2062584802303078 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb.jpg resize: (1080, 1920) 1374643374 -4.707175112252301 treat image : temp/1753987229_3491317_1374643450_fddf373e83e67f0a4137cd27c96abcbd_rle_crop_3899563914_0.png resize: (100, 105) 1374644556 -1.4914338261335267 treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423_rle_crop_3899563925_0.png resize: (45, 87) 1374644557 -1.9530145812372914 treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423_rle_crop_3899563926_0.png resize: (50, 57) 1374644558 -1.546577504953789 treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492_rle_crop_3899563933_0.png resize: (57, 39) 1374644560 0.4271943476016961 treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563937_0.png resize: (249, 362) 1374644561 -1.425786222404913 treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563935_0.png resize: (152, 137) 1374644562 -2.0367442362315518 treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563936_0.png resize: (140, 166) 1374644563 -1.5069736283227737 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563945_0.png resize: (108, 392) 1374644564 -3.3260283873361995 treat image : temp/1753987229_3491317_1374643448_1da1b0749a912687095d2e73b6ccb70f_rle_crop_3899563915_0.png resize: (948, 956) 1374644567 -0.4255889144714398 treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c_rle_crop_3899563922_0.png resize: (72, 77) 1374644568 -2.0695669137641235 treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563938_0.png resize: (142, 78) 1374644569 -1.1281499810379108 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563944_0.png resize: (164, 216) 1374644570 -3.2174958371370974 treat image : temp/1753987229_3491317_1374643442_186e97363aa73af11da165243ea493db_rle_crop_3899563916_0.png resize: (948, 1061) 1374644613 0.34978202698014227 treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295_rle_crop_3899563917_0.png resize: (942, 1034) 1374644614 -0.26418794069598767 treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295_rle_crop_3899563919_0.png resize: (344, 485) 1374644616 -0.3276991935644384 treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295_rle_crop_3899563918_0.png resize: (180, 184) 1374644617 -1.4832755179017076 treat image : temp/1753987229_3491317_1374643433_0e29e4e1ccf699817c2df78de5df4fb9_rle_crop_3899563921_0.png resize: (98, 94) 1374644618 -2.9059666873808454 treat image : temp/1753987229_3491317_1374643433_0e29e4e1ccf699817c2df78de5df4fb9_rle_crop_3899563920_0.png resize: (529, 327) 1374644619 0.08994263247781466 treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c_rle_crop_3899563923_0.png resize: (155, 132) 1374644621 -3.099836140681027 treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c_rle_crop_3899563924_0.png resize: (530, 378) 1374644622 -0.12084403984183152 treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423_rle_crop_3899563927_0.png resize: (517, 348) 1374644623 -0.1812822939105896 treat image : temp/1753987229_3491317_1374643412_e147779237f362471a58ec35701d029f_rle_crop_3899563929_0.png resize: (86, 114) 1374644625 1.0623935712036345 treat image : temp/1753987229_3491317_1374643412_e147779237f362471a58ec35701d029f_rle_crop_3899563928_0.png resize: (506, 322) 1374644626 0.4203842549652753 treat image : temp/1753987229_3491317_1374643409_c3a5289c2ca6df3c09768a89a26a9f3e_rle_crop_3899563931_0.png resize: (919, 941) 1374644627 0.39854321703030726 treat image : temp/1753987229_3491317_1374643409_c3a5289c2ca6df3c09768a89a26a9f3e_rle_crop_3899563930_0.png resize: (150, 80) 1374644629 -3.62898439866804 treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492_rle_crop_3899563932_0.png resize: (218, 252) 1374644631 -3.700168019049793 treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492_rle_crop_3899563934_0.png resize: (512, 366) 1374644633 -0.0925792141351013 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563942_0.png resize: (100, 315) 1374644634 -3.4775730760080394 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563939_0.png resize: (142, 212) 1374644636 -3.5577950360195447 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563941_0.png resize: (96, 90) 1374644637 -4.83189949264737 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563940_0.png resize: (156, 125) 1374644638 -3.6063003507697475 treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563943_0.png resize: (533, 360) 1374644640 0.054604056675572776 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 : 45 time used for this insertion : 0.013787031173706055 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 45 time used for this insertion : 0.014835119247436523 save missing photos in datou_result : time spend for datou_step_exec : 12.706323862075806 time spend to save output : 0.03359198570251465 total time spend for step 6 : 12.73991584777832 step7:brightness Thu Jul 31 20:41:53 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/1753987229_3491317_1374643450_fddf373e83e67f0a4137cd27c96abcbd.jpg treat image : temp/1753987229_3491317_1374643448_1da1b0749a912687095d2e73b6ccb70f.jpg treat image : temp/1753987229_3491317_1374643442_186e97363aa73af11da165243ea493db.jpg treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295.jpg treat image : temp/1753987229_3491317_1374643433_0e29e4e1ccf699817c2df78de5df4fb9.jpg treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c.jpg treat image : temp/1753987229_3491317_1374643417_747725d9b93adbfbcb2c8c11ed05ec64.jpg treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423.jpg treat image : temp/1753987229_3491317_1374643412_e147779237f362471a58ec35701d029f.jpg treat image : temp/1753987229_3491317_1374643409_c3a5289c2ca6df3c09768a89a26a9f3e.jpg treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492.jpg treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d.jpg treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb.jpg treat image : temp/1753987229_3491317_1374643450_fddf373e83e67f0a4137cd27c96abcbd_rle_crop_3899563914_0.png treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423_rle_crop_3899563925_0.png treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423_rle_crop_3899563926_0.png treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492_rle_crop_3899563933_0.png treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563937_0.png treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563935_0.png treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563936_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563945_0.png treat image : temp/1753987229_3491317_1374643448_1da1b0749a912687095d2e73b6ccb70f_rle_crop_3899563915_0.png treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c_rle_crop_3899563922_0.png treat image : temp/1753987229_3491317_1374643379_5ff348908ec380e66b8500c4d2ba4b6d_rle_crop_3899563938_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563944_0.png treat image : temp/1753987229_3491317_1374643442_186e97363aa73af11da165243ea493db_rle_crop_3899563916_0.png treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295_rle_crop_3899563917_0.png treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295_rle_crop_3899563919_0.png treat image : temp/1753987229_3491317_1374643437_777375a7635b75d82db0664a68a2c295_rle_crop_3899563918_0.png treat image : temp/1753987229_3491317_1374643433_0e29e4e1ccf699817c2df78de5df4fb9_rle_crop_3899563921_0.png treat image : temp/1753987229_3491317_1374643433_0e29e4e1ccf699817c2df78de5df4fb9_rle_crop_3899563920_0.png treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c_rle_crop_3899563923_0.png treat image : temp/1753987229_3491317_1374643419_fe04424e4b7dd3f3994d9acec8cc668c_rle_crop_3899563924_0.png treat image : temp/1753987229_3491317_1374643415_205ee0d2e7f7c8a5e4aa5551da739423_rle_crop_3899563927_0.png treat image : temp/1753987229_3491317_1374643412_e147779237f362471a58ec35701d029f_rle_crop_3899563929_0.png treat image : temp/1753987229_3491317_1374643412_e147779237f362471a58ec35701d029f_rle_crop_3899563928_0.png treat image : temp/1753987229_3491317_1374643409_c3a5289c2ca6df3c09768a89a26a9f3e_rle_crop_3899563931_0.png treat image : temp/1753987229_3491317_1374643409_c3a5289c2ca6df3c09768a89a26a9f3e_rle_crop_3899563930_0.png treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492_rle_crop_3899563932_0.png treat image : temp/1753987229_3491317_1374643405_89cf6376257cfd77e07f85e45440c492_rle_crop_3899563934_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563942_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563939_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563941_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563940_0.png treat image : temp/1753987229_3491317_1374643374_d0d4d9963030599ab8e093ef791648bb_rle_crop_3899563943_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 : 45 time used for this insertion : 0.013742446899414062 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 45 time used for this insertion : 0.012781620025634766 save missing photos in datou_result : time spend for datou_step_exec : 3.498560905456543 time spend to save output : 0.03116440773010254 total time spend for step 7 : 3.5297253131866455 step8:velours_tree Thu Jul 31 20:41:57 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure 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.08964896202087402 time spend to save output : 7.390975952148438e-05 total time spend for step 8 : 0.08972287178039551 step9:send_mail_cod Thu Jul 31 20:41:57 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 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_P25559193_31-07-2025_20_41_57.pdf 25559263 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 .imagette255592631753987317 25559264 imagette255592641753987318 25559265 imagette255592651753987318 25559268 imagette255592681753987318 25559269 imagette255592691753987318 25559270 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 .imagette255592701753987319 25559271 change filename to text .change filename to text .change filename to text .change filename to text .imagette255592711753987319 25559273 imagette255592731753987319 25559274 imagette255592741753987319 25559275 imagette255592751753987319 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=25559193 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/25559263,25559264,25559265,25559266,25559268,25559269,25559270,25559271,25559273,25559274,25559275?tags=pet_clair,pehd,metal,environnement,flou,background,papier,carton,pet_fonce,autre,mal_croppe args[1374643450] : ((1374643450, -2.9299267054521834, 492609224), (1374643450, 0.2932970880211961, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643448] : ((1374643448, -4.435013196484463, 492609224), (1374643448, 0.30931633316189266, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643442] : ((1374643442, 0.4442009731836256, 492688767), (1374643442, 0.5922380546973176, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643437] : ((1374643437, -1.3216562333692508, 492688767), (1374643437, 0.3767030330572599, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643433] : ((1374643433, 0.6336667307686028, 492688767), (1374643433, 0.6915130611394648, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643419] : ((1374643419, -1.8258719355943345, 492688767), (1374643419, 0.13417821290084173, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643417] : ((1374643417, -1.9922507357262287, 492688767), (1374643417, 0.8323745267337292, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643415] : ((1374643415, -4.126596865907225, 492609224), (1374643415, 0.6715564556223018, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643412] : ((1374643412, -1.7603865372827117, 492688767), (1374643412, 0.9689756449442487, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643409] : ((1374643409, -0.6188120501055495, 492688767), (1374643409, 0.5253365480635256, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643405] : ((1374643405, -4.862418107327323, 492609224), (1374643405, 0.34129244404678044, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643379] : ((1374643379, -0.2062584802303078, 492688767), (1374643379, 0.18683226410924345, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com args[1374643374] : ((1374643374, -4.707175112252301, 492609224), (1374643374, 0.3289998425768804, 2107752395), '0.14059777124881292') We are sending mail with results at report@fotonower.com refus_total : 0.14059777124881292 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=25559193 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_P25559193_31-07-2025_20_41_57.pdf results_Auto_P25559193_31-07-2025_20_41_57.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25559193_31-07-2025_20_41_57.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','25559193','results_Auto_P25559193_31-07-2025_20_41_57.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25559193_31-07-2025_20_41_57.pdf','pdf','','0.47','0.14059777124881292') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/25559193

https://www.fotonower.com/image?json=false&list_photos_id=1374643450
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643448
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643442
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643437
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643433
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643419
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643417
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643415
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643412
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643409
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643405
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643379
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1374643374
Bravo, la photo est bien prise.

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

exemples de contaminants: pet_clair: https://www.fotonower.com/view/25559263?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/25559270?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/25559271?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25559193_31-07-2025_20_41_57.pdf.

Lien vers velours :https://www.fotonower.com/velours/25559263,25559264,25559265,25559266,25559268,25559269,25559270,25559271,25559273,25559274,25559275?tags=pet_clair,pehd,metal,environnement,flou,background,papier,carton,pet_fonce,autre,mal_croppe.


L'équipe Fotonower 202 b'' Server: nginx Date: Thu, 31 Jul 2025 18:42:01 GMT Content-Length: 0 Connection: close X-Message-Id: Ea9u1ksKRPSTiVpY4xQMBQ 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 [1374643450, 1374643448, 1374643442, 1374643437, 1374643433, 1374643419, 1374643417, 1374643415, 1374643412, 1374643409, 1374643405, 1374643379, 1374643374] 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, '3416127') ('3318', '25559193', '1374643450', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643448', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643442', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643437', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643433', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643419', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643417', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643415', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643412', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643409', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643405', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643379', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643374', None, None, None, None, None, '3416127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 13 time used for this insertion : 0.013689517974853516 save_final save missing photos in datou_result : time spend for datou_step_exec : 4.374171733856201 time spend to save output : 0.014014959335327148 total time spend for step 9 : 4.388186693191528 step10:split_time_score Thu Jul 31 20:42:01 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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'}] (('20', 13),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 31072025 25559193 Nombre de photos uploadées : 13 / 23040 (0%) 31072025 25559193 Nombre de photos taguées (types de déchets): 0 / 13 (0%) 31072025 25559193 Nombre de photos taguées (volume) : 0 / 13 (0%) elapsed_time : load_data_split_time_score 3.5762786865234375e-06 elapsed_time : order_list_meta_photo_and_scores 1.3113021850585938e-05 ????????????? elapsed_time : fill_and_build_computed_from_old_data 0.000762939453125 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.2092137336730957 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.1288892103909465 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25530216_31-07-2025_08_21_35.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25530216 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`=25530216 AND mptpi.`type`=3594 To do Qualite : 0.0400941679526749 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25532093_31-07-2025_09_51_52.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25532093 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`=25532093 AND mptpi.`type`=3594 To do Qualite : 0.017316454475308645 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25532109_31-07-2025_09_41_23.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25532109 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`=25532109 AND mptpi.`type`=3594 To do Qualite : 0.045261622299382735 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25532112_31-07-2025_09_31_06.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25532112 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`=25532112 AND mptpi.`type`=3594 To do Qualite : 0.10603395061728398 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25537191_31-07-2025_11_41_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25537191 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`=25537191 AND mptpi.`type`=3594 To do Qualite : 0.1775103777154558 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25543232_31-07-2025_14_51_52.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25543232 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`=25543232 AND mptpi.`type`=3594 To do Qualite : 0.2067458164544753 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25543235_31-07-2025_14_31_40.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25543235 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`=25543235 AND mptpi.`type`=3594 To do Qualite : 0.15670513974622782 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25543266_31-07-2025_14_21_39.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25543266 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`=25543266 AND mptpi.`type`=3594 To do Qualite : 0.11439766589506177 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25543287_31-07-2025_14_12_54.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25543287 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`=25543287 AND mptpi.`type`=3594 To do Qualite : 0.1538847155448718 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25550837_31-07-2025_17_33_10.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25550837 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`=25550837 AND mptpi.`type`=3594 To do Qualite : 0.19044441040305016 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25550842_31-07-2025_17_22_28.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25550842 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`=25550842 AND mptpi.`type`=3594 To do Qualite : 0.11378101258309595 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25550846_31-07-2025_17_11_50.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25550846 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`=25550846 AND mptpi.`type`=3594 To do Qualite : 0.15474861461840628 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25552249_31-07-2025_17_51_47.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25552249 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`=25552249 AND mptpi.`type`=3594 To do Qualite : 0.09546847080084471 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25552251_31-07-2025_18_02_31.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25552251 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`=25552251 AND mptpi.`type`=3594 To do Qualite : 0.12310812114197532 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25552256_31-07-2025_17_41_51.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25552256 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`=25552256 AND mptpi.`type`=3594 To do Qualite : 0.018800747863247858 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25555609_31-07-2025_19_11_35.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25555609 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`=25555609 AND mptpi.`type`=3594 To do Qualite : 0.14059777124881292 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25559193_31-07-2025_20_41_57.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25559193 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`=25559193 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'31072025': {'nb_upload': 13, '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 [1374643450, 1374643448, 1374643442, 1374643437, 1374643433, 1374643419, 1374643417, 1374643415, 1374643412, 1374643409, 1374643405, 1374643379, 1374643374] Looping around the photos to save general results len do output : 1 /25559193Didn'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, '3416127') ('3318', '25559193', '1374643450', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643448', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643442', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643437', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643433', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643419', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643417', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643415', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643412', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643409', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643405', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643379', None, None, None, None, None, '3416127') ('3318', None, None, None, None, None, None, None, '3416127') ('3318', '25559193', '1374643374', None, None, None, None, None, '3416127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 14 time used for this insertion : 0.014892578125 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.3621370792388916 time spend to save output : 0.01520085334777832 total time spend for step 10 : 1.37733793258667 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 13 set_done_treatment 54.15user 26.84system 1:38.76elapsed 82%CPU (0avgtext+0avgdata 2835300maxresident)k 504176inputs+32968outputs (50major+1784813minor)pagefaults 0swaps