python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4255 ' -s datou_consolidate -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 : 3014068 load datou : 4255 # 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) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11644 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11645 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11642 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 11642 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11649 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11643 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11646 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 11647 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 11648 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 11650 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11644 have datatype=11 whereas input 0 of step 11642 have datatype=2 WARNING : type of output 1 of step 11645 doesn't seem to be define in the database( WARNING : type of input 3 of step 11643 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11645 doesn't seem to be define in the database( WARNING : type of input 1 of step 11642 doesn't seem to be define in the database( WARNING : output 0 of step 11649 have datatype=10 whereas input 3 of step 11648 have datatype=6 WARNING : type of input 1 of step 11649 doesn't seem to be define in the database( WARNING : output 1 of step 11642 have datatype=7 whereas input 1 of step 11649 have datatype=None WARNING : type of output 1 of step 11649 doesn't seem to be define in the database( WARNING : type of input 4 of step 11643 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11644 doesn't seem to be define in the database( WARNING : type of input 1 of step 11645 doesn't seem to be define in the database( DataTypes for each output/input checked ! 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 : id de la photo (peut être local ou global) was removed should we ? donnée sous forme de nombre was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? chemin de la photo was removed should we ? donnée sous forme de texte was removed should we ? [ (photo_id, photo_id_loc, hashtag_type, x0, x1, y0, y1, score), ...] was removed should we ? None was removed should we ? donnée sous forme de texte was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? id de la photo (peut être local ou global) was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? donnée sous forme de texte was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? donnée sous forme de texte was removed should we ? 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 : 4255, datou_cur_ids : ['4046779'] with mtr_portfolio_ids : ['27473895'] and first list_photo_ids : [] new path : /proc/3014068/ 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) All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! All sons are already in current list ! DONE and to test : checkNoCycle ! Here we check the consistency of inputs/outputs number between the given ones and the db ! eke 1-6-18 : checkConsistencyNbInputNbOutput should be processed after step reordering ! WARNING : number of outputs for step 11644 copy_chis is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11645 consolidate_hashtags_from_manual_portfolio is not consistent : 2 used against 1 in the step definition ! WARNING : number of inputs for step 11642 rle_unique_nms_with_priority is not consistent : 3 used against 1 in the step definition ! WARNING : number of outputs for step 11642 rle_unique_nms_with_priority is not consistent : 2 used against 1 in the step definition ! WARNING : number of outputs for step 11649 ventilate_hashtags_in_portfolio is not consistent : 2 used against 1 in the step definition ! Step 11643 final have less outputs used (1) than in the step definition (2) : some outputs may be not used ! Step 11646 blur_detection have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 11647 brightness have less inputs used (0) than in the step definition (1) : maybe we manage optionnal inputs ! Step 11648 send_mail_cod have less inputs used (4) than in the step definition (5) : maybe we manage optionnal inputs ! Step 11650 split_time_score have less inputs used (1) than in the step definition (2) : maybe we manage optionnal inputs ! Number of inputs / outputs for each step checked ! Here we check the consistency of outputs/inputs types during steps connections eke 1-6-18 : checkConsistencyTypeOutputInput should be processed after checkConsistencyNbInputNbOutput ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : output 0 of step 11644 have datatype=11 whereas input 0 of step 11642 have datatype=2 WARNING : type of output 1 of step 11645 doesn't seem to be define in the database( WARNING : type of input 3 of step 11643 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11645 doesn't seem to be define in the database( WARNING : type of input 1 of step 11642 doesn't seem to be define in the database( WARNING : output 0 of step 11649 have datatype=10 whereas input 3 of step 11648 have datatype=6 WARNING : type of input 1 of step 11649 doesn't seem to be define in the database( WARNING : output 1 of step 11642 have datatype=7 whereas input 1 of step 11649 have datatype=None WARNING : type of output 1 of step 11649 doesn't seem to be define in the database( WARNING : type of input 4 of step 11643 doesn't seem to be define in the database( We ignore checkConsistencyTypeOutputInput for datou_step final ! WARNING : type of output 1 of step 11644 doesn't seem to be define in the database( WARNING : type of input 1 of step 11645 doesn't seem to be define in the database( DataTypes for each output/input checked ! List Step Type Loaded in datou : copy_chis, consolidate_hashtags_from_manual_portfolio, rle_unique_nms_with_priority, ventilate_hashtags_in_portfolio, final, blur_detection, brightness, send_mail_cod, split_time_score over limit max, limiting to limit_max 100 list_input_json : {} origin We have 1 , BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 28 ; length of list_pids : 28 ; length of list_args : 28 time to download the photos : 6.759352922439575 About to test input to load we should then remove the video here, and this would fix the bug of datou_current ! Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 9 step1:copy_chis Fri Nov 14 12:00:36 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 step datou_step_copy_crop batch 1 Loaded 626 chid ids of type : 3327 batch 1 Loaded 260 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 197 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 237 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 233 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 290 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! batch 1 Loaded 154 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : copy_chis we use saveGeneral [1387545538, 1387545528, 1387545525, 1387545521, 1387545517, 1387545513, 1387545499, 1387545497, 1387545493, 1387545490, 1387545484, 1387545477, 1387545476, 1387545474, 1387545472, 1387545469, 1387545466, 1387545453, 1387545451, 1387545449, 1387545447, 1387545425, 1387545403, 1387545401, 1387545397, 1387545395, 1387545390, 1387545388] Looping around the photos to save general results len do output : 28 /1387545538Didn't retrieve data . /1387545528Didn't retrieve data . /1387545525Didn't retrieve data . /1387545521Didn't retrieve data . /1387545517Didn't retrieve data . /1387545513Didn't retrieve data . /1387545499Didn't retrieve data . /1387545497Didn't retrieve data . /1387545493Didn't retrieve data . /1387545490Didn't retrieve data . /1387545484Didn't retrieve data . /1387545477Didn't retrieve data . /1387545476Didn't retrieve data . /1387545474Didn't retrieve data . /1387545472Didn't retrieve data . /1387545469Didn't retrieve data . /1387545466Didn't retrieve data . /1387545453Didn't retrieve data . /1387545451Didn't retrieve data . /1387545449Didn't retrieve data . /1387545447Didn't retrieve data . /1387545425Didn't retrieve data . /1387545403Didn't retrieve data . /1387545401Didn't retrieve data . /1387545397Didn't retrieve data . /1387545395Didn't retrieve data . /1387545390Didn't retrieve data . /1387545388Didn't retrieve data . before output type Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545538', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545528', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545525', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545521', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545517', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545513', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545499', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545497', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545493', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545490', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545484', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545477', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545476', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545474', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545472', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545469', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545466', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545453', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545451', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545449', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545447', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545425', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545403', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545401', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545397', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545395', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545390', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545388', None, None, None, None, None, '4046779') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 56 time used for this insertion : 0.027647733688354492 save_final save missing photos in datou_result : time spend for datou_step_exec : 0.48239994049072266 time spend to save output : 0.028505325317382812 total time spend for step 1 : 0.5109052658081055 step2:consolidate_hashtags_from_manual_portfolio Fri Nov 14 12:00:37 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step consolidate_hashtags_from_manual_portfolio Iterating over portfolio : 27473895 SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473895 AND mptpi.`type`=3327 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','etiquette','bouchon','pet_fonce','pehd','barquette_avec_film','papier','carton','verre','metal','mal_croppe','flou','background','emr')) To do To do SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473895 AND mptpi.`type`=3327 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','etiquette','bouchon','pet_fonce','pehd','barquette_avec_film','papier','carton','verre','metal','mal_croppe','flou','background','emr')) To do SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473895 AND mptpi.`type`=3327 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','etiquette','bouchon','pet_fonce','pehd','barquette_avec_film','papier','carton','verre','metal','mal_croppe','flou','background','emr')) To do TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474643 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474644 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474645 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 931 chid ids of type : 3327 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474646 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474647 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474648 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474649 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474650 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 202 chid ids of type : 3327 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : Catched exception ! Connect or reconnect ! TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474651 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474652 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 55 chid ids of type : 3327 begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474655 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=27474656 AND mpp.hide_status=0 ORDER BY ph.size desc batch 1 Loaded 1371 chid ids of type : 3327 begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : begin to find the sub_photo_id : TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=28530579 AND mpp.hide_status=0 ORDER BY ph.size desc TODO : # On doit donc construire les chi a partir des informations dans les photos filles query : SELECT ph.photo_id FROM MTRBack.photos_view ph, MTRUser.mtr_portfolio_photos mpp WHERE ph.photo_id=mpp.mtr_photo_id AND mpp.mtr_portfolio_id=28530580 AND mpp.hide_status=0 ORDER BY ph.size desc To test ! Use context local managing function ! Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : consolidate_hashtags_from_manual_portfolio we use saveGeneral [1387545538, 1387545528, 1387545525, 1387545521, 1387545517, 1387545513, 1387545499, 1387545497, 1387545493, 1387545490, 1387545484, 1387545477, 1387545476, 1387545474, 1387545472, 1387545469, 1387545466, 1387545453, 1387545451, 1387545449, 1387545447, 1387545425, 1387545403, 1387545401, 1387545397, 1387545395, 1387545390, 1387545388] Looping around the photos to save general results len do output : 6 /Tassign value string error string indices must be integers invalid literal for int() with base 10: 'T' begin to insert list_values into mtr_datou_result : length of list_values in save_final : 28 time used for this insertion : 0.019936800003051758 save_final save missing photos in datou_result : time spend for datou_step_exec : 5.701971054077148 time spend to save output : 0.0202028751373291 total time spend for step 2 : 5.7221739292144775 step3:rle_unique_nms_with_priority Fri Nov 14 12:00:43 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed complete output_args for input 0 We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array We expect there is only one output and this part is used while all output are not tuple or array VR 22-3-18 : For now we do not clean correctly the datou structure Begin step rle-unique-nms batch 1 Loaded 553 chid ids of type : 3327 seulement à utiliser dans la step consolidation batch 1 Loaded 59 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03181576728820801 seulement à utiliser dans la step consolidation batch 1 Loaded 50 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030313730239868164 seulement à utiliser dans la step consolidation batch 1 Loaded 48 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03156280517578125 seulement à utiliser dans la step consolidation batch 1 Loaded 55 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030728578567504883 seulement à utiliser dans la step consolidation batch 1 Loaded 48 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.028657913208007812 seulement à utiliser dans la step consolidation batch 1 Loaded 48 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029352426528930664 seulement à utiliser dans la step consolidation batch 1 Loaded 47 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03045821189880371 seulement à utiliser dans la step consolidation batch 1 Loaded 46 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.031317710876464844 seulement à utiliser dans la step consolidation batch 1 Loaded 56 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030950546264648438 seulement à utiliser dans la step consolidation batch 1 Loaded 43 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030623435974121094 seulement à utiliser dans la step consolidation batch 1 Loaded 46 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02853560447692871 seulement à utiliser dans la step consolidation batch 1 Loaded 52 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03206491470336914 seulement à utiliser dans la step consolidation batch 1 Loaded 47 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03770160675048828 seulement à utiliser dans la step consolidation batch 1 Loaded 49 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02996826171875 seulement à utiliser dans la step consolidation batch 1 Loaded 43 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02967548370361328 seulement à utiliser dans la step consolidation batch 1 Loaded 46 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030863285064697266 seulement à utiliser dans la step consolidation batch 1 Loaded 42 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03072071075439453 seulement à utiliser dans la step consolidation batch 1 Loaded 47 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030344009399414062 seulement à utiliser dans la step consolidation batch 1 Loaded 55 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029821395874023438 seulement à utiliser dans la step consolidation batch 1 Loaded 46 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030648469924926758 seulement à utiliser dans la step consolidation batch 1 Loaded 43 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030031204223632812 seulement à utiliser dans la step consolidation batch 1 Loaded 46 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.029321908950805664 seulement à utiliser dans la step consolidation batch 1 Loaded 52 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030330657958984375 seulement à utiliser dans la step consolidation batch 1 Loaded 48 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.0290677547454834 seulement à utiliser dans la step consolidation batch 1 Loaded 55 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.02910161018371582 seulement à utiliser dans la step consolidation batch 1 Loaded 50 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.028882265090942383 seulement à utiliser dans la step consolidation batch 1 Loaded 49 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.030499935150146484 seulement à utiliser dans la step consolidation batch 1 Loaded 55 chid ids of type : 3327 Number RLEs to save : 0 TO DO : save crop sub photo not yet done ! save time : 0.03168153762817383 map_output_result : {1387545538: (0.0, 'Should be the crop_list due to order', 0.0), 1387545528: (0.0, 'Should be the crop_list due to order', 0.0), 1387545525: (0.0, 'Should be the crop_list due to order', 0.0), 1387545521: (0.0, 'Should be the crop_list due to order', 0.0), 1387545517: (0.0, 'Should be the crop_list due to order', 0.0), 1387545513: (0.0, 'Should be the crop_list due to order', 0.0), 1387545499: (0.0, 'Should be the crop_list due to order', 0.0), 1387545497: (0.0, 'Should be the crop_list due to order', 0.0), 1387545493: (0.0, 'Should be the crop_list due to order', 0.0), 1387545490: (0.0, 'Should be the crop_list due to order', 0.0), 1387545484: (0.0, 'Should be the crop_list due to order', 0.0), 1387545477: (0.0, 'Should be the crop_list due to order', 0.0), 1387545476: (0.0, 'Should be the crop_list due to order', 0.0), 1387545474: (0.0, 'Should be the crop_list due to order', 0.0), 1387545472: (0.0, 'Should be the crop_list due to order', 0.0), 1387545469: (0.0, 'Should be the crop_list due to order', 0.0), 1387545466: (0.0, 'Should be the crop_list due to order', 0.0), 1387545453: (0.0, 'Should be the crop_list due to order', 0.0), 1387545451: (0.0, 'Should be the crop_list due to order', 0.0), 1387545449: (0.0, 'Should be the crop_list due to order', 0.0), 1387545447: (0.0, 'Should be the crop_list due to order', 0.0), 1387545425: (0.0, 'Should be the crop_list due to order', 0.0), 1387545403: (0.0, 'Should be the crop_list due to order', 0.0), 1387545401: (0.0, 'Should be the crop_list due to order', 0.0), 1387545397: (0.0, 'Should be the crop_list due to order', 0.0), 1387545395: (0.0, 'Should be the crop_list due to order', 0.0), 1387545390: (0.0, 'Should be the crop_list due to order', 0.0), 1387545388: (0.0, 'Should be the crop_list due to order', 0.0)} End step rle-unique-nms Inside saveOutput : final : False verbose : 0 saveOutput not yet implemented for datou_step.type : rle_unique_nms_with_priority we use saveGeneral [1387545538, 1387545528, 1387545525, 1387545521, 1387545517, 1387545513, 1387545499, 1387545497, 1387545493, 1387545490, 1387545484, 1387545477, 1387545476, 1387545474, 1387545472, 1387545469, 1387545466, 1387545453, 1387545451, 1387545449, 1387545447, 1387545425, 1387545403, 1387545401, 1387545397, 1387545395, 1387545390, 1387545388] Looping around the photos to save general results len do output : 28 /1387545538.Didn't retrieve data . /1387545528.Didn't retrieve data . /1387545525.Didn't retrieve data . /1387545521.Didn't retrieve data . /1387545517.Didn't retrieve data . /1387545513.Didn't retrieve data . /1387545499.Didn't retrieve data . /1387545497.Didn't retrieve data . /1387545493.Didn't retrieve data . /1387545490.Didn't retrieve data . /1387545484.Didn't retrieve data . /1387545477.Didn't retrieve data . /1387545476.Didn't retrieve data . /1387545474.Didn't retrieve data . /1387545472.Didn't retrieve data . /1387545469.Didn't retrieve data . /1387545466.Didn't retrieve data . /1387545453.Didn't retrieve data . /1387545451.Didn't retrieve data . /1387545449.Didn't retrieve data . /1387545447.Didn't retrieve data . /1387545425.Didn't retrieve data . /1387545403.Didn't retrieve data . /1387545401.Didn't retrieve data . /1387545397.Didn't retrieve data . /1387545395.Didn't retrieve data . /1387545390.Didn't retrieve data . /1387545388.Didn't retrieve data . before output type Used above Here is an output not treated by saveGeneral : Managing all output in save final without adding information in the mtr_datou_result ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545538', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545528', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545525', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545521', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545517', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545513', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545499', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545497', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545493', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545490', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545484', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545477', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545476', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545474', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545472', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545469', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545466', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545453', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545451', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545449', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545447', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545425', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545403', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545401', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545397', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545395', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545390', None, None, None, None, None, '4046779') ('4255', None, None, None, None, None, None, None, '4046779') ('4255', '27473895', '1387545388', None, None, None, None, None, '4046779') begin to insert list_values into mtr_datou_result : length of list_values in save_final : 84 time used for this insertion : 0.016924381256103516 save_final save missing photos in datou_result : time spend for datou_step_exec : 3.6832971572875977 time spend to save output : 0.017887115478515625 total time spend for step 3 : 3.7011842727661133 step4:ventilate_hashtags_in_portfolio Fri Nov 14 12:00:46 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 Currently we do not manage missing dependencies information, that could maybe be correctly interpreted with default behavior Some of the step done at execution of the step could be done before when the tree of execution is build and the dependencies of different step analysed We should have FATAL ERROR but same_nb_input_output==True : this should be an optionnal input ! VR 22-3-18 : For now we do not clean correctly the datou structure beginning of datou step ventilate_hashtags_in_portfolio : To implement ! Iterating over portfolio : 27473895 get user id for portfolio 27473895 SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473895 AND mptpi.`type`=3327 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','etiquette','bouchon','pet_fonce','pehd','barquette_avec_film','papier','carton','verre','metal','mal_croppe','flou','emr')) AND mptpi.`min_score`=0.5 To do To do SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473895 AND mptpi.`type`=3327 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','etiquette','bouchon','pet_fonce','pehd','barquette_avec_film','papier','carton','verre','metal','mal_croppe','flou','emr')) AND mptpi.`min_score`=0.5 To do To do ! Use context local managing function ! SELECT mptpi.id, mptpi.mtr_portfolio_id_1, mptpi.mtr_portfolio_id_2, mptpi.type, mptpi.hashtag_id, mptpi.min_score, mptpi.mtr_user_id, mptpi.created_at, mptpi.updated_at, mptpi.last_updated_at_desc, mptpi.last_updated_at_asc, h.hashtag FROM MTRPhoto.mtr_port_to_port_ids mptpi, MTRBack.hashtags h WHERE h.hashtag_id=mptpi.hashtag_id AND mptpi.`mtr_portfolio_id_1`=27473895 AND mptpi.`type`=3327 AND mptpi.`hashtag_id` in (select hashtag_id FROM MTRBack.hashtags where hashtag in ('pet_clair','etiquette','bouchon','pet_fonce','pehd','barquette_avec_film','papier','carton','verre','metal','mal_croppe','flou','emr')) AND mptpi.`min_score`=0.5 To do Catched exception ! (1213, 'Deadlock found when trying to get lock; try restarting transaction') 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 2339, 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 2641, in datou_step_exec return post_process.datou_step_exec_ventilate_hashtags_in_portfolio(param, json_param, args, context, map_info, File "/home/admin/workarea/git/Velours/python/mtr/datou/lib_step_exec/lib_step_post_processing.py", line 281, in datou_step_exec_ventilate_hashtags_in_portfolio context.pq.copy_portfolio(old_port_id,sub_port_id , verbose = verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/portfolio_queries.py", line 538, in copy_portfolio self.gq.insert(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 151, in insert number = cursor.execute(query, args) 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) [1387545538, 1387545528, 1387545525, 1387545521, 1387545517, 1387545513, 1387545499, 1387545497, 1387545493, 1387545490, 1387545484, 1387545477, 1387545476, 1387545474, 1387545472, 1387545469, 1387545466, 1387545453, 1387545451, 1387545449, 1387545447, 1387545425, 1387545403, 1387545401, 1387545397, 1387545395, 1387545390, 1387545388] begin to insert list_values into mtr_datou_result : length of list_values in save_final : 28 time used for this insertion : 0.02042388916015625 save_final ERROR in last step ventilate_hashtags_in_portfolio, (1213, 'Deadlock found when trying to get lock; try restarting transaction') time spend for datou_step_exec : 3.748899221420288 time spend to save output : 0.027031421661376953 total time spend for step 3 : 3.775930643081665 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 ! 4.35user 0.86system 0:24.45elapsed 21%CPU (0avgtext+0avgdata 176332maxresident)k 128inputs+64240outputs (1major+81323minor)pagefaults 0swaps