python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 10 -a ' -a 3459 -l 10 ' -s datou_current_3459 -M 0 -S 0 -U 95,95,80 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 1495898 load datou : 3459 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! Unexpected type for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? [(photo_id, hashtag_id, hashtag_type, x0, x1, y0, y1, score, seg_temp, polygons), ...] was removed should we ? chemin de la photo was removed should we ? [ (photo_id_loc, hashtag_id, hashtag_type, x0, x1, y0, y1, score, None), ...] was removed should we ? chemin de la photo was removed should we ? id de la photo (peut être local ou global) was removed should we ? chemin de la photo was removed should we ? (x0, y0, x1, y1) was removed should we ? chemin de la photo was removed should we ? [ (photo_id, hashtag_id_0, score_0), (photo_id, hashtag_id_1, score_1), ...] was removed should we ? output optionnel thcl was removed should we ? id de la photo (peut être local ou global) was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? [ (photo_id, hashtag_id_0, score_0), (photo_id, hashtag_id_1, score_1), ...] was removed should we ? id de la photo (peut être local ou global) was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? chemin de la photo was removed should we ? donnée sous forme de texte was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? [ (photo_id_loc, hashtag_id, hashtag_type, x0, x1, y0, y1, score, None), ...] was removed should we ? chemin de la photo was removed should we ? id de la photo (peut être local ou global) was removed should we ? chemin de la photo was removed should we ? (x0, y0, x1, y1) was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? id de la photo (peut être local ou global) was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? None was removed should we ? donnée sous forme de nombre was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? donnée sous forme de texte was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? FOUND : 1 Here is data_from_sql_as_vec to set the ParamDescriptorType : (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)) 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)) 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)) load thcls load THCL from format json or kwargs add thcl : 2456 in CacheModelConfig load THCL from format json or kwargs add thcl : 2868 in CacheModelConfig load THCL from format json or kwargs add thcl : 2896 in CacheModelConfig load pdts add pdt : 4999 in CacheModelConfig add pdt : 5288 in CacheModelConfig add pdt : 5309 in CacheModelConfig Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec updating current state to 1 we have a portfolio with more photos than limit : 30>10 please execute split_portfolio.py -i 20776396 -l 10 size over we load limit photo not treated list_input_json: [] Current got : datou_id : 3459, datou_cur_ids : ['2610201'] with mtr_portfolio_ids : ['20776396'] and first list_photo_ids : [] new path : /proc/1495898/ Inside batchDatouExec : verbose : 0 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! 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, final, velours_tree, send_mail_cod, split_time_score list_input_json : [] origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! BFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 10 ; length of list_pids : 10 ; length of list_args : 10 time to download the photos : 1.0946471691131592 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 : 11 step1:mask_detect Mon Feb 24 16:50:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Beginning of datou step mask_detect ! save_polygon : True begin detect begin to check gpu status inside check gpu memory l 3637 free memory gpu now : 10814 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-02-24 16:50:31.576191: 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-02-24 16:50:31.603146: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-02-24 16:50:31.605145: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f2930000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-02-24 16:50:31.605192: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-02-24 16:50:31.608661: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-02-24 16:50:31.827024: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x23fe61b0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-02-24 16:50:31.827064: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-02-24 16:50:31.828044: 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-02-24 16:50:31.828317: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-24 16:50:31.830142: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-24 16:50:31.831869: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-24 16:50:31.832165: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-24 16:50:31.834126: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-24 16:50:31.835072: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-24 16:50:31.839077: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-24 16:50:31.840500: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-24 16:50:31.840558: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-24 16:50:31.841277: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-02-24 16:50:31.841291: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-02-24 16:50:31.841299: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-02-24 16:50:31.842574: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 10023 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-02-24 16:50:32.102615: 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-02-24 16:50:32.102747: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-24 16:50:32.102779: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-24 16:50:32.102807: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-24 16:50:32.102833: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-24 16:50:32.102859: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-24 16:50:32.102885: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-24 16:50:32.102946: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-24 16:50:32.104696: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-24 16:50:32.106075: 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-02-24 16:50:32.106147: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-24 16:50:32.106163: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-24 16:50:32.106178: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-24 16:50:32.106192: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-24 16:50:32.106206: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-24 16:50:32.106221: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-24 16:50:32.106235: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-24 16:50:32.107556: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-24 16:50:32.107597: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-02-24 16:50:32.107607: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-02-24 16:50:32.107616: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-02-24 16:50:32.108982: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 10023 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-02-24 16:50:40.037553: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-24 16:50:40.225014: 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 : 10 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 7 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 6 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 3 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 12 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 5 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (1080, 1920, 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: 1920.00000 nb d'objets trouves : 3 Detection mask done ! Trying to reset tf kernel 1496451 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 1940 tf kernel not reseted sub process len(results) : 10 len(list_Values) 0 None max_time_sub_proc : 3600 parent process len(results) : 10 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 : 10814 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.00014019012451171875 nb_pixel_total : 539 time to create 1 rle with old method : 0.0007572174072265625 length of segment : 63 time for calcul the mask position with numpy : 0.01987457275390625 nb_pixel_total : 1001667 time to create 1 rle with new method : 0.6992981433868408 length of segment : 1437 time for calcul the mask position with numpy : 0.000125885009765625 nb_pixel_total : 717 time to create 1 rle with old method : 0.0008475780487060547 length of segment : 84 time for calcul the mask position with numpy : 0.0007817745208740234 nb_pixel_total : 53404 time to create 1 rle with old method : 0.05801653861999512 length of segment : 482 time for calcul the mask position with numpy : 0.0022079944610595703 nb_pixel_total : 154953 time to create 1 rle with new method : 0.005761861801147461 length of segment : 606 time for calcul the mask position with numpy : 0.005799531936645508 nb_pixel_total : 294292 time to create 1 rle with new method : 0.011026859283447266 length of segment : 945 time for calcul the mask position with numpy : 0.0013287067413330078 nb_pixel_total : 105706 time to create 1 rle with old method : 0.11692929267883301 length of segment : 435 time for calcul the mask position with numpy : 0.00026988983154296875 nb_pixel_total : 5341 time to create 1 rle with old method : 0.006313800811767578 length of segment : 100 time for calcul the mask position with numpy : 0.019887924194335938 nb_pixel_total : 1041053 time to create 1 rle with new method : 0.08471274375915527 length of segment : 1502 time for calcul the mask position with numpy : 0.0012767314910888672 nb_pixel_total : 98605 time to create 1 rle with old method : 0.10838437080383301 length of segment : 423 time for calcul the mask position with numpy : 0.000133514404296875 nb_pixel_total : 4477 time to create 1 rle with old method : 0.004804849624633789 length of segment : 163 time for calcul the mask position with numpy : 0.004525899887084961 nb_pixel_total : 373216 time to create 1 rle with new method : 0.012563467025756836 length of segment : 1207 time for calcul the mask position with numpy : 0.0033240318298339844 nb_pixel_total : 232539 time to create 1 rle with new method : 0.008735179901123047 length of segment : 827 time for calcul the mask position with numpy : 0.004021167755126953 nb_pixel_total : 204934 time to create 1 rle with new method : 0.008446455001831055 length of segment : 689 time for calcul the mask position with numpy : 0.00046896934509277344 nb_pixel_total : 5113 time to create 1 rle with old method : 0.006555318832397461 length of segment : 95 time for calcul the mask position with numpy : 0.012398719787597656 nb_pixel_total : 750902 time to create 1 rle with new method : 0.6773908138275146 length of segment : 1600 time for calcul the mask position with numpy : 0.004607677459716797 nb_pixel_total : 365746 time to create 1 rle with new method : 0.016655921936035156 length of segment : 1931 time for calcul the mask position with numpy : 0.0005838871002197266 nb_pixel_total : 13651 time to create 1 rle with old method : 0.015385627746582031 length of segment : 153 time for calcul the mask position with numpy : 0.011495113372802734 nb_pixel_total : 720253 time to create 1 rle with new method : 0.05452108383178711 length of segment : 1540 time for calcul the mask position with numpy : 9.489059448242188e-05 nb_pixel_total : 1714 time to create 1 rle with old method : 0.002230405807495117 length of segment : 49 time for calcul the mask position with numpy : 0.0038285255432128906 nb_pixel_total : 263724 time to create 1 rle with new method : 0.01186227798461914 length of segment : 792 time for calcul the mask position with numpy : 0.003448963165283203 nb_pixel_total : 291974 time to create 1 rle with new method : 0.007704734802246094 length of segment : 1042 time for calcul the mask position with numpy : 0.508819580078125 nb_pixel_total : 1664145 time to create 1 rle with new method : 0.06939816474914551 length of segment : 1339 time for calcul the mask position with numpy : 8.678436279296875e-05 nb_pixel_total : 2937 time to create 1 rle with old method : 0.0036568641662597656 length of segment : 52 time for calcul the mask position with numpy : 0.0034449100494384766 nb_pixel_total : 314967 time to create 1 rle with new method : 0.007534503936767578 length of segment : 954 time for calcul the mask position with numpy : 0.003187417984008789 nb_pixel_total : 118976 time to create 1 rle with old method : 0.13300037384033203 length of segment : 793 time for calcul the mask position with numpy : 0.010140180587768555 nb_pixel_total : 454794 time to create 1 rle with new method : 0.15248918533325195 length of segment : 1284 time for calcul the mask position with numpy : 0.0003771781921386719 nb_pixel_total : 25934 time to create 1 rle with old method : 0.02836751937866211 length of segment : 204 time for calcul the mask position with numpy : 0.0006575584411621094 nb_pixel_total : 46773 time to create 1 rle with old method : 0.053456783294677734 length of segment : 294 time for calcul the mask position with numpy : 0.0007598400115966797 nb_pixel_total : 38522 time to create 1 rle with old method : 0.042714834213256836 length of segment : 159 time for calcul the mask position with numpy : 0.0013871192932128906 nb_pixel_total : 55539 time to create 1 rle with old method : 0.0627448558807373 length of segment : 423 time for calcul the mask position with numpy : 0.0004229545593261719 nb_pixel_total : 24000 time to create 1 rle with old method : 0.026244163513183594 length of segment : 134 time for calcul the mask position with numpy : 0.0007300376892089844 nb_pixel_total : 58619 time to create 1 rle with old method : 0.06593012809753418 length of segment : 318 time for calcul the mask position with numpy : 0.0011887550354003906 nb_pixel_total : 89666 time to create 1 rle with old method : 0.0987548828125 length of segment : 383 time for calcul the mask position with numpy : 0.0004284381866455078 nb_pixel_total : 26072 time to create 1 rle with old method : 0.028751611709594727 length of segment : 207 time for calcul the mask position with numpy : 0.00018143653869628906 nb_pixel_total : 5131 time to create 1 rle with old method : 0.006369113922119141 length of segment : 68 time for calcul the mask position with numpy : 0.00039577484130859375 nb_pixel_total : 16334 time to create 1 rle with old method : 0.018451452255249023 length of segment : 166 time for calcul the mask position with numpy : 0.007520437240600586 nb_pixel_total : 369206 time to create 1 rle with new method : 0.015848159790039062 length of segment : 992 time for calcul the mask position with numpy : 0.0002181529998779297 nb_pixel_total : 12437 time to create 1 rle with old method : 0.013379573822021484 length of segment : 233 time for calcul the mask position with numpy : 0.0012049674987792969 nb_pixel_total : 61101 time to create 1 rle with old method : 0.06763482093811035 length of segment : 496 time for calcul the mask position with numpy : 0.0003516674041748047 nb_pixel_total : 11574 time to create 1 rle with old method : 0.013346672058105469 length of segment : 156 time for calcul the mask position with numpy : 0.014573097229003906 nb_pixel_total : 1116756 time to create 1 rle with new method : 0.06022906303405762 length of segment : 1350 time for calcul the mask position with numpy : 0.003893613815307617 nb_pixel_total : 364790 time to create 1 rle with new method : 0.007908105850219727 length of segment : 867 time for calcul the mask position with numpy : 0.0007648468017578125 nb_pixel_total : 71637 time to create 1 rle with old method : 0.07912373542785645 length of segment : 179 time for calcul the mask position with numpy : 0.0028150081634521484 nb_pixel_total : 157126 time to create 1 rle with new method : 0.004985809326171875 length of segment : 673 time for calcul the mask position with numpy : 0.011851072311401367 nb_pixel_total : 816159 time to create 1 rle with new method : 0.07251906394958496 length of segment : 1341 time for calcul the mask position with numpy : 0.0038118362426757812 nb_pixel_total : 311606 time to create 1 rle with new method : 0.010671854019165039 length of segment : 1002 time for calcul the mask position with numpy : 0.0011703968048095703 nb_pixel_total : 72095 time to create 1 rle with old method : 0.08405804634094238 length of segment : 631 time for calcul the mask position with numpy : 0.005218029022216797 nb_pixel_total : 243934 time to create 1 rle with new method : 0.010112285614013672 length of segment : 1004 time for calcul the mask position with numpy : 0.012505292892456055 nb_pixel_total : 1066552 time to create 1 rle with new method : 0.19462132453918457 length of segment : 1696 time for calcul the mask position with numpy : 0.0033407211303710938 nb_pixel_total : 311180 time to create 1 rle with new method : 0.006769895553588867 length of segment : 972 time spent for convertir_results : 8.928894996643066 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 51 chid ids of type : 3663 Number RLEs to save : 34535 save missing photos in datou_result : time spend for datou_step_exec : 34.15019154548645 time spend to save output : 1.9161462783813477 total time spend for step 1 : 36.0663378238678 step2:crop_condition Mon Feb 24 16:51:05 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 : 10 ! batch 1 Loaded 51 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 ! 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 : 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 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 [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 14 /-3685290622Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290639Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290647Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290648Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290650Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290626Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290643Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290652Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290649Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290629Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290653Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290651Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290659Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3685290663Didn'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 ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 52 time used for this insertion : 0.021048545837402344 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.916963577270508 time spend to save output : 0.021878957748413086 total time spend for step 2 : 3.938842535018921 step3:thcl Mon Feb 24 16:51:08 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.008498430252075195 time to convert the images to numpy array : 3.337860107421875e-06 time to import caffe and check if the image exist : 0.009495019912719727 time to convert the images to numpy array : 2.86102294921875e-06 time to import caffe and check if the image exist : 0.008492231369018555 time to convert the images to numpy array : 0.0029926300048828125 time to import caffe and check if the image exist : 0.008944034576416016 time to convert the images to numpy array : 2.384185791015625e-06 time to import caffe and check if the image exist : 0.011754274368286133 time to convert the images to numpy array : 0.014027118682861328 time to import caffe and check if the image exist : 0.009500265121459961 time to convert the images to numpy array : 0.0167539119720459 time to import caffe and check if the image exist : 0.010004997253417969 time to convert the images to numpy array : 0.01829385757446289 time to import caffe and check if the image exist : 0.01314997673034668 time to convert the images to numpy array : 0.01730060577392578 time to import caffe and check if the image exist : 0.011226415634155273 time to convert the images to numpy array : 0.022464513778686523 time to import caffe and check if the image exist : 0.01433873176574707 time to convert the images to numpy array : 0.019838809967041016 total time to convert the images to numpy array : 0.2755460739135742 list photo_ids error: [] list photo_ids correct : [-3685290622, -3685290639, -3685290643, -3685290652, -3685290647, -3685290648, -3685290659, -3685290663, -3685290653, -3685290651, -3685290650, -3685290626, -3685290649, -3685290629] number of photos to traite : 14 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 : 10814 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/caffe_cuda8_python3/python/:/home/admin/workarea/install/darknet/:/home/admin/workarea/git/Velours/python:/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python:/home/admin/mtr/.credentials:/home/admin/workarea/install/caffe/python:/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools/:/home/admin/workarea/git/fotonowerpip/:/home/admin/workarea/install/segment-anything:/home/admin//workarea/git/pyfvs/ 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 : 10595 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.14507699012756348 time used to do the prediction : 0.1052706241607666 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 : 10593 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/caffe_cuda8_python3/python/:/home/admin/workarea/install/darknet/:/home/admin/workarea/git/Velours/python:/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python:/home/admin/mtr/.credentials:/home/admin/workarea/install/caffe/python:/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools/:/home/admin/workarea/git/fotonowerpip/:/home/admin/workarea/install/segment-anything:/home/admin//workarea/git/pyfvs/ 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 : 10593 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.16153240203857422 time used to do the prediction : 0.05481362342834473 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 : 1.5497207641601562e-05 save missing photos in datou_result : time spend for datou_step_exec : 7.30968165397644 time spend to save output : 0.0002772808074951172 total time spend for step 3 : 7.3099589347839355 step4:merge_mask_thcl_custom Mon Feb 24 16:51:16 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 51 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 [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 10 /1339355240Didn't retrieve data .Didn't retrieve data . /1339355213Didn't retrieve data .Didn't retrieve data . /1339355212Didn't retrieve data .Didn't retrieve data . /1339355179Didn't retrieve data .Didn't retrieve data . /1339355176Didn't retrieve data .Didn't retrieve data . /1339355147Didn't retrieve data .Didn't retrieve data . /1339355144Didn't retrieve data .Didn't retrieve data . /1339354926Didn't retrieve data .Didn't retrieve data . /1339354906Didn't retrieve data .Didn't retrieve data . /1339354666Didn'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 ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.014074325561523438 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.052861928939819336 time spend to save output : 0.014527082443237305 total time spend for step 4 : 0.06738901138305664 step5:rle_unique_nms_with_priority Mon Feb 24 16:51:16 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 : 7 nb_hashtags : 3 time to prepare the origin masks : 1.8298993110656738 time for calcul the mask position with numpy : 0.20632147789001465 nb_pixel_total : 777614 time to create 1 rle with new method : 0.08361983299255371 time for calcul the mask position with numpy : 0.006992816925048828 nb_pixel_total : 144109 time to create 1 rle with old method : 0.15935564041137695 time for calcul the mask position with numpy : 0.006186485290527344 nb_pixel_total : 72687 time to create 1 rle with old method : 0.0820772647857666 time for calcul the mask position with numpy : 0.006119251251220703 nb_pixel_total : 3288 time to create 1 rle with old method : 0.00365447998046875 time for calcul the mask position with numpy : 0.006207704544067383 nb_pixel_total : 50052 time to create 1 rle with old method : 0.05200386047363281 time for calcul the mask position with numpy : 0.005892038345336914 nb_pixel_total : 398 time to create 1 rle with old method : 0.0004837512969970703 time for calcul the mask position with numpy : 0.03357577323913574 nb_pixel_total : 1024912 time to create 1 rle with new method : 0.24060392379760742 time for calcul the mask position with numpy : 0.006274223327636719 nb_pixel_total : 540 time to create 1 rle with old method : 0.0006246566772460938 create new chi : 0.9167008399963379 time to delete rle : 0.025246143341064453 batch 1 Loaded 8 chid ids of type : 3726 Number RLEs to save : 6312 TO DO : save crop sub photo not yet done ! save time : 0.37082886695861816 nb_obj : 6 nb_hashtags : 2 time to prepare the origin masks : 0.9241414070129395 time for calcul the mask position with numpy : 0.011260509490966797 nb_pixel_total : 740938 time to create 1 rle with new method : 0.2948615550994873 time for calcul the mask position with numpy : 0.006209373474121094 nb_pixel_total : 70662 time to create 1 rle with old method : 0.07673311233520508 time for calcul the mask position with numpy : 0.006566047668457031 nb_pixel_total : 115808 time to create 1 rle with old method : 0.12170219421386719 time for calcul the mask position with numpy : 0.006052732467651367 nb_pixel_total : 4465 time to create 1 rle with old method : 0.0046253204345703125 time for calcul the mask position with numpy : 0.012871026992797852 nb_pixel_total : 1038100 time to create 1 rle with new method : 0.04997897148132324 time for calcul the mask position with numpy : 0.005802154541015625 nb_pixel_total : 5330 time to create 1 rle with old method : 0.0060040950775146484 time for calcul the mask position with numpy : 0.007007598876953125 nb_pixel_total : 98297 time to create 1 rle with old method : 0.10448312759399414 create new chi : 0.7151498794555664 time to delete rle : 0.0005877017974853516 batch 1 Loaded 7 chid ids of type : 3726 Number RLEs to save : 7021 TO DO : save crop sub photo not yet done ! save time : 0.4163353443145752 nb_obj : 4 nb_hashtags : 1 time to prepare the origin masks : 0.5221524238586426 time for calcul the mask position with numpy : 0.013495683670043945 nb_pixel_total : 1115692 time to create 1 rle with new method : 0.2216777801513672 time for calcul the mask position with numpy : 0.00651240348815918 nb_pixel_total : 147950 time to create 1 rle with old method : 0.1581103801727295 time for calcul the mask position with numpy : 0.009660005569458008 nb_pixel_total : 601325 time to create 1 rle with new method : 0.02862715721130371 time for calcul the mask position with numpy : 0.006047964096069336 nb_pixel_total : 5077 time to create 1 rle with old method : 0.005687713623046875 time for calcul the mask position with numpy : 0.007172822952270508 nb_pixel_total : 203556 time to create 1 rle with new method : 0.028533935546875 create new chi : 0.48648810386657715 time to delete rle : 0.0005285739898681641 batch 1 Loaded 5 chid ids of type : 3726 Number RLEs to save : 6430 TO DO : save crop sub photo not yet done ! save time : 0.3738715648651123 nb_obj : 5 nb_hashtags : 2 time to prepare the origin masks : 0.5843160152435303 time for calcul the mask position with numpy : 0.040178775787353516 nb_pixel_total : 1088313 time to create 1 rle with new method : 0.20678400993347168 time for calcul the mask position with numpy : 0.007249593734741211 nb_pixel_total : 1710 time to create 1 rle with old method : 0.0019567012786865234 time for calcul the mask position with numpy : 0.007490873336791992 nb_pixel_total : 25625 time to create 1 rle with old method : 0.03327679634094238 time for calcul the mask position with numpy : 0.00938272476196289 nb_pixel_total : 225023 time to create 1 rle with new method : 0.09001278877258301 time for calcul the mask position with numpy : 0.011064291000366211 nb_pixel_total : 719370 time to create 1 rle with new method : 0.028212785720825195 time for calcul the mask position with numpy : 0.005975246429443359 nb_pixel_total : 13559 time to create 1 rle with old method : 0.015188455581665039 create new chi : 0.4673759937286377 time to delete rle : 0.0005583763122558594 batch 1 Loaded 6 chid ids of type : 3726 Number RLEs to save : 6324 TO DO : save crop sub photo not yet done ! save time : 0.48035693168640137 nb_obj : 2 nb_hashtags : 1 time to prepare the origin masks : 0.3958578109741211 time for calcul the mask position with numpy : 0.00789332389831543 nb_pixel_total : 307446 time to create 1 rle with new method : 0.10430097579956055 time for calcul the mask position with numpy : 0.006537199020385742 nb_pixel_total : 49363 time to create 1 rle with old method : 0.056293487548828125 time for calcul the mask position with numpy : 0.05673480033874512 nb_pixel_total : 1716791 time to create 1 rle with new method : 0.24277853965759277 create new chi : 0.4850428104400635 time to delete rle : 0.00038695335388183594 batch 1 Loaded 3 chid ids of type : 3726 Number RLEs to save : 4007 TO DO : save crop sub photo not yet done ! save time : 0.9043252468109131 nb_obj : 9 nb_hashtags : 4 time to prepare the origin masks : 1.1742377281188965 time for calcul the mask position with numpy : 0.05102992057800293 nb_pixel_total : 1214097 time to create 1 rle with new method : 0.1262199878692627 time for calcul the mask position with numpy : 0.0071985721588134766 nb_pixel_total : 25782 time to create 1 rle with old method : 0.029989004135131836 time for calcul the mask position with numpy : 0.006555318832397461 nb_pixel_total : 370 time to create 1 rle with old method : 0.0008189678192138672 time for calcul the mask position with numpy : 0.006882190704345703 nb_pixel_total : 38340 time to create 1 rle with old method : 0.041898488998413086 time for calcul the mask position with numpy : 0.006214141845703125 nb_pixel_total : 23894 time to create 1 rle with old method : 0.026753902435302734 time for calcul the mask position with numpy : 0.0066375732421875 nb_pixel_total : 63731 time to create 1 rle with old method : 0.06937026977539062 time for calcul the mask position with numpy : 0.008874654769897461 nb_pixel_total : 443814 time to create 1 rle with new method : 0.4928629398345947 time for calcul the mask position with numpy : 0.006652355194091797 nb_pixel_total : 89515 time to create 1 rle with old method : 0.09333992004394531 time for calcul the mask position with numpy : 0.00697779655456543 nb_pixel_total : 118812 time to create 1 rle with old method : 0.12717676162719727 time for calcul the mask position with numpy : 0.006493091583251953 nb_pixel_total : 55245 time to create 1 rle with old method : 0.0700068473815918 create new chi : 1.2025728225708008 time to delete rle : 0.0007734298706054688 batch 1 Loaded 10 chid ids of type : 3726 Number RLEs to save : 8193 TO DO : save crop sub photo not yet done ! save time : 0.4622519016265869 nb_obj : 5 nb_hashtags : 2 time to prepare the origin masks : 0.4820747375488281 time for calcul the mask position with numpy : 0.017199993133544922 nb_pixel_total : 1609916 time to create 1 rle with new method : 0.03046131134033203 time for calcul the mask position with numpy : 0.006599903106689453 nb_pixel_total : 60991 time to create 1 rle with old method : 0.06986641883850098 time for calcul the mask position with numpy : 0.005960702896118164 nb_pixel_total : 12407 time to create 1 rle with old method : 0.013225555419921875 time for calcul the mask position with numpy : 0.007985115051269531 nb_pixel_total : 368921 time to create 1 rle with new method : 0.027621984481811523 time for calcul the mask position with numpy : 0.0057604312896728516 nb_pixel_total : 16264 time to create 1 rle with old method : 0.017284870147705078 time for calcul the mask position with numpy : 0.006099700927734375 nb_pixel_total : 5101 time to create 1 rle with old method : 0.005852937698364258 create new chi : 0.2217423915863037 time to delete rle : 0.0004811286926269531 batch 1 Loaded 6 chid ids of type : 3726 Number RLEs to save : 4952 TO DO : save crop sub photo not yet done ! save time : 0.3060922622680664 nb_obj : 4 nb_hashtags : 2 time to prepare the origin masks : 0.4985771179199219 time for calcul the mask position with numpy : 0.012158632278442383 nb_pixel_total : 824143 time to create 1 rle with new method : 0.029971837997436523 time for calcul the mask position with numpy : 0.00647282600402832 nb_pixel_total : 51015 time to create 1 rle with old method : 0.05756568908691406 time for calcul the mask position with numpy : 0.006407260894775391 nb_pixel_total : 71462 time to create 1 rle with old method : 0.08016777038574219 time for calcul the mask position with numpy : 0.01358175277709961 nb_pixel_total : 1115413 time to create 1 rle with new method : 0.028978586196899414 time for calcul the mask position with numpy : 0.006073713302612305 nb_pixel_total : 11567 time to create 1 rle with old method : 0.013075590133666992 create new chi : 0.2552030086517334 time to delete rle : 0.0004284381866455078 batch 1 Loaded 5 chid ids of type : 3726 Number RLEs to save : 5108 TO DO : save crop sub photo not yet done ! save time : 0.4550306797027588 nb_obj : 4 nb_hashtags : 1 time to prepare the origin masks : 0.2870514392852783 time for calcul the mask position with numpy : 0.04045581817626953 nb_pixel_total : 1115384 time to create 1 rle with new method : 0.17038679122924805 time for calcul the mask position with numpy : 0.008083105087280273 nb_pixel_total : 22800 time to create 1 rle with old method : 0.026210546493530273 time for calcul the mask position with numpy : 0.0077877044677734375 nb_pixel_total : 76526 time to create 1 rle with old method : 0.08906912803649902 time for calcul the mask position with numpy : 0.014806985855102539 nb_pixel_total : 702097 time to create 1 rle with new method : 0.09640860557556152 time for calcul the mask position with numpy : 0.007337093353271484 nb_pixel_total : 156793 time to create 1 rle with new method : 0.03478860855102539 create new chi : 0.5118069648742676 time to delete rle : 0.0006527900695800781 batch 1 Loaded 5 chid ids of type : 3726 Number RLEs to save : 6339 TO DO : save crop sub photo not yet done ! save time : 0.4765510559082031 nb_obj : 3 nb_hashtags : 1 time to prepare the origin masks : 0.33321428298950195 time for calcul the mask position with numpy : 0.012975692749023438 nb_pixel_total : 744807 time to create 1 rle with new method : 0.1863565444946289 time for calcul the mask position with numpy : 0.006807088851928711 nb_pixel_total : 155358 time to create 1 rle with new method : 0.07788252830505371 time for calcul the mask position with numpy : 0.012924909591674805 nb_pixel_total : 930377 time to create 1 rle with new method : 0.09910249710083008 time for calcul the mask position with numpy : 0.008027315139770508 nb_pixel_total : 243058 time to create 1 rle with new method : 0.07965302467346191 create new chi : 0.5003006458282471 time to delete rle : 0.0005545616149902344 batch 1 Loaded 4 chid ids of type : 3726 Number RLEs to save : 6282 TO DO : save crop sub photo not yet done ! save time : 0.9056916236877441 map_output_result : {1339355240: (0.0, 'Should be the crop_list due to order', 0), 1339355213: (0.0, 'Should be the crop_list due to order', 0), 1339355212: (0.0, 'Should be the crop_list due to order', 0), 1339355179: (0.0, 'Should be the crop_list due to order', 0), 1339355176: (0.0, 'Should be the crop_list due to order', 0), 1339355147: (0.0, 'Should be the crop_list due to order', 0), 1339355144: (0.0, 'Should be the crop_list due to order', 0), 1339354926: (0.0, 'Should be the crop_list due to order', 0), 1339354906: (0.0, 'Should be the crop_list due to order', 0), 1339354666: (0.0, 'Should be the crop_list due to order', 0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 10 /1339355240.Didn't retrieve data . /1339355213.Didn't retrieve data . /1339355212.Didn't retrieve data . /1339355179.Didn't retrieve data . /1339355176.Didn't retrieve data . /1339355147.Didn't retrieve data . /1339355144.Didn't retrieve data . /1339354926.Didn't retrieve data . /1339354906.Didn't retrieve data . /1339354666.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 ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.014478921890258789 save_final save missing photos in datou_result : time spend for datou_step_exec : 18.2593994140625 time spend to save output : 0.3033301830291748 total time spend for step 5 : 18.562729597091675 step6:crop_condition Mon Feb 24 16:51:34 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 : 10 ! batch 1 Loaded 59 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 ! 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 ! About to upload 2 photos upload in portfolio : 4869462 init cache_photo without model_param we have 2 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740412296_1495898 we have uploaded 2 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.7904367446899414 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 begin to crop the class : cartonnette param for this class : {'min_score': 0.5} filtre for class : cartonnette hashtag_id of this class : 702398920 Next one ! 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 ! About to upload 2 photos upload in portfolio : 4869462 init cache_photo without model_param we have 2 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740412297_1495898 we have uploaded 2 photos in the portfolio 4869462 time of upload the photos Elapsed time : 1.1003739833831787 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 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 [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 4 /1339360303Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1339360304Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1339360308Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1339360309Didn'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 ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 22 time used for this insertion : 0.09689140319824219 save_final save missing photos in datou_result : time spend for datou_step_exec : 4.097674369812012 time spend to save output : 0.09734940528869629 total time spend for step 6 : 4.195023775100708 step7:ventilate_hashtags_in_portfolio Mon Feb 24 16:51:39 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure 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 : 20776396 get user id for portfolio 20776396 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`=20776396 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','environnement','flou','autre_refus','plastique','kraft','Teint_Dans_La_Masse','Carton_gris','mal_croppe','papier','metal','Carton_brun')) 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`=20776396 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('cartonnette','environnement','flou','autre_refus','plastique','kraft','Teint_Dans_La_Masse','Carton_gris','mal_croppe','papier','metal','Carton_brun')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/20776694,20776695,20776696,20776697,20776698,20776699,20776700,20776701,20776702,20776703,20776704,20776705?tags=Carton_brun,papier,flou,kraft,Teint_Dans_La_Masse,plastique,metal,autre_refus,Carton_gris,environnement,mal_croppe,cartonnette Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 1 /20776396. 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 ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.014658689498901367 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.3428640365600586 time spend to save output : 0.014926910400390625 total time spend for step 7 : 1.3577909469604492 step8:final Mon Feb 24 16:51:40 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 2 VR 22-3-18 : For now we do not clean correctly the datou structure Beginning of datou step final ! Catched exception ! Connect or reconnect ! Inside saveOutput : final : False verbose : 0 original output for save of step final : {1339355240: ('0.014093503593244827',), 1339355213: ('0.014093503593244827',), 1339355212: ('0.014093503593244827',), 1339355179: ('0.014093503593244827',), 1339355176: ('0.014093503593244827',), 1339355147: ('0.014093503593244827',), 1339355144: ('0.014093503593244827',), 1339354926: ('0.014093503593244827',), 1339354906: ('0.014093503593244827',), 1339354666: ('0.014093503593244827',)} new output for save of step final : {1339355240: ('0.014093503593244827',), 1339355213: ('0.014093503593244827',), 1339355212: ('0.014093503593244827',), 1339355179: ('0.014093503593244827',), 1339355176: ('0.014093503593244827',), 1339355147: ('0.014093503593244827',), 1339355144: ('0.014093503593244827',), 1339354926: ('0.014093503593244827',), 1339354906: ('0.014093503593244827',), 1339354666: ('0.014093503593244827',)} [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 10 /1339355240.Didn't retrieve data . /1339355213.Didn't retrieve data . /1339355212.Didn't retrieve data . /1339355179.Didn't retrieve data . /1339355176.Didn't retrieve data . /1339355147.Didn't retrieve data . /1339355144.Didn't retrieve data . /1339354926.Didn't retrieve data . /1339354906.Didn't retrieve data . /1339354666.Didn't retrieve data . before output type Used above Used above Managing all output in save final without adding information in the mtr_datou_result ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.014867067337036133 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.6829347610473633 time spend to save output : 0.015464067459106445 total time spend for step 8 : 0.6983988285064697 step9:velours_tree Mon Feb 24 16:51:41 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 VR 22-3-18 : For now we do not clean correctly the datou structure can't find the photo_desc_type Inside saveOutput : final : False verbose : 0 ouput is None No outpout to save, returning out of save general time spend for datou_step_exec : 0.07985424995422363 time spend to save output : 3.647804260253906e-05 total time spend for step 9 : 0.07989072799682617 step10:send_mail_cod Mon Feb 24 16:51:41 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! complete output_args for input 2 Inconsistent number of input and output, step which parrallelize and manage error in input by avoiding sending an output for this data can't be used in tree dependencies of input and output complete output_args for input 3 We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure dans la step send mail cod work_area: /home/admin/workarea/git/Velours/python in order to get the selector url, please entre the license of selector results_Auto_P20776396_24-02-2025_16_51_41.pdf 20776696 imagette207766961740412301 20776697 imagette207766971740412301 20776699 imagette207766991740412301 20776700 imagette207767001740412301 20776701 change filename to text .imagette207767011740412301 20776704 imagette207767041740412301 20776705 change filename to text .change filename to text .change filename to text .change filename to text .imagette207767051740412301 20776694 change filename to text .imagette207766941740412301 20776698 change filename to text .change filename to text .imagette207766981740412301 20776702 imagette207767021740412301 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=20776396 and hashtag_type = 3726 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/20776694,20776695,20776696,20776697,20776698,20776699,20776700,20776701,20776702,20776703,20776704,20776705?tags=Carton_brun,papier,flou,kraft,Teint_Dans_La_Masse,plastique,metal,autre_refus,Carton_gris,environnement,mal_croppe,cartonnette your option no_mail is active, we will not send the real mail to your client args[1339355240] : ('0.014093503593244827',) no score found for photo 1339355240 We are sending mail with results at report@fotonower.com args[1339355213] : ('0.014093503593244827',) no score found for photo 1339355213 We are sending mail with results at report@fotonower.com args[1339355212] : ('0.014093503593244827',) no score found for photo 1339355212 We are sending mail with results at report@fotonower.com args[1339355179] : ('0.014093503593244827',) no score found for photo 1339355179 We are sending mail with results at report@fotonower.com args[1339355176] : ('0.014093503593244827',) no score found for photo 1339355176 We are sending mail with results at report@fotonower.com args[1339355147] : ('0.014093503593244827',) no score found for photo 1339355147 We are sending mail with results at report@fotonower.com args[1339355144] : ('0.014093503593244827',) no score found for photo 1339355144 We are sending mail with results at report@fotonower.com args[1339354926] : ('0.014093503593244827',) no score found for photo 1339354926 We are sending mail with results at report@fotonower.com args[1339354906] : ('0.014093503593244827',) no score found for photo 1339354906 We are sending mail with results at report@fotonower.com args[1339354666] : ('0.014093503593244827',) no score found for photo 1339354666 We are sending mail with results at report@fotonower.com refus_total : 0.014093503593244827 2022-04-13 10:29:59 0 SELECT ph.photo_id,ph.url,ph.username,ph.uploaded_at,ph.text FROM MTRBack.photos ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=20776396 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 1000 SELECT photo_id, url FROM MTRBack.photos ph WHERE photo_id IN (1339355212,1339355630,1339355354,1339355579,1339355574,1339355536,1339355535,1339355495,1339355493,1339355451,1339355450,1339355417,1339355415,1339355382,1339355381,1339355355,1339354666,1339355325,1339355320,1339355266) Found this number of photos: 20 begin to download photo : 1339355212 begin to download photo : 1339355536 begin to download photo : 1339355450 begin to download photo : 1339355355 download finish for photo 1339355212 begin to download photo : 1339355630 download finish for photo 1339355355 begin to download photo : 1339354666 download finish for photo 1339355450 begin to download photo : 1339355417 download finish for photo 1339355536 begin to download photo : 1339355535 download finish for photo 1339355630 begin to download photo : 1339355354 download finish for photo 1339355417 begin to download photo : 1339355415 download finish for photo 1339354666 begin to download photo : 1339355325 download finish for photo 1339355535 begin to download photo : 1339355495 download finish for photo 1339355415 begin to download photo : 1339355382 download finish for photo 1339355354 begin to download photo : 1339355579 download finish for photo 1339355495 begin to download photo : 1339355493 download finish for photo 1339355325 begin to download photo : 1339355320 download finish for photo 1339355579 begin to download photo : 1339355574 download finish for photo 1339355382 begin to download photo : 1339355381 download finish for photo 1339355493 begin to download photo : 1339355451 download finish for photo 1339355320 begin to download photo : 1339355266 download finish for photo 1339355451 download finish for photo 1339355381 download finish for photo 1339355574 download finish for photo 1339355266 start upload file to ovh https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20776396_24-02-2025_16_51_41.pdf results_Auto_P20776396_24-02-2025_16_51_41.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20776396_24-02-2025_16_51_41.pdf start insert file to database insert into MTRUser.mtr_files (mtd_id,mtr_portfolio_id,text,url,format,tags,file_size,value) values ('3459','20776396','results_Auto_P20776396_24-02-2025_16_51_41.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20776396_24-02-2025_16_51_41.pdf','pdf','','0.21','0.014093503593244827') Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 0 before output type Used above Managing all output in save final without adding information in the mtr_datou_result ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 10 time used for this insertion : 0.01342463493347168 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.840301990509033 time spend to save output : 0.01359248161315918 total time spend for step 10 : 3.8538944721221924 step11:split_time_score Mon Feb 24 16:51:45 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array 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 1 VR 22-3-18 : For now we do not clean correctly the datou structure begin split time score Catched exception ! Connect or reconnect ! TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 861, 'mtr_user_id': 31, 'name': 'Rungis_class_dechets_1212', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'Rungis_Aluminium,Rungis_Carton,Rungis_Papier,Rungis_Plastique_clair,Rungis_Plastique_dur,Rungis_Plastique_fonce,Rungis_Tapis_vide,Rungis_Tetrapak', 'svm_portfolios_learning': '1160730,571842,571844,571839,571933,571840,571841,572307', 'photo_hashtag_type': 999, 'photo_desc_type': 3963, 'type_classification': 'caffe', 'hashtag_id_list': '2107751280,2107750907,2107750908,2107750909,2107750910,2107750911,2107750912,2107750913'}] thcls : [{'id': 758, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 856, 'photo_desc_type': 3853, 'type_classification': 'caffe', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('15', 30),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 24022025 20776396 Nombre de photos uploadées : 30 / 23040 (0%) 24022025 20776396 Nombre de photos taguées (types de déchets): 0 / 30 (0%) 24022025 20776396 Nombre de photos taguées (volume) : 0 / 30 (0%) elapsed_time : load_data_split_time_score 1.430511474609375e-06 elapsed_time : order_list_meta_photo_and_scores 5.4836273193359375e-06 ?????????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.001474618911743164 elapsed_time : insert_dashboard_record_day_entry 0.023505210876464844 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776371 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776372 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776373 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776374 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776375 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776376 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776377 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776378 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776379 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776380 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776381 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776382 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776383 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776384 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776385 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776386 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776387 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776388 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776389 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776390 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776391 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776392 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776393 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776394 order by id desc limit 1 Qualite : 0.031579998332255436 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20776395_24-02-2025_16_45_26.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776395 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20776395 AND mptpi.`type`=3726 To do Qualite : 0.02339440315396657 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20776396_24-02-2025_16_51_41.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776396 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20776396 AND mptpi.`type`=3726 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776397 order by id desc limit 1 Qualite : 0.01744923387764322 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20776398_24-02-2025_16_41_44.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20776398 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11449 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11452 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Step 11452 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11453 merge_mask_thcl_custom have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11453 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11454 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11478 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11478 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11456 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11455 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11455 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11458 send_mail_cod have less inputs used (3) than in the step definition (5) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11449 doesn't seem to be define in the database( WARNING : type of input 2 of step 11452 doesn't seem to be define in the database( WARNING : output 1 of step 11449 have datatype=2 whereas input 1 of step 11453 have datatype=7 WARNING : type of output 2 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11454 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 3 of step 11453 doesn't seem to be define in the database( WARNING : type of input 1 of step 11456 doesn't seem to be define in the database( WARNING : type of output 1 of step 11456 doesn't seem to be define in the database( WARNING : type of input 3 of step 11455 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11456 have datatype=10 whereas input 3 of step 11458 have datatype=6 WARNING : type of input 5 of step 11458 doesn't seem to be define in the database( WARNING : output 0 of step 11477 have datatype=11 whereas input 5 of step 11458 have datatype=None WARNING : output 0 of step 11456 have datatype=10 whereas input 0 of step 11477 have datatype=18 WARNING : type of input 2 of step 11478 doesn't seem to be define in the database( WARNING : output 1 of step 11454 have datatype=7 whereas input 2 of step 11478 have datatype=None WARNING : type of output 3 of step 11478 doesn't seem to be define in the database( WARNING : type of input 2 of step 11456 doesn't seem to be define in the database( WARNING : output 0 of step 11453 have datatype=1 whereas input 0 of step 11454 have datatype=2 DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20776398 AND mptpi.`type`=3726 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'24022025': {'nb_upload': 30, 'nb_taggue_class': 0, 'nb_taggue_densite': 0}} Inside saveOutput : final : True verbose : 0 saveOutput not yet implemented for datou_step.type : split_time_score we use saveGeneral [1339355240, 1339355213, 1339355212, 1339355179, 1339355176, 1339355147, 1339355144, 1339354926, 1339354906, 1339354666] Looping around the photos to save general results len do output : 1 /20776396Didn'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 ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355240', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355213', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355212', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355179', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355176', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355147', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339355144', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354926', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354906', None, None, None, None, None, '2610201') ('3459', None, None, None, None, None, None, None, '2610201') ('3459', None, '1339354666', None, None, None, None, None, '2610201') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.01576852798461914 save_final save missing photos in datou_result : time spend for datou_step_exec : 19.428428649902344 time spend to save output : 0.01597285270690918 total time spend for step 11 : 19.444401502609253 caffe_path_current : About to save ! 2 After save, about to update current ! update_current_state 37.56user 31.22system 1:40.30elapsed 68%CPU (0avgtext+0avgdata 2543000maxresident)k 175568inputs+25888outputs (6994major+1869957minor)pagefaults 0swaps