python /home/admin/mtr/script_for_cron.py -j datou_current3 -m 20 -a ' -a 4935' -s datou_current_4935 -M 0 -S 0 -U 95,95,120 import MySQLdb succeeded Import error (python version) ['/Users/moilerat/Documents/Fotonower/install/caffe/distribute/python', '/home/admin/workarea/git/Velours/python/prod', '/home/admin/workarea/install/caffe_cuda8_python3/python', '/home/admin/workarea/install/darknet', '/home/admin/workarea/git/Velours/python', '/home/admin/workarea/install/caffe_frcnn_python3/py-faster-rcnn/caffe-fast-rcnn/python', '/home/admin/mtr/.credentials', '/home/admin/workarea/install/caffe/python', '/home/admin/workarea/install/caffe_frcnn/py-faster-rcnn/tools', '/home/admin/workarea/git/fotonowerpip', '/home/admin/workarea/install/segment-anything', '/home/admin/workarea/git/pyfvs', '/usr/lib/python38.zip', '/usr/lib/python3.8', '/usr/lib/python3.8/lib-dynload', '/home/admin/.local/lib/python3.8/site-packages', '/usr/local/lib/python3.8/dist-packages', '/usr/lib/python3/dist-packages'] process id : 859972 load datou : 4935 # VR 17-11-17 : to create in DB ! Here we check the datou graph and we reorder steps ! Tree builded and cycle checked, now we need to re-order the steps ! We have currenlty an error because there is no dependence between the last step for the case tile - detect - glue We can either keep the depence of, it is better to keep an order compatible with the id of steps if we do not have sons, so a lexical order : (number_son, step_id) DONE and to test : checkNoCycle ! We are managing only one step so we do not consider checkConsistencyNbInputNbOutput ! We are managing only one step so we do not consider checkConsistencyTypeOutputInput ! Unexpected type for variable list_input_json ERROR or WARNING : can't parse json string Expecting value: line 1 column 1 (char 0) Tried to parse : None was removed should we ? donnée sous forme de texte was removed should we ? [ptf_id0,ptf_id1...] was removed should we ? load thcls load pdts Running datou job : batch_current TODO datou_current to load to do maybe to take outside batchDatouExec no input labels no input values updating current state to 1 we have a portfolio with more photos than limit : 3233>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 : 4935, datou_cur_ids : ['3953613'] with mtr_portfolio_ids : ['27870361'] and first list_photo_ids : [] new path : /proc/859972/ Catched exception ! Connect or reconnect ! Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 185, in insert_many cursor.executemany(query, args[:limit]) File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 241, in executemany return self._do_execute_many( File "/home/admin/.local/lib/python3.8/site-packages/MySQLdb/cursors.py", line 275, in _do_execute_many rows += self.execute(sql + postfix) 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 605, in batchDatouCurrent SaveInfoMem("datou_batch_current", context, verbose, datou_cur_ids[0]) File "/home/admin/workarea/git/Velours/python/mtr/datou/datou_lib.py", line 1172, in SaveInfoMem GIS(context.AQ, name, verbose, 0, datou_current_id) File "/home/admin/workarea/git/Velours/python/mtr/mem_info.py", line 92, in get_info_and_save save_info(AQ, dict, name,verbose, datou_current_id) File "/home/admin/workarea/git/Velours/python/mtr/mem_info.py", line 74, in save_info AQ.save_mem_info(list_values,verbose) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/admin_queries.py", line 107, in save_mem_info self.gq.insert_many(query,list_values) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 195, in insert_many 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.70user 0.61system 3:44.75elapsed 1%CPU (0avgtext+0avgdata 103964maxresident)k 16inputs+16outputs (6major+48707minor)pagefaults 0swaps