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 : 3955366 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 : ['3681585'] with mtr_portfolio_ids : ['26665669'] and first list_photo_ids : [] new path : /proc/3955366/ 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.04467439651489258 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:split_time_score Tue Sep 9 01:28:28 2025 VR 17-11-17 : now, only for linear exec dependencies tree, some output goes to fill the input of the next VR 22-3-18 : now we test the dependencies tree, but keep two separate code for datou_prepare_output_input until the code is correctly tested, clean and works in both case VR 22-3-18 : but we use the first code for the first step id = -1, build in the code of datou_exec VR 22-3-18 : we should manage here the case when we are at the first step instead of building this step before datou_exec 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', 260), ('01', 3)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 255} 09092025 26665669 Nombre de photos uploadées : 263 / 23040 (1%) 09092025 26665669 Nombre de photos taguées (types de déchets): 255 / 263 (96%) 09092025 26665669 Nombre de photos taguées (volume) : 255 / 263 (96%) elapsed_time : load_data_split_time_score 1.9073486328125e-06 elapsed_time : order_list_meta_photo_and_scores 0.00011563301086425781 ???????? elapsed_time : fill_and_build_computed_from_old_data 0.01224970817565918 Catched exception ! Connect or reconnect ! Catched exception ! Connect or reconnect ! elapsed_time : insert_dashboard_record_day_entry 0.2602198123931885 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 elapsed_time : list_photo_by_hashtags 0.01446390151977539 photos_removed : len 0 elapsed_time : load_duplicate_info 0.011432886123657227 ***** BEGIN SPLIT TIME ***** ```````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````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, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199], [200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 253, 254, 255, 256, 257, 258, 259], [260, 261], [262]] forced_hashtag: JRM force hashtag to JRM elapsed_time : SPLIT_TIME 0.01453542709350586 ***** END SPLIT TIME ***** NUMBER BATCH : 6 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 result_one_balle_Type_JRM:{'day': '09092025', 'map_nb_amount': {0: 7, 1: 52, 2: 13, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 869.9999680519104, 'nb_balles_papier': 0.0007300000000000013, 'begin_time_port': 'image_09092025_00_00_14_010167m0.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.0007300000000000013 We reject this portfolio because of the condition_save_data : 2025-09-09 00:00:14.010167 ERROR missing amount info result_one_balle_Type_JRM:{'day': '09092025', 'map_nb_amount': {0: 6, 1: 32, 2: 5, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 589.9999849796295, 'nb_balles_papier': 0.0004400000000000005, 'begin_time_port': 'image_09092025_00_15_04_010152m0.jpg 1e-05 for time 1, id_amount 3 this amount prod time diff : 1e-05'} Production hashtag (incorrect ponderation at 20-10-18) : 0.0004400000000000005 We reject this portfolio because of the condition_save_data : 2025-09-09 00:15:04.010152 result_one_balle_Type_JRM:{'day': '09092025', 'map_nb_amount': {0: 9, 1: 52, 2: 16, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 829.9999821186066, 'nb_balles_papier': 0.0007800000000000014, 'begin_time_port': 'image_09092025_00_31_04_010151m0.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.0007800000000000014 Catched exception ! Connect or reconnect ! ERROR in datou_step_exec, will save and exit ! (1213, 'Deadlock found when trying to get lock; try restarting transaction') File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2329, in datou_exec output = datou_step_exec(sNext, args, cache, context, map_info, verbose, mtr_user_id) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2513, in datou_step_exec return lib_process.datou_step_split_time_score(param, json_param, args, context, map_info, verbose, mtr_user_id) File "/home/admin/workarea/git/Velours/python/mtr/datou/lib_step_exec/lib_step_process.py", line 2295, in datou_step_split_time_score one_result = split_port_in_batch_balle( File "/home/admin/workarea/git/Velours/python/misc/split_time_score.py", line 816, in split_port_in_batch_balle map_amount_per_hashtag, dict_nb_balles, list_of_portfolios_to_create = count_nb_balles(ds, File "/home/admin/workarea/git/Velours/python/mtr/math_fotonower/timeseries/lib_split_time_score.py", line 2783, in count_nb_balles context.pq.update_text_in_photos(list_photo_id_text, verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/portfolio_queries.py", line 366, in update_text_in_photos nb1 = self.gq.insert_many(query1, list_photo_id_text) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 167, in insert_many cursor.executemany(query, args[:limit]) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 241, in executemany return self._do_execute_many( File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 275, in _do_execute_many rows += self.execute(sql + postfix) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 179, in execute res = self._query(mogrified_query) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 330, in _query db.query(q) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 280, in query _mysql.connection.query(self, query) [1382706014, 1382705598, 1382704312, 1382702246, 1382702241, 1382702237, 1382702230, 1382702219, 1382702218, 1382702195, 1382702192, 1382702189, 1382702187, 1382702185, 1382702165, 1382702162, 1382702160, 1382702156, 1382702126, 1382702123, 1382702119, 1382702115, 1382702101, 1382702097, 1382702092, 1382702090, 1382702087, 1382702080, 1382702076, 1382702072, 1382702067, 1382702062, 1382702035, 1382702013, 1382702007, 1382702005, 1382702004, 1382702002, 1382701975, 1382701971, 1382701966, 1382701962, 1382701960, 1382701933, 1382701929, 1382701925, 1382701922, 1382701908, 1382701856, 1382701854, 1382701841, 1382701835, 1382701832, 1382701830, 1382701828, 1382701808, 1382701805, 1382701802, 1382701798, 1382701794, 1382701791, 1382701784, 1382701777, 1382701773, 1382701769, 1382701762, 1382701758, 1382701755, 1382701751, 1382701749, 1382701747, 1382701744, 1382701741, 1382701734, 1382701720, 1382701718, 1382701716, 1382701714, 1382701710, 1382701707, 1382701696, 1382701694, 1382701692, 1382701690, 1382701689, 1382701685, 1382701680, 1382701677, 1382701673, 1382701668, 1382701663, 1382701651, 1382701645, 1382701643, 1382701642, 1382701641, 1382701631, 1382701626, 1382701623, 1382701619] begin to insert list_values into mtr_datou_result : length of list_values in save_final : 100 time used for this insertion : 1.7678370475769043 save_final ERROR in last step split_time_score, (1213, 'Deadlock found when trying to get lock; try restarting transaction') time spend for datou_step_exec : 0.6723132133483887 time spend to save output : 1.7763283252716064 total time spend for step 0 : 2.448641538619995 need to delete datou_research and reload, so keep current state 1 caffe_path_current : About to save ! 2 After save, about to update current ! 1.14user 0.45system 0:06.24elapsed 25%CPU (0avgtext+0avgdata 104324maxresident)k 1496inputs+32outputs (0major+49515minor)pagefaults 0swaps