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 : 2226272 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 : ['3988543'] with mtr_portfolio_ids : ['28106454'] and first list_photo_ids : [] new path : /proc/2226272/ 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 , BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 20 ; length of list_pids : 20 ; length of list_args : 20 time to download the photos : 3.451235294342041 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 Mon Nov 3 17:00:33 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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 : 10553 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-11-03 17:00:36.821666: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-11-03 17:00:36.850463: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493010000 Hz 2025-11-03 17:00:36.852643: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f8b4c000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-11-03 17:00:36.852684: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-11-03 17:00:36.857356: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-11-03 17:00:37.037965: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x414b5e70 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-11-03 17:00:37.038028: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-11-03 17:00:37.038929: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-11-03 17:00:37.039426: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-03 17:00:37.043106: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-03 17:00:37.046957: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-03 17:00:37.047544: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-03 17:00:37.051423: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-03 17:00:37.052921: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-03 17:00:37.059887: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-03 17:00:37.061718: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-03 17:00:37.061846: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-03 17:00:37.062822: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-11-03 17:00:37.062845: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-11-03 17:00:37.062855: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-11-03 17:00:37.064932: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9633 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-11-03 17:00:37.499200: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-11-03 17:00:37.499350: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-03 17:00:37.499374: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-03 17:00:37.499395: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-03 17:00:37.499416: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-03 17:00:37.499436: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-03 17:00:37.499455: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-03 17:00:37.499476: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-03 17:00:37.501219: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-03 17:00:37.503147: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-11-03 17:00:37.503223: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-11-03 17:00:37.503243: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-03 17:00:37.503261: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-11-03 17:00:37.503279: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-11-03 17:00:37.503296: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-11-03 17:00:37.503313: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-11-03 17:00:37.503338: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-11-03 17:00:37.504599: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-11-03 17:00:37.504649: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-11-03 17:00:37.504660: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-11-03 17:00:37.504668: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-11-03 17:00:37.505945: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9633 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) Using TensorFlow backend. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:396: calling crop_and_resize_v1 (from tensorflow.python.ops.image_ops_impl) with box_ind is deprecated and will be removed in a future version. Instructions for updating: box_ind is deprecated, use box_indices instead WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:703: to_int32 (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. WARNING:tensorflow:From /home/admin/workarea/install/Mask_RCNN/model.py:729: to_float (from tensorflow.python.ops.math_ops) is deprecated and will be removed in a future version. Instructions for updating: Use `tf.cast` instead. Inside mask_sub_process Inside mask_detect About to load cache.load_thcl_param To do loadFromThcl(), then load ParamDescType : thcl2847 thcls : [{'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}] thcl {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5275 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5275, 'learn_RUBBIA_REFUS_AMIENS_23', 16384, 25088, 'learn_RUBBIA_REFUS_AMIENS_23', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 23, 14, 19, 39), datetime.datetime(2021, 4, 23, 14, 19, 39)) {'thcl': {'id': 2847, 'mtr_user_id': 31, 'name': 'learn_RUBBIA_REFUS_AMIENS_23', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'photo_desc_type': 5275, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'], 'list_hashtags_csv': 'background,papier,carton,metal,pet_clair,autre,pehd,pet_fonce,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3594, 'svm_hashtag_type_desc': 5275, 'photo_desc_type': 5275, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'papier', 'carton', 'metal', 'pet_clair', 'autre', 'pehd', 'pet_fonce', 'environnement'] Configurations: BACKBONE resnet101 BACKBONE_SHAPES [[160 160] [ 80 80] [ 40 40] [ 20 20] [ 10 10]] BACKBONE_STRIDES [4, 8, 16, 32, 64] BATCH_SIZE 1 BBOX_STD_DEV [0.1 0.1 0.2 0.2] DETECTION_MAX_INSTANCES 100 DETECTION_MIN_CONFIDENCE 0.3 DETECTION_NMS_THRESHOLD 0.3 GPU_COUNT 1 IMAGES_PER_GPU 1 IMAGE_MAX_DIM 640 IMAGE_MIN_DIM 640 IMAGE_PADDING True IMAGE_SHAPE [640 640 3] LEARNING_MOMENTUM 0.9 LEARNING_RATE 0.001 LOSS_WEIGHTS {'rpn_class_loss': 1.0, 'rpn_bbox_loss': 1.0, 'mrcnn_class_loss': 1.0, 'mrcnn_bbox_loss': 1.0, 'mrcnn_mask_loss': 1.0} MASK_POOL_SIZE 14 MASK_SHAPE [28, 28] MAX_GT_INSTANCES 100 MEAN_PIXEL [123.7 116.8 103.9] MINI_MASK_SHAPE (56, 56) NAME learn_RUBBIA_REFUS_AMIENS_23 NUM_CLASSES 9 POOL_SIZE 7 POST_NMS_ROIS_INFERENCE 1000 POST_NMS_ROIS_TRAINING 2000 ROI_POSITIVE_RATIO 0.33 RPN_ANCHOR_RATIOS [0.5, 1, 2] RPN_ANCHOR_SCALES (16, 32, 64, 128, 256) RPN_ANCHOR_STRIDE 1 RPN_BBOX_STD_DEV [0.1 0.1 0.2 0.2] RPN_NMS_THRESHOLD 0.7 RPN_TRAIN_ANCHORS_PER_IMAGE 256 STEPS_PER_EPOCH 1000 TRAIN_ROIS_PER_IMAGE 200 USE_MINI_MASK True USE_RPN_ROIS True VALIDATION_STEPS 50 WEIGHT_DECAY 0.0001 model_param file didn't exist model_name : learn_RUBBIA_REFUS_AMIENS_23 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-11-03 17:00:47.788934: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-11-03 17:00:48.052536: 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 : 20 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 44.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 9 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 34.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 35.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 25.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 41.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 40.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 9 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 52.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 51.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 26.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 49.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 37.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 46.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 33.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 2 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 40.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 2 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 24.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 41.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 57.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 2 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 43.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 56.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 3) min: 50.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 17) min: 0.00000 max: 1920.00000 nb d'objets trouves : 3 Detection mask done ! Trying to reset tf kernel 2227028 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 294 tf kernel not reseted sub process len(results) : 20 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 20 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 : 5583 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.0003814697265625 nb_pixel_total : 3958 time to create 1 rle with old method : 0.0049245357513427734 length of segment : 114 time for calcul the mask position with numpy : 0.0005381107330322266 nb_pixel_total : 9478 time to create 1 rle with old method : 0.011184930801391602 length of segment : 190 time for calcul the mask position with numpy : 0.046234130859375 nb_pixel_total : 884313 time to create 1 rle with new method : 0.08308053016662598 length of segment : 1858 time for calcul the mask position with numpy : 0.0003731250762939453 nb_pixel_total : 9555 time to create 1 rle with old method : 0.011562347412109375 length of segment : 118 time for calcul the mask position with numpy : 0.00022602081298828125 nb_pixel_total : 3595 time to create 1 rle with old method : 0.004428386688232422 length of segment : 86 time for calcul the mask position with numpy : 0.00019502639770507812 nb_pixel_total : 3275 time to create 1 rle with old method : 0.004204750061035156 length of segment : 78 time for calcul the mask position with numpy : 0.0004153251647949219 nb_pixel_total : 13493 time to create 1 rle with old method : 0.016361474990844727 length of segment : 141 time for calcul the mask position with numpy : 0.009553909301757812 nb_pixel_total : 487105 time to create 1 rle with new method : 0.08234930038452148 length of segment : 1104 time for calcul the mask position with numpy : 0.00031638145446777344 nb_pixel_total : 3670 time to create 1 rle with old method : 0.004413604736328125 length of segment : 89 time for calcul the mask position with numpy : 0.0002944469451904297 nb_pixel_total : 7521 time to create 1 rle with old method : 0.008970499038696289 length of segment : 69 time for calcul the mask position with numpy : 0.0002110004425048828 nb_pixel_total : 2951 time to create 1 rle with old method : 0.003662586212158203 length of segment : 64 time for calcul the mask position with numpy : 0.00021266937255859375 nb_pixel_total : 3721 time to create 1 rle with old method : 0.004332304000854492 length of segment : 96 time for calcul the mask position with numpy : 0.0001316070556640625 nb_pixel_total : 2199 time to create 1 rle with old method : 0.0028591156005859375 length of segment : 46 time for calcul the mask position with numpy : 0.00026154518127441406 nb_pixel_total : 5048 time to create 1 rle with old method : 0.006371259689331055 length of segment : 89 time for calcul the mask position with numpy : 0.0002734661102294922 nb_pixel_total : 3180 time to create 1 rle with old method : 0.004154682159423828 length of segment : 93 time for calcul the mask position with numpy : 0.0008370876312255859 nb_pixel_total : 22902 time to create 1 rle with old method : 0.02786111831665039 length of segment : 246 time for calcul the mask position with numpy : 0.0003464221954345703 nb_pixel_total : 7126 time to create 1 rle with old method : 0.00846552848815918 length of segment : 136 time for calcul the mask position with numpy : 0.00015401840209960938 nb_pixel_total : 3118 time to create 1 rle with old method : 0.0037412643432617188 length of segment : 79 time for calcul the mask position with numpy : 0.0004000663757324219 nb_pixel_total : 6724 time to create 1 rle with old method : 0.00790095329284668 length of segment : 167 time for calcul the mask position with numpy : 0.00036263465881347656 nb_pixel_total : 5781 time to create 1 rle with old method : 0.006882905960083008 length of segment : 175 time for calcul the mask position with numpy : 0.00019979476928710938 nb_pixel_total : 7067 time to create 1 rle with old method : 0.008468389511108398 length of segment : 66 time for calcul the mask position with numpy : 0.0004260540008544922 nb_pixel_total : 8830 time to create 1 rle with old method : 0.01036977767944336 length of segment : 132 time for calcul the mask position with numpy : 0.0187530517578125 nb_pixel_total : 975954 time to create 1 rle with new method : 0.04992318153381348 length of segment : 1041 time for calcul the mask position with numpy : 0.0001533031463623047 nb_pixel_total : 6256 time to create 1 rle with old method : 0.007299184799194336 length of segment : 100 time for calcul the mask position with numpy : 0.00020074844360351562 nb_pixel_total : 5419 time to create 1 rle with old method : 0.00634765625 length of segment : 84 time for calcul the mask position with numpy : 0.00019693374633789062 nb_pixel_total : 6613 time to create 1 rle with old method : 0.007623195648193359 length of segment : 67 time for calcul the mask position with numpy : 0.00010752677917480469 nb_pixel_total : 3946 time to create 1 rle with old method : 0.004662513732910156 length of segment : 66 time for calcul the mask position with numpy : 0.00014281272888183594 nb_pixel_total : 2633 time to create 1 rle with old method : 0.003172159194946289 length of segment : 61 time for calcul the mask position with numpy : 0.012485027313232422 nb_pixel_total : 681719 time to create 1 rle with new method : 0.0472407341003418 length of segment : 986 time for calcul the mask position with numpy : 0.0023279190063476562 nb_pixel_total : 77359 time to create 1 rle with old method : 0.08496952056884766 length of segment : 467 time for calcul the mask position with numpy : 0.0004355907440185547 nb_pixel_total : 4708 time to create 1 rle with old method : 0.00583195686340332 length of segment : 118 time for calcul the mask position with numpy : 0.00025773048400878906 nb_pixel_total : 5110 time to create 1 rle with old method : 0.006535768508911133 length of segment : 70 time for calcul the mask position with numpy : 0.0002980232238769531 nb_pixel_total : 6940 time to create 1 rle with old method : 0.008465766906738281 length of segment : 195 time for calcul the mask position with numpy : 0.00012683868408203125 nb_pixel_total : 2187 time to create 1 rle with old method : 0.0029134750366210938 length of segment : 34 time for calcul the mask position with numpy : 0.0004069805145263672 nb_pixel_total : 7782 time to create 1 rle with old method : 0.009308815002441406 length of segment : 191 time spent for convertir_results : 2.243849515914917 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 35 chid ids of type : 3594 Number RLEs to save : 8716 save missing photos in datou_result : time spend for datou_step_exec : 33.29634737968445 time spend to save output : 0.6950516700744629 total time spend for step 1 : 33.99139904975891 step2:crop_condition Mon Nov 3 17:01:07 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : 20 ! batch 1 Loaded 35 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 ! map_result returned by crop_photo_return_map_crop : length : 23 About to insert : list_path_to_insert length 23 new photo from crops ! About to upload 23 photos upload in portfolio : 3736932 init cache_photo without model_param we have 23 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1762185671_2226272 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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796212_0.png', 0, 71, 190, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796211_0.png', 0, 73, 114, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796216_0.png', 0, 74, 78, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796214_0.png', 0, 109, 114, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821_rle_crop_4016796218_0.png', 0, 895, 970, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821_rle_crop_4016796217_0.png', 0, 140, 133, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107386_e8adc61537748eea93b2f2ff80ca18d2_rle_crop_4016796219_0.png', 0, 86, 89, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796222_0.png', 0, 57, 93, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796220_0.png', 0, 155, 69, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796221_0.png', 0, 92, 64, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796223_0.png', 0, 63, 44, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7_rle_crop_4016796224_0.png', 0, 92, 89, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7_rle_crop_4016796225_0.png', 0, 92, 93, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796229_0.png', 0, 80, 166, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796226_0.png', 0, 151, 229, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796228_0.png', 0, 66, 79, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6_rle_crop_4016796230_0.png', 0, 77, 156, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6_rle_crop_4016796231_0.png', 0, 148, 66, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107378_f5131447fdbae35f5b4fb0ab0c386384_rle_crop_4016796235_0.png', 0, 95, 81, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0_rle_crop_4016796238_0.png', 0, 67, 61, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107370_601112bfb7ade4b13499618aae5f374a_rle_crop_4016796241_0.png', 0, 96, 118, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796242_0.png', 0, 128, 70, 0, 1762185675,'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(1762185675), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107367_8de3dc4813eaf41702e451db1284ec8b_rle_crop_4016796245_0.png', 0, 99, 177, 0, 1762185675,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 23 photos in the portfolio 3736932 time of upload the photos Elapsed time : 5.875925540924072 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 ! 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/1762185680_2226272 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(1762185680), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796215_0.png', 0, 56, 86, 0, 1762185680,'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(1762185680), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796232_0.png', 0, 126, 132, 0, 1762185680,'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(1762185680), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0_rle_crop_4016796239_0.png', 0, 952, 985, 0, 1762185680,'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 : 0.9684739112854004 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! 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 : 9 About to insert : list_path_to_insert length 9 new photo from crops ! About to upload 9 photos upload in portfolio : 3736932 init cache_photo without model_param we have 9 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1762185689_2226272 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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796213_0.png', 0, 1205, 990, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796227_0.png', 0, 72, 136, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796233_0.png', 0, 1208, 1012, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796234_0.png', 0, 90, 87, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90_rle_crop_4016796236_0.png', 0, 122, 66, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90_rle_crop_4016796237_0.png', 0, 76, 65, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107372_d65a9981d213b00bb39796dfe49f39e1_rle_crop_4016796240_0.png', 0, 313, 437, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796243_0.png', 0, 79, 141, 0, 1762185691,'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(1762185691), 0.0, 0.0, 14, '', 0, 0, '1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796244_0.png', 0, 75, 33, 0, 1762185691,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 9 photos in the portfolio 3736932 time of upload the photos Elapsed time : 2.2907555103302 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles 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 [1390107403, 1390107402, 1390107399, 1390107398, 1390107386, 1390107385, 1390107384, 1390107383, 1390107382, 1390107379, 1390107378, 1390107376, 1390107375, 1390107374, 1390107373, 1390107372, 1390107371, 1390107370, 1390107369, 1390107367] Looping around the photos to save general results len do output : 35 /1392089302Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089303Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089304Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089305Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089306Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089307Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089308Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089309Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089310Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089311Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089312Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089313Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089314Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089315Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089316Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089317Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089318Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089319Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089320Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089321Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089322Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089323Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089324Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089386Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089387Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089389Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089483Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089484Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089486Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089487Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089488Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089490Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089491Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089492Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1392089494Didn'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, '3988543') ('3318', '28106454', '1390107403', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107402', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107399', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107398', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107386', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107385', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107384', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107383', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107382', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107379', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107378', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107376', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107375', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107374', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107373', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107372', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107371', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107370', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107369', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107367', None, None, None, None, None, '3988543') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 125 time used for this insertion : 0.031065702438354492 save_final save missing photos in datou_result : time spend for datou_step_exec : 24.048688411712646 time spend to save output : 0.03282308578491211 total time spend for step 2 : 24.08151149749756 step3:rle_unique_nms_with_priority Mon Nov 3 17:01:31 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array 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 35 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.634406328201294 time for calcul the mask position with numpy : 0.04258847236633301 nb_pixel_total : 1183935 time to create 1 rle with new method : 0.3157024383544922 time for calcul the mask position with numpy : 0.04420876502990723 nb_pixel_total : 876229 time to create 1 rle with new method : 0.11752080917358398 time for calcul the mask position with numpy : 0.006924629211425781 nb_pixel_total : 9478 time to create 1 rle with old method : 0.011012554168701172 time for calcul the mask position with numpy : 0.006537675857543945 nb_pixel_total : 3958 time to create 1 rle with old method : 0.004601478576660156 create new chi : 0.5667624473571777 time to delete rle : 0.030190706253051758 batch 1 Loaded 7 chid ids of type : 3594 ++++Number RLEs to save : 5302 TO DO : save crop sub photo not yet done ! save time : 0.36225461959838867 No data in photo_id : 1390107402 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.13791799545288086 time for calcul the mask position with numpy : 0.09017562866210938 nb_pixel_total : 2057175 time to create 1 rle with new method : 0.08424806594848633 time for calcul the mask position with numpy : 0.008423805236816406 nb_pixel_total : 3275 time to create 1 rle with old method : 0.005535602569580078 time for calcul the mask position with numpy : 0.008782148361206055 nb_pixel_total : 3595 time to create 1 rle with old method : 0.006034135818481445 time for calcul the mask position with numpy : 0.007942914962768555 nb_pixel_total : 9555 time to create 1 rle with old method : 0.01580953598022461 create new chi : 0.24193835258483887 time to delete rle : 0.0005259513854980469 batch 1 Loaded 7 chid ids of type : 3594 +++Number RLEs to save : 1644 TO DO : save crop sub photo not yet done ! save time : 0.14955735206604004 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04922032356262207 time for calcul the mask position with numpy : 0.2530496120452881 nb_pixel_total : 1574294 time to create 1 rle with new method : 0.0865774154663086 time for calcul the mask position with numpy : 0.009552478790283203 nb_pixel_total : 485813 time to create 1 rle with new method : 0.2951021194458008 time for calcul the mask position with numpy : 0.006583213806152344 nb_pixel_total : 13493 time to create 1 rle with old method : 0.015938282012939453 create new chi : 0.6752896308898926 time to delete rle : 0.0004799365997314453 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 3460 TO DO : save crop sub photo not yet done ! save time : 0.2428581714630127 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.043039560317993164 time for calcul the mask position with numpy : 0.1934971809387207 nb_pixel_total : 2069930 time to create 1 rle with new method : 0.225846529006958 time for calcul the mask position with numpy : 0.006507396697998047 nb_pixel_total : 3670 time to create 1 rle with old method : 0.004328727722167969 create new chi : 0.4407837390899658 time to delete rle : 0.00020503997802734375 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1258 TO DO : save crop sub photo not yet done ! save time : 0.11883425712585449 nb_obj : 4 nb_hashtags : 1 time to prepare the origin masks : 0.3432278633117676 time for calcul the mask position with numpy : 0.28130578994750977 nb_pixel_total : 2057208 time to create 1 rle with new method : 0.35753726959228516 time for calcul the mask position with numpy : 0.006368398666381836 nb_pixel_total : 2199 time to create 1 rle with old method : 0.0026330947875976562 time for calcul the mask position with numpy : 0.006350517272949219 nb_pixel_total : 3721 time to create 1 rle with old method : 0.0044040679931640625 time for calcul the mask position with numpy : 0.0066454410552978516 nb_pixel_total : 2951 time to create 1 rle with old method : 0.0035164356231689453 time for calcul the mask position with numpy : 0.006743669509887695 nb_pixel_total : 7521 time to create 1 rle with old method : 0.009023666381835938 create new chi : 0.6950397491455078 time to delete rle : 0.0002827644348144531 batch 1 Loaded 9 chid ids of type : 3594 ++++Number RLEs to save : 1630 TO DO : save crop sub photo not yet done ! save time : 0.15230751037597656 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04501509666442871 time for calcul the mask position with numpy : 0.021845102310180664 nb_pixel_total : 2065372 time to create 1 rle with new method : 0.30731987953186035 time for calcul the mask position with numpy : 0.0074329376220703125 nb_pixel_total : 3180 time to create 1 rle with old method : 0.003831148147583008 time for calcul the mask position with numpy : 0.00702357292175293 nb_pixel_total : 5048 time to create 1 rle with old method : 0.005812644958496094 create new chi : 0.362415075302124 time to delete rle : 0.00035071372985839844 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1444 TO DO : save crop sub photo not yet done ! save time : 0.12666845321655273 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.0942380428314209 time for calcul the mask position with numpy : 0.3597395420074463 nb_pixel_total : 2033730 time to create 1 rle with new method : 0.08127617835998535 time for calcul the mask position with numpy : 0.006678581237792969 nb_pixel_total : 6724 time to create 1 rle with old method : 0.010001420974731445 time for calcul the mask position with numpy : 0.006098508834838867 nb_pixel_total : 3118 time to create 1 rle with old method : 0.003654956817626953 time for calcul the mask position with numpy : 0.006313323974609375 nb_pixel_total : 7126 time to create 1 rle with old method : 0.00814962387084961 time for calcul the mask position with numpy : 0.006656646728515625 nb_pixel_total : 22902 time to create 1 rle with old method : 0.026453256607055664 create new chi : 0.525566577911377 time to delete rle : 0.0003581047058105469 batch 1 Loaded 9 chid ids of type : 3594 ++++Number RLEs to save : 2336 TO DO : save crop sub photo not yet done ! save time : 0.19328618049621582 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04427742958068848 time for calcul the mask position with numpy : 0.020242691040039062 nb_pixel_total : 2060752 time to create 1 rle with new method : 0.2865138053894043 time for calcul the mask position with numpy : 0.0065517425537109375 nb_pixel_total : 7067 time to create 1 rle with old method : 0.008426666259765625 time for calcul the mask position with numpy : 0.006481170654296875 nb_pixel_total : 5781 time to create 1 rle with old method : 0.006850719451904297 create new chi : 0.34207868576049805 time to delete rle : 0.0002853870391845703 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1562 TO DO : save crop sub photo not yet done ! save time : 0.14446067810058594 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.049529314041137695 time for calcul the mask position with numpy : 0.013948678970336914 nb_pixel_total : 1097646 time to create 1 rle with new method : 0.3647592067718506 time for calcul the mask position with numpy : 0.013674259185791016 nb_pixel_total : 967124 time to create 1 rle with new method : 0.16057181358337402 time for calcul the mask position with numpy : 0.006339311599731445 nb_pixel_total : 8830 time to create 1 rle with old method : 0.010438919067382812 create new chi : 0.5884182453155518 time to delete rle : 0.0004906654357910156 batch 1 Loaded 6 chid ids of type : 3594 +++Number RLEs to save : 3426 TO DO : save crop sub photo not yet done ! save time : 0.26839566230773926 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.07880854606628418 time for calcul the mask position with numpy : 0.059366703033447266 nb_pixel_total : 2068181 time to create 1 rle with new method : 0.31986260414123535 time for calcul the mask position with numpy : 0.006620645523071289 nb_pixel_total : 5419 time to create 1 rle with old method : 0.00640416145324707 create new chi : 0.40157103538513184 time to delete rle : 0.0002522468566894531 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1248 TO DO : save crop sub photo not yet done ! save time : 0.11505413055419922 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.04360175132751465 time for calcul the mask position with numpy : 0.2862720489501953 nb_pixel_total : 2063041 time to create 1 rle with new method : 0.35021042823791504 time for calcul the mask position with numpy : 0.007344722747802734 nb_pixel_total : 3946 time to create 1 rle with old method : 0.005474567413330078 time for calcul the mask position with numpy : 0.0074880123138427734 nb_pixel_total : 6613 time to create 1 rle with old method : 0.007886171340942383 create new chi : 0.6756136417388916 time to delete rle : 0.00041413307189941406 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 1346 TO DO : save crop sub photo not yet done ! save time : 0.13291120529174805 No data in photo_id : 1390107375 No data in photo_id : 1390107374 nb_obj : 2 nb_hashtags : 2 time to prepare the origin masks : 0.14542603492736816 time for calcul the mask position with numpy : 0.05167841911315918 nb_pixel_total : 1389248 time to create 1 rle with new method : 0.8369362354278564 time for calcul the mask position with numpy : 0.01447153091430664 nb_pixel_total : 681719 time to create 1 rle with new method : 0.4777047634124756 time for calcul the mask position with numpy : 0.0061419010162353516 nb_pixel_total : 2633 time to create 1 rle with old method : 0.0031409263610839844 create new chi : 1.3995680809020996 time to delete rle : 0.00048732757568359375 batch 1 Loaded 5 chid ids of type : 3594 ++Number RLEs to save : 3174 TO DO : save crop sub photo not yet done ! save time : 0.2443084716796875 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.042098045349121094 time for calcul the mask position with numpy : 0.5767147541046143 nb_pixel_total : 1996241 time to create 1 rle with new method : 0.13470220565795898 time for calcul the mask position with numpy : 0.006911039352416992 nb_pixel_total : 77359 time to create 1 rle with old method : 0.08979463577270508 create new chi : 0.8182706832885742 time to delete rle : 0.0003871917724609375 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 2014 TO DO : save crop sub photo not yet done ! save time : 0.1931619644165039 No data in photo_id : 1390107371 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.034264564514160156 time for calcul the mask position with numpy : 0.21643328666687012 nb_pixel_total : 2068892 time to create 1 rle with new method : 0.08365631103515625 time for calcul the mask position with numpy : 0.006764650344848633 nb_pixel_total : 4708 time to create 1 rle with old method : 0.005599260330200195 create new chi : 0.32381629943847656 time to delete rle : 0.0002772808074951172 batch 1 Loaded 3 chid ids of type : 3594 +Number RLEs to save : 1316 TO DO : save crop sub photo not yet done ! save time : 0.11955547332763672 nb_obj : 3 nb_hashtags : 2 time to prepare the origin masks : 0.7315118312835693 time for calcul the mask position with numpy : 0.08128547668457031 nb_pixel_total : 2059363 time to create 1 rle with new method : 0.9565527439117432 time for calcul the mask position with numpy : 0.006569385528564453 nb_pixel_total : 2187 time to create 1 rle with old method : 0.002614259719848633 time for calcul the mask position with numpy : 0.0063669681549072266 nb_pixel_total : 6940 time to create 1 rle with old method : 0.008188724517822266 time for calcul the mask position with numpy : 0.006483793258666992 nb_pixel_total : 5110 time to create 1 rle with old method : 0.006045341491699219 create new chi : 1.0860531330108643 time to delete rle : 0.00030541419982910156 batch 1 Loaded 7 chid ids of type : 3594 ++++++Number RLEs to save : 1678 TO DO : save crop sub photo not yet done ! save time : 0.13808655738830566 nb_obj : 1 nb_hashtags : 1 time to prepare the origin masks : 0.04037904739379883 time for calcul the mask position with numpy : 0.026795387268066406 nb_pixel_total : 2065818 time to create 1 rle with new method : 0.6131830215454102 time for calcul the mask position with numpy : 0.006660938262939453 nb_pixel_total : 7782 time to create 1 rle with old method : 0.009161233901977539 create new chi : 0.6633405685424805 time to delete rle : 0.0002598762512207031 batch 1 Loaded 3 chid ids of type : 3594 ++Number RLEs to save : 1462 TO DO : save crop sub photo not yet done ! save time : 0.1461496353149414 map_output_result : {1390107403: (0.0, 'Should be the crop_list due to order', 0), 1390107402: (0.0, 'Should be the crop_list due to order', 0.0), 1390107399: (0.0, 'Should be the crop_list due to order', 0), 1390107398: (0.0, 'Should be the crop_list due to order', 0), 1390107386: (0.0, 'Should be the crop_list due to order', 0), 1390107385: (0.0, 'Should be the crop_list due to order', 0), 1390107384: (0.0, 'Should be the crop_list due to order', 0), 1390107383: (0.0, 'Should be the crop_list due to order', 0), 1390107382: (0.0, 'Should be the crop_list due to order', 0), 1390107379: (0.0, 'Should be the crop_list due to order', 0), 1390107378: (0.0, 'Should be the crop_list due to order', 0), 1390107376: (0.0, 'Should be the crop_list due to order', 0), 1390107375: (0.0, 'Should be the crop_list due to order', 0.0), 1390107374: (0.0, 'Should be the crop_list due to order', 0.0), 1390107373: (0.0, 'Should be the crop_list due to order', 0), 1390107372: (0.0, 'Should be the crop_list due to order', 0), 1390107371: (0.0, 'Should be the crop_list due to order', 0.0), 1390107370: (0.0, 'Should be the crop_list due to order', 0), 1390107369: (0.0, 'Should be the crop_list due to order', 0), 1390107367: (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 [1390107403, 1390107402, 1390107399, 1390107398, 1390107386, 1390107385, 1390107384, 1390107383, 1390107382, 1390107379, 1390107378, 1390107376, 1390107375, 1390107374, 1390107373, 1390107372, 1390107371, 1390107370, 1390107369, 1390107367] Looping around the photos to save general results len do output : 20 /1390107403.Didn't retrieve data . /1390107402.Didn't retrieve data . /1390107399.Didn't retrieve data . /1390107398.Didn't retrieve data . /1390107386.Didn't retrieve data . /1390107385.Didn't retrieve data . /1390107384.Didn't retrieve data . /1390107383.Didn't retrieve data . /1390107382.Didn't retrieve data . /1390107379.Didn't retrieve data . /1390107378.Didn't retrieve data . /1390107376.Didn't retrieve data . /1390107375.Didn't retrieve data . /1390107374.Didn't retrieve data . /1390107373.Didn't retrieve data . /1390107372.Didn't retrieve data . /1390107371.Didn't retrieve data . /1390107370.Didn't retrieve data . /1390107369.Didn't retrieve data . /1390107367.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, '3988543') ('3318', '28106454', '1390107403', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107402', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107399', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107398', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107386', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107385', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107384', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107383', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107382', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107379', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107378', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107376', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107375', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107374', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107373', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107372', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107371', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107370', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107369', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107367', None, None, None, None, None, '3988543') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 60 time used for this insertion : 0.015915632247924805 save_final save missing photos in datou_result : time spend for datou_step_exec : 15.755388021469116 time spend to save output : 0.01651740074157715 total time spend for step 3 : 15.771905422210693 step4:ventilate_hashtags_in_portfolio Mon Nov 3 17:01:47 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step ventilate_hashtags_in_portfolio : To implement ! Iterating over portfolio : 28106454 get user id for portfolio 28106454 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`=28106454 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','autre','metal','background','pehd','papier','pet_fonce','flou','mal_croppe','environnement','carton')) 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`=28106454 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','autre','metal','background','pehd','papier','pet_fonce','flou','mal_croppe','environnement','carton')) 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`=28106454 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','autre','metal','background','pehd','papier','pet_fonce','flou','mal_croppe','environnement','carton')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/28106552,28106553,28106554,28106555,28106556,28106557,28106558,28106559,28106560,28106561,28106562?tags=pet_clair,autre,metal,background,pehd,papier,pet_fonce,flou,mal_croppe,environnement,carton Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1390107403, 1390107402, 1390107399, 1390107398, 1390107386, 1390107385, 1390107384, 1390107383, 1390107382, 1390107379, 1390107378, 1390107376, 1390107375, 1390107374, 1390107373, 1390107372, 1390107371, 1390107370, 1390107369, 1390107367] Looping around the photos to save general results len do output : 1 /28106454. 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, '3988543') ('3318', '28106454', '1390107403', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107402', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107399', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107398', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107386', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107385', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107384', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107383', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107382', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107379', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107378', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107376', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107375', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107374', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107373', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107372', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107371', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107370', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107369', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107367', None, None, None, None, None, '3988543') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 21 time used for this insertion : 0.02069234848022461 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.7475264072418213 time spend to save output : 0.02104663848876953 total time spend for step 4 : 1.7685730457305908 step5:final Mon Nov 3 17:01:49 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 2 VR 22-3-18 : For now we do not clean correctly the datou structure Beginning of datou step final ! Catched exception ! Connect or reconnect ! Inside saveOutput : final : False verbose : 0 original output for save of step final : {1390107403: ('0.07877059220679013',), 1390107402: ('0.07877059220679013',), 1390107399: ('0.07877059220679013',), 1390107398: ('0.07877059220679013',), 1390107386: ('0.07877059220679013',), 1390107385: ('0.07877059220679013',), 1390107384: ('0.07877059220679013',), 1390107383: ('0.07877059220679013',), 1390107382: ('0.07877059220679013',), 1390107379: ('0.07877059220679013',), 1390107378: ('0.07877059220679013',), 1390107376: ('0.07877059220679013',), 1390107375: ('0.07877059220679013',), 1390107374: ('0.07877059220679013',), 1390107373: ('0.07877059220679013',), 1390107372: ('0.07877059220679013',), 1390107371: ('0.07877059220679013',), 1390107370: ('0.07877059220679013',), 1390107369: ('0.07877059220679013',), 1390107367: ('0.07877059220679013',)} new output for save of step final : {1390107403: ('0.07877059220679013',), 1390107402: ('0.07877059220679013',), 1390107399: ('0.07877059220679013',), 1390107398: ('0.07877059220679013',), 1390107386: ('0.07877059220679013',), 1390107385: ('0.07877059220679013',), 1390107384: ('0.07877059220679013',), 1390107383: ('0.07877059220679013',), 1390107382: ('0.07877059220679013',), 1390107379: ('0.07877059220679013',), 1390107378: ('0.07877059220679013',), 1390107376: ('0.07877059220679013',), 1390107375: ('0.07877059220679013',), 1390107374: ('0.07877059220679013',), 1390107373: ('0.07877059220679013',), 1390107372: ('0.07877059220679013',), 1390107371: ('0.07877059220679013',), 1390107370: ('0.07877059220679013',), 1390107369: ('0.07877059220679013',), 1390107367: ('0.07877059220679013',)} [1390107403, 1390107402, 1390107399, 1390107398, 1390107386, 1390107385, 1390107384, 1390107383, 1390107382, 1390107379, 1390107378, 1390107376, 1390107375, 1390107374, 1390107373, 1390107372, 1390107371, 1390107370, 1390107369, 1390107367] Looping around the photos to save general results len do output : 20 /1390107403.Didn't retrieve data . /1390107402.Didn't retrieve data . /1390107399.Didn't retrieve data . /1390107398.Didn't retrieve data . /1390107386.Didn't retrieve data . /1390107385.Didn't retrieve data . /1390107384.Didn't retrieve data . /1390107383.Didn't retrieve data . /1390107382.Didn't retrieve data . /1390107379.Didn't retrieve data . /1390107378.Didn't retrieve data . /1390107376.Didn't retrieve data . /1390107375.Didn't retrieve data . /1390107374.Didn't retrieve data . /1390107373.Didn't retrieve data . /1390107372.Didn't retrieve data . /1390107371.Didn't retrieve data . /1390107370.Didn't retrieve data . /1390107369.Didn't retrieve data . /1390107367.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, '3988543') ('3318', '28106454', '1390107403', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107402', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107399', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107398', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107386', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107385', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107384', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107383', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107382', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107379', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107378', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107376', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107375', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107374', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107373', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107372', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107371', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107370', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107369', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107367', None, None, None, None, None, '3988543') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 60 time used for this insertion : 0.019359111785888672 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.12464594841003418 time spend to save output : 0.020188093185424805 total time spend for step 5 : 0.14483404159545898 step6:blur_detection Mon Nov 3 17:01:49 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step blur_detection methode: ratio et variance treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d.jpg resize: (1080, 1920) 1390107403 0.37849426494354615 treat image : temp/1762185630_2226272_1390107402_71e5d9f2b492b13eb419e6b30c09e735.jpg resize: (1080, 1920) 1390107402 0.9666924965518177 treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0.jpg resize: (1080, 1920) 1390107399 0.5532462700905292 treat image : temp/1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821.jpg resize: (1080, 1920) 1390107398 -1.6467498849940116 treat image : temp/1762185630_2226272_1390107386_e8adc61537748eea93b2f2ff80ca18d2.jpg resize: (1080, 1920) 1390107386 -0.2750528918092419 treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1.jpg resize: (1080, 1920) 1390107385 -4.344743024275763 treat image : temp/1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7.jpg resize: (1080, 1920) 1390107384 0.7277102842935548 treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0.jpg resize: (1080, 1920) 1390107383 -3.059904270326093 treat image : temp/1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6.jpg resize: (1080, 1920) 1390107382 -4.507195430163205 treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c.jpg resize: (1080, 1920) 1390107379 -0.1056628146917875 treat image : temp/1762185630_2226272_1390107378_f5131447fdbae35f5b4fb0ab0c386384.jpg resize: (1080, 1920) 1390107378 -3.9212810284045503 treat image : temp/1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90.jpg resize: (1080, 1920) 1390107376 0.1994837940716366 treat image : temp/1762185630_2226272_1390107375_e995b1162e65d9ba97106a7f5f5417cd.jpg resize: (1080, 1920) 1390107375 -4.3329619112008695 treat image : temp/1762185630_2226272_1390107374_fd36dbfd519e4d37a84ae61a201c7276.jpg resize: (1080, 1920) 1390107374 -0.21709382320732404 treat image : temp/1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0.jpg resize: (1080, 1920) 1390107373 0.1701247297172927 treat image : temp/1762185630_2226272_1390107372_d65a9981d213b00bb39796dfe49f39e1.jpg resize: (1080, 1920) 1390107372 0.2176819522948708 treat image : temp/1762185630_2226272_1390107371_2d1b13f5619b6000603af68e5aeffda3.jpg resize: (1080, 1920) 1390107371 -0.7156728750892103 treat image : temp/1762185630_2226272_1390107370_601112bfb7ade4b13499618aae5f374a.jpg resize: (1080, 1920) 1390107370 0.04536927994382289 treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea.jpg resize: (1080, 1920) 1390107369 0.6671903045372165 treat image : temp/1762185630_2226272_1390107367_8de3dc4813eaf41702e451db1284ec8b.jpg resize: (1080, 1920) 1390107367 0.4286565094047165 treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796212_0.png resize: (190, 71) 1392089302 -0.8389961010653942 treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796211_0.png resize: (114, 73) 1392089303 -2.098631723783208 treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796216_0.png resize: (78, 74) 1392089304 -3.4851363655856353 treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796214_0.png resize: (114, 109) 1392089305 4.069235685234788 treat image : temp/1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821_rle_crop_4016796218_0.png resize: (970, 895) 1392089306 -1.1115188972610635 treat image : temp/1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821_rle_crop_4016796217_0.png resize: (133, 140) 1392089307 -0.4620440968644052 treat image : temp/1762185630_2226272_1390107386_e8adc61537748eea93b2f2ff80ca18d2_rle_crop_4016796219_0.png resize: (89, 86) 1392089308 -1.4474839524195202 treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796222_0.png resize: (93, 57) 1392089309 -4.017334306184596 treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796220_0.png resize: (69, 155) 1392089310 -2.284574005135494 treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796221_0.png resize: (64, 92) 1392089311 -3.3880367408305427 treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796223_0.png resize: (44, 63) 1392089312 -3.056424225056634 treat image : temp/1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7_rle_crop_4016796224_0.png resize: (89, 92) 1392089313 -2.245294715426036 treat image : temp/1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7_rle_crop_4016796225_0.png resize: (93, 92) 1392089314 -3.0298752548853267 treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796229_0.png resize: (166, 80) 1392089315 -1.7613371732598009 treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796226_0.png resize: (229, 151) 1392089316 -0.9011170640807715 treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796228_0.png resize: (79, 66) 1392089317 -1.9074012576972506 treat image : temp/1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6_rle_crop_4016796230_0.png resize: (156, 77) 1392089318 -2.43324464116304 treat image : temp/1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6_rle_crop_4016796231_0.png resize: (66, 148) 1392089319 -4.167367309767484 treat image : temp/1762185630_2226272_1390107378_f5131447fdbae35f5b4fb0ab0c386384_rle_crop_4016796235_0.png resize: (81, 95) 1392089320 -3.4703270263440573 treat image : temp/1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0_rle_crop_4016796238_0.png resize: (61, 67) 1392089321 -3.08737982216879 treat image : temp/1762185630_2226272_1390107370_601112bfb7ade4b13499618aae5f374a_rle_crop_4016796241_0.png resize: (118, 96) 1392089322 -1.9812818016280551 treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796242_0.png resize: (70, 128) 1392089323 -1.2220725665298562 treat image : temp/1762185630_2226272_1390107367_8de3dc4813eaf41702e451db1284ec8b_rle_crop_4016796245_0.png resize: (177, 99) 1392089324 -2.3949840671934837 treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796215_0.png resize: (86, 56) 1392089386 0.17621679730080647 treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796232_0.png resize: (132, 126) 1392089387 -1.8291032053387837 treat image : temp/1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0_rle_crop_4016796239_0.png resize: (985, 952) 1392089389 -0.30013880969815315 treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796213_0.png resize: (990, 1205) 1392089483 -0.8522743623238582 treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796227_0.png resize: (136, 72) 1392089484 -1.3846886810316448 treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796233_0.png resize: (1012, 1208) 1392089486 -1.0956984632641271 treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796234_0.png resize: (87, 90) 1392089487 -3.1037749813066333 treat image : temp/1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90_rle_crop_4016796236_0.png resize: (66, 122) 1392089488 -0.23859778971941822 treat image : temp/1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90_rle_crop_4016796237_0.png resize: (65, 76) 1392089490 1.2220162593315862 treat image : temp/1762185630_2226272_1390107372_d65a9981d213b00bb39796dfe49f39e1_rle_crop_4016796240_0.png resize: (437, 313) 1392089491 -0.4455676832205633 treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796243_0.png resize: (141, 79) 1392089492 -1.1531687726444455 treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796244_0.png resize: (33, 75) 1392089494 4.644938110802469 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 : 55 time used for this insertion : 0.017086267471313477 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 55 time used for this insertion : 0.01867842674255371 save missing photos in datou_result : time spend for datou_step_exec : 17.983596801757812 time spend to save output : 0.040930747985839844 total time spend for step 6 : 18.024527549743652 step7:brightness Mon Nov 3 17:02:07 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure inside step calcul brightness treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d.jpg treat image : temp/1762185630_2226272_1390107402_71e5d9f2b492b13eb419e6b30c09e735.jpg treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0.jpg treat image : temp/1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821.jpg treat image : temp/1762185630_2226272_1390107386_e8adc61537748eea93b2f2ff80ca18d2.jpg treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1.jpg treat image : temp/1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7.jpg treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0.jpg treat image : temp/1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6.jpg treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c.jpg treat image : temp/1762185630_2226272_1390107378_f5131447fdbae35f5b4fb0ab0c386384.jpg treat image : temp/1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90.jpg treat image : temp/1762185630_2226272_1390107375_e995b1162e65d9ba97106a7f5f5417cd.jpg treat image : temp/1762185630_2226272_1390107374_fd36dbfd519e4d37a84ae61a201c7276.jpg treat image : temp/1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0.jpg treat image : temp/1762185630_2226272_1390107372_d65a9981d213b00bb39796dfe49f39e1.jpg treat image : temp/1762185630_2226272_1390107371_2d1b13f5619b6000603af68e5aeffda3.jpg treat image : temp/1762185630_2226272_1390107370_601112bfb7ade4b13499618aae5f374a.jpg treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea.jpg treat image : temp/1762185630_2226272_1390107367_8de3dc4813eaf41702e451db1284ec8b.jpg treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796212_0.png treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796211_0.png treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796216_0.png treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796214_0.png treat image : temp/1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821_rle_crop_4016796218_0.png treat image : temp/1762185630_2226272_1390107398_d03c0a496c05c66635ef7310c8bd9821_rle_crop_4016796217_0.png treat image : temp/1762185630_2226272_1390107386_e8adc61537748eea93b2f2ff80ca18d2_rle_crop_4016796219_0.png treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796222_0.png treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796220_0.png treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796221_0.png treat image : temp/1762185630_2226272_1390107385_c50a729436f1ad0675dc8bea5cf7e6b1_rle_crop_4016796223_0.png treat image : temp/1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7_rle_crop_4016796224_0.png treat image : temp/1762185630_2226272_1390107384_228edb757030b7f4edc5026a1bcce1d7_rle_crop_4016796225_0.png treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796229_0.png treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796226_0.png treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796228_0.png treat image : temp/1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6_rle_crop_4016796230_0.png treat image : temp/1762185630_2226272_1390107382_0bbc399a7231f7ca561fef55563c02a6_rle_crop_4016796231_0.png treat image : temp/1762185630_2226272_1390107378_f5131447fdbae35f5b4fb0ab0c386384_rle_crop_4016796235_0.png treat image : temp/1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0_rle_crop_4016796238_0.png treat image : temp/1762185630_2226272_1390107370_601112bfb7ade4b13499618aae5f374a_rle_crop_4016796241_0.png treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796242_0.png treat image : temp/1762185630_2226272_1390107367_8de3dc4813eaf41702e451db1284ec8b_rle_crop_4016796245_0.png treat image : temp/1762185630_2226272_1390107399_0a40e9da9b40eac66cd2ad81f215e1e0_rle_crop_4016796215_0.png treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796232_0.png treat image : temp/1762185630_2226272_1390107373_0cc44315dd1c09e92764d1c821e36be0_rle_crop_4016796239_0.png treat image : temp/1762185630_2226272_1390107403_0987c00fd3a96e8145bf52a31262ed8d_rle_crop_4016796213_0.png treat image : temp/1762185630_2226272_1390107383_c8b2875293d30e9e881db8d4c29d62d0_rle_crop_4016796227_0.png treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796233_0.png treat image : temp/1762185630_2226272_1390107379_786d1047a4f121a2b6a2ad06c26eba1c_rle_crop_4016796234_0.png treat image : temp/1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90_rle_crop_4016796236_0.png treat image : temp/1762185630_2226272_1390107376_43e61f4198f8b9606908bbca58dcaa90_rle_crop_4016796237_0.png treat image : temp/1762185630_2226272_1390107372_d65a9981d213b00bb39796dfe49f39e1_rle_crop_4016796240_0.png treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796243_0.png treat image : temp/1762185630_2226272_1390107369_5cfafa42dc51917825d35778b32661ea_rle_crop_4016796244_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 : 55 time used for this insertion : 0.017423629760742188 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 55 time used for this insertion : 0.015022993087768555 save missing photos in datou_result : time spend for datou_step_exec : 5.07327127456665 time spend to save output : 0.03688311576843262 total time spend for step 7 : 5.110154390335083 step8:velours_tree Mon Nov 3 17:02:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure can't find the photo_desc_type Inside saveOutput : final : False verbose : 0 ouput is None No outpout to save, returning out of save general time spend for datou_step_exec : 0.1471874713897705 time spend to save output : 3.5762786865234375e-05 total time spend for step 8 : 0.14722323417663574 step9:send_mail_cod Mon Nov 3 17:02:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 complete output_args for input 1 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 2 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 3 We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure dans la step send mail cod work_area: /home/admin/workarea/git/Velours/python in order to get the selector url, please entre the license of selector results_Auto_P28106454_03-11-2025_17_02_12.pdf 28106552 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 .imagette281065521762185732 28106553 imagette281065531762185733 28106554 imagette281065541762185733 28106555 imagette281065551762185733 28106556 imagette281065561762185733 28106557 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 .imagette281065571762185733 28106558 imagette281065581762185735 28106559 imagette281065591762185735 28106560 imagette281065601762185735 28106562 change filename to text .change filename to text .change filename to text .imagette281065621762185735 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=28106454 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://marlene.fotonower.com/velours/28106552,28106553,28106554,28106555,28106556,28106557,28106558,28106559,28106560,28106561,28106562?tags=pet_clair,autre,metal,background,pehd,papier,pet_fonce,flou,mal_croppe,environnement,carton args[1390107403] : ((1390107403, 0.37849426494354615, 492688767), (1390107403, 0.6597852814103198, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107402] : ((1390107402, 0.9666924965518177, 492688767), (1390107402, 0.4485404091742654, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107399] : ((1390107399, 0.5532462700905292, 492688767), (1390107399, 0.7195781535897906, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107398] : ((1390107398, -1.6467498849940116, 492688767), (1390107398, 0.12090287424890583, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107386] : ((1390107386, -0.2750528918092419, 492688767), (1390107386, 0.8570721601365886, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107385] : ((1390107385, -4.344743024275763, 492609224), (1390107385, 0.6658357961679547, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107384] : ((1390107384, 0.7277102842935548, 492688767), (1390107384, 0.7455600404505113, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107383] : ((1390107383, -3.059904270326093, 492609224), (1390107383, 1.2038830246916599, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107382] : ((1390107382, -4.507195430163205, 492609224), (1390107382, 0.46775564308907724, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107379] : ((1390107379, -0.1056628146917875, 492688767), (1390107379, 0.8169211040267522, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107378] : ((1390107378, -3.9212810284045503, 492609224), (1390107378, 0.4063323210674682, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107376] : ((1390107376, 0.1994837940716366, 492688767), (1390107376, 0.48583716057964016, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107375] : ((1390107375, -4.3329619112008695, 492609224), (1390107375, 0.5098833556342348, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107374] : ((1390107374, -0.21709382320732404, 492688767), (1390107374, 0.7406977730892254, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107373] : ((1390107373, 0.1701247297172927, 492688767), (1390107373, 0.5732643570332837, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107372] : ((1390107372, 0.2176819522948708, 492688767), (1390107372, 0.7024371147615582, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107371] : ((1390107371, -0.7156728750892103, 492688767), (1390107371, 1.6919166924965146, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107370] : ((1390107370, 0.04536927994382289, 492688767), (1390107370, 0.8097001615761136, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107369] : ((1390107369, 0.6671903045372165, 492688767), (1390107369, 0.8988040539089316, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com args[1390107367] : ((1390107367, 0.4286565094047165, 492688767), (1390107367, 0.6363401615859353, 2107752395), '0.07877059220679013') We are sending mail with results at report@fotonower.com refus_total : 0.07877059220679013 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=28106454 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_P28106454_03-11-2025_17_02_12.pdf results_Auto_P28106454_03-11-2025_17_02_12.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28106454_03-11-2025_17_02_12.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('3318','28106454','results_Auto_P28106454_03-11-2025_17_02_12.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28106454_03-11-2025_17_02_12.pdf','pdf','','0.49','0.07877059220679013') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/28106454

https://www.fotonower.com/image?json=false&list_photos_id=1390107403
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107402
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107399
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107398
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107386
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107385
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107384
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107383
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107382
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107379
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107378
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107376
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107375
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107374
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107373
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107372
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107371
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107370
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107369
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1390107367
Bravo, la photo est bien prise.

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

exemples de contaminants: pet_clair: https://www.fotonower.com/view/28106552?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/28106557?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/28106562?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28106454_03-11-2025_17_02_12.pdf.

Lien vers velours :https://marlene.fotonower.com/velours/28106552,28106553,28106554,28106555,28106556,28106557,28106558,28106559,28106560,28106561,28106562?tags=pet_clair,autre,metal,background,pehd,papier,pet_fonce,flou,mal_croppe,environnement,carton.


L'équipe Fotonower 202 b'' Server: nginx Date: Mon, 03 Nov 2025 16:02:18 GMT Content-Length: 0 Connection: close X-Message-Id: rPaEY8HPQcu-91lawESvXQ 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 [1390107403, 1390107402, 1390107399, 1390107398, 1390107386, 1390107385, 1390107384, 1390107383, 1390107382, 1390107379, 1390107378, 1390107376, 1390107375, 1390107374, 1390107373, 1390107372, 1390107371, 1390107370, 1390107369, 1390107367] 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, '3988543') ('3318', '28106454', '1390107403', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107402', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107399', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107398', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107386', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107385', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107384', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107383', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107382', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107379', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107378', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107376', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107375', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107374', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107373', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107372', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107371', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107370', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107369', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107367', None, None, None, None, None, '3988543') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 20 time used for this insertion : 0.024603605270385742 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.254131078720093 time spend to save output : 0.02492976188659668 total time spend for step 9 : 5.2790608406066895 step10:split_time_score Mon Nov 3 17:02:18 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('08', 20),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 28102025 28106454 Nombre de photos uploadées : 20 / 23040 (0%) 28102025 28106454 Nombre de photos taguées (types de déchets): 0 / 20 (0%) 28102025 28106454 Nombre de photos taguées (volume) : 0 / 20 (0%) elapsed_time : load_data_split_time_score 1.6689300537109375e-06 elapsed_time : order_list_meta_photo_and_scores 5.245208740234375e-06 ???????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.0009133815765380859 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.26203322410583496 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28106429 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28106432 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28106434 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28106438 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28106440 order by id desc limit 1 Qualite : 0.07877059220679013 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P28106454_03-11-2025_17_02_12.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 28106454 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`=28106454 AND mptpi.`type`=3594 To do Qualite : 0.02853083789281707 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27909528_29-10-2025_16_26_36.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27909528 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`=27909528 AND mptpi.`type`=3594 To do Qualite : 0.02325551376028806 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P27909529_29-10-2025_16_22_23.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 27909529 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`=27909529 AND mptpi.`type`=3594 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'28102025': {'nb_upload': 20, '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 [1390107403, 1390107402, 1390107399, 1390107398, 1390107386, 1390107385, 1390107384, 1390107383, 1390107382, 1390107379, 1390107378, 1390107376, 1390107375, 1390107374, 1390107373, 1390107372, 1390107371, 1390107370, 1390107369, 1390107367] Looping around the photos to save general results len do output : 1 /28106454Didn'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, '3988543') ('3318', '28106454', '1390107403', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107402', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107399', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107398', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107386', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107385', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107384', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107383', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107382', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107379', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107378', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107376', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107375', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107374', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107373', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107372', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107371', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107370', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107369', None, None, None, None, None, '3988543') ('3318', None, None, None, None, None, None, None, '3988543') ('3318', '28106454', '1390107367', None, None, None, None, None, '3988543') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 21 time used for this insertion : 0.017925739288330078 save_final save missing photos in datou_result : time spend for datou_step_exec : 6.573788404464722 time spend to save output : 0.018221139907836914 total time spend for step 10 : 6.592009544372559 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 20 set_done_treatment 61.78user 32.28system 1:59.38elapsed 78%CPU (0avgtext+0avgdata 2891348maxresident)k 802912inputs+37544outputs (3432major+1965167minor)pagefaults 0swaps