python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 8 -a ' --fifo -a 533 -l 100 ' -s datou_current_533 -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 : 2544501 load datou : 533 # 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 ! 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 ! 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 ! 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 : chemin de la photo was removed should we ? [ (photo_id, hashtag_id_0, score_0), (photo_id, hashtag_id_1, score_1), ...] was removed should we ? [ (photo_id, hashtag_id_0, score_0), (photo_id, hashtag_id_1, score_1), ...] was removed should we ? (photo_id, hashtag_id, score_max) was removed should we ? chemin de la photo 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 : 1045>100 please execute split_portfolio.py -i 22420226 -l 100 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 533, datou_cur_ids : ['2761078'] with mtr_portfolio_ids : ['22420226'] and first list_photo_ids : [] new path : /proc/2544501/ 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 ! 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 ! 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 ! DataTypes for each output/input checked ! List Step Type Loaded in datou : tfhub_classification2, argmax list_input_json : {} origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 81 ; length of list_pids : 81 ; length of list_args : 81 time to download the photos : 9.445553064346313 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 : 2 step1:tfhub_classification2 Fri Apr 25 19:01: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 Beginning of datou_step TFHub with tf2 ! nombre de thcls : 3 we are using the classfication for multi_thcl [3513, 3379, 3847] begin to check gpu status inside check gpu memory havn't enough memory gpu , need / 3096 l 3632 free memory gpu now : 820 wait 20 seconds inside check gpu memory havn't enough memory gpu , need / 3096 l 3632 free memory gpu now : 820 wait 20 seconds inside check gpu memory havn't enough memory gpu , need / 3096 l 3632 free memory gpu now : 820 wait 20 seconds inside check gpu memory havn't enough memory gpu , need / 3096 l 3632 free memory gpu now : 820 wait 20 seconds inside check gpu memory havn't enough memory gpu , need / 3096 l 3632 free memory gpu now : 820 wait 20 seconds inside check gpu memory havn't enough memory gpu , need / 3096 l 3632 free memory gpu now : 820 wait 20 seconds 2025-04-25 19:03:44.239773: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcuda.so.1 2025-04-25 19:03:44.247765: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-04-25 19:03:44.247970: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-04-25 19:03:44.253622: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-04-25 19:03:44.255628: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-04-25 19:03:44.255985: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-04-25 19:03:44.258369: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-04-25 19:03:44.259741: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-04-25 19:03:44.263839: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-04-25 19:03:44.264894: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-04-25 19:03:44.265229: I tensorflow/core/platform/cpu_feature_guard.cc:143] Your CPU supports instructions that this TensorFlow binary was not compiled to use: AVX2 FMA 2025-04-25 19:03:44.291127: I tensorflow/core/platform/profile_utils/cpu_utils.cc:102] CPU Frequency: 3493065000 Hz 2025-04-25 19:03:44.293156: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x7fcf80000b60 initialized for platform Host (this does not guarantee that XLA will be used). Devices: 2025-04-25 19:03:44.293212: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): Host, Default Version 2025-04-25 19:03:44.495066: I tensorflow/compiler/xla/service/service.cc:168] XLA service 0x2dc74670 initialized for platform CUDA (this does not guarantee that XLA will be used). Devices: 2025-04-25 19:03:44.495101: I tensorflow/compiler/xla/service/service.cc:176] StreamExecutor device (0): NVIDIA GeForce RTX 2080 Ti, Compute Capability 7.5 2025-04-25 19:03:44.495967: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1561] Found device 0 with properties: pciBusID: 0000:41:00.0 name: NVIDIA GeForce RTX 2080 Ti computeCapability: 7.5 coreClock: 1.545GHz coreCount: 68 deviceMemorySize: 10.76GiB deviceMemoryBandwidth: 573.69GiB/s 2025-04-25 19:03:44.496041: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-04-25 19:03:44.496070: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcublas.so.10 2025-04-25 19:03:44.496097: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcufft.so.10 2025-04-25 19:03:44.496123: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcurand.so.10 2025-04-25 19:03:44.496149: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusolver.so.10 2025-04-25 19:03:44.496175: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcusparse.so.10 2025-04-25 19:03:44.496201: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudnn.so.7 2025-04-25 19:03:44.497306: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1703] Adding visible gpu devices: 0 2025-04-25 19:03:44.497368: I tensorflow/stream_executor/platform/default/dso_loader.cc:44] Successfully opened dynamic library libcudart.so.10.1 2025-04-25 19:03:44.498052: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1102] Device interconnect StreamExecutor with strength 1 edge matrix: 2025-04-25 19:03:44.498076: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1108] 0 2025-04-25 19:03:44.498091: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1121] 0: N 2025-04-25 19:03:44.499263: I tensorflow/core/common_runtime/gpu/gpu_device.cc:1247] Created TensorFlow device (/job:localhost/replica:0/task:0/device:GPU:0 with 3096 MB memory) -> physical GPU (device: 0, name: NVIDIA GeForce RTX 2080 Ti, pci bus id: 0000:41:00.0, compute capability: 7.5) l 3637 free memory gpu now : 820 max_wait_temp : 6 max_wait : 5 1 Physical GPUs, 1 Logical GPUs tagging for thcl : 3513 To do loadFromThcl(), then load ParamDescType : thcl3513 Catched exception ! Connect or reconnect ! ERROR in datou_step_exec, will save and exit ! Unable to connect to sql.fotonower.com : (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (110)") File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2329, in datou_exec output = datou_step_exec(sNext, args, cache, context, map_info, verbose, mtr_user_id) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2523, in datou_step_exec return lib_process.datou_step_tfhub2(param, json_param, args, cache, context, map_info, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/lib_step_exec/lib_step_process.py", line 3114, in datou_step_tfhub2 photo_desc_type, list_hashtags = context.load_thcl_param(thclid, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 1806, in load_thcl_param return self.cache_model_config.load_thcl_param(self.cat, thclid, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2091, in load_thcl_param pb_hashtag_id_or_classifier) = self.get_desc_type_from_thcl(thclid, cat, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2131, in get_desc_type_from_thcl thcls = cat.getClassificationThemes(0, False, thclid, verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/classification_admin_tools.py", line 67, in getClassificationThemes thcls = self.gq.select(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 77, in select self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 46, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) [1353861009, 1353860955, 1353860368, 1353860305, 1353859410, 1353859362, 1353859047, 1353859045, 1353858985, 1353858982, 1353858945, 1353858942, 1353858883, 1353858881, 1353858643, 1353858629, 1353858423, 1353858421, 1353858293, 1353858271, 1353858050, 1353858023, 1353857871, 1353857868, 1353857817, 1353857814, 1353857573, 1353857545, 1353857363, 1353857361, 1353857221, 1353857219, 1353857076, 1353857070, 1353856825, 1353856822, 1353856760, 1353856731, 1353856567, 1353856541, 1353856378, 1353856335, 1353856333, 1353856157, 1353856152, 1353855778, 1353855338, 1353855294, 1353855291, 1353854926, 1353854923, 1353854337, 1353854174, 1353853967, 1353853964, 1353853793, 1353853785, 1353853587, 1353853560, 1353853385, 1353853382, 1353853327, 1353853324, 1353853141, 1353853130, 1353852926, 1353852921, 1353852874, 1353852871, 1353852816, 1353852789, 1353852559, 1353852555, 1353852241, 1353852238, 1353851626, 1353851491, 1353850668, 1353850626, 1353849481, 1353849431] begin to insert list_values into mtr_datou_result : length of list_values in save_final : 81 Catched exception ! Connect or reconnect ! exception in save_final Unable to connect to sql.fotonower.com : (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (113)") 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 : [('533', '22420226', '1353861009', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353860955', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353860368', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353860305', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353859410', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353859362', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353859047', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353859045', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858985', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858982', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858945', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858942', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858883', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858881', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858643', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858629', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858423', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858421', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858293', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858271', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858050', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353858023', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857871', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857868', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857817', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857814', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857573', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857545', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857363', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857361', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857221', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857219', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857076', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353857070', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856825', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856822', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856760', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856731', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856567', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856541', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856378', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856335', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856333', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856157', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353856152', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353855778', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353855338', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353855294', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353855291', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353854926', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353854923', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353854337', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353854174', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853967', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853964', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853793', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853785', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853587', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853560', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853385', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853382', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853327', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853324', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853141', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353853130', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852926', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852921', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852874', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852871', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852816', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852789', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852559', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852555', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852241', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353852238', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353851626', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353851491', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353850668', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353850626', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353849481', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078'), ('533', '22420226', '1353849431', '[>, , , , \'Unable to connect to sql.fotonower.com : (2003, "Can\\\'t connect to MySQL server on \\\'sql.fotonower.com:3306\\\' (110)")\']', '-1', '-1.0', '501120777', '1.0', '2761078')] time used for this insertion : 3.9173355102539062 save_final ERROR in last step tfhub_classification2, Unable to connect to sql.fotonower.com : (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (110)") time spend for datou_step_exec : 263.99637818336487 time spend to save output : 3.922287702560425 total time spend for step 0 : 267.9186658859253 Catched exception ! Connect or reconnect ! Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 68, in select cursor.execute(query, args) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.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 43, in connect self.db = MySQLdb.connect(host=self.host, db=self.dbname, user=self.user, passwd=self.password) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 179, in __init__ super(Connection, self).__init__(*args, **kwargs2) MySQLdb._exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (110)") 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 2329, in datou_exec output = datou_step_exec(sNext, args, cache, context, map_info, verbose, mtr_user_id) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2523, in datou_step_exec return lib_process.datou_step_tfhub2(param, json_param, args, cache, context, map_info, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/lib_step_exec/lib_step_process.py", line 3114, in datou_step_tfhub2 photo_desc_type, list_hashtags = context.load_thcl_param(thclid, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 1806, in load_thcl_param return self.cache_model_config.load_thcl_param(self.cat, thclid, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2091, in load_thcl_param pb_hashtag_id_or_classifier) = self.get_desc_type_from_thcl(thclid, cat, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 2131, in get_desc_type_from_thcl thcls = cat.getClassificationThemes(0, False, thclid, verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/classification_admin_tools.py", line 67, in getClassificationThemes thcls = self.gq.select(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 77, in select self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 46, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) Exception: Unable to connect to sql.fotonower.com : (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (110)") 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 100, in insert number = cursor.execute(query, args) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 209, in execute res = self._query(query) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/cursors.py", line 315, in _query db.query(q) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 239, in query _mysql.connection.query(self, query) MySQLdb._exceptions.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 43, in connect self.db = MySQLdb.connect(host=self.host, db=self.dbname, user=self.user, passwd=self.password) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/__init__.py", line 84, in Connect return Connection(*args, **kwargs) File "/usr/local/lib/python3.8/dist-packages/MySQLdb/connections.py", line 179, in __init__ super(Connection, self).__init__(*args, **kwargs2) MySQLdb._exceptions.OperationalError: (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (113)") 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 621, 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 819, 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 2368, 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 1875, 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 170, in update_current_state self.gq.insert(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 110, in insert self.connect() File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 46, in connect raise Exception("Unable to connect to " + str(self.host) + " : " + str(e)) Exception: Unable to connect to sql.fotonower.com : (2003, "Can't connect to MySQL server on 'sql.fotonower.com:3306' (113)") Command exited with non-zero status 1 3.04user 2.60system 4:42.75elapsed 2%CPU (0avgtext+0avgdata 545316maxresident)k 864inputs+35376outputs (30major+142972minor)pagefaults 0swaps