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 : 3510564 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 : ['3886081'] with mtr_portfolio_ids : ['27600762'] and first list_photo_ids : [] new path : /proc/3510564/ 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 2 , BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 17 ; length of list_pids : 17 ; length of list_args : 17 time to download the photos : 2.6441943645477295 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 Oct 8 15: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 : 10128 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-10-08 15:10:36.615252: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-10-08 15:10:36.648587: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3492910000 Hz 2025-10-08 15:10:36.650971: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fb6b8000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-10-08 15:10:36.651020: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-10-08 15:10:36.657664: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-10-08 15:10:36.795850: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x11d13620 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-10-08 15:10:36.795910: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-10-08 15:10:36.797294: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-08 15:10:36.797720: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-08 15:10:36.800246: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-08 15:10:36.823866: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-08 15:10:36.824350: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-08 15:10:36.861712: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-08 15:10:36.867474: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-08 15:10:36.937840: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-08 15:10:36.939336: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-08 15:10:36.939807: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-08 15:10:36.940589: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-08 15:10:36.940606: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-08 15:10:36.940616: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-08 15:10:36.942280: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9378 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-10-08 15:10:37.471295: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-08 15:10:37.471401: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-08 15:10:37.471420: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-08 15:10:37.471436: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-08 15:10:37.471450: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-08 15:10:37.471465: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-08 15:10:37.471479: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-08 15:10:37.471498: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-08 15:10:37.473103: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-08 15:10:37.474582: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-08 15:10:37.474642: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-08 15:10:37.474661: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-08 15:10:37.474677: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-08 15:10:37.474694: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-08 15:10:37.474712: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-08 15:10:37.474735: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-08 15:10:37.474756: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-08 15:10:37.476056: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-08 15:10:37.476089: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-08 15:10:37.476098: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-08 15:10:37.476106: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-08 15:10:37.477535: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9378 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) Using TensorFlow backend. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:396: calling crop_and_resize_v1 (from tensorflow.python.ops.image_ops_impl) with box_ind is deprecated and will be removed in a future version. Instructions for updating: box_ind is deprecated, use box_indices instead WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:703: to_int32 (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:729: to_float (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. Inside mask_sub_process Inside mask_detect About to load cache.load_thcl_param To do loadFromThcl(), then load ParamDescType : thcl2847 thcls : [{'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}] thcl {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5275 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) {'thcl': {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'], 'list_hashtags_csv': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'svm_hashtag_type_desc': 5275, 'photo_desc_type': 5275, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'] Configurations: BACKBONE resnet101 BACKBONE_SHAPES [[160 160] [ 80 80] [ 40 40] [ 20 20] [ 10 10]] BACKBONE_STRIDES [4, 8, 16, 32, 64] BATCH_SIZE 1 BBOX_STD_DEV [0.1 0.1 0.2 0.2] DETECTION_MAX_INSTANCES 100 DETECTION_MIN_CONFIDENCE 0.3 DETECTION_NMS_THRESHOLD 0.3 GPU_COUNT 1 IMAGES_PER_GPU 1 IMAGE_MAX_DIM 640 IMAGE_MIN_DIM 640 IMAGE_PADDING True IMAGE_SHAPE [640 640 3] LEARNING_MOMENTUM 0.9 LEARNING_RATE 0.001 LOSS_WEIGHTS {'rpn_class_loss': 1.0, 'rpn_bbox_loss': 1.0, 'mrcnn_class_loss': 1.0, 'mrcnn_bbox_loss': 1.0, 'mrcnn_mask_loss': 1.0} MASK_POOL_SIZE 14 MASK_SHAPE [28, 28] MAX_GT_INSTANCES 100 MEAN_PIXEL [123.7 116.8 103.9] MINI_MASK_SHAPE (56, 56) NAME learn_RUBBIA_REFUS_AMIENS_23 NUM_CLASSES 9 POOL_SIZE 7 POST_NMS_ROIS_INFERENCE 1000 POST_NMS_ROIS_TRAINING 2000 ROI_POSITIVE_RATIO 0.33 RPN_ANCHOR_RATIOS [0.5, 1, 2] RPN_ANCHOR_SCALES (16, 32, 64, 128, 256) RPN_ANCHOR_STRIDE 1 RPN_BBOX_STD_DEV [0.1 0.1 0.2 0.2] RPN_NMS_THRESHOLD 0.7 RPN_TRAIN_ANCHORS_PER_IMAGE 256 STEPS_PER_EPOCH 1000 TRAIN_ROIS_PER_IMAGE 200 USE_MINI_MASK True USE_RPN_ROIS True VALIDATION_STEPS 50 WEIGHT_DECAY 0.0001 model_param file didn't exist model_name : learn_RUBBIA_REFUS_AMIENS_23 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-10-08 15:10:47.290624: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-08 15:10:47.605920: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 local folder : /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23 /data/models_weight/learn_RUBBIA_REFUS_AMIENS_23/mask_model.h5 size_local : 256009536 size in s3 : 256009536 create time local : 2021-08-09 09:43:22 create time in s3 : 2021-08-06 18:54:04 mask_model.h5 already exist and didn't need to update list_images length : 17 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 : 4 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 : 4 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 : 2 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 : 5 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 : 4 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 : 5 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 : 4 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 : 4 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 : 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 : 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 : 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 : 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 : 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 : 2 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 : 4 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 : 5 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 : 3 Detection mask done ! Trying to reset tf kernel 3511124 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 3646 tf kernel not reseted sub process len(results) : 17 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 17 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 : 8935 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.004736900329589844 nb_pixel_total : 142496 time to create 1 rle with old method : 0.15386366844177246 length of segment : 511 time for calcul the mask position with numpy : 0.0017476081848144531 nb_pixel_total : 128648 time to create 1 rle with old method : 0.13786673545837402 length of segment : 543 time for calcul the mask position with numpy : 0.002275705337524414 nb_pixel_total : 139003 time to create 1 rle with old method : 0.1490941047668457 length of segment : 527 time for calcul the mask position with numpy : 0.0006701946258544922 nb_pixel_total : 45198 time to create 1 rle with old method : 0.04937744140625 length of segment : 229 time for calcul the mask position with numpy : 0.001863241195678711 nb_pixel_total : 139310 time to create 1 rle with old method : 0.15659189224243164 length of segment : 519 time for calcul the mask position with numpy : 0.0032880306243896484 nb_pixel_total : 134360 time to create 1 rle with old method : 0.15197491645812988 length of segment : 664 time for calcul the mask position with numpy : 0.0002722740173339844 nb_pixel_total : 5607 time to create 1 rle with old method : 0.0069675445556640625 length of segment : 71 time for calcul the mask position with numpy : 0.002565145492553711 nb_pixel_total : 142720 time to create 1 rle with old method : 0.16268539428710938 length of segment : 514 time spent for convertir_results : 3.0422627925872803 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 8 chid ids of type : 3594 Number RLEs to save : 3578 save missing photos in datou_result : time spend for datou_step_exec : 36.11681127548218 time spend to save output : 0.6105444431304932 total time spend for step 1 : 36.72735571861267 step2:crop_condition Wed Oct 8 15:11:09 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 : 17 ! batch 1 Loaded 8 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 begin to crop the class : carton param for this class : {'min_score': 0.7} filtre for class : carton hashtag_id of this class : 492774966 we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 3736932 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759929070_3510564 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(1759929070), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4_rle_crop_3989267766_0.png', 0, 356, 521, 0, 1759929070,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 1 photos in the portfolio 3736932 time of upload the photos Elapsed time : 0.8742153644561768 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 2 About to insert : list_path_to_insert length 2 new photo from crops ! About to upload 2 photos upload in portfolio : 3736932 init cache_photo without model_param we have 2 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759929072_3510564 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(1759929072), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388187582_6c11bb726fa0805143ce7778717ac205_rle_crop_3989267764_0.png', 0, 319, 224, 0, 1759929072,'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(1759929072), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4_rle_crop_3989267767_0.png', 0, 113, 71, 0, 1759929072,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 2 photos in the portfolio 3736932 time of upload the photos Elapsed time : 0.9570767879486084 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 we have both polygon and rles Next one ! 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/1759929076_3510564 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(1759929077), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388188830_7e5f406968158b801a236169f313c6e2_rle_crop_3989267761_0.png', 0, 353, 511, 0, 1759929077,'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(1759929077), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388188537_49cf829130ac4d610d70a50d7d1332ab_rle_crop_3989267762_0.png', 0, 292, 541, 0, 1759929077,'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(1759929077), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388187663_8d2bc79b1e03749a58384c3d732deee4_rle_crop_3989267763_0.png', 0, 329, 527, 0, 1759929077,'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(1759929077), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388187492_fd91596501ad38cbe635e69db2a4deb6_rle_crop_3989267765_0.png', 0, 335, 519, 0, 1759929077,'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(1759929077), 0.0, 0.0, 14, '', 0, 0, '1759929029_3510564_1388184333_844699989c6d05140ff883c37f2f0ac1_rle_crop_3989267768_0.png', 0, 351, 514, 0, 1759929077,'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 : 1.795816421508789 we have finished the crop for the class : autre begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles 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 [1388188830, 1388188537, 1388187663, 1388187589, 1388187587, 1388187585, 1388187582, 1388187570, 1388187567, 1388187492, 1388187489, 1388187483, 1388187350, 1388185272, 1388184338, 1388184333, 1388184155] Looping around the photos to save general results len do output : 8 /1388227945Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388227947Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388227948Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388227995Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388227997Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388227999Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388228001Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388228003Didn'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, '3886081') ('3318', '27600762', '1388188830', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388188537', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187663', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187589', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187587', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187585', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187582', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187570', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187567', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187492', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187489', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187483', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187350', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388185272', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184338', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184333', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184155', None, None, None, None, None, '3886081') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 41 time used for this insertion : 0.03767561912536621 save_final save missing photos in datou_result : time spend for datou_step_exec : 8.938729763031006 time spend to save output : 0.03824615478515625 total time spend for step 2 : 8.976975917816162 step3:rle_unique_nms_with_priority Wed Oct 8 15:11:18 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 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 8 chid ids of type : 3594 ++++++++++nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.23415493965148926 time for calcul the mask position with numpy : 0.0798642635345459 nb_pixel_total : 1931104 time to create 1 rle with new method : 0.22971725463867188 time for calcul the mask position with numpy : 0.0077555179595947266 nb_pixel_total : 142496 time to create 1 rle with old method : 0.15868115425109863 create new chi : 0.48755335807800293 time to delete rle : 0.11969184875488281 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2102 TO DO : save crop sub photo not yet done ! save time : 0.40285301208496094 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.3867156505584717 time for calcul the mask position with numpy : 0.12707757949829102 nb_pixel_total : 1944952 time to create 1 rle with new method : 0.30564069747924805 time for calcul the mask position with numpy : 0.01243901252746582 nb_pixel_total : 128648 time to create 1 rle with old method : 0.14348292350769043 create new chi : 0.6005203723907471 time to delete rle : 0.00043845176696777344 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2166 TO DO : save crop sub photo not yet done ! save time : 0.4010608196258545 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.09572601318359375 time for calcul the mask position with numpy : 0.3826775550842285 nb_pixel_total : 1934597 time to create 1 rle with new method : 0.3186981678009033 time for calcul the mask position with numpy : 0.007251262664794922 nb_pixel_total : 139003 time to create 1 rle with old method : 0.1530468463897705 create new chi : 0.8720231056213379 time to delete rle : 0.0003502368927001953 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2134 TO DO : save crop sub photo not yet done ! save time : 0.40546655654907227 No data in photo_id : 1388187589 No data in photo_id : 1388187587 No data in photo_id : 1388187585 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.040152549743652344 time for calcul the mask position with numpy : 0.30966949462890625 nb_pixel_total : 2028402 time to create 1 rle with new method : 0.2040879726409912 time for calcul the mask position with numpy : 0.006484031677246094 nb_pixel_total : 45198 time to create 1 rle with old method : 0.049437522888183594 create new chi : 0.5807456970214844 time to delete rle : 0.00027108192443847656 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1538 TO DO : save crop sub photo not yet done ! save time : 0.3384873867034912 No data in photo_id : 1388187570 No data in photo_id : 1388187567 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.03912925720214844 time for calcul the mask position with numpy : 0.11808896064758301 nb_pixel_total : 1934290 time to create 1 rle with new method : 0.16985249519348145 time for calcul the mask position with numpy : 0.00799703598022461 nb_pixel_total : 139310 time to create 1 rle with old method : 0.15559864044189453 create new chi : 0.4633316993713379 time to delete rle : 0.00030231475830078125 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2118 TO DO : save crop sub photo not yet done ! save time : 0.3933596611022949 No data in photo_id : 1388187489 No data in photo_id : 1388187483 No data in photo_id : 1388187350 No data in photo_id : 1388185272 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.16942977905273438 time for calcul the mask position with numpy : 0.3200960159301758 nb_pixel_total : 1933633 time to create 1 rle with new method : 0.5086328983306885 time for calcul the mask position with numpy : 0.008463859558105469 nb_pixel_total : 5607 time to create 1 rle with old method : 0.007544279098510742 time for calcul the mask position with numpy : 0.0084228515625 nb_pixel_total : 134360 time to create 1 rle with old method : 0.15473270416259766 create new chi : 1.0329582691192627 time to delete rle : 0.00038051605224609375 batch 1 Loaded 5 chid ids of type : 3594 ++++Number RLEs to save : 2550 TO DO : save crop sub photo not yet done ! save time : 0.45731019973754883 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.059845685958862305 time for calcul the mask position with numpy : 0.05220770835876465 nb_pixel_total : 1930880 time to create 1 rle with new method : 0.4952394962310791 time for calcul the mask position with numpy : 0.007738351821899414 nb_pixel_total : 142720 time to create 1 rle with old method : 0.15780043601989746 create new chi : 0.7231960296630859 time to delete rle : 0.00034737586975097656 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2108 TO DO : save crop sub photo not yet done ! save time : 0.3968498706817627 No data in photo_id : 1388184155 map_output_result : {1388188830: (0.0, 'Should be the crop_list due to order', 0), 1388188537: (0.0, 'Should be the crop_list due to order', 0), 1388187663: (0.0, 'Should be the crop_list due to order', 0), 1388187589: (0.0, 'Should be the crop_list due to order', 0.0), 1388187587: (0.0, 'Should be the crop_list due to order', 0.0), 1388187585: (0.0, 'Should be the crop_list due to order', 0.0), 1388187582: (0.0, 'Should be the crop_list due to order', 0), 1388187570: (0.0, 'Should be the crop_list due to order', 0.0), 1388187567: (0.0, 'Should be the crop_list due to order', 0.0), 1388187492: (0.0, 'Should be the crop_list due to order', 0), 1388187489: (0.0, 'Should be the crop_list due to order', 0.0), 1388187483: (0.0, 'Should be the crop_list due to order', 0.0), 1388187350: (0.0, 'Should be the crop_list due to order', 0.0), 1388185272: (0.0, 'Should be the crop_list due to order', 0.0), 1388184338: (0.0, 'Should be the crop_list due to order', 0), 1388184333: (0.0, 'Should be the crop_list due to order', 0), 1388184155: (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 [1388188830, 1388188537, 1388187663, 1388187589, 1388187587, 1388187585, 1388187582, 1388187570, 1388187567, 1388187492, 1388187489, 1388187483, 1388187350, 1388185272, 1388184338, 1388184333, 1388184155] Looping around the photos to save general results len do output : 17 /1388188830.Didn't retrieve data . /1388188537.Didn't retrieve data . /1388187663.Didn't retrieve data . /1388187589.Didn't retrieve data . /1388187587.Didn't retrieve data . /1388187585.Didn't retrieve data . /1388187582.Didn't retrieve data . /1388187570.Didn't retrieve data . /1388187567.Didn't retrieve data . /1388187492.Didn't retrieve data . /1388187489.Didn't retrieve data . /1388187483.Didn't retrieve data . /1388187350.Didn't retrieve data . /1388185272.Didn't retrieve data . /1388184338.Didn't retrieve data . /1388184333.Didn't retrieve data . /1388184155.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, '3886081') ('3318', '27600762', '1388188830', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388188537', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187663', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187589', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187587', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187585', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187582', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187570', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187567', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187492', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187489', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187483', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187350', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388185272', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184338', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184333', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184155', None, None, None, None, None, '3886081') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 51 time used for this insertion : 0.03775429725646973 save_final save missing photos in datou_result : time spend for datou_step_exec : 9.153509140014648 time spend to save output : 0.038306474685668945 total time spend for step 3 : 9.191815614700317 step4:ventilate_hashtags_in_portfolio Wed Oct 8 15:11:27 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 : 27600762 get user id for portfolio 27600762 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`=27600762 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('papier','flou','environnement','pet_clair','metal','pehd','pet_fonce','background','mal_croppe','carton','autre')) AND mptpi.`min_score`=0.5 To do To do SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27600762 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('papier','flou','environnement','pet_clair','metal','pehd','pet_fonce','background','mal_croppe','carton','autre')) AND mptpi.`min_score`=0.5 To do Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") Catched exception ! Connect or reconnect ! (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\n and cspi.crop_hashtag_id = chi.id' at line 3") To do ! Use context local managing function ! SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27600762 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('papier','flou','environnement','pet_clair','metal','pehd','pet_fonce','background','mal_croppe','carton','autre')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/27601077,27601078,27601079,27601080,27601081,27601082,27601083,27601084,27601085,27601086,27601087?tags=papier,flou,environnement,pet_clair,metal,pehd,pet_fonce,background,mal_croppe,carton,autre Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1388188830, 1388188537, 1388187663, 1388187589, 1388187587, 1388187585, 1388187582, 1388187570, 1388187567, 1388187492, 1388187489, 1388187483, 1388187350, 1388185272, 1388184338, 1388184333, 1388184155] Looping around the photos to save general results len do output : 1 /27600762. 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, '3886081') ('3318', '27600762', '1388188830', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388188537', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187663', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187589', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187587', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187585', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187582', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187570', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187567', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187492', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187489', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187483', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187350', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388185272', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184338', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184333', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184155', None, None, None, None, None, '3886081') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 18 time used for this insertion : 0.037923574447631836 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.433317422866821 time spend to save output : 0.038315534591674805 total time spend for step 4 : 5.471632957458496 step5:final Wed Oct 8 15:11:32 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : {1388188830: ('0.02488828749092229',), 1388188537: ('0.02488828749092229',), 1388187663: ('0.02488828749092229',), 1388187589: ('0.02488828749092229',), 1388187587: ('0.02488828749092229',), 1388187585: ('0.02488828749092229',), 1388187582: ('0.02488828749092229',), 1388187570: ('0.02488828749092229',), 1388187567: ('0.02488828749092229',), 1388187492: ('0.02488828749092229',), 1388187489: ('0.02488828749092229',), 1388187483: ('0.02488828749092229',), 1388187350: ('0.02488828749092229',), 1388185272: ('0.02488828749092229',), 1388184338: ('0.02488828749092229',), 1388184333: ('0.02488828749092229',), 1388184155: ('0.02488828749092229',)} new output for save of step final : {1388188830: ('0.02488828749092229',), 1388188537: ('0.02488828749092229',), 1388187663: ('0.02488828749092229',), 1388187589: ('0.02488828749092229',), 1388187587: ('0.02488828749092229',), 1388187585: ('0.02488828749092229',), 1388187582: ('0.02488828749092229',), 1388187570: ('0.02488828749092229',), 1388187567: ('0.02488828749092229',), 1388187492: ('0.02488828749092229',), 1388187489: ('0.02488828749092229',), 1388187483: ('0.02488828749092229',), 1388187350: ('0.02488828749092229',), 1388185272: ('0.02488828749092229',), 1388184338: ('0.02488828749092229',), 1388184333: ('0.02488828749092229',), 1388184155: ('0.02488828749092229',)} [1388188830, 1388188537, 1388187663, 1388187589, 1388187587, 1388187585, 1388187582, 1388187570, 1388187567, 1388187492, 1388187489, 1388187483, 1388187350, 1388185272, 1388184338, 1388184333, 1388184155] Looping around the photos to save general results len do output : 17 /1388188830.Didn't retrieve data . /1388188537.Didn't retrieve data . /1388187663.Didn't retrieve data . /1388187589.Didn't retrieve data . /1388187587.Didn't retrieve data . /1388187585.Didn't retrieve data . /1388187582.Didn't retrieve data . /1388187570.Didn't retrieve data . /1388187567.Didn't retrieve data . /1388187492.Didn't retrieve data . /1388187489.Didn't retrieve data . /1388187483.Didn't retrieve data . /1388187350.Didn't retrieve data . /1388185272.Didn't retrieve data . /1388184338.Didn't retrieve data . /1388184333.Didn't retrieve data . /1388184155.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, '3886081') ('3318', '27600762', '1388188830', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388188537', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187663', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187589', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187587', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187585', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187582', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187570', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187567', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187492', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187489', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187483', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187350', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388185272', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184338', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184333', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184155', None, None, None, None, None, '3886081') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 51 time used for this insertion : 0.0389251708984375 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.38664889335632324 time spend to save output : 0.03974342346191406 total time spend for step 5 : 0.4263923168182373 step6:blur_detection Wed Oct 8 15:11:33 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/1759929029_3510564_1388188830_7e5f406968158b801a236169f313c6e2.jpg resize: (1080, 1920) 1388188830 -1.4749068690196665 treat image : temp/1759929029_3510564_1388188537_49cf829130ac4d610d70a50d7d1332ab.jpg resize: (1080, 1920) 1388188537 -1.1770751072158288 treat image : temp/1759929029_3510564_1388187663_8d2bc79b1e03749a58384c3d732deee4.jpg resize: (1080, 1920) 1388187663 -1.3258750672919217 treat image : temp/1759929029_3510564_1388187589_2c047f56ddcf773b8784e8335172ffc6.jpg resize: (1080, 1920) 1388187589 -1.3146101700277433 treat image : temp/1759929029_3510564_1388187587_c391cb618a4708374536e2843ba83908.jpg resize: (1080, 1920) 1388187587 -1.223833938005478 treat image : temp/1759929029_3510564_1388187585_95ea51438271007b527008c1aeb944cc.jpg resize: (1080, 1920) 1388187585 -0.7383150373240404 treat image : temp/1759929029_3510564_1388187582_6c11bb726fa0805143ce7778717ac205.jpg resize: (1080, 1920) 1388187582 -1.0865849626608353 treat image : temp/1759929029_3510564_1388187570_d36afdc84dcc5799ff096a05d988320d.jpg resize: (1080, 1920) 1388187570 -1.6230350508067966 treat image : temp/1759929029_3510564_1388187567_f6ec5620a3ab46d774cc2251a3aa4faa.jpg resize: (1080, 1920) 1388187567 -1.0171097264718405 treat image : temp/1759929029_3510564_1388187492_fd91596501ad38cbe635e69db2a4deb6.jpg resize: (1080, 1920) 1388187492 -1.3757509767894847 treat image : temp/1759929029_3510564_1388187489_0cc8781826e3ef679992a4daacfe06fe.jpg resize: (1080, 1920) 1388187489 -1.1306157137588984 treat image : temp/1759929029_3510564_1388187483_a631d114e1851b160962948a3b7f86ba.jpg resize: (1080, 1920) 1388187483 -1.2701104849973401 treat image : temp/1759929029_3510564_1388187350_c0f2213be6b8a952ffb170da5eecb569.jpg resize: (1080, 1920) 1388187350 -1.4606499696909094 treat image : temp/1759929029_3510564_1388185272_bc8ac50dacf8efa3f6d5eaeb4ea60301.jpg resize: (1080, 1920) 1388185272 -1.2812312797379481 treat image : temp/1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4.jpg resize: (1080, 1920) 1388184338 -1.3597986276217062 treat image : temp/1759929029_3510564_1388184333_844699989c6d05140ff883c37f2f0ac1.jpg resize: (1080, 1920) 1388184333 -1.2169505275837498 treat image : temp/1759929029_3510564_1388184155_8cfa648dfeb4966f1c44b9eb807863e6.jpg resize: (1080, 1920) 1388184155 -1.4007693431958685 treat image : temp/1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4_rle_crop_3989267766_0.png resize: (521, 356) 1388227945 -3.860205368918194 treat image : temp/1759929029_3510564_1388187582_6c11bb726fa0805143ce7778717ac205_rle_crop_3989267764_0.png resize: (224, 319) 1388227947 -0.09400331960454678 treat image : temp/1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4_rle_crop_3989267767_0.png resize: (71, 113) 1388227948 1.0652776629600191 treat image : temp/1759929029_3510564_1388188830_7e5f406968158b801a236169f313c6e2_rle_crop_3989267761_0.png resize: (511, 353) 1388227995 -3.5583556626761896 treat image : temp/1759929029_3510564_1388188537_49cf829130ac4d610d70a50d7d1332ab_rle_crop_3989267762_0.png resize: (541, 292) 1388227997 -3.4099799531251054 treat image : temp/1759929029_3510564_1388187663_8d2bc79b1e03749a58384c3d732deee4_rle_crop_3989267763_0.png resize: (527, 329) 1388227999 -3.3659582896478373 treat image : temp/1759929029_3510564_1388187492_fd91596501ad38cbe635e69db2a4deb6_rle_crop_3989267765_0.png resize: (519, 335) 1388228001 -3.445722414785778 treat image : temp/1759929029_3510564_1388184333_844699989c6d05140ff883c37f2f0ac1_rle_crop_3989267768_0.png resize: (514, 351) 1388228003 -3.5723418660250914 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 : 25 time used for this insertion : 0.037041664123535156 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 25 time used for this insertion : 0.03796243667602539 save missing photos in datou_result : time spend for datou_step_exec : 14.039994716644287 time spend to save output : 0.09299159049987793 total time spend for step 6 : 14.132986307144165 step7:brightness Wed Oct 8 15: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 inside step calcul brightness treat image : temp/1759929029_3510564_1388188830_7e5f406968158b801a236169f313c6e2.jpg treat image : temp/1759929029_3510564_1388188537_49cf829130ac4d610d70a50d7d1332ab.jpg treat image : temp/1759929029_3510564_1388187663_8d2bc79b1e03749a58384c3d732deee4.jpg treat image : temp/1759929029_3510564_1388187589_2c047f56ddcf773b8784e8335172ffc6.jpg treat image : temp/1759929029_3510564_1388187587_c391cb618a4708374536e2843ba83908.jpg treat image : temp/1759929029_3510564_1388187585_95ea51438271007b527008c1aeb944cc.jpg treat image : temp/1759929029_3510564_1388187582_6c11bb726fa0805143ce7778717ac205.jpg treat image : temp/1759929029_3510564_1388187570_d36afdc84dcc5799ff096a05d988320d.jpg treat image : temp/1759929029_3510564_1388187567_f6ec5620a3ab46d774cc2251a3aa4faa.jpg treat image : temp/1759929029_3510564_1388187492_fd91596501ad38cbe635e69db2a4deb6.jpg treat image : temp/1759929029_3510564_1388187489_0cc8781826e3ef679992a4daacfe06fe.jpg treat image : temp/1759929029_3510564_1388187483_a631d114e1851b160962948a3b7f86ba.jpg treat image : temp/1759929029_3510564_1388187350_c0f2213be6b8a952ffb170da5eecb569.jpg treat image : temp/1759929029_3510564_1388185272_bc8ac50dacf8efa3f6d5eaeb4ea60301.jpg treat image : temp/1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4.jpg treat image : temp/1759929029_3510564_1388184333_844699989c6d05140ff883c37f2f0ac1.jpg treat image : temp/1759929029_3510564_1388184155_8cfa648dfeb4966f1c44b9eb807863e6.jpg treat image : temp/1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4_rle_crop_3989267766_0.png treat image : temp/1759929029_3510564_1388187582_6c11bb726fa0805143ce7778717ac205_rle_crop_3989267764_0.png treat image : temp/1759929029_3510564_1388184338_48ab4bfa01ea9b3d555568dd88a4e4c4_rle_crop_3989267767_0.png treat image : temp/1759929029_3510564_1388188830_7e5f406968158b801a236169f313c6e2_rle_crop_3989267761_0.png treat image : temp/1759929029_3510564_1388188537_49cf829130ac4d610d70a50d7d1332ab_rle_crop_3989267762_0.png treat image : temp/1759929029_3510564_1388187663_8d2bc79b1e03749a58384c3d732deee4_rle_crop_3989267763_0.png treat image : temp/1759929029_3510564_1388187492_fd91596501ad38cbe635e69db2a4deb6_rle_crop_3989267765_0.png treat image : temp/1759929029_3510564_1388184333_844699989c6d05140ff883c37f2f0ac1_rle_crop_3989267768_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 : 25 time used for this insertion : 0.03719019889831543 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 25 time used for this insertion : 0.03763294219970703 save missing photos in datou_result : time spend for datou_step_exec : 3.9493956565856934 time spend to save output : 0.09289765357971191 total time spend for step 7 : 4.042293310165405 step8:velours_tree Wed Oct 8 15:11:51 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.21186518669128418 time spend to save output : 5.650520324707031e-05 total time spend for step 8 : 0.21192169189453125 step9:send_mail_cod Wed Oct 8 15:11:51 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_P27600762_08-10-2025_15_11_51.pdf 27601077 imagette276010771759929111 27601078 imagette276010781759929111 27601080 change filename to text .change filename to text .imagette276010801759929111 27601081 imagette276010811759929111 27601082 imagette276010821759929111 27601083 imagette276010831759929111 27601084 imagette276010841759929111 27601085 imagette276010851759929111 27601086 change filename to text .imagette276010861759929111 27601087 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette276010871759929111 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=27600762 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/27601077,27601078,27601079,27601080,27601081,27601082,27601083,27601084,27601085,27601086,27601087?tags=papier,flou,environnement,pet_clair,metal,pehd,pet_fonce,background,mal_croppe,carton,autre args[1388188830] : ((1388188830, -1.4749068690196665, 492688767), (1388188830, -0.8741826807534289, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388188537] : ((1388188537, -1.1770751072158288, 492688767), (1388188537, -1.1095328031987588, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187663] : ((1388187663, -1.3258750672919217, 492688767), (1388187663, -0.38314554470465056, 496442774), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187589] : ((1388187589, -1.3146101700277433, 492688767), (1388187589, -0.7453601615240429, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187587] : ((1388187587, -1.223833938005478, 492688767), (1388187587, -0.8364082799312493, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187585] : ((1388187585, -0.7383150373240404, 492688767), (1388187585, -0.3078642697079446, 496442774), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187582] : ((1388187582, -1.0865849626608353, 492688767), (1388187582, -0.6820153517572466, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187570] : ((1388187570, -1.6230350508067966, 492688767), (1388187570, -0.5824437508331414, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187567] : ((1388187567, -1.0171097264718405, 492688767), (1388187567, -0.983597974536277, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187492] : ((1388187492, -1.3757509767894847, 492688767), (1388187492, -0.9520138907268154, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187489] : ((1388187489, -1.1306157137588984, 492688767), (1388187489, -0.3651777976368069, 496442774), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187483] : ((1388187483, -1.2701104849973401, 492688767), (1388187483, -0.9388484145587813, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388187350] : ((1388187350, -1.4606499696909094, 492688767), (1388187350, -1.0574440572335235, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388185272] : ((1388185272, -1.2812312797379481, 492688767), (1388185272, -1.1341890684405351, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388184338] : ((1388184338, -1.3597986276217062, 492688767), (1388184338, -0.655396224642599, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388184333] : ((1388184333, -1.2169505275837498, 492688767), (1388184333, -1.049732331937444, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com args[1388184155] : ((1388184155, -1.4007693431958685, 492688767), (1388184155, -0.9800501230715165, 501862349), '0.02488828749092229') We are sending mail with results at report@fotonower.com refus_total : 0.02488828749092229 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=27600762 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_P27600762_08-10-2025_15_11_51.pdf results_Auto_P27600762_08-10-2025_15_11_51.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27600762_08-10-2025_15_11_51.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','27600762','results_Auto_P27600762_08-10-2025_15_11_51.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27600762_08-10-2025_15_11_51.pdf','pdf','','0.21','0.02488828749092229') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/27600762

https://www.fotonower.com/image?json=false&list_photos_id=1388188830
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388188537
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187663
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187589
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187587
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187585
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187582
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187570
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187567
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187492
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187489
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187483
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388187350
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388185272
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388184338
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388184333
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1388184155
Bravo, la photo est bien prise.

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

exemples de contaminants: pet_clair: https://www.fotonower.com/view/27601080?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/27601086?limit=200
exemples de contaminants: autre: https://www.fotonower.com/view/27601087?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27600762_08-10-2025_15_11_51.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/27601077,27601078,27601079,27601080,27601081,27601082,27601083,27601084,27601085,27601086,27601087?tags=papier,flou,environnement,pet_clair,metal,pehd,pet_fonce,background,mal_croppe,carton,autre.


L'équipe Fotonower 202 b'' Server: nginx Date: Wed, 08 Oct 2025 13:11:55 GMT Content-Length: 0 Connection: close X-Message-Id: ClQIKp7nTjaW9iTJ3RMO_A 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 [1388188830, 1388188537, 1388187663, 1388187589, 1388187587, 1388187585, 1388187582, 1388187570, 1388187567, 1388187492, 1388187489, 1388187483, 1388187350, 1388185272, 1388184338, 1388184333, 1388184155] 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, '3886081') ('3318', '27600762', '1388188830', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388188537', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187663', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187589', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187587', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187585', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187582', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187570', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187567', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187492', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187489', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187483', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187350', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388185272', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184338', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184333', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184155', None, None, None, None, None, '3886081') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 17 time used for this insertion : 0.038309574127197266 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.5306334495544434 time spend to save output : 0.03848624229431152 total time spend for step 9 : 3.569119691848755 step10:split_time_score Wed Oct 8 15:11:55 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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'}] (('12', 4), ('13', 13)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 08102025 27600762 Nombre de photos uploadées : 17 / 23040 (0%) 08102025 27600762 Nombre de photos taguées (types de déchets): 0 / 17 (0%) 08102025 27600762 Nombre de photos taguées (volume) : 0 / 17 (0%) elapsed_time : load_data_split_time_score 1.430511474609375e-06 elapsed_time : order_list_meta_photo_and_scores 4.5299530029296875e-06 ????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.0005195140838623047 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.649167537689209 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.20286307629243827 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592179_08-10-2025_13_21_48.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592179 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`=27592179 AND mptpi.`type`=3594 To do Qualite : 0.03041503906250001 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592183_08-10-2025_13_03_25.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592183 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`=27592183 AND mptpi.`type`=3594 To do Qualite : 0.253427533436214 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592186_08-10-2025_13_12_03.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592186 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`=27592186 AND mptpi.`type`=3594 To do Qualite : 0.09278805347815768 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592214_08-10-2025_12_42_11.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592214 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`=27592214 AND mptpi.`type`=3594 To do Qualite : 0.030465505751964085 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592223_08-10-2025_12_31_39.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592223 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`=27592223 AND mptpi.`type`=3594 To do Qualite : 0.13276063924501427 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592225_08-10-2025_12_22_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592225 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`=27592225 AND mptpi.`type`=3594 To do Qualite : 0.07691526813271601 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27592231_08-10-2025_12_13_23.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27592231 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`=27592231 AND mptpi.`type`=3594 To do Qualite : 0.02488828749092229 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27600762_08-10-2025_15_11_51.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27600762 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`=27600762 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'08102025': {'nb_upload': 17, '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 [1388188830, 1388188537, 1388187663, 1388187589, 1388187587, 1388187585, 1388187582, 1388187570, 1388187567, 1388187492, 1388187489, 1388187483, 1388187350, 1388185272, 1388184338, 1388184333, 1388184155] Looping around the photos to save general results len do output : 1 /27600762Didn'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, '3886081') ('3318', '27600762', '1388188830', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388188537', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187663', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187589', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187587', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187585', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187582', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187570', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187567', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187492', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187489', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187483', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388187350', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388185272', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184338', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184333', None, None, None, None, None, '3886081') ('3318', None, None, None, None, None, None, None, '3886081') ('3318', '27600762', '1388184155', None, None, None, None, None, '3886081') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 18 time used for this insertion : 0.03708624839782715 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.935105800628662 time spend to save output : 0.03744864463806152 total time spend for step 10 : 2.9725544452667236 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 17 set_done_treatment 45.19user 27.58system 1:33.15elapsed 78%CPU (0avgtext+0avgdata 2836696maxresident)k 2232208inputs+25048outputs (13013major+1510252minor)pagefaults 0swaps