python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4935' -s datou_current_4935 -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 : 2451790
load datou : 4935
# 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 
updating current state to 1
list_input_json: []
Current got : datou_id : 4935, datou_cur_ids : ['3673061'] with mtr_portfolio_ids : ['26598398'] and first list_photo_ids : []
new path :  /proc/2451790/
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 : merge_dashboard
over limit max, limiting to limit_max 100
list_input_json : []
origin
We have 1 , 
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.04213905334472656
About to test input to load 
Calling datou_exec

Inside datou_exec : verbose : 0
number of steps :  1
step1:merge_dashboard
Sat Sep  6 04:00:29 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
2022-04-13 10:29:59 0
TODO : Insert select and so on
TODO : Insert select and so on
to do
to do
to do
to do
to do
to do
to do
to do
to do
to do
to do
to do
TODO : Insert select and so on
Catched exception !
Connect or reconnect !
Catched exception !
Connect or reconnect !

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 00:01:24', '2025-09-06 00:13:24',
9, 26598571,
0.0, 3672628,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26598571_06-09-2025_00_18_59.pdf', 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26598572, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26598573, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26598574, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26598575, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26598576, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26598577, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26598578, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26598579, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26598580, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26598581, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26598582, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26598583, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 00:17:54', '2025-09-06 00:29:54',
10, 26598836,
0.0414243862550139, 3672652,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26598836_06-09-2025_00_32_59.pdf', 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26598837, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26598838, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26598839, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26598840, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26598841, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26598842, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26598843, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26598844, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26598845, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26598846, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26598847, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26598848, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 00:31:23', '2025-09-06 00:43:04',
10, 26598917,
0.061141312624146314, 3672677,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26598917_06-09-2025_00_47_00.pdf', 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26598918, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26598919, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26598920, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26598921, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26598922, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26598923, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26598924, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26598925, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26598926, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26598927, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26598928, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26598929, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 00:45:24', '2025-09-06 00:56:14',
9, 26599002,
0.023243641210010695, 3672704,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26599002_06-09-2025_01_32_59.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26599004, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26599005, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26599006, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26599007, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26599008, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26599009, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26599010, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26599011, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26599012, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26599013, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26599014, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26599015, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 02:15:04', '2025-09-06 02:28:54',
11, 26599699,
0.06066238791207766, 3672877,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26599699_06-09-2025_02_36_58.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 26599700, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26599701, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26599702, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26599703, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26599704, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26599705, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26599706, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26599707, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26599708, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26599709, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26599710, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26599711, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 03:00:14', '2025-09-06 03:11:55',
3, 26599985,
-1.0, -1,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26599985_06-09-2025_03_18_58.pdf', 'metal': {'hashtag': 'metal', 'sub_port_id': 26599986, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26599987, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26599988, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26599989, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26599990, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26599991, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26599992, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26599993, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26599994, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26599995, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26599996, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26599997, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 03:17:14', '2025-09-06 03:28:15',
8, 26600012,
0.08620990824263582, 3672985,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26600012_06-09-2025_03_32_58.pdf', 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26600013, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26600014, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26600015, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26600016, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26600017, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26600018, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26600019, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26600020, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26600021, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26600022, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26600023, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26600024, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 03:30:34', '2025-09-06 03:39:54',
10, 26600089,
0.11211162086863025, 3673009,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26600089_06-09-2025_03_46_58.pdf', 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26600090, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26600091, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26600092, 'pht': 3726}, 'papier': {'hashtag': 'papier', 'sub_port_id': 26600093, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26600094, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26600095, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26600096, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26600097, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26600098, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26600099, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26600100, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26600101, 'pht': 3726}}"
);

        INSERT INTO `MTRPhoto`.`dashboard_results`
(`dashboard_run_id`,
`hashtag`,
`date_debut`,
`date_fin`,
`nombre_balle`,
`mtr_portfolio_id`,
`qualite`,
`datou_result_id_qualite`,
`completion_percentage`,
`completion_json`)
VALUES
(2249693, '_______JRM',
'2025-09-06 03:45:15', '2025-09-06 03:54:14',
8, 26600170,
0.10158117282114304, 3673036,
'-1.0', "{'max_time_prod_two_photos': 0, 'url_report': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/results_Auto_P26600170_06-09-2025_03_56_59.pdf', 'papier': {'hashtag': 'papier', 'sub_port_id': 26600171, 'pht': 3726}, 'cartonnette': {'hashtag': 'cartonnette', 'sub_port_id': 26600172, 'pht': 3726}, 'Carton_gris': {'hashtag': 'Carton_gris', 'sub_port_id': 26600173, 'pht': 3726}, 'plastique': {'hashtag': 'plastique', 'sub_port_id': 26600174, 'pht': 3726}, 'flou': {'hashtag': 'flou', 'sub_port_id': 26600175, 'pht': 3726}, 'kraft': {'hashtag': 'kraft', 'sub_port_id': 26600176, 'pht': 3726}, 'metal': {'hashtag': 'metal', 'sub_port_id': 26600177, 'pht': 3726}, 'mal_croppe': {'hashtag': 'mal_croppe', 'sub_port_id': 26600178, 'pht': 3726}, 'Teint_Dans_La_Masse': {'hashtag': 'Teint_Dans_La_Masse', 'sub_port_id': 26600179, 'pht': 3726}, 'autre_refus': {'hashtag': 'autre_refus', 'sub_port_id': 26600180, 'pht': 3726}, 'Carton_brun': {'hashtag': 'Carton_brun', 'sub_port_id': 26600181, 'pht': 3726}, 'environnement': {'hashtag': 'environnement', 'sub_port_id': 26600182, 'pht': 3726}}"
);
Inside saveOutput : final : True verbose : 0
ouput is None
saving photo_ids in datou_result


begin to insert list_values into mtr_datou_result : 
length of list_values in save_final : 99
time used for this insertion : 2.002896308898926

time spend for datou_step_exec : 0.5842595100402832
time spend to save output : 2.0032904148101807
total time spend for step 1 : 2.587549924850464

caffe_path_current : 
About to save ! 2
After save, about to update current !
ret : 2
len(input) + len(total_photo_id_missing) : 1
 set_done_treatment 
1.31user 0.50system 0:07.29elapsed 24%CPU (0avgtext+0avgdata 100284maxresident)k
0inputs+32outputs (0major+48752minor)pagefaults 0swaps