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 : 444605
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 : 1130>1000
please execute split_portfolio.py -i 26665669 -l 1000
size over we load limit photo not treated
list_input_json: {}
Current got : datou_id : 4876, datou_cur_ids : ['3682900'] with mtr_portfolio_ids : ['26665669'] and first list_photo_ids : []
new path :  /proc/444605/
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.025533199310302734
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 07:00: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
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', 261), ('01', 118), ('02', 273), ('03', 289), ('04', 49), ('05', 138), ('06', 2))
ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 1017}
09092025 26665669 Nombre de photos uploadées : 141 / 23040 (0%)
09092025 26665669 Nombre de photos taguées (types de déchets): 1017 / 141 (721%)
09092025 26665669 Nombre de photos taguées (volume) : 1017 / 141 (721%)
 elapsed_time : load_data_split_time_score 2.86102294921875e-06
 elapsed_time : order_list_meta_photo_and_scores 0.0004019737243652344
????????? elapsed_time : fill_and_build_computed_from_old_data 0.010611772537231445
Catched exception !
Connect or reconnect !
Catched exception !
Connect or reconnect !
 elapsed_time : insert_dashboard_record_day_entry 0.22243428230285645

 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 


 elapsed_time : list_photo_by_hashtags 0.011864423751831055
  photos_removed : len 0
 elapsed_time : load_duplicate_info 0.012883901596069336
***** 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]]
forced_hashtag:  JRM
force hashtag to JRM
 elapsed_time : SPLIT_TIME 0.009800195693969727
***** END SPLIT TIME *****
 NUMBER BATCH : 7
 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
result_one_balle_Type_JRM:{'day': '09092025', 'map_nb_amount': {0: 7, 1: 21, 2: 3, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 659.9999978542328, 'nb_balles_papier': 0.00031000000000000016, 'begin_time_port': 'image_09092025_05_03_54_10138.jpg'}
 Production hashtag (incorrect ponderation at 20-10-18) : 0.00031000000000000016
We reject this portfolio because of the condition_save_data : 2025-09-09 05:03:54.010138
ERROR missing amount info
result_one_balle_Type_JRM:{'day': '09092025', 'map_nb_amount': {0: 11, 1: 59, 2: 6, 3: 0, 4: 0}, 'map_time_amount': {0: 0, 1: 0, 2: 0, 3: 0, 4: 0}, 'duration': 860.0000100135803, 'nb_balles_papier': 0.0007600000000000013, 'begin_time_port': 'image_09092025_05_15_35_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.0007600000000000013
We reject this portfolio because of the condition_save_data : 2025-09-09 05:15:35.010133
ERROR missing amount info
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)

[1382734544, 1382731938, 1382729309, 1382729164, 1382729036, 1382728967, 1382728964, 1382728916, 1382728873, 1382728870, 1382728855, 1382728852, 1382728848, 1382728836, 1382728829, 1382728822, 1382728817, 1382728809, 1382728806, 1382728801, 1382728798, 1382728788, 1382728785, 1382728783, 1382728781, 1382728779, 1382728759, 1382728755, 1382728751, 1382728745, 1382728723, 1382728717, 1382728712, 1382728708, 1382728703, 1382728699, 1382728677, 1382728674, 1382728670, 1382728666, 1382728663, 1382728626, 1382728622, 1382728614, 1382728610, 1382728606, 1382728602, 1382728586, 1382728582, 1382728578, 1382728573, 1382728569, 1382728566, 1382728555, 1382728551, 1382728543, 1382728533, 1382728520, 1382728518, 1382728516, 1382728514, 1382728510, 1382728508, 1382728496, 1382728492, 1382728487, 1382728482, 1382728478, 1382728426, 1382728420, 1382728416, 1382728409, 1382728396, 1382728393, 1382728388, 1382728382, 1382728380, 1382728371, 1382728351, 1382728347, 1382728345, 1382728342, 1382728341, 1382728338, 1382728320, 1382728317, 1382728314, 1382728294, 1382728289, 1382728284, 1382728279, 1382728274, 1382728270, 1382728260, 1382728256, 1382728251, 1382728246, 1382728244, 1382728238, 1382728209]


begin to insert list_values into mtr_datou_result : 
length of list_values in save_final : 100
time used for this insertion : 0.4587247371673584
 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.6372063159942627
time spend to save output : 0.46627306938171387
total time spend for step 0 : 1.1034793853759766
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.57user 0.74system 0:06.05elapsed 38%CPU (0avgtext+0avgdata 106288maxresident)k
1504inputs+24outputs (0major+49771minor)pagefaults 0swaps