python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 8 -a ' -a 4871 -l 100 ' -s datou_current_4871 -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 : 2546762 load datou : 4871 # 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 : chemin de la photo was removed should we ? (photo_id, hashtag_id, score_max) 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 : 3888>100 please execute split_portfolio.py -i 22406770 -l 100 size over we load limit photo not treated list_input_json: {} Current got : datou_id : 4871, datou_cur_ids : ['2759758'] with mtr_portfolio_ids : ['22406770'] and first list_photo_ids : [] new path : /proc/2546762/ 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 : blur_detection over limit max, limiting to limit_max 20 list_input_json : {} origin We have 1 , WARNING: data may be incomplete, need to offset and complete ! BFBFBFBFBFBFBFBFBFBFBFBFBFBFBFwe have missing 0 photos in the step downloads : photo missing : [] try to delete the photos missing in DB length of list_filenames : 15 ; length of list_pids : 15 ; length of list_args : 15 time to download the photos : 1.5973491668701172 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 : 1 step1:blur_detection Fri Apr 25 19:02:30 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 inside step blur_detection methode: ratio et variance treat image : temp/1745600548_2546762_1353861794_8c282984fee3b17fbc9bc32954fcc9f4.jpg resize: (1080, 1632) 1353861794 -4.610564216185357 treat image : temp/1745600548_2546762_1353861768_7bc81a7dc501f7d98d4993f4de39268f.jpg resize: (1080, 1632) 1353861768 -6.06585755438613 treat image : temp/1745600548_2546762_1353861729_edc3c952a29ce7b229cdda7963d204a5.jpg resize: (1080, 1632) 1353861729 -4.22031370378582 treat image : temp/1745600548_2546762_1353861687_6a87604eec5dbc15961a32cb45f06b1a.jpg resize: (1080, 1632) 1353861687 -1.2237949649200097 treat image : temp/1745600548_2546762_1353861092_3332bd050dd0a00ac368b5788ea16145.jpg resize: (1080, 1632) 1353861092 -2.922763734286483 treat image : temp/1745600548_2546762_1353861036_fc3466ea1700134a790716e2bc757470.jpg resize: (1080, 1632) 1353861036 -5.24047821322998 treat image : temp/1745600548_2546762_1353860991_84d668301e31f1384786265ae7a5424e.jpg resize: (1080, 1632) 1353860991 -6.017798359655423 treat image : temp/1745600548_2546762_1353860929_f29fcf8d976c181a287db89b9db53641.jpg resize: (1080, 1632) 1353860929 -5.645215742658297 treat image : temp/1745600548_2546762_1353860874_462e113dfc904eec71ab53e8cbd52129.jpg resize: (1080, 1632) 1353860874 -4.977331259251902 treat image : temp/1745600548_2546762_1353860371_c25720854a149be83904f94e99888458.jpg resize: (1080, 1632) 1353860371 -4.764292090338665 treat image : temp/1745600548_2546762_1353860302_f1b1647754fdc9fce63181e660ddd777.jpg resize: (1080, 1632) 1353860302 -4.737109554860967 treat image : temp/1745600548_2546762_1353860262_cc494c35f6e0e24f6eae487a15b24445.jpg resize: (1080, 1632) 1353860262 -5.538688252958136 treat image : temp/1745600548_2546762_1353860208_9c7181f3033e79c478cc190c2538d31c.jpg resize: (1080, 1632) 1353860208 -4.981863018128477 treat image : temp/1745600548_2546762_1353860132_6c4f8a97fb7e4dc7b1b3e2d6146da7f0.jpg resize: (1080, 1632) 1353860132 -4.744587232028543 treat image : temp/1745600548_2546762_1353860046_fb26b605af2b5ace7cd7451cd0806c3e.jpg resize: (1080, 1632) 1353860046 -4.938608952152708 Inside saveOutput : final : True verbose : 0 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' (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 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 2381, in datou_exec SAVE.saveOutput(output, map_info, sNext, final=final, verbose=verbose, cache=cache, File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib_step_save.py", line 1687, in saveOutput save_blur_detection(output, map_info, datou_step.param, datou_step.json_param, DQ, hq, cat, final, verbose) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib_step_save.py", line 879, in save_blur_detection hashtag_type = DQ.selectHashtagTypeFromthcl(int(param), verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/datou_queries.py", line 365, in selectHashtagTypeFromthcl res = 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' (111)") Command exited with non-zero status 1 10.85user 4.42system 0:18.58elapsed 82%CPU (0avgtext+0avgdata 137772maxresident)k 96inputs+7264outputs (3major+204937minor)pagefaults 0swaps