python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 ~/workarea/git/Velours/python/prod/datou.py -j batch_current -C 3911012' -s traitement_4877 -M 0 -S 0 -U 100,80,95 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/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', '/home/admin/workarea/git/apy', '/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 : 4088367 load datou : 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) 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 : step 0 init_dummy_multi_datou is not linked in the step_by_step architecture ! WARNING : step 1294 init_dummy_multi_datou is not linked in the step_by_step architecture ! 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 ! 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 : (photo_id, hashtag_id, score_max) was removed should we ? (x0, y0, x1, y1) was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (x0, y0, x1, y1) was removed should we ? chemin de la photo was removed should we ? load thcls load pdts 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 : 4877, datou_cur_ids : ['3911012'] with mtr_portfolio_ids : ['27666941'] and first list_photo_ids : [] new path : /proc/4088367/ 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 ! 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 13611 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 13613 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 13613 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 13614 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 13614 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 13615 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 13621 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 13621 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 13617 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 13617 ventilate_hashtags_in_portfolio have less outputs used (0) than in the step definition (1) : some outputs may be not used ! 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 13611 doesn't seem to be define in the database( WARNING : type of input 2 of step 13613 doesn't seem to be define in the database( WARNING : output 1 of step 13611 have datatype=2 whereas input 1 of step 13614 have datatype=7 WARNING : type of output 2 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13615 doesn't seem to be define in the database( WARNING : type of output 3 of step 13614 doesn't seem to be define in the database( WARNING : type of input 1 of step 13617 doesn't seem to be define in the database( WARNING : type of input 2 of step 13621 doesn't seem to be define in the database( WARNING : output 1 of step 13615 have datatype=7 whereas input 2 of step 13621 have datatype=None WARNING : type of output 3 of step 13621 doesn't seem to be define in the database( WARNING : type of input 2 of step 13617 doesn't seem to be define in the database( WARNING : output 0 of step 13614 have datatype=1 whereas input 0 of step 13615 have datatype=2 DataTypes for each output/input checked ! List Step Type Loaded in datou : mask_detect, crop_condition, thcl, merge_mask_thcl_custom, rle_unique_nms_with_priority, crop_condition, ventilate_hashtags_in_portfolio, tfhub_classification2, argmax over limit max, limiting to limit_max 20 list_input_json : [] origin We have 1 , BFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 3 ; length of list_pids : 3 ; length of list_args : 3 time to download the photos : 0.5048732757568359 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 : 9 step1:mask_detect Fri Oct 10 09:15:12 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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 : 10774 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-10-10 09:15:14.936927: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-10-10 09:15:14.966462: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493010000 Hz 2025-10-10 09:15:14.968442: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f368c000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-10-10 09:15:14.968486: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-10-10 09:15:14.971984: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-10-10 09:15:15.086294: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x40566bf0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-10-10 09:15:15.086343: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-10-10 09:15:15.087746: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-10 09:15:15.088112: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:15:15.090784: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:15:15.093292: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 09:15:15.093738: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 09:15:15.096424: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 09:15:15.097613: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 09:15:15.102432: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 09:15:15.103860: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 09:15:15.103918: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:15:15.104645: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-10 09:15:15.104659: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-10 09:15:15.104667: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-10 09:15:15.106042: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9985 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) WARNING:tensorflow:From /home/admin/workarea/git/Velours/python/mtr/mask_rcnn/mask_detection.py:69: The name tf.keras.backend.set_session is deprecated. Please use tf.compat.v1.keras.backend.set_session instead. 2025-10-10 09:15:15.504107: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-10 09:15:15.504179: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:15:15.504196: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:15:15.504209: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 09:15:15.504233: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 09:15:15.504248: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 09:15:15.504261: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 09:15:15.504275: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 09:15:15.505573: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 09:15:15.506679: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-10 09:15:15.506710: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:15:15.506726: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:15:15.506740: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 09:15:15.506754: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 09:15:15.506768: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 09:15:15.506781: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 09:15:15.506795: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 09:15:15.508051: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 09:15:15.508075: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-10 09:15:15.508082: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-10 09:15:15.508089: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-10 09:15:15.509316: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 9985 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 : thcl2896 thcls : [{'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'}] thcl {'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5309 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5309, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 16384, 25088, 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 5, 10, 19, 20, 46), datetime.datetime(2021, 5, 10, 19, 20, 46)) {'thcl': {'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'}, 'list_hashtags': ['background', 'carton_brun', 'carton_gris', 'cartonnette', 'kraft', 'autre_refus', 'metal', 'plastique', 'teint_dans_la_masse', 'environnement'], 'list_hashtags_csv': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'svm_hashtag_type_desc': 5309, 'photo_desc_type': 5309, 'pb_hashtag_id_or_classifier': 0} list_class_names : ['background', 'carton_brun', 'carton_gris', 'cartonnette', 'kraft', 'autre_refus', 'metal', 'plastique', 'teint_dans_la_masse', '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_convoyeur_qualipapia_nantes_poly_100521_1 NUM_CLASSES 10 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_convoyeur_qualipapia_nantes_poly_100521_1 model_type : mask_rcnn list file need : ['mask_model.h5'] file exist in s3 : ['mask_model.h5'] file manque in s3 : [] 2025-10-10 09:15:21.842290: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:15:22.024525: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 local folder : /data/models_weight/learn_convoyeur_qualipapia_nantes_poly_100521_1 /data/models_weight/learn_convoyeur_qualipapia_nantes_poly_100521_1/mask_model.h5 size_local : 256031040 size in s3 : 256031040 create time local : 2021-08-09 05:45:48 create time in s3 : 2021-08-06 18:59:51 mask_model.h5 already exist and didn't need to update list_images length : 3 NEW PHOTO Processing 1 images image shape: (1080, 1632, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1632.00000 nb d'objets trouves : 13 NEW PHOTO Processing 1 images image shape: (1080, 1632, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1632.00000 nb d'objets trouves : 13 NEW PHOTO Processing 1 images image shape: (1080, 1632, 3) min: 0.00000 max: 255.00000 molded_images shape: (1, 640, 640, 3) min: -123.70000 max: 151.10000 image_metas shape: (1, 18) min: 0.00000 max: 1632.00000 nb d'objets trouves : 17 Detection mask done ! Trying to reset tf kernel 4088441 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 5483 tf kernel not reseted sub process len(results) : 3 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 3 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 : 10772 list_Values should be empty [] To do loadFromThcl(), then load ParamDescType : thcl2896 Catched exception ! Connect or reconnect ! thcls : [{'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'}] thcl {'id': 2896, 'mtr_user_id': 31, 'name': 'learn_convoyeur_qualipapia_nantes_poly_100521_1', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'background,carton_brun,carton_gris,cartonnette,kraft,autre_refus,metal,plastique,teint_dans_la_masse,environnement', 'svm_portfolios_learning': '0,0,0,0,0,0,0,0,0,0', 'photo_hashtag_type': 3663, 'photo_desc_type': 5309, 'type_classification': 'mask_rcnn', 'hashtag_id_list': '0,0,0,0,0,0,0,0,0,0'} Update svm_hashtag_type_desc : 5309 ['background', 'carton_brun', 'carton_gris', 'cartonnette', 'kraft', 'autre_refus', 'metal', 'plastique', 'teint_dans_la_masse', 'environnement'] time for calcul the mask position with numpy : 0.00017404556274414062 nb_pixel_total : 3625 time to create 1 rle with old method : 0.004398345947265625 length of segment : 73 time for calcul the mask position with numpy : 6.532669067382812e-05 nb_pixel_total : 852 time to create 1 rle with old method : 0.0010986328125 length of segment : 55 time for calcul the mask position with numpy : 0.00014138221740722656 nb_pixel_total : 4148 time to create 1 rle with old method : 0.004964351654052734 length of segment : 97 time for calcul the mask position with numpy : 0.0002846717834472656 nb_pixel_total : 11551 time to create 1 rle with old method : 0.013888359069824219 length of segment : 74 time for calcul the mask position with numpy : 9.608268737792969e-05 nb_pixel_total : 2600 time to create 1 rle with old method : 0.003179788589477539 length of segment : 77 time for calcul the mask position with numpy : 4.601478576660156e-05 nb_pixel_total : 321 time to create 1 rle with old method : 0.0004513263702392578 length of segment : 21 time for calcul the mask position with numpy : 0.0016970634460449219 nb_pixel_total : 107948 time to create 1 rle with old method : 0.1201024055480957 length of segment : 422 time for calcul the mask position with numpy : 0.005195140838623047 nb_pixel_total : 182151 time to create 1 rle with new method : 0.017203092575073242 length of segment : 870 time for calcul the mask position with numpy : 6.890296936035156e-05 nb_pixel_total : 504 time to create 1 rle with old method : 0.0006699562072753906 length of segment : 29 time for calcul the mask position with numpy : 0.0013883113861083984 nb_pixel_total : 108116 time to create 1 rle with old method : 0.12225818634033203 length of segment : 535 time for calcul the mask position with numpy : 9.608268737792969e-05 nb_pixel_total : 3593 time to create 1 rle with old method : 0.00428318977355957 length of segment : 72 time for calcul the mask position with numpy : 5.2928924560546875e-05 nb_pixel_total : 853 time to create 1 rle with old method : 0.0010533332824707031 length of segment : 55 time for calcul the mask position with numpy : 0.00011420249938964844 nb_pixel_total : 4148 time to create 1 rle with old method : 0.0050182342529296875 length of segment : 97 time for calcul the mask position with numpy : 0.00027489662170410156 nb_pixel_total : 11553 time to create 1 rle with old method : 0.014356613159179688 length of segment : 74 time for calcul the mask position with numpy : 9.274482727050781e-05 nb_pixel_total : 2600 time to create 1 rle with old method : 0.0031485557556152344 length of segment : 77 time for calcul the mask position with numpy : 3.62396240234375e-05 nb_pixel_total : 321 time to create 1 rle with old method : 0.00041556358337402344 length of segment : 21 time for calcul the mask position with numpy : 0.0011816024780273438 nb_pixel_total : 107948 time to create 1 rle with old method : 0.11803436279296875 length of segment : 422 time for calcul the mask position with numpy : 0.003816366195678711 nb_pixel_total : 182155 time to create 1 rle with new method : 0.010721445083618164 length of segment : 870 time for calcul the mask position with numpy : 5.340576171875e-05 nb_pixel_total : 503 time to create 1 rle with old method : 0.0006887912750244141 length of segment : 29 time for calcul the mask position with numpy : 0.0014495849609375 nb_pixel_total : 108133 time to create 1 rle with old method : 0.1346597671508789 length of segment : 534 time for calcul the mask position with numpy : 6.341934204101562e-05 nb_pixel_total : 841 time to create 1 rle with old method : 0.0010471343994140625 length of segment : 56 time for calcul the mask position with numpy : 4.124641418457031e-05 nb_pixel_total : 374 time to create 1 rle with old method : 0.00048828125 length of segment : 38 time for calcul the mask position with numpy : 5.5789947509765625e-05 nb_pixel_total : 774 time to create 1 rle with old method : 0.0010178089141845703 length of segment : 47 time for calcul the mask position with numpy : 3.814697265625e-05 nb_pixel_total : 216 time to create 1 rle with old method : 0.0003261566162109375 length of segment : 23 time for calcul the mask position with numpy : 0.0002486705780029297 nb_pixel_total : 12051 time to create 1 rle with old method : 0.013794422149658203 length of segment : 183 time for calcul the mask position with numpy : 8.940696716308594e-05 nb_pixel_total : 1541 time to create 1 rle with old method : 0.0019145011901855469 length of segment : 107 time for calcul the mask position with numpy : 9.036064147949219e-05 nb_pixel_total : 2881 time to create 1 rle with old method : 0.0036520957946777344 length of segment : 79 time for calcul the mask position with numpy : 0.00016808509826660156 nb_pixel_total : 3936 time to create 1 rle with old method : 0.004721641540527344 length of segment : 127 time for calcul the mask position with numpy : 0.005509853363037109 nb_pixel_total : 334569 time to create 1 rle with new method : 0.020476341247558594 length of segment : 1233 time for calcul the mask position with numpy : 0.00019168853759765625 nb_pixel_total : 7237 time to create 1 rle with old method : 0.008553266525268555 length of segment : 226 time for calcul the mask position with numpy : 6.318092346191406e-05 nb_pixel_total : 1238 time to create 1 rle with old method : 0.0015134811401367188 length of segment : 48 time for calcul the mask position with numpy : 0.0011751651763916016 nb_pixel_total : 99160 time to create 1 rle with old method : 0.1124124526977539 length of segment : 279 time for calcul the mask position with numpy : 0.0001430511474609375 nb_pixel_total : 2007 time to create 1 rle with old method : 0.0026481151580810547 length of segment : 138 time for calcul the mask position with numpy : 6.031990051269531e-05 nb_pixel_total : 1455 time to create 1 rle with old method : 0.0018029212951660156 length of segment : 59 time for calcul the mask position with numpy : 0.00023508071899414062 nb_pixel_total : 13053 time to create 1 rle with old method : 0.015337467193603516 length of segment : 201 time for calcul the mask position with numpy : 0.001622915267944336 nb_pixel_total : 114913 time to create 1 rle with old method : 0.12804079055786133 length of segment : 452 time spent for convertir_results : 2.4537837505340576 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 36 chid ids of type : 3663 Number RLEs to save : 7800 save missing photos in datou_result : time spend for datou_step_exec : 18.498007774353027 time spend to save output : 1.0477583408355713 total time spend for step 1 : 19.5457661151886 step2:crop_condition Fri Oct 10 09:15:31 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure Loading chi in step crop with photo_hashtag_type : 3663 Loading chi in step crop for list_pids : 3 ! batch 1 Loaded 36 chid ids of type : 3663 +++++++++++++++++++++++++++++++++++++++++++++++++++++ begin to crop the class : teint_dans_la_masse param for this class : {'min_score': 0.7} filtre for class : teint_dans_la_masse hashtag_id of this class : 2107752385 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 5 About to insert : list_path_to_insert length 5 new photo from crops ! we have finished the crop for the class : teint_dans_la_masse begin to crop the class : autre_refus param for this class : {'min_score': 0.5} filtre for class : autre_refus hashtag_id of this class : 2107752406 we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 2 About to insert : list_path_to_insert length 2 new photo from crops ! we have finished the crop for the class : autre_refus begin to crop the class : carton_gris param for this class : {'min_score': 0.5} filtre for class : carton_gris hashtag_id of this class : 2107753020 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 ! we have finished the crop for the class : carton_gris begin to crop the class : cartonnette param for this class : {'min_score': 0.5} filtre for class : cartonnette hashtag_id of this class : 702398920 we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 5 About to insert : list_path_to_insert length 5 new photo from crops ! we have finished the crop for the class : cartonnette begin to crop the class : carton_brun param for this class : {'min_score': 0.7} filtre for class : carton_brun hashtag_id of this class : 2107753024 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 ! we have finished the crop for the class : carton_brun begin to crop the class : plastique param for this class : {'min_score': 0.5} filtre for class : plastique hashtag_id of this class : 492725882 begin to crop the class : kraft param for this class : {'min_score': 0.5} filtre for class : kraft hashtag_id of this class : 493202403 begin to crop the class : metal param for this class : {'min_score': 0.5} filtre for class : metal hashtag_id of this class : 492628673 delete rles for these photos Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1388571712, 1388571330, 1388571241] Looping around the photos to save general results len do output : 16 /-3991813641Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813642Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813651Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813652Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813668Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813643Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813653Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813648Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813658Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813673Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813645Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813655Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813666Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813670Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813663Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3991813665Didn'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 ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571712', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571330', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571241', None, None, None, None, None, '3911012') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 51 time used for this insertion : 0.08665680885314941 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.189779758453369 time spend to save output : 0.087677001953125 total time spend for step 2 : 3.277456760406494 step3:thcl Fri Oct 10 09:15:35 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 Beginning of datou step Thcl ! nombre de thcls : 2 we are using the classfication for multi_thcl [2456, 2868] time to import caffe and check if the image exist : 0.0033311843872070312 time to convert the images to numpy array : 1.6689300537109375e-06 time to import caffe and check if the image exist : 0.004536628723144531 time to convert the images to numpy array : 1.430511474609375e-06 time to import caffe and check if the image exist : 0.0036940574645996094 time to convert the images to numpy array : 0.004155635833740234 time to import caffe and check if the image exist : 0.005549192428588867 time to convert the images to numpy array : 0.0035483837127685547 time to import caffe and check if the image exist : 0.005697011947631836 time to convert the images to numpy array : 0.004326820373535156 time to import caffe and check if the image exist : 0.005712270736694336 time to convert the images to numpy array : 0.005769252777099609 time to import caffe and check if the image exist : 0.006916046142578125 time to convert the images to numpy array : 0.011087417602539062 time to import caffe and check if the image exist : 0.004509925842285156 time to convert the images to numpy array : 0.017859697341918945 time to import caffe and check if the image exist : 0.004873037338256836 time to convert the images to numpy array : 0.017452001571655273 time to import caffe and check if the image exist : 0.0036933422088623047 time to convert the images to numpy array : 0.019235849380493164 total time to convert the images to numpy array : 0.20068645477294922 list photo_ids error: [] list photo_ids correct : [-3991813641, -3991813642, -3991813668, -3991813643, -3991813663, -3991813665, -3991813651, -3991813652, -3991813666, -3991813670, -3991813658, -3991813673, -3991813645, -3991813655, -3991813653, -3991813648] number of photos to traite : 16 try to delete the photos incorrect in DB tagging for thcl : 2456 To do loadFromThcl(), then load ParamDescType : thcl2456 thcls : [{'id': 2456, 'mtr_user_id': 31, 'name': 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'papier,refus', 'svm_portfolios_learning': '3028087,3028251', 'photo_hashtag_type': 3049, 'photo_desc_type': 4999, 'type_classification': 'caffe', 'hashtag_id_list': '492668766,538914404'}] thcl {'id': 2456, 'mtr_user_id': 31, 'name': 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'papier,refus', 'svm_portfolios_learning': '3028087,3028251', 'photo_hashtag_type': 3049, 'photo_desc_type': 4999, 'type_classification': 'caffe', 'hashtag_id_list': '492668766,538914404'} Update svm_hashtag_type_desc : 4999 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (4999, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 16384, 25088, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'res5b', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2020, 10, 23, 14, 27, 22), datetime.datetime(2020, 10, 23, 14, 27, 22)) To loadFromThcl() : net_4999 begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 7216 max_wait_temp : 1 max_wait : 0 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (4999, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 16384, 25088, 'learn_qualipapia_papier_refus_from_vlg_data_aug', 'res5b', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2020, 10, 23, 14, 27, 22), datetime.datetime(2020, 10, 23, 14, 27, 22)) None mean_file_type : mean_file_path : prototxt_file_path : model : learn_qualipapia_papier_refus_from_vlg_data_aug Inside get_net Inside get_net before cache_data_model model_param file didn't exist Inside get_net before CDM.load_model_par_type model_name : learn_qualipapia_papier_refus_from_vlg_data_aug model_type : caffe list file need : ['caffemodel', 'deploy_conv_normal.prototxt', 'deploy_fc.prototxt', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file exist in s3 : ['caffemodel', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file manque in s3 : ['deploy_conv_normal.prototxt', 'deploy_fc.prototxt'] local folder : /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/caffemodel size_local : 44972172 size in s3 : 44972172 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:49 caffemodel already exist and didn't need to update /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/deploy.prototxt size_local : 17311 size in s3 : 17311 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:49 deploy.prototxt already exist and didn't need to update /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/mean.npy size_local : 1572992 size in s3 : 1572992 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:51 mean.npy already exist and didn't need to update /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/synset_words.txt size_local : 57 size in s3 : 57 create time local : 2021-08-09 05:55:48 create time in s3 : 2021-08-06 19:28:49 synset_words.txt already exist and didn't need to update Inside get_net after CDM.load_model_par_type After if not only_with_local_cache: /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/:/home/admin/workarea/git/apy/ Here before set mode gpu Doing nothing but we could set mode gpu after set mode gpu prototxt_filename : /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/deploy.prototxt caffemodel_filename : /data/models_weight/learn_qualipapia_papier_refus_from_vlg_data_aug/caffemodel now we set caffe to gpu mode before predict begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 6997 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.14377713203430176 time used to do the prediction : 0.07293009757995605 we don't save the descriptors for this thcl 2456 tagging for thcl : 2868 To do loadFromThcl(), then load ParamDescType : thcl2868 thcls : [{'id': 2868, 'mtr_user_id': 31, 'name': 'learn_papier_nantes_300421', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3752117,3752118,3752123,3752106,3752116,3752124,3752119,3581575,3486029,3752122', 'photo_hashtag_type': 3632, 'photo_desc_type': 5288, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'}] thcl {'id': 2868, 'mtr_user_id': 31, 'name': 'learn_papier_nantes_300421', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3752117,3752118,3752123,3752106,3752116,3752124,3752119,3581575,3486029,3752122', 'photo_hashtag_type': 3632, 'photo_desc_type': 5288, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'} Update svm_hashtag_type_desc : 5288 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5288, 'learn_papier_nantes_300421', 512, 512, 'learn_papier_nantes_300421', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 30, 17, 9, 41), datetime.datetime(2021, 4, 30, 17, 9, 41)) To loadFromThcl() : net_5288 begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 6995 max_wait_temp : 1 max_wait : 0 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5288, 'learn_papier_nantes_300421', 512, 512, 'learn_papier_nantes_300421', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 1, datetime.datetime(2021, 4, 30, 17, 9, 41), datetime.datetime(2021, 4, 30, 17, 9, 41)) None mean_file_type : mean_file_path : prototxt_file_path : model : learn_papier_nantes_300421 Inside get_net Inside get_net before cache_data_model model_param file didn't exist Inside get_net before CDM.load_model_par_type model_name : learn_papier_nantes_300421 model_type : caffe list file need : ['caffemodel', 'deploy_conv_normal.prototxt', 'deploy_fc.prototxt', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file exist in s3 : ['caffemodel', 'deploy.prototxt', 'mean.npy', 'synset_words.txt'] file manque in s3 : ['deploy_conv_normal.prototxt', 'deploy_fc.prototxt'] local folder : /data/models_weight/learn_papier_nantes_300421 /data/models_weight/learn_papier_nantes_300421/caffemodel size_local : 44791983 size in s3 : 44791983 create time local : 2021-08-09 05:55:59 create time in s3 : 2021-08-06 19:22:13 caffemodel already exist and didn't need to update /data/models_weight/learn_papier_nantes_300421/deploy.prototxt size_local : 17255 size in s3 : 17255 create time local : 2021-08-09 05:55:59 create time in s3 : 2021-08-06 19:22:12 deploy.prototxt already exist and didn't need to update /data/models_weight/learn_papier_nantes_300421/mean.npy size_local : 1572992 size in s3 : 1572992 create time local : 2021-08-09 05:55:59 create time in s3 : 2021-08-06 19:22:14 mean.npy already exist and didn't need to update /data/models_weight/learn_papier_nantes_300421/synset_words.txt size_local : 331 size in s3 : 331 create time local : 2021-08-09 05:56:00 create time in s3 : 2021-08-06 19:22:12 synset_words.txt already exist and didn't need to update Inside get_net after CDM.load_model_par_type After if not only_with_local_cache: /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/:/home/admin/workarea/git/apy/ Here before set mode gpu Doing nothing but we could set mode gpu after set mode gpu prototxt_filename : /data/models_weight/learn_papier_nantes_300421/deploy.prototxt caffemodel_filename : /data/models_weight/learn_papier_nantes_300421/caffemodel now we set caffe to gpu mode before predict begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 6995 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.15515804290771484 time used to do the prediction : 0.06720495223999023 we don't save the descriptors for this thcl 2868 Inside saveOutput : final : False verbose : 0 time used to find the portfolios of the photos test new format of the output of the step_thcl begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 0 time used for this insertion : 8.58306884765625e-06 save missing photos in datou_result : time spend for datou_step_exec : 7.429327964782715 time spend to save output : 0.0002701282501220703 total time spend for step 3 : 7.429598093032837 step4:merge_mask_thcl_custom Fri Oct 10 09:15:42 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 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 2 VR 22-3-18 : For now we do not clean correctly the datou structure Begin step merge_mask_thcl_custom batch 1 Loaded 36 chid ids of type : 3663 +++++++++++++++++++++++++++++++++++++++++++++++++++++As expected we have just one thcl present End of step merge_mask_thcl_custom Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : merge_mask_thcl_custom we use saveGeneral [1388571712, 1388571330, 1388571241] Looping around the photos to save general results len do output : 3 /1388571712Didn't retrieve data .Didn't retrieve data . /1388571330Didn't retrieve data .Didn't retrieve data . /1388571241Didn'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 : Managing all output in save final without adding information in the mtr_datou_result ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571712', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571330', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571241', None, None, None, None, None, '3911012') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.03550314903259277 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.19919657707214355 time spend to save output : 0.035809993743896484 total time spend for step 4 : 0.23500657081604004 step5:rle_unique_nms_with_priority Fri Oct 10 09:15:42 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 Begin step rle-unique-nms nb_obj : 9 nb_hashtags : 3 time to prepare the origin masks : 0.66473388671875 time for calcul the mask position with numpy : 0.016466856002807617 nb_pixel_total : 1429128 time to create 1 rle with new method : 0.03713107109069824 time for calcul the mask position with numpy : 0.005646705627441406 nb_pixel_total : 21242 time to create 1 rle with old method : 0.023202180862426758 time for calcul the mask position with numpy : 0.005289793014526367 nb_pixel_total : 11464 time to create 1 rle with old method : 0.01381826400756836 time for calcul the mask position with numpy : 0.007063865661621094 nb_pixel_total : 109376 time to create 1 rle with old method : 0.13173723220825195 time for calcul the mask position with numpy : 0.0058078765869140625 nb_pixel_total : 496 time to create 1 rle with old method : 0.0006349086761474609 time for calcul the mask position with numpy : 0.00668025016784668 nb_pixel_total : 181958 time to create 1 rle with new method : 0.041622161865234375 time for calcul the mask position with numpy : 0.0058460235595703125 nb_pixel_total : 317 time to create 1 rle with old method : 0.00040340423583984375 time for calcul the mask position with numpy : 0.0058269500732421875 nb_pixel_total : 846 time to create 1 rle with old method : 0.0010204315185546875 time for calcul the mask position with numpy : 0.005966901779174805 nb_pixel_total : 3612 time to create 1 rle with old method : 0.004244089126586914 time for calcul the mask position with numpy : 0.005939006805419922 nb_pixel_total : 4121 time to create 1 rle with old method : 0.004774808883666992 create new chi : 0.33343052864074707 time to delete rle : 0.06902790069580078 batch 1 Loaded 10 chid ids of type : 3726 Number RLEs to save : 4690 TO DO : save crop sub photo not yet done ! save time : 0.6114537715911865 nb_obj : 9 nb_hashtags : 3 time to prepare the origin masks : 0.7321047782897949 time for calcul the mask position with numpy : 0.0171051025390625 nb_pixel_total : 1428844 time to create 1 rle with new method : 0.05823564529418945 time for calcul the mask position with numpy : 0.005813121795654297 nb_pixel_total : 21242 time to create 1 rle with old method : 0.023673057556152344 time for calcul the mask position with numpy : 0.005707740783691406 nb_pixel_total : 11468 time to create 1 rle with old method : 0.012984752655029297 time for calcul the mask position with numpy : 0.00605010986328125 nb_pixel_total : 109341 time to create 1 rle with old method : 0.1203773021697998 time for calcul the mask position with numpy : 0.005443572998046875 nb_pixel_total : 495 time to create 1 rle with old method : 0.0005936622619628906 time for calcul the mask position with numpy : 0.006192207336425781 nb_pixel_total : 182297 time to create 1 rle with new method : 0.033299922943115234 time for calcul the mask position with numpy : 0.005384922027587891 nb_pixel_total : 317 time to create 1 rle with old method : 0.00037789344787597656 time for calcul the mask position with numpy : 0.005413532257080078 nb_pixel_total : 846 time to create 1 rle with old method : 0.0010051727294921875 time for calcul the mask position with numpy : 0.00533294677734375 nb_pixel_total : 3589 time to create 1 rle with old method : 0.004103422164916992 time for calcul the mask position with numpy : 0.005406856536865234 nb_pixel_total : 4121 time to create 1 rle with old method : 0.00473332405090332 create new chi : 0.3334949016571045 time to delete rle : 0.0004582405090332031 batch 1 Loaded 10 chid ids of type : 3726 Number RLEs to save : 4676 TO DO : save crop sub photo not yet done ! save time : 0.6058759689331055 nb_obj : 14 nb_hashtags : 4 time to prepare the origin masks : 1.2811739444732666 time for calcul the mask position with numpy : 0.03688669204711914 nb_pixel_total : 1297294 time to create 1 rle with new method : 0.16716527938842773 time for calcul the mask position with numpy : 0.006764650344848633 nb_pixel_total : 99019 time to create 1 rle with old method : 0.11008524894714355 time for calcul the mask position with numpy : 0.006018638610839844 nb_pixel_total : 1450 time to create 1 rle with old method : 0.0016467571258544922 time for calcul the mask position with numpy : 0.005462646484375 nb_pixel_total : 595 time to create 1 rle with old method : 0.0007555484771728516 time for calcul the mask position with numpy : 0.005393266677856445 nb_pixel_total : 2872 time to create 1 rle with old method : 0.003330230712890625 time for calcul the mask position with numpy : 0.0056188106536865234 nb_pixel_total : 7333 time to create 1 rle with old method : 0.00852346420288086 time for calcul the mask position with numpy : 0.007925748825073242 nb_pixel_total : 334035 time to create 1 rle with new method : 0.1497483253479004 time for calcul the mask position with numpy : 0.005377292633056641 nb_pixel_total : 779 time to create 1 rle with old method : 0.0009679794311523438 time for calcul the mask position with numpy : 0.005461215972900391 nb_pixel_total : 216 time to create 1 rle with old method : 0.000274658203125 time for calcul the mask position with numpy : 0.005414009094238281 nb_pixel_total : 3915 time to create 1 rle with old method : 0.00452423095703125 time for calcul the mask position with numpy : 0.005297660827636719 nb_pixel_total : 1061 time to create 1 rle with old method : 0.0013580322265625 time for calcul the mask position with numpy : 0.0055272579193115234 nb_pixel_total : 769 time to create 1 rle with old method : 0.0009262561798095703 time for calcul the mask position with numpy : 0.005754232406616211 nb_pixel_total : 368 time to create 1 rle with old method : 0.0004413127899169922 time for calcul the mask position with numpy : 0.005935192108154297 nb_pixel_total : 12026 time to create 1 rle with old method : 0.013842344284057617 time for calcul the mask position with numpy : 0.005759477615356445 nb_pixel_total : 828 time to create 1 rle with old method : 0.0009884834289550781 create new chi : 0.5900888442993164 time to delete rle : 0.0006225109100341797 batch 1 Loaded 15 chid ids of type : 3726 Number RLEs to save : 6334 TO DO : save crop sub photo not yet done ! save time : 0.7412734031677246 map_output_result : {1388571712: (0.0, 'Should be the crop_list due to order', 0.0), 1388571330: (0.0, 'Should be the crop_list due to order', 0.0), 1388571241: (0.0, 'Should be the crop_list due to order', 0.0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1388571712, 1388571330, 1388571241] Looping around the photos to save general results len do output : 3 /1388571712.Didn't retrieve data . /1388571330.Didn't retrieve data . /1388571241.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 ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571712', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571330', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571241', None, None, None, None, None, '3911012') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.03664588928222656 save_final save missing photos in datou_result : time spend for datou_step_exec : 6.1150617599487305 time spend to save output : 0.036966562271118164 total time spend for step 5 : 6.152028322219849 step6:crop_condition Fri Oct 10 09:15:49 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure some photos are not treated, begin crop_condition Loading chi in step crop with photo_hashtag_type : 3726 Loading chi in step crop for list_pids : 3 ! batch 1 Loaded 35 chid ids of type : 3726 begin to crop the class : teint_dans_la_masse param for this class : {'min_score': 0.7} filtre for class : teint_dans_la_masse hashtag_id of this class : 2107752385 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 : 4869462 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1760080549_4088367 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760080550), 0.0, 0.0, 14, '', 0, 0, '1760080511_4088367_1388571241_fe7063abe0af83ee9c5a54eb27693ddc_rle_crop_3991813986_0.png', 0, 84, 127, 0, 1760080550,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 1 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.6544866561889648 we have finished the crop for the class : teint_dans_la_masse begin to crop the class : autre_refus param for this class : {'min_score': 0.5} filtre for class : autre_refus hashtag_id of this class : 2107752406 begin to crop the class : carton_gris param for this class : {'min_score': 0.5} filtre for class : carton_gris hashtag_id of this class : 2107753020 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 : 4869462 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1760080550_4088367 INSERT INTO MTRBack.photos (`timeStamp`, `latitude`, `longitude`, `right_categories`, `tags`, `speed`, `size`, `text`, `altitude`, `width`, `height`, `score`, `created_at`,`source_id`,`place_id`) VALUES (FROM_UNIXTIME(1760080550), 0.0, 0.0, 14, '', 0, 0, '1760080511_4088367_1388571241_fe7063abe0af83ee9c5a54eb27693ddc_rle_crop_3991813982_0.png', 0, 137, 108, 0, 1760080550,'0',0) batch_size : 0, verbose : False, strat_bulk_insert : ignore_different_from_first This is a hack ! we have uploaded 1 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.7652740478515625 we have finished the crop for the class : carton_gris begin to crop the class : cartonnette param for this class : {'min_score': 0.5} filtre for class : cartonnette hashtag_id of this class : 702398920 begin to crop the class : carton_brun param for this class : {'min_score': 0.7} filtre for class : carton_brun hashtag_id of this class : 2107753024 begin to crop the class : plastique param for this class : {'min_score': 0.5} filtre for class : plastique hashtag_id of this class : 492725882 begin to crop the class : kraft param for this class : {'min_score': 0.5} filtre for class : kraft hashtag_id of this class : 493202403 begin to crop the class : metal param for this class : {'min_score': 0.5} filtre for class : metal hashtag_id of this class : 492628673 delete rles for these photos Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : crop_condition we use saveGeneral [1388571712, 1388571330, 1388571241] Looping around the photos to save general results len do output : 2 /1388628594Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1388628596Didn'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 ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571712', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571330', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571241', None, None, None, None, None, '3911012') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.036936283111572266 save_final save missing photos in datou_result : time spend for datou_step_exec : 2.304610252380371 time spend to save output : 0.03719687461853027 total time spend for step 6 : 2.3418071269989014 step7:ventilate_hashtags_in_portfolio Fri Oct 10 09:15:51 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed 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 ! To do loadFromThcl(), then load ParamDescType : thcl2725 thcls : [{'id': 2725, 'mtr_user_id': 31, 'name': 'learn_qualipapia_rle_210302_2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3460440,3460441,3460446,3460434,3460439,3467416,3460442,3460443,3486028,3460445', 'photo_hashtag_type': 3410, 'photo_desc_type': 5186, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'}] thcl {'id': 2725, 'mtr_user_id': 31, 'name': 'learn_qualipapia_rle_210302_2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Carton_brun,Carton_gris,Teint_Dans_La_Masse,autre_refus,cartonnette,environnement,kraft,metal,papier,plastique', 'svm_portfolios_learning': '3460440,3460441,3460446,3460434,3460439,3467416,3460442,3460443,3486028,3460445', 'photo_hashtag_type': 3410, 'photo_desc_type': 5186, 'type_classification': 'caffe', 'hashtag_id_list': '2107753024,2107753020,2107752385,2107752406,702398920,493012381,493202403,492628673,492668766,492725882'} Update svm_hashtag_type_desc : 5186 Iterating over portfolio : 27666941 get user id for portfolio 27666941 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`=27666941 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','environnement','mal_croppe','Carton_brun','Teint_Dans_La_Masse','Carton_gris','autre_refus','papier','kraft','metal','plastique','flou')) 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`=27666941 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','environnement','mal_croppe','Carton_brun','Teint_Dans_La_Masse','Carton_gris','autre_refus','papier','kraft','metal','plastique','flou')) 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") 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`=27666941 AND mptpi.`type`=4417 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','environnement','mal_croppe','Carton_brun','Teint_Dans_La_Masse','Carton_gris','autre_refus','papier','kraft','metal','plastique','flou')) 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`=27666941 AND mptpi.`type`=4417 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','environnement','mal_croppe','Carton_brun','Teint_Dans_La_Masse','Carton_gris','autre_refus','papier','kraft','metal','plastique','flou')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://marlene.fotonower.com/velours/27684764,27684765,27684766,27684767,27684768,27684769,27684770,27684771,27684772,27684773,27684774,27684775?tags=cartonnette,environnement,mal_croppe,Carton_brun,Teint_Dans_La_Masse,Carton_gris,autre_refus,papier,kraft,metal,plastique,flou Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1388571712, 1388571330, 1388571241] Looping around the photos to save general results len do output : 1 /27666941. 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 ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571712', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571330', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571241', None, None, None, None, None, '3911012') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 4 time used for this insertion : 0.03605318069458008 save_final save missing photos in datou_result : time spend for datou_step_exec : 6.88223934173584 time spend to save output : 0.036255836486816406 total time spend for step 7 : 6.918495178222656 step8:tfhub_classification2 Fri Oct 10 09:15:58 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure Beginning of datou_step TFHub with tf2 ! nombre de thcls : 3 we are using the classfication for multi_thcl [3513, 3379, 3847] begin to check gpu status inside check gpu memory 2025-10-10 09:16:01.005861: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-10-10 09:16:01.006644: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-10 09:16:01.006715: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:16:01.006761: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:16:01.008565: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 09:16:01.008670: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 09:16:01.010765: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 09:16:01.011983: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 09:16:01.016898: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 09:16:01.018552: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 09:16:01.019030: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-10-10 09:16:01.027542: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493010000 Hz 2025-10-10 09:16:01.028941: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f3578000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-10-10 09:16:01.028973: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-10-10 09:16:01.032291: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x3d5f77d0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-10-10 09:16:01.032345: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-10-10 09:16:01.033247: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-10-10 09:16:01.033317: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:16:01.033339: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:16:01.033408: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-10-10 09:16:01.033428: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-10-10 09:16:01.033465: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-10-10 09:16:01.033489: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-10-10 09:16:01.033514: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-10-10 09:16:01.034660: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-10-10 09:16:01.034725: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-10-10 09:16:01.034780: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-10-10 09:16:01.034790: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-10-10 09:16:01.034798: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-10-10 09:16:01.035925: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 3096 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) l 3637 free memory gpu now : 6774 max_wait_temp : 1 max_wait : 5 1 Physical GPUs, 1 Logical GPUs tagging for thcl : 3513 To do loadFromThcl(), then load ParamDescType : thcl3513 thcls : [{'id': 3513, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2_tf', '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': 4557, 'photo_desc_type': 5767, 'type_classification': 'tf_classification2', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] thcl {'id': 3513, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2_tf', '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': 4557, 'photo_desc_type': 5767, 'type_classification': 'tf_classification2', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'} Update svm_hashtag_type_desc : 5767 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5767, 'Rungis_amount_dechets_fall_2018_v2_tf', 2048, 2048, 'Rungis_amount_dechets_fall_2018_v2_tf', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 3, datetime.datetime(2023, 3, 16, 15, 52, 10), datetime.datetime(2023, 3, 16, 15, 52, 10)) model_name : Rungis_amount_dechets_fall_2018_v2_tf model_param file didn't exist model_name : Rungis_amount_dechets_fall_2018_v2_tf model_type : tf_classification2 list file need : ['Confusion_Matrix.png', 'Precision_Recall_05102018_Papier_non_papier_dense.jpg', 'Precision_Recall_05102018_Papier_non_papier_peu_dense.jpg', 'Precision_Recall_05102018_Papier_non_papier_presque_vide.jpg', 'Precision_Recall_05102018_Papier_non_papier_tres_dense.jpg', 'Precision_Recall_05102018_Papier_non_papier_tres_peu_dense.jpg', 'Result_Summary.txt', 'checkpoint', 'model_checkpoint.ckpt.data-00000-of-00001', 'model_checkpoint.ckpt.data-00000-of-00002', 'model_checkpoint.ckpt.data-00001-of-00002', 'model_checkpoint.ckpt.index', 'model_weights.h5'] file exist in s3 : ['Confusion_Matrix.png', 'Precision_Recall_05102018_Papier_non_papier_dense.jpg', 'Precision_Recall_05102018_Papier_non_papier_peu_dense.jpg', 'Precision_Recall_05102018_Papier_non_papier_presque_vide.jpg', 'Precision_Recall_05102018_Papier_non_papier_tres_dense.jpg', 'Precision_Recall_05102018_Papier_non_papier_tres_peu_dense.jpg', 'Result_Summary.txt', 'checkpoint', 'model_checkpoint.ckpt.data-00000-of-00001', 'model_checkpoint.ckpt.data-00000-of-00002', 'model_checkpoint.ckpt.data-00001-of-00002', 'model_checkpoint.ckpt.index', 'model_weights.h5'] file manque in s3 : [] local folder : /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Confusion_Matrix.png size_local : 67810 size in s3 : 67810 create time local : 2023-10-30 16:21:37 create time in s3 : 2023-10-30 14:09:29 Confusion_Matrix.png already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Precision_Recall_05102018_Papier_non_papier_dense.jpg size_local : 73949 size in s3 : 73949 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:30 Precision_Recall_05102018_Papier_non_papier_dense.jpg already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Precision_Recall_05102018_Papier_non_papier_peu_dense.jpg size_local : 85572 size in s3 : 85572 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:39 Precision_Recall_05102018_Papier_non_papier_peu_dense.jpg already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Precision_Recall_05102018_Papier_non_papier_presque_vide.jpg size_local : 72361 size in s3 : 72361 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:37 Precision_Recall_05102018_Papier_non_papier_presque_vide.jpg already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Precision_Recall_05102018_Papier_non_papier_tres_dense.jpg size_local : 83567 size in s3 : 83567 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:48 Precision_Recall_05102018_Papier_non_papier_tres_dense.jpg already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Precision_Recall_05102018_Papier_non_papier_tres_peu_dense.jpg size_local : 71611 size in s3 : 71611 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:29 Precision_Recall_05102018_Papier_non_papier_tres_peu_dense.jpg already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/Result_Summary.txt size_local : 1058 size in s3 : 1058 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:30 Result_Summary.txt already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/checkpoint size_local : 99 size in s3 : 99 create time local : 2023-10-30 16:21:38 create time in s3 : 2023-10-30 14:09:36 checkpoint already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/model_checkpoint.ckpt.data-00000-of-00001 size_local : 188538519 size in s3 : 188538519 create time local : 2023-10-30 16:21:41 create time in s3 : 2023-10-30 14:09:40 model_checkpoint.ckpt.data-00000-of-00001 already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/model_checkpoint.ckpt.data-00000-of-00002 size_local : 216572 size in s3 : 216572 create time local : 2023-10-30 16:21:41 create time in s3 : 2023-03-16 14:52:09 model_checkpoint.ckpt.data-00000-of-00002 already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/model_checkpoint.ckpt.data-00001-of-00002 size_local : 32279708 size in s3 : 32279708 create time local : 2023-10-30 16:21:42 create time in s3 : 2023-03-16 14:52:07 model_checkpoint.ckpt.data-00001-of-00002 already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/model_checkpoint.ckpt.index size_local : 28001 size in s3 : 28001 create time local : 2023-10-30 16:21:42 create time in s3 : 2023-10-30 14:09:30 model_checkpoint.ckpt.index already exist and didn't need to update /data/models_weight/Rungis_amount_dechets_fall_2018_v2_tf/model_weights.h5 size_local : 94501976 size in s3 : 94501976 create time local : 2023-10-30 16:21:44 create time in s3 : 2023-10-30 14:09:37 model_weights.h5 already exist and didn't need to update desc size : 2048 Model: "sequential" _________________________________________________________________ Layer (type) Output Shape Param # ================================================================= module (KerasLayer) (None, 2048) 23561152 _________________________________________________________________ Rungis_amount_dechets_fall_2 (None, 5) 10245 ================================================================= Total params: 23,571,397 Trainable params: 10,245 Non-trainable params: 23,561,152 _________________________________________________________________ Loading Weights... time used to create the model : 7.733047246932983 time used to load_weights : 0.1533653736114502 0it [00:00, ?it/s] 3it [00:00, 2157.19it/s]2025-10-10 09:16:11.583289: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-10-10 09:16:11.610207: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 temp/1760080511_4088367_1388571712_6880acc5e20b7d9bb62f885e795e690f.jpg temp/1760080511_4088367_1388571330_df8f9b60b9e5237a773dd199673f2879.jpg temp/1760080511_4088367_1388571241_fe7063abe0af83ee9c5a54eb27693ddc.jpg Found 3 images belonging to 1 classes. begin to do the prediction : time used to do the prediction : 2.1974313259124756 (3,) (3, 5) (3, 2048) shape of features : (3, 2048) shape of new features : (1, 3, 2048) save descriptor for thcl : 3513 time to traite the descriptors : 0.029062271118164062 storage_type for insertDescriptorsMulti : 3 To insert : 1388571712 To insert : 1388571330 To insert : 1388571241 Catched exception ! Connect or reconnect ! time to insert the descriptors : 2.2701032161712646 tagging for thcl : 3379 To do loadFromThcl(), then load ParamDescType : thcl3379 thcls : [{'id': 3379, 'mtr_user_id': 31, 'name': 'learn_classif_flux_maj_generique_effnet_v2_s_02062022', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'aluminium,ela,film_pedb,flux_dev,jrm,pcm,pcnc,pehd_pp,pet_clair,refus,tapis_vide', 'svm_portfolios_learning': '5515864,5515840,5515844,5515850,6244400,6237996,6237998,5515847,5515841,5515868,5515866', 'photo_hashtag_type': 4374, 'photo_desc_type': 5680, 'type_classification': 'tf_classification2', 'hashtag_id_list': '493546845,492741797,2107760237,2107760238,495916461,560181804,1284539308,2107760239,2107755846,538914404,2107748999'}] thcl {'id': 3379, 'mtr_user_id': 31, 'name': 'learn_classif_flux_maj_generique_effnet_v2_s_02062022', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'aluminium,ela,film_pedb,flux_dev,jrm,pcm,pcnc,pehd_pp,pet_clair,refus,tapis_vide', 'svm_portfolios_learning': '5515864,5515840,5515844,5515850,6244400,6237996,6237998,5515847,5515841,5515868,5515866', 'photo_hashtag_type': 4374, 'photo_desc_type': 5680, 'type_classification': 'tf_classification2', 'hashtag_id_list': '493546845,492741797,2107760237,2107760238,495916461,560181804,1284539308,2107760239,2107755846,538914404,2107748999'} Update svm_hashtag_type_desc : 5680 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (5680, 'learn_classif_flux_maj_generique_effnet_v2_s_02062022', 1280, 1280, 'learn_classif_flux_maj_generique_effnet_v2_s_02062022', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 3, datetime.datetime(2022, 6, 4, 1, 31, 10), datetime.datetime(2022, 6, 4, 1, 31, 10)) model_name : learn_classif_flux_maj_generique_effnet_v2_s_02062022 model_param file didn't exist model_name : learn_classif_flux_maj_generique_effnet_v2_s_02062022 model_type : tf_classification2 list file need : ['Confusion_Matrix.png', 'Precision_Recall_aluminium.jpg', 'Precision_Recall_ela.jpg', 'Precision_Recall_film_pedb.jpg', 'Precision_Recall_flux_dev.jpg', 'Precision_Recall_jrm.jpg', 'Precision_Recall_pcm.jpg', 'Precision_Recall_pcnc.jpg', 'Precision_Recall_pehd_pp.jpg', 'Precision_Recall_pet_clair.jpg', 'Precision_Recall_refus.jpg', 'Precision_Recall_tapis_vide.jpg', 'Result_Summary.txt', 'checkpoint', 'model_checkpoint.ckpt.data-00000-of-00002', 'model_checkpoint.ckpt.data-00001-of-00002', 'model_checkpoint.ckpt.index', 'model_weights.h5'] file exist in s3 : ['Confusion_Matrix.png', 'Precision_Recall_aluminium.jpg', 'Precision_Recall_ela.jpg', 'Precision_Recall_film_pedb.jpg', 'Precision_Recall_flux_dev.jpg', 'Precision_Recall_jrm.jpg', 'Precision_Recall_pcm.jpg', 'Precision_Recall_pcnc.jpg', 'Precision_Recall_pehd_pp.jpg', 'Precision_Recall_pet_clair.jpg', 'Precision_Recall_refus.jpg', 'Precision_Recall_tapis_vide.jpg', 'Result_Summary.txt', 'checkpoint', 'model_checkpoint.ckpt.data-00000-of-00002', 'model_checkpoint.ckpt.data-00001-of-00002', 'model_checkpoint.ckpt.index', 'model_weights.h5'] file manque in s3 : [] local folder : /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022 /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Confusion_Matrix.png size_local : 82527 size in s3 : 82527 create time local : 2022-06-06 13:01:24 create time in s3 : 2022-06-03 23:31:09 Confusion_Matrix.png already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_aluminium.jpg size_local : 67602 size in s3 : 67602 create time local : 2022-06-06 13:01:24 create time in s3 : 2022-06-03 23:23:41 Precision_Recall_aluminium.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_ela.jpg size_local : 67189 size in s3 : 67189 create time local : 2022-06-06 13:01:25 create time in s3 : 2022-06-03 23:26:13 Precision_Recall_ela.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_film_pedb.jpg size_local : 71280 size in s3 : 71280 create time local : 2022-06-06 13:01:25 create time in s3 : 2022-06-03 23:26:14 Precision_Recall_film_pedb.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_flux_dev.jpg size_local : 59936 size in s3 : 59936 create time local : 2022-06-06 13:01:25 create time in s3 : 2022-06-03 23:23:41 Precision_Recall_flux_dev.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_jrm.jpg size_local : 67657 size in s3 : 67657 create time local : 2022-06-06 13:01:25 create time in s3 : 2022-06-03 23:31:06 Precision_Recall_jrm.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_pcm.jpg size_local : 83042 size in s3 : 83042 create time local : 2022-06-06 13:01:25 create time in s3 : 2022-06-03 23:23:40 Precision_Recall_pcm.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_pcnc.jpg size_local : 69972 size in s3 : 69972 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:31:05 Precision_Recall_pcnc.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_pehd_pp.jpg size_local : 67313 size in s3 : 67313 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:23:45 Precision_Recall_pehd_pp.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_pet_clair.jpg size_local : 67320 size in s3 : 67320 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:31:04 Precision_Recall_pet_clair.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_refus.jpg size_local : 59936 size in s3 : 59936 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:31:08 Precision_Recall_refus.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Precision_Recall_tapis_vide.jpg size_local : 80244 size in s3 : 80244 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:23:45 Precision_Recall_tapis_vide.jpg already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/Result_Summary.txt size_local : 1018 size in s3 : 1018 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:31:08 Result_Summary.txt already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/checkpoint size_local : 99 size in s3 : 99 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:31:06 checkpoint already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/model_checkpoint.ckpt.data-00000-of-00002 size_local : 216640 size in s3 : 216640 create time local : 2022-06-06 13:01:27 create time in s3 : 2022-06-03 23:23:43 model_checkpoint.ckpt.data-00000-of-00002 already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/model_checkpoint.ckpt.data-00001-of-00002 size_local : 32341196 size in s3 : 32341196 create time local : 2022-06-06 13:01:28 create time in s3 : 2022-06-03 23:26:15 model_checkpoint.ckpt.data-00001-of-00002 already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/model_checkpoint.ckpt.index size_local : 43546 size in s3 : 43546 create time local : 2022-06-06 13:01:28 create time in s3 : 2022-06-03 23:26:13 model_checkpoint.ckpt.index already exist and didn't need to update /data/models_weight/learn_classif_flux_maj_generique_effnet_v2_s_02062022/model_weights.h5 size_local : 16531224 size in s3 : 16531224 create time local : 2022-06-06 13:01:29 create time in s3 : 2022-06-03 23:23:46 model_weights.h5 already exist and didn't need to update desc size : 1280 Model: "sequential" _________________________________________________________________ Layer (type) Output Shape Param # ================================================================= module (KerasLayer) (None, 1280) 4049564 _________________________________________________________________ learn_classif_flux_maj_gener (None, 11) 14091 ================================================================= Total params: 4,063,655 Trainable params: 14,091 Non-trainable params: 4,049,564 _________________________________________________________________ Loading Weights... time used to create the model : 6.9917380809783936 time used to load_weights : 0.10987687110900879 0it [00:00, ?it/s] 3it [00:00, 2787.53it/s]temp/1760080511_4088367_1388571712_6880acc5e20b7d9bb62f885e795e690f.jpg temp/1760080511_4088367_1388571330_df8f9b60b9e5237a773dd199673f2879.jpg temp/1760080511_4088367_1388571241_fe7063abe0af83ee9c5a54eb27693ddc.jpg Found 3 images belonging to 1 classes. begin to do the prediction : time used to do the prediction : 1.0500786304473877 (3,) (3, 11) (3, 1280) shape of features : (3, 1280) shape of new features : (1, 3, 1280) save descriptor for thcl : 3379 time to traite the descriptors : 0.037279367446899414 storage_type for insertDescriptorsMulti : 3 To insert : 1388571712 To insert : 1388571330 To insert : 1388571241 time to insert the descriptors : 1.1270692348480225 tagging for thcl : 3847 To do loadFromThcl(), then load ParamDescType : thcl3847 thcls : [{'id': 3847, 'mtr_user_id': 31, 'name': 'learn_MM_generique_050224', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'aluminium,ela,emr,film_pedb,flux_dev,jrm,pcm,pcnc,pehd_pp,pet_clair,refus,tapis_vide', 'svm_portfolios_learning': '13096157,13096155,13096163,13096159,13301956,13095886,13096162,13096160,13358264,13096158,5515868,13276803', 'photo_hashtag_type': 4932, 'photo_desc_type': 6032, 'type_classification': 'tf_classification2', 'hashtag_id_list': '493546845,492741797,616987804,2107760237,2107760238,495916461,560181804,1284539308,2107760239,2107755846,538914404,2107748999'}] thcl {'id': 3847, 'mtr_user_id': 31, 'name': 'learn_MM_generique_050224', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'aluminium,ela,emr,film_pedb,flux_dev,jrm,pcm,pcnc,pehd_pp,pet_clair,refus,tapis_vide', 'svm_portfolios_learning': '13096157,13096155,13096163,13096159,13301956,13095886,13096162,13096160,13358264,13096158,5515868,13276803', 'photo_hashtag_type': 4932, 'photo_desc_type': 6032, 'type_classification': 'tf_classification2', 'hashtag_id_list': '493546845,492741797,616987804,2107760237,2107760238,495916461,560181804,1284539308,2107760239,2107755846,538914404,2107748999'} Update svm_hashtag_type_desc : 6032 FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (6032, 'learn_MM_generique_050224', 1280, 1280, 'learn_MM_generique_050224', 'pool5', 10.0, None, None, 256, None, 0, None, 8, None, None, -1000.0, 3, datetime.datetime(2024, 2, 5, 21, 42, 4), datetime.datetime(2024, 2, 5, 21, 42, 4)) model_name : learn_MM_generique_050224 model_param file didn't exist model_name : learn_MM_generique_050224 model_type : tf_classification2 list file need : ['Confusion_Matrix.png', 'Precision_Recall_aluminium.jpg', 'Precision_Recall_ela.jpg', 'Precision_Recall_emr.jpg', 'Precision_Recall_film_pedb.jpg', 'Precision_Recall_flux_dev.jpg', 'Precision_Recall_jrm.jpg', 'Precision_Recall_pcm.jpg', 'Precision_Recall_pcnc.jpg', 'Precision_Recall_pehd_pp.jpg', 'Precision_Recall_pet_clair.jpg', 'Precision_Recall_refus.jpg', 'Precision_Recall_tapis_vide.jpg', 'Result_Summary.txt', 'checkpoint', 'model_checkpoint.ckpt.data-00000-of-00001', 'model_checkpoint.ckpt.index', 'model_weights.h5'] file exist in s3 : ['Confusion_Matrix.png', 'Precision_Recall_aluminium.jpg', 'Precision_Recall_ela.jpg', 'Precision_Recall_emr.jpg', 'Precision_Recall_film_pedb.jpg', 'Precision_Recall_flux_dev.jpg', 'Precision_Recall_jrm.jpg', 'Precision_Recall_pcm.jpg', 'Precision_Recall_pcnc.jpg', 'Precision_Recall_pehd_pp.jpg', 'Precision_Recall_pet_clair.jpg', 'Precision_Recall_refus.jpg', 'Precision_Recall_tapis_vide.jpg', 'Result_Summary.txt', 'checkpoint', 'model_checkpoint.ckpt.data-00000-of-00001', 'model_checkpoint.ckpt.index', 'model_weights.h5'] file manque in s3 : [] local folder : /data/models_weight/learn_MM_generique_050224 /data/models_weight/learn_MM_generique_050224/Confusion_Matrix.png size_local : 88145 size in s3 : 88145 create time local : 2024-04-08 09:17:48 create time in s3 : 2024-02-05 20:41:54 Confusion_Matrix.png already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_aluminium.jpg size_local : 67983 size in s3 : 67983 create time local : 2024-04-08 09:17:48 create time in s3 : 2024-02-05 20:42:02 Precision_Recall_aluminium.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_ela.jpg size_local : 68484 size in s3 : 68484 create time local : 2024-04-08 09:17:48 create time in s3 : 2024-02-05 20:42:04 Precision_Recall_ela.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_emr.jpg size_local : 77930 size in s3 : 77930 create time local : 2024-04-08 09:17:48 create time in s3 : 2024-02-05 20:41:55 Precision_Recall_emr.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_film_pedb.jpg size_local : 66701 size in s3 : 66701 create time local : 2024-04-08 09:17:48 create time in s3 : 2024-02-05 20:41:55 Precision_Recall_film_pedb.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_flux_dev.jpg size_local : 59936 size in s3 : 59936 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:04 Precision_Recall_flux_dev.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_jrm.jpg size_local : 72890 size in s3 : 72890 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:04 Precision_Recall_jrm.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_pcm.jpg size_local : 93916 size in s3 : 93916 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:02 Precision_Recall_pcm.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_pcnc.jpg size_local : 74701 size in s3 : 74701 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:04 Precision_Recall_pcnc.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_pehd_pp.jpg size_local : 68765 size in s3 : 68765 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:03 Precision_Recall_pehd_pp.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_pet_clair.jpg size_local : 69649 size in s3 : 69649 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:03 Precision_Recall_pet_clair.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_refus.jpg size_local : 59936 size in s3 : 59936 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:41:59 Precision_Recall_refus.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Precision_Recall_tapis_vide.jpg size_local : 71529 size in s3 : 71529 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:41:54 Precision_Recall_tapis_vide.jpg already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/Result_Summary.txt size_local : 1076 size in s3 : 1076 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:41:55 Result_Summary.txt already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/checkpoint size_local : 99 size in s3 : 99 create time local : 2024-04-08 09:17:49 create time in s3 : 2024-02-05 20:42:00 checkpoint already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/model_checkpoint.ckpt.data-00000-of-00001 size_local : 32591049 size in s3 : 32591049 create time local : 2024-04-08 09:17:50 create time in s3 : 2024-02-05 20:42:02 model_checkpoint.ckpt.data-00000-of-00001 already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/model_checkpoint.ckpt.index size_local : 42495 size in s3 : 42495 create time local : 2024-04-08 09:17:50 create time in s3 : 2024-02-05 20:41:55 model_checkpoint.ckpt.index already exist and didn't need to update /data/models_weight/learn_MM_generique_050224/model_weights.h5 size_local : 16536200 size in s3 : 16536200 create time local : 2024-04-08 09:17:50 create time in s3 : 2024-02-05 20:42:00 model_weights.h5 already exist and didn't need to update desc size : 1280 Model: "sequential" _________________________________________________________________ Layer (type) Output Shape Param # ================================================================= module (KerasLayer) (None, 1280) 4049564 _________________________________________________________________ learn_MM_generique_050224den (None, 12) 15372 ================================================================= Total params: 4,064,936 Trainable params: 15,372 Non-trainable params: 4,049,564 _________________________________________________________________ Loading Weights... time used to create the model : 7.25700569152832 time used to load_weights : 0.10146784782409668 0it [00:00, ?it/s] 3it [00:00, 2630.21it/s]temp/1760080511_4088367_1388571712_6880acc5e20b7d9bb62f885e795e690f.jpg temp/1760080511_4088367_1388571330_df8f9b60b9e5237a773dd199673f2879.jpg temp/1760080511_4088367_1388571241_fe7063abe0af83ee9c5a54eb27693ddc.jpg Found 3 images belonging to 1 classes. begin to do the prediction : time used to do the prediction : 0.8783090114593506 (3,) (3, 12) (3, 1280) shape of features : (3, 1280) shape of new features : (1, 3, 1280) save descriptor for thcl : 3847 time to traite the descriptors : 0.04537487030029297 storage_type for insertDescriptorsMulti : 3 To insert : 1388571712 To insert : 1388571330 To insert : 1388571241 time to insert the descriptors : 1.0037567615509033 Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : tfhub_classification2 we use saveGeneral [1388571712, 1388571330, 1388571241] Looping around the photos to save general results len do output : 3 /1388571712Didn't retrieve data . /1388571330Didn't retrieve data . /1388571241Didn'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 ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571712', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571330', None, None, None, None, None, '3911012') ('4877', None, None, None, None, None, None, None, '3911012') ('4877', '27666941', '1388571241', None, None, None, None, None, '3911012') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 6 time used for this insertion : 0.03592324256896973 save_final save missing photos in datou_result : time spend for datou_step_exec : 40.323169469833374 time spend to save output : 0.036289215087890625 total time spend for step 8 : 40.359458684921265 step9:argmax Fri Oct 10 09:16:38 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure Beginning of datou_step Argmax ! Inside saveOutput : final : True verbose : 0 photo_id : 1388571712 output[photo_id] : [[(1388571712, '05102018_Papier_non_papier_tres_dense', 0.38359502, 4557, 3513), (1388571712, 'jrm', 0.864646, 4374, 3379), (1388571712, 'jrm', 0.8926467, 4932, 3847)], 'temp/1760080511_4088367_1388571712_6880acc5e20b7d9bb62f885e795e690f.jpg'] photo_id : 1388571330 output[photo_id] : [[(1388571330, '05102018_Papier_non_papier_tres_dense', 0.38358384, 4557, 3513), (1388571330, 'jrm', 0.8645551, 4374, 3379), (1388571330, 'jrm', 0.8926404, 4932, 3847)], 'temp/1760080511_4088367_1388571330_df8f9b60b9e5237a773dd199673f2879.jpg'] photo_id : 1388571241 output[photo_id] : [[(1388571241, '05102018_Papier_non_papier_tres_dense', 0.32468042, 4557, 3513), (1388571241, 'jrm', 0.8639782, 4374, 3379), (1388571241, 'jrm', 0.8616314, 4932, 3847)], 'temp/1760080511_4088367_1388571241_fe7063abe0af83ee9c5a54eb27693ddc.jpg'] begin to insert list_values into photo_hahstag_ids : length of list_valuse in save_photo_hashtag_id_type : 9 time used for this insertion : 0.03676414489746094 begin to insert list_values into class_photo_scores : length of list_valuse in save_photo_hashtag_id_thcl_score : 9 time used for this insertion : 0.03554701805114746 len list_finale : 9, len picture : 3 begin to insert list_values into mtr_datou_result : length of list_values in save_final : 9 time used for this insertion : 0.035759925842285156 saving photo_ids in datou_result begin to insert list_values into mtr_datou_result : length of list_values in save_final : 3 time used for this insertion : 0.0363306999206543 save missing photos in datou_result : time spend for datou_step_exec : 0.017594337463378906 time spend to save output : 0.1800670623779297 total time spend for step 9 : 0.1976613998413086 caffe_path_current : About to save ! 2 After save, about to update current ! ret : 2 len(input) + len(total_photo_id_missing) : 3 set_done_treatment 51.86user 18.39system 1:32.04elapsed 76%CPU (0avgtext+0avgdata 2998484maxresident)k 24inputs+9944outputs (8major+2856604minor)pagefaults 0swaps