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 : 2852616 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 : 27>10 please execute split_portfolio.py -i 20681346 -l 10 size over we load limit photo not treated list_input_json: [] Current got : datou_id : 3459, datou_cur_ids : ['2600137'] with mtr_portfolio_ids : ['20681346'] and first list_photo_ids : [] new path : /proc/2852616/ 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 : 2.225247621536255 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 Thu Feb 20 18:08:31 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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 : 2743 max_wait_temp : 1 max_wait : 0 gpu_flag : 0 2025-02-20 18:08:34.082733: 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-20 18:08:34.111132: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-02-20 18:08:34.113361: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7f8380000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-02-20 18:08:34.113392: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-02-20 18:08:34.117326: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-02-20 18:08:34.392551: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x2fe017c0 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-02-20 18:08:34.392622: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-02-20 18:08:34.393532: 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-20 18:08:34.394019: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-20 18:08:34.397899: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-20 18:08:34.401359: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-20 18:08:34.401785: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-20 18:08:34.407164: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-20 18:08:34.408553: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-20 18:08:34.418295: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-20 18:08:34.419558: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-20 18:08:34.419658: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-20 18:08:34.420313: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-02-20 18:08:34.420394: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-02-20 18:08:34.420407: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-02-20 18:08:34.421753: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 2291 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-20 18:08:34.720342: 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-20 18:08:34.720479: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-20 18:08:34.720507: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-20 18:08:34.720533: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-20 18:08:34.720555: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-20 18:08:34.720581: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-20 18:08:34.720602: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-20 18:08:34.720626: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-20 18:08:34.721755: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-20 18:08:34.722909: 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-20 18:08:34.722973: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-02-20 18:08:34.722998: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-20 18:08:34.723019: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-02-20 18:08:34.723049: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-02-20 18:08:34.723080: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-02-20 18:08:34.723109: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-02-20 18:08:34.723135: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-20 18:08:34.724280: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-02-20 18:08:34.724315: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-02-20 18:08:34.724326: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-02-20 18:08:34.724337: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-02-20 18:08:34.725532: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 2291 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-20 18:08:44.672962: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-02-20 18:08:44.836477: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-02-20 18:08:46.682693: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.06GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.682771: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.06GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.689234: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.06GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.689260: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.06GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.741075: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.06GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.741129: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.06GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.784436: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.09GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.784473: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.09GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.835762: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.15GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.835799: W tensorflow/core/common_runtime/bfc_allocator.cc:245] Allocator (GPU_0_bfc) ran out of memory trying to allocate 2.15GiB with freed_by_count=0. The caller indicates that this is not a failure, but may mean that there could be performance gains if more memory were available. 2025-02-20 18:08:46.838291: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.24G (1330511872 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.838827: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.11G (1197460736 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.838841: W tensorflow/core/common_runtime/bfc_allocator.cc:311] Garbage collection: deallocate free memory regions (i.e., allocations) so that we can re-allocate a larger region to avoid OOM due to memory fragmentation. If you see this message frequently, you are running near the threshold of the available device memory and re-allocation may incur great performance overhead. You may try smaller batch sizes to observe the performance impact. Set TF_ENABLE_GPU_GARBAGE_COLLECTION=false if you'd like to disable this feature. 2025-02-20 18:08:46.855827: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.856401: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.887324: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.888145: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.890133: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.890731: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.897594: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.898183: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.900175: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.900740: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.907634: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.908213: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.910099: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.910626: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.942461: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.943478: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.944453: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.945029: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.948838: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.949613: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.965273: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.965857: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.966417: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.967001: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.979534: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.980114: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.980676: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.981236: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.985793: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.986361: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.991196: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:46.991975: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.004146: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.004953: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.009262: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.010049: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.011187: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.011990: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.022557: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.023402: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.024206: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.024782: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.025360: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.025949: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.068125: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.068207: W tensorflow/core/kernels/gpu_utils.cc:49] Failed to allocate memory for convolution redzone checking; skipping this check. This is benign and only means that we won't check cudnn for out-of-bounds reads and writes. This message will only be printed once. 2025-02-20 18:08:47.068954: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.069484: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.076874: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.077400: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.085600: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.086128: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.105558: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.106557: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.107288: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.108446: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.113083: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.114115: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.115206: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.116287: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.117500: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.127416: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.128193: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.137329: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.137899: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.138477: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.139322: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.140105: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 2025-02-20 18:08:47.140665: I tensorflow/stream_executor/cuda/cuda_driver.cc:763] failed to allocate 1.74G (1867382784 bytes) from device: CUDA_ERROR_OUT_OF_MEMORY: out of memory 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: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 21 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 21 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 18 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 19 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 12 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 8 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 13 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 16 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 4 NEW PHOTO Processing 1 images image shape: (2160, 3264, 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: 3264.00000 nb d'objets trouves : 8 Detection mask done ! Trying to reset tf kernel 2853146 begin to check gpu status inside check gpu memory l 3610 free memory gpu now : 1550 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 : 2964 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.003191232681274414 nb_pixel_total : 150443 time to create 1 rle with new method : 0.008769989013671875 length of segment : 500 time for calcul the mask position with numpy : 0.0006606578826904297 nb_pixel_total : 46372 time to create 1 rle with old method : 0.051223039627075195 length of segment : 232 time for calcul the mask position with numpy : 0.0021440982818603516 nb_pixel_total : 123093 time to create 1 rle with old method : 0.12937331199645996 length of segment : 457 time for calcul the mask position with numpy : 0.0029859542846679688 nb_pixel_total : 203644 time to create 1 rle with new method : 0.008075714111328125 length of segment : 511 time for calcul the mask position with numpy : 0.0004425048828125 nb_pixel_total : 20615 time to create 1 rle with old method : 0.021956205368041992 length of segment : 202 time for calcul the mask position with numpy : 0.0002582073211669922 nb_pixel_total : 7705 time to create 1 rle with old method : 0.008599996566772461 length of segment : 169 time for calcul the mask position with numpy : 0.0008990764617919922 nb_pixel_total : 40212 time to create 1 rle with old method : 0.04295206069946289 length of segment : 257 time for calcul the mask position with numpy : 0.0022847652435302734 nb_pixel_total : 123056 time to create 1 rle with old method : 0.13231611251831055 length of segment : 469 time for calcul the mask position with numpy : 1.0834476947784424 nb_pixel_total : 1900083 time to create 1 rle with new method : 1.7578847408294678 length of segment : 1936 time for calcul the mask position with numpy : 0.017573118209838867 nb_pixel_total : 582245 time to create 1 rle with new method : 0.029570341110229492 length of segment : 1017 time for calcul the mask position with numpy : 0.00015974044799804688 nb_pixel_total : 4271 time to create 1 rle with old method : 0.004775285720825195 length of segment : 110 time for calcul the mask position with numpy : 0.0002655982971191406 nb_pixel_total : 1995 time to create 1 rle with old method : 0.0023145675659179688 length of segment : 60 time for calcul the mask position with numpy : 0.0001857280731201172 nb_pixel_total : 4874 time to create 1 rle with old method : 0.006205081939697266 length of segment : 50 time for calcul the mask position with numpy : 0.0033614635467529297 nb_pixel_total : 111721 time to create 1 rle with old method : 0.11959552764892578 length of segment : 511 time for calcul the mask position with numpy : 0.0028557777404785156 nb_pixel_total : 52402 time to create 1 rle with old method : 0.057654619216918945 length of segment : 531 time for calcul the mask position with numpy : 0.0004420280456542969 nb_pixel_total : 9631 time to create 1 rle with old method : 0.010871171951293945 length of segment : 96 time for calcul the mask position with numpy : 0.003401041030883789 nb_pixel_total : 154597 time to create 1 rle with new method : 0.007065534591674805 length of segment : 350 time for calcul the mask position with numpy : 0.002205371856689453 nb_pixel_total : 42449 time to create 1 rle with old method : 0.04701828956604004 length of segment : 803 time for calcul the mask position with numpy : 0.00026106834411621094 nb_pixel_total : 5648 time to create 1 rle with old method : 0.006525516510009766 length of segment : 81 time for calcul the mask position with numpy : 0.0021605491638183594 nb_pixel_total : 59169 time to create 1 rle with old method : 0.06529903411865234 length of segment : 300 time for calcul the mask position with numpy : 0.000713348388671875 nb_pixel_total : 20361 time to create 1 rle with old method : 0.023347854614257812 length of segment : 130 time for calcul the mask position with numpy : 0.0004940032958984375 nb_pixel_total : 11325 time to create 1 rle with old method : 0.013223409652709961 length of segment : 139 time for calcul the mask position with numpy : 0.00017571449279785156 nb_pixel_total : 2567 time to create 1 rle with old method : 0.0030112266540527344 length of segment : 69 time for calcul the mask position with numpy : 0.004410982131958008 nb_pixel_total : 166152 time to create 1 rle with new method : 0.007030487060546875 length of segment : 491 time for calcul the mask position with numpy : 0.006806612014770508 nb_pixel_total : 171511 time to create 1 rle with new method : 0.01196908950805664 length of segment : 731 time for calcul the mask position with numpy : 0.0007300376892089844 nb_pixel_total : 23160 time to create 1 rle with old method : 0.037384033203125 length of segment : 150 time for calcul the mask position with numpy : 0.002241373062133789 nb_pixel_total : 93863 time to create 1 rle with old method : 0.10251021385192871 length of segment : 415 time for calcul the mask position with numpy : 0.00015115737915039062 nb_pixel_total : 1036 time to create 1 rle with old method : 0.0013489723205566406 length of segment : 47 time for calcul the mask position with numpy : 0.0017542839050292969 nb_pixel_total : 97060 time to create 1 rle with old method : 0.10433053970336914 length of segment : 429 time for calcul the mask position with numpy : 0.003899812698364258 nb_pixel_total : 143787 time to create 1 rle with old method : 0.15452980995178223 length of segment : 473 time for calcul the mask position with numpy : 0.0037093162536621094 nb_pixel_total : 84650 time to create 1 rle with old method : 0.09083795547485352 length of segment : 572 time for calcul the mask position with numpy : 0.0021011829376220703 nb_pixel_total : 106457 time to create 1 rle with old method : 0.11492490768432617 length of segment : 553 time for calcul the mask position with numpy : 0.002443075180053711 nb_pixel_total : 103571 time to create 1 rle with old method : 0.1118617057800293 length of segment : 248 time for calcul the mask position with numpy : 0.0009894371032714844 nb_pixel_total : 28077 time to create 1 rle with old method : 0.030204296112060547 length of segment : 251 time for calcul the mask position with numpy : 0.0021889209747314453 nb_pixel_total : 73395 time to create 1 rle with old method : 0.07897186279296875 length of segment : 374 time for calcul the mask position with numpy : 0.00019359588623046875 nb_pixel_total : 2871 time to create 1 rle with old method : 0.0034759044647216797 length of segment : 59 time for calcul the mask position with numpy : 0.0007832050323486328 nb_pixel_total : 17656 time to create 1 rle with old method : 0.0202023983001709 length of segment : 210 time for calcul the mask position with numpy : 0.006751298904418945 nb_pixel_total : 167310 time to create 1 rle with new method : 0.012236833572387695 length of segment : 709 time for calcul the mask position with numpy : 0.00045013427734375 nb_pixel_total : 9319 time to create 1 rle with old method : 0.010658979415893555 length of segment : 128 time for calcul the mask position with numpy : 0.0014743804931640625 nb_pixel_total : 24664 time to create 1 rle with old method : 0.0282595157623291 length of segment : 257 time for calcul the mask position with numpy : 0.0007624626159667969 nb_pixel_total : 18235 time to create 1 rle with old method : 0.02052474021911621 length of segment : 183 time for calcul the mask position with numpy : 0.004454135894775391 nb_pixel_total : 191314 time to create 1 rle with new method : 0.011781930923461914 length of segment : 877 time for calcul the mask position with numpy : 0.0003921985626220703 nb_pixel_total : 11045 time to create 1 rle with old method : 0.012623786926269531 length of segment : 128 time for calcul the mask position with numpy : 0.00015592575073242188 nb_pixel_total : 1366 time to create 1 rle with old method : 0.0016841888427734375 length of segment : 43 time for calcul the mask position with numpy : 0.0001964569091796875 nb_pixel_total : 5591 time to create 1 rle with old method : 0.0064661502838134766 length of segment : 125 time for calcul the mask position with numpy : 0.000978231430053711 nb_pixel_total : 34986 time to create 1 rle with old method : 0.03841114044189453 length of segment : 179 time for calcul the mask position with numpy : 0.0003273487091064453 nb_pixel_total : 8958 time to create 1 rle with old method : 0.010091781616210938 length of segment : 84 time for calcul the mask position with numpy : 0.0009105205535888672 nb_pixel_total : 26325 time to create 1 rle with old method : 0.028218746185302734 length of segment : 286 time for calcul the mask position with numpy : 0.002713441848754883 nb_pixel_total : 123588 time to create 1 rle with old method : 0.13437485694885254 length of segment : 406 time for calcul the mask position with numpy : 0.0009500980377197266 nb_pixel_total : 40670 time to create 1 rle with old method : 0.04422593116760254 length of segment : 152 time for calcul the mask position with numpy : 0.0004677772521972656 nb_pixel_total : 7518 time to create 1 rle with old method : 0.008453130722045898 length of segment : 140 time for calcul the mask position with numpy : 0.0021080970764160156 nb_pixel_total : 40718 time to create 1 rle with old method : 0.04385519027709961 length of segment : 397 time for calcul the mask position with numpy : 0.0019452571868896484 nb_pixel_total : 54335 time to create 1 rle with old method : 0.0573115348815918 length of segment : 363 time for calcul the mask position with numpy : 0.0016064643859863281 nb_pixel_total : 46887 time to create 1 rle with old method : 0.05161118507385254 length of segment : 326 time for calcul the mask position with numpy : 0.0027675628662109375 nb_pixel_total : 106401 time to create 1 rle with old method : 0.1152048110961914 length of segment : 569 time for calcul the mask position with numpy : 0.0014350414276123047 nb_pixel_total : 32285 time to create 1 rle with old method : 0.03551149368286133 length of segment : 287 time for calcul the mask position with numpy : 0.0002269744873046875 nb_pixel_total : 7174 time to create 1 rle with old method : 0.008063316345214844 length of segment : 142 time for calcul the mask position with numpy : 0.0008265972137451172 nb_pixel_total : 15914 time to create 1 rle with old method : 0.019055843353271484 length of segment : 326 time for calcul the mask position with numpy : 0.0019757747650146484 nb_pixel_total : 60762 time to create 1 rle with old method : 0.06768035888671875 length of segment : 278 time for calcul the mask position with numpy : 0.0010852813720703125 nb_pixel_total : 55069 time to create 1 rle with old method : 0.05913233757019043 length of segment : 360 time for calcul the mask position with numpy : 0.0004699230194091797 nb_pixel_total : 7541 time to create 1 rle with old method : 0.012339115142822266 length of segment : 85 time for calcul the mask position with numpy : 0.00032067298889160156 nb_pixel_total : 12439 time to create 1 rle with old method : 0.02010321617126465 length of segment : 239 time for calcul the mask position with numpy : 0.005797863006591797 nb_pixel_total : 207303 time to create 1 rle with new method : 0.011792898178100586 length of segment : 825 time for calcul the mask position with numpy : 0.0014090538024902344 nb_pixel_total : 52722 time to create 1 rle with old method : 0.057343482971191406 length of segment : 295 time for calcul the mask position with numpy : 0.00070953369140625 nb_pixel_total : 21753 time to create 1 rle with old method : 0.023990869522094727 length of segment : 242 time for calcul the mask position with numpy : 0.0007109642028808594 nb_pixel_total : 21011 time to create 1 rle with old method : 0.0239865779876709 length of segment : 259 time for calcul the mask position with numpy : 0.0015833377838134766 nb_pixel_total : 61097 time to create 1 rle with old method : 0.06579136848449707 length of segment : 398 time for calcul the mask position with numpy : 0.0009667873382568359 nb_pixel_total : 28156 time to create 1 rle with old method : 0.033284902572631836 length of segment : 291 time for calcul the mask position with numpy : 0.0005750656127929688 nb_pixel_total : 14143 time to create 1 rle with old method : 0.01557612419128418 length of segment : 188 time for calcul the mask position with numpy : 0.0009121894836425781 nb_pixel_total : 35273 time to create 1 rle with old method : 0.038802385330200195 length of segment : 238 time for calcul the mask position with numpy : 0.003033161163330078 nb_pixel_total : 112876 time to create 1 rle with old method : 0.12168312072753906 length of segment : 375 time for calcul the mask position with numpy : 0.0046160221099853516 nb_pixel_total : 259412 time to create 1 rle with new method : 0.006942033767700195 length of segment : 474 time for calcul the mask position with numpy : 0.0006499290466308594 nb_pixel_total : 36820 time to create 1 rle with old method : 0.04128289222717285 length of segment : 223 time for calcul the mask position with numpy : 0.0006628036499023438 nb_pixel_total : 21988 time to create 1 rle with old method : 0.024547100067138672 length of segment : 227 time for calcul the mask position with numpy : 0.00019669532775878906 nb_pixel_total : 3315 time to create 1 rle with old method : 0.0038270950317382812 length of segment : 109 time for calcul the mask position with numpy : 0.0007529258728027344 nb_pixel_total : 32148 time to create 1 rle with old method : 0.03560042381286621 length of segment : 150 time for calcul the mask position with numpy : 0.004493236541748047 nb_pixel_total : 169563 time to create 1 rle with new method : 0.008849620819091797 length of segment : 785 time for calcul the mask position with numpy : 0.0005042552947998047 nb_pixel_total : 29427 time to create 1 rle with old method : 0.03268098831176758 length of segment : 122 time for calcul the mask position with numpy : 0.00456690788269043 nb_pixel_total : 261727 time to create 1 rle with new method : 0.009064674377441406 length of segment : 602 time for calcul the mask position with numpy : 0.0009894371032714844 nb_pixel_total : 37052 time to create 1 rle with old method : 0.04202437400817871 length of segment : 215 time for calcul the mask position with numpy : 0.0005342960357666016 nb_pixel_total : 12748 time to create 1 rle with old method : 0.023029088973999023 length of segment : 177 time for calcul the mask position with numpy : 0.0009906291961669922 nb_pixel_total : 12206 time to create 1 rle with old method : 0.01441049575805664 length of segment : 204 time for calcul the mask position with numpy : 0.002425670623779297 nb_pixel_total : 105402 time to create 1 rle with old method : 0.11821556091308594 length of segment : 507 time for calcul the mask position with numpy : 0.0037279129028320312 nb_pixel_total : 183030 time to create 1 rle with new method : 0.0057561397552490234 length of segment : 372 time for calcul the mask position with numpy : 0.00121307373046875 nb_pixel_total : 44732 time to create 1 rle with old method : 0.06694841384887695 length of segment : 210 time for calcul the mask position with numpy : 0.0016546249389648438 nb_pixel_total : 47319 time to create 1 rle with old method : 0.05321455001831055 length of segment : 406 time for calcul the mask position with numpy : 0.0029039382934570312 nb_pixel_total : 134236 time to create 1 rle with old method : 0.14435148239135742 length of segment : 502 time for calcul the mask position with numpy : 0.00012755393981933594 nb_pixel_total : 2432 time to create 1 rle with old method : 0.0029401779174804688 length of segment : 34 time for calcul the mask position with numpy : 0.00011277198791503906 nb_pixel_total : 1874 time to create 1 rle with old method : 0.0023560523986816406 length of segment : 55 time for calcul the mask position with numpy : 0.00011897087097167969 nb_pixel_total : 1181 time to create 1 rle with old method : 0.0014872550964355469 length of segment : 48 time for calcul the mask position with numpy : 0.0029540061950683594 nb_pixel_total : 103898 time to create 1 rle with old method : 0.11430025100708008 length of segment : 548 time for calcul the mask position with numpy : 0.005968332290649414 nb_pixel_total : 217942 time to create 1 rle with new method : 0.009383201599121094 length of segment : 815 time for calcul the mask position with numpy : 0.0007159709930419922 nb_pixel_total : 46717 time to create 1 rle with old method : 0.051238298416137695 length of segment : 281 time for calcul the mask position with numpy : 0.0006067752838134766 nb_pixel_total : 22746 time to create 1 rle with old method : 0.02494192123413086 length of segment : 221 time for calcul the mask position with numpy : 0.00021958351135253906 nb_pixel_total : 5712 time to create 1 rle with old method : 0.006512641906738281 length of segment : 90 time for calcul the mask position with numpy : 0.002024412155151367 nb_pixel_total : 113992 time to create 1 rle with old method : 0.1334676742553711 length of segment : 505 time for calcul the mask position with numpy : 0.00034308433532714844 nb_pixel_total : 6709 time to create 1 rle with old method : 0.0076863765716552734 length of segment : 90 time for calcul the mask position with numpy : 0.0005648136138916016 nb_pixel_total : 13603 time to create 1 rle with old method : 0.015306472778320312 length of segment : 194 time for calcul the mask position with numpy : 0.0001430511474609375 nb_pixel_total : 5327 time to create 1 rle with old method : 0.006275177001953125 length of segment : 69 time for calcul the mask position with numpy : 0.035881757736206055 nb_pixel_total : 427678 time to create 1 rle with new method : 1.1259946823120117 length of segment : 1219 time for calcul the mask position with numpy : 0.035094261169433594 nb_pixel_total : 1436799 time to create 1 rle with new method : 0.49120664596557617 length of segment : 2492 time for calcul the mask position with numpy : 0.001140594482421875 nb_pixel_total : 46391 time to create 1 rle with old method : 0.050925493240356445 length of segment : 450 time for calcul the mask position with numpy : 0.00035119056701660156 nb_pixel_total : 16398 time to create 1 rle with old method : 0.02173304557800293 length of segment : 165 time for calcul the mask position with numpy : 0.0008864402770996094 nb_pixel_total : 49872 time to create 1 rle with old method : 0.0547337532043457 length of segment : 276 time for calcul the mask position with numpy : 0.0016579627990722656 nb_pixel_total : 110139 time to create 1 rle with old method : 0.1232764720916748 length of segment : 900 time for calcul the mask position with numpy : 0.00010633468627929688 nb_pixel_total : 2735 time to create 1 rle with old method : 0.003268718719482422 length of segment : 59 time for calcul the mask position with numpy : 0.23028802871704102 nb_pixel_total : 2624911 time to create 1 rle with new method : 0.6136074066162109 length of segment : 3469 time for calcul the mask position with numpy : 0.0001456737518310547 nb_pixel_total : 1926 time to create 1 rle with old method : 0.0022640228271484375 length of segment : 49 time for calcul the mask position with numpy : 0.0001468658447265625 nb_pixel_total : 3228 time to create 1 rle with old method : 0.004475593566894531 length of segment : 77 time for calcul the mask position with numpy : 0.0008273124694824219 nb_pixel_total : 48816 time to create 1 rle with old method : 0.053261756896972656 length of segment : 314 time for calcul the mask position with numpy : 0.0005004405975341797 nb_pixel_total : 18621 time to create 1 rle with old method : 0.020957231521606445 length of segment : 138 time for calcul the mask position with numpy : 0.0023467540740966797 nb_pixel_total : 99586 time to create 1 rle with old method : 0.10596489906311035 length of segment : 434 time for calcul the mask position with numpy : 0.0011477470397949219 nb_pixel_total : 50791 time to create 1 rle with old method : 0.05525040626525879 length of segment : 316 time for calcul the mask position with numpy : 0.0010349750518798828 nb_pixel_total : 17301 time to create 1 rle with old method : 0.019756317138671875 length of segment : 424 time for calcul the mask position with numpy : 0.0008144378662109375 nb_pixel_total : 35386 time to create 1 rle with old method : 0.04010653495788574 length of segment : 213 time for calcul the mask position with numpy : 0.0008795261383056641 nb_pixel_total : 28590 time to create 1 rle with old method : 0.04545736312866211 length of segment : 175 time for calcul the mask position with numpy : 0.0013489723205566406 nb_pixel_total : 68737 time to create 1 rle with old method : 0.07322382926940918 length of segment : 339 time for calcul the mask position with numpy : 0.00019431114196777344 nb_pixel_total : 3226 time to create 1 rle with old method : 0.00371551513671875 length of segment : 77 time spent for convertir_results : 18.58625292778015 Inside saveOutput : final : False verbose : 0 eke 12-6-18 : saveMask need to be cleaned for new output ! Number saved : None batch 1 Loaded 118 chid ids of type : 3663 Number RLEs to save : 43984 save missing photos in datou_result : time spend for datou_step_exec : 60.09858846664429 time spend to save output : 2.819221258163452 total time spend for step 1 : 62.91780972480774 step2:crop_condition Thu Feb 20 18:09: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 Loading chi in step crop with photo_hashtag_type : 3663 Loading chi in step crop for list_pids : 10 ! batch 1 Loaded 118 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 ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 22 About to insert : list_path_to_insert length 22 new photo from crops ! we have finished the crop for the class : teint_dans_la_masse begin to crop the class : autre_refus param for this class : {'min_score': 0.5} filtre for class : autre_refus hashtag_id of this class : 2107752406 we have both polygon and rles Next one ! we have both polygon and rles Next one ! 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 : 7 About to insert : list_path_to_insert length 7 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 ! 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 : 6 About to insert : list_path_to_insert length 6 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 ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 34 About to insert : list_path_to_insert length 34 new photo from crops ! we have finished the crop for the class : cartonnette begin to crop the class : carton_brun param for this class : {'min_score': 0.7} filtre for class : carton_brun hashtag_id of this class : 2107753024 we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! we have finished the crop for the class : carton_brun begin to crop the class : plastique param for this class : {'min_score': 0.5} filtre for class : plastique hashtag_id of this class : 492725882 we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 2 About to insert : list_path_to_insert length 2 new photo from crops ! we have finished the crop for the class : plastique begin to crop the class : kraft param for this class : {'min_score': 0.5} filtre for class : kraft hashtag_id of this class : 493202403 we have both polygon and rles Next one ! we have both polygon and rles Next one ! map_result returned by crop_photo_return_map_crop : length : 2 About to insert : list_path_to_insert length 2 new photo from crops ! we have finished the crop for the class : kraft 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 [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 74 /-3680847033Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847051Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847053Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847063Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847059Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847052Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847062Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847066Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847067Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847070Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847080Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847087Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847081Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847084Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847089Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847082Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847085Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847101Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847100Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847106Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847118Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847126Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847037Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847072Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847103Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847111Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847119Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847144Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847147Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847046Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847065Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847074Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847110Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847115Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847137Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847047Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847049Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847036Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847034Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847039Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847050Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847048Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847058Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847061Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847056Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847069Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847073Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847078Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847075Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847095Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847088Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847092Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847094Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847091Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847096Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847099Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847104Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847109Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847123Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847116Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847117Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847127Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847124Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847125Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847128Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847135Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847136Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847148Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847145Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847086Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847057Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847149Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847064Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /-3680847102Didn'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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 232 time used for this insertion : 0.03367018699645996 save_final save missing photos in datou_result : time spend for datou_step_exec : 36.4123592376709 time spend to save output : 0.03667163848876953 total time spend for step 2 : 36.44903087615967 step3:thcl Thu Feb 20 18:10:10 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.009830236434936523 time to convert the images to numpy array : 0.04315495491027832 time to import caffe and check if the image exist : 0.01684427261352539 time to convert the images to numpy array : 0.08373093605041504 time to import caffe and check if the image exist : 0.014661312103271484 time to convert the images to numpy array : 0.49156808853149414 time to import caffe and check if the image exist : 0.00897359848022461 time to convert the images to numpy array : 0.537682056427002 time to import caffe and check if the image exist : 0.018075942993164062 time to convert the images to numpy array : 0.5277352333068848 time to import caffe and check if the image exist : 0.01114034652709961 time to convert the images to numpy array : 0.5353302955627441 time to import caffe and check if the image exist : 0.010598421096801758 time to convert the images to numpy array : 0.5458207130432129 time to import caffe and check if the image exist : 0.00886392593383789 time to convert the images to numpy array : 0.55495285987854 time to import caffe and check if the image exist : 0.014261245727539062 time to convert the images to numpy array : 0.5755383968353271 time to import caffe and check if the image exist : 0.013975143432617188 time to convert the images to numpy array : 0.8800973892211914 total time to convert the images to numpy array : 1.213233470916748 list photo_ids error: [] list photo_ids correct : [-3680847064, -3680847102, -3680847085, -3680847101, -3680847100, -3680847106, -3680847118, -3680847126, -3680847037, -3680847072, -3680847050, -3680847048, -3680847058, -3680847061, -3680847056, -3680847069, -3680847073, -3680847078, -3680847033, -3680847051, -3680847053, -3680847063, -3680847059, -3680847052, -3680847062, -3680847066, -3680847075, -3680847095, -3680847088, -3680847092, -3680847094, -3680847091, -3680847096, -3680847099, -3680847128, -3680847135, -3680847136, -3680847148, -3680847145, -3680847086, -3680847057, -3680847149, -3680847067, -3680847070, -3680847080, -3680847087, -3680847081, -3680847084, -3680847089, -3680847082, -3680847110, -3680847115, -3680847137, -3680847047, -3680847049, -3680847036, -3680847034, -3680847039, -3680847104, -3680847109, -3680847123, -3680847116, -3680847117, -3680847127, -3680847124, -3680847125, -3680847103, -3680847111, -3680847119, -3680847144, -3680847147, -3680847046, -3680847065, -3680847074] number of photos to traite : 74 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 : 2964 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 : 2745 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.7675244808197021 time used to do the prediction : 0.18742966651916504 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 : 2743 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 : 2743 max_wait_temp : 1 max_wait : 0 dict_keys(['prob']) time used to do the prepocess of the images : 0.8057229518890381 time used to do the prediction : 0.14832592010498047 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 : 7.152557373046875e-06 save missing photos in datou_result : time spend for datou_step_exec : 9.978097915649414 time spend to save output : 0.0005147457122802734 total time spend for step 3 : 9.978612661361694 step4:merge_mask_thcl_custom Thu Feb 20 18:10:20 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 118 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 [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 10 /1338538264Didn't retrieve data .Didn't retrieve data . /1338538263Didn't retrieve data .Didn't retrieve data . /1338528173Didn't retrieve data .Didn't retrieve data . /1338528169Didn't retrieve data .Didn't retrieve data . /1338528165Didn't retrieve data .Didn't retrieve data . /1338528160Didn't retrieve data .Didn't retrieve data . /1338528156Didn't retrieve data .Didn't retrieve data . /1338527564Didn't retrieve data .Didn't retrieve data . /1338527556Didn't retrieve data .Didn't retrieve data . /1338527541Didn'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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.014076948165893555 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.05871176719665527 time spend to save output : 0.014553308486938477 total time spend for step 4 : 0.07326507568359375 step5:rle_unique_nms_with_priority Thu Feb 20 18:10:20 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 : 17 nb_hashtags : 5 time to prepare the origin masks : 17.629355430603027 time for calcul the mask position with numpy : 1.3739008903503418 nb_pixel_total : 4134402 time to create 1 rle with new method : 1.3994050025939941 time for calcul the mask position with numpy : 0.035471439361572266 nb_pixel_total : 9587 time to create 1 rle with old method : 0.010341405868530273 time for calcul the mask position with numpy : 0.042734622955322266 nb_pixel_total : 122447 time to create 1 rle with old method : 0.13759255409240723 time for calcul the mask position with numpy : 0.03557300567626953 nb_pixel_total : 46267 time to create 1 rle with old method : 0.05022788047790527 time for calcul the mask position with numpy : 0.03690457344055176 nb_pixel_total : 20571 time to create 1 rle with old method : 0.021976709365844727 time for calcul the mask position with numpy : 0.04306197166442871 nb_pixel_total : 1980 time to create 1 rle with old method : 0.002309560775756836 time for calcul the mask position with numpy : 0.03518486022949219 nb_pixel_total : 4247 time to create 1 rle with old method : 0.006557941436767578 time for calcul the mask position with numpy : 0.03628683090209961 nb_pixel_total : 127128 time to create 1 rle with old method : 0.13488340377807617 time for calcul the mask position with numpy : 0.03680086135864258 nb_pixel_total : 149249 time to create 1 rle with old method : 0.1623084545135498 time for calcul the mask position with numpy : 0.060117483139038086 nb_pixel_total : 1899628 time to create 1 rle with new method : 0.4495556354522705 time for calcul the mask position with numpy : 0.03668355941772461 nb_pixel_total : 8719 time to create 1 rle with old method : 0.010260820388793945 time for calcul the mask position with numpy : 0.03531599044799805 nb_pixel_total : 2367 time to create 1 rle with old method : 0.0027687549591064453 time for calcul the mask position with numpy : 0.03638005256652832 nb_pixel_total : 111888 time to create 1 rle with old method : 0.11902689933776855 time for calcul the mask position with numpy : 0.037279605865478516 nb_pixel_total : 122868 time to create 1 rle with old method : 0.1348409652709961 time for calcul the mask position with numpy : 0.035979509353637695 nb_pixel_total : 40184 time to create 1 rle with old method : 0.04264569282531738 time for calcul the mask position with numpy : 0.03668093681335449 nb_pixel_total : 154120 time to create 1 rle with new method : 0.32830214500427246 time for calcul the mask position with numpy : 0.03569483757019043 nb_pixel_total : 52210 time to create 1 rle with old method : 0.05652737617492676 time for calcul the mask position with numpy : 0.036496877670288086 nb_pixel_total : 42378 time to create 1 rle with old method : 0.06722617149353027 create new chi : 5.236389398574829 time to delete rle : 0.011200666427612305 batch 1 Loaded 18 chid ids of type : 3726 Number RLEs to save : 16267 TO DO : save crop sub photo not yet done ! save time : 1.8234999179840088 nb_obj : 15 nb_hashtags : 4 time to prepare the origin masks : 16.232492446899414 time for calcul the mask position with numpy : 1.6016578674316406 nb_pixel_total : 6160288 time to create 1 rle with new method : 1.0088865756988525 time for calcul the mask position with numpy : 0.03741264343261719 nb_pixel_total : 21845 time to create 1 rle with old method : 0.02567124366760254 time for calcul the mask position with numpy : 0.03288102149963379 nb_pixel_total : 84473 time to create 1 rle with old method : 0.09006094932556152 time for calcul the mask position with numpy : 0.032062530517578125 nb_pixel_total : 171225 time to create 1 rle with new method : 1.689117670059204 time for calcul the mask position with numpy : 0.03797268867492676 nb_pixel_total : 3691 time to create 1 rle with old method : 0.004250049591064453 time for calcul the mask position with numpy : 0.02751898765563965 nb_pixel_total : 93696 time to create 1 rle with old method : 0.10392951965332031 time for calcul the mask position with numpy : 0.025624990463256836 nb_pixel_total : 1028 time to create 1 rle with old method : 0.0012776851654052734 time for calcul the mask position with numpy : 0.032900333404541016 nb_pixel_total : 2549 time to create 1 rle with old method : 0.003832578659057617 time for calcul the mask position with numpy : 0.03664994239807129 nb_pixel_total : 11203 time to create 1 rle with old method : 0.01252603530883789 time for calcul the mask position with numpy : 0.03858184814453125 nb_pixel_total : 2801 time to create 1 rle with old method : 0.003289461135864258 time for calcul the mask position with numpy : 0.036634206771850586 nb_pixel_total : 143621 time to create 1 rle with old method : 0.1696479320526123 time for calcul the mask position with numpy : 0.036156415939331055 nb_pixel_total : 20288 time to create 1 rle with old method : 0.02295088768005371 time for calcul the mask position with numpy : 0.03955268859863281 nb_pixel_total : 5615 time to create 1 rle with old method : 0.006968975067138672 time for calcul the mask position with numpy : 0.0353391170501709 nb_pixel_total : 165572 time to create 1 rle with new method : 1.8413028717041016 time for calcul the mask position with numpy : 0.04218888282775879 nb_pixel_total : 59028 time to create 1 rle with old method : 0.06458258628845215 time for calcul the mask position with numpy : 0.03527069091796875 nb_pixel_total : 103317 time to create 1 rle with old method : 0.12269902229309082 create new chi : 7.3925745487213135 time to delete rle : 0.0007214546203613281 batch 1 Loaded 16 chid ids of type : 3726 Number RLEs to save : 11668 TO DO : save crop sub photo not yet done ! save time : 0.7181587219238281 nb_obj : 12 nb_hashtags : 6 time to prepare the origin masks : 13.607466459274292 time for calcul the mask position with numpy : 1.5485584735870361 nb_pixel_total : 6634454 time to create 1 rle with new method : 0.9767980575561523 time for calcul the mask position with numpy : 0.03702044486999512 nb_pixel_total : 4134 time to create 1 rle with old method : 0.0056231021881103516 time for calcul the mask position with numpy : 0.04137015342712402 nb_pixel_total : 73065 time to create 1 rle with old method : 0.08173990249633789 time for calcul the mask position with numpy : 0.037435293197631836 nb_pixel_total : 28016 time to create 1 rle with old method : 0.04876899719238281 time for calcul the mask position with numpy : 0.03985404968261719 nb_pixel_total : 191037 time to create 1 rle with new method : 0.8316090106964111 time for calcul the mask position with numpy : 0.03505873680114746 nb_pixel_total : 1352 time to create 1 rle with old method : 0.001417398452758789 time for calcul the mask position with numpy : 0.03424811363220215 nb_pixel_total : 34858 time to create 1 rle with old method : 0.03748965263366699 time for calcul the mask position with numpy : 0.03735160827636719 nb_pixel_total : 9233 time to create 1 rle with old method : 0.01121377944946289 time for calcul the mask position with numpy : 0.03814840316772461 nb_pixel_total : 17614 time to create 1 rle with old method : 0.03298592567443848 time for calcul the mask position with numpy : 0.03715944290161133 nb_pixel_total : 10995 time to create 1 rle with old method : 0.012311220169067383 time for calcul the mask position with numpy : 0.03736257553100586 nb_pixel_total : 2857 time to create 1 rle with old method : 0.003218412399291992 time for calcul the mask position with numpy : 0.04106593132019043 nb_pixel_total : 24542 time to create 1 rle with old method : 0.027571916580200195 time for calcul the mask position with numpy : 0.024544477462768555 nb_pixel_total : 18083 time to create 1 rle with old method : 0.019371509552001953 create new chi : 4.145572900772095 time to delete rle : 0.00047850608825683594 batch 1 Loaded 13 chid ids of type : 3726 Number RLEs to save : 7961 TO DO : save crop sub photo not yet done ! save time : 0.6404759883880615 nb_obj : 16 nb_hashtags : 6 time to prepare the origin masks : 15.143069744110107 time for calcul the mask position with numpy : 2.0660014152526855 nb_pixel_total : 6268807 time to create 1 rle with new method : 1.57918381690979 time for calcul the mask position with numpy : 0.03265070915222168 nb_pixel_total : 60534 time to create 1 rle with old method : 0.06411600112915039 time for calcul the mask position with numpy : 0.03461909294128418 nb_pixel_total : 40539 time to create 1 rle with old method : 0.043503522872924805 time for calcul the mask position with numpy : 0.034020423889160156 nb_pixel_total : 207230 time to create 1 rle with new method : 1.906299114227295 time for calcul the mask position with numpy : 0.03131699562072754 nb_pixel_total : 7149 time to create 1 rle with old method : 0.00738072395324707 time for calcul the mask position with numpy : 0.030846118927001953 nb_pixel_total : 23729 time to create 1 rle with old method : 0.025186777114868164 time for calcul the mask position with numpy : 0.035184383392333984 nb_pixel_total : 109936 time to create 1 rle with old method : 0.11795735359191895 time for calcul the mask position with numpy : 0.04003643989562988 nb_pixel_total : 12434 time to create 1 rle with old method : 0.01964545249938965 time for calcul the mask position with numpy : 0.028144359588623047 nb_pixel_total : 43245 time to create 1 rle with old method : 0.04616808891296387 time for calcul the mask position with numpy : 0.020794391632080078 nb_pixel_total : 7512 time to create 1 rle with old method : 0.007917404174804688 time for calcul the mask position with numpy : 0.02066349983215332 nb_pixel_total : 15880 time to create 1 rle with old method : 0.01707911491394043 time for calcul the mask position with numpy : 0.02072000503540039 nb_pixel_total : 26329 time to create 1 rle with old method : 0.02968120574951172 time for calcul the mask position with numpy : 0.028178691864013672 nb_pixel_total : 40524 time to create 1 rle with old method : 0.053290605545043945 time for calcul the mask position with numpy : 0.0242156982421875 nb_pixel_total : 123221 time to create 1 rle with old method : 0.1423816680908203 time for calcul the mask position with numpy : 0.030596017837524414 nb_pixel_total : 7486 time to create 1 rle with old method : 0.007918596267700195 time for calcul the mask position with numpy : 0.0345454216003418 nb_pixel_total : 758 time to create 1 rle with old method : 0.0011782646179199219 time for calcul the mask position with numpy : 0.037424564361572266 nb_pixel_total : 54927 time to create 1 rle with old method : 0.05820608139038086 create new chi : 6.743543386459351 time to delete rle : 0.0006425380706787109 batch 1 Loaded 17 chid ids of type : 3726 Number RLEs to save : 11555 TO DO : save crop sub photo not yet done ! save time : 0.7745420932769775 nb_obj : 9 nb_hashtags : 5 time to prepare the origin masks : 20.23086142539978 time for calcul the mask position with numpy : 4.615462779998779 nb_pixel_total : 6431777 time to create 1 rle with new method : 1.632314920425415 time for calcul the mask position with numpy : 0.04503464698791504 nb_pixel_total : 52611 time to create 1 rle with old method : 0.06020760536193848 time for calcul the mask position with numpy : 0.04222583770751953 nb_pixel_total : 112684 time to create 1 rle with old method : 0.12709617614746094 time for calcul the mask position with numpy : 0.03713560104370117 nb_pixel_total : 61567 time to create 1 rle with old method : 0.0662539005279541 time for calcul the mask position with numpy : 0.03634023666381836 nb_pixel_total : 271710 time to create 1 rle with new method : 2.781679630279541 time for calcul the mask position with numpy : 0.03498125076293945 nb_pixel_total : 35163 time to create 1 rle with old method : 0.03756403923034668 time for calcul the mask position with numpy : 0.034673452377319336 nb_pixel_total : 14040 time to create 1 rle with old method : 0.015378713607788086 time for calcul the mask position with numpy : 0.03459763526916504 nb_pixel_total : 28112 time to create 1 rle with old method : 0.030178546905517578 time for calcul the mask position with numpy : 0.03432297706604004 nb_pixel_total : 20876 time to create 1 rle with old method : 0.02221226692199707 time for calcul the mask position with numpy : 0.0324709415435791 nb_pixel_total : 21700 time to create 1 rle with old method : 0.023519277572631836 create new chi : 9.813380479812622 time to delete rle : 0.0004200935363769531 batch 1 Loaded 10 chid ids of type : 3726 Number RLEs to save : 7354 TO DO : save crop sub photo not yet done ! save time : 0.48578929901123047 nb_obj : 5 nb_hashtags : 4 time to prepare the origin masks : 9.892049551010132 time for calcul the mask position with numpy : 2.0239131450653076 nb_pixel_total : 6564544 time to create 1 rle with new method : 1.9095962047576904 time for calcul the mask position with numpy : 0.021013498306274414 nb_pixel_total : 29292 time to create 1 rle with old method : 0.03347611427307129 time for calcul the mask position with numpy : 0.02363872528076172 nb_pixel_total : 21957 time to create 1 rle with old method : 0.028340816497802734 time for calcul the mask position with numpy : 0.024110078811645508 nb_pixel_total : 3304 time to create 1 rle with old method : 0.004303455352783203 time for calcul the mask position with numpy : 0.022905349731445312 nb_pixel_total : 169677 time to create 1 rle with new method : 1.1003577709197998 time for calcul the mask position with numpy : 0.026600122451782227 nb_pixel_total : 261466 time to create 1 rle with new method : 1.8726508617401123 create new chi : 7.1839728355407715 time to delete rle : 0.00036525726318359375 batch 1 Loaded 6 chid ids of type : 3726 Number RLEs to save : 5888 TO DO : save crop sub photo not yet done ! save time : 0.43791818618774414 nb_obj : 11 nb_hashtags : 5 time to prepare the origin masks : 12.46634817123413 time for calcul the mask position with numpy : 1.7621638774871826 nb_pixel_total : 6376222 time to create 1 rle with new method : 1.1856963634490967 time for calcul the mask position with numpy : 0.03070855140686035 nb_pixel_total : 47047 time to create 1 rle with old method : 0.05110335350036621 time for calcul the mask position with numpy : 0.027667760848999023 nb_pixel_total : 44573 time to create 1 rle with old method : 0.04849672317504883 time for calcul the mask position with numpy : 0.02660679817199707 nb_pixel_total : 105260 time to create 1 rle with old method : 0.11598825454711914 time for calcul the mask position with numpy : 0.027898311614990234 nb_pixel_total : 182154 time to create 1 rle with new method : 1.668825387954712 time for calcul the mask position with numpy : 0.024437904357910156 nb_pixel_total : 1861 time to create 1 rle with old method : 0.002107381820678711 time for calcul the mask position with numpy : 0.02660369873046875 nb_pixel_total : 2421 time to create 1 rle with old method : 0.0027632713317871094 time for calcul the mask position with numpy : 0.031061887741088867 nb_pixel_total : 11995 time to create 1 rle with old method : 0.01259756088256836 time for calcul the mask position with numpy : 0.024108409881591797 nb_pixel_total : 94913 time to create 1 rle with old method : 0.20706558227539062 time for calcul the mask position with numpy : 0.024731159210205078 nb_pixel_total : 134169 time to create 1 rle with old method : 0.13721823692321777 time for calcul the mask position with numpy : 0.02530670166015625 nb_pixel_total : 12671 time to create 1 rle with old method : 0.015376806259155273 time for calcul the mask position with numpy : 0.025589942932128906 nb_pixel_total : 36954 time to create 1 rle with old method : 0.04545903205871582 create new chi : 5.625622987747192 time to delete rle : 0.000545501708984375 batch 1 Loaded 12 chid ids of type : 3726 Number RLEs to save : 8509 TO DO : save crop sub photo not yet done ! save time : 0.5589203834533691 nb_obj : 14 nb_hashtags : 3 time to prepare the origin masks : 18.398443698883057 time for calcul the mask position with numpy : 0.4752798080444336 nb_pixel_total : 4545377 time to create 1 rle with new method : 0.8577466011047363 time for calcul the mask position with numpy : 0.03333163261413574 nb_pixel_total : 4439 time to create 1 rle with old method : 0.0047855377197265625 time for calcul the mask position with numpy : 0.038298606872558594 nb_pixel_total : 2728 time to create 1 rle with old method : 0.003114938735961914 time for calcul the mask position with numpy : 0.042238712310791016 nb_pixel_total : 46378 time to create 1 rle with old method : 0.05203533172607422 time for calcul the mask position with numpy : 0.05164813995361328 nb_pixel_total : 1424638 time to create 1 rle with new method : 1.141376256942749 time for calcul the mask position with numpy : 0.03499865531921387 nb_pixel_total : 22744 time to create 1 rle with old method : 0.025139331817626953 time for calcul the mask position with numpy : 0.04044318199157715 nb_pixel_total : 423921 time to create 1 rle with new method : 1.3912789821624756 time for calcul the mask position with numpy : 0.034021854400634766 nb_pixel_total : 5304 time to create 1 rle with old method : 0.00592494010925293 time for calcul the mask position with numpy : 0.03316044807434082 nb_pixel_total : 13580 time to create 1 rle with old method : 0.014542102813720703 time for calcul the mask position with numpy : 0.03284120559692383 nb_pixel_total : 6660 time to create 1 rle with old method : 0.007341146469116211 time for calcul the mask position with numpy : 0.03371429443359375 nb_pixel_total : 16333 time to create 1 rle with old method : 0.017715930938720703 time for calcul the mask position with numpy : 0.0334773063659668 nb_pixel_total : 113796 time to create 1 rle with old method : 0.12818074226379395 time for calcul the mask position with numpy : 0.02409672737121582 nb_pixel_total : 247932 time to create 1 rle with new method : 1.6508967876434326 time for calcul the mask position with numpy : 0.026732683181762695 nb_pixel_total : 126611 time to create 1 rle with old method : 0.14780950546264648 time for calcul the mask position with numpy : 0.023449420928955078 nb_pixel_total : 49799 time to create 1 rle with old method : 0.059652090072631836 create new chi : 6.575240135192871 time to delete rle : 0.0007560253143310547 batch 1 Loaded 15 chid ids of type : 3726 Number RLEs to save : 15992 TO DO : save crop sub photo not yet done ! save time : 0.9752748012542725 nb_obj : 3 nb_hashtags : 1 time to prepare the origin masks : 4.701835632324219 time for calcul the mask position with numpy : 0.7171125411987305 nb_pixel_total : 4431572 time to create 1 rle with new method : 1.9004476070404053 time for calcul the mask position with numpy : 0.020761489868164062 nb_pixel_total : 3219 time to create 1 rle with old method : 0.003446817398071289 time for calcul the mask position with numpy : 0.02173638343811035 nb_pixel_total : 1925 time to create 1 rle with old method : 0.0026960372924804688 time for calcul the mask position with numpy : 0.03938579559326172 nb_pixel_total : 2613524 time to create 1 rle with new method : 2.40463924407959 create new chi : 5.173433542251587 time to delete rle : 0.00047898292541503906 batch 1 Loaded 4 chid ids of type : 3726 Number RLEs to save : 9374 TO DO : save crop sub photo not yet done ! save time : 0.5948131084442139 nb_obj : 8 nb_hashtags : 5 time to prepare the origin masks : 9.601168632507324 time for calcul the mask position with numpy : 1.1561164855957031 nb_pixel_total : 6729003 time to create 1 rle with new method : 1.1393568515777588 time for calcul the mask position with numpy : 0.02411675453186035 nb_pixel_total : 99321 time to create 1 rle with old method : 0.10223603248596191 time for calcul the mask position with numpy : 0.022814512252807617 nb_pixel_total : 3207 time to create 1 rle with old method : 0.0034818649291992188 time for calcul the mask position with numpy : 0.02370738983154297 nb_pixel_total : 68504 time to create 1 rle with old method : 0.07097363471984863 time for calcul the mask position with numpy : 0.02403879165649414 nb_pixel_total : 28484 time to create 1 rle with old method : 0.030134201049804688 time for calcul the mask position with numpy : 0.023538589477539062 nb_pixel_total : 50677 time to create 1 rle with old method : 0.0561978816986084 time for calcul the mask position with numpy : 0.038889408111572266 nb_pixel_total : 17249 time to create 1 rle with old method : 0.01792621612548828 time for calcul the mask position with numpy : 0.03844714164733887 nb_pixel_total : 18527 time to create 1 rle with old method : 0.019250154495239258 time for calcul the mask position with numpy : 0.038880109786987305 nb_pixel_total : 35268 time to create 1 rle with old method : 0.03641152381896973 create new chi : 2.911454439163208 time to delete rle : 0.0007195472717285156 batch 1 Loaded 9 chid ids of type : 3726 Number RLEs to save : 6373 TO DO : save crop sub photo not yet done ! save time : 0.44673943519592285 map_output_result : {1338538264: (0.0, 'Should be the crop_list due to order', 0), 1338538263: (0.0, 'Should be the crop_list due to order', 0), 1338528173: (0.0, 'Should be the crop_list due to order', 0), 1338528169: (0.0, 'Should be the crop_list due to order', 0), 1338528165: (0.0, 'Should be the crop_list due to order', 0), 1338528160: (0.0, 'Should be the crop_list due to order', 0), 1338528156: (0.0, 'Should be the crop_list due to order', 0), 1338527564: (0.0, 'Should be the crop_list due to order', 0), 1338527556: (0.0, 'Should be the crop_list due to order', 0), 1338527541: (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 [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 10 /1338538264.Didn't retrieve data . /1338538263.Didn't retrieve data . /1338528173.Didn't retrieve data . /1338528169.Didn't retrieve data . /1338528165.Didn't retrieve data . /1338528160.Didn't retrieve data . /1338528156.Didn't retrieve data . /1338527564.Didn't retrieve data . /1338527556.Didn't retrieve data . /1338527541.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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.013121843338012695 save_final save missing photos in datou_result : time spend for datou_step_exec : 207.5999207496643 time spend to save output : 0.013709068298339844 total time spend for step 5 : 207.61362981796265 step6:crop_condition Thu Feb 20 18:13:48 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 120 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 ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 9 About to insert : list_path_to_insert length 9 new photo from crops ! About to upload 9 photos upload in portfolio : 4869462 init cache_photo without model_param we have 9 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740071632_2852616 we have uploaded 9 photos in the portfolio 4869462 time of upload the photos Elapsed time : 3.4087486267089844 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 Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 3 About to insert : list_path_to_insert length 3 new photo from crops ! About to upload 3 photos upload in portfolio : 4869462 init cache_photo without model_param we have 3 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740071638_2852616 we have uploaded 3 photos in the portfolio 4869462 time of upload the photos Elapsed time : 1.296138048171997 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 Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! Next one ! map_result returned by crop_photo_return_map_crop : length : 9 About to insert : list_path_to_insert length 9 new photo from crops ! About to upload 9 photos upload in portfolio : 4869462 init cache_photo without model_param we have 9 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740071645_2852616 we have uploaded 9 photos in the portfolio 4869462 time of upload the photos Elapsed time : 3.4151322841644287 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 Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 4869462 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740071651_2852616 we have uploaded 1 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.664132833480835 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 Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 4869462 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740071653_2852616 we have uploaded 1 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.7974920272827148 we have finished the crop for the class : carton_brun begin to crop the class : plastique param for this class : {'min_score': 0.5} filtre for class : plastique hashtag_id of this class : 492725882 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/1740071657_2852616 we have uploaded 2 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.8916976451873779 we have finished the crop for the class : plastique begin to crop the class : kraft param for this class : {'min_score': 0.5} filtre for class : kraft hashtag_id of this class : 493202403 Next one ! map_result returned by crop_photo_return_map_crop : length : 1 About to insert : list_path_to_insert length 1 new photo from crops ! About to upload 1 photos upload in portfolio : 4869462 init cache_photo without model_param we have 1 photo to upload uploaded to storage server : ovh folder_temporaire : temp/1740071663_2852616 we have uploaded 1 photos in the portfolio 4869462 time of upload the photos Elapsed time : 0.5318655967712402 we have finished the crop for the class : kraft 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 [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 26 /1338642919Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642920Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642921Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642922Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642923Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642924Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642925Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642926Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642927Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642929Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642930Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642932Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642939Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642941Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642942Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642943Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642944Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642945Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642946Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642947Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642948Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642950Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642953Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642955Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642956Didn't retrieve data .Didn't retrieve data .Didn't retrieve data . /1338642964Didn'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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 88 time used for this insertion : 0.0270082950592041 save_final save missing photos in datou_result : time spend for datou_step_exec : 36.52026391029358 time spend to save output : 0.027989625930786133 total time spend for step 6 : 36.548253536224365 step7:ventilate_hashtags_in_portfolio Thu Feb 20 18:14:24 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! 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 : 20681346 get user id for portfolio 20681346 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`=20681346 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('plastique','Teint_Dans_La_Masse','autre_refus','Carton_gris','flou','metal','cartonnette','mal_croppe','Carton_brun','kraft','environnement','papier')) AND mptpi.`min_score`=0.5 To do To do SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20681346 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('plastique','Teint_Dans_La_Masse','autre_refus','Carton_gris','flou','metal','cartonnette','mal_croppe','Carton_brun','kraft','environnement','papier')) 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`=20681346 AND mptpi.`type`=3726 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('plastique','Teint_Dans_La_Masse','autre_refus','Carton_gris','flou','metal','cartonnette','mal_croppe','Carton_brun','kraft','environnement','papier')) AND mptpi.`min_score`=0.5 To do lien utilise dans velours : https://www.fotonower.com/velours/20685406,20685407,20685408,20685409,20685410,20685411,20685412,20685413,20685414,20685415,20685416,20685417?tags=plastique,Teint_Dans_La_Masse,autre_refus,Carton_gris,flou,metal,cartonnette,mal_croppe,Carton_brun,kraft,environnement,papier Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : ventilate_hashtags_in_portfolio we use saveGeneral [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 1 /20681346. 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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.02233600616455078 save_final save missing photos in datou_result : time spend for datou_step_exec : 1.9555888175964355 time spend to save output : 0.023049592971801758 total time spend for step 7 : 1.9786384105682373 step8:final Thu Feb 20 18:14:26 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 : {1338538264: ('0.7067119635407394',), 1338538263: ('0.7067119635407394',), 1338528173: ('0.7067119635407394',), 1338528169: ('0.7067119635407394',), 1338528165: ('0.7067119635407394',), 1338528160: ('0.7067119635407394',), 1338528156: ('0.7067119635407394',), 1338527564: ('0.7067119635407394',), 1338527556: ('0.7067119635407394',), 1338527541: ('0.7067119635407394',)} new output for save of step final : {1338538264: ('0.7067119635407394',), 1338538263: ('0.7067119635407394',), 1338528173: ('0.7067119635407394',), 1338528169: ('0.7067119635407394',), 1338528165: ('0.7067119635407394',), 1338528160: ('0.7067119635407394',), 1338528156: ('0.7067119635407394',), 1338527564: ('0.7067119635407394',), 1338527556: ('0.7067119635407394',), 1338527541: ('0.7067119635407394',)} [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 10 /1338538264.Didn't retrieve data . /1338538263.Didn't retrieve data . /1338528173.Didn't retrieve data . /1338528169.Didn't retrieve data . /1338528165.Didn't retrieve data . /1338528160.Didn't retrieve data . /1338528156.Didn't retrieve data . /1338527564.Didn't retrieve data . /1338527556.Didn't retrieve data . /1338527541.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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 30 time used for this insertion : 0.015856027603149414 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.1136469841003418 time spend to save output : 0.016239643096923828 total time spend for step 8 : 0.12988662719726562 step9:velours_tree Thu Feb 20 18:14:26 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.056719064712524414 time spend to save output : 4.8160552978515625e-05 total time spend for step 9 : 0.05676722526550293 step10:send_mail_cod Thu Feb 20 18:14:26 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_P20681346_20-02-2025_18_14_26.pdf 20685406 change filename to text .change filename to text .imagette206854061740071666 20685408 change filename to text .change filename to text .change filename to text .imagette206854081740071667 20685410 imagette206854101740071667 20685411 imagette206854111740071667 20685412 change filename to text .imagette206854121740071667 20685413 imagette206854131740071667 20685415 change filename to text .imagette206854151740071667 20685407 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette206854071740071667 20685409 change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .change filename to text .imagette206854091740071668 20685414 change filename to text .imagette206854141740071668 SELECT h.hashtag,pcr.value FROM MTRUser.portfolio_carac_ratio pcr, MTRBack.hashtags h where pcr.portfolio_id=20681346 and hashtag_type = 3726 and pcr.hashtag_id = h.hashtag_id; velour_link : https://www.fotonower.com/velours/20685406,20685407,20685408,20685409,20685410,20685411,20685412,20685413,20685414,20685415,20685416,20685417?tags=plastique,Teint_Dans_La_Masse,autre_refus,Carton_gris,flou,metal,cartonnette,mal_croppe,Carton_brun,kraft,environnement,papier your option no_mail is active, we will not send the real mail to your client args[1338538264] : ('0.7067119635407394',) no score found for photo 1338538264 We are sending mail with results at report@fotonower.com args[1338538263] : ('0.7067119635407394',) no score found for photo 1338538263 We are sending mail with results at report@fotonower.com args[1338528173] : ('0.7067119635407394',) no score found for photo 1338528173 We are sending mail with results at report@fotonower.com args[1338528169] : ('0.7067119635407394',) no score found for photo 1338528169 We are sending mail with results at report@fotonower.com args[1338528165] : ('0.7067119635407394',) no score found for photo 1338528165 We are sending mail with results at report@fotonower.com args[1338528160] : ('0.7067119635407394',) no score found for photo 1338528160 We are sending mail with results at report@fotonower.com args[1338528156] : ('0.7067119635407394',) no score found for photo 1338528156 We are sending mail with results at report@fotonower.com args[1338527564] : ('0.7067119635407394',) no score found for photo 1338527564 We are sending mail with results at report@fotonower.com args[1338527556] : ('0.7067119635407394',) no score found for photo 1338527556 We are sending mail with results at report@fotonower.com args[1338527541] : ('0.7067119635407394',) no score found for photo 1338527541 We are sending mail with results at report@fotonower.com refus_total : 0.7067119635407394 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=20681346 AND mpp.hide_status=0 ORDER BY mpp.order LIMIT 0, 1000 SELECT photo_id, url FROM MTRBack.photos ph WHERE photo_id IN (1338527463,1338528173,1338528169,1338528165,1338528160,1338528156,1338527541,1338527539,1338527525,1338527523,1338527513,1338527510,1338527508,1338527507,1338527503,1338527490,1338527488,1338527486,1338527484,1338527482) Found this number of photos: 20 begin to download photo : 1338527463 begin to download photo : 1338528156 begin to download photo : 1338527513 begin to download photo : 1338527490 download finish for photo 1338527463 begin to download photo : 1338528173 download finish for photo 1338527513 begin to download photo : 1338527510 download finish for photo 1338527490 begin to download photo : 1338527488 download finish for photo 1338528156 begin to download photo : 1338527541 download finish for photo 1338527510 begin to download photo : 1338527508 download finish for photo 1338528173 begin to download photo : 1338528169 download finish for photo 1338527488 begin to download photo : 1338527486 download finish for photo 1338527541 begin to download photo : 1338527539 download finish for photo 1338528169 begin to download photo : 1338528165 download finish for photo 1338527508 begin to download photo : 1338527507 download finish for photo 1338527539 begin to download photo : 1338527525 download finish for photo 1338527486 begin to download photo : 1338527484 download finish for photo 1338528165 begin to download photo : 1338528160 download finish for photo 1338527507 begin to download photo : 1338527503 download finish for photo 1338527525 begin to download photo : 1338527523 download finish for photo 1338528160 download finish for photo 1338527503 download finish for photo 1338527523 download finish for photo 1338527484 begin to download photo : 1338527482 download finish for photo 1338527482 start upload file to ovh https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681346_20-02-2025_18_14_26.pdf results_Auto_P20681346_20-02-2025_18_14_26.pdf uploaded to url https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681346_20-02-2025_18_14_26.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','20681346','results_Auto_P20681346_20-02-2025_18_14_26.pdf','https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681346_20-02-2025_18_14_26.pdf','pdf','','0.72','0.7067119635407394') Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : send_mail_cod we use saveGeneral [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] 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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 10 time used for this insertion : 0.013770341873168945 save_final save missing photos in datou_result : time spend for datou_step_exec : 6.827513694763184 time spend to save output : 0.014042854309082031 total time spend for step 10 : 6.841556549072266 step11:split_time_score Thu Feb 20 18:14:33 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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'}] (('11', 27),) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {} 19022025 20681346 Nombre de photos uploadées : 27 / 23040 (0%) 19022025 20681346 Nombre de photos taguées (types de déchets): 0 / 27 (0%) 19022025 20681346 Nombre de photos taguées (volume) : 0 / 27 (0%) elapsed_time : load_data_split_time_score 8.106231689453125e-06 elapsed_time : order_list_meta_photo_and_scores 7.62939453125e-06 ??????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.003858804702758789 elapsed_time : insert_dashboard_record_day_entry 0.025829792022705078 We will return after consolidate but for now we need the day, how to get it, for now depending on the previous heavy steps Qualite : 0.14421148009919454 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669340 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20669340 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669341 order by id desc limit 1 Qualite : 0.1391260793958787 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669342 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20669342 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669343 order by id desc limit 1 Qualite : 0.1339949420161583 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669344 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20669344 AND mptpi.`type`=3594 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669345 order by id desc limit 1 Qualite : 0.12545851866981367 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669346 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20669346 AND mptpi.`type`=3594 To do Qualite : 0.11530906749273781 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20669347 order by id desc limit 1 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 7928 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 8092 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 8092 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7933 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 7935 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 7934 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 7934 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! WARNING : number of outputs for step 13649 velours_tree is not consistent : 2 used against 1 in the step definition ! Step 9283 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 7935 doesn't seem to be define in the database( WARNING : type of input 3 of step 7934 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 1 of step 7935 doesn't seem to be define in the database( WARNING : output 1 of step 7933 have datatype=7 whereas input 1 of step 7935 have datatype=None WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 2 of step 8092 doesn't seem to be define in the database( WARNING : type of output 3 of step 8092 doesn't seem to be define in the database( WARNING : type of input 1 of step 7933 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10917 doesn't seem to be define in the database( WARNING : type of output 2 of step 7928 doesn't seem to be define in the database( WARNING : type of input 1 of step 10918 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 7935 have datatype=10 whereas input 3 of step 10916 have datatype=6 WARNING : output 0 of step 7935 have datatype=10 whereas input 0 of step 13649 have datatype=18 WARNING : type of output 1 of step 13649 doesn't seem to be define in the database( WARNING : type of input 5 of step 10916 doesn't seem to be define in the database( DataTypes for each output/input checked ! TODO Duplicate data, are they consistent 3 ? Duplicate data, are they consistent 4 ? SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=20669347 AND mptpi.`type`=3594 To do Qualite : 0.054274749764895006 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20671915_19-02-2025_13_01_29.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20671915 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20671915 AND mptpi.`type`=4207 To do Qualite : 0.09720824633177619 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20671916 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20671916 AND mptpi.`type`=4207 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681341 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681342 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681343 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681344 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681345 order by id desc limit 1 Qualite : 0.7067119635407394 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681346_20-02-2025_18_14_26.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681346 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`=20681346 AND mptpi.`type`=3726 To do Qualite : 0.16030533271441313 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681347_20-02-2025_17_59_31.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681347 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 ! 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 11560 mask_detect is not consistent : 3 used against 2 in the step definition ! Step 11567 mask_detect have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11567 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11563 crop_condition is not consistent : 4 used against 2 in the step definition ! Step 11563 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11564 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 11564 merge_mask_thcl_custom is not consistent : 4 used against 2 in the step definition ! WARNING : number of inputs for step 11565 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11565 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11573 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11573 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of inputs for step 11568 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11568 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11566 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11566 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! WARNING : type of output 2 of step 11560 doesn't seem to be define in the database( WARNING : type of input 2 of step 11563 doesn't seem to be define in the database( WARNING : output 1 of step 11560 have datatype=2 whereas input 1 of step 11564 have datatype=7 WARNING : type of output 2 of step 11564 doesn't seem to be define in the database( WARNING : type of input 1 of step 11565 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11567 doesn't seem to be define in the database( WARNING : type of input 3 of step 11563 doesn't seem to be define in the database( WARNING : type of output 3 of step 11564 doesn't seem to be define in the database( WARNING : type of input 1 of step 11568 doesn't seem to be define in the database( WARNING : type of output 1 of step 11568 doesn't seem to be define in the database( WARNING : type of input 3 of step 11566 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of input 2 of step 11563 doesn't seem to be define in the database( WARNING : output 0 of step 11570 have datatype=6 whereas input 2 of step 11563 have datatype=None WARNING : type of input 2 of step 11563 doesn't seem to be define in the database( WARNING : output 0 of step 11569 have datatype=6 whereas input 2 of step 11563 have datatype=None WARNING : type of output 2 of step 11560 doesn't seem to be define in the database( WARNING : type of input 1 of step 11570 doesn't seem to be define in the database( WARNING : type of output 2 of step 11560 doesn't seem to be define in the database( WARNING : type of input 1 of step 11569 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11568 have datatype=10 whereas input 3 of step 11571 have datatype=6 WARNING : type of input 2 of step 11573 doesn't seem to be define in the database( WARNING : output 1 of step 11565 have datatype=7 whereas input 2 of step 11573 have datatype=None WARNING : type of output 3 of step 11573 doesn't seem to be define in the database( WARNING : type of input 3 of step 11568 doesn't seem to be define in the database( WARNING : output 0 of step 11568 have datatype=10 whereas input 0 of step 11587 have datatype=18 WARNING : type of input 5 of step 11571 doesn't seem to be define in the database( WARNING : output 0 of step 11587 have datatype=11 whereas input 5 of step 11571 have datatype=None WARNING : output 0 of step 11564 have datatype=1 whereas input 0 of step 11565 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`=20681347 AND mptpi.`type`=3327 To do find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20673480_20-02-2025_14_07_22.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20673480 order by id desc limit 1 Qualite : 0.0320981981646938 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20673481_19-02-2025_13_36_24.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20673481 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20673481 AND mptpi.`type`=4207 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681348 order by id desc limit 1 Qualite : 0.7356852245090688 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681349_20-02-2025_17_07_51.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681349 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`=20681349 AND mptpi.`type`=3726 To do find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681350 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681351 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681352 order by id desc limit 1 find url: select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681353 order by id desc limit 1 Qualite : 0.027948317779609787 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681354_20-02-2025_17_33_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681354 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20681354 AND mptpi.`type`=4207 To do Qualite : 0.3549736350297101 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681355_20-02-2025_17_01_23.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681355 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`=20681355 AND mptpi.`type`=3726 To do Qualite : 0.013757769850653528 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681356_20-02-2025_17_10_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681356 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20681356 AND mptpi.`type`=4207 To do Qualite : 0.012098030396853662 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681357_20-02-2025_17_38_19.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681357 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20681357 AND mptpi.`type`=4207 To do Qualite : 0.7159814219457672 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681358_20-02-2025_18_08_45.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681358 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`=20681358 AND mptpi.`type`=3726 To do Qualite : 0.006334283938265225 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681359_20-02-2025_16_46_17.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681359 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 ! 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 11500 mask_detect is not consistent : 3 used against 2 in the step definition ! WARNING : number of outputs for step 11508 brightness is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11509 blur_detection is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11504 crop_condition is not consistent : 3 used against 2 in the step definition ! Step 11504 crop_condition have less outputs used (2) than in the step definition (3) : some outputs may be not used ! Step 11507 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 11507 merge_mask_thcl_custom is not consistent : 3 used against 2 in the step definition ! WARNING : number of inputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11501 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! Step 11576 crop_condition have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! WARNING : number of outputs for step 11576 crop_condition is not consistent : 4 used against 3 in the step definition ! WARNING : number of outputs for step 11503 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11502 final have less inputs used (2) than in the step definition (3) : maybe we manage optionnal inputs ! Step 11502 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11511 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11503 doesn't seem to be define in the database( WARNING : type of input 3 of step 11502 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 2 of step 11500 doesn't seem to be define in the database( WARNING : type of input 2 of step 11504 doesn't seem to be define in the database( WARNING : output 1 of step 11500 have datatype=2 whereas input 1 of step 11507 have datatype=7 WARNING : type of output 2 of step 11507 doesn't seem to be define in the database( WARNING : type of input 1 of step 11501 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11503 have datatype=10 whereas input 3 of step 11510 have datatype=6 WARNING : type of input 2 of step 11576 doesn't seem to be define in the database( WARNING : output 1 of step 11501 have datatype=7 whereas input 2 of step 11576 have datatype=None WARNING : type of output 3 of step 11576 doesn't seem to be define in the database( WARNING : type of input 1 of step 11503 doesn't seem to be define in the database( WARNING : output 0 of step 11503 have datatype=10 whereas input 0 of step 11582 have datatype=18 WARNING : type of input 5 of step 11510 doesn't seem to be define in the database( WARNING : output 0 of step 11582 have datatype=11 whereas input 5 of step 11510 have datatype=None WARNING : type of output 1 of step 11508 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : type of output 1 of step 11509 doesn't seem to be define in the database( WARNING : type of input 3 of step 11504 doesn't seem to be define in the database( WARNING : output 0 of step 11507 have datatype=1 whereas input 0 of step 11501 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`=20681359 AND mptpi.`type`=4207 To do Qualite : 0.7151161215199712 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681360_20-02-2025_16_33_19.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681360 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`=20681360 AND mptpi.`type`=3726 To do Qualite : 0.27799727563338583 find url: https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P20681361_20-02-2025_16_57_21.pdf select completion_json, dashboard_run_id from MTRPhoto.dashboard_results where mtr_portfolio_id = 20681361 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`=20681361 AND mptpi.`type`=3726 To do NUMBER BATCH : 0 # DISPLAY ALL COLLECTED DATA : {'19022025': {'nb_upload': 27, '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 [1338538264, 1338538263, 1338528173, 1338528169, 1338528165, 1338528160, 1338528156, 1338527564, 1338527556, 1338527541] Looping around the photos to save general results len do output : 1 /20681346Didn'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, '2600137') ('3459', '20681346', '1338538264', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338538263', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528173', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528169', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528165', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528160', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338528156', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527564', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527556', None, None, None, None, None, '2600137') ('3459', None, None, None, None, None, None, None, '2600137') ('3459', '20681346', '1338527541', None, None, None, None, None, '2600137') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 11 time used for this insertion : 0.016978979110717773 save_final save missing photos in datou_result : time spend for datou_step_exec : 17.031956911087036 time spend to save output : 0.017300128936767578 total time spend for step 11 : 17.049257040023804 caffe_path_current : About to save ! 2 After save, about to update current ! update_current_state 128.40user 220.71system 6:27.01elapsed 90%CPU (0avgtext+0avgdata 4014780maxresident)k 607312inputs+113680outputs (9868major+11675033minor)pagefaults 0swaps