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 : 465315 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 : ['3924282'] with mtr_portfolio_ids : ['27699099'] and first list_photo_ids : [] new path : /proc/465315/ 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 , BFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 5 ; length of list_pids : 5 ; length of list_args : 5 time to download the photos : 1.0275678634643555 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 Fri Oct 10 14:20:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 10998 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-10-10 14:20:32.468400: 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-10-10 14:20:32.494517: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493010000 Hz 2025-10-10 14:20:32.496800: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fa918000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-10-10 14:20:32.496859: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-10-10 14:20:32.500736: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-10-10 14:20:32.801426: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x388c8000 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-10-10 14:20:32.801482: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-10-10 14:20:32.802994: 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-10-10 14:20:32.803410: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 14:20:32.806706: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 14:20:32.809809: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 14:20:32.810358: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 14:20:32.813075: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 14:20:32.814081: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 14:20:32.818553: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 14:20:32.820075: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 14:20:32.820145: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 14:20:32.821040: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-10 14:20:32.821058: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-10 14:20:32.821068: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-10 14:20:32.822462: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 10193 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-10-10 14:20:33.215483: 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-10-10 14:20:33.215617: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 14:20:33.215637: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 14:20:33.215653: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 14:20:33.215668: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 14:20:33.215683: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 14:20:33.215698: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 14:20:33.215714: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 14:20:33.216879: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 14:20:33.217988: 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-10-10 14:20:33.218016: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 14:20:33.218030: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 14:20:33.218042: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 14:20:33.218054: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 14:20:33.218067: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 14:20:33.218079: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 14:20:33.218091: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 14:20:33.219277: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 14:20:33.219312: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-10 14:20:33.219320: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-10 14:20:33.219328: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-10 14:20:33.220535: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 10193 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-10-10 14:20:40.625248: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 14:20:40.779453: 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 : 5 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 11 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 16 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 17 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 16 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 12 Detection mask done ! Trying to reset tf kernel 465845 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 1524 tf kernel not reseted sub process len(results) : 5 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 5 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 : 6419 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.0011854171752929688 nb_pixel_total : 54937 time to create 1 rle with old method : 0.06584000587463379 length of segment : 214 time for calcul the mask position with numpy : 0.0004374980926513672 nb_pixel_total : 23023 time to create 1 rle with old method : 0.024555444717407227 length of segment : 206 time for calcul the mask position with numpy : 0.0013604164123535156 nb_pixel_total : 69425 time to create 1 rle with old method : 0.07423162460327148 length of segment : 287 time for calcul the mask position with numpy : 0.003049612045288086 nb_pixel_total : 140165 time to create 1 rle with old method : 0.14649724960327148 length of segment : 392 time for calcul the mask position with numpy : 0.00024080276489257812 nb_pixel_total : 11765 time to create 1 rle with old method : 0.012517929077148438 length of segment : 145 time for calcul the mask position with numpy : 0.0005364418029785156 nb_pixel_total : 30279 time to create 1 rle with old method : 0.03526043891906738 length of segment : 260 time for calcul the mask position with numpy : 0.00025391578674316406 nb_pixel_total : 15539 time to create 1 rle with old method : 0.018355131149291992 length of segment : 125 time for calcul the mask position with numpy : 0.00048804283142089844 nb_pixel_total : 27191 time to create 1 rle with old method : 0.030980825424194336 length of segment : 125 time for calcul the mask position with numpy : 0.0053980350494384766 nb_pixel_total : 219946 time to create 1 rle with new method : 0.015625953674316406 length of segment : 537 time for calcul the mask position with numpy : 0.0009708404541015625 nb_pixel_total : 49006 time to create 1 rle with old method : 0.05548357963562012 length of segment : 257 time for calcul the mask position with numpy : 0.0006511211395263672 nb_pixel_total : 13089 time to create 1 rle with old method : 0.01570272445678711 length of segment : 266 time for calcul the mask position with numpy : 0.0014262199401855469 nb_pixel_total : 69774 time to create 1 rle with old method : 0.0795595645904541 length of segment : 405 time for calcul the mask position with numpy : 0.00286102294921875 nb_pixel_total : 164866 time to create 1 rle with new method : 0.010958671569824219 length of segment : 446 time for calcul the mask position with numpy : 0.0010485649108886719 nb_pixel_total : 61925 time to create 1 rle with old method : 0.06826996803283691 length of segment : 439 time for calcul the mask position with numpy : 0.0004305839538574219 nb_pixel_total : 24547 time to create 1 rle with old method : 0.02755570411682129 length of segment : 287 time for calcul the mask position with numpy : 0.0004773139953613281 nb_pixel_total : 22653 time to create 1 rle with old method : 0.024944305419921875 length of segment : 247 time for calcul the mask position with numpy : 0.00032591819763183594 nb_pixel_total : 17309 time to create 1 rle with old method : 0.019446611404418945 length of segment : 109 time for calcul the mask position with numpy : 0.0017952919006347656 nb_pixel_total : 97282 time to create 1 rle with old method : 0.1095421314239502 length of segment : 441 time for calcul the mask position with numpy : 0.0004363059997558594 nb_pixel_total : 21683 time to create 1 rle with old method : 0.024502992630004883 length of segment : 141 time for calcul the mask position with numpy : 0.0019752979278564453 nb_pixel_total : 63674 time to create 1 rle with old method : 0.06872034072875977 length of segment : 348 time for calcul the mask position with numpy : 0.0005803108215332031 nb_pixel_total : 17020 time to create 1 rle with old method : 0.01877140998840332 length of segment : 106 time for calcul the mask position with numpy : 0.0004947185516357422 nb_pixel_total : 22607 time to create 1 rle with old method : 0.024344444274902344 length of segment : 233 time for calcul the mask position with numpy : 0.0037238597869873047 nb_pixel_total : 141788 time to create 1 rle with old method : 0.14949822425842285 length of segment : 626 time for calcul the mask position with numpy : 0.001260519027709961 nb_pixel_total : 24721 time to create 1 rle with old method : 0.026152849197387695 length of segment : 269 time for calcul the mask position with numpy : 0.0029401779174804688 nb_pixel_total : 93040 time to create 1 rle with old method : 0.09993791580200195 length of segment : 371 time for calcul the mask position with numpy : 0.0006773471832275391 nb_pixel_total : 20664 time to create 1 rle with old method : 0.022281885147094727 length of segment : 197 time for calcul the mask position with numpy : 0.0023682117462158203 nb_pixel_total : 67248 time to create 1 rle with old method : 0.07349634170532227 length of segment : 363 time for calcul the mask position with numpy : 0.0013358592987060547 nb_pixel_total : 39023 time to create 1 rle with old method : 0.04115748405456543 length of segment : 333 time for calcul the mask position with numpy : 0.0010945796966552734 nb_pixel_total : 25784 time to create 1 rle with old method : 0.028033971786499023 length of segment : 276 time spent for convertir_results : 3.1749300956726074 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 29 chid ids of type : 3594 Number RLEs to save : 8451 save missing photos in datou_result : time spend for datou_step_exec : 24.56700372695923 time spend to save output : 1.0988101959228516 total time spend for step 1 : 25.66581392288208 step2:crop_condition Fri Oct 10 14:20:55 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : 5 ! batch 1 Loaded 29 chid ids of type : 3594 +++++++++++++++++++++++++++++++++ begin to crop the class : papier param for this class : {'min_score': 0.7} filtre for class : papier hashtag_id of this class : 492668766 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 21 About to insert : list_path_to_insert length 21 new photo from crops ! About to upload 21 photos upload in portfolio : 3736932 init cache_photo without model_param we have 21 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1760098862_465315 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788621_0.png', 0, 493, 392, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788618_0.png', 0, 336, 213, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788619_0.png', 0, 206, 206, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788620_0.png', 0, 363, 281, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788622_0.png', 0, 107, 143, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788626_0.png', 0, 693, 479, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788628_0.png', 0, 187, 202, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788625_0.png', 0, 326, 109, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788627_0.png', 0, 393, 257, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788631_0.png', 0, 198, 418, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788635_0.png', 0, 455, 326, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788630_0.png', 0, 626, 439, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788634_0.png', 0, 272, 93, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788636_0.png', 0, 287, 133, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788633_0.png', 0, 173, 243, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788629_0.png', 0, 386, 344, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788643_0.png', 0, 144, 197, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788642_0.png', 0, 358, 353, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788637_0.png', 0, 321, 347, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788645_0.png', 0, 173, 333, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098867), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788644_0.png', 0, 326, 358, 0, 1760098867,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 21 photos in the portfolio 3736932 time of upload the photos Elapsed time : 7.31615686416626 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 ! 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 : 6 About to insert : list_path_to_insert length 6 new photo from crops ! About to upload 6 photos upload in portfolio : 3736932 init cache_photo without model_param we have 6 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1760098871_465315 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098873), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788623_0.png', 0, 156, 257, 0, 1760098873,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098873), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788632_0.png', 0, 184, 196, 0, 1760098873,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098873), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788638_0.png', 0, 215, 104, 0, 1760098873,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098873), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788641_0.png', 0, 149, 269, 0, 1760098873,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098873), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788639_0.png', 0, 131, 232, 0, 1760098873,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098873), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788646_0.png', 0, 140, 276, 0, 1760098873,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 6 photos in the portfolio 3736932 time of upload the photos Elapsed time : 2.2551262378692627 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 ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 3736932 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1760098875_465315 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098875), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788640_0.png', 0, 305, 621, 0, 1760098875,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 1 photos in the portfolio 3736932 time of upload the photos Elapsed time : 0.7373745441436768 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 3736932 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1760098876_465315 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760098877), 0.0, 0.0, 14, '', 0, 0, '1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788624_0.png', 0, 148, 125, 0, 1760098877,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 1 photos in the portfolio 3736932 time of upload the photos Elapsed time : 0.707831621170044 we have finished the crop for the class : autre begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1388734802, 1388734799, 1388734797, 1388734792, 1388734781] Looping around the photos to save general results len do output : 29 /1388743766Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743767Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743768Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743769Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743770Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743771Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743772Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743773Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743774Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743776Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743777Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743778Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743779Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743780Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743781Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743782Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743783Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743784Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743785Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743786Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743787Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743789Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743790Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743791Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743792Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743793Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743795Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743797Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388743799Didn'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, '3924282') ('3318', '27699099', '1388734802', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734799', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734797', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734792', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734781', None, None, None, None, None, '3924282') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 92 time used for this insertion : 0.03749227523803711 save_final save missing photos in datou_result : time spend for datou_step_exec : 21.856163501739502 time spend to save output : 0.039084672927856445 total time spend for step 2 : 21.89524817466736 step3:rle_unique_nms_with_priority Fri Oct 10 14:21:17 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 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 29 chid ids of type : 3594 +++++++++++++++++++++++++++++++++nb_obj : 6 nb_hashtags : 2 time to prepare the origin masks : 1.9825830459594727 time for calcul the mask position with numpy : 0.5425598621368408 nb_pixel_total : 7964806 time to create 1 rle with new method : 0.5000245571136475 time for calcul the mask position with numpy : 0.024772167205810547 nb_pixel_total : 30279 time to create 1 rle with old method : 0.033968210220336914 time for calcul the mask position with numpy : 0.02497267723083496 nb_pixel_total : 11765 time to create 1 rle with old method : 0.01369786262512207 time for calcul the mask position with numpy : 0.0286102294921875 nb_pixel_total : 140165 time to create 1 rle with old method : 0.16728734970092773 time for calcul the mask position with numpy : 0.02777385711669922 nb_pixel_total : 69425 time to create 1 rle with old method : 0.08403992652893066 time for calcul the mask position with numpy : 0.03264617919921875 nb_pixel_total : 23023 time to create 1 rle with old method : 0.03327059745788574 time for calcul the mask position with numpy : 0.03024005889892578 nb_pixel_total : 54937 time to create 1 rle with old method : 0.06695055961608887 create new chi : 1.6509666442871094 time to delete rle : 0.10010027885437012 batch 1 Loaded 13 chid ids of type : 3594 ++++++Number RLEs to save : 5168 TO DO : save crop sub photo not yet done ! save time : 0.7373549938201904 nb_obj : 5 nb_hashtags : 2 time to prepare the origin masks : 1.667956829071045 time for calcul the mask position with numpy : 0.5724728107452393 nb_pixel_total : 7969629 time to create 1 rle with new method : 1.0883281230926514 time for calcul the mask position with numpy : 0.03512001037597656 nb_pixel_total : 13089 time to create 1 rle with old method : 0.015140533447265625 time for calcul the mask position with numpy : 0.034505367279052734 nb_pixel_total : 49006 time to create 1 rle with old method : 0.05866885185241699 time for calcul the mask position with numpy : 0.03807377815246582 nb_pixel_total : 219946 time to create 1 rle with new method : 0.7396535873413086 time for calcul the mask position with numpy : 0.03246021270751953 nb_pixel_total : 27191 time to create 1 rle with old method : 0.05193138122558594 time for calcul the mask position with numpy : 0.03534722328186035 nb_pixel_total : 15539 time to create 1 rle with old method : 0.01762557029724121 create new chi : 2.8230295181274414 time to delete rle : 0.0010082721710205078 batch 1 Loaded 11 chid ids of type : 3594 +++++++Number RLEs to save : 4780 TO DO : save crop sub photo not yet done ! save time : 0.64190673828125 nb_obj : 8 nb_hashtags : 2 time to prepare the origin masks : 3.6946475505828857 time for calcul the mask position with numpy : 0.49445509910583496 nb_pixel_total : 7814361 time to create 1 rle with new method : 1.1372034549713135 time for calcul the mask position with numpy : 0.034612417221069336 nb_pixel_total : 21683 time to create 1 rle with old method : 0.02702021598815918 time for calcul the mask position with numpy : 0.044284820556640625 nb_pixel_total : 97282 time to create 1 rle with old method : 0.10914850234985352 time for calcul the mask position with numpy : 0.041706085205078125 nb_pixel_total : 17309 time to create 1 rle with old method : 0.019495487213134766 time for calcul the mask position with numpy : 0.042258501052856445 nb_pixel_total : 22653 time to create 1 rle with old method : 0.026893138885498047 time for calcul the mask position with numpy : 0.04285860061645508 nb_pixel_total : 24547 time to create 1 rle with old method : 0.02856588363647461 time for calcul the mask position with numpy : 0.04211115837097168 nb_pixel_total : 61925 time to create 1 rle with old method : 0.06915855407714844 time for calcul the mask position with numpy : 0.041587114334106445 nb_pixel_total : 164866 time to create 1 rle with new method : 2.1164233684539795 time for calcul the mask position with numpy : 0.03034687042236328 nb_pixel_total : 69774 time to create 1 rle with old method : 0.08231735229492188 create new chi : 4.517685651779175 time to delete rle : 0.002082347869873047 batch 1 Loaded 17 chid ids of type : 3594 ++++++++++Number RLEs to save : 7190 TO DO : save crop sub photo not yet done ! save time : 0.8770649433135986 nb_obj : 7 nb_hashtags : 3 time to prepare the origin masks : 3.8991973400115967 time for calcul the mask position with numpy : 0.2635366916656494 nb_pixel_total : 7910886 time to create 1 rle with new method : 0.31891798973083496 time for calcul the mask position with numpy : 0.025905609130859375 nb_pixel_total : 20664 time to create 1 rle with old method : 0.02346944808959961 time for calcul the mask position with numpy : 0.026787519454956055 nb_pixel_total : 93040 time to create 1 rle with old method : 0.10418891906738281 time for calcul the mask position with numpy : 0.024069547653198242 nb_pixel_total : 24721 time to create 1 rle with old method : 0.027014970779418945 time for calcul the mask position with numpy : 0.02458643913269043 nb_pixel_total : 141788 time to create 1 rle with old method : 0.1562519073486328 time for calcul the mask position with numpy : 0.03816699981689453 nb_pixel_total : 22607 time to create 1 rle with old method : 0.024672508239746094 time for calcul the mask position with numpy : 0.0390927791595459 nb_pixel_total : 17020 time to create 1 rle with old method : 0.018503427505493164 time for calcul the mask position with numpy : 0.03806877136230469 nb_pixel_total : 63674 time to create 1 rle with old method : 0.06994795799255371 create new chi : 1.2640671730041504 time to delete rle : 0.0008068084716796875 batch 1 Loaded 15 chid ids of type : 3594 +++++++Number RLEs to save : 6460 TO DO : save crop sub photo not yet done ! save time : 0.824129581451416 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.209794282913208 time for calcul the mask position with numpy : 0.0893254280090332 nb_pixel_total : 8162345 time to create 1 rle with new method : 0.15088319778442383 time for calcul the mask position with numpy : 0.022809743881225586 nb_pixel_total : 25784 time to create 1 rle with old method : 0.02778768539428711 time for calcul the mask position with numpy : 0.022800207138061523 nb_pixel_total : 39023 time to create 1 rle with old method : 0.04178452491760254 time for calcul the mask position with numpy : 0.023168087005615234 nb_pixel_total : 67248 time to create 1 rle with old method : 0.07249283790588379 create new chi : 0.47228312492370605 time to delete rle : 0.0005044937133789062 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 4104 TO DO : save crop sub photo not yet done ! save time : 0.6366841793060303 map_output_result : {1388734802: (0.0, 'Should be the crop_list due to order', 0), 1388734799: (0.0, 'Should be the crop_list due to order', 0), 1388734797: (0.0, 'Should be the crop_list due to order', 0), 1388734792: (0.0, 'Should be the crop_list due to order', 0), 1388734781: (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 [1388734802, 1388734799, 1388734797, 1388734792, 1388734781] Looping around the photos to save general results len do output : 5 /1388734802.Didn't retrieve data . /1388734799.Didn't retrieve data . /1388734797.Didn't retrieve data . /1388734792.Didn't retrieve data . /1388734781.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, '3924282') ('3318', '27699099', '1388734802', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734799', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734797', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734792', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734781', None, None, None, None, None, '3924282') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.035935163497924805 save_final save missing photos in datou_result : time spend for datou_step_exec : 26.937336683273315 time spend to save output : 0.03626227378845215 total time spend for step 3 : 26.973598957061768 step4:ventilate_hashtags_in_portfolio Fri Oct 10 14:21:44 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 : 27699099 get user id for portfolio 27699099 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`=27699099 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','pehd','carton','metal','papier','environnement','background','autre','flou','pet_fonce','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`=27699099 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','pehd','carton','metal','papier','environnement','background','autre','flou','pet_fonce','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`=27699099 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','pehd','carton','metal','papier','environnement','background','autre','flou','pet_fonce','mal_croppe')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/27699998,27699999,27700000,27700001,27700002,27700003,27700004,27700005,27700006,27700007,27700008?tags=pet_clair,pehd,carton,metal,papier,environnement,background,autre,flou,pet_fonce,mal_croppe Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1388734802, 1388734799, 1388734797, 1388734792, 1388734781] Looping around the photos to save general results len do output : 1 /27699099. 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, '3924282') ('3318', '27699099', '1388734802', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734799', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734797', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734792', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734781', None, None, None, None, None, '3924282') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.03681540489196777 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.5346152782440186 time spend to save output : 0.03710365295410156 total time spend for step 4 : 5.57171893119812 step5:final Fri Oct 10 14:21:49 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : {1388734802: ('0.03978522858796297',), 1388734799: ('0.03978522858796297',), 1388734797: ('0.03978522858796297',), 1388734792: ('0.03978522858796297',), 1388734781: ('0.03978522858796297',)} new output for save of step final : {1388734802: ('0.03978522858796297',), 1388734799: ('0.03978522858796297',), 1388734797: ('0.03978522858796297',), 1388734792: ('0.03978522858796297',), 1388734781: ('0.03978522858796297',)} [1388734802, 1388734799, 1388734797, 1388734792, 1388734781] Looping around the photos to save general results len do output : 5 /1388734802.Didn't retrieve data . /1388734799.Didn't retrieve data . /1388734797.Didn't retrieve data . /1388734792.Didn't retrieve data . /1388734781.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, '3924282') ('3318', '27699099', '1388734802', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734799', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734797', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734792', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734781', None, None, None, None, None, '3924282') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.03667163848876953 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.3730776309967041 time spend to save output : 0.03698849678039551 total time spend for step 5 : 0.4100661277770996 step6:blur_detection Fri Oct 10 14:21:50 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f.jpg resize: (2160, 3840) 1388734802 -7.059428526230514 treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7.jpg resize: (2160, 3840) 1388734799 -7.0174068411956565 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65.jpg resize: (2160, 3840) 1388734797 -6.823341571119875 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a.jpg resize: (2160, 3840) 1388734792 -7.104350714680066 treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006.jpg resize: (2160, 3840) 1388734781 -7.080114886856625 treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788621_0.png resize: (392, 493) 1388743766 -1.6986096374161368 treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788618_0.png resize: (213, 336) 1388743767 0.2149490056487335 treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788619_0.png resize: (206, 206) 1388743768 -1.9603639557522639 treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788620_0.png resize: (281, 363) 1388743769 1.4387344373601114 treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788622_0.png resize: (143, 107) 1388743770 -3.7821261484780053 treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788626_0.png resize: (479, 693) 1388743771 -3.7985680847748045 treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788628_0.png resize: (202, 187) 1388743772 2.2427195160425235 treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788625_0.png resize: (109, 326) 1388743773 -1.9748410381328185 treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788627_0.png resize: (257, 393) 1388743774 -2.2092483219164154 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788631_0.png resize: (418, 198) 1388743776 -2.27680664019753 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788635_0.png resize: (326, 455) 1388743777 -4.414007308850467 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788630_0.png resize: (439, 626) 1388743778 -4.492931572780394 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788634_0.png resize: (93, 272) 1388743779 -2.6228445763977897 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788636_0.png resize: (133, 287) 1388743780 -1.908495100098383 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788633_0.png resize: (243, 173) 1388743781 -3.079233572653548 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788629_0.png resize: (344, 386) 1388743782 -3.2842033882067576 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788643_0.png resize: (197, 144) 1388743783 -2.7912425628366915 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788642_0.png resize: (353, 358) 1388743784 1.5145362982646582 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788637_0.png resize: (347, 321) 1388743785 0.6466010807099901 treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788645_0.png resize: (333, 173) 1388743786 1.5746010118558484 treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788644_0.png resize: (358, 326) 1388743787 -0.26211436663671434 treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788623_0.png resize: (257, 156) 1388743789 -3.3097038169025708 treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788632_0.png resize: (196, 184) 1388743790 -3.6574503933350555 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788638_0.png resize: (104, 215) 1388743791 -2.8831225957969537 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788641_0.png resize: (269, 149) 1388743792 -3.4618471960946318 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788639_0.png resize: (232, 131) 1388743793 -2.474783547725475 treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788646_0.png resize: (276, 140) 1388743795 -3.3140535925656525 treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788640_0.png resize: (621, 305) 1388743797 -4.462856603277587 treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788624_0.png resize: (125, 148) 1388743799 -2.1519400829998094 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 : 34 time used for this insertion : 0.039707183837890625 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 34 time used for this insertion : 0.03760671615600586 save missing photos in datou_result : time spend for datou_step_exec : 17.02426791191101 time spend to save output : 0.09549355506896973 total time spend for step 6 : 17.11976146697998 step7:brightness Fri Oct 10 14:22:07 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/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f.jpg treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7.jpg treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65.jpg treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a.jpg treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006.jpg treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788621_0.png treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788618_0.png treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788619_0.png treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788620_0.png treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788622_0.png treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788626_0.png treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788628_0.png treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788625_0.png treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788627_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788631_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788635_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788630_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788634_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788636_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788633_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788629_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788643_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788642_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788637_0.png treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788645_0.png treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788644_0.png treat image : temp/1760098828_465315_1388734802_3cb74ea359200d01c71e4e83fa01055f_rle_crop_3992788623_0.png treat image : temp/1760098828_465315_1388734797_b56f2747dddfc4a898a62329fab16b65_rle_crop_3992788632_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788638_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788641_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788639_0.png treat image : temp/1760098828_465315_1388734781_1636e414adbfca752c87d6c22c192006_rle_crop_3992788646_0.png treat image : temp/1760098828_465315_1388734792_93d8a0d771e98e16b86f56c7552f3f6a_rle_crop_3992788640_0.png treat image : temp/1760098828_465315_1388734799_5ee68e67890ce7388c22ca40a85f40c7_rle_crop_3992788624_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 : 34 time used for this insertion : 0.03752613067626953 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 34 time used for this insertion : 0.03757119178771973 save missing photos in datou_result : time spend for datou_step_exec : 5.165949106216431 time spend to save output : 0.09276771545410156 total time spend for step 7 : 5.258716821670532 step8:velours_tree Fri Oct 10 14:22:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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.24642038345336914 time spend to save output : 4.029273986816406e-05 total time spend for step 8 : 0.2464606761932373 step9:send_mail_cod Fri Oct 10 14:22:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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_P27699099_10-10-2025_14_22_12.pdf 27699998 change filename to text .imagette276999981760098932 27699999 imagette276999991760098933 27700000 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette277000001760098933 27700001 imagette277000011760098933 27700002 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 .imagette277000021760098933 27700004 imagette277000041760098935 27700005 change filename to text .imagette277000051760098935 27700006 imagette277000061760098936 27700007 imagette277000071760098936 27700008 imagette277000081760098936 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=27699099 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/27699998,27699999,27700000,27700001,27700002,27700003,27700004,27700005,27700006,27700007,27700008?tags=pet_clair,pehd,carton,metal,papier,environnement,background,autre,flou,pet_fonce,mal_croppe args[1388734802] : ((1388734802, -7.059428526230514, 492609224), (1388734802, 1.7017141928099222, 2107752395), '0.03978522858796297') We are sending mail with results at report@fotonower.com args[1388734799] : ((1388734799, -7.0174068411956565, 492609224), (1388734799, 1.5369087116736548, 2107752395), '0.03978522858796297') We are sending mail with results at report@fotonower.com args[1388734797] : ((1388734797, -6.823341571119875, 492609224), (1388734797, 2.152252982087018, 492649241), '0.03978522858796297') We are sending mail with results at report@fotonower.com args[1388734792] : ((1388734792, -7.104350714680066, 492609224), (1388734792, 1.8389641027636439, 2107752395), '0.03978522858796297') We are sending mail with results at report@fotonower.com args[1388734781] : ((1388734781, -7.080114886856625, 492609224), (1388734781, 1.8626163880554136, 2107752395), '0.03978522858796297') We are sending mail with results at report@fotonower.com refus_total : 0.03978522858796297 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27699099 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_P27699099_10-10-2025_14_22_12.pdf results_Auto_P27699099_10-10-2025_14_22_12.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27699099_10-10-2025_14_22_12.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','27699099','results_Auto_P27699099_10-10-2025_14_22_12.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27699099_10-10-2025_14_22_12.pdf','pdf','','0.35','0.03978522858796297') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/27699099

