python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python ~/workarea/git/Velours/python/mtr/utils/delete_rows_crops.py --limit=2000 --nb_batch=50 --type=3132 --days=370 ' -s delete_crops -M 0 -S 0 -U 90,80,95
 import MySQLdb succeeded 
on va faire 50 occurences de suppression de 2000 photos
batch : 0/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 1/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 2/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 3/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 4/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 5/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 6/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 7/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 8/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 9/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 10/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 11/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 12/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 13/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 14/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 15/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 16/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 17/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 18/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 19/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 20/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 21/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 22/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 23/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 24/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 25/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 26/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 27/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 28/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 29/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 30/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 31/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 32/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 33/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 34/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 35/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 36/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 37/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 38/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
batch : 39/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
Catched exception !
Connect or reconnect !
batch : 40/49

                          select id from MTRPhoto.crop_hashtag_ids where type in (3132)
                           and timestamp < "2024-04-09"  LIMIT 2000;
nombre de photos selectionnées : 2000
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: (3019, 'Undo Log error: No more space left over in undo tablespace for allocating UNDO log pages. Please add new data file to the tablespace or check if filesystem is full or enable auto-extension for the tablespace')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/home/admin/workarea/git/Velours/python/mtr/utils/delete_rows_crops.py", line 112, in <module>
    delete_cs_id(id_list_final, batch_delete)
  File "/home/admin/workarea/git/Velours/python/mtr/utils/delete_rows_crops.py", line 40, 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.28user 0.04system 4:32.12elapsed 0%CPU (0avgtext+0avgdata 32900maxresident)k
0inputs+256outputs (0major+4939minor)pagefaults 0swaps