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 : 1882720 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 we have a portfolio with more photos than limit : 2346>1000 please execute split_portfolio.py -i 24862863 -l 1000 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 4876, datou_cur_ids : ['3275237'] with mtr_portfolio_ids : ['24862863'] and first list_photo_ids : [] new path : /proc/1882720/ 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.027865171432495117 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:split_time_score Sat Jul 12 07:40:30 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', 401), ('01', 382), ('02', 390), ('03', 406), ('04', 389), ('05', 378)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 2346} 12072025 24862863 Nombre de photos uploadées : 132 / 23040 (0%) 12072025 24862863 Nombre de photos taguées (types de déchets): 2346 / 132 (1777%) 12072025 24862863 Nombre de photos taguées (volume) : 2346 / 132 (1777%) elapsed_time : load_data_split_time_score 3.337860107421875e-06 elapsed_time : order_list_meta_photo_and_scores 0.0009534358978271484 elapsed_time : fill_and_build_computed_from_old_data 0.04941439628601074 elapsed_time : insert_dashboard_record_day_entry 0.030414819717407227 Creating list_photo_by_hashtags elapsed_time : list_photo_by_hashtags 0.009712457656860352 photos_removed : len 0 elapsed_time : load_duplicate_info 0.011917591094970703 ***** 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]] forced_hashtag: JRM force hashtag to JRM elapsed_time : SPLIT_TIME 0.007458209991455078 ***** END SPLIT TIME ***** NUMBER BATCH : 2 list_ponderation used : [1e-05, 1e-05, 1e-05, 1e-05, 1e-05] , list_hashtag_class_create_as_list : ['jrm'] result_one_balle_Type_JRM:{'day': '12072025', 'map_nb_amount': {0: 0, 1: 42, 2: 0, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 349.9999701976776, 'nb_balles_papier': 0.00042000000000000045, 'begin_time_port': 'image_12072025_05_39_04_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.00042000000000000045 We reject this portfolio because of the condition_save_data : 2025-07-12 05:39:04.010167 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 363, 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 157, 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) [1371798316, 1371798290, 1371798265, 1371798241, 1371798234, 1371798217, 1371797594, 1371797548, 1371797502, 1371797457, 1371797406, 1371797358, 1371797242, 1371797216, 1371797189, 1371797163, 1371797114, 1371797111, 1371797056, 1371797055, 1371797054, 1371797053, 1371797052, 1371797050, 1371797030, 1371797029, 1371797028, 1371797027, 1371797026, 1371797024, 1371797018, 1371796995, 1371796993, 1371796983, 1371796980, 1371796974, 1371796924, 1371796923, 1371796921, 1371796918, 1371796917, 1371796915, 1371796878, 1371796876, 1371796875, 1371796873, 1371796872, 1371796869, 1371796859, 1371796857, 1371796854, 1371796851, 1371796849, 1371796847, 1371796814, 1371796813, 1371796812, 1371796811, 1371796807, 1371796798, 1371796781, 1371796780, 1371796778, 1371796776, 1371796774, 1371796771, 1371796764, 1371796763, 1371796756, 1371796754, 1371796753, 1371796750, 1371796717, 1371796715, 1371796713, 1371796711, 1371796710, 1371796709, 1371796704, 1371796702, 1371796701, 1371796700, 1371796698, 1371796697, 1371796694, 1371796690, 1371796686, 1371796684, 1371796683, 1371796681, 1371796646, 1371796645, 1371796642, 1371796640, 1371796637, 1371796635, 1371796611, 1371796609, 1371796607, 1371796606] begin to insert list_values into mtr_datou_result : length of list_values in save_final : 100 time used for this insertion : 1.0533864498138428 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.5375661849975586 time spend to save output : 1.0625553131103516 total time spend for step 0 : 1.6001214981079102 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.59user 0.37system 0:05.85elapsed 33%CPU (0avgtext+0avgdata 104524maxresident)k 1512inputs+16outputs (2major+59910minor)pagefaults 0swaps