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 : 2754194 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 : ['2631684'] with mtr_portfolio_ids : ['21001262'] and first list_photo_ids : [] new path : /proc/2754194/ 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 , BFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 5 ; length of list_pids : 5 ; length of list_args : 5 time to download the photos : 1.0881397724151611 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 Tue Mar 4 09:20:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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 : 9930 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-03-04 09:20:31.324533: 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-03-04 09:20:31.355159: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-03-04 09:20:31.357369: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7ff6c4000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-03-04 09:20:31.357423: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-03-04 09:20:31.361344: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-03-04 09:20:31.490662: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x3081e8e0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-03-04 09:20:31.490703: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-03-04 09:20:31.492122: 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-03-04 09:20:31.492531: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-04 09:20:31.496265: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-04 09:20:31.499009: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-04 09:20:31.499529: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-04 09:20:31.502336: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-04 09:20:31.503421: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-04 09:20:31.508050: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-04 09:20:31.509524: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-04 09:20:31.509592: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-04 09:20:31.510364: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-03-04 09:20:31.510380: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-03-04 09:20:31.510388: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-03-04 09:20:31.511804: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9192 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-03-04 09:20:31.876921: 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-03-04 09:20:31.877010: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-04 09:20:31.877031: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-04 09:20:31.877050: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-04 09:20:31.877068: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-04 09:20:31.877085: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-04 09:20:31.877103: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-04 09:20:31.877121: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-04 09:20:31.878765: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-04 09:20:31.880004: 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-03-04 09:20:31.880037: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-03-04 09:20:31.880053: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-04 09:20:31.880067: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-03-04 09:20:31.880080: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-03-04 09:20:31.880094: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-03-04 09:20:31.880107: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-03-04 09:20:31.880121: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-03-04 09:20:31.881362: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-03-04 09:20:31.881400: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-03-04 09:20:31.881411: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-03-04 09:20:31.881419: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-03-04 09:20:31.882721: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9192 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-03-04 09:20:44.468231: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-03-04 09:20:44.644664: 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 : 5 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 9.00000 max: 253.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 139.10000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 18 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 16.00000 max: 252.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 138.60000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 15 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 142.60000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 24 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 145.35000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 29 NEW PHOTO Processing 1 images image shape: (2160, 3840, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 143.85000 image_metas shape: (1, 17) min: 0.00000 max: 3840.00000 nb d'objets trouves : 33 Detection mask done ! Trying to reset tf kernel 2756683 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 4862 tf kernel not reseted sub process len(results) : 5 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 5 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 : 10151 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.0012590885162353516 nb_pixel_total : 28204 time to create 1 rle with old method : 0.03987860679626465 length of segment : 242 time for calcul the mask position with numpy : 0.0015687942504882812 nb_pixel_total : 39306 time to create 1 rle with old method : 0.05260610580444336 length of segment : 342 time for calcul the mask position with numpy : 0.0003647804260253906 nb_pixel_total : 15912 time to create 1 rle with old method : 0.021198272705078125 length of segment : 113 time for calcul the mask position with numpy : 0.0016088485717773438 nb_pixel_total : 77550 time to create 1 rle with old method : 0.09616565704345703 length of segment : 477 time for calcul the mask position with numpy : 0.0007145404815673828 nb_pixel_total : 41732 time to create 1 rle with old method : 0.053344011306762695 length of segment : 354 time for calcul the mask position with numpy : 0.0010573863983154297 nb_pixel_total : 41168 time to create 1 rle with old method : 0.04742312431335449 length of segment : 255 time for calcul the mask position with numpy : 0.000308990478515625 nb_pixel_total : 12875 time to create 1 rle with old method : 0.019811391830444336 length of segment : 184 time for calcul the mask position with numpy : 0.0006425380706787109 nb_pixel_total : 27487 time to create 1 rle with old method : 0.03449702262878418 length of segment : 228 time for calcul the mask position with numpy : 0.3224494457244873 nb_pixel_total : 3196930 time to create 1 rle with new method : 0.5891938209533691 length of segment : 1715 time for calcul the mask position with numpy : 0.0014183521270751953 nb_pixel_total : 42943 time to create 1 rle with old method : 0.0502169132232666 length of segment : 342 time for calcul the mask position with numpy : 0.0010330677032470703 nb_pixel_total : 50213 time to create 1 rle with old method : 0.05804109573364258 length of segment : 192 time for calcul the mask position with numpy : 0.002391338348388672 nb_pixel_total : 86799 time to create 1 rle with old method : 0.1065058708190918 length of segment : 366 time for calcul the mask position with numpy : 0.0009174346923828125 nb_pixel_total : 42815 time to create 1 rle with old method : 0.05077385902404785 length of segment : 142 time for calcul the mask position with numpy : 0.002787351608276367 nb_pixel_total : 144707 time to create 1 rle with old method : 0.17098450660705566 length of segment : 526 time for calcul the mask position with numpy : 0.0007779598236083984 nb_pixel_total : 27191 time to create 1 rle with old method : 0.03304934501647949 length of segment : 190 time for calcul the mask position with numpy : 0.001651763916015625 nb_pixel_total : 65039 time to create 1 rle with old method : 0.07682299613952637 length of segment : 208 time for calcul the mask position with numpy : 0.0008716583251953125 nb_pixel_total : 35919 time to create 1 rle with old method : 0.052374839782714844 length of segment : 179 time for calcul the mask position with numpy : 0.00177764892578125 nb_pixel_total : 47724 time to create 1 rle with old method : 0.0608518123626709 length of segment : 209 time for calcul the mask position with numpy : 0.0010323524475097656 nb_pixel_total : 24924 time to create 1 rle with old method : 0.029656648635864258 length of segment : 204 time for calcul the mask position with numpy : 0.0014379024505615234 nb_pixel_total : 54341 time to create 1 rle with old method : 0.06719207763671875 length of segment : 241 time for calcul the mask position with numpy : 0.004370927810668945 nb_pixel_total : 165909 time to create 1 rle with new method : 0.008744239807128906 length of segment : 685 time for calcul the mask position with numpy : 0.001749277114868164 nb_pixel_total : 63933 time to create 1 rle with old method : 0.07903409004211426 length of segment : 557 time for calcul the mask position with numpy : 0.0009114742279052734 nb_pixel_total : 33583 time to create 1 rle with old method : 0.041243791580200195 length of segment : 156 time for calcul the mask position with numpy : 0.0010819435119628906 nb_pixel_total : 40682 time to create 1 rle with old method : 0.05124211311340332 length of segment : 318 time for calcul the mask position with numpy : 0.004916191101074219 nb_pixel_total : 142171 time to create 1 rle with old method : 0.16298222541809082 length of segment : 430 time for calcul the mask position with numpy : 0.0009238719940185547 nb_pixel_total : 27376 time to create 1 rle with old method : 0.03460812568664551 length of segment : 217 time for calcul the mask position with numpy : 0.0011489391326904297 nb_pixel_total : 34590 time to create 1 rle with old method : 0.044399261474609375 length of segment : 179 time for calcul the mask position with numpy : 0.0018711090087890625 nb_pixel_total : 56354 time to create 1 rle with old method : 0.06877541542053223 length of segment : 367 time for calcul the mask position with numpy : 0.0035867691040039062 nb_pixel_total : 95183 time to create 1 rle with old method : 0.1187431812286377 length of segment : 469 time for calcul the mask position with numpy : 0.0005922317504882812 nb_pixel_total : 13373 time to create 1 rle with old method : 0.01640772819519043 length of segment : 127 time for calcul the mask position with numpy : 0.004638671875 nb_pixel_total : 137360 time to create 1 rle with old method : 0.16985225677490234 length of segment : 420 time for calcul the mask position with numpy : 0.003225088119506836 nb_pixel_total : 111377 time to create 1 rle with old method : 0.13974881172180176 length of segment : 327 time for calcul the mask position with numpy : 0.00445246696472168 nb_pixel_total : 166317 time to create 1 rle with new method : 0.0057659149169921875 length of segment : 446 time for calcul the mask position with numpy : 0.002101898193359375 nb_pixel_total : 77871 time to create 1 rle with old method : 0.09354496002197266 length of segment : 451 time for calcul the mask position with numpy : 0.00043010711669921875 nb_pixel_total : 7106 time to create 1 rle with old method : 0.009151458740234375 length of segment : 117 time for calcul the mask position with numpy : 0.0005216598510742188 nb_pixel_total : 14014 time to create 1 rle with old method : 0.01748347282409668 length of segment : 141 time for calcul the mask position with numpy : 0.0012829303741455078 nb_pixel_total : 41602 time to create 1 rle with old method : 0.050629377365112305 length of segment : 219 time for calcul the mask position with numpy : 0.0047833919525146484 nb_pixel_total : 82168 time to create 1 rle with old method : 0.10363006591796875 length of segment : 270 time for calcul the mask position with numpy : 0.0032165050506591797 nb_pixel_total : 104204 time to create 1 rle with old method : 0.13706493377685547 length of segment : 370 time for calcul the mask position with numpy : 0.0033037662506103516 nb_pixel_total : 126281 time to create 1 rle with old method : 0.15281939506530762 length of segment : 289 time for calcul the mask position with numpy : 0.0011234283447265625 nb_pixel_total : 32350 time to create 1 rle with old method : 0.040824174880981445 length of segment : 268 time for calcul the mask position with numpy : 0.0011150836944580078 nb_pixel_total : 46031 time to create 1 rle with old method : 0.05938601493835449 length of segment : 221 time for calcul the mask position with numpy : 0.005261659622192383 nb_pixel_total : 168477 time to create 1 rle with new method : 0.010404109954833984 length of segment : 620 time for calcul the mask position with numpy : 0.0009171962738037109 nb_pixel_total : 18563 time to create 1 rle with old method : 0.023420095443725586 length of segment : 239 time for calcul the mask position with numpy : 0.006292581558227539 nb_pixel_total : 181994 time to create 1 rle with new method : 0.008967161178588867 length of segment : 568 time for calcul the mask position with numpy : 0.0015981197357177734 nb_pixel_total : 37585 time to create 1 rle with old method : 0.045061588287353516 length of segment : 279 time for calcul the mask position with numpy : 0.0037975311279296875 nb_pixel_total : 121585 time to create 1 rle with old method : 0.13860440254211426 length of segment : 405 time for calcul the mask position with numpy : 0.0017185211181640625 nb_pixel_total : 60541 time to create 1 rle with old method : 0.07359814643859863 length of segment : 283 time for calcul the mask position with numpy : 0.002246856689453125 nb_pixel_total : 59386 time to create 1 rle with old method : 0.0708463191986084 length of segment : 273 time for calcul the mask position with numpy : 0.003049612045288086 nb_pixel_total : 73834 time to create 1 rle with old method : 0.09354567527770996 length of segment : 543 time for calcul the mask position with numpy : 0.017431020736694336 nb_pixel_total : 585183 time to create 1 rle with new method : 0.1158597469329834 length of segment : 1242 time for calcul the mask position with numpy : 0.006353139877319336 nb_pixel_total : 194658 time to create 1 rle with new method : 0.010413169860839844 length of segment : 507 time for calcul the mask position with numpy : 0.001718759536743164 nb_pixel_total : 85850 time to create 1 rle with old method : 0.09788370132446289 length of segment : 528 time for calcul the mask position with numpy : 0.0008590221405029297 nb_pixel_total : 23932 time to create 1 rle with old method : 0.02833271026611328 length of segment : 146 time for calcul the mask position with numpy : 0.0007607936859130859 nb_pixel_total : 20119 time to create 1 rle with old method : 0.024282455444335938 length of segment : 109 time for calcul the mask position with numpy : 0.0005166530609130859 nb_pixel_total : 12392 time to create 1 rle with old method : 0.020186662673950195 length of segment : 94 time for calcul the mask position with numpy : 0.0053157806396484375 nb_pixel_total : 143845 time to create 1 rle with old method : 0.17665767669677734 length of segment : 526 time for calcul the mask position with numpy : 0.0046710968017578125 nb_pixel_total : 257089 time to create 1 rle with new method : 0.013701677322387695 length of segment : 449 time spent for convertir_results : 9.304527282714844 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 58 chid ids of type : 3594 Number RLEs to save : 20564 save missing photos in datou_result : time spend for datou_step_exec : 57.61514353752136 time spend to save output : 1.9113876819610596 total time spend for step 1 : 59.52653121948242 step2:crop_condition Tue Mar 4 09:21:27 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : 5 ! batch 1 Loaded 58 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ begin to crop the class : papier param for this class : {'min_score': 0.7} filtre for class : papier hashtag_id of this class : 492668766 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 24 About to insert : list_path_to_insert length 24 new photo from crops ! About to upload 24 photos upload in portfolio : 3736932 init cache_photo without model_param we have 24 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1741076495_2754194 we have uploaded 24 photos in the portfolio 3736932 time of upload the photos Elapsed time : 7.714828729629517 we have finished the crop for the class : papier begin to crop the class : carton param for this class : {'min_score': 0.7} filtre for class : carton hashtag_id of this class : 492774966 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 8 About to insert : list_path_to_insert length 8 new photo from crops ! About to upload 8 photos upload in portfolio : 3736932 init cache_photo without model_param we have 8 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1741076507_2754194 we have uploaded 8 photos in the portfolio 3736932 time of upload the photos Elapsed time : 4.101799249649048 we have finished the crop for the class : carton begin to crop the class : metal param for this class : {'min_score': 0.7} filtre for class : metal hashtag_id of this class : 492628673 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 3736932 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1741076512_2754194 we have uploaded 3 photos in the portfolio 3736932 time of upload the photos Elapsed time : 1.0937988758087158 we have finished the crop for the class : metal begin to crop the class : pet_clair param for this class : {'min_score': 0.7} filtre for class : pet_clair hashtag_id of this class : 2107755846 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 22 About to insert : list_path_to_insert length 22 new photo from crops ! About to upload 22 photos upload in portfolio : 3736932 init cache_photo without model_param we have 22 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1741076540_2754194 we have uploaded 22 photos in the portfolio 3736932 time of upload the photos Elapsed time : 7.162782907485962 we have finished the crop for the class : pet_clair begin to crop the class : autre param for this class : {'min_score': 0.7} filtre for class : autre hashtag_id of this class : 494826614 we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 3736932 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1741076549_2754194 we have uploaded 1 photos in the portfolio 3736932 time of upload the photos Elapsed time : 3.2458901405334473 we have finished the crop for the class : autre begin to crop the class : pehd param for this class : {'min_score': 0.7} filtre for class : pehd hashtag_id of this class : 628944319 begin to crop the class : pet_fonce param for this class : {'min_score': 0.7} filtre for class : pet_fonce hashtag_id of this class : 2107755900 delete rles from all chi we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles we have 0 chi objets contains the rles Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1334154494, 1334154433, 1334154430, 1334154426, 1334154421] Looping around the photos to save general results len do output : 58 /1340770033Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770034Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770035Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770036Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770037Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770038Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770039Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770040Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770041Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770042Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770043Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770044Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770045Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770046Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770047Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770048Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770049Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770050Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770051Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770052Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770053Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770054Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770055Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770056Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770064Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770065Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770066Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770067Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770069Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770070Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770071Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770072Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770088Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770089Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770090Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770106Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770107Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770108Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770109Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770110Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770111Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770112Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770113Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770114Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770115Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770116Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770117Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770118Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770119Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770120Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770121Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770122Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770123Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770124Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770125Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770126Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770127Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1340770130Didn'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, '2631684') ('3318', '21001262', '1334154494', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154433', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154430', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154426', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154421', None, None, None, None, None, '2631684') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 179 time used for this insertion : 0.019354581832885742 save_final save missing photos in datou_result : time spend for datou_step_exec : 64.36097288131714 time spend to save output : 0.02494049072265625 total time spend for step 2 : 64.3859133720398 step3:rle_unique_nms_with_priority Tue Mar 4 09:22:31 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 58 chid ids of type : 3594 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++nb_obj : 10 nb_hashtags : 3 time to prepare the origin masks : 5.8073272705078125 time for calcul the mask position with numpy : 0.8940403461456299 nb_pixel_total : 4854457 time to create 1 rle with new method : 1.1556107997894287 time for calcul the mask position with numpy : 0.03902840614318848 nb_pixel_total : 42943 time to create 1 rle with old method : 0.048073768615722656 time for calcul the mask position with numpy : 0.18855977058410645 nb_pixel_total : 3112766 time to create 1 rle with new method : 0.7213854789733887 time for calcul the mask position with numpy : 0.029425382614135742 nb_pixel_total : 27487 time to create 1 rle with old method : 0.03229379653930664 time for calcul the mask position with numpy : 0.028672218322753906 nb_pixel_total : 12875 time to create 1 rle with old method : 0.014632701873779297 time for calcul the mask position with numpy : 0.0272061824798584 nb_pixel_total : 41168 time to create 1 rle with old method : 0.04637432098388672 time for calcul the mask position with numpy : 0.032561540603637695 nb_pixel_total : 41732 time to create 1 rle with old method : 0.051123857498168945 time for calcul the mask position with numpy : 0.042752981185913086 nb_pixel_total : 77550 time to create 1 rle with old method : 0.08483529090881348 time for calcul the mask position with numpy : 0.04478573799133301 nb_pixel_total : 15912 time to create 1 rle with old method : 0.01770806312561035 time for calcul the mask position with numpy : 0.04444313049316406 nb_pixel_total : 39306 time to create 1 rle with old method : 0.0438995361328125 time for calcul the mask position with numpy : 0.040883541107177734 nb_pixel_total : 28204 time to create 1 rle with old method : 0.03182196617126465 create new chi : 3.729846239089966 time to delete rle : 0.024132251739501953 batch 1 Loaded 21 chid ids of type : 3594 +++++++++++++++++++++Number RLEs to save : 10608 TO DO : save crop sub photo not yet done ! save time : 0.9320828914642334 nb_obj : 7 nb_hashtags : 2 time to prepare the origin masks : 6.110630035400391 time for calcul the mask position with numpy : 1.0867085456848145 nb_pixel_total : 7842193 time to create 1 rle with new method : 0.564622163772583 time for calcul the mask position with numpy : 0.04297614097595215 nb_pixel_total : 35919 time to create 1 rle with old method : 0.055521488189697266 time for calcul the mask position with numpy : 0.046997785568237305 nb_pixel_total : 65039 time to create 1 rle with old method : 0.07443761825561523 time for calcul the mask position with numpy : 0.04684805870056152 nb_pixel_total : 27191 time to create 1 rle with old method : 0.03167152404785156 time for calcul the mask position with numpy : 0.042650699615478516 nb_pixel_total : 144231 time to create 1 rle with old method : 0.16283893585205078 time for calcul the mask position with numpy : 0.0422978401184082 nb_pixel_total : 42815 time to create 1 rle with old method : 0.051989078521728516 time for calcul the mask position with numpy : 0.04338479042053223 nb_pixel_total : 86799 time to create 1 rle with old method : 0.09990549087524414 time for calcul the mask position with numpy : 0.03548264503479004 nb_pixel_total : 50213 time to create 1 rle with old method : 0.06034445762634277 create new chi : 2.5408005714416504 time to delete rle : 0.0016694068908691406 batch 1 Loaded 15 chid ids of type : 3594 +++++++Number RLEs to save : 5727 TO DO : save crop sub photo not yet done ! save time : 4.179619789123535 nb_obj : 10 nb_hashtags : 4 time to prepare the origin masks : 5.24811577796936 time for calcul the mask position with numpy : 0.6038556098937988 nb_pixel_total : 7660489 time to create 1 rle with new method : 1.1599218845367432 time for calcul the mask position with numpy : 0.041371822357177734 nb_pixel_total : 34590 time to create 1 rle with old method : 0.04108881950378418 time for calcul the mask position with numpy : 0.05147194862365723 nb_pixel_total : 27376 time to create 1 rle with old method : 0.040643930435180664 time for calcul the mask position with numpy : 0.03822183609008789 nb_pixel_total : 142171 time to create 1 rle with old method : 0.16889142990112305 time for calcul the mask position with numpy : 0.03830265998840332 nb_pixel_total : 40682 time to create 1 rle with old method : 0.04792475700378418 time for calcul the mask position with numpy : 0.04164266586303711 nb_pixel_total : 33583 time to create 1 rle with old method : 0.04829883575439453 time for calcul the mask position with numpy : 0.04616999626159668 nb_pixel_total : 62611 time to create 1 rle with old method : 0.07165861129760742 time for calcul the mask position with numpy : 0.04149436950683594 nb_pixel_total : 165909 time to create 1 rle with new method : 0.8503067493438721 time for calcul the mask position with numpy : 0.037197113037109375 nb_pixel_total : 54341 time to create 1 rle with old method : 0.06627869606018066 time for calcul the mask position with numpy : 0.03574371337890625 nb_pixel_total : 24924 time to create 1 rle with old method : 0.03031301498413086 time for calcul the mask position with numpy : 0.034456729888916016 nb_pixel_total : 47724 time to create 1 rle with old method : 0.05638623237609863 create new chi : 3.674966812133789 time to delete rle : 0.0014259815216064453 batch 1 Loaded 21 chid ids of type : 3594 ++++++++++Number RLEs to save : 8268 TO DO : save crop sub photo not yet done ! save time : 6.029179096221924 nb_obj : 17 nb_hashtags : 4 time to prepare the origin masks : 10.879454374313354 time for calcul the mask position with numpy : 0.5238094329833984 nb_pixel_total : 6996093 time to create 1 rle with new method : 0.905651330947876 time for calcul the mask position with numpy : 0.042517662048339844 nb_pixel_total : 18563 time to create 1 rle with old method : 0.021068334579467773 time for calcul the mask position with numpy : 0.04956650733947754 nb_pixel_total : 168477 time to create 1 rle with new method : 0.779106855392456 time for calcul the mask position with numpy : 0.05167555809020996 nb_pixel_total : 46031 time to create 1 rle with old method : 0.06523704528808594 time for calcul the mask position with numpy : 0.03899097442626953 nb_pixel_total : 32350 time to create 1 rle with old method : 0.03925514221191406 time for calcul the mask position with numpy : 0.03679060935974121 nb_pixel_total : 126281 time to create 1 rle with old method : 0.14434480667114258 time for calcul the mask position with numpy : 0.0405879020690918 nb_pixel_total : 104204 time to create 1 rle with old method : 0.12016844749450684 time for calcul the mask position with numpy : 0.03226113319396973 nb_pixel_total : 81844 time to create 1 rle with old method : 0.09149527549743652 time for calcul the mask position with numpy : 0.029827356338500977 nb_pixel_total : 41602 time to create 1 rle with old method : 0.04676175117492676 time for calcul the mask position with numpy : 0.03197741508483887 nb_pixel_total : 14014 time to create 1 rle with old method : 0.01581883430480957 time for calcul the mask position with numpy : 0.03230786323547363 nb_pixel_total : 7106 time to create 1 rle with old method : 0.008577823638916016 time for calcul the mask position with numpy : 0.02735424041748047 nb_pixel_total : 77871 time to create 1 rle with old method : 0.08765959739685059 time for calcul the mask position with numpy : 0.0288240909576416 nb_pixel_total : 166317 time to create 1 rle with new method : 1.0573301315307617 time for calcul the mask position with numpy : 0.027597427368164062 nb_pixel_total : 111377 time to create 1 rle with old method : 0.12272047996520996 time for calcul the mask position with numpy : 0.02768254280090332 nb_pixel_total : 137360 time to create 1 rle with old method : 0.156080961227417 time for calcul the mask position with numpy : 0.040836334228515625 nb_pixel_total : 13373 time to create 1 rle with old method : 0.014663457870483398 time for calcul the mask position with numpy : 0.04211759567260742 nb_pixel_total : 95183 time to create 1 rle with old method : 0.1044769287109375 time for calcul the mask position with numpy : 0.04401087760925293 nb_pixel_total : 56354 time to create 1 rle with old method : 0.06482553482055664 create new chi : 5.254293441772461 time to delete rle : 0.0017142295837402344 batch 1 Loaded 35 chid ids of type : 3594 ++++++++++++++++++++++++++++Number RLEs to save : 12839 TO DO : save crop sub photo not yet done ! save time : 0.8540153503417969 nb_obj : 14 nb_hashtags : 4 time to prepare the origin masks : 8.06679892539978 time for calcul the mask position with numpy : 0.899303674697876 nb_pixel_total : 6747764 time to create 1 rle with new method : 1.3778471946716309 time for calcul the mask position with numpy : 0.0391085147857666 nb_pixel_total : 14296 time to create 1 rle with old method : 0.017179250717163086 time for calcul the mask position with numpy : 0.04931163787841797 nb_pixel_total : 143845 time to create 1 rle with old method : 0.1695995330810547 time for calcul the mask position with numpy : 0.04386711120605469 nb_pixel_total : 12392 time to create 1 rle with old method : 0.014596700668334961 time for calcul the mask position with numpy : 0.0457608699798584 nb_pixel_total : 20119 time to create 1 rle with old method : 0.023721933364868164 time for calcul the mask position with numpy : 0.04530453681945801 nb_pixel_total : 23932 time to create 1 rle with old method : 0.027055740356445312 time for calcul the mask position with numpy : 0.04857277870178223 nb_pixel_total : 17317 time to create 1 rle with old method : 0.020843029022216797 time for calcul the mask position with numpy : 0.042450666427612305 nb_pixel_total : 194627 time to create 1 rle with new method : 0.8050997257232666 time for calcul the mask position with numpy : 0.0490870475769043 nb_pixel_total : 585183 time to create 1 rle with new method : 0.8378865718841553 time for calcul the mask position with numpy : 0.045258522033691406 nb_pixel_total : 73834 time to create 1 rle with old method : 0.08209609985351562 time for calcul the mask position with numpy : 0.04686379432678223 nb_pixel_total : 59386 time to create 1 rle with old method : 0.06763029098510742 time for calcul the mask position with numpy : 0.04748892784118652 nb_pixel_total : 60541 time to create 1 rle with old method : 0.07621335983276367 time for calcul the mask position with numpy : 0.045879364013671875 nb_pixel_total : 121585 time to create 1 rle with old method : 0.1393136978149414 time for calcul the mask position with numpy : 0.042064666748046875 nb_pixel_total : 37585 time to create 1 rle with old method : 0.04560565948486328 time for calcul the mask position with numpy : 0.05064105987548828 nb_pixel_total : 181994 time to create 1 rle with new method : 0.94748854637146 create new chi : 6.345028400421143 time to delete rle : 0.0030596256256103516 batch 1 Loaded 29 chid ids of type : 3594 ++++++++++++++++++Number RLEs to save : 13047 TO DO : save crop sub photo not yet done ! save time : 1.029078722000122 map_output_result : {1334154494: (0.0, 'Should be the crop_list due to order', 0), 1334154433: (0.0, 'Should be the crop_list due to order', 0), 1334154430: (0.0, 'Should be the crop_list due to order', 0), 1334154426: (0.0, 'Should be the crop_list due to order', 0), 1334154421: (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 [1334154494, 1334154433, 1334154430, 1334154426, 1334154421] Looping around the photos to save general results len do output : 5 /1334154494.Didn't retrieve data . /1334154433.Didn't retrieve data . /1334154430.Didn't retrieve data . /1334154426.Didn't retrieve data . /1334154421.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, '2631684') ('3318', '21001262', '1334154494', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154433', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154430', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154426', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154421', None, None, None, None, None, '2631684') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.012309074401855469 save_final save missing photos in datou_result : time spend for datou_step_exec : 72.44212698936462 time spend to save output : 0.012824773788452148 total time spend for step 3 : 72.45495176315308 step4:ventilate_hashtags_in_portfolio Tue Mar 4 09:23:44 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 : 21001262 get user id for portfolio 21001262 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`=21001262 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','metal','papier','carton','pet_fonce','flou','background','pet_clair','pehd','autre','environnement')) 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`=21001262 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','metal','papier','carton','pet_fonce','flou','background','pet_clair','pehd','autre','environnement')) 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`=21001262 AND mptpi.`type`=3594 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('mal_croppe','metal','papier','carton','pet_fonce','flou','background','pet_clair','pehd','autre','environnement')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/21001935,21001936,21001937,21001938,21001939,21001940,21001941,21001942,21001943,21001944,21001945?tags=mal_croppe,metal,papier,carton,pet_fonce,flou,background,pet_clair,pehd,autre,environnement Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1334154494, 1334154433, 1334154430, 1334154426, 1334154421] Looping around the photos to save general results len do output : 1 /21001262. 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, '2631684') ('3318', '21001262', '1334154494', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154433', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154430', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154426', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154421', None, None, None, None, None, '2631684') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.7009680271148682 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.6032929420471191 time spend to save output : 0.7018032073974609 total time spend for step 4 : 2.30509614944458 step5:final Tue Mar 4 09:23:46 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 : {1334154494: ('0.17773447145061727',), 1334154433: ('0.17773447145061727',), 1334154430: ('0.17773447145061727',), 1334154426: ('0.17773447145061727',), 1334154421: ('0.17773447145061727',)} new output for save of step final : {1334154494: ('0.17773447145061727',), 1334154433: ('0.17773447145061727',), 1334154430: ('0.17773447145061727',), 1334154426: ('0.17773447145061727',), 1334154421: ('0.17773447145061727',)} [1334154494, 1334154433, 1334154430, 1334154426, 1334154421] Looping around the photos to save general results len do output : 5 /1334154494.Didn't retrieve data . /1334154433.Didn't retrieve data . /1334154430.Didn't retrieve data . /1334154426.Didn't retrieve data . /1334154421.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, '2631684') ('3318', '21001262', '1334154494', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154433', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154430', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154426', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154421', None, None, None, None, None, '2631684') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 15 time used for this insertion : 0.012457847595214844 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.14270710945129395 time spend to save output : 0.012820243835449219 total time spend for step 5 : 0.15552735328674316 step6:blur_detection Tue Mar 4 09:23:46 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 toutes les photos sont déjà traitées, on saute les calculs 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 : 5 time used for this insertion : 0.008912324905395508 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 5 time used for this insertion : 0.009790182113647461 save missing photos in datou_result : time spend for datou_step_exec : 0.029731273651123047 time spend to save output : 0.023354053497314453 total time spend for step 6 : 0.0530853271484375 step7:brightness Tue Mar 4 09:23:46 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 toutes les photos sont déjà traitées, on saute les calculs 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 : 5 time used for this insertion : 0.0077648162841796875 begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 5 time used for this insertion : 0.00793147087097168 save missing photos in datou_result : time spend for datou_step_exec : 0.03400087356567383 time spend to save output : 0.019842863082885742 total time spend for step 7 : 0.05384373664855957 step8:velours_tree Tue Mar 4 09:23:46 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.23503708839416504 time spend to save output : 4.076957702636719e-05 total time spend for step 8 : 0.2350778579711914 step9:send_mail_cod Tue Mar 4 09:23: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 complete output_args for input 0 complete output_args for input 1 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_P21001262_04-03-2025_09_23_47.pdf 21001935 imagette210019351741076627 21001936 change filename to text .change filename to text .change filename to text .imagette210019361741076627 21001937 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 .imagette210019371741076627 21001938 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 .imagette210019381741076628 21001939 imagette210019391741076629 21001940 imagette210019401741076629 21001941 imagette210019411741076629 21001942 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 .imagette210019421741076629 21001943 imagette210019431741076631 21001944 change filename to text .imagette210019441741076631 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=21001262 and hashtag_type = 3594 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/21001935,21001936,21001937,21001938,21001939,21001940,21001941,21001942,21001943,21001944,21001945?tags=mal_croppe,metal,papier,carton,pet_fonce,flou,background,pet_clair,pehd,autre,environnement args[1334154494] : ((1334154494, -3.2577491783924475, 492609224), (1334154494, -1.7169506822315936, 501862349), '0.17773447145061727') We are sending mail with results at report@fotonower.com args[1334154433] : ((1334154433, -3.0595103330791935, 492609224), (1334154433, -1.4873837823661578, 501862349), '0.17773447145061727') We are sending mail with results at report@fotonower.com args[1334154430] : ((1334154430, -4.940956204845302, 492609224), (1334154430, -0.661587761361929, 501862349), '0.17773447145061727') We are sending mail with results at report@fotonower.com args[1334154426] : ((1334154426, -5.027443202892873, 492609224), (1334154426, -0.7552216356092761, 501862349), '0.17773447145061727') We are sending mail with results at report@fotonower.com args[1334154421] : ((1334154421, -5.366384236490718, 492609224), (1334154421, -0.391817133839027, 496442774), '0.17773447145061727') We are sending mail with results at report@fotonower.com refus_total : 0.17773447145061727 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=21001262 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_P21001262_04-03-2025_09_23_47.pdf results_Auto_P21001262_04-03-2025_09_23_47.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001262_04-03-2025_09_23_47.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','21001262','results_Auto_P21001262_04-03-2025_09_23_47.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001262_04-03-2025_09_23_47.pdf','pdf','','1.06','0.17773447145061727') message_in_mail: Bonjour,
Veuillez trouver ci dessous les résultats du service carac on demand pour le portfolio: https://www.fotonower.com/view/21001262

