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 : 668015 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 : 2423>1000 please execute split_portfolio.py -i 27870361 -l 1000 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 4876, datou_cur_ids : ['3952836'] with mtr_portfolio_ids : ['27870361'] and first list_photo_ids : [] new path : /proc/668015/ 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.19863104820251465 About to test input to load Calling datou_exec Inside datou_exec : verbose : 0 number of steps : 1 step1:split_time_score Fri Oct 17 09:39:23 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', 274), ('01', 156), ('02', 289), ('03', 275), ('04', 51), ('05', 185), ('06', 326), ('07', 342), ('08', 466), ('09', 65)) ERROR counted https://github.com/fotonower/Velours/issues/663#issuecomment-421136223 {1: 28} 17102025 27870361 Nombre de photos uploadées : 654 / 23040 (2%) 17102025 27870361 Nombre de photos taguées (types de déchets): 28 / 654 (4%) 17102025 27870361 Nombre de photos taguées (volume) : 28 / 654 (4%) elapsed_time : load_data_split_time_score 3.5762786865234375e-06 elapsed_time : order_list_meta_photo_and_scores 2.7894973754882812e-05 ?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? elapsed_time : fill_and_build_computed_from_old_data 0.052600860595703125 Catched exception ! Connect or reconnect ! ERROR in datou_step_exec, will save and exit ! Unable to connect to sql_cath.fotonower.com : (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") 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 2523, 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 394, in split_port_in_batch_balle dashboard_run_id = one_gbs.set_run_id(context, day_insert, mtr_portfolio, mtr_user_id, verbose , not_update_port_id) File "/home/admin/workarea/git/Velours/python/mtr/math_fotonower/timeseries/class_split_time_score.py", line 94, in set_run_id self.dashboard_entry_day = context.DQ.insert_entry_day(self.place_id, day, mtr_portfolio_id, verbose , not_update_port_id) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/datou_queries.py", line 1981, in insert_entry_day res = self.insert_id_retrieve(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 170, in insert_id_retrieve self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 84, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) [1389768975, 1389768942, 1389768941, 1389768911, 1389768910, 1389768888, 1389768881, 1389768880, 1389768855, 1389768852, 1389768849, 1389768848, 1389768820, 1389768819, 1389768811, 1389768810, 1389768808, 1389768788, 1389768787, 1389768775, 1389768774, 1389768755, 1389768754, 1389768751, 1389768738, 1389768719, 1389768716, 1389768715, 1389768703, 1389768677, 1389768675, 1389768674, 1389768668, 1389768645, 1389768644, 1389768634, 1389768611, 1389768610, 1389768608, 1389768583, 1389768576, 1389768574, 1389768560, 1389768550, 1389768548, 1389768525, 1389768521, 1389768514, 1389768493, 1389768492, 1389768482, 1389768463, 1389768462, 1389768453, 1389768438, 1389768427, 1389768423, 1389768413, 1389768402, 1389768401, 1389768396, 1389768371, 1389768366, 1389768350, 1389768344, 1389768331, 1389768322, 1389768309, 1389768299, 1389768298, 1389768289, 1389768276, 1389768275, 1389768268, 1389768264, 1389768245, 1389768244, 1389768239, 1389768234, 1389768207, 1389768206, 1389768205, 1389768199, 1389768173, 1389768167, 1389768165, 1389768153, 1389768136, 1389768135, 1389768134, 1389768119, 1389768100, 1389768088, 1389768077, 1389768065, 1389768058, 1389768051, 1389768038, 1389768026, 1389768018] begin to insert list_values into mtr_datou_result : length of list_values in save_final : 100 Catched exception ! Connect or reconnect ! exception in save_final Unable to connect to sql_cath.fotonower.com : (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") query : insert ignore into MTRPhoto.mtr_datou_result (mtd_id, mtr_portfolio_id,mtr_photo_id,result,result_long,result_double,hashtag_id,proba, mtr_current_id) values (%s,%s,%s,%s,%s,%s,%s,%s,%s) on duplicate key update mtr_portfolio_id = mtr_portfolio_id list_tup_unique : [('4876', '27870361', '1389768975', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768942', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768941', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768911', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768910', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768888', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768881', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768880', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768855', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768852', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768849', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768848', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768820', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768819', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768811', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768810', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768808', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768788', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768787', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768775', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768774', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768755', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768754', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768751', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768738', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768719', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768716', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768715', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768703', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768677', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768675', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768674', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768668', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768645', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768644', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768634', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768611', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768610', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768608', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768583', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768576', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768574', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768560', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768550', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768548', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768525', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768521', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768514', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768493', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768492', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768482', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768463', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768462', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768453', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768438', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768427', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768423', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768413', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768402', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768401', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768396', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768371', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768366', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768350', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768344', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768331', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768322', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768309', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768299', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768298', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768289', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768276', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768275', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768268', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768264', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768245', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768244', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768239', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768234', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768207', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768206', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768205', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768199', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768173', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768167', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768165', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768153', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768136', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768135', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768134', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768119', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768100', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768088', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768077', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768065', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768058', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768051', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768038', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768026', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836'), ('4876', '27870361', '1389768018', '[>, , , , \'Unable to connect to sql_cath.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql_cath.fotonower.com:3306\\\' (111)")\']', '-1', '-1.0', '501120777', '1.0', '3952836')] time used for this insertion : 0.09935212135314941 save_final ERROR in last step split_time_score, Unable to connect to sql_cath.fotonower.com : (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") time spend for datou_step_exec : 182.54768705368042 time spend to save output : 0.10445904731750488 total time spend for step 0 : 182.65214610099792 Catched exception ! (2013, 'Lost connection to MySQL server during query') Connect or reconnect ! Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 158, in insert_id_retrieve 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) MySQLdb.OperationalError: (2013, 'Lost connection to MySQL server during query') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 81, in connect self.db = MySQLdb.connect(host=self.host, db=self.dbname, user=self.user, passwd=self.password) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/__init__.py", line 121, in Connect return Connection(*args, **kwargs) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 200, in __init__ super().__init__(*args, **kwargs2) MySQLdb.OperationalError: (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") During handling of the above exception, another exception occurred: Traceback (most recent call last): 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 2523, 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 394, in split_port_in_batch_balle dashboard_run_id = one_gbs.set_run_id(context, day_insert, mtr_portfolio, mtr_user_id, verbose , not_update_port_id) File "/home/admin/workarea/git/Velours/python/mtr/math_fotonower/timeseries/class_split_time_score.py", line 94, in set_run_id self.dashboard_entry_day = context.DQ.insert_entry_day(self.place_id, day, mtr_portfolio_id, verbose , not_update_port_id) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/datou_queries.py", line 1981, in insert_entry_day res = self.insert_id_retrieve(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 170, in insert_id_retrieve self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 84, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) Exception: Unable to connect to sql_cath.fotonower.com : (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 138, 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) MySQLdb.OperationalError: (2013, 'Lost connection to MySQL server during query') During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 81, in connect self.db = MySQLdb.connect(host=self.host, db=self.dbname, user=self.user, passwd=self.password) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/__init__.py", line 121, in Connect return Connection(*args, **kwargs) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/connections.py", line 200, in __init__ super().__init__(*args, **kwargs2) MySQLdb.OperationalError: (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "prod/datou.py", line 270, in ret = batchDatouCurrent(context, datou_id, mtr_portfolio_ids, list_photo_ids, limit, offset, rand, save, File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 628, in batchDatouCurrent ret = batchDatouExec(context, datou_id, mtr_portfolio_ids, list_photo_ids, list_input_json, limit, File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 826, in batchDatouExec output, datou_failed_to_relaunch = datou_exec(datou, input, cache, context, map_info, save, list_pids, verbose, mtr_user_id, is_last_batch, end_time) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2378, in datou_exec context.update_current_state(map_info["datou_cur_ids"], 0, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 1885, in update_current_state self.DQ.update_current_state(map_info_datou_cur_ids, status, verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/datou_queries.py", line 184, in update_current_state self.gq.insert(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 149, in insert self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 84, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) Exception: Unable to connect to sql_cath.fotonower.com : (2003, "Can't connect to MySQL server on 'sql_cath.fotonower.com:3306' (111)") Command exited with non-zero status 1 1.52user 0.55system 3:55.15elapsed 0%CPU (0avgtext+0avgdata 108072maxresident)k 0inputs+176outputs (0major+49871minor)pagefaults 0swaps