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 : 1169602 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 : ['3460109'] with mtr_portfolio_ids : ['25727196'] and first list_photo_ids : [] new path : /proc/1169602/ Inside batchDatouExec : verbose : 0 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! List Step Type Loaded in datou : mask_detect, crop_condition, rle_unique_nms_with_priority, ventilate_hashtags_in_portfolio, final, blur_detection, brightness, velours_tree, send_mail_cod, split_time_score over limit max, limiting to limit_max 40 list_input_json : [] origin We have 1 , BFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 11 ; length of list_pids : 11 ; length of list_args : 11 time to download the photos : 1.388967752456665 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 Aug 6 14:00:30 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 10957 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-08-06 14:00:32.559979: 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-08-06 14:00:32.583416: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493035000 Hz 2025-08-06 14:00:32.585308: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f6ae8000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-08-06 14:00:32.585356: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-08-06 14:00:32.588969: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-08-06 14:00:32.731295: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7e48e80 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-08-06 14:00:32.731340: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-08-06 14:00:32.732695: 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-08-06 14:00:32.733067: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-08-06 14:00:32.735962: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-08-06 14:00:32.738503: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-08-06 14:00:32.738959: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-08-06 14:00:32.741541: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-08-06 14:00:32.742452: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-08-06 14:00:32.746165: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-08-06 14:00:32.747729: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-08-06 14:00:32.747784: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-08-06 14:00:32.748507: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-08-06 14:00:32.748521: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-08-06 14:00:32.748529: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-08-06 14:00:32.749853: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 10154 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-08-06 14:00:32.991336: 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-08-06 14:00:32.991423: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-08-06 14:00:32.991452: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-08-06 14:00:32.991477: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-08-06 14:00:32.991502: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-08-06 14:00:32.991526: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-08-06 14:00:32.991551: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-08-06 14:00:32.991576: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-08-06 14:00:32.993096: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-08-06 14:00:32.994123: 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-08-06 14:00:32.994150: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-08-06 14:00:32.994164: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-08-06 14:00:32.994177: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-08-06 14:00:32.994190: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-08-06 14:00:32.994204: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-08-06 14:00:32.994217: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-08-06 14:00:32.994230: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-08-06 14:00:32.995431: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-08-06 14:00:32.995457: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-08-06 14:00:32.995465: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-08-06 14:00:32.995472: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-08-06 14:00:32.996714: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 10154 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-08-06 14:00:40.697139: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-08-06 14:00:40.883002: 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 : 11 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 29.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 11 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 31.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 17.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 29.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 2 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 24.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 27.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 24.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 22.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: 29.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 34.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: 26.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 Detection mask done ! Trying to reset tf kernel 1170227 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 4866 tf kernel not reseted sub process len(results) : 11 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 11 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 : 9761 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.00025582313537597656 nb_pixel_total : 10134 time to create 1 rle with old method : 0.011847972869873047 length of segment : 73 time for calcul the mask position with numpy : 0.0017957687377929688 nb_pixel_total : 109830 time to create 1 rle with old method : 0.11995887756347656 length of segment : 500 time for calcul the mask position with numpy : 0.0001480579376220703 nb_pixel_total : 7785 time to create 1 rle with old method : 0.009045600891113281 length of segment : 82 time for calcul the mask position with numpy : 0.0003745555877685547 nb_pixel_total : 14718 time to create 1 rle with old method : 0.016725778579711914 length of segment : 206 time for calcul the mask position with numpy : 0.00012040138244628906 nb_pixel_total : 6173 time to create 1 rle with old method : 0.007205963134765625 length of segment : 82 time for calcul the mask position with numpy : 0.0002925395965576172 nb_pixel_total : 13610 time to create 1 rle with old method : 0.01567840576171875 length of segment : 200 time for calcul the mask position with numpy : 0.0002334117889404297 nb_pixel_total : 15612 time to create 1 rle with old method : 0.017570018768310547 length of segment : 138 time for calcul the mask position with numpy : 0.00013637542724609375 nb_pixel_total : 7226 time to create 1 rle with old method : 0.008488893508911133 length of segment : 70 time for calcul the mask position with numpy : 0.00014257431030273438 nb_pixel_total : 8557 time to create 1 rle with old method : 0.009521961212158203 length of segment : 163 time for calcul the mask position with numpy : 7.009506225585938e-05 nb_pixel_total : 2547 time to create 1 rle with old method : 0.003100872039794922 length of segment : 40 time for calcul the mask position with numpy : 0.00013184547424316406 nb_pixel_total : 7937 time to create 1 rle with old method : 0.009303569793701172 length of segment : 79 time for calcul the mask position with numpy : 0.0017006397247314453 nb_pixel_total : 118967 time to create 1 rle with old method : 0.13221001625061035 length of segment : 524 time for calcul the mask position with numpy : 0.027103662490844727 nb_pixel_total : 714125 time to create 1 rle with new method : 0.6343090534210205 length of segment : 956 time for calcul the mask position with numpy : 0.0020902156829833984 nb_pixel_total : 112904 time to create 1 rle with old method : 0.12705326080322266 length of segment : 515 time for calcul the mask position with numpy : 0.0003883838653564453 nb_pixel_total : 12647 time to create 1 rle with old method : 0.016063690185546875 length of segment : 118 time for calcul the mask position with numpy : 0.00024318695068359375 nb_pixel_total : 6931 time to create 1 rle with old method : 0.008427619934082031 length of segment : 91 time for calcul the mask position with numpy : 0.0004928112030029297 nb_pixel_total : 18177 time to create 1 rle with old method : 0.021397113800048828 length of segment : 127 time for calcul the mask position with numpy : 0.00020313262939453125 nb_pixel_total : 10843 time to create 1 rle with old method : 0.013266324996948242 length of segment : 140 time for calcul the mask position with numpy : 0.01960611343383789 nb_pixel_total : 827160 time to create 1 rle with new method : 0.14501667022705078 length of segment : 1217 time for calcul the mask position with numpy : 0.00030159950256347656 nb_pixel_total : 5812 time to create 1 rle with old method : 0.006851911544799805 length of segment : 155 time for calcul the mask position with numpy : 0.011701107025146484 nb_pixel_total : 763362 time to create 1 rle with new method : 0.0694882869720459 length of segment : 1005 time for calcul the mask position with numpy : 0.00029349327087402344 nb_pixel_total : 9222 time to create 1 rle with old method : 0.010788202285766602 length of segment : 137 time for calcul the mask position with numpy : 0.00012063980102539062 nb_pixel_total : 3692 time to create 1 rle with old method : 0.004453182220458984 length of segment : 90 time for calcul the mask position with numpy : 0.0007395744323730469 nb_pixel_total : 52978 time to create 1 rle with old method : 0.06589126586914062 length of segment : 310 time for calcul the mask position with numpy : 0.0003292560577392578 nb_pixel_total : 22985 time to create 1 rle with old method : 0.026363849639892578 length of segment : 181 time for calcul the mask position with numpy : 0.0013163089752197266 nb_pixel_total : 96633 time to create 1 rle with old method : 0.11261463165283203 length of segment : 482 time spent for convertir_results : 2.9915835857391357 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 26 chid ids of type : 3594 Number RLEs to save : 7681 save missing photos in datou_result : time spend for datou_step_exec : 27.5931556224823 time spend to save output : 0.6038615703582764 total time spend for step 1 : 28.197017192840576 step2:crop_condition Wed Aug 6 14:00:58 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 : 11 ! batch 1 Loaded 26 chid ids of type : 3594 +++++++++++++++++++++++++++ begin to crop the class : papier param for this class : {'min_score': 0.7} filtre for class : papier hashtag_id of this class : 492668766 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 5 About to insert : list_path_to_insert length 5 new photo from crops ! About to upload 5 photos upload in portfolio : 3736932 init cache_photo without model_param we have 5 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1754481659_1169602 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 5 photos in the portfolio 3736932 time of upload the photos Elapsed time : 3.228454351425171 we have finished the crop for the class : papier begin to crop the class : carton param for this class : {'min_score': 0.7} filtre for class : carton hashtag_id of this class : 492774966 begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 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/1754481662_1169602 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.6695678234100342 we have finished the crop for the class : metal begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 20 About to insert : list_path_to_insert length 20 new photo from crops ! About to upload 20 photos upload in portfolio : 3736932 init cache_photo without model_param we have 20 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1754481676_1169602 batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 20 photos in the portfolio 3736932 time of upload the photos Elapsed time : 6.016906499862671 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1375450865, 1375450862, 1375450860, 1375450838, 1375450834, 1375450831, 1375450828, 1375450825, 1375450824, 1375450785, 1375450782] Looping around the photos to save general results len do output : 26 /1375480652Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480653Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480654Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480656Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480657Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480668Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480778Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480780Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480781Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480782Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480783Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480785Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480786Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480787Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480789Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480790Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480791Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480793Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480794Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480795Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480797Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480798Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480799Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480800Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480802Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1375480803Didn'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, '3460109') ('3318', '25727196', '1375450865', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450862', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450860', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450838', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450834', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450831', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450828', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450825', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450824', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450785', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450782', None, None, None, None, None, '3460109') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 89 time used for this insertion : 0.0208280086517334 save_final save missing photos in datou_result : time spend for datou_step_exec : 23.283085107803345 time spend to save output : 0.021735668182373047 total time spend for step 2 : 23.304820775985718 step3:rle_unique_nms_with_priority Wed Aug 6 14:01:21 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 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 26 chid ids of type : 3594 +++++++++++++++++++++++++++nb_obj : 8 nb_hashtags : 2 time to prepare the origin masks : 0.7400641441345215 time for calcul the mask position with numpy : 0.19374537467956543 nb_pixel_total : 1901971 time to create 1 rle with new method : 0.11578583717346191 time for calcul the mask position with numpy : 0.006484508514404297 nb_pixel_total : 7226 time to create 1 rle with old method : 0.00884246826171875 time for calcul the mask position with numpy : 0.0063495635986328125 nb_pixel_total : 15612 time to create 1 rle with old method : 0.01979231834411621 time for calcul the mask position with numpy : 0.006269931793212891 nb_pixel_total : 151 time to create 1 rle with old method : 0.0003218650817871094 time for calcul the mask position with numpy : 0.0063533782958984375 nb_pixel_total : 6173 time to create 1 rle with old method : 0.007830619812011719 time for calcul the mask position with numpy : 0.005998373031616211 nb_pixel_total : 14718 time to create 1 rle with old method : 0.016405820846557617 time for calcul the mask position with numpy : 0.006194114685058594 nb_pixel_total : 7785 time to create 1 rle with old method : 0.009574413299560547 time for calcul the mask position with numpy : 0.006746530532836914 nb_pixel_total : 109830 time to create 1 rle with old method : 0.11855435371398926 time for calcul the mask position with numpy : 0.006201505661010742 nb_pixel_total : 10134 time to create 1 rle with old method : 0.01116323471069336 create new chi : 0.563438892364502 time to delete rle : 0.030846118927001953 batch 1 Loaded 17 chid ids of type : 3594 ++++++++Number RLEs to save : 3460 TO DO : save crop sub photo not yet done ! save time : 0.24859261512756348 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.3137073516845703 time for calcul the mask position with numpy : 0.04848909378051758 nb_pixel_total : 2062496 time to create 1 rle with new method : 0.02808690071105957 time for calcul the mask position with numpy : 0.006087303161621094 nb_pixel_total : 2547 time to create 1 rle with old method : 0.002832174301147461 time for calcul the mask position with numpy : 0.0056610107421875 nb_pixel_total : 8557 time to create 1 rle with old method : 0.009268045425415039 create new chi : 0.10067868232727051 time to delete rle : 0.00022172927856445312 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1486 TO DO : save crop sub photo not yet done ! save time : 0.1279006004333496 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.047554969787597656 time for calcul the mask position with numpy : 0.2004077434539795 nb_pixel_total : 1946696 time to create 1 rle with new method : 0.09385371208190918 time for calcul the mask position with numpy : 0.0066564083099365234 nb_pixel_total : 118967 time to create 1 rle with old method : 0.12585091590881348 time for calcul the mask position with numpy : 0.0058977603912353516 nb_pixel_total : 7937 time to create 1 rle with old method : 0.008350372314453125 create new chi : 0.4514167308807373 time to delete rle : 0.00033593177795410156 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 2286 TO DO : save crop sub photo not yet done ! save time : 0.17899537086486816 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.0482480525970459 time for calcul the mask position with numpy : 0.01794266700744629 nb_pixel_total : 1359475 time to create 1 rle with new method : 0.18057918548583984 time for calcul the mask position with numpy : 0.011749982833862305 nb_pixel_total : 714125 time to create 1 rle with new method : 0.06304216384887695 create new chi : 0.28125524520874023 time to delete rle : 0.00028014183044433594 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2992 TO DO : save crop sub photo not yet done ! save time : 0.22081923484802246 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.04502058029174805 time for calcul the mask position with numpy : 0.02720355987548828 nb_pixel_total : 1960696 time to create 1 rle with new method : 0.19482684135437012 time for calcul the mask position with numpy : 0.00911259651184082 nb_pixel_total : 112904 time to create 1 rle with old method : 0.1274559497833252 create new chi : 0.3692030906677246 time to delete rle : 0.00041794776916503906 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2110 TO DO : save crop sub photo not yet done ! save time : 0.17190337181091309 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.12489914894104004 time for calcul the mask position with numpy : 0.10697007179260254 nb_pixel_total : 2054022 time to create 1 rle with new method : 0.32772397994995117 time for calcul the mask position with numpy : 0.007451057434082031 nb_pixel_total : 6931 time to create 1 rle with old method : 0.007889747619628906 time for calcul the mask position with numpy : 0.0069887638092041016 nb_pixel_total : 12647 time to create 1 rle with old method : 0.014596939086914062 create new chi : 0.48438358306884766 time to delete rle : 0.00041604042053222656 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1498 TO DO : save crop sub photo not yet done ! save time : 0.13561654090881348 nb_obj : 3 nb_hashtags : 1 time to prepare the origin masks : 0.06277894973754883 time for calcul the mask position with numpy : 0.05140972137451172 nb_pixel_total : 1231522 time to create 1 rle with new method : 0.1532142162322998 time for calcul the mask position with numpy : 0.011779308319091797 nb_pixel_total : 813058 time to create 1 rle with new method : 0.09627676010131836 time for calcul the mask position with numpy : 0.0062444210052490234 nb_pixel_total : 10843 time to create 1 rle with old method : 0.011836528778076172 time for calcul the mask position with numpy : 0.006119966506958008 nb_pixel_total : 18177 time to create 1 rle with old method : 0.020028114318847656 create new chi : 0.3756072521209717 time to delete rle : 0.0005698204040527344 batch 1 Loaded 7 chid ids of type : 3594 ++++Number RLEs to save : 3944 TO DO : save crop sub photo not yet done ! save time : 0.25434422492980957 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.04095816612243652 time for calcul the mask position with numpy : 0.2534818649291992 nb_pixel_total : 1304426 time to create 1 rle with new method : 0.09590959548950195 time for calcul the mask position with numpy : 0.012031316757202148 nb_pixel_total : 763362 time to create 1 rle with new method : 0.20872902870178223 time for calcul the mask position with numpy : 0.006231784820556641 nb_pixel_total : 5812 time to create 1 rle with old method : 0.006496429443359375 create new chi : 0.5992245674133301 time to delete rle : 0.0004639625549316406 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 3400 TO DO : save crop sub photo not yet done ! save time : 0.24295353889465332 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.04214644432067871 time for calcul the mask position with numpy : 0.08358240127563477 nb_pixel_total : 2060686 time to create 1 rle with new method : 0.2695438861846924 time for calcul the mask position with numpy : 0.0059146881103515625 nb_pixel_total : 3692 time to create 1 rle with old method : 0.003920078277587891 time for calcul the mask position with numpy : 0.005726337432861328 nb_pixel_total : 9222 time to create 1 rle with old method : 0.009766817092895508 create new chi : 0.3886606693267822 time to delete rle : 0.0002455711364746094 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1534 TO DO : save crop sub photo not yet done ! save time : 0.144669771194458 No data in photo_id : 1375450785 nb_obj : 3 nb_hashtags : 1 time to prepare the origin masks : 0.06608200073242188 time for calcul the mask position with numpy : 0.14519238471984863 nb_pixel_total : 1901004 time to create 1 rle with new method : 0.10167980194091797 time for calcul the mask position with numpy : 0.007460117340087891 nb_pixel_total : 96633 time to create 1 rle with old method : 0.1036064624786377 time for calcul the mask position with numpy : 0.006390571594238281 nb_pixel_total : 22985 time to create 1 rle with old method : 0.02532482147216797 time for calcul the mask position with numpy : 0.006331682205200195 nb_pixel_total : 52978 time to create 1 rle with old method : 0.05709528923034668 create new chi : 0.46373748779296875 time to delete rle : 0.00044035911560058594 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 3026 TO DO : save crop sub photo not yet done ! save time : 0.2251296043395996 map_output_result : {1375450865: (0.0, 'Should be the crop_list due to order', 0), 1375450862: (0.0, 'Should be the crop_list due to order', 0), 1375450860: (0.0, 'Should be the crop_list due to order', 0), 1375450838: (0.0, 'Should be the crop_list due to order', 0), 1375450834: (0.0, 'Should be the crop_list due to order', 0), 1375450831: (0.0, 'Should be the crop_list due to order', 0), 1375450828: (0.0, 'Should be the crop_list due to order', 0), 1375450825: (0.0, 'Should be the crop_list due to order', 0), 1375450824: (0.0, 'Should be the crop_list due to order', 0), 1375450785: (0.0, 'Should be the crop_list due to order', 0.0), 1375450782: (0.0, 'Should be the crop_list due to order', 0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1375450865, 1375450862, 1375450860, 1375450838, 1375450834, 1375450831, 1375450828, 1375450825, 1375450824, 1375450785, 1375450782] Looping around the photos to save general results len do output : 11 /1375450865.Didn't retrieve data . /1375450862.Didn't retrieve data . /1375450860.Didn't retrieve data . /1375450838.Didn't retrieve data . /1375450834.Didn't retrieve data . /1375450831.Didn't retrieve data . /1375450828.Didn't retrieve data . /1375450825.Didn't retrieve data . /1375450824.Didn't retrieve data . /1375450785.Didn't retrieve data . /1375450782.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, '3460109') ('3318', '25727196', '1375450865', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450862', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450860', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450838', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450834', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450831', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450828', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450825', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450824', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450785', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450782', None, None, None, None, None, '3460109') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 33 time used for this insertion : 0.014251708984375 save_final save missing photos in datou_result : time spend for datou_step_exec : 7.956461668014526 time spend to save output : 0.01473379135131836 total time spend for step 3 : 7.971195459365845 step4:ventilate_hashtags_in_portfolio Wed Aug 6 14:01:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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 : 25727196 get user id for portfolio 25727196 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`=25727196 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('papier','pehd','metal','pet_fonce','flou','environnement','background','autre','carton','mal_croppe','pet_clair')) 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`=25727196 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('papier','pehd','metal','pet_fonce','flou','environnement','background','autre','carton','mal_croppe','pet_clair')) 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`=25727196 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('papier','pehd','metal','pet_fonce','flou','environnement','background','autre','carton','mal_croppe','pet_clair')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/25728537,25728538,25728539,25728540,25728541,25728542,25728543,25728544,25728545,25728546,25728547?tags=papier,pehd,metal,pet_fonce,flou,environnement,background,autre,carton,mal_croppe,pet_clair Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1375450865, 1375450862, 1375450860, 1375450838, 1375450834, 1375450831, 1375450828, 1375450825, 1375450824, 1375450785, 1375450782] Looping around the photos to save general results len do output : 1 /25727196. 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, '3460109') ('3318', '25727196', '1375450865', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450862', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450860', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450838', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450834', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450831', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450828', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450825', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450824', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450785', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450782', None, None, None, None, None, '3460109') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 12 time used for this insertion : 0.015389204025268555 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6037421226501465 time spend to save output : 0.015786409378051758 total time spend for step 4 : 1.6195285320281982 step5:final Wed Aug 6 14:01:31 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 : {1375450865: ('0.12946329615600452',), 1375450862: ('0.12946329615600452',), 1375450860: ('0.12946329615600452',), 1375450838: ('0.12946329615600452',), 1375450834: ('0.12946329615600452',), 1375450831: ('0.12946329615600452',), 1375450828: ('0.12946329615600452',), 1375450825: ('0.12946329615600452',), 1375450824: ('0.12946329615600452',), 1375450785: ('0.12946329615600452',), 1375450782: ('0.12946329615600452',)} new output for save of step final : {1375450865: ('0.12946329615600452',), 1375450862: ('0.12946329615600452',), 1375450860: ('0.12946329615600452',), 1375450838: ('0.12946329615600452',), 1375450834: ('0.12946329615600452',), 1375450831: ('0.12946329615600452',), 1375450828: ('0.12946329615600452',), 1375450825: ('0.12946329615600452',), 1375450824: ('0.12946329615600452',), 1375450785: ('0.12946329615600452',), 1375450782: ('0.12946329615600452',)} [1375450865, 1375450862, 1375450860, 1375450838, 1375450834, 1375450831, 1375450828, 1375450825, 1375450824, 1375450785, 1375450782] Looping around the photos to save general results len do output : 11 /1375450865.Didn't retrieve data . /1375450862.Didn't retrieve data . /1375450860.Didn't retrieve data . /1375450838.Didn't retrieve data . /1375450834.Didn't retrieve data . /1375450831.Didn't retrieve data . /1375450828.Didn't retrieve data . /1375450825.Didn't retrieve data . /1375450824.Didn't retrieve data . /1375450785.Didn't retrieve data . /1375450782.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, '3460109') ('3318', '25727196', '1375450865', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450862', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450860', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450838', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450834', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450831', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450828', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450825', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450824', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450785', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450782', None, None, None, None, None, '3460109') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 33 time used for this insertion : 0.015348434448242188 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.11451554298400879 time spend to save output : 0.01587057113647461 total time spend for step 5 : 0.1303861141204834 step6:blur_detection Wed Aug 6 14:01:31 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/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a.jpg resize: (1080, 1920) 1375450865 -0.5836451752096797 treat image : temp/1754481628_1169602_1375450862_dc37c30a3faeb299ea4677b0280013c1.jpg resize: (1080, 1920) 1375450862 -2.751800901509457 treat image : temp/1754481628_1169602_1375450860_490f2b7430e0792f91667e78d2299446.jpg resize: (1080, 1920) 1375450860 -4.761852547722806 treat image : temp/1754481628_1169602_1375450838_fbc1d41e8daa6a01c8d137bcaf478141.jpg resize: (1080, 1920) 1375450838 -0.5227254297712718 treat image : temp/1754481628_1169602_1375450834_110e8fe49644896aa5d566b6f8a0722f.jpg resize: (1080, 1920) 1375450834 -2.1055622009895765 treat image : temp/1754481628_1169602_1375450831_3cb741c31cf1b75e812f532708c6e60a.jpg resize: (1080, 1920) 1375450831 -2.516990728479095 treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397.jpg resize: (1080, 1920) 1375450828 -1.5947245625109494 treat image : temp/1754481628_1169602_1375450825_e12d35021b4560169b6b1315cc7981eb.jpg resize: (1080, 1920) 1375450825 -2.2951361005254722 treat image : temp/1754481628_1169602_1375450824_b944b2f9e85eb2a6bec52a172b3f96c2.jpg resize: (1080, 1920) 1375450824 -3.363316254982822 treat image : temp/1754481628_1169602_1375450785_387d66005edf2fad67e83d124ce4cb25.jpg resize: (1080, 1920) 1375450785 -3.2615794314226325 treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e.jpg resize: (1080, 1920) 1375450782 0.014553701700155927 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810089_0.png resize: (200, 179) 1375480652 -2.232797735954688 treat image : temp/1754481628_1169602_1375450860_490f2b7430e0792f91667e78d2299446_rle_crop_3904810094_0.png resize: (77, 137) 1375480653 -4.684626480139558 treat image : temp/1754481628_1169602_1375450831_3cb741c31cf1b75e812f532708c6e60a_rle_crop_3904810099_0.png resize: (90, 138) 1375480654 -1.892711022277864 treat image : temp/1754481628_1169602_1375450825_e12d35021b4560169b6b1315cc7981eb_rle_crop_3904810103_0.png resize: (155, 90) 1375480656 -2.331413270862966 treat image : temp/1754481628_1169602_1375450824_b944b2f9e85eb2a6bec52a172b3f96c2_rle_crop_3904810106_0.png resize: (90, 74) 1375480657 -1.9656586330136854 treat image : temp/1754481628_1169602_1375450862_dc37c30a3faeb299ea4677b0280013c1_rle_crop_3904810093_0.png resize: (40, 86) 1375480668 -3.9117070614577663 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810087_0.png resize: (206, 178) 1375480778 -2.2761662738115724 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810091_0.png resize: (70, 137) 1375480780 -4.248174291016937 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810084_0.png resize: (72, 183) 1375480781 -3.132047139416663 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810090_0.png resize: (138, 142) 1375480782 -2.872528184382387 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810088_0.png resize: (81, 112) 1375480783 -1.8694782740700966 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810086_0.png resize: (82, 132) 1375480785 -3.5668003889866235 treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810085_0.png resize: (493, 338) 1375480786 0.6744071948315296 treat image : temp/1754481628_1169602_1375450862_dc37c30a3faeb299ea4677b0280013c1_rle_crop_3904810092_0.png resize: (163, 64) 1375480787 -1.629500523417179 treat image : temp/1754481628_1169602_1375450860_490f2b7430e0792f91667e78d2299446_rle_crop_3904810095_0.png resize: (520, 362) 1375480789 0.0652756111586569 treat image : temp/1754481628_1169602_1375450838_fbc1d41e8daa6a01c8d137bcaf478141_rle_crop_3904810096_0.png resize: (950, 962) 1375480790 1.201111423288566 treat image : temp/1754481628_1169602_1375450834_110e8fe49644896aa5d566b6f8a0722f_rle_crop_3904810097_0.png resize: (506, 352) 1375480791 0.0965301122425291 treat image : temp/1754481628_1169602_1375450831_3cb741c31cf1b75e812f532708c6e60a_rle_crop_3904810098_0.png resize: (118, 132) 1375480793 -1.099975002068087 treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397_rle_crop_3904810102_0.png resize: (996, 1243) 1375480794 -0.7428836077762089 treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397_rle_crop_3904810101_0.png resize: (139, 95) 1375480795 -1.632031588507709 treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397_rle_crop_3904810100_0.png resize: (120, 212) 1375480797 -4.510291612191346 treat image : temp/1754481628_1169602_1375450825_e12d35021b4560169b6b1315cc7981eb_rle_crop_3904810104_0.png resize: (1002, 1096) 1375480798 0.5085697599040127 treat image : temp/1754481628_1169602_1375450824_b944b2f9e85eb2a6bec52a172b3f96c2_rle_crop_3904810105_0.png resize: (137, 136) 1375480799 -2.9688842388698973 treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e_rle_crop_3904810108_0.png resize: (174, 194) 1375480800 -2.504984561730208 treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e_rle_crop_3904810107_0.png resize: (310, 260) 1375480802 -1.2879713744984294 treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e_rle_crop_3904810109_0.png resize: (475, 346) 1375480803 -0.278255740174052 Inside saveOutput : final : False verbose : 0 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 37 time used for this insertion : 0.015883445739746094 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 37 time used for this insertion : 0.016322612762451172 save missing photos in datou_result : time spend for datou_step_exec : 10.363479852676392 time spend to save output : 0.037447452545166016 total time spend for step 6 : 10.400927305221558 step7:brightness Wed Aug 6 14:01:41 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step calcul brightness treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a.jpg treat image : temp/1754481628_1169602_1375450862_dc37c30a3faeb299ea4677b0280013c1.jpg treat image : temp/1754481628_1169602_1375450860_490f2b7430e0792f91667e78d2299446.jpg treat image : temp/1754481628_1169602_1375450838_fbc1d41e8daa6a01c8d137bcaf478141.jpg treat image : temp/1754481628_1169602_1375450834_110e8fe49644896aa5d566b6f8a0722f.jpg treat image : temp/1754481628_1169602_1375450831_3cb741c31cf1b75e812f532708c6e60a.jpg treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397.jpg treat image : temp/1754481628_1169602_1375450825_e12d35021b4560169b6b1315cc7981eb.jpg treat image : temp/1754481628_1169602_1375450824_b944b2f9e85eb2a6bec52a172b3f96c2.jpg treat image : temp/1754481628_1169602_1375450785_387d66005edf2fad67e83d124ce4cb25.jpg treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e.jpg treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810089_0.png treat image : temp/1754481628_1169602_1375450860_490f2b7430e0792f91667e78d2299446_rle_crop_3904810094_0.png treat image : temp/1754481628_1169602_1375450831_3cb741c31cf1b75e812f532708c6e60a_rle_crop_3904810099_0.png treat image : temp/1754481628_1169602_1375450825_e12d35021b4560169b6b1315cc7981eb_rle_crop_3904810103_0.png treat image : temp/1754481628_1169602_1375450824_b944b2f9e85eb2a6bec52a172b3f96c2_rle_crop_3904810106_0.png treat image : temp/1754481628_1169602_1375450862_dc37c30a3faeb299ea4677b0280013c1_rle_crop_3904810093_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810087_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810091_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810084_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810090_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810088_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810086_0.png treat image : temp/1754481628_1169602_1375450865_dc2b515b9cebfaf0e373afdf55cec46a_rle_crop_3904810085_0.png treat image : temp/1754481628_1169602_1375450862_dc37c30a3faeb299ea4677b0280013c1_rle_crop_3904810092_0.png treat image : temp/1754481628_1169602_1375450860_490f2b7430e0792f91667e78d2299446_rle_crop_3904810095_0.png treat image : temp/1754481628_1169602_1375450838_fbc1d41e8daa6a01c8d137bcaf478141_rle_crop_3904810096_0.png treat image : temp/1754481628_1169602_1375450834_110e8fe49644896aa5d566b6f8a0722f_rle_crop_3904810097_0.png treat image : temp/1754481628_1169602_1375450831_3cb741c31cf1b75e812f532708c6e60a_rle_crop_3904810098_0.png treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397_rle_crop_3904810102_0.png treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397_rle_crop_3904810101_0.png treat image : temp/1754481628_1169602_1375450828_f96e3731d60489a65e3d0814ffcd7397_rle_crop_3904810100_0.png treat image : temp/1754481628_1169602_1375450825_e12d35021b4560169b6b1315cc7981eb_rle_crop_3904810104_0.png treat image : temp/1754481628_1169602_1375450824_b944b2f9e85eb2a6bec52a172b3f96c2_rle_crop_3904810105_0.png treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e_rle_crop_3904810108_0.png treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e_rle_crop_3904810107_0.png treat image : temp/1754481628_1169602_1375450782_2b996e3c3ee2f0d4c7fd7decb3935b0e_rle_crop_3904810109_0.png Inside saveOutput : final : False verbose : 0 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 37 time used for this insertion : 0.016406536102294922 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 37 time used for this insertion : 0.017054319381713867 save missing photos in datou_result : time spend for datou_step_exec : 2.875330924987793 time spend to save output : 0.04302477836608887 total time spend for step 7 : 2.918355703353882 step8:velours_tree Wed Aug 6 14:01:44 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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.1414475440979004 time spend to save output : 3.62396240234375e-05 total time spend for step 8 : 0.14148378372192383 step9:send_mail_cod Wed Aug 6 14:01:44 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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_P25727196_06-08-2025_14_01_44.pdf 25728537 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette257285371754481704 25728538 imagette257285381754481704 25728539 change filename to text .imagette257285391754481705 25728540 imagette257285401754481705 25728541 imagette257285411754481705 25728543 imagette257285431754481705 25728544 imagette257285441754481705 25728545 imagette257285451754481705 25728546 imagette257285461754481705 25728547 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette257285471754481705 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=25727196 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/25728537,25728538,25728539,25728540,25728541,25728542,25728543,25728544,25728545,25728546,25728547?tags=papier,pehd,metal,pet_fonce,flou,environnement,background,autre,carton,mal_croppe,pet_clair args[1375450865] : ((1375450865, -0.5836451752096797, 492688767), (1375450865, 0.6681305408170395, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450862] : ((1375450862, -2.751800901509457, 492609224), (1375450862, 0.6468796609290057, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450860] : ((1375450860, -4.761852547722806, 492609224), (1375450860, 0.4607622623233913, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450838] : ((1375450838, -0.5227254297712718, 492688767), (1375450838, 0.5531652165525057, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450834] : ((1375450834, -2.1055622009895765, 492609224), (1375450834, 0.4803727818356874, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450831] : ((1375450831, -2.516990728479095, 492609224), (1375450831, 0.5333806683855823, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450828] : ((1375450828, -1.5947245625109494, 492688767), (1375450828, 0.4979950763618055, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450825] : ((1375450825, -2.2951361005254722, 492609224), (1375450825, 0.5550941060136877, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450824] : ((1375450824, -3.363316254982822, 492609224), (1375450824, 0.5672579736989529, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450785] : ((1375450785, -3.2615794314226325, 492609224), (1375450785, 0.6799332714610204, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com args[1375450782] : ((1375450782, 0.014553701700155927, 492688767), (1375450782, 0.6256331503600995, 2107752395), '0.12946329615600452') We are sending mail with results at report@fotonower.com refus_total : 0.12946329615600452 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=25727196 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_P25727196_06-08-2025_14_01_44.pdf results_Auto_P25727196_06-08-2025_14_01_44.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727196_06-08-2025_14_01_44.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','25727196','results_Auto_P25727196_06-08-2025_14_01_44.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727196_06-08-2025_14_01_44.pdf','pdf','','0.38','0.12946329615600452') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/25727196