https://www.fotonower.com/image?json=false&list_photos_id=1334154494
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1334154433
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1334154430
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1334154426
Bravo, la photo est bien prise.
https://www.fotonower.com/image?json=false&list_photos_id=1334154421
Bravo, la photo est bien prise.

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

exemples de contaminants: metal: https://www.fotonower.com/view/21001936?limit=200
exemples de contaminants: papier: https://www.fotonower.com/view/21001937?limit=200
exemples de contaminants: carton: https://www.fotonower.com/view/21001938?limit=200
exemples de contaminants: pet_clair: https://www.fotonower.com/view/21001942?limit=200
exemples de contaminants: autre: https://www.fotonower.com/view/21001944?limit=200
Veuillez trouver le rapport en pdf:https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001262_04-03-2025_09_23_47.pdf.

Lien vers velours :https://www.fotonower.com/velours/21001935,21001936,21001937,21001938,21001939,21001940,21001941,21001942,21001943,21001944,21001945?tags=mal_croppe,metal,papier,carton,pet_fonce,flou,background,pet_clair,pehd,autre,environnement.


L'équipe Fotonower 202 b'' Server: nginx Date: Tue, 04 Mar 2025 08:23:54 GMT Content-Length: 0 Connection: close X-Message-Id: DkN_YfKOTFKqNxkwBZgC5w 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 [1334154494, 1334154433, 1334154430, 1334154426, 1334154421] 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, '2631684') ('3318', '21001262', '1334154494', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154433', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154430', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154426', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154421', None, None, None, None, None, '2631684') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 5 time used for this insertion : 0.01193690299987793 save_final save missing photos in datou_result : time spend for datou_step_exec : 7.224920272827148 time spend to save output : 0.012322664260864258 total time spend for step 9 : 7.237242937088013 step10:split_time_score Tue Mar 4 09:23:54 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('10', 5),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 03022025 21001262 Nombre de photos uploadées : 5 / 23040 (0%) 03022025 21001262 Nombre de photos taguées (types de déchets): 0 / 5 (0%) 03022025 21001262 Nombre de photos taguées (volume) : 0 / 5 (0%) elapsed_time : load_data_split_time_score 2.86102294921875e-06 elapsed_time : order_list_meta_photo_and_scores 9.298324584960938e-06 ????? elapsed_time : fill_and_build_computed_from_old_data 0.0002982616424560547 elapsed_time : insert_dashboard_record_day_entry 0.022403478622436523 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps Qualite : 0.021748578599110682 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001228_04-03-2025_09_11_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21001228 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21001228 AND mptpi.`type`=3726 To do Qualite : 0.17773447145061727 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001262_04-03-2025_09_23_47.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21001262 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`=21001262 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21001267 order by id desc limit 1 Qualite : 0.11845845389660496 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001273_04-03-2025_09_13_38.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21001273 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`=21001273 AND mptpi.`type`=3594 To do Qualite : 0.04425722099928955 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P21001276_04-03-2025_09_13_38.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 21001276 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=21001276 AND mptpi.`type`=3726 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'03022025': {'nb_upload': 5, '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 [1334154494, 1334154433, 1334154430, 1334154426, 1334154421] Looping around the photos to save general results len do output : 1 /21001262Didn'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, '2631684') ('3318', '21001262', '1334154494', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154433', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154430', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154426', None, None, None, None, None, '2631684') ('3318', None, None, None, None, None, None, None, '2631684') ('3318', '21001262', '1334154421', None, None, None, None, None, '2631684') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.05560922622680664 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.2335968017578125 time spend to save output : 0.0559229850769043 total time spend for step 10 : 1.2895197868347168 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 5 set_done_treatment 74.35user 90.42system 3:31.57elapsed 77%CPU (0avgtext+0avgdata 3912052maxresident)k 661064inputs+139952outputs (5766major+7935495minor)pagefaults 0swaps