python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 ~/workarea/git/Velours/python/mtr/utils/cdn/migration_s3_ovh/delete_photo_id_s3.py -s ovh -j delete_by_pht --pht 4151 --csv_port_exclusive 18972231,18986807,19058055 --date_end 2024-12-17 -D --multi=1 --max_threads=25 ' -s delete_sub_images -M 0 -S 0 -U 100,100,100 import MySQLdb succeeded Import error (python version) warning , we can't find thcl infos in json_data warning , we can't find pdt infos in json_data on parallélise SELECT photo_id FROM MTRBack.photo_hashtag_ids where type = 4151 and timestamp <="2024-12-17" and photo_id not in (select mtr_photo_id from MTRUser.mtr_portfolio_photos where mtr_portfolio_id in (18972231,18986807,19058055)) LIMIT 200 failed to delete the file, maybe something wrong : 5557.1287987837.desc Catched exception ! Connect or reconnect ! 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: (1114, "The table 'photos' is full") During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/home/admin/workarea/git/Velours/python/mtr/utils/cdn/migration_s3_ovh/delete_photo_id_s3.py", line 574, in delete_sub_photos_by_pht(context,s3,desc,x.photo_hashtag_type,x.delete,x.verbose,x.storage_server,x.date_end,x.csv_port_exclusive, x.multi, x.max_threads) File "/home/admin/workarea/git/Velours/python/mtr/utils/cdn/migration_s3_ovh/delete_photo_id_s3.py", line 494, in delete_sub_photos_by_pht delete_photos(context,s3,desc,csv_photo_ids,delete,verbose,storage_server, multi, max_threads) File "/home/admin/workarea/git/Velours/python/mtr/utils/cdn/migration_s3_ovh/delete_photo_id_s3.py", line 180, in delete_photos delete_urls(context, s3, desc, photos, delete, verbose, storage_server=storage_server, multi=multi, max_threads=max_threads) File "/home/admin/workarea/git/Velours/python/mtr/utils/cdn/migration_s3_ovh/delete_photo_id_s3.py", line 169, in delete_urls context.AQ.delete_from_base_table_by_ids('MTRBack', 'photos', ids, verbose, 'photo_id') File "/home/admin/workarea/git/Velours/python/mtr/database_queries/admin_queries.py", line 540, in delete_from_base_table_by_ids self.gq.insert(query) File "/home/admin/workarea/git/Velours/python/mtr/database_queries/general_queries.py", line 112, 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: (1114, "The table 'photos' is full") Command exited with non-zero status 1 2.29user 1.08system 2:19.16elapsed 2%CPU (0avgtext+0avgdata 140424maxresident)k 704inputs+8outputs (6major+29576minor)pagefaults 0swaps