python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 ~/workarea/git/Velours/python/mtr/utils/delete_row_crop_segment.py --limit=8000 --nb_batch=200 --days=0 --type=3132,3326,3327,3594,3663,3726,3760,3789,3887,3923,3996,4003,4199,4200,4202,4203,4204,4205,4206,4207,4208,4209,4210,4211,4213,4228,4230,4341,4391,4455,4460,4463,4474,4481,4549  -v ' -s delete_crop_segments -M 0 -S 0 -U 90,80,95
 import MySQLdb succeeded 
on va faire 200 occurences de suppression de 8000 photos
batch : 0/199
nombre de photos selectionnées : 8000
batch : 1/199
nombre de photos selectionnées : 8000
batch : 2/199
nombre de photos selectionnées : 8000
batch : 3/199
nombre de photos selectionnées : 8000
batch : 4/199
nombre de photos selectionnées : 8000
batch : 5/199
nombre de photos selectionnées : 8000
batch : 6/199
nombre de photos selectionnées : 8000
batch : 7/199
nombre de photos selectionnées : 8000
batch : 8/199
nombre de photos selectionnées : 8000
batch : 9/199
nombre de photos selectionnées : 8000
batch : 10/199
nombre de photos selectionnées : 8000
batch : 11/199
nombre de photos selectionnées : 8000
batch : 12/199
nombre de photos selectionnées : 8000
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: (1205, 'Lock wait timeout exceeded; try restarting transaction')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/admin/workarea/git/Velours/python/mtr/utils/delete_row_crop_segment.py", line 153, in <module>
    delete_cs_id(id_list_final, batch_delete)
  File "/home/admin/workarea/git/Velours/python/mtr/utils/delete_row_crop_segment.py", line 38, in delete_cs_id
    gq.select(delete_cs_id_query)
  File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 79, 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: (1205, 'Lock wait timeout exceeded; try restarting transaction')
Command exited with non-zero status 1
0.27user 0.07system 11:16.53elapsed 0%CPU (0avgtext+0avgdata 32384maxresident)k
12096inputs+104outputs (1250major+7038minor)pagefaults 0swaps