https://www.fotonower.com/image?json=false&list_photos_id=1375450865
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450862
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450860
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450838
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450834
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450831
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450828
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450825
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450824
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450785
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1375450782
Bravo, la photo est bien prise.

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

exemples de contaminants: papier: https://www.fotonower.com/view/25728537?limit=200
exemples de contaminants: metal: https://www.fotonower.com/view/25728539?limit=200
exemples de contaminants: pet_clair: https://www.fotonower.com/view/25728547?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727196_06-08-2025_14_01_44.pdf.

Lien vers velours :https://www.fotonower.com/velours/25728537,25728538,25728539,25728540,25728541,25728542,25728543,25728544,25728545,25728546,25728547?tags=papier,pehd,metal,pet_fonce,flou,environnement,background,autre,carton,mal_croppe,pet_clair.


L'équipe Fotonower 202 b'' Server: nginx Date: Wed, 06 Aug 2025 12:01:48 GMT Content-Length: 0 Connection: close X-Message-Id: pnbjBs7UQZO1P0JCjDuzUw 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 [1375450865, 1375450862, 1375450860, 1375450838, 1375450834, 1375450831, 1375450828, 1375450825, 1375450824, 1375450785, 1375450782] 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, '3460109') ('3318', '25727196', '1375450865', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450862', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450860', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450838', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450834', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450831', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450828', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450825', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450824', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450785', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450782', None, None, None, None, None, '3460109') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.013810396194458008 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.570664167404175 time spend to save output : 0.014027833938598633 total time spend for step 9 : 3.5846920013427734 step10:split_time_score Wed Aug 6 14:01:48 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'}] (('10', 11),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 06082025 25727196 Nombre de photos uploadées : 11 / 23040 (0%) 06082025 25727196 Nombre de photos taguées (types de déchets): 0 / 11 (0%) 06082025 25727196 Nombre de photos taguées (volume) : 0 / 11 (0%) elapsed_time : load_data_split_time_score 2.384185791015625e-06 elapsed_time : order_list_meta_photo_and_scores 5.245208740234375e-06 ??????????? elapsed_time : fill_and_build_computed_from_old_data 0.0006034374237060547 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.19794821739196777 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.11844979745370371 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25716934_06-08-2025_08_42_56.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25716934 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`=25716934 AND mptpi.`type`=3594 To do Qualite : 0.05851508601125635 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25717830_06-08-2025_09_22_04.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25717830 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`=25717830 AND mptpi.`type`=3594 To do Qualite : 0.1097653653252612 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727185_06-08-2025_13_48_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727185 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`=25727185 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727189 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727191 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727194 order by id desc limit 1 Qualite : 0.12946329615600452 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727196_06-08-2025_14_01_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727196 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`=25727196 AND mptpi.`type`=3594 To do Qualite : 0.24456746720679012 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727198_06-08-2025_13_51_48.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727198 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`=25727198 AND mptpi.`type`=3594 To do Qualite : 0.12766646499719417 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727203_06-08-2025_13_41_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727203 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`=25727203 AND mptpi.`type`=3594 To do Qualite : 0.11182745341792408 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P25727206_06-08-2025_13_33_15.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 25727206 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`=25727206 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'06082025': {'nb_upload': 11, '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 [1375450865, 1375450862, 1375450860, 1375450838, 1375450834, 1375450831, 1375450828, 1375450825, 1375450824, 1375450785, 1375450782] Looping around the photos to save general results len do output : 1 /25727196Didn'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, '3460109') ('3318', '25727196', '1375450865', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450862', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450860', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450838', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450834', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450831', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450828', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450825', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450824', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450785', None, None, None, None, None, '3460109') ('3318', None, None, None, None, None, None, None, '3460109') ('3318', '25727196', '1375450782', None, None, None, None, None, '3460109') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 12 time used for this insertion : 0.013424873352050781 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.727987051010132 time spend to save output : 0.01363229751586914 total time spend for step 10 : 3.741619348526001 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 11 set_done_treatment 44.73user 24.89system 1:27.59elapsed 79%CPU (0avgtext+0avgdata 2772240maxresident)k 3576inputs+25232outputs (24major+1570995minor)pagefaults 0swaps