python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4876' -s datou_current_4876 -M 0 -S 0 -U 95,95,120 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 4086693 load datou : 4876 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! 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 : None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? load thcls load pdts Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec no input labels no input values updating current state to 1 list_input_json: {} Current got : datou_id : 4876, datou_cur_ids : ['2700274'] with mtr_portfolio_ids : ['21820661'] and first list_photo_ids : [] new path : /proc/4086693/ 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) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! List Step Type Loaded in datou : split_time_score over limit max, limiting to limit_max 100 list_input_json : {} origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! we have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB time to download the photos : 0.05343770980834961 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:split_time_score Fri Mar 28 05:46:27 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec begin split time score 2022-04-13 10:29:59 0 TODO : Insert select and so on Begin split_port_in_batch_balle thcls : [{'id': 3379, 'mtr_user_id': 31, 'name': 'learn_classif_flux_maj_generique_effnet_v2_s_02062022', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': 'aluminium,ela,film_pedb,flux_dev,jrm,pcm,pcnc,pehd_pp,pet_clair,refus,tapis_vide', 'svm_portfolios_learning': '5515864,5515840,5515844,5515850,6244400,6237996,6237998,5515847,5515841,5515868,5515866', 'photo_hashtag_type': 4374, 'photo_desc_type': 5680, 'type_classification': 'tf_classification2', 'hashtag_id_list': '493546845,492741797,2107760237,2107760238,495916461,560181804,1284539308,2107760239,2107755846,538914404,2107748999'}] thcls : [{'id': 3513, 'mtr_user_id': 31, 'name': 'Rungis_amount_dechets_fall_2018_v2_tf', 'pb_hashtag_id': 0, 'live': b'\x00', 'list_hashtags': '05102018_Papier_non_papier_dense,05102018_Papier_non_papier_peu_dense,05102018_Papier_non_papier_presque_vide,05102018_Papier_non_papier_tres_dense,05102018_Papier_non_papier_tres_peu_dense', 'svm_portfolios_learning': '1108385,1108386,1108388,1108384,1108387', 'photo_hashtag_type': 4557, 'photo_desc_type': 5767, 'type_classification': 'tf_classification2', 'hashtag_id_list': '2107751013,2107751014,2107751015,2107751016,2107751017'}] (('00', 27), ('01', 22), ('02', 33), ('03', 15), ('04', 6), ('05', 173)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 146} 28032025 21820661 Nombre de photos uploadées : 183 / 23040 (0%) 28032025 21820661 Nombre de photos taguées (types de déchets): 146 / 183 (79%) 28032025 21820661 Nombre de photos taguées (volume) : 146 / 183 (79%) elapsed_time : load_data_split_time_score 2.6226043701171875e-06 elapsed_time : order_list_meta_photo_and_scores 7.510185241699219e-05 ????????????????????????????????????????????????????????????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.008227109909057617 elapsed_time : insert_dashboard_record_day_entry 0.021702289581298828 Creating list_photo_by_hashtags Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None Hashtag is None elapsed_time : list_photo_by_hashtags 0.007582426071166992 photos_removed : len 0 elapsed_time : load_duplicate_info 0.014717340469360352 ***** BEGIN SPLIT TIME ***** True 1743120000.0 `1743129803.010139 1743129000.0 `1743130643.010145 1743129900.0 `1743130703.009125 1743129900.0 `1743130774.010138 1743129900.0 `1743131024.010141 1743130800.0 `1743131644.010141 1743130800.0 `1743132194.01014 1743131700.0 `1743132744.010138 1743132600.0 `1743133294.010144 1743132600.0 `1743133844.010137 1743133500.0 `1743134414.0102 1743134400.0 `1743134465.010156 1743134400.0 `1743134474.009124 1743134400.0 `1743134535.010133 1743134400.0 `1743134644.010162 1743134400.0 `1743134654.010134 1743134400.0 `1743134714.010134 1743134400.0 `1743134965.010136 1743134400.0 `1743134984.009125 1743134400.0 `1743134994.010137 1743134400.0 `1743135025.010134 1743134400.0 `1743135045.010142 1743134400.0 `1743135064.01017 1743134400.0 `1743135074.010134 1743134400.0 `1743135084.010134 1743134400.0 `1743135095.010143 1743134400.0 `1743135105.010138 1743134400.0 `1743135115.010138 1743134400.0 `1743135124.009132 1743134400.0 `1743135134.010137 1743134400.0 `1743135144.010134 1743134400.0 `1743135164.010132 1743134400.0 `1743135175.010134 1743134400.0 `1743135185.010144 1743134400.0 `1743135194.009125 1743134400.0 `1743135204.010135 1743134400.0 `1743135214.010137 1743134400.0 `1743135224.010136 1743134400.0 `1743135234.010135 1743134400.0 `1743135245.010154 1743134400.0 `1743135255.01014 1743134400.0 `1743135264.009124 1743134400.0 `1743135274.010133 1743134400.0 `1743135315.010133 1743135300.0 `1743135335.010134 1743135300.0 `1743135344.009126 1743135300.0 `1743135354.010134 1743135300.0 `1743135364.010144 1743135300.0 `1743135374.010135 1743135300.0 `1743135384.010134 1743135300.0 `1743135395.010133 1743135300.0 `1743135405.010135 1743135300.0 `1743135414.009125 1743135300.0 `1743135424.010162 1743135300.0 `1743135434.010134 1743135300.0 `1743135444.010135 1743135300.0 `1743135454.010132 1743135300.0 `1743135475.010136 1743135300.0 `1743135485.010141 1743135300.0 `1743135494.009125 1743135300.0 `1743135504.010134 1743135300.0 `1743135514.010134 1743135300.0 `1743135524.010134 1743135300.0 `1743135534.010138 1743135300.0 `1743135545.010153 1743135300.0 `1743135555.010135 1743135300.0 `1743135564.009124 1743135300.0 `1743135574.010136 1743135300.0 `1743135584.010134 1743135300.0 `1743135594.010138 1743135300.0 `1743135604.010161 1743135300.0 `1743135615.010136 1743135300.0 `1743135654.010136 1743135300.0 `1743135664.010147 1743135300.0 `1743135674.010132 1743135300.0 `1743135685.010135 1743135300.0 `1743135695.010143 1743135300.0 `1743135704.009127 1743135300.0 `1743135714.010138 1743135300.0 `1743135724.010145 1743135300.0 `1743135734.010135 1743135300.0 `1743135744.010133 1743135300.0 `1743135775.010134 1743135300.0 `1743135784.00914 1743135300.0 `1743135794.010142 1743135300.0 `1743135804.010142 1743135300.0 `1743135814.010145 1743135300.0 `1743135824.010139 1743135300.0 `1743135835.010137 1743135300.0 `1743135845.010154 1743135300.0 `1743135854.009127 1743135300.0 `1743135864.010134 1743135300.0 `1743135874.010135 1743135300.0 `1743135905.010148 1743135300.0 `1743135915.010133 1743135300.0 `1743135924.009126 1743135300.0 `1743135934.010135 1743135300.0 `1743135944.010136 1743135300.0 `1743135954.010137 1743135300.0 `1743135964.010154 1743135300.0 `1743135975.010134 1743135300.0 `1743135985.010133 1743135300.0 `1743135995.010135 1743135300.0 `1743136004.009125 1743135300.0 `1743136014.010149 1743135300.0 `1743136055.010135 1743135300.0 `1743136065.010132 1743135300.0 `1743136074.009126 1743135300.0 `1743136084.010144 1743135300.0 `1743136094.010139 1743135300.0 `1743136104.010133 1743135300.0 `1743136114.010137 1743135300.0 `1743136125.010137 1743135300.0 `1743136135.010136 1743135300.0 `1743136144.009138 1743135300.0 `1743136154.010135 1743135300.0 `1743136195.010134 1743135300.0 `1743136205.010164 1743136200.0 `1743136214.009125 1743136200.0 `1743136224.010136 1743136200.0 `1743136235.010788 1743136200.0 `1743136244.009126 1743136200.0 `1743136254.010137 1743136200.0 `1743136264.010147 1743136200.0 `1743136274.01014 1743136200.0 `1743136284.010135 1743136200.0 `1743136295.010135 1743136200.0 `1743136305.010135 1743136200.0 `1743136334.010136 1743136200.0 `1743136344.010133 1743136200.0 `1743136354.010134 1743136200.0 `1743136365.010135 1743136200.0 `1743136375.01014 1743136200.0 `1743136384.009142 1743136200.0 `1743136394.010134 1743136200.0 `1743136404.010134 1743136200.0 `1743136414.010135 1743136200.0 `1743136424.010134 1743136200.0 `1743136435.010136 1743136200.0 `1743136464.009124 1743136200.0 `1743136474.010132 1743136200.0 `1743136484.010134 1743136200.0 `1743136494.010134 1743136200.0 `1743136504.010157 1743136200.0 `1743136515.010136 1743136200.0 `1743136525.010135 1743136200.0 `1743136534.009123 1743136200.0 `1743136544.010136 1743136200.0 `1743136554.010134 1743136200.0 `1743136564.010144 1743136200.0 `1743136595.010133 1743136200.0 `1743136605.010132 1743136200.0 `1743136614.009127 1743136200.0 `1743136624.010152 1743136200.0 `1743136644.010138 1743136200.0 `1743136665.010136 1743136200.0 `1743136675.010138 1743136200.0 `1743136684.009144 1743136200.0 `1743136694.010142 1743136200.0 `1743136704.010135 1743136200.0 `1743136714.010135 1743136200.0 `1743136724.010154 1743136200.0 `1743136764.010137 1743136200.0 `1743136774.010132 1743136200.0 `1743136784.010137 1743136200.0 `1743136794.010137 1743136200.0 `1743136805.010141 1743136200.0 `1743136815.010139 1743136200.0 `1743136824.009139 1743136200.0 `1743136834.010144 1743136200.0 `1743136844.010139 1743136200.0 `1743136854.010136 1743136200.0 `1743136885.010133 1743136200.0 `1743136894.00912 1743136200.0 `1743136904.010135 1743136200.0 `1743136914.010135 1743136200.0 `1743136924.010155 1743136200.0 `1743136934.010137 1743136200.0 `1743136955.010143 1743136200.0 `1743136965.010138 1743136200.0 `1743136974.009129 1743136200.0 `1743137014.010132 1743136200.0 `1743137025.010133 1743136200.0 list printed: [[0], [1, 2, 3], [4, 5], [6], [7, 8], [9], [10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42], [43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116], [117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182]] forced_hashtag: JRM force hashtag to JRM elapsed_time : SPLIT_TIME 0.00975799560546875 ***** END SPLIT TIME ***** NUMBER BATCH : 9 list_ponderation used : [1e-05, 1e-05, 1e-05, 1e-05, 1e-05] , list_hashtag_class_create_as_list : ['jrm'] ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info result_one_balle_Type_JRM:{'day': '28032025', 'map_nb_amount': {0: 2, 1: 17, 2: 2, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 859.9999330043793, 'nb_balles_papier': 0.00021, 'begin_time_port': 'image_28032025_05_00_14_10200.jpg'} Production hashtag (incorrect ponderation at 20-10-18) : 0.00021 ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info result_one_balle_Type_JRM:{'day': '28032025', 'map_nb_amount': {0: 3, 1: 44, 2: 5, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 880.0000009536743, 'nb_balles_papier': 0.0005200000000000007, 'begin_time_port': 'image_28032025_05_15_15_010133m0.jpg 1e-05 for time 1, id_amount 2 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 0.0005200000000000007 ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing amount info ERROR missing am