https://www.fotonower.com/image?json=false&list_photos_id=1388734802
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388734799
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388734797
La photo est trop lumineuse, merci de reprendre une photo.(avec le score = 2.152252982087018,le score doit entre -2 et 2)
https://www.fotonower.com/image?json=false&list_photos_id=1388734792
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388734781
Bravo, la photo est bien prise.

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

exemples de contaminants: pet_clair: https://www.fotonower.com/view/27699998?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/27700000?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/27700002?limit=200
exemples de contaminants: autre: https://www.fotonower.com/view/27700005?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27699099_10-10-2025_14_22_12.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/27699998,27699999,27700000,27700001,27700002,27700003,27700004,27700005,27700006,27700007,27700008?tags=pet_clair,pehd,carton,metal,papier,environnement,background,autre,flou,pet_fonce,mal_croppe.


L'équipe Fotonower 202 b'' Server: nginx Date: Fri, 10 Oct 2025 12:22:18 GMT Content-Length: 0 Connection: close X-Message-Id: oL1LodyGQcWEnloSg56ozw 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 [1388734802, 1388734799, 1388734797, 1388734792, 1388734781] 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, '3924282') ('3318', '27699099', '1388734802', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734799', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734797', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734792', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734781', None, None, None, None, None, '3924282') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 5 time used for this insertion : 0.03629755973815918 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.480806589126587 time spend to save output : 0.03647351264953613 total time spend for step 9 : 5.517280101776123 step10:split_time_score Fri Oct 10 14:22:18 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'}] (('13', 5),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 10102025 27699099 Nombre de photos uploadées : 5 / 23040 (0%) 10102025 27699099 Nombre de photos taguées (types de déchets): 0 / 5 (0%) 10102025 27699099 Nombre de photos taguées (volume) : 0 / 5 (0%) elapsed_time : load_data_split_time_score 2.384185791015625e-06 elapsed_time : order_list_meta_photo_and_scores 9.059906005859375e-06 ????? elapsed_time : fill_and_build_computed_from_old_data 0.00061798095703125 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.6869916915893555 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.016585620841056286 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27687819_10-10-2025_10_37_02.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27687819 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27687819 AND mptpi.`type`=3726 To do Qualite : 0.011015505999029911 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27687824_10-10-2025_10_26_51.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27687824 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27687824 AND mptpi.`type`=3726 To do Qualite : 0.03243944818601996 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27688029_10-10-2025_10_16_56.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27688029 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27688029 AND mptpi.`type`=3726 To do Qualite : 0.09762990144500565 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27691360_10-10-2025_13_54_20.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27691360 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`=27691360 AND mptpi.`type`=3594 To do Qualite : 0.023645774617599626 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27694856_10-10-2025_12_17_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27694856 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27694856 AND mptpi.`type`=3726 To do Qualite : 0.07622775059624015 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27694858_10-10-2025_12_16_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27694858 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`=27694858 AND mptpi.`type`=3594 To do Qualite : 0.05575887345679011 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27699098_10-10-2025_14_12_18.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27699098 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`=27699098 AND mptpi.`type`=3594 To do Qualite : 0.03978522858796297 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27699099_10-10-2025_14_22_12.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27699099 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`=27699099 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'10102025': {'nb_upload': 5, '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 [1388734802, 1388734799, 1388734797, 1388734792, 1388734781] Looping around the photos to save general results len do output : 1 /27699099Didn'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, '3924282') ('3318', '27699099', '1388734802', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734799', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734797', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734792', None, None, None, None, None, '3924282') ('3318', None, None, None, None, None, None, None, '3924282') ('3318', '27699099', '1388734781', None, None, None, None, None, '3924282') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.036777496337890625 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.983513355255127 time spend to save output : 0.03695321083068848 total time spend for step 10 : 3.0204665660858154 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 5 set_done_treatment 55.62user 30.83system 1:56.41elapsed 74%CPU (0avgtext+0avgdata 3442812maxresident)k 30560inputs+40072outputs (597major+3715423minor)pagefaults 0swaps