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 : 350095 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 : ['4072127'] with mtr_portfolio_ids : ['28685558'] and first list_photo_ids : [] new path : /proc/350095/ Inside batchDatouExec : verbose : 0 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! List Step Type Loaded in datou : mask_detect, crop_condition, rle_unique_nms_with_priority, ventilate_hashtags_in_portfolio, final, blur_detection, brightness, velours_tree, send_mail_cod, split_time_score over limit max, limiting to limit_max 40 list_input_json : [] origin We have 1 , BFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 14 ; length of list_pids : 14 ; length of list_args : 14 time to download the photos : 2.0761537551879883 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 Wed Nov 19 01:10:32 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 4012 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-11-19 01:10:34.781059: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-11-19 01:10:34.806500: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493010000 Hz 2025-11-19 01:10:34.808065: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fe970000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-11-19 01:10:34.808116: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-11-19 01:10:34.810880: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-11-19 01:10:35.072998: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x3c4daf70 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-11-19 01:10:35.073046: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-11-19 01:10:35.073810: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-11-19 01:10:35.077765: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-19 01:10:35.081466: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-19 01:10:35.083833: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-19 01:10:35.085002: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-19 01:10:35.087719: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-19 01:10:35.089041: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-19 01:10:35.094857: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-19 01:10:35.095993: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-19 01:10:35.096078: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-19 01:10:35.096651: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-11-19 01:10:35.096666: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-11-19 01:10:35.096675: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-11-19 01:10:35.097603: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 3560 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-11-19 01:10:35.372781: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-11-19 01:10:35.372892: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-19 01:10:35.372908: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-19 01:10:35.372923: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-19 01:10:35.372937: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-19 01:10:35.372950: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-19 01:10:35.372963: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-19 01:10:35.372977: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-19 01:10:35.373776: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-19 01:10:35.374825: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-11-19 01:10:35.374858: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-19 01:10:35.374874: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-19 01:10:35.374888: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-19 01:10:35.374901: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-19 01:10:35.374915: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-19 01:10:35.374928: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-19 01:10:35.374942: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-19 01:10:35.375788: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-19 01:10:35.375821: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-11-19 01:10:35.375829: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-11-19 01:10:35.375836: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-11-19 01:10:35.376667: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 3560 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) Using TensorFlow backend. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:396: calling crop_and_resize_v1 (from tensorflow.python.ops.image_ops_impl) with box_ind is deprecated and will be removed in a future version. Instructions for updating: box_ind is deprecated, use box_indices instead WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:703: to_int32 (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:729: to_float (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. Inside mask_sub_process Inside mask_detect About to load cache.load_thcl_param To do loadFromThcl(), then load ParamDescType : thcl2847 thcls : [{'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}] thcl {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5275 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) {'thcl': {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'], 'list_hashtags_csv': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'svm_hashtag_type_desc': 5275, 'photo_desc_type': 5275, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'] Configurations: BACKBONE resnet101 BACKBONE_SHAPES [[160 160] [ 80 80] [ 40 40] [ 20 20] [ 10 10]] BACKBONE_STRIDES [4, 8, 16, 32, 64] BATCH_SIZE 1 BBOX_STD_DEV [0.1 0.1 0.2 0.2] DETECTION_MAX_INSTANCES 100 DETECTION_MIN_CONFIDENCE 0.3 DETECTION_NMS_THRESHOLD 0.3 GPU_COUNT 1 IMAGES_PER_GPU 1 IMAGE_MAX_DIM 640 IMAGE_MIN_DIM 640 IMAGE_PADDING True IMAGE_SHAPE [640 640 3] LEARNING_MOMENTUM 0.9 LEARNING_RATE 0.001 LOSS_WEIGHTS {'rpn_class_loss': 1.0, 'rpn_bbox_loss': 1.0, 'mrcnn_class_loss': 1.0, 'mrcnn_bbox_loss': 1.0, 'mrcnn_mask_loss': 1.0} MASK_POOL_SIZE 14 MASK_SHAPE [28, 28] MAX_GT_INSTANCES 100 MEAN_PIXEL [123.7 116.8 103.9] MINI_MASK_SHAPE (56, 56) NAME learn_RUBBIA_REFUS_AMIENS_23 NUM_CLASSES 9 POOL_SIZE 7 POST_NMS_ROIS_INFERENCE 1000 POST_NMS_ROIS_TRAINING 2000 ROI_POSITIVE_RATIO 0.33 RPN_ANCHOR_RATIOS [0.5, 1, 2] RPN_ANCHOR_SCALES (16, 32, 64, 128, 256) RPN_ANCHOR_STRIDE 1 RPN_BBOX_STD_DEV [0.1 0.1 0.2 0.2] RPN_NMS_THRESHOLD 0.7 RPN_TRAIN_ANCHORS_PER_IMAGE 256 STEPS_PER_EPOCH 1000 TRAIN_ROIS_PER_IMAGE 200 USE_MINI_MASK True USE_RPN_ROIS True VALIDATION_STEPS 50 WEIGHT_DECAY 0.0001 model_param file didn't exist model_name : learn_RUBBIA_REFUS_AMIENS_23 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-11-19 01:10:47.696542: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-19 01:10:47.903869: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-19 01:10:49.326146: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 2.98G (3198025728 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-11-19 01:10:50.108206: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 3.29GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-11-19 01:10:50.108279: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 3.29GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. local folder : /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23 /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23/mask_model.h5 size_local : 256009536 size in s3 : 256009536 create time local : 2021-08-09 09:43:22 create time in s3 : 2021-08-06 18:54:04 mask_model.h5 already exist and didn't need to update list_images length : 14 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 43.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 36.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 23.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 27.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 39.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 30.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 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: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 40.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 1 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 54.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 29.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 35.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 1 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 36.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 27.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 38.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 1 Detection mask done ! Trying to reset tf kernel 350695 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 73 tf kernel not reseted sub process len(results) : 14 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 14 len(list_Values) 0 process is alive finish correctly or not : True after detect begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 4012 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.0002620220184326172 nb_pixel_total : 11076 time to create 1 rle with old method : 0.012527704238891602 length of segment : 130 time for calcul the mask position with numpy : 0.00024175643920898438 nb_pixel_total : 10588 time to create 1 rle with old method : 0.012103557586669922 length of segment : 100 time for calcul the mask position with numpy : 0.0016202926635742188 nb_pixel_total : 94748 time to create 1 rle with old method : 0.1054229736328125 length of segment : 516 time for calcul the mask position with numpy : 0.00015592575073242188 nb_pixel_total : 6311 time to create 1 rle with old method : 0.007132053375244141 length of segment : 129 time for calcul the mask position with numpy : 0.5025923252105713 nb_pixel_total : 641453 time to create 1 rle with new method : 0.03376936912536621 length of segment : 908 time for calcul the mask position with numpy : 0.0005366802215576172 nb_pixel_total : 42435 time to create 1 rle with old method : 0.04836750030517578 length of segment : 174 time for calcul the mask position with numpy : 0.016820430755615234 nb_pixel_total : 1529980 time to create 1 rle with new method : 0.21157360076904297 length of segment : 1035 time for calcul the mask position with numpy : 0.00034546852111816406 nb_pixel_total : 20145 time to create 1 rle with old method : 0.025821685791015625 length of segment : 139 time for calcul the mask position with numpy : 0.0005178451538085938 nb_pixel_total : 19143 time to create 1 rle with old method : 0.022600650787353516 length of segment : 157 time for calcul the mask position with numpy : 0.00020194053649902344 nb_pixel_total : 4241 time to create 1 rle with old method : 0.005120754241943359 length of segment : 75 time for calcul the mask position with numpy : 0.0006995201110839844 nb_pixel_total : 24858 time to create 1 rle with old method : 0.028962135314941406 length of segment : 277 time for calcul the mask position with numpy : 0.0025267601013183594 nb_pixel_total : 110517 time to create 1 rle with old method : 0.13057994842529297 length of segment : 540 time for calcul the mask position with numpy : 0.00025582313537597656 nb_pixel_total : 7873 time to create 1 rle with old method : 0.00936436653137207 length of segment : 97 time for calcul the mask position with numpy : 0.016587018966674805 nb_pixel_total : 856248 time to create 1 rle with new method : 0.28076696395874023 length of segment : 1077 time for calcul the mask position with numpy : 0.00012993812561035156 nb_pixel_total : 4341 time to create 1 rle with old method : 0.0053136348724365234 length of segment : 77 time for calcul the mask position with numpy : 0.002137422561645508 nb_pixel_total : 110894 time to create 1 rle with old method : 0.12097764015197754 length of segment : 566 time for calcul the mask position with numpy : 0.0019652843475341797 nb_pixel_total : 122523 time to create 1 rle with old method : 0.13758039474487305 length of segment : 430 time for calcul the mask position with numpy : 0.0002715587615966797 nb_pixel_total : 18729 time to create 1 rle with old method : 0.020825624465942383 length of segment : 111 time for calcul the mask position with numpy : 0.0014417171478271484 nb_pixel_total : 86865 time to create 1 rle with old method : 0.0968632698059082 length of segment : 464 time for calcul the mask position with numpy : 0.004313230514526367 nb_pixel_total : 272983 time to create 1 rle with new method : 0.07164788246154785 length of segment : 1077 time for calcul the mask position with numpy : 0.002225637435913086 nb_pixel_total : 113052 time to create 1 rle with old method : 0.13028478622436523 length of segment : 562 time for calcul the mask position with numpy : 0.00028014183044433594 nb_pixel_total : 10669 time to create 1 rle with old method : 0.012034416198730469 length of segment : 181 time for calcul the mask position with numpy : 0.0002880096435546875 nb_pixel_total : 6427 time to create 1 rle with old method : 0.00748443603515625 length of segment : 160 time spent for convertir_results : 3.5693728923797607 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 23 chid ids of type : 3594 Number RLEs to save : 8982 save missing photos in datou_result : time spend for datou_step_exec : 40.334691286087036 time spend to save output : 0.6617796421051025 total time spend for step 1 : 40.99647092819214 step2:crop_condition Wed Nov 19 01:11:13 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure Loading chi in step crop with photo_hashtag_type : 3594 Loading chi in step crop for list_pids : 14 ! batch 1 Loaded 23 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 ! map_result returned by crop_photo_return_map_crop : length : 5 About to insert : list_path_to_insert length 5 new photo from crops ! About to upload 5 photos upload in portfolio : 3736932 init cache_photo without model_param we have 5 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1763511074_350095 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(1763511075), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181355_0.png', 0, 90, 123, 0, 1763511075,'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(1763511075), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181353_0.png', 0, 152, 99, 0, 1763511075,'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(1763511075), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181364_0.png', 0, 120, 96, 0, 1763511075,'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(1763511075), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181366_0.png', 0, 100, 74, 0, 1763511075,'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(1763511075), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088644_bac656f808c0ac0443c9b8fc15374fcb_rle_crop_4038181373_0.png', 0, 92, 181, 0, 1763511075,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 5 photos in the portfolio 3736932 time of upload the photos Elapsed time : 2.221747875213623 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 begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 18 About to insert : list_path_to_insert length 18 new photo from crops ! About to upload 18 photos upload in portfolio : 3736932 init cache_photo without model_param we have 18 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1763511093_350095 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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181352_0.png', 0, 113, 130, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181354_0.png', 0, 298, 516, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d_rle_crop_4038181356_0.png', 0, 967, 907, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d_rle_crop_4038181357_0.png', 0, 313, 171, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181358_0.png', 0, 1625, 979, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181359_0.png', 0, 213, 139, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181360_0.png', 0, 265, 120, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a_rle_crop_4038181361_0.png', 0, 74, 75, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a_rle_crop_4038181362_0.png', 0, 125, 276, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181365_0.png', 0, 1119, 997, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181363_0.png', 0, 332, 535, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088857_8225f558526abca8fe62261a13928c29_rle_crop_4038181367_0.png', 0, 337, 562, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69_rle_crop_4038181368_0.png', 0, 457, 368, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69_rle_crop_4038181369_0.png', 0, 231, 102, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231_rle_crop_4038181371_0.png', 0, 623, 896, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231_rle_crop_4038181370_0.png', 0, 331, 462, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088677_0da490a252729b1b888105af74c60cdf_rle_crop_4038181372_0.png', 0, 351, 555, 0, 1763511095,'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(1763511095), 0.0, 0.0, 14, '', 0, 0, '1763511029_350095_1395088597_3d58b15f524f7e3d84a10422feaa8c9a_rle_crop_4038181374_0.png', 0, 105, 160, 0, 1763511095,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 18 photos in the portfolio 3736932 time of upload the photos Elapsed time : 4.129611253738403 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1395089139, 1395089096, 1395088960, 1395088925, 1395088892, 1395088857, 1395088823, 1395088787, 1395088712, 1395088677, 1395088644, 1395088597, 1395088561, 1395087805] Looping around the photos to save general results len do output : 23 /1395120399Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120401Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120402Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120403Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120405Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120513Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120514Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120515Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120517Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120518Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120519Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120520Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120521Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120522Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120523Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120524Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120525Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120526Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120527Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120528Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120529Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120530Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1395120531Didn'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, '4072127') ('3318', '28685558', '1395089139', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395089096', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088960', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088925', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088892', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088857', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088823', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088787', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088712', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088677', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088644', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088597', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088561', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395087805', None, None, None, None, None, '4072127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 83 time used for this insertion : 0.02609419822692871 save_final save missing photos in datou_result : time spend for datou_step_exec : 23.72843623161316 time spend to save output : 0.026917457580566406 total time spend for step 2 : 23.755353689193726 step3:rle_unique_nms_with_priority Wed Nov 19 01:11:36 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 23 chid ids of type : 3594 +++++++++++++++++++++++++++++nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.4604630470275879 time for calcul the mask position with numpy : 0.06408238410949707 nb_pixel_total : 1950954 time to create 1 rle with new method : 0.18445205688476562 time for calcul the mask position with numpy : 0.00677037239074707 nb_pixel_total : 6311 time to create 1 rle with old method : 0.007137298583984375 time for calcul the mask position with numpy : 0.006861686706542969 nb_pixel_total : 94671 time to create 1 rle with old method : 0.10976028442382812 time for calcul the mask position with numpy : 0.0075986385345458984 nb_pixel_total : 10588 time to create 1 rle with old method : 0.012003660202026367 time for calcul the mask position with numpy : 0.007152080535888672 nb_pixel_total : 11076 time to create 1 rle with old method : 0.01252603530883789 create new chi : 0.429516077041626 time to delete rle : 0.03296923637390137 batch 1 Loaded 9 chid ids of type : 3594 +++++Number RLEs to save : 2794 TO DO : save crop sub photo not yet done ! save time : 0.20682573318481445 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.10111665725708008 time for calcul the mask position with numpy : 0.13353443145751953 nb_pixel_total : 1389712 time to create 1 rle with new method : 0.09263896942138672 time for calcul the mask position with numpy : 0.006693363189697266 nb_pixel_total : 42435 time to create 1 rle with old method : 0.04722309112548828 time for calcul the mask position with numpy : 0.010694026947021484 nb_pixel_total : 641453 time to create 1 rle with new method : 0.02899956703186035 create new chi : 0.3202829360961914 time to delete rle : 0.00031065940856933594 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 3244 TO DO : save crop sub photo not yet done ! save time : 0.22227096557617188 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.06039309501647949 time for calcul the mask position with numpy : 0.009538650512695312 nb_pixel_total : 524477 time to create 1 rle with new method : 0.16166925430297852 time for calcul the mask position with numpy : 0.006255388259887695 nb_pixel_total : 19143 time to create 1 rle with old method : 0.02146744728088379 time for calcul the mask position with numpy : 0.016415834426879883 nb_pixel_total : 1529980 time to create 1 rle with new method : 0.050154685974121094 create new chi : 0.2659885883331299 time to delete rle : 0.00039267539978027344 batch 1 Loaded 6 chid ids of type : 3594 ++++Number RLEs to save : 3464 TO DO : save crop sub photo not yet done ! save time : 0.2500011920928955 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.05086326599121094 time for calcul the mask position with numpy : 0.5650894641876221 nb_pixel_total : 2044501 time to create 1 rle with new method : 0.45436835289001465 time for calcul the mask position with numpy : 0.006809234619140625 nb_pixel_total : 24858 time to create 1 rle with old method : 0.02772831916809082 time for calcul the mask position with numpy : 0.0069925785064697266 nb_pixel_total : 4241 time to create 1 rle with old method : 0.004869699478149414 create new chi : 1.076648473739624 time to delete rle : 0.0003879070281982422 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1784 TO DO : save crop sub photo not yet done ! save time : 0.15203332901000977 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.10650849342346191 time for calcul the mask position with numpy : 0.3977620601654053 nb_pixel_total : 1101042 time to create 1 rle with new method : 0.08179926872253418 time for calcul the mask position with numpy : 0.012372732162475586 nb_pixel_total : 854168 time to create 1 rle with new method : 0.42360472679138184 time for calcul the mask position with numpy : 0.0062389373779296875 nb_pixel_total : 7873 time to create 1 rle with old method : 0.00867605209350586 time for calcul the mask position with numpy : 0.006639242172241211 nb_pixel_total : 110517 time to create 1 rle with old method : 0.11944580078125 create new chi : 1.0734198093414307 time to delete rle : 0.000579833984375 batch 1 Loaded 8 chid ids of type : 3594 ++++Number RLEs to save : 4485 TO DO : save crop sub photo not yet done ! save time : 0.3046302795410156 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.033387184143066406 time for calcul the mask position with numpy : 0.0185849666595459 nb_pixel_total : 1962706 time to create 1 rle with new method : 0.4352684020996094 time for calcul the mask position with numpy : 0.00751495361328125 nb_pixel_total : 110894 time to create 1 rle with old method : 0.12847566604614258 create new chi : 0.597477912902832 time to delete rle : 0.0003898143768310547 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2212 TO DO : save crop sub photo not yet done ! save time : 0.18097877502441406 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.09540987014770508 time for calcul the mask position with numpy : 0.04259300231933594 nb_pixel_total : 1946658 time to create 1 rle with new method : 0.4077115058898926 time for calcul the mask position with numpy : 0.006028652191162109 nb_pixel_total : 4419 time to create 1 rle with old method : 0.004958152770996094 time for calcul the mask position with numpy : 0.008795976638793945 nb_pixel_total : 122523 time to create 1 rle with old method : 0.13561773300170898 create new chi : 0.6165294647216797 time to delete rle : 0.0003542900085449219 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 2008 TO DO : save crop sub photo not yet done ! save time : 0.16725397109985352 No data in photo_id : 1395088787 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04507875442504883 time for calcul the mask position with numpy : 0.05720329284667969 nb_pixel_total : 1714584 time to create 1 rle with new method : 0.46767497062683105 time for calcul the mask position with numpy : 0.00867319107055664 nb_pixel_total : 272151 time to create 1 rle with new method : 0.45071864128112793 time for calcul the mask position with numpy : 0.006970405578613281 nb_pixel_total : 86865 time to create 1 rle with old method : 0.09684967994689941 create new chi : 1.1019411087036133 time to delete rle : 0.0006155967712402344 batch 1 Loaded 5 chid ids of type : 3594 ++++++Number RLEs to save : 4061 TO DO : save crop sub photo not yet done ! save time : 0.2806973457336426 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.03961062431335449 time for calcul the mask position with numpy : 0.05650615692138672 nb_pixel_total : 1960548 time to create 1 rle with new method : 0.14945673942565918 time for calcul the mask position with numpy : 0.007147312164306641 nb_pixel_total : 113052 time to create 1 rle with old method : 0.13169264793395996 create new chi : 0.35701513290405273 time to delete rle : 0.00035691261291503906 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2204 TO DO : save crop sub photo not yet done ! save time : 0.1887834072113037 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.03172183036804199 time for calcul the mask position with numpy : 0.3934824466705322 nb_pixel_total : 2062931 time to create 1 rle with new method : 0.07596969604492188 time for calcul the mask position with numpy : 0.00625920295715332 nb_pixel_total : 10669 time to create 1 rle with old method : 0.011692523956298828 create new chi : 0.498302698135376 time to delete rle : 0.0002758502960205078 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1442 TO DO : save crop sub photo not yet done ! save time : 0.11905074119567871 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.03277921676635742 time for calcul the mask position with numpy : 0.30446696281433105 nb_pixel_total : 2067173 time to create 1 rle with new method : 0.4014623165130615 time for calcul the mask position with numpy : 0.006478309631347656 nb_pixel_total : 6427 time to create 1 rle with old method : 0.0071523189544677734 create new chi : 0.7303085327148438 time to delete rle : 0.00025153160095214844 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1400 TO DO : save crop sub photo not yet done ! save time : 0.12936997413635254 No data in photo_id : 1395088561 No data in photo_id : 1395087805 map_output_result : {1395089139: (0.0, 'Should be the crop_list due to order', 0), 1395089096: (0.0, 'Should be the crop_list due to order', 0), 1395088960: (0.0, 'Should be the crop_list due to order', 0), 1395088925: (0.0, 'Should be the crop_list due to order', 0), 1395088892: (0.0, 'Should be the crop_list due to order', 0), 1395088857: (0.0, 'Should be the crop_list due to order', 0), 1395088823: (0.0, 'Should be the crop_list due to order', 0), 1395088787: (0.0, 'Should be the crop_list due to order', 0.0), 1395088712: (0.0, 'Should be the crop_list due to order', 0), 1395088677: (0.0, 'Should be the crop_list due to order', 0), 1395088644: (0.0, 'Should be the crop_list due to order', 0), 1395088597: (0.0, 'Should be the crop_list due to order', 0), 1395088561: (0.0, 'Should be the crop_list due to order', 0.0), 1395087805: (0.0, 'Should be the crop_list due to order', 0.0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1395089139, 1395089096, 1395088960, 1395088925, 1395088892, 1395088857, 1395088823, 1395088787, 1395088712, 1395088677, 1395088644, 1395088597, 1395088561, 1395087805] Looping around the photos to save general results len do output : 14 /1395089139.Didn't retrieve data . /1395089096.Didn't retrieve data . /1395088960.Didn't retrieve data . /1395088925.Didn't retrieve data . /1395088892.Didn't retrieve data . /1395088857.Didn't retrieve data . /1395088823.Didn't retrieve data . /1395088787.Didn't retrieve data . /1395088712.Didn't retrieve data . /1395088677.Didn't retrieve data . /1395088644.Didn't retrieve data . /1395088597.Didn't retrieve data . /1395088561.Didn't retrieve data . /1395087805.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, '4072127') ('3318', '28685558', '1395089139', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395089096', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088960', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088925', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088892', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088857', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088823', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088787', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088712', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088677', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088644', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088597', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088561', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395087805', None, None, None, None, None, '4072127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 42 time used for this insertion : 0.017928600311279297 save_final save missing photos in datou_result : time spend for datou_step_exec : 10.743611812591553 time spend to save output : 0.018387317657470703 total time spend for step 3 : 10.761999130249023 step4:ventilate_hashtags_in_portfolio Wed Nov 19 01:11:47 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 : 28685558 get user id for portfolio 28685558 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`=28685558 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pehd','flou','metal','pet_clair','carton','pet_fonce','background','papier','autre','environnement','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`=28685558 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pehd','flou','metal','pet_clair','carton','pet_fonce','background','papier','autre','environnement','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`=28685558 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pehd','flou','metal','pet_clair','carton','pet_fonce','background','papier','autre','environnement','mal_croppe')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/28685656,28685657,28685658,28685659,28685660,28685661,28685662,28685663,28685664,28685665,28685666?tags=pehd,flou,metal,pet_clair,carton,pet_fonce,background,papier,autre,environnement,mal_croppe Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1395089139, 1395089096, 1395088960, 1395088925, 1395088892, 1395088857, 1395088823, 1395088787, 1395088712, 1395088677, 1395088644, 1395088597, 1395088561, 1395087805] Looping around the photos to save general results len do output : 1 /28685558. 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, '4072127') ('3318', '28685558', '1395089139', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395089096', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088960', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088925', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088892', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088857', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088823', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088787', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088712', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088677', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088644', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088597', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088561', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395087805', None, None, None, None, None, '4072127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.01599407196044922 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6231186389923096 time spend to save output : 0.016266822814941406 total time spend for step 4 : 1.639385461807251 step5:final Wed Nov 19 01:11: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 : {1395089139: ('0.14069093088624338',), 1395089096: ('0.14069093088624338',), 1395088960: ('0.14069093088624338',), 1395088925: ('0.14069093088624338',), 1395088892: ('0.14069093088624338',), 1395088857: ('0.14069093088624338',), 1395088823: ('0.14069093088624338',), 1395088787: ('0.14069093088624338',), 1395088712: ('0.14069093088624338',), 1395088677: ('0.14069093088624338',), 1395088644: ('0.14069093088624338',), 1395088597: ('0.14069093088624338',), 1395088561: ('0.14069093088624338',), 1395087805: ('0.14069093088624338',)} new output for save of step final : {1395089139: ('0.14069093088624338',), 1395089096: ('0.14069093088624338',), 1395088960: ('0.14069093088624338',), 1395088925: ('0.14069093088624338',), 1395088892: ('0.14069093088624338',), 1395088857: ('0.14069093088624338',), 1395088823: ('0.14069093088624338',), 1395088787: ('0.14069093088624338',), 1395088712: ('0.14069093088624338',), 1395088677: ('0.14069093088624338',), 1395088644: ('0.14069093088624338',), 1395088597: ('0.14069093088624338',), 1395088561: ('0.14069093088624338',), 1395087805: ('0.14069093088624338',)} [1395089139, 1395089096, 1395088960, 1395088925, 1395088892, 1395088857, 1395088823, 1395088787, 1395088712, 1395088677, 1395088644, 1395088597, 1395088561, 1395087805] Looping around the photos to save general results len do output : 14 /1395089139.Didn't retrieve data . /1395089096.Didn't retrieve data . /1395088960.Didn't retrieve data . /1395088925.Didn't retrieve data . /1395088892.Didn't retrieve data . /1395088857.Didn't retrieve data . /1395088823.Didn't retrieve data . /1395088787.Didn't retrieve data . /1395088712.Didn't retrieve data . /1395088677.Didn't retrieve data . /1395088644.Didn't retrieve data . /1395088597.Didn't retrieve data . /1395088561.Didn't retrieve data . /1395087805.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, '4072127') ('3318', '28685558', '1395089139', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395089096', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088960', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088925', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088892', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088857', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088823', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088787', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088712', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088677', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088644', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088597', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088561', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395087805', None, None, None, None, None, '4072127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 42 time used for this insertion : 0.020561695098876953 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.12666606903076172 time spend to save output : 0.02100849151611328 total time spend for step 5 : 0.147674560546875 step6:blur_detection Wed Nov 19 01:11: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 ! 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/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba.jpg resize: (1080, 1920) 1395089139 -2.1403528828003813 treat image : temp/1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d.jpg resize: (1080, 1920) 1395089096 -0.5838424217813666 treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974.jpg resize: (1080, 1920) 1395088960 -0.6679538033320642 treat image : temp/1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a.jpg resize: (1080, 1920) 1395088925 1.150188769948386 treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba.jpg resize: (1080, 1920) 1395088892 1.5331494994174237 treat image : temp/1763511029_350095_1395088857_8225f558526abca8fe62261a13928c29.jpg resize: (1080, 1920) 1395088857 -0.28022326194460295 treat image : temp/1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69.jpg resize: (1080, 1920) 1395088823 -0.5137808314437053 treat image : temp/1763511029_350095_1395088787_577bd2d503f2304a65d456ae684dc003.jpg resize: (1080, 1920) 1395088787 -0.7579373338157319 treat image : temp/1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231.jpg resize: (1080, 1920) 1395088712 -0.7986192334401154 treat image : temp/1763511029_350095_1395088677_0da490a252729b1b888105af74c60cdf.jpg resize: (1080, 1920) 1395088677 -4.399153045422855 treat image : temp/1763511029_350095_1395088644_bac656f808c0ac0443c9b8fc15374fcb.jpg resize: (1080, 1920) 1395088644 -0.6520439494648553 treat image : temp/1763511029_350095_1395088597_3d58b15f524f7e3d84a10422feaa8c9a.jpg resize: (1080, 1920) 1395088597 -1.2312240248998898 treat image : temp/1763511029_350095_1395088561_1777e0afb250f5f59922084be8d93a61.jpg resize: (1080, 1920) 1395088561 -4.27877857568233 treat image : temp/1763511029_350095_1395087805_3c214d4f339c783dac9e6a425be0b53f.jpg resize: (1080, 1920) 1395087805 -4.678987208320855 treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181355_0.png resize: (123, 90) 1395120399 -1.4541352629322755 treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181353_0.png resize: (99, 152) 1395120401 -0.7088279837113959 treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181364_0.png resize: (96, 120) 1395120402 -0.14964538923042273 treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181366_0.png resize: (74, 100) 1395120403 -2.066470798841991 treat image : temp/1763511029_350095_1395088644_bac656f808c0ac0443c9b8fc15374fcb_rle_crop_4038181373_0.png resize: (181, 92) 1395120405 -0.05852605614374329 treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181352_0.png resize: (130, 113) 1395120513 -1.6843717034089227 treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181354_0.png resize: (516, 298) 1395120514 0.4063306826470711 treat image : temp/1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d_rle_crop_4038181356_0.png resize: (907, 967) 1395120515 0.2940322118114155 treat image : temp/1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d_rle_crop_4038181357_0.png resize: (171, 313) 1395120517 -1.5226480200851935 treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181358_0.png resize: (979, 1625) 1395120518 -1.3408839158540389 treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181359_0.png resize: (139, 213) 1395120519 -2.1988852702901247 treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181360_0.png resize: (120, 265) 1395120520 -2.2244900854152765 treat image : temp/1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a_rle_crop_4038181361_0.png resize: (75, 74) 1395120521 -0.2551624189070558 treat image : temp/1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a_rle_crop_4038181362_0.png resize: (276, 125) 1395120522 -0.8212555698090932 treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181365_0.png resize: (997, 1119) 1395120523 -0.6282622004818126 treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181363_0.png resize: (535, 332) 1395120524 0.13936175627515007 treat image : temp/1763511029_350095_1395088857_8225f558526abca8fe62261a13928c29_rle_crop_4038181367_0.png resize: (562, 337) 1395120525 0.1661880361046712 treat image : temp/1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69_rle_crop_4038181368_0.png resize: (368, 457) 1395120526 -0.9304133923969116 treat image : temp/1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69_rle_crop_4038181369_0.png resize: (102, 231) 1395120527 -0.7855353023250238 treat image : temp/1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231_rle_crop_4038181371_0.png resize: (896, 623) 1395120528 -0.7534898043344574 treat image : temp/1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231_rle_crop_4038181370_0.png resize: (462, 331) 1395120529 0.3023387765374442 treat image : temp/1763511029_350095_1395088677_0da490a252729b1b888105af74c60cdf_rle_crop_4038181372_0.png resize: (555, 351) 1395120530 0.1532297459708797 treat image : temp/1763511029_350095_1395088597_3d58b15f524f7e3d84a10422feaa8c9a_rle_crop_4038181374_0.png resize: (160, 105) 1395120531 -3.128824059168303 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 : 37 time used for this insertion : 0.014179706573486328 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 37 time used for this insertion : 0.016568422317504883 save missing photos in datou_result : time spend for datou_step_exec : 12.939330816268921 time spend to save output : 0.0359799861907959 total time spend for step 6 : 12.975310802459717 step7:brightness Wed Nov 19 01:12:02 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba.jpg treat image : temp/1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d.jpg treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974.jpg treat image : temp/1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a.jpg treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba.jpg treat image : temp/1763511029_350095_1395088857_8225f558526abca8fe62261a13928c29.jpg treat image : temp/1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69.jpg treat image : temp/1763511029_350095_1395088787_577bd2d503f2304a65d456ae684dc003.jpg treat image : temp/1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231.jpg treat image : temp/1763511029_350095_1395088677_0da490a252729b1b888105af74c60cdf.jpg treat image : temp/1763511029_350095_1395088644_bac656f808c0ac0443c9b8fc15374fcb.jpg treat image : temp/1763511029_350095_1395088597_3d58b15f524f7e3d84a10422feaa8c9a.jpg treat image : temp/1763511029_350095_1395088561_1777e0afb250f5f59922084be8d93a61.jpg treat image : temp/1763511029_350095_1395087805_3c214d4f339c783dac9e6a425be0b53f.jpg treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181355_0.png treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181353_0.png treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181364_0.png treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181366_0.png treat image : temp/1763511029_350095_1395088644_bac656f808c0ac0443c9b8fc15374fcb_rle_crop_4038181373_0.png treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181352_0.png treat image : temp/1763511029_350095_1395089139_415f743b5822266d71b836894e2820ba_rle_crop_4038181354_0.png treat image : temp/1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d_rle_crop_4038181356_0.png treat image : temp/1763511029_350095_1395089096_2e8a34791843c70adeb7e63e1dee658d_rle_crop_4038181357_0.png treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181358_0.png treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181359_0.png treat image : temp/1763511029_350095_1395088960_bf01378abdabdec86b1fa9e59ec13974_rle_crop_4038181360_0.png treat image : temp/1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a_rle_crop_4038181361_0.png treat image : temp/1763511029_350095_1395088925_a6deb1b3a5e7f58360a9b6a99f26726a_rle_crop_4038181362_0.png treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181365_0.png treat image : temp/1763511029_350095_1395088892_ac05259ab1d1e2b24a052adc2f6b79ba_rle_crop_4038181363_0.png treat image : temp/1763511029_350095_1395088857_8225f558526abca8fe62261a13928c29_rle_crop_4038181367_0.png treat image : temp/1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69_rle_crop_4038181368_0.png treat image : temp/1763511029_350095_1395088823_2c8c7ffc1bef0bf4a96116da8e83ff69_rle_crop_4038181369_0.png treat image : temp/1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231_rle_crop_4038181371_0.png treat image : temp/1763511029_350095_1395088712_a9d0a1c7329242a691ea60c2d5da8231_rle_crop_4038181370_0.png treat image : temp/1763511029_350095_1395088677_0da490a252729b1b888105af74c60cdf_rle_crop_4038181372_0.png treat image : temp/1763511029_350095_1395088597_3d58b15f524f7e3d84a10422feaa8c9a_rle_crop_4038181374_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 : 37 time used for this insertion : 0.017796754837036133 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 37 time used for this insertion : 0.017517805099487305 save missing photos in datou_result : time spend for datou_step_exec : 3.715097188949585 time spend to save output : 0.04017353057861328 total time spend for step 7 : 3.7552707195281982 step8:velours_tree Wed Nov 19 01:12:06 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.21546053886413574 time spend to save output : 3.600120544433594e-05 total time spend for step 8 : 0.21549654006958008 step9:send_mail_cod Wed Nov 19 01:12:06 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_P28685558_19-11-2025_01_12_06.pdf 28685656 imagette286856561763511126 28685657 imagette286856571763511126 28685658 imagette286856581763511126 28685659 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 .imagette286856591763511126 28685660 imagette286856601763511128 28685661 imagette286856611763511128 28685662 imagette286856621763511128 28685663 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette286856631763511128 28685664 imagette286856641763511128 28685666 imagette286856661763511128 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=28685558 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/28685656,28685657,28685658,28685659,28685660,28685661,28685662,28685663,28685664,28685665,28685666?tags=pehd,flou,metal,pet_clair,carton,pet_fonce,background,papier,autre,environnement,mal_croppe args[1395089139] : ((1395089139, -2.1403528828003813, 492609224), (1395089139, 0.5878894592450055, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395089096] : ((1395089096, -0.5838424217813666, 492688767), (1395089096, 0.4924966675245154, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088960] : ((1395088960, -0.6679538033320642, 492688767), (1395088960, 0.32785016837448344, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088925] : ((1395088925, 1.150188769948386, 492688767), (1395088925, 0.2942454904209482, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088892] : ((1395088892, 1.5331494994174237, 492688767), (1395088892, 0.45877064201351464, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088857] : ((1395088857, -0.28022326194460295, 492688767), (1395088857, 0.4209860578274533, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088823] : ((1395088823, -0.5137808314437053, 492688767), (1395088823, -0.0376572984884121, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088787] : ((1395088787, -0.7579373338157319, 492688767), (1395088787, 0.5900264489449873, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088712] : ((1395088712, -0.7986192334401154, 492688767), (1395088712, 0.9105983298799597, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088677] : ((1395088677, -4.399153045422855, 492609224), (1395088677, 0.35957378536814694, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088644] : ((1395088644, -0.6520439494648553, 492688767), (1395088644, 0.4838891982825646, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088597] : ((1395088597, -1.2312240248998898, 492688767), (1395088597, 0.45101964984797827, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395088561] : ((1395088561, -4.27877857568233, 492609224), (1395088561, 0.48040130613969945, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com args[1395087805] : ((1395087805, -4.678987208320855, 492609224), (1395087805, 0.5659124633077286, 2107752395), '0.14069093088624338') We are sending mail with results at report@fotonower.com refus_total : 0.14069093088624338 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=28685558 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_P28685558_19-11-2025_01_12_06.pdf results_Auto_P28685558_19-11-2025_01_12_06.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28685558_19-11-2025_01_12_06.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','28685558','results_Auto_P28685558_19-11-2025_01_12_06.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28685558_19-11-2025_01_12_06.pdf','pdf','','0.53','0.14069093088624338') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/28685558

https://www.fotonower.com/image?json=false&list_photos_id=1395089139
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395089096
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088960
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088925
La photo est trop floue, merci de reprendre une photo.(avec le score = 1.150188769948386)
https://www.fotonower.com/image?json=false&list_photos_id=1395088892
La photo est trop floue, merci de reprendre une photo.(avec le score = 1.5331494994174237)
https://www.fotonower.com/image?json=false&list_photos_id=1395088857
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088823
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088787
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088712
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088677
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088644
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088597
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395088561
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1395087805
Bravo, la photo est bien prise.

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

exemples de contaminants: pet_clair: https://www.fotonower.com/view/28685659?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/28685663?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28685558_19-11-2025_01_12_06.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/28685656,28685657,28685658,28685659,28685660,28685661,28685662,28685663,28685664,28685665,28685666?tags=pehd,flou,metal,pet_clair,carton,pet_fonce,background,papier,autre,environnement,mal_croppe.


L'équipe Fotonower 202 b'' Date: Wed, 19 Nov 2025 00:12:11 GMT Content-Length: 0 Connection: close Server: nginx X-Message-Id: YK7DyzAeQjeGFDCHGv0uAg 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 [1395089139, 1395089096, 1395088960, 1395088925, 1395088892, 1395088857, 1395088823, 1395088787, 1395088712, 1395088677, 1395088644, 1395088597, 1395088561, 1395087805] 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, '4072127') ('3318', '28685558', '1395089139', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395089096', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088960', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088925', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088892', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088857', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088823', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088787', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088712', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088677', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088644', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088597', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088561', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395087805', None, None, None, None, None, '4072127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 14 time used for this insertion : 0.014635324478149414 save_final save missing photos in datou_result : time spend for datou_step_exec : 4.786494255065918 time spend to save output : 0.014822721481323242 total time spend for step 9 : 4.801316976547241 step10:split_time_score Wed Nov 19 01:12:11 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('20', 14),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 18112025 28685558 Nombre de photos uploadées : 14 / 23040 (0%) 18112025 28685558 Nombre de photos taguées (types de déchets): 0 / 14 (0%) 18112025 28685558 Nombre de photos taguées (volume) : 0 / 14 (0%) elapsed_time : load_data_split_time_score 1.6689300537109375e-06 elapsed_time : order_list_meta_photo_and_scores 5.245208740234375e-06 ?????????????? elapsed_time : fill_and_build_computed_from_old_data 0.0006668567657470703 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.22248482704162598 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.10302089006899057 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28650767_18-11-2025_09_31_58.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28650767 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`=28650767 AND mptpi.`type`=3594 To do Qualite : 0.19006823881172832 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28657578_18-11-2025_14_52_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28657578 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`=28657578 AND mptpi.`type`=3594 To do Qualite : 0.20229590647505133 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28657580_18-11-2025_13_33_03.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28657580 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`=28657580 AND mptpi.`type`=3594 To do Qualite : 0.07675022628798672 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28657587_18-11-2025_12_52_43.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28657587 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`=28657587 AND mptpi.`type`=3594 To do Qualite : 0.0032867270171957675 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28666729_18-11-2025_18_31_12.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28666729 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`=28666729 AND mptpi.`type`=3594 To do Qualite : 0.13427932098765435 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28666743_18-11-2025_17_11_42.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28666743 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`=28666743 AND mptpi.`type`=3594 To do Qualite : 0.09589124754489341 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28676890_18-11-2025_23_31_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28676890 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`=28676890 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28685556 order by id desc limit 1 Qualite : 0.14069093088624338 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28685558_19-11-2025_01_12_06.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28685558 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`=28685558 AND mptpi.`type`=3594 To do Qualite : 0.07281703317901234 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28677782_18-11-2025_21_42_02.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28677782 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`=28677782 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'18112025': {'nb_upload': 14, 'nb_taggue_class': 0, 'nb_taggue_densite': 0}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1395089139, 1395089096, 1395088960, 1395088925, 1395088892, 1395088857, 1395088823, 1395088787, 1395088712, 1395088677, 1395088644, 1395088597, 1395088561, 1395087805] Looping around the photos to save general results len do output : 1 /28685558Didn'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, '4072127') ('3318', '28685558', '1395089139', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395089096', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088960', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088925', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088892', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088857', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088823', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088787', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088712', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088677', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088644', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088597', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395088561', None, None, None, None, None, '4072127') ('3318', None, None, None, None, None, None, None, '4072127') ('3318', '28685558', '1395087805', None, None, None, None, None, '4072127') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.015468835830688477 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.107968807220459 time spend to save output : 0.015705347061157227 total time spend for step 10 : 2.123674154281616 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 14 set_done_treatment 53.03user 37.76system 1:47.85elapsed 84%CPU (0avgtext+0avgdata 2762372maxresident)k 561064inputs+39400outputs (618major+1628738minor)pagefaults 0swaps