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 : 79300 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 : ['3841110'] with mtr_portfolio_ids : ['27507873'] and first list_photo_ids : [] new path : /proc/79300/ 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 , BFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 8 ; length of list_pids : 8 ; length of list_args : 8 time to download the photos : 1.7687242031097412 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 Sat Oct 4 01:20:29 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 10578 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-10-04 01:20:32.292625: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-10-04 01:20:32.316728: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3492910000 Hz 2025-10-04 01:20:32.318465: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f9800000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-10-04 01:20:32.318508: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-10-04 01:20:32.322016: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-10-04 01:20:32.494691: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x24793480 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-10-04 01:20:32.494738: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-10-04 01:20:32.496008: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-04 01:20:32.499836: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-04 01:20:32.504565: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-04 01:20:32.507952: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-04 01:20:32.509041: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-04 01:20:32.512534: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-04 01:20:32.514260: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-04 01:20:32.520502: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-04 01:20:32.522217: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-04 01:20:32.522283: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-04 01:20:32.523206: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-04 01:20:32.523224: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-04 01:20:32.523235: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-04 01:20:32.524932: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9798 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-10-04 01:20:32.983894: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-04 01:20:32.983992: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-04 01:20:32.984020: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-04 01:20:32.984046: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-04 01:20:32.984071: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-04 01:20:32.984095: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-04 01:20:32.984119: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-04 01:20:32.984143: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-04 01:20:32.985916: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-04 01:20:32.987098: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-04 01:20:32.987128: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-04 01:20:32.987144: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-04 01:20:32.987159: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-04 01:20:32.987173: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-04 01:20:32.987188: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-04 01:20:32.987202: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-04 01:20:32.987217: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-04 01:20:32.988450: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-04 01:20:32.988482: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-04 01:20:32.988491: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-04 01:20:32.988499: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-04 01:20:32.989821: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9798 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) Using TensorFlow backend. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:396: calling crop_and_resize_v1 (from tensorflow.python.ops.image_ops_impl) with box_ind is deprecated and will be removed in a future version. Instructions for updating: box_ind is deprecated, use box_indices instead WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:703: to_int32 (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:729: to_float (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. Inside mask_sub_process Inside mask_detect About to load cache.load_thcl_param To do loadFromThcl(), then load ParamDescType : thcl2847 thcls : [{'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}] thcl {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5275 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) {'thcl': {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'], 'list_hashtags_csv': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'svm_hashtag_type_desc': 5275, 'photo_desc_type': 5275, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'] Configurations: BACKBONE resnet101 BACKBONE_SHAPES [[160 160] [ 80 80] [ 40 40] [ 20 20] [ 10 10]] BACKBONE_STRIDES [4, 8, 16, 32, 64] BATCH_SIZE 1 BBOX_STD_DEV [0.1 0.1 0.2 0.2] DETECTION_MAX_INSTANCES 100 DETECTION_MIN_CONFIDENCE 0.3 DETECTION_NMS_THRESHOLD 0.3 GPU_COUNT 1 IMAGES_PER_GPU 1 IMAGE_MAX_DIM 640 IMAGE_MIN_DIM 640 IMAGE_PADDING True IMAGE_SHAPE [640 640 3] LEARNING_MOMENTUM 0.9 LEARNING_RATE 0.001 LOSS_WEIGHTS {'rpn_class_loss': 1.0, 'rpn_bbox_loss': 1.0, 'mrcnn_class_loss': 1.0, 'mrcnn_bbox_loss': 1.0, 'mrcnn_mask_loss': 1.0} MASK_POOL_SIZE 14 MASK_SHAPE [28, 28] MAX_GT_INSTANCES 100 MEAN_PIXEL [123.7 116.8 103.9] MINI_MASK_SHAPE (56, 56) NAME learn_RUBBIA_REFUS_AMIENS_23 NUM_CLASSES 9 POOL_SIZE 7 POST_NMS_ROIS_INFERENCE 1000 POST_NMS_ROIS_TRAINING 2000 ROI_POSITIVE_RATIO 0.33 RPN_ANCHOR_RATIOS [0.5, 1, 2] RPN_ANCHOR_SCALES (16, 32, 64, 128, 256) RPN_ANCHOR_STRIDE 1 RPN_BBOX_STD_DEV [0.1 0.1 0.2 0.2] RPN_NMS_THRESHOLD 0.7 RPN_TRAIN_ANCHORS_PER_IMAGE 256 STEPS_PER_EPOCH 1000 TRAIN_ROIS_PER_IMAGE 200 USE_MINI_MASK True USE_RPN_ROIS True VALIDATION_STEPS 50 WEIGHT_DECAY 0.0001 model_param file didn't exist model_name : learn_RUBBIA_REFUS_AMIENS_23 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-10-04 01:20:43.603787: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-04 01:20:43.794355: 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 : 8 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 18 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 20 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 15 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 26 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 20 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 3.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 16 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 3.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 20 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 17 Detection mask done ! Trying to reset tf kernel 79869 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 5286 tf kernel not reseted sub process len(results) : 8 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 8 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 : 10578 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.0006237030029296875 nb_pixel_total : 22682 time to create 1 rle with old method : 0.02470993995666504 length of segment : 216 time for calcul the mask position with numpy : 0.004733085632324219 nb_pixel_total : 219335 time to create 1 rle with new method : 0.013531684875488281 length of segment : 614 time for calcul the mask position with numpy : 0.0006716251373291016 nb_pixel_total : 48910 time to create 1 rle with old method : 0.051400184631347656 length of segment : 262 time for calcul the mask position with numpy : 0.0005345344543457031 nb_pixel_total : 36088 time to create 1 rle with old method : 0.037482261657714844 length of segment : 239 time for calcul the mask position with numpy : 0.00038933753967285156 nb_pixel_total : 29538 time to create 1 rle with old method : 0.03099226951599121 length of segment : 238 time for calcul the mask position with numpy : 0.002107858657836914 nb_pixel_total : 150230 time to create 1 rle with new method : 0.008296489715576172 length of segment : 471 time for calcul the mask position with numpy : 0.00038504600524902344 nb_pixel_total : 25908 time to create 1 rle with old method : 0.02672266960144043 length of segment : 257 time for calcul the mask position with numpy : 0.0017228126525878906 nb_pixel_total : 120488 time to create 1 rle with old method : 0.1245424747467041 length of segment : 509 time for calcul the mask position with numpy : 0.002413511276245117 nb_pixel_total : 200493 time to create 1 rle with new method : 0.009177684783935547 length of segment : 616 time for calcul the mask position with numpy : 0.0014851093292236328 nb_pixel_total : 108569 time to create 1 rle with old method : 0.11090350151062012 length of segment : 411 time for calcul the mask position with numpy : 0.0007157325744628906 nb_pixel_total : 42413 time to create 1 rle with old method : 0.04596567153930664 length of segment : 254 time for calcul the mask position with numpy : 0.0017819404602050781 nb_pixel_total : 132395 time to create 1 rle with old method : 0.1387159824371338 length of segment : 360 time for calcul the mask position with numpy : 0.000331878662109375 nb_pixel_total : 13947 time to create 1 rle with old method : 0.014606952667236328 length of segment : 156 time for calcul the mask position with numpy : 0.0006568431854248047 nb_pixel_total : 47310 time to create 1 rle with old method : 0.04896998405456543 length of segment : 434 time for calcul the mask position with numpy : 0.0005609989166259766 nb_pixel_total : 44507 time to create 1 rle with old method : 0.046099185943603516 length of segment : 311 time for calcul the mask position with numpy : 0.00048279762268066406 nb_pixel_total : 31690 time to create 1 rle with old method : 0.03452110290527344 length of segment : 233 time for calcul the mask position with numpy : 0.0018143653869628906 nb_pixel_total : 122153 time to create 1 rle with old method : 0.1271378993988037 length of segment : 541 time for calcul the mask position with numpy : 0.0005130767822265625 nb_pixel_total : 29576 time to create 1 rle with old method : 0.0307161808013916 length of segment : 246 time for calcul the mask position with numpy : 0.002901315689086914 nb_pixel_total : 219403 time to create 1 rle with new method : 0.010965824127197266 length of segment : 555 time for calcul the mask position with numpy : 0.0008311271667480469 nb_pixel_total : 60416 time to create 1 rle with old method : 0.06269955635070801 length of segment : 285 time for calcul the mask position with numpy : 0.0008745193481445312 nb_pixel_total : 47213 time to create 1 rle with old method : 0.04954385757446289 length of segment : 270 time for calcul the mask position with numpy : 0.00057220458984375 nb_pixel_total : 43856 time to create 1 rle with old method : 0.04634714126586914 length of segment : 251 time for calcul the mask position with numpy : 0.0012400150299072266 nb_pixel_total : 110542 time to create 1 rle with old method : 0.11338233947753906 length of segment : 515 time for calcul the mask position with numpy : 0.0009067058563232422 nb_pixel_total : 70477 time to create 1 rle with old method : 0.07450461387634277 length of segment : 362 time for calcul the mask position with numpy : 0.0018210411071777344 nb_pixel_total : 153820 time to create 1 rle with new method : 0.007082939147949219 length of segment : 409 time for calcul the mask position with numpy : 0.00032448768615722656 nb_pixel_total : 18860 time to create 1 rle with old method : 0.020179271697998047 length of segment : 202 time for calcul the mask position with numpy : 0.001753091812133789 nb_pixel_total : 138822 time to create 1 rle with old method : 0.1441957950592041 length of segment : 463 time for calcul the mask position with numpy : 0.0026450157165527344 nb_pixel_total : 217848 time to create 1 rle with new method : 0.009774923324584961 length of segment : 544 time for calcul the mask position with numpy : 0.0012197494506835938 nb_pixel_total : 99492 time to create 1 rle with old method : 0.10886287689208984 length of segment : 380 time for calcul the mask position with numpy : 0.00025391578674316406 nb_pixel_total : 15476 time to create 1 rle with old method : 0.01730179786682129 length of segment : 153 time for calcul the mask position with numpy : 0.0003685951232910156 nb_pixel_total : 27120 time to create 1 rle with old method : 0.03045177459716797 length of segment : 164 time for calcul the mask position with numpy : 0.0006225109100341797 nb_pixel_total : 43258 time to create 1 rle with old method : 0.051418304443359375 length of segment : 258 time for calcul the mask position with numpy : 0.0007028579711914062 nb_pixel_total : 49881 time to create 1 rle with old method : 0.0544276237487793 length of segment : 256 time for calcul the mask position with numpy : 0.0002498626708984375 nb_pixel_total : 15367 time to create 1 rle with old method : 0.01778864860534668 length of segment : 94 time for calcul the mask position with numpy : 0.0007545948028564453 nb_pixel_total : 50957 time to create 1 rle with old method : 0.05520296096801758 length of segment : 277 time for calcul the mask position with numpy : 0.0006937980651855469 nb_pixel_total : 49495 time to create 1 rle with old method : 0.05185675621032715 length of segment : 182 time for calcul the mask position with numpy : 0.0005848407745361328 nb_pixel_total : 40588 time to create 1 rle with old method : 0.04404473304748535 length of segment : 170 time for calcul the mask position with numpy : 0.0003974437713623047 nb_pixel_total : 19997 time to create 1 rle with old method : 0.020756244659423828 length of segment : 213 time for calcul the mask position with numpy : 0.00044155120849609375 nb_pixel_total : 26044 time to create 1 rle with old method : 0.026998519897460938 length of segment : 250 time for calcul the mask position with numpy : 0.0006535053253173828 nb_pixel_total : 41617 time to create 1 rle with old method : 0.04417777061462402 length of segment : 328 time for calcul the mask position with numpy : 0.0006051063537597656 nb_pixel_total : 40889 time to create 1 rle with old method : 0.042830467224121094 length of segment : 257 time for calcul the mask position with numpy : 0.00070953369140625 nb_pixel_total : 33098 time to create 1 rle with old method : 0.035964250564575195 length of segment : 181 time for calcul the mask position with numpy : 0.0016658306121826172 nb_pixel_total : 132273 time to create 1 rle with old method : 0.13574790954589844 length of segment : 482 time for calcul the mask position with numpy : 0.0017445087432861328 nb_pixel_total : 130606 time to create 1 rle with old method : 0.13442516326904297 length of segment : 478 time for calcul the mask position with numpy : 0.0004322528839111328 nb_pixel_total : 19391 time to create 1 rle with old method : 0.021134614944458008 length of segment : 223 time for calcul the mask position with numpy : 0.001277923583984375 nb_pixel_total : 76965 time to create 1 rle with old method : 0.08713841438293457 length of segment : 435 time for calcul the mask position with numpy : 0.0018451213836669922 nb_pixel_total : 55338 time to create 1 rle with old method : 0.06406569480895996 length of segment : 295 time for calcul the mask position with numpy : 0.0014033317565917969 nb_pixel_total : 37959 time to create 1 rle with old method : 0.044875144958496094 length of segment : 281 time for calcul the mask position with numpy : 0.0007967948913574219 nb_pixel_total : 13536 time to create 1 rle with old method : 0.015935182571411133 length of segment : 236 time for calcul the mask position with numpy : 0.0005686283111572266 nb_pixel_total : 14998 time to create 1 rle with old method : 0.019361019134521484 length of segment : 149 time for calcul the mask position with numpy : 0.005791187286376953 nb_pixel_total : 261191 time to create 1 rle with new method : 0.013636112213134766 length of segment : 407 time for calcul the mask position with numpy : 0.0017795562744140625 nb_pixel_total : 81265 time to create 1 rle with old method : 0.09256529808044434 length of segment : 345 time for calcul the mask position with numpy : 0.0006101131439208984 nb_pixel_total : 19196 time to create 1 rle with old method : 0.022957801818847656 length of segment : 153 time for calcul the mask position with numpy : 0.002532958984375 nb_pixel_total : 85895 time to create 1 rle with old method : 0.0937654972076416 length of segment : 354 time for calcul the mask position with numpy : 0.0004172325134277344 nb_pixel_total : 15617 time to create 1 rle with old method : 0.0195009708404541 length of segment : 168 time for calcul the mask position with numpy : 0.015498638153076172 nb_pixel_total : 320869 time to create 1 rle with new method : 0.16357946395874023 length of segment : 865 time for calcul the mask position with numpy : 0.0006515979766845703 nb_pixel_total : 38573 time to create 1 rle with old method : 0.041365861892700195 length of segment : 133 time for calcul the mask position with numpy : 0.00032329559326171875 nb_pixel_total : 19181 time to create 1 rle with old method : 0.02029728889465332 length of segment : 149 time for calcul the mask position with numpy : 0.0008907318115234375 nb_pixel_total : 61166 time to create 1 rle with old method : 0.06434965133666992 length of segment : 247 time for calcul the mask position with numpy : 0.0005512237548828125 nb_pixel_total : 31379 time to create 1 rle with old method : 0.034009695053100586 length of segment : 199 time for calcul the mask position with numpy : 0.003890514373779297 nb_pixel_total : 127545 time to create 1 rle with old method : 0.1380748748779297 length of segment : 443 time for calcul the mask position with numpy : 0.00058746337890625 nb_pixel_total : 37365 time to create 1 rle with old method : 0.03947186470031738 length of segment : 223 time for calcul the mask position with numpy : 0.0002148151397705078 nb_pixel_total : 11601 time to create 1 rle with old method : 0.013084173202514648 length of segment : 114 time for calcul the mask position with numpy : 0.0004112720489501953 nb_pixel_total : 27664 time to create 1 rle with old method : 0.029736757278442383 length of segment : 200 time for calcul the mask position with numpy : 0.00044536590576171875 nb_pixel_total : 32016 time to create 1 rle with old method : 0.035167694091796875 length of segment : 199 time for calcul the mask position with numpy : 0.00043201446533203125 nb_pixel_total : 20256 time to create 1 rle with old method : 0.02177739143371582 length of segment : 185 time for calcul the mask position with numpy : 0.0006937980651855469 nb_pixel_total : 36613 time to create 1 rle with old method : 0.0380403995513916 length of segment : 204 time for calcul the mask position with numpy : 0.0003788471221923828 nb_pixel_total : 18322 time to create 1 rle with old method : 0.023749828338623047 length of segment : 146 time for calcul the mask position with numpy : 0.0008192062377929688 nb_pixel_total : 34998 time to create 1 rle with old method : 0.03818798065185547 length of segment : 248 time for calcul the mask position with numpy : 0.0012526512145996094 nb_pixel_total : 74665 time to create 1 rle with old method : 0.07687616348266602 length of segment : 246 time for calcul the mask position with numpy : 0.0030117034912109375 nb_pixel_total : 200589 time to create 1 rle with new method : 0.006140470504760742 length of segment : 738 time for calcul the mask position with numpy : 0.00020265579223632812 nb_pixel_total : 7732 time to create 1 rle with old method : 0.00860285758972168 length of segment : 91 time for calcul the mask position with numpy : 0.00044798851013183594 nb_pixel_total : 29841 time to create 1 rle with old method : 0.03228640556335449 length of segment : 196 time spent for convertir_results : 7.33224892616272 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 73 chid ids of type : 3594 Number RLEs to save : 22219 save missing photos in datou_result : time spend for datou_step_exec : 53.04662108421326 time spend to save output : 2.449192762374878 total time spend for step 1 : 55.495813846588135 step2:crop_condition Sat Oct 4 01:21:24 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 : 8 ! batch 1 Loaded 73 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ begin to crop the class : papier param for this class : {'min_score': 0.7} filtre for class : papier hashtag_id of this class : 492668766 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! 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 : 34 About to insert : list_path_to_insert length 34 new photo from crops ! About to upload 34 photos upload in portfolio : 3736932 init cache_photo without model_param we have 34 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759533696_79300 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042719_0.png', 0, 527, 611, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042724_0.png', 0, 135, 257, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042722_0.png', 0, 155, 230, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042721_0.png', 0, 215, 238, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042737_0.png', 0, 294, 285, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042736_0.png', 0, 567, 550, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042747_0.png', 0, 147, 151, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042745_0.png', 0, 567, 544, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042744_0.png', 0, 457, 462, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042749_0.png', 0, 279, 238, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042739_0.png', 0, 413, 190, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042743_0.png', 0, 143, 202, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042750_0.png', 0, 249, 243, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042761_0.png', 0, 376, 478, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042763_0.png', 0, 243, 434, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042755_0.png', 0, 167, 213, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042757_0.png', 0, 186, 328, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042754_0.png', 0, 343, 160, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042762_0.png', 0, 189, 195, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042752_0.png', 0, 280, 277, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042756_0.png', 0, 188, 250, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042767_0.png', 0, 144, 149, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042765_0.png', 0, 261, 281, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042769_0.png', 0, 348, 342, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042772_0.png', 0, 138, 167, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042770_0.png', 0, 171, 151, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042766_0.png', 0, 92, 236, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042776_0.png', 0, 370, 247, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042775_0.png', 0, 223, 144, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042780_0.png', 0, 134, 114, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042782_0.png', 0, 222, 189, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042779_0.png', 0, 261, 223, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042783_0.png', 0, 156, 185, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533714), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042788_0.png', 0, 355, 723, 0, 1759533714,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 34 photos in the portfolio 3736932 time of upload the photos Elapsed time : 22.847662448883057 we have finished the crop for the class : papier begin to crop the class : carton param for this class : {'min_score': 0.7} filtre for class : carton hashtag_id of this class : 492774966 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! 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 : 11 About to insert : list_path_to_insert length 11 new photo from crops ! About to upload 11 photos upload in portfolio : 3736932 init cache_photo without model_param we have 11 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759533722_79300 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042728_0.png', 0, 241, 254, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042718_0.png', 0, 196, 216, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042735_0.png', 0, 220, 245, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042730_0.png', 0, 182, 155, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042731_0.png', 0, 199, 422, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042748_0.png', 0, 216, 161, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042740_0.png', 0, 308, 510, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042764_0.png', 0, 235, 294, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042753_0.png', 0, 362, 173, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042784_0.png', 0, 245, 204, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533724), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042789_0.png', 0, 114, 91, 0, 1759533724,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 11 photos in the portfolio 3736932 time of upload the photos Elapsed time : 4.571138381958008 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 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 : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 3736932 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759533728_79300 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533728), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042777_0.png', 0, 261, 172, 0, 1759533728,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533728), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042785_0.png', 0, 149, 146, 0, 1759533728,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533728), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042786_0.png', 0, 195, 239, 0, 1759533728,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.3159270286560059 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 ! 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 : 22 About to insert : list_path_to_insert length 22 new photo from crops ! About to upload 22 photos upload in portfolio : 3736932 init cache_photo without model_param we have 22 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759533740_79300 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042723_0.png', 0, 490, 460, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042727_0.png', 0, 431, 398, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042725_0.png', 0, 421, 499, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042726_0.png', 0, 470, 613, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042732_0.png', 0, 190, 309, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042733_0.png', 0, 278, 183, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042738_0.png', 0, 298, 251, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042734_0.png', 0, 488, 471, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042729_0.png', 0, 543, 358, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042741_0.png', 0, 338, 307, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042742_0.png', 0, 545, 409, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042760_0.png', 0, 379, 482, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042759_0.png', 0, 297, 167, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042758_0.png', 0, 218, 257, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042751_0.png', 0, 205, 89, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042771_0.png', 0, 327, 354, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042773_0.png', 0, 1042, 529, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042768_0.png', 0, 1082, 318, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042778_0.png', 0, 1133, 336, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042774_0.png', 0, 353, 131, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042787_0.png', 0, 415, 234, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533745), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042790_0.png', 0, 259, 194, 0, 1759533745,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 22 photos in the portfolio 3736932 time of upload the photos Elapsed time : 8.102617025375366 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 3736932 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1759533750_79300 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533751), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042720_0.png', 0, 268, 262, 0, 1759533751,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533751), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042746_0.png', 0, 342, 369, 0, 1759533751,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1759533751), 0.0, 0.0, 14, '', 0, 0, '1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042781_0.png', 0, 164, 200, 0, 1759533751,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.4117963314056396 we have finished the crop for the class : autre begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles 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 [1387686017, 1387686005, 1387685998, 1387685953, 1387685951, 1387685949, 1387685948, 1387685946] Looping around the photos to save general results len do output : 73 /1387696140Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696142Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696143Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696144Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696145Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696146Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696147Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696148Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696149Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696150Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696151Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696152Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696153Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696154Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696155Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696156Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696157Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696158Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696159Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696160Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696161Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696162Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696163Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696164Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696165Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696166Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696167Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696168Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696169Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696170Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696171Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696172Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696173Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696174Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696175Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696176Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696177Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696178Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696179Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696180Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696181Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696182Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696183Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696184Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696185Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696186Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696187Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696188Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696212Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696213Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696214Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696215Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696216Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696217Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696218Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696219Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696220Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696221Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696222Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696223Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696224Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696225Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696226Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696227Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696228Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696229Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696230Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696231Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696232Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696233Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696236Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696237Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1387696238Didn'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, '3841110') ('3318', '27507873', '1387686017', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387686005', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685998', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685953', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685951', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685949', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685948', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685946', None, None, None, None, None, '3841110') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 227 time used for this insertion : 0.04973745346069336 save_final save missing photos in datou_result : time spend for datou_step_exec : 67.0270402431488 time spend to save output : 0.05292463302612305 total time spend for step 2 : 67.07996487617493 step3:rle_unique_nms_with_priority Sat Oct 4 01:22: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 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 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 73 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++nb_obj : 11 nb_hashtags : 4 time to prepare the origin masks : 4.815623998641968 time for calcul the mask position with numpy : 0.49014782905578613 nb_pixel_total : 7289748 time to create 1 rle with new method : 0.7907023429870605 time for calcul the mask position with numpy : 0.024518489837646484 nb_pixel_total : 42413 time to create 1 rle with old method : 0.04705333709716797 time for calcul the mask position with numpy : 0.02551722526550293 nb_pixel_total : 108569 time to create 1 rle with old method : 0.1220254898071289 time for calcul the mask position with numpy : 0.027796506881713867 nb_pixel_total : 200493 time to create 1 rle with new method : 0.823061466217041 time for calcul the mask position with numpy : 0.02529454231262207 nb_pixel_total : 120488 time to create 1 rle with old method : 0.14229869842529297 time for calcul the mask position with numpy : 0.029819488525390625 nb_pixel_total : 25908 time to create 1 rle with old method : 0.03537440299987793 time for calcul the mask position with numpy : 0.02543497085571289 nb_pixel_total : 150230 time to create 1 rle with new method : 0.7640953063964844 time for calcul the mask position with numpy : 0.024913787841796875 nb_pixel_total : 29536 time to create 1 rle with old method : 0.0314178466796875 time for calcul the mask position with numpy : 0.036200761795043945 nb_pixel_total : 36088 time to create 1 rle with old method : 0.03802847862243652 time for calcul the mask position with numpy : 0.030371427536010742 nb_pixel_total : 48910 time to create 1 rle with old method : 0.05445551872253418 time for calcul the mask position with numpy : 0.028715848922729492 nb_pixel_total : 219335 time to create 1 rle with new method : 0.40188026428222656 time for calcul the mask position with numpy : 0.024329662322998047 nb_pixel_total : 22682 time to create 1 rle with old method : 0.024402379989624023 create new chi : 4.179765701293945 time to delete rle : 0.09023141860961914 batch 1 Loaded 23 chid ids of type : 3594 +++++++++++Number RLEs to save : 10332 TO DO : save crop sub photo not yet done ! save time : 1.2475414276123047 nb_obj : 10 nb_hashtags : 3 time to prepare the origin masks : 4.257776498794556 time for calcul the mask position with numpy : 0.6068563461303711 nb_pixel_total : 7560641 time to create 1 rle with new method : 0.8236405849456787 time for calcul the mask position with numpy : 0.023578166961669922 nb_pixel_total : 42893 time to create 1 rle with old method : 0.04641461372375488 time for calcul the mask position with numpy : 0.02328038215637207 nb_pixel_total : 60416 time to create 1 rle with old method : 0.06531023979187012 time for calcul the mask position with numpy : 0.025542736053466797 nb_pixel_total : 219403 time to create 1 rle with new method : 0.8147015571594238 time for calcul the mask position with numpy : 0.03659772872924805 nb_pixel_total : 29576 time to create 1 rle with old method : 0.032147884368896484 time for calcul the mask position with numpy : 0.034722328186035156 nb_pixel_total : 122153 time to create 1 rle with old method : 0.1605377197265625 time for calcul the mask position with numpy : 0.024529218673706055 nb_pixel_total : 31690 time to create 1 rle with old method : 0.034193992614746094 time for calcul the mask position with numpy : 0.024866104125976562 nb_pixel_total : 44507 time to create 1 rle with old method : 0.048689842224121094 time for calcul the mask position with numpy : 0.02698040008544922 nb_pixel_total : 36779 time to create 1 rle with old method : 0.04060649871826172 time for calcul the mask position with numpy : 0.025211572647094727 nb_pixel_total : 13947 time to create 1 rle with old method : 0.01539921760559082 time for calcul the mask position with numpy : 0.025881528854370117 nb_pixel_total : 132395 time to create 1 rle with old method : 0.14212965965270996 create new chi : 3.167595624923706 time to delete rle : 0.0010652542114257812 batch 1 Loaded 21 chid ids of type : 3594 +++++++++++++Number RLEs to save : 8626 TO DO : save crop sub photo not yet done ! save time : 1.0317749977111816 nb_obj : 11 nb_hashtags : 4 time to prepare the origin masks : 4.420801162719727 time for calcul the mask position with numpy : 0.4094531536102295 nb_pixel_total : 7354829 time to create 1 rle with new method : 0.6299986839294434 time for calcul the mask position with numpy : 0.023095130920410156 nb_pixel_total : 43258 time to create 1 rle with old method : 0.04643726348876953 time for calcul the mask position with numpy : 0.039193153381347656 nb_pixel_total : 27120 time to create 1 rle with old method : 0.028029203414916992 time for calcul the mask position with numpy : 0.036913394927978516 nb_pixel_total : 15476 time to create 1 rle with old method : 0.015816926956176758 time for calcul the mask position with numpy : 0.025359630584716797 nb_pixel_total : 99492 time to create 1 rle with old method : 0.10282611846923828 time for calcul the mask position with numpy : 0.02474832534790039 nb_pixel_total : 217848 time to create 1 rle with new method : 0.7719323635101318 time for calcul the mask position with numpy : 0.024553298950195312 nb_pixel_total : 138822 time to create 1 rle with old method : 0.14147496223449707 time for calcul the mask position with numpy : 0.025651931762695312 nb_pixel_total : 18860 time to create 1 rle with old method : 0.01980280876159668 time for calcul the mask position with numpy : 0.02413034439086914 nb_pixel_total : 153820 time to create 1 rle with new method : 0.7192237377166748 time for calcul the mask position with numpy : 0.024112939834594727 nb_pixel_total : 70477 time to create 1 rle with old method : 0.07425355911254883 time for calcul the mask position with numpy : 0.025445938110351562 nb_pixel_total : 110542 time to create 1 rle with old method : 0.11436629295349121 time for calcul the mask position with numpy : 0.023490190505981445 nb_pixel_total : 43856 time to create 1 rle with old method : 0.046120643615722656 create new chi : 3.5090715885162354 time to delete rle : 0.001199483871459961 batch 1 Loaded 23 chid ids of type : 3594 +++++++++++++Number RLEs to save : 9562 TO DO : save crop sub photo not yet done ! save time : 1.15016508102417 nb_obj : 15 nb_hashtags : 3 time to prepare the origin masks : 5.125289440155029 time for calcul the mask position with numpy : 0.5593917369842529 nb_pixel_total : 7640975 time to create 1 rle with new method : 0.727231502532959 time for calcul the mask position with numpy : 0.040987253189086914 nb_pixel_total : 55338 time to create 1 rle with old method : 0.056463003158569336 time for calcul the mask position with numpy : 0.023531436920166016 nb_pixel_total : 76965 time to create 1 rle with old method : 0.08485913276672363 time for calcul the mask position with numpy : 0.0239865779876709 nb_pixel_total : 19391 time to create 1 rle with old method : 0.020601511001586914 time for calcul the mask position with numpy : 0.023160457611083984 nb_pixel_total : 1525 time to create 1 rle with old method : 0.002248525619506836 time for calcul the mask position with numpy : 0.02424001693725586 nb_pixel_total : 132273 time to create 1 rle with old method : 0.14377045631408691 time for calcul the mask position with numpy : 0.024916648864746094 nb_pixel_total : 33098 time to create 1 rle with old method : 0.03562331199645996 time for calcul the mask position with numpy : 0.024544715881347656 nb_pixel_total : 40889 time to create 1 rle with old method : 0.041808366775512695 time for calcul the mask position with numpy : 0.024196386337280273 nb_pixel_total : 41617 time to create 1 rle with old method : 0.04365134239196777 time for calcul the mask position with numpy : 0.03587007522583008 nb_pixel_total : 26044 time to create 1 rle with old method : 0.0272829532623291 time for calcul the mask position with numpy : 0.03856039047241211 nb_pixel_total : 19997 time to create 1 rle with old method : 0.020536422729492188 time for calcul the mask position with numpy : 0.038455963134765625 nb_pixel_total : 40588 time to create 1 rle with old method : 0.04194808006286621 time for calcul the mask position with numpy : 0.03934836387634277 nb_pixel_total : 49495 time to create 1 rle with old method : 0.05121278762817383 time for calcul the mask position with numpy : 0.03937840461730957 nb_pixel_total : 50957 time to create 1 rle with old method : 0.056349754333496094 time for calcul the mask position with numpy : 0.03877592086791992 nb_pixel_total : 15367 time to create 1 rle with old method : 0.01651763916015625 time for calcul the mask position with numpy : 0.03520512580871582 nb_pixel_total : 49881 time to create 1 rle with old method : 0.05216574668884277 create new chi : 2.499359369277954 time to delete rle : 0.0013175010681152344 batch 1 Loaded 31 chid ids of type : 3594 ++++++++++++++++Number RLEs to save : 9787 TO DO : save crop sub photo not yet done ! save time : 1.1927621364593506 nb_obj : 9 nb_hashtags : 2 time to prepare the origin masks : 3.1260011196136475 time for calcul the mask position with numpy : 0.4403824806213379 nb_pixel_total : 7443874 time to create 1 rle with new method : 0.7560529708862305 time for calcul the mask position with numpy : 0.026657819747924805 nb_pixel_total : 320869 time to create 1 rle with new method : 0.76924729347229 time for calcul the mask position with numpy : 0.0228116512298584 nb_pixel_total : 15617 time to create 1 rle with old method : 0.016292095184326172 time for calcul the mask position with numpy : 0.023732423782348633 nb_pixel_total : 85895 time to create 1 rle with old method : 0.09130668640136719 time for calcul the mask position with numpy : 0.023218870162963867 nb_pixel_total : 19196 time to create 1 rle with old method : 0.019644498825073242 time for calcul the mask position with numpy : 0.02410125732421875 nb_pixel_total : 81265 time to create 1 rle with old method : 0.08590149879455566 time for calcul the mask position with numpy : 0.025293588638305664 nb_pixel_total : 261191 time to create 1 rle with new method : 0.5757880210876465 time for calcul the mask position with numpy : 0.023522377014160156 nb_pixel_total : 14998 time to create 1 rle with old method : 0.015496015548706055 time for calcul the mask position with numpy : 0.024812936782836914 nb_pixel_total : 13536 time to create 1 rle with old method : 0.014471292495727539 time for calcul the mask position with numpy : 0.024507999420166016 nb_pixel_total : 37959 time to create 1 rle with old method : 0.043184518814086914 create new chi : 3.139078140258789 time to delete rle : 0.001230001449584961 batch 1 Loaded 19 chid ids of type : 3594 ++++++++++++Number RLEs to save : 8076 TO DO : save crop sub photo not yet done ! save time : 1.0004112720489502 nb_obj : 5 nb_hashtags : 3 time to prepare the origin masks : 2.0434188842773438 time for calcul the mask position with numpy : 0.597252607345581 nb_pixel_total : 8016556 time to create 1 rle with new method : 0.9411699771881104 time for calcul the mask position with numpy : 0.03578329086303711 nb_pixel_total : 127545 time to create 1 rle with old method : 0.13716578483581543 time for calcul the mask position with numpy : 0.02420949935913086 nb_pixel_total : 31379 time to create 1 rle with old method : 0.03532123565673828 time for calcul the mask position with numpy : 0.022539138793945312 nb_pixel_total : 61166 time to create 1 rle with old method : 0.06552648544311523 time for calcul the mask position with numpy : 0.023980379104614258 nb_pixel_total : 19181 time to create 1 rle with old method : 0.02041935920715332 time for calcul the mask position with numpy : 0.02453446388244629 nb_pixel_total : 38573 time to create 1 rle with old method : 0.042322635650634766 create new chi : 2.011442184448242 time to delete rle : 0.0006585121154785156 batch 1 Loaded 11 chid ids of type : 3594 +++++Number RLEs to save : 4502 TO DO : save crop sub photo not yet done ! save time : 0.6610538959503174 nb_obj : 5 nb_hashtags : 2 time to prepare the origin masks : 2.0989580154418945 time for calcul the mask position with numpy : 0.4809572696685791 nb_pixel_total : 8165498 time to create 1 rle with new method : 0.7706801891326904 time for calcul the mask position with numpy : 0.027235031127929688 nb_pixel_total : 20256 time to create 1 rle with old method : 0.02167224884033203 time for calcul the mask position with numpy : 0.022998332977294922 nb_pixel_total : 32016 time to create 1 rle with old method : 0.032445669174194336 time for calcul the mask position with numpy : 0.023521900177001953 nb_pixel_total : 27664 time to create 1 rle with old method : 0.030233383178710938 time for calcul the mask position with numpy : 0.024733304977416992 nb_pixel_total : 11601 time to create 1 rle with old method : 0.012525081634521484 time for calcul the mask position with numpy : 0.024326801300048828 nb_pixel_total : 37365 time to create 1 rle with old method : 0.03944849967956543 create new chi : 1.5553359985351562 time to delete rle : 0.0007042884826660156 batch 1 Loaded 11 chid ids of type : 3594 +++++Number RLEs to save : 4002 TO DO : save crop sub photo not yet done ! save time : 0.5840647220611572 nb_obj : 7 nb_hashtags : 4 time to prepare the origin masks : 3.5994889736175537 time for calcul the mask position with numpy : 0.5585803985595703 nb_pixel_total : 7891640 time to create 1 rle with new method : 0.917731761932373 time for calcul the mask position with numpy : 0.02759265899658203 nb_pixel_total : 29841 time to create 1 rle with old method : 0.03254437446594238 time for calcul the mask position with numpy : 0.043497323989868164 nb_pixel_total : 7732 time to create 1 rle with old method : 0.008926630020141602 time for calcul the mask position with numpy : 0.041074514389038086 nb_pixel_total : 200589 time to create 1 rle with new method : 0.5471723079681396 time for calcul the mask position with numpy : 0.02548670768737793 nb_pixel_total : 74665 time to create 1 rle with old method : 0.08399558067321777 time for calcul the mask position with numpy : 0.02648639678955078 nb_pixel_total : 34998 time to create 1 rle with old method : 0.04132413864135742 time for calcul the mask position with numpy : 0.025522470474243164 nb_pixel_total : 18322 time to create 1 rle with old method : 0.019584178924560547 time for calcul the mask position with numpy : 0.024227142333984375 nb_pixel_total : 36613 time to create 1 rle with old method : 0.03846383094787598 create new chi : 2.531522035598755 time to delete rle : 0.0009167194366455078 batch 1 Loaded 15 chid ids of type : 3594 +++++++Number RLEs to save : 5898 TO DO : save crop sub photo not yet done ! save time : 0.7735016345977783 map_output_result : {1387686017: (0.0, 'Should be the crop_list due to order', 0), 1387686005: (0.0, 'Should be the crop_list due to order', 0), 1387685998: (0.0, 'Should be the crop_list due to order', 0), 1387685953: (0.0, 'Should be the crop_list due to order', 0), 1387685951: (0.0, 'Should be the crop_list due to order', 0), 1387685949: (0.0, 'Should be the crop_list due to order', 0), 1387685948: (0.0, 'Should be the crop_list due to order', 0), 1387685946: (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 [1387686017, 1387686005, 1387685998, 1387685953, 1387685951, 1387685949, 1387685948, 1387685946] Looping around the photos to save general results len do output : 8 /1387686017.Didn't retrieve data . /1387686005.Didn't retrieve data . /1387685998.Didn't retrieve data . /1387685953.Didn't retrieve data . /1387685951.Didn't retrieve data . /1387685949.Didn't retrieve data . /1387685948.Didn't retrieve data . /1387685946.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, '3841110') ('3318', '27507873', '1387686017', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387686005', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685998', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685953', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685951', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685949', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685948', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685946', None, None, None, None, None, '3841110') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 24 time used for this insertion : 0.03746461868286133 save_final save missing photos in datou_result : time spend for datou_step_exec : 61.294764041900635 time spend to save output : 0.037806034088134766 total time spend for step 3 : 61.33257007598877 step4:ventilate_hashtags_in_portfolio Sat Oct 4 01:23:32 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : 27507873 get user id for portfolio 27507873 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`=27507873 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('metal','flou','papier','pehd','pet_fonce','autre','mal_croppe','pet_clair','environnement','carton','background')) 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`=27507873 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('metal','flou','papier','pehd','pet_fonce','autre','mal_croppe','pet_clair','environnement','carton','background')) 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`=27507873 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('metal','flou','papier','pehd','pet_fonce','autre','mal_croppe','pet_clair','environnement','carton','background')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/27508693,27508694,27508695,27508696,27508697,27508698,27508699,27508700,27508701,27508702,27508703?tags=metal,flou,papier,pehd,pet_fonce,autre,mal_croppe,pet_clair,environnement,carton,background Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1387686017, 1387686005, 1387685998, 1387685953, 1387685951, 1387685949, 1387685948, 1387685946] Looping around the photos to save general results len do output : 1 /27507873. 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, '3841110') ('3318', '27507873', '1387686017', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387686005', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685998', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685953', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685951', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685949', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685948', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685946', None, None, None, None, None, '3841110') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.03735828399658203 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.574483633041382 time spend to save output : 0.03761696815490723 total time spend for step 4 : 5.612100601196289 step5:final Sat Oct 4 01:23:38 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 : {1387686017: ('0.0752230269820602',), 1387686005: ('0.0752230269820602',), 1387685998: ('0.0752230269820602',), 1387685953: ('0.0752230269820602',), 1387685951: ('0.0752230269820602',), 1387685949: ('0.0752230269820602',), 1387685948: ('0.0752230269820602',), 1387685946: ('0.0752230269820602',)} new output for save of step final : {1387686017: ('0.0752230269820602',), 1387686005: ('0.0752230269820602',), 1387685998: ('0.0752230269820602',), 1387685953: ('0.0752230269820602',), 1387685951: ('0.0752230269820602',), 1387685949: ('0.0752230269820602',), 1387685948: ('0.0752230269820602',), 1387685946: ('0.0752230269820602',)} [1387686017, 1387686005, 1387685998, 1387685953, 1387685951, 1387685949, 1387685948, 1387685946] Looping around the photos to save general results len do output : 8 /1387686017.Didn't retrieve data . /1387686005.Didn't retrieve data . /1387685998.Didn't retrieve data . /1387685953.Didn't retrieve data . /1387685951.Didn't retrieve data . /1387685949.Didn't retrieve data . /1387685948.Didn't retrieve data . /1387685946.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, '3841110') ('3318', '27507873', '1387686017', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387686005', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685998', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685953', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685951', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685949', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685948', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685946', None, None, None, None, None, '3841110') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 24 time used for this insertion : 0.036657094955444336 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.3773190975189209 time spend to save output : 0.03713655471801758 total time spend for step 5 : 0.4144556522369385 step6:blur_detection Sat Oct 4 01:23:39 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step blur_detection methode: ratio et variance treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2.jpg resize: (2160, 3840) 1387686017 -6.450727755419489 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6.jpg resize: (2160, 3840) 1387686005 -6.224491456654126 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6.jpg resize: (2160, 3840) 1387685998 -6.147782512495353 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c.jpg resize: (2160, 3840) 1387685953 -6.210293605446872 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db.jpg resize: (2160, 3840) 1387685951 -5.134049222698141 treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b.jpg resize: (2160, 3840) 1387685949 -4.074401190908372 treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32.jpg resize: (2160, 3840) 1387685948 -4.00406063311292 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090.jpg resize: (2160, 3840) 1387685946 -3.9632476597262296 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042719_0.png resize: (611, 527) 1387696140 -4.837082163409477 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042724_0.png resize: (257, 135) 1387696142 -4.426582737855761 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042722_0.png resize: (230, 155) 1387696143 -3.4878392178781703 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042721_0.png resize: (238, 215) 1387696144 -3.9410151671179667 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042737_0.png resize: (285, 294) 1387696145 -3.7710870611209155 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042736_0.png resize: (550, 567) 1387696146 -3.5656254166458425 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042747_0.png resize: (151, 147) 1387696147 -1.1132622033599524 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042745_0.png resize: (544, 567) 1387696148 -3.9434872404530896 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042744_0.png resize: (462, 457) 1387696149 -4.298448292064154 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042749_0.png resize: (238, 279) 1387696150 -1.5343661900259542 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042739_0.png resize: (190, 413) 1387696151 -3.483413779487612 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042743_0.png resize: (202, 143) 1387696152 -2.9268696416480755 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042750_0.png resize: (243, 249) 1387696153 -2.1496654512622864 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042761_0.png resize: (478, 376) 1387696154 -4.7828851959326055 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042763_0.png resize: (434, 243) 1387696155 -4.439836079879376 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042755_0.png resize: (213, 167) 1387696156 -2.625059413939505 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042757_0.png resize: (328, 186) 1387696157 -2.887897801764531 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042754_0.png resize: (160, 343) 1387696158 -1.2298469378785626 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042762_0.png resize: (195, 189) 1387696159 -3.1310346387376176 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042752_0.png resize: (277, 280) 1387696160 -4.1644486450767655 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042756_0.png resize: (250, 188) 1387696161 -4.012719606366336 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042767_0.png resize: (149, 144) 1387696162 -4.3975890843634975 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042765_0.png resize: (281, 261) 1387696163 -3.936530300938675 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042769_0.png resize: (342, 348) 1387696164 -3.9179805718629828 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042772_0.png resize: (167, 138) 1387696165 -4.861444531159694 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042770_0.png resize: (151, 171) 1387696166 -4.470348479017886 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042766_0.png resize: (236, 92) 1387696167 -4.360533230609304 treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042776_0.png resize: (247, 370) 1387696168 -4.410611515759743 treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042775_0.png resize: (144, 223) 1387696169 -4.326943755528093 treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042780_0.png resize: (114, 134) 1387696170 -2.5408636085790874 treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042782_0.png resize: (189, 222) 1387696171 -4.729770222386408 treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042779_0.png resize: (223, 261) 1387696172 -4.219852857619091 treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042783_0.png resize: (185, 156) 1387696173 -4.124229716916931 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042788_0.png resize: (723, 355) 1387696174 -4.970113007644597 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042728_0.png resize: (254, 241) 1387696175 -4.887406677837849 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042718_0.png resize: (216, 196) 1387696176 -4.169290391561544 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042735_0.png resize: (245, 220) 1387696177 -3.6874704640477995 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042730_0.png resize: (155, 182) 1387696178 -3.5180812350807735 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042731_0.png resize: (422, 199) 1387696179 -4.064387475538033 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042748_0.png resize: (161, 216) 1387696180 -3.4140428482899137 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042740_0.png resize: (510, 308) 1387696181 -4.647514320230829 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042764_0.png resize: (294, 235) 1387696182 -4.615129495922887 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042753_0.png resize: (173, 362) 1387696183 -2.6429242582707118 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042784_0.png resize: (204, 245) 1387696184 -2.2044902201521115 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042789_0.png resize: (91, 114) 1387696185 -0.9622308141091873 treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042777_0.png resize: (172, 261) 1387696186 -4.8408205625015235 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042785_0.png resize: (146, 149) 1387696187 -3.5931831720272718 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042786_0.png resize: (239, 195) 1387696188 -3.8259609819518126 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042723_0.png resize: (460, 490) 1387696212 -4.627273198767864 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042727_0.png resize: (398, 431) 1387696213 -3.368125379492484 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042725_0.png resize: (499, 421) 1387696214 -4.651193940245855 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042726_0.png resize: (613, 470) 1387696215 -5.058934386901495 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042732_0.png resize: (309, 190) 1387696216 -4.757622899804496 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042733_0.png resize: (183, 278) 1387696217 -3.37087123102451 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042738_0.png resize: (251, 298) 1387696218 -3.158836665069778 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042734_0.png resize: (471, 488) 1387696219 -4.734752686959614 treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042729_0.png resize: (358, 543) 1387696220 -4.1538995894111395 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042741_0.png resize: (307, 338) 1387696221 -3.4939121412811724 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042742_0.png resize: (409, 545) 1387696222 -4.55429280162999 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042760_0.png resize: (482, 379) 1387696223 -4.862417722014965 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042759_0.png resize: (167, 297) 1387696224 -2.818330047374576 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042758_0.png resize: (257, 218) 1387696225 -4.382207098486792 treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042751_0.png resize: (89, 205) 1387696226 -4.300544406697537 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042771_0.png resize: (354, 327) 1387696227 -5.175885689949201 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042773_0.png resize: (529, 1042) 1387696228 -3.927734616203887 treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042768_0.png resize: (318, 1082) 1387696229 -5.033873817460581 treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042778_0.png resize: (336, 1133) 1387696230 -1.9573367392022665 treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042774_0.png resize: (131, 353) 1387696231 -4.172196737884831 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042787_0.png resize: (234, 415) 1387696232 -4.69414297419345 treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042790_0.png resize: (194, 259) 1387696233 -4.407863803687237 treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042720_0.png resize: (262, 268) 1387696236 -4.364836592094698 treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042746_0.png resize: (369, 342) 1387696237 -2.813925720094427 treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042781_0.png resize: (200, 164) 1387696238 -3.4829822991823076 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 : 81 time used for this insertion : 0.041252851486206055 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 81 time used for this insertion : 0.03664970397949219 save missing photos in datou_result : time spend for datou_step_exec : 32.22354578971863 time spend to save output : 0.09554505348205566 total time spend for step 6 : 32.319090843200684 step7:brightness Sat Oct 4 01:24:11 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step calcul brightness treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2.jpg treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6.jpg treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6.jpg treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c.jpg treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db.jpg treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b.jpg treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32.jpg treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090.jpg treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042719_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042724_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042722_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042721_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042737_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042736_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042747_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042745_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042744_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042749_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042739_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042743_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042750_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042761_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042763_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042755_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042757_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042754_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042762_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042752_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042756_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042767_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042765_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042769_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042772_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042770_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042766_0.png treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042776_0.png treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042775_0.png treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042780_0.png treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042782_0.png treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042779_0.png treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042783_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042788_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042728_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042718_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042735_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042730_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042731_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042748_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042740_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042764_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042753_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042784_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042789_0.png treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042777_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042785_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042786_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042723_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042727_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042725_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042726_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042732_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042733_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042738_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042734_0.png treat image : temp/1759533627_79300_1387686005_ea80f18bca36333d07b50f8796c09ed6_rle_crop_3986042729_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042741_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042742_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042760_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042759_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042758_0.png treat image : temp/1759533627_79300_1387685953_d0aad401eaae206503cf3112f03a9b5c_rle_crop_3986042751_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042771_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042773_0.png treat image : temp/1759533627_79300_1387685951_6dd3c85caa67bc7cc19bf7f97d09a7db_rle_crop_3986042768_0.png treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042778_0.png treat image : temp/1759533627_79300_1387685949_9169bf9a83b6e1c7ad3453f3e1468f9b_rle_crop_3986042774_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042787_0.png treat image : temp/1759533627_79300_1387685946_b42d9d747376aa79f2c04ae51a6cf090_rle_crop_3986042790_0.png treat image : temp/1759533627_79300_1387686017_07b5633e6d950fc38f60cff1e2f97cc2_rle_crop_3986042720_0.png treat image : temp/1759533627_79300_1387685998_f49c942322c810d8e70704c95f9be4e6_rle_crop_3986042746_0.png treat image : temp/1759533627_79300_1387685948_1531593aa17475eee27a7cc8d042ff32_rle_crop_3986042781_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 : 81 time used for this insertion : 0.041689157485961914 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 81 time used for this insertion : 0.03761720657348633 save missing photos in datou_result : time spend for datou_step_exec : 8.173985719680786 time spend to save output : 0.0969538688659668 total time spend for step 7 : 8.270939588546753 step8:velours_tree Sat Oct 4 01:24:19 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.13743185997009277 time spend to save output : 5.125999450683594e-05 total time spend for step 8 : 0.1374831199645996 step9:send_mail_cod Sat Oct 4 01:24:19 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_P27507873_04-10-2025_01_24_19.pdf 27508693 change filename to text .change filename to text .change filename to text .imagette275086931759533859 27508694 imagette275086941759533860 27508695 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 .imagette275086951759533860 27508696 imagette275086961759533861 27508697 imagette275086971759533861 27508698 change filename to text .change filename to text .change filename to text .imagette275086981759533861 27508699 imagette275086991759533862 27508700 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 .imagette275087001759533862 27508702 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 .imagette275087021759533864 27508703 imagette275087031759533865 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=27507873 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/27508693,27508694,27508695,27508696,27508697,27508698,27508699,27508700,27508701,27508702,27508703?tags=metal,flou,papier,pehd,pet_fonce,autre,mal_croppe,pet_clair,environnement,carton,background args[1387686017] : ((1387686017, -6.450727755419489, 492609224), (1387686017, 0.26360864372881176, 2107752395), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387686005] : ((1387686005, -6.224491456654126, 492609224), (1387686005, 0.34486199674761264, 2107752395), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387685998] : ((1387685998, -6.147782512495353, 492609224), (1387685998, 0.30133597743578483, 2107752395), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387685953] : ((1387685953, -6.210293605446872, 492609224), (1387685953, 0.3422365113202396, 2107752395), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387685951] : ((1387685951, -5.134049222698141, 492609224), (1387685951, -0.6777007944419605, 501862349), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387685949] : ((1387685949, -4.074401190908372, 492609224), (1387685949, -1.6650074005685582, 501862349), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387685948] : ((1387685948, -4.00406063311292, 492609224), (1387685948, -1.4166953588065183, 501862349), '0.0752230269820602') We are sending mail with results at report@fotonower.com args[1387685946] : ((1387685946, -3.9632476597262296, 492609224), (1387685946, -1.5840720313286412, 501862349), '0.0752230269820602') We are sending mail with results at report@fotonower.com refus_total : 0.0752230269820602 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27507873 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_P27507873_04-10-2025_01_24_19.pdf results_Auto_P27507873_04-10-2025_01_24_19.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27507873_04-10-2025_01_24_19.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','27507873','results_Auto_P27507873_04-10-2025_01_24_19.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27507873_04-10-2025_01_24_19.pdf','pdf','','0.69','0.0752230269820602') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/27507873

https://www.fotonower.com/image?json=false&list_photos_id=1387686017
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387686005
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387685998
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387685953
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387685951
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387685949
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387685948
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1387685946
Bravo, la photo est bien prise.

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

exemples de contaminants: metal: https://www.fotonower.com/view/27508693?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/27508695?limit=200
exemples de contaminants: autre: https://www.fotonower.com/view/27508698?limit=200
exemples de contaminants: pet_clair: https://www.fotonower.com/view/27508700?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/27508702?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27507873_04-10-2025_01_24_19.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/27508693,27508694,27508695,27508696,27508697,27508698,27508699,27508700,27508701,27508702,27508703?tags=metal,flou,papier,pehd,pet_fonce,autre,mal_croppe,pet_clair,environnement,carton,background.


L'équipe Fotonower 202 b'' Server: nginx Date: Fri, 03 Oct 2025 23:24:28 GMT Content-Length: 0 Connection: close X-Message-Id: FynA0XvGQfuGtE6L-CvhTg 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 [1387686017, 1387686005, 1387685998, 1387685953, 1387685951, 1387685949, 1387685948, 1387685946] 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, '3841110') ('3318', '27507873', '1387686017', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387686005', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685998', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685953', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685951', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685949', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685948', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685946', None, None, None, None, None, '3841110') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 8 time used for this insertion : 0.041124582290649414 save_final save missing photos in datou_result : time spend for datou_step_exec : 8.815775632858276 time spend to save output : 0.04131627082824707 total time spend for step 9 : 8.857091903686523 step10:split_time_score Sat Oct 4 01:24:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('20', 8),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 03102025 27507873 Nombre de photos uploadées : 8 / 23040 (0%) 03102025 27507873 Nombre de photos taguées (types de déchets): 0 / 8 (0%) 03102025 27507873 Nombre de photos taguées (volume) : 0 / 8 (0%) elapsed_time : load_data_split_time_score 2.1457672119140625e-06 elapsed_time : order_list_meta_photo_and_scores 5.245208740234375e-06 ???????? elapsed_time : fill_and_build_computed_from_old_data 0.00043964385986328125 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.6398630142211914 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.01748878970893063 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27473887_03-10-2025_07_31_33.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27473887 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473887 AND mptpi.`type`=3726 To do Qualite : 0.04494256855048339 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27480976_03-10-2025_09_51_52.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27480976 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27480976 AND mptpi.`type`=3726 To do Qualite : 0.030411793988759758 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27480980_03-10-2025_09_46_34.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27480980 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27480980 AND mptpi.`type`=3726 To do Qualite : 0.053515633611662276 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27485662_03-10-2025_11_47_00.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27485662 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`=27485662 AND mptpi.`type`=3594 To do Qualite : 0.029711582112811292 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27485667_03-10-2025_11_46_50.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27485667 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27485667 AND mptpi.`type`=3726 To do Qualite : 0.033902186975035185 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27497506_03-10-2025_17_16_36.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27497506 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27497506 AND mptpi.`type`=3726 To do Qualite : 0.04000268576291108 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27499187_03-10-2025_18_51_47.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27499187 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27499187 AND mptpi.`type`=3726 To do Qualite : 0.019924410343238465 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27499190_03-10-2025_18_46_30.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27499190 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27499190 AND mptpi.`type`=3726 To do Qualite : 0.0570101887445339 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27501603_03-10-2025_20_06_52.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27501603 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27501603 AND mptpi.`type`=3726 To do Qualite : 0.0752230269820602 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27507873_04-10-2025_01_24_19.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27507873 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`=27507873 AND mptpi.`type`=3594 To do Qualite : 0.059879681769744605 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27507875_04-10-2025_00_11_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27507875 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27507875 AND mptpi.`type`=3726 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'03102025': {'nb_upload': 8, '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 [1387686017, 1387686005, 1387685998, 1387685953, 1387685951, 1387685949, 1387685948, 1387685946] Looping around the photos to save general results len do output : 1 /27507873Didn'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, '3841110') ('3318', '27507873', '1387686017', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387686005', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685998', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685953', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685951', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685949', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685948', None, None, None, None, None, '3841110') ('3318', None, None, None, None, None, None, None, '3841110') ('3318', '27507873', '1387685946', None, None, None, None, None, '3841110') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.03608250617980957 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.5625596046447754 time spend to save output : 0.036328792572021484 total time spend for step 10 : 3.598888397216797 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 8 set_done_treatment 98.48user 87.74system 4:07.26elapsed 75%CPU (0avgtext+0avgdata 4187616maxresident)k 595808inputs+108648outputs (518major+9716239minor)pagefaults 0swaps