python /home/admin/mtr/script_for_cron.py -j default -m 20 -a 'python3 /home/admin/workarea/git/Velours/python/mtr/utils/cdn/migration_s3_ovh/delete_photo_id_s3.py -j delete_by_right -v --right 13977' -s delete_romainville_0923 -M 0 -S 0 -U 90,80,95 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 Starting time : 1769430899.208989 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203579440, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ec550fecaf564a18e42daa716ac06b95_24618087.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203579442, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/1dba7abe0d6fc0e2df6e409e6e212ed7_85578351.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.010412216186523438 Currently in test ! try to remove file 2023/9/1/ec550fecaf564a18e42daa716ac06b95_24618087.jpg from ovh : successful delete the file try to remove file 2023/9/1/1dba7abe0d6fc0e2df6e409e6e212ed7_85578351.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203579440,1203579442) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.711050, desc_s3 : 0:00:00.804002, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203579440","1203579442") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.5312342643737793 Starting time : 1769430900.750675 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203579443, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/45b478811998918bb3691ac854e0b5f8_63203640.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203579444, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/375fed12aa0f6b9c163851fed4cba7a6_67385965.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005597591400146484 Currently in test ! try to remove file 2023/9/1/45b478811998918bb3691ac854e0b5f8_63203640.jpg from ovh : successful delete the file try to remove file 2023/9/1/375fed12aa0f6b9c163851fed4cba7a6_67385965.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203579443,1203579444) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.667800, desc_s3 : 0:00:00.572201, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203579443","1203579444") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2583701610565186 Starting time : 1769430902.014675 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203585199, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d0997f31b9c2c92efc7daabf8b251454_85104826.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203585201, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/3434ee908bf5baaeb5af487f281fadb5_35972274.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006318569183349609 Currently in test ! try to remove file 2023/9/1/d0997f31b9c2c92efc7daabf8b251454_85104826.jpg from ovh : successful delete the file try to remove file 2023/9/1/3434ee908bf5baaeb5af487f281fadb5_35972274.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203585199,1203585201) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.593690, desc_s3 : 0:00:00.732162, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203585199","1203585201") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3428118228912354 Starting time : 1769430903.3638418 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203653903, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a71e0d18b668477f2322d1ecf8cf37a9_78653129.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203655899, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6ef351c69fb6e137bd0030e9fd3c8726_45638475.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006693124771118164 Currently in test ! try to remove file 2023/9/1/a71e0d18b668477f2322d1ecf8cf37a9_78653129.jpg from ovh : successful delete the file try to remove file 2023/9/1/6ef351c69fb6e137bd0030e9fd3c8726_45638475.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203653903,1203655899) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.824769, desc_s3 : 0:00:00.501682, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203653903","1203655899") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.342176914215088 Starting time : 1769430904.7127419 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203909923, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/db9035635caf8a5fa450e838caa0af69_40807469.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203909924, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6b88f4b32b33cf5720e4b5284a388de8_34726779.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0067005157470703125 Currently in test ! try to remove file 2023/9/1/db9035635caf8a5fa450e838caa0af69_40807469.jpg from ovh : successful delete the file try to remove file 2023/9/1/6b88f4b32b33cf5720e4b5284a388de8_34726779.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203909923,1203909924) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.763236, desc_s3 : 0:00:00.485277, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203909923","1203909924") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2641959190368652 Starting time : 1769430905.9836655 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203909925, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8d898e842947f5e4f5c03f4742d20419_355954.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203909926, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bd7bd4c37bb7429c6640c1bac403da0c_76322920.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005811214447021484 Currently in test ! try to remove file 2023/9/1/8d898e842947f5e4f5c03f4742d20419_355954.jpg from ovh : successful delete the file try to remove file 2023/9/1/bd7bd4c37bb7429c6640c1bac403da0c_76322920.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203909925,1203909926) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.725803, desc_s3 : 0:00:00.534613, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203909925","1203909926") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2775561809539795 Starting time : 1769430907.2670598 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910312, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/3ddd20cdccdb11b182d3e6f34cbc2bce_44851673.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910313, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6a64c48a6cd5f88eadb618720f57594b_68504114.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006723880767822266 Currently in test ! try to remove file 2023/9/1/3ddd20cdccdb11b182d3e6f34cbc2bce_44851673.jpg from ovh : successful delete the file try to remove file 2023/9/1/6a64c48a6cd5f88eadb618720f57594b_68504114.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910312,1203910313) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.657469, desc_s3 : 0:00:00.465327, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910312","1203910313") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1398909091949463 Starting time : 1769430908.4137008 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910314, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bf08fa3ed372728bcdd2a4e16c6fd901_34624623.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910315, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/67b2f32022571cdf80bef335ddbedd40_97437614.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005773782730102539 Currently in test ! try to remove file 2023/9/1/bf08fa3ed372728bcdd2a4e16c6fd901_34624623.jpg from ovh : successful delete the file try to remove file 2023/9/1/67b2f32022571cdf80bef335ddbedd40_97437614.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910314,1203910315) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.569995, desc_s3 : 0:00:00.649400, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910314","1203910315") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.234210729598999 Starting time : 1769430909.6537113 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910316, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9b5428ab2a38f325660b9d1d474ddea3_64015933.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910317, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/89c0cd63e8ae5f3487d4ce72054201ec_85347746.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0056095123291015625 Currently in test ! try to remove file 2023/9/1/9b5428ab2a38f325660b9d1d474ddea3_64015933.jpg from ovh : successful delete the file try to remove file 2023/9/1/89c0cd63e8ae5f3487d4ce72054201ec_85347746.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910316,1203910317) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.927480, desc_s3 : 0:00:00.523567, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910316","1203910317") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.4664626121520996 Starting time : 1769430911.1258101 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910397, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2173e8c04e3b1da42da33cf35361b97c_22822723.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910398, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e7fc4626d3853f406b13e04fc4a3351a_1009255.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005618095397949219 Currently in test ! try to remove file 2023/9/1/2173e8c04e3b1da42da33cf35361b97c_22822723.jpg from ovh : successful delete the file try to remove file 2023/9/1/e7fc4626d3853f406b13e04fc4a3351a_1009255.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910397,1203910398) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.689254, desc_s3 : 0:00:00.682748, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910397","1203910398") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3885493278503418 Starting time : 1769430912.5200043 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910399, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ab0b86762f3479005e58605b6cf8a7a6_29065639.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910401, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2af3345a77cad3a4e2ce8907f8e5d275_47729412.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006379604339599609 Currently in test ! try to remove file 2023/9/1/ab0b86762f3479005e58605b6cf8a7a6_29065639.jpg from ovh : successful delete the file try to remove file 2023/9/1/2af3345a77cad3a4e2ce8907f8e5d275_47729412.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910399,1203910401) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.608254, desc_s3 : 0:00:00.524936, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910399","1203910401") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1502649784088135 Starting time : 1769430913.6766753 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910402, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/fa7b7a8ab4cf62c1cb14c87fcb83a1b4_79193279.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910403, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/75020d5ff4682ff51730626acd682187_6117511.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.00581049919128418 Currently in test ! try to remove file 2023/9/1/fa7b7a8ab4cf62c1cb14c87fcb83a1b4_79193279.jpg from ovh : successful delete the file try to remove file 2023/9/1/75020d5ff4682ff51730626acd682187_6117511.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910402,1203910403) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.552581, desc_s3 : 0:00:00.551250, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910402","1203910403") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1224486827850342 Starting time : 1769430914.8049607 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910520, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2c206fa1a4c6f4d14d2874ea64eb63b4_90284075.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910521, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bfaa7e6ddb583a7b4220e3f9bcc45410_84556098.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0072901248931884766 Currently in test ! try to remove file 2023/9/1/2c206fa1a4c6f4d14d2874ea64eb63b4_90284075.jpg from ovh : successful delete the file try to remove file 2023/9/1/bfaa7e6ddb583a7b4220e3f9bcc45410_84556098.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910520,1203910521) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.562834, desc_s3 : 0:00:00.551190, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910520","1203910521") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1314079761505127 Starting time : 1769430915.9436862 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910522, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/37e8819271e69eeae25b985f9d7a6c2b_70855984.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910523, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/dad6742d9b22013c8215e291cf4ac60d_33784410.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005635738372802734 Currently in test ! try to remove file 2023/9/1/37e8819271e69eeae25b985f9d7a6c2b_70855984.jpg from ovh : successful delete the file try to remove file 2023/9/1/dad6742d9b22013c8215e291cf4ac60d_33784410.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910522,1203910523) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.667091, desc_s3 : 0:00:00.828656, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910522","1203910523") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.5113420486450195 Starting time : 1769430917.4606915 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910524, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9f61f30cfd9bc8634c1f92efc997cb3e_188709.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910525, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e175511ceb3823ca91c572c89fe1b253_36077045.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.00565028190612793 Currently in test ! try to remove file 2023/9/1/9f61f30cfd9bc8634c1f92efc997cb3e_188709.jpg from ovh : successful delete the file try to remove file 2023/9/1/e175511ceb3823ca91c572c89fe1b253_36077045.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910524,1203910525) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.491837, desc_s3 : 0:00:00.592225, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910524","1203910525") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.099942684173584 Starting time : 1769430918.5663106 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910583, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/c767ad6e620cefebdc99f7df89cbed01_23254521.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910584, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e0ef039ec3503684a42ae433c0984e33_79802462.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006053924560546875 Currently in test ! try to remove file 2023/9/1/c767ad6e620cefebdc99f7df89cbed01_23254521.jpg from ovh : successful delete the file try to remove file 2023/9/1/e0ef039ec3503684a42ae433c0984e33_79802462.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910583,1203910584) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.652201, desc_s3 : 0:00:01.088856, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910583","1203910584") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.7583224773406982 Starting time : 1769430920.330713 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910585, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/789f0cafa43862b2e3e5ec41ff6a9abe_71158303.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910586, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/02f2f2d0386ceda8f88e06200552f278_14854353.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005576372146606445 Currently in test ! try to remove file 2023/9/1/789f0cafa43862b2e3e5ec41ff6a9abe_71158303.jpg from ovh : successful delete the file try to remove file 2023/9/1/02f2f2d0386ceda8f88e06200552f278_14854353.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910585,1203910586) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.698192, desc_s3 : 0:00:00.501710, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910585","1203910586") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2184324264526367 Starting time : 1769430921.5547485 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910587, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f0a1a91db64d04c4c414406662e8991c_75328365.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910588, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4bdaf07738d9ddb7c90a420bcaa06e71_37095925.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005657196044921875 Currently in test ! try to remove file 2023/9/1/f0a1a91db64d04c4c414406662e8991c_75328365.jpg from ovh : successful delete the file try to remove file 2023/9/1/4bdaf07738d9ddb7c90a420bcaa06e71_37095925.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910587,1203910588) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.539307, desc_s3 : 0:00:00.612325, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910587","1203910588") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1913249492645264 Starting time : 1769430922.7517638 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910637, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/7889e65339289fde78ecf341462fda4c_49018509.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910639, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ef2b0459ebdb54ffff322864e71d86e7_54452523.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.018384933471679688 Currently in test ! try to remove file 2023/9/1/7889e65339289fde78ecf341462fda4c_49018509.jpg from ovh : successful delete the file try to remove file 2023/9/1/ef2b0459ebdb54ffff322864e71d86e7_54452523.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910637,1203910639) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.540543, desc_s3 : 0:00:00.600095, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910637","1203910639") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1574978828430176 Starting time : 1769430923.9276772 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910640, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/85d92b2faef11ad62e0deb2ed203d3df_57381738.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910642, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e0958482a6dc046296508b74ced57fa0_50999370.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005614042282104492 Currently in test ! try to remove file 2023/9/1/85d92b2faef11ad62e0deb2ed203d3df_57381738.jpg from ovh : successful delete the file try to remove file 2023/9/1/e0958482a6dc046296508b74ced57fa0_50999370.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910640,1203910642) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.663310, desc_s3 : 0:00:01.009326, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910640","1203910642") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.6878230571746826 Starting time : 1769430925.621143 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910644, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e9407e5ed527d0645c4c3e81554c10f2_29987552.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910646, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/7047883a9cc110bde898967a9b35172c_11853509.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005562305450439453 Currently in test ! try to remove file 2023/9/1/e9407e5ed527d0645c4c3e81554c10f2_29987552.jpg from ovh : successful delete the file try to remove file 2023/9/1/7047883a9cc110bde898967a9b35172c_11853509.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910644,1203910646) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.617052, desc_s3 : 0:00:00.538340, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910644","1203910646") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1726963520050049 Starting time : 1769430926.7994275 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910697, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f2e747538895a6f88bc679f4cae632b6_91078571.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910698, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8598a2121502ae1595e7f7dfed8cd9a7_55398068.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006879091262817383 Currently in test ! try to remove file 2023/9/1/f2e747538895a6f88bc679f4cae632b6_91078571.jpg from ovh : successful delete the file try to remove file 2023/9/1/8598a2121502ae1595e7f7dfed8cd9a7_55398068.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910697,1203910698) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.749894, desc_s3 : 0:00:00.609469, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910697","1203910698") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3746721744537354 Starting time : 1769430928.1810079 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910699, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e17c92291489580eb1479735f373af25_19092475.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910701, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b8eabe4187e1b612db6021660694b1f4_87580601.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005944728851318359 Currently in test ! try to remove file 2023/9/1/e17c92291489580eb1479735f373af25_19092475.jpg from ovh : successful delete the file try to remove file 2023/9/1/b8eabe4187e1b612db6021660694b1f4_87580601.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910699,1203910701) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.567405, desc_s3 : 0:00:00.547375, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910699","1203910701") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1309995651245117 Starting time : 1769430929.3179805 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910702, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d155fd93067becc1258dca42179c4ef5_62216057.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910799, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/47affb60ed4ef310839e7259674766e4_54935801.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0060367584228515625 Currently in test ! try to remove file 2023/9/1/d155fd93067becc1258dca42179c4ef5_62216057.jpg from ovh : successful delete the file try to remove file 2023/9/1/47affb60ed4ef310839e7259674766e4_54935801.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910702,1203910799) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.641252, desc_s3 : 0:00:00.697185, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910702","1203910799") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3572518825531006 Starting time : 1769430930.6813004 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910801, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/53a84a24741206b74bb2c60ba447fb35_58350865.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910802, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f7d1508efc594a539a8c2ceff7b91144_17224765.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006131410598754883 Currently in test ! try to remove file 2023/9/1/53a84a24741206b74bb2c60ba447fb35_58350865.jpg from ovh : successful delete the file try to remove file 2023/9/1/f7d1508efc594a539a8c2ceff7b91144_17224765.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910801,1203910802) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.449962, desc_s3 : 0:00:00.612420, sql : 0:00:00.000008 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910801","1203910802") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0774493217468262 Starting time : 1769430931.7649121 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910804, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f187d57bd8e35ca5c45385b16beb41af_64436162.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910806, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/79863e219220d1e22bd82a9d91ad6dd9_22202967.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005695819854736328 Currently in test ! try to remove file 2023/9/1/f187d57bd8e35ca5c45385b16beb41af_64436162.jpg from ovh : successful delete the file try to remove file 2023/9/1/79863e219220d1e22bd82a9d91ad6dd9_22202967.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910804,1203910806) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.672142, desc_s3 : 0:00:00.715211, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910804","1203910806") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.406111717224121 Starting time : 1769430933.1767528 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910896, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9bcd2c97d92de458dfb4e6362a8ed551_19193987.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910897, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8796d42aa08156c4ea637e7948327947_8378593.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005615711212158203 Currently in test ! try to remove file 2023/9/1/9bcd2c97d92de458dfb4e6362a8ed551_19193987.jpg from ovh : successful delete the file try to remove file 2023/9/1/8796d42aa08156c4ea637e7948327947_8378593.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910896,1203910897) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.833852, desc_s3 : 0:00:00.614444, sql : 0:00:00.000010 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910896","1203910897") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.4644904136657715 Starting time : 1769430934.646893 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910898, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/980f5f9c8d2fbf6e95a7e39723492c6e_46638973.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910899, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e6dbf10fb1be208bdc4fa6f20b16c40b_73154994.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005803585052490234 Currently in test ! try to remove file 2023/9/1/980f5f9c8d2fbf6e95a7e39723492c6e_46638973.jpg from ovh : successful delete the file try to remove file 2023/9/1/e6dbf10fb1be208bdc4fa6f20b16c40b_73154994.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910898,1203910899) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.787329, desc_s3 : 0:00:00.453568, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910898","1203910899") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2561967372894287 Starting time : 1769430935.9089248 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910965, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5b5c41f913d7779683f01edad6399398_9916666.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910966, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bd2b0c82a6951de65cf5d21656873117_19113601.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005665302276611328 Currently in test ! try to remove file 2023/9/1/5b5c41f913d7779683f01edad6399398_9916666.jpg from ovh : successful delete the file try to remove file 2023/9/1/bd2b0c82a6951de65cf5d21656873117_19113601.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910965,1203910966) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.694974, desc_s3 : 0:00:00.481159, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910965","1203910966") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1931920051574707 Starting time : 1769430937.1078095 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910967, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d55f8d4a25c21fe14ac3ddb3f2ff589e_52339287.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910968, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/99b62eaec35ac45fb887a8dcd7f3f817_89984417.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0058443546295166016 Currently in test ! try to remove file 2023/9/1/d55f8d4a25c21fe14ac3ddb3f2ff589e_52339287.jpg from ovh : successful delete the file try to remove file 2023/9/1/99b62eaec35ac45fb887a8dcd7f3f817_89984417.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910967,1203910968) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.619237, desc_s3 : 0:00:00.759606, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910967","1203910968") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3941917419433594 Starting time : 1769430938.507873 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910969, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/267620b01c20aeac8e8f3539e9812436_86678479.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910970, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/05259cdfc9f0ea326c42125188695c21_24813336.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005855560302734375 Currently in test ! try to remove file 2023/9/1/267620b01c20aeac8e8f3539e9812436_86678479.jpg from ovh : successful delete the file try to remove file 2023/9/1/05259cdfc9f0ea326c42125188695c21_24813336.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910969,1203910970) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.489036, desc_s3 : 0:00:00.864281, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910969","1203910970") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3691380023956299 Starting time : 1769430939.882894 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910975, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a6e46fe477998508790e7d21348d6787_46132881.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910976, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/803180f5e5e71a95ae2f9deea5f55f51_84401492.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005867958068847656 Currently in test ! try to remove file 2023/9/1/a6e46fe477998508790e7d21348d6787_46132881.jpg from ovh : successful delete the file try to remove file 2023/9/1/803180f5e5e71a95ae2f9deea5f55f51_84401492.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910975,1203910976) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.606196, desc_s3 : 0:00:00.704995, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910975","1203910976") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.328035831451416 Starting time : 1769430941.2168252 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203910978, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/34d957debd2bdde5dc2f7ceb662e80f7_90299075.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203910979, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d45fbff054d411a371c632b1aec6c8d4_95125994.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005923271179199219 Currently in test ! try to remove file 2023/9/1/34d957debd2bdde5dc2f7ceb662e80f7_90299075.jpg from ovh : successful delete the file try to remove file 2023/9/1/d45fbff054d411a371c632b1aec6c8d4_95125994.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203910978,1203910979) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.501235, desc_s3 : 0:00:00.510152, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203910978","1203910979") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0271437168121338 Starting time : 1769430942.2499223 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911052, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4a93431b33a6d1d19fb65ceec96b0c7a_93239064.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911053, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/331dd7768ce17d3b7f432d6e54daf169_32959285.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006135225296020508 Currently in test ! try to remove file 2023/9/1/4a93431b33a6d1d19fb65ceec96b0c7a_93239064.jpg from ovh : successful delete the file try to remove file 2023/9/1/331dd7768ce17d3b7f432d6e54daf169_32959285.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911052,1203911053) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.829930, desc_s3 : 0:00:00.523230, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911052","1203911053") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3706722259521484 Starting time : 1769430943.6267602 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911054, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/dc483e6d10be0c454f07cd9e92dec31e_48708398.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911055, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/c5b79e0ebafb3d3c984a81c74ac7a0c0_3473193.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005853414535522461 Currently in test ! try to remove file 2023/9/1/dc483e6d10be0c454f07cd9e92dec31e_48708398.jpg from ovh : successful delete the file try to remove file 2023/9/1/c5b79e0ebafb3d3c984a81c74ac7a0c0_3473193.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911054,1203911055) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.463216, desc_s3 : 0:00:00.575127, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911054","1203911055") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.055931568145752 Starting time : 1769430944.688573 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911056, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b7b851c8e54943ba501dc468f26e3de1_65841083.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911057, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/00b0a806f27a02a7c3e7b8f66ecd23b7_66044445.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005975484848022461 Currently in test ! try to remove file 2023/9/1/b7b851c8e54943ba501dc468f26e3de1_65841083.jpg from ovh : successful delete the file try to remove file 2023/9/1/00b0a806f27a02a7c3e7b8f66ecd23b7_66044445.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911056,1203911057) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.575835, desc_s3 : 0:00:00.689154, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911056","1203911057") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2807443141937256 Starting time : 1769430945.9753199 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911061, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b780c551629bdd40b82fa6ea0afe1d7d_57315290.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911062, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/66f3249b3af2d6295443c9350fea8c10_73462653.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005829811096191406 Currently in test ! try to remove file 2023/9/1/b780c551629bdd40b82fa6ea0afe1d7d_57315290.jpg from ovh : successful delete the file try to remove file 2023/9/1/66f3249b3af2d6295443c9350fea8c10_73462653.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911061,1203911062) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.683480, desc_s3 : 0:00:00.613085, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911061","1203911062") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3123481273651123 Starting time : 1769430947.2935247 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911063, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6c49afe3422b4de01576c16c8e257323_50369822.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911064, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/7ad0c0624a4369b06285c2c0b861fa8b_38200156.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005858421325683594 Currently in test ! try to remove file 2023/9/1/6c49afe3422b4de01576c16c8e257323_50369822.jpg from ovh : successful delete the file try to remove file 2023/9/1/7ad0c0624a4369b06285c2c0b861fa8b_38200156.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911063,1203911064) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.642090, desc_s3 : 0:00:00.521708, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911063","1203911064") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.179086685180664 Starting time : 1769430948.478497 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911065, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/623cd584dd4e4c3f56a8d5883daccc05_42737608.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911066, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ae21d348198f46f163eb1c25ffb747ff_15336246.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006061553955078125 Currently in test ! try to remove file 2023/9/1/623cd584dd4e4c3f56a8d5883daccc05_42737608.jpg from ovh : successful delete the file try to remove file 2023/9/1/ae21d348198f46f163eb1c25ffb747ff_15336246.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911065,1203911066) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.986493, desc_s3 : 0:00:00.630975, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911065","1203911066") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.6339805126190186 Starting time : 1769430950.1185653 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911131, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/be64b0cd878d507fd1bd32bc00acd978_60932096.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911132, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/de079450c535e2192235fa038ce50497_7943574.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007043361663818359 Currently in test ! try to remove file 2023/9/1/be64b0cd878d507fd1bd32bc00acd978_60932096.jpg from ovh : successful delete the file try to remove file 2023/9/1/de079450c535e2192235fa038ce50497_7943574.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911131,1203911132) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.626852, desc_s3 : 0:00:00.529988, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911131","1203911132") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1737477779388428 Starting time : 1769430951.2993839 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911133, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/1b23bceaced70cb7951a2258d7d82b5f_96283773.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911134, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6b53b7c423cfbcf48cc5961551cf009f_90925468.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005666494369506836 Currently in test ! try to remove file 2023/9/1/1b23bceaced70cb7951a2258d7d82b5f_96283773.jpg from ovh : successful delete the file try to remove file 2023/9/1/6b53b7c423cfbcf48cc5961551cf009f_90925468.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911133,1203911134) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.456522, desc_s3 : 0:00:00.539069, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911133","1203911134") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0112569332122803 Starting time : 1769430952.3163342 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911135, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/fd2c1c601542e02d4144882706f955f9_36005619.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911136, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/afad91bc898fb4b7260b28b40023fb2e_46127175.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006196260452270508 Currently in test ! try to remove file 2023/9/1/fd2c1c601542e02d4144882706f955f9_36005619.jpg from ovh : successful delete the file try to remove file 2023/9/1/afad91bc898fb4b7260b28b40023fb2e_46127175.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911135,1203911136) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.623022, desc_s3 : 0:00:00.623441, sql : 0:00:00.000010 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911135","1203911136") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.261685848236084 Starting time : 1769430953.5842628 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911175, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4eda87f3fe9003de31bb45904a5aa6f4_88348329.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911176, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/22da4d59143ab6d221546fe87224a399_12140856.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006212472915649414 Currently in test ! try to remove file 2023/9/1/4eda87f3fe9003de31bb45904a5aa6f4_88348329.jpg from ovh : successful delete the file try to remove file 2023/9/1/22da4d59143ab6d221546fe87224a399_12140856.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911175,1203911176) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.695478, desc_s3 : 0:00:00.677753, sql : 0:00:00.000009 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911175","1203911176") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3899569511413574 Starting time : 1769430954.9804692 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911177, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/be3eae1b7ecd265e5b0eb8f9f5d87411_54392406.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911178, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e962ca9cf1a2c4e4e0ff350cefda1224_84711952.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.00604557991027832 Currently in test ! try to remove file 2023/9/1/be3eae1b7ecd265e5b0eb8f9f5d87411_54392406.jpg from ovh : successful delete the file try to remove file 2023/9/1/e962ca9cf1a2c4e4e0ff350cefda1224_84711952.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911177,1203911178) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.588819, desc_s3 : 0:00:00.480824, sql : 0:00:00.000017 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911177","1203911178") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0877716541290283 Starting time : 1769430956.0743504 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911179, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e8bd672daaa057f51c3e1998238005b3_47308090.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911181, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/7fd4cc1fce49cfb83d3be76eee433ea2_13652703.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006233692169189453 Currently in test ! try to remove file 2023/9/1/e8bd672daaa057f51c3e1998238005b3_47308090.jpg from ovh : successful delete the file try to remove file 2023/9/1/7fd4cc1fce49cfb83d3be76eee433ea2_13652703.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911179,1203911181) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.681358, desc_s3 : 0:00:00.538411, sql : 0:00:00.000010 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911179","1203911181") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.23683500289917 Starting time : 1769430957.3174646 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911229, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8bec7498682ab3ddee6ebaaa1aeabce9_12441343.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911230, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ab836de73027975200bfa389cf83f7e1_44035503.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.005927562713623047 Currently in test ! try to remove file 2023/9/1/8bec7498682ab3ddee6ebaaa1aeabce9_12441343.jpg from ovh : successful delete the file try to remove file 2023/9/1/ab836de73027975200bfa389cf83f7e1_44035503.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911229,1203911230) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.490204, desc_s3 : 0:00:00.619179, sql : 0:00:00.000009 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911229","1203911230") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1261382102966309 Starting time : 1769430958.4495716 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911231, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8b767d775a837b59535cb4076612bbd7_79814137.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911232, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9ba3ca3910c08ffe1814c3765b83ce9f_76550254.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006946563720703125 Currently in test ! try to remove file 2023/9/1/8b767d775a837b59535cb4076612bbd7_79814137.jpg from ovh : successful delete the file try to remove file 2023/9/1/9ba3ca3910c08ffe1814c3765b83ce9f_76550254.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911231,1203911232) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.533097, desc_s3 : 0:00:00.563027, sql : 0:00:00.000009 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911231","1203911232") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1128168106079102 Starting time : 1769430959.5693796 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911233, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/3955218a08e002a60f3dc2884a0017b0_83414517.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911234, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8bcdb8fcd330378d6fafb5f47ebebf37_46318343.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006025552749633789 Currently in test ! try to remove file 2023/9/1/3955218a08e002a60f3dc2884a0017b0_83414517.jpg from ovh : successful delete the file try to remove file 2023/9/1/8bcdb8fcd330378d6fafb5f47ebebf37_46318343.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911233,1203911234) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.612992, desc_s3 : 0:00:00.534410, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911233","1203911234") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1649057865142822 Starting time : 1769430960.7403388 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911249, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2f8550e9d067f760facba660dbda2478_92910003.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911367, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2e5693024de9b9d3503cfc2b1e624675_31836360.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0062448978424072266 Currently in test ! try to remove file 2023/9/1/2f8550e9d067f760facba660dbda2478_92910003.jpg from ovh : successful delete the file try to remove file 2023/9/1/2e5693024de9b9d3503cfc2b1e624675_31836360.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911249,1203911367) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.540682, desc_s3 : 0:00:00.465324, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911249","1203911367") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0236725807189941 Starting time : 1769430961.7702935 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911368, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8bc873ea3990410a7ab9cc13c45f6b46_7765089.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911370, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a215e5b984e93c5f7fe10e17a69f45bb_73728565.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006132841110229492 Currently in test ! try to remove file 2023/9/1/8bc873ea3990410a7ab9cc13c45f6b46_7765089.jpg from ovh : successful delete the file try to remove file 2023/9/1/a215e5b984e93c5f7fe10e17a69f45bb_73728565.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911368,1203911370) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.501101, desc_s3 : 0:00:00.690903, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911368","1203911370") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.206770658493042 Starting time : 1769430962.9832246 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911371, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2dc8ff71153021565a8fb0054c1fd202_75454668.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911376, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/109f7f10c52347bee896e57f7136302f_71861912.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006220340728759766 Currently in test ! try to remove file 2023/9/1/2dc8ff71153021565a8fb0054c1fd202_75454668.jpg from ovh : successful delete the file try to remove file 2023/9/1/109f7f10c52347bee896e57f7136302f_71861912.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911371,1203911376) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.474562, desc_s3 : 0:00:00.529944, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911371","1203911376") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0218541622161865 Starting time : 1769430964.0113266 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911378, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/60e339079916fa9591ec6e4d84a12a80_21921478.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911406, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/37d9fe9f55a0969709eb5351e26f580c_85060178.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0061337947845458984 Currently in test ! try to remove file 2023/9/1/60e339079916fa9591ec6e4d84a12a80_21921478.jpg from ovh : successful delete the file try to remove file 2023/9/1/37d9fe9f55a0969709eb5351e26f580c_85060178.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911378,1203911406) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.602686, desc_s3 : 0:00:00.540686, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911378","1203911406") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1599271297454834 Starting time : 1769430965.1774142 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911496, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/46242aa7d09d777b6e331df9881f4164_74900386.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911497, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ebae4d9934ce44190a94f92c9914dec1_26310165.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006351947784423828 Currently in test ! try to remove file 2023/9/1/46242aa7d09d777b6e331df9881f4164_74900386.jpg from ovh : successful delete the file try to remove file 2023/9/1/ebae4d9934ce44190a94f92c9914dec1_26310165.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911496,1203911497) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.500177, desc_s3 : 0:00:00.856136, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911496","1203911497") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3745317459106445 Starting time : 1769430966.5583265 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911498, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5d0f98462790bb27d42ed16c89388175_40199535.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911499, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/3889b9caa8fd8f9ac6e7d9f5c0f9ab0b_24852116.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006074428558349609 Currently in test ! try to remove file 2023/9/1/5d0f98462790bb27d42ed16c89388175_40199535.jpg from ovh : successful delete the file try to remove file 2023/9/1/3889b9caa8fd8f9ac6e7d9f5c0f9ab0b_24852116.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911498,1203911499) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.502226, desc_s3 : 0:00:00.728322, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911498","1203911499") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.244856357574463 Starting time : 1769430967.8092856 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911501, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b3ede5da09cf145a4415aee295a5a138_84508059.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911552, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/99deff25ed2f87c19a46b830aeae4585_31387565.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0067560672760009766 Currently in test ! try to remove file 2023/9/1/b3ede5da09cf145a4415aee295a5a138_84508059.jpg from ovh : successful delete the file try to remove file 2023/9/1/99deff25ed2f87c19a46b830aeae4585_31387565.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911501,1203911552) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.571524, desc_s3 : 0:00:00.588322, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911501","1203911552") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1765429973602295 Starting time : 1769430968.9926121 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911553, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/527d98dec8e16d07447138e490db9853_88636706.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911554, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/08ae65476528826721e1330a72c313bd_10599534.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006804466247558594 Currently in test ! try to remove file 2023/9/1/527d98dec8e16d07447138e490db9853_88636706.jpg from ovh : successful delete the file try to remove file 2023/9/1/08ae65476528826721e1330a72c313bd_10599534.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911553,1203911554) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.486296, desc_s3 : 0:00:00.594338, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911553","1203911554") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0970017910003662 Starting time : 1769430970.0964472 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203911714, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/56b6d32f4081e0bf59d61a4464c53c3d_44355824.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203911715, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/528a224ceba663165ead199fef8d61f6_43077541.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006283760070800781 Currently in test ! try to remove file 2023/9/1/56b6d32f4081e0bf59d61a4464c53c3d_44355824.jpg from ovh : successful delete the file try to remove file 2023/9/1/528a224ceba663165ead199fef8d61f6_43077541.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203911714,1203911715) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.695702, desc_s3 : 0:00:00.461357, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203911714","1203911715") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1734697818756104 Starting time : 1769430971.2762299 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912543, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e758d1a94d679b4096b81c36f2470b1f_46189425.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912544, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b7d6b2ef2c410596d2aaa79bcd4bd063_48741742.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006218433380126953 Currently in test ! try to remove file 2023/9/1/e758d1a94d679b4096b81c36f2470b1f_46189425.jpg from ovh : successful delete the file try to remove file 2023/9/1/b7d6b2ef2c410596d2aaa79bcd4bd063_48741742.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912543,1203912544) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.580357, desc_s3 : 0:00:00.666424, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912543","1203912544") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2638096809387207 Starting time : 1769430972.546298 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912545, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d8fcd8695a70beff31c576a3f2a79f3e_42646137.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912546, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5992e2f964691be5de90fb033f521d30_22072779.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006053447723388672 Currently in test ! try to remove file 2023/9/1/d8fcd8695a70beff31c576a3f2a79f3e_42646137.jpg from ovh : successful delete the file try to remove file 2023/9/1/5992e2f964691be5de90fb033f521d30_22072779.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912545,1203912546) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.740980, desc_s3 : 0:00:00.690182, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912545","1203912546") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.4479608535766602 Starting time : 1769430974.000346 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912547, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/09ce8b4570e7bbd62812b8cf4caa8dcb_79968145.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912548, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5f95215106f86f7eda3d704adc4154ec_14118745.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006113529205322266 Currently in test ! try to remove file 2023/9/1/09ce8b4570e7bbd62812b8cf4caa8dcb_79968145.jpg from ovh : successful delete the file try to remove file 2023/9/1/5f95215106f86f7eda3d704adc4154ec_14118745.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912547,1203912548) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.852187, desc_s3 : 0:00:00.993743, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912547","1203912548") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.8628249168395996 Starting time : 1769430975.8693116 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912586, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/94ce5d92717a7d991c31d368315ba40d_63398385.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912587, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/fd09e4a936d38db6be15ae7eaee7a7d5_91355751.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.6300637722015381 Currently in test ! try to remove file 2023/9/1/94ce5d92717a7d991c31d368315ba40d_63398385.jpg from ovh : successful delete the file try to remove file 2023/9/1/fd09e4a936d38db6be15ae7eaee7a7d5_91355751.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912586,1203912587) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.682202, desc_s3 : 0:00:00.700785, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912586","1203912587") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3999059200286865 Starting time : 1769430977.899313 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912723, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5956a35ec8a57b22f7b78ea153c91e1d_8207868.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912724, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ec15b6a1621f27e50139555104c3f238_58440278.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0065958499908447266 Currently in test ! try to remove file 2023/9/1/5956a35ec8a57b22f7b78ea153c91e1d_8207868.jpg from ovh : successful delete the file try to remove file 2023/9/1/ec15b6a1621f27e50139555104c3f238_58440278.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912723,1203912724) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.549025, desc_s3 : 0:00:00.845192, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912723","1203912724") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.4094765186309814 Starting time : 1769430979.3154128 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912731, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e23c9d4dcc4aa66c4c638cde6f4b9240_64284942.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912733, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/7088d51a4a48f8bfdc00b10ad653d821_73313776.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006497621536254883 Currently in test ! try to remove file 2023/9/1/e23c9d4dcc4aa66c4c638cde6f4b9240_64284942.jpg from ovh : successful delete the file try to remove file 2023/9/1/7088d51a4a48f8bfdc00b10ad653d821_73313776.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912731,1203912733) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.482294, desc_s3 : 0:00:00.744199, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912731","1203912733") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2403919696807861 Starting time : 1769430980.56233 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912738, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/efbaf65a830e8b6e30c5eb99dfa9ed9a_14172347.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912739, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/729e6d4d60018c2fecccb444f13839e8_50112083.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006439924240112305 Currently in test ! try to remove file 2023/9/1/efbaf65a830e8b6e30c5eb99dfa9ed9a_14172347.jpg from ovh : successful delete the file try to remove file 2023/9/1/729e6d4d60018c2fecccb444f13839e8_50112083.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912738,1203912739) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.495956, desc_s3 : 0:00:00.471172, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912738","1203912739") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 0.9834692478179932 Starting time : 1769430981.5522647 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912784, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/db3f1132dfe6292ea239728c87500865_29489161.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912785, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f7d267f9a961ba7cf32e2e01d09cafad_93306851.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0063703060150146484 Currently in test ! try to remove file 2023/9/1/db3f1132dfe6292ea239728c87500865_29489161.jpg from ovh : successful delete the file try to remove file 2023/9/1/f7d267f9a961ba7cf32e2e01d09cafad_93306851.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912784,1203912785) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.629359, desc_s3 : 0:00:00.759596, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912784","1203912785") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.439911127090454 Starting time : 1769430982.9985757 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912786, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e6768c872012b8d101f928073121e8d6_36778904.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912787, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8e797d9123461bc1737dccf59b45de52_88751436.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.024852991104125977 Currently in test ! try to remove file 2023/9/1/e6768c872012b8d101f928073121e8d6_36778904.jpg from ovh : successful delete the file try to remove file 2023/9/1/8e797d9123461bc1737dccf59b45de52_88751436.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912786,1203912787) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.530269, desc_s3 : 0:00:00.600541, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912786","1203912787") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.145923137664795 Starting time : 1769430984.1693823 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912788, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/1cb0b773f7019b4c1f52a71f4a1d8d1a_55855382.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912789, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9687e7de6b2cda361d54b399a77ecfb9_59454978.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0063173770904541016 Currently in test ! try to remove file 2023/9/1/1cb0b773f7019b4c1f52a71f4a1d8d1a_55855382.jpg from ovh : successful delete the file try to remove file 2023/9/1/9687e7de6b2cda361d54b399a77ecfb9_59454978.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912788,1203912789) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.428745, desc_s3 : 0:00:00.432963, sql : 0:00:00.000008 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912788","1203912789") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 0.8786697387695312 Starting time : 1769430985.054408 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912865, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ccfae24e1314aacbcadd9c53d83cf9ae_90111954.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912866, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/95d31e53554eb08193d537b543c35dbb_30225548.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006644487380981445 Currently in test ! try to remove file 2023/9/1/ccfae24e1314aacbcadd9c53d83cf9ae_90111954.jpg from ovh : successful delete the file try to remove file 2023/9/1/95d31e53554eb08193d537b543c35dbb_30225548.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912865,1203912866) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.695757, desc_s3 : 0:00:00.537956, sql : 0:00:00.000008 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912865","1203912866") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2511732578277588 Starting time : 1769430986.3122597 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912867, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/dabfc5357c31ecb170b3d576b0de3f3c_46411738.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912868, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/69a564b5061b68de868a05b16dc89228_95595532.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006585121154785156 Currently in test ! try to remove file 2023/9/1/dabfc5357c31ecb170b3d576b0de3f3c_46411738.jpg from ovh : successful delete the file try to remove file 2023/9/1/69a564b5061b68de868a05b16dc89228_95595532.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912867,1203912868) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.573945, desc_s3 : 0:00:00.659665, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912867","1203912868") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2476980686187744 Starting time : 1769430987.5665808 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912869, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9b94b16c18aa21ffe9b0f2cfd813484c_96133256.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912870, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/00301393028e3a4e30e4658a02e153af_19656213.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.00743865966796875 Currently in test ! try to remove file 2023/9/1/9b94b16c18aa21ffe9b0f2cfd813484c_96133256.jpg from ovh : successful delete the file try to remove file 2023/9/1/00301393028e3a4e30e4658a02e153af_19656213.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912869,1203912870) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.521242, desc_s3 : 0:00:00.691697, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912869","1203912870") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2282180786132812 Starting time : 1769430988.8022914 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912873, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2637851be54fbc7496b05afbb7020029_94340721.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912875, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/c7cc75b138baef8fe352f19cba296bf4_22625252.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006493091583251953 Currently in test ! try to remove file 2023/9/1/2637851be54fbc7496b05afbb7020029_94340721.jpg from ovh : successful delete the file try to remove file 2023/9/1/c7cc75b138baef8fe352f19cba296bf4_22625252.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912873,1203912875) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.524218, desc_s3 : 0:00:00.464912, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912873","1203912875") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0063772201538086 Starting time : 1769430989.8151948 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912877, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4bc7769705f69b046089353b140aec68_1369671.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912935, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9717749695ba5c94846aa08734438e9f_79133069.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0064525604248046875 Currently in test ! try to remove file 2023/9/1/4bc7769705f69b046089353b140aec68_1369671.jpg from ovh : successful delete the file try to remove file 2023/9/1/9717749695ba5c94846aa08734438e9f_79133069.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912877,1203912935) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.471022, desc_s3 : 0:00:00.707316, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912877","1203912935") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.193650722503662 Starting time : 1769430991.0153341 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912936, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/af24732b41c76210cf8a78cc13390451_69533071.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912937, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a960bddb2396f7aa31aa43a663d4fbd9_56198503.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006891489028930664 Currently in test ! try to remove file 2023/9/1/af24732b41c76210cf8a78cc13390451_69533071.jpg from ovh : successful delete the file try to remove file 2023/9/1/a960bddb2396f7aa31aa43a663d4fbd9_56198503.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912936,1203912937) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.560683, desc_s3 : 0:00:00.576270, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912936","1203912937") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1551549434661865 Starting time : 1769430992.1774147 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912938, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8f598c35bdb83a4ba70e9a3be8a3fdda_10971427.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912939, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/60cff3b71c8f7193a3b93d79333675d5_528092.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006603717803955078 Currently in test ! try to remove file 2023/9/1/8f598c35bdb83a4ba70e9a3be8a3fdda_10971427.jpg from ovh : successful delete the file try to remove file 2023/9/1/60cff3b71c8f7193a3b93d79333675d5_528092.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912938,1203912939) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.517372, desc_s3 : 0:00:00.589734, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912938","1203912939") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1235270500183105 Starting time : 1769430993.3075721 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912940, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/aa764159e308b6f3bbcc240ba361780f_21738856.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912959, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5b6407bb67ad7df259ea4748b765afe9_55032811.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006949186325073242 Currently in test ! try to remove file 2023/9/1/aa764159e308b6f3bbcc240ba361780f_21738856.jpg from ovh : successful delete the file try to remove file 2023/9/1/5b6407bb67ad7df259ea4748b765afe9_55032811.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912940,1203912959) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.586687, desc_s3 : 0:00:00.500339, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912940","1203912959") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1009984016418457 Starting time : 1769430994.4155502 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912967, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/19f9080dc3709307df6aaf698432a017_65016078.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912968, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/29ea45537c4e827e09b964f0cec79d2d_83165648.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006460905075073242 Currently in test ! try to remove file 2023/9/1/19f9080dc3709307df6aaf698432a017_65016078.jpg from ovh : successful delete the file try to remove file 2023/9/1/29ea45537c4e827e09b964f0cec79d2d_83165648.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912967,1203912968) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.445437, desc_s3 : 0:00:00.454519, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912967","1203912968") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 0.9189119338989258 Starting time : 1769430995.3409529 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912969, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/444a7eccfc2b4d41f4df2d7644a7dd3e_46095815.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912970, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/02780bf996799ad943e360b2ebd9a7c5_29067077.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007572174072265625 Currently in test ! try to remove file 2023/9/1/444a7eccfc2b4d41f4df2d7644a7dd3e_46095815.jpg from ovh : successful delete the file try to remove file 2023/9/1/02780bf996799ad943e360b2ebd9a7c5_29067077.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912969,1203912970) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.637281, desc_s3 : 0:00:00.601329, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912969","1203912970") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2549941539764404 Starting time : 1769430996.6035476 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912971, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/3f1c3eb1eeafe3bea62ef72719c22c78_33019748.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912972, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8a9a4f1028e9633f2a38541c33824fb3_89007776.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0068438053131103516 Currently in test ! try to remove file 2023/9/1/3f1c3eb1eeafe3bea62ef72719c22c78_33019748.jpg from ovh : successful delete the file try to remove file 2023/9/1/8a9a4f1028e9633f2a38541c33824fb3_89007776.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912971,1203912972) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.716320, desc_s3 : 0:00:00.641093, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912971","1203912972") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3749938011169434 Starting time : 1769430997.985413 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912974, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f20a7a1d3337df23ce25ec31f2091dc8_68990562.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912975, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d3d8a58f282ebae5425619618c626cec_33928906.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.008199930191040039 Currently in test ! try to remove file 2023/9/1/f20a7a1d3337df23ce25ec31f2091dc8_68990562.jpg from ovh : successful delete the file try to remove file 2023/9/1/d3d8a58f282ebae5425619618c626cec_33928906.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912974,1203912975) failed to delete the file, maybe something wrong : 5680.1203912974.desc deleted 2 pictures from base. timer : photo_s3 : 0:00:00.625071, desc_s3 : 0:00:01.077306, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912974","1203912975") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.7174363136291504 Starting time : 1769430999.7110784 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912976, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/db131d4fa3621fa9f57d3a51109ee518_70554203.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912977, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d105b44b2ccb5b705ebdee838b908360_26947585.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006643533706665039 Currently in test ! try to remove file 2023/9/1/db131d4fa3621fa9f57d3a51109ee518_70554203.jpg from ovh : successful delete the file try to remove file 2023/9/1/d105b44b2ccb5b705ebdee838b908360_26947585.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912976,1203912977) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.460416, desc_s3 : 0:00:00.693067, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912976","1203912977") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1674566268920898 Starting time : 1769431000.8852088 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203912978, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/44d2a3cc115810d5f4e05bd7362c948e_60080513.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203912979, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ce25250cb9e950b51669874ee31b5bff_69890573.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0064542293548583984 Currently in test ! try to remove file 2023/9/1/44d2a3cc115810d5f4e05bd7362c948e_60080513.jpg from ovh : successful delete the file try to remove file 2023/9/1/ce25250cb9e950b51669874ee31b5bff_69890573.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203912978,1203912979) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.634565, desc_s3 : 0:00:00.518272, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203912978","1203912979") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1720249652862549 Starting time : 1769431002.0637162 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913056, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ac409d4b1b0b504cbc6936b087c031c7_12662918.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913057, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/3a7aee03e6acc0aa5efd1a407fdfe062_45030021.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.009517908096313477 Currently in test ! try to remove file 2023/9/1/ac409d4b1b0b504cbc6936b087c031c7_12662918.jpg from ovh : successful delete the file try to remove file 2023/9/1/3a7aee03e6acc0aa5efd1a407fdfe062_45030021.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913056,1203913057) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.525798, desc_s3 : 0:00:00.771940, sql : 0:00:00.000008 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913056","1203913057") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3146181106567383 Starting time : 1769431003.3878849 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913059, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/9bd8ef407a676269f46320d2e94c0353_17435210.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913061, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/67e716a19dd6375f778acacd5c9cf4be_39550150.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006583213806152344 Currently in test ! try to remove file 2023/9/1/9bd8ef407a676269f46320d2e94c0353_17435210.jpg from ovh : successful delete the file try to remove file 2023/9/1/67e716a19dd6375f778acacd5c9cf4be_39550150.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913059,1203913061) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.702059, desc_s3 : 0:00:00.656124, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913059","1203913061") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3751626014709473 Starting time : 1769431004.7696621 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913062, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6eb85b50d06ae60573ab3319df1b6b97_4202931.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913063, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/59271646c99c39a8c6f08bf941f63ad0_15003650.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006741523742675781 Currently in test ! try to remove file 2023/9/1/6eb85b50d06ae60573ab3319df1b6b97_4202931.jpg from ovh : successful delete the file try to remove file 2023/9/1/59271646c99c39a8c6f08bf941f63ad0_15003650.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913062,1203913063) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.759454, desc_s3 : 0:00:00.643467, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913062","1203913063") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.4184186458587646 Starting time : 1769431006.19485 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913068, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a463bd8c628968c6282a7b3bfe755e96_63070271.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913069, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b011ccb3964d43b26ed30289c003f53c_2736910.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0076215267181396484 Currently in test ! try to remove file 2023/9/1/a463bd8c628968c6282a7b3bfe755e96_63070271.jpg from ovh : successful delete the file try to remove file 2023/9/1/b011ccb3964d43b26ed30289c003f53c_2736910.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913068,1203913069) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.505913, desc_s3 : 0:00:00.682094, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913068","1203913069") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2031090259552002 Starting time : 1769431007.4056082 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913070, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/de7ba22bb52ea0bace418c2e5c907e7d_14979340.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913071, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b3bb0e309c7ce236614bb96c12318a9f_6166740.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006421327590942383 Currently in test ! try to remove file 2023/9/1/de7ba22bb52ea0bace418c2e5c907e7d_14979340.jpg from ovh : successful delete the file try to remove file 2023/9/1/b3bb0e309c7ce236614bb96c12318a9f_6166740.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913070,1203913071) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.464087, desc_s3 : 0:00:00.665784, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913070","1203913071") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1442229747772217 Starting time : 1769431008.5562847 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913072, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b1884bb5256c33dcd0a2004ff48cc24c_20979222.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913079, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/c548e9c9b0fee82d6bb16a2b8c46891d_60879612.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006275177001953125 Currently in test ! try to remove file 2023/9/1/b1884bb5256c33dcd0a2004ff48cc24c_20979222.jpg from ovh : successful delete the file try to remove file 2023/9/1/c548e9c9b0fee82d6bb16a2b8c46891d_60879612.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913072,1203913079) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.513259, desc_s3 : 0:00:00.831150, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913072","1203913079") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3594684600830078 Starting time : 1769431009.9220629 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913080, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4bc19b5bbcae2aabd419342df63b18bb_64079114.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913081, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/958c73efe52457c05301808d8aa14aff_61454570.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006173610687255859 Currently in test ! try to remove file 2023/9/1/4bc19b5bbcae2aabd419342df63b18bb_64079114.jpg from ovh : successful delete the file try to remove file 2023/9/1/958c73efe52457c05301808d8aa14aff_61454570.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913080,1203913081) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.557047, desc_s3 : 0:00:00.700244, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913080","1203913081") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2750484943389893 Starting time : 1769431011.2033134 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913082, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a9775ac91f329906d68ed0e4acaeee00_30122680.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913083, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b88eee692a824582ccec1260db9abeec_4112588.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006481170654296875 Currently in test ! try to remove file 2023/9/1/a9775ac91f329906d68ed0e4acaeee00_30122680.jpg from ovh : successful delete the file try to remove file 2023/9/1/b88eee692a824582ccec1260db9abeec_4112588.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913082,1203913083) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.796346, desc_s3 : 0:00:00.749853, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913082","1203913083") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.5623993873596191 Starting time : 1769431012.7722225 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913084, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/1a67ef56992c8aa56874da7192e24eac_91822268.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913088, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bbbcf334573c20df078f4533cb59a685_54353610.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006372928619384766 Currently in test ! try to remove file 2023/9/1/1a67ef56992c8aa56874da7192e24eac_91822268.jpg from ovh : successful delete the file try to remove file 2023/9/1/bbbcf334573c20df078f4533cb59a685_54353610.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913084,1203913088) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.685178, desc_s3 : 0:00:00.436659, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913084","1203913088") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1406095027923584 Starting time : 1769431013.919236 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913089, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/17e56cfa3c6a0ca8d68d7cb4d98100de_49959200.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913090, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/0edae665b56f196a92f7c6a9f537a512_77615588.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007025480270385742 Currently in test ! try to remove file 2023/9/1/17e56cfa3c6a0ca8d68d7cb4d98100de_49959200.jpg from ovh : successful delete the file try to remove file 2023/9/1/0edae665b56f196a92f7c6a9f537a512_77615588.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913089,1203913090) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.617182, desc_s3 : 0:00:00.706957, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913089","1203913090") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3419034481048584 Starting time : 1769431015.268197 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913097, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/886e1c3c35bec40e829d8688e75d9592_22114598.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913098, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/36fb344a3bab578174b39312fb9a230d_48451558.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006855010986328125 Currently in test ! try to remove file 2023/9/1/886e1c3c35bec40e829d8688e75d9592_22114598.jpg from ovh : successful delete the file try to remove file 2023/9/1/36fb344a3bab578174b39312fb9a230d_48451558.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913097,1203913098) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.494294, desc_s3 : 0:00:00.490434, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913097","1203913098") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0013139247894287 Starting time : 1769431016.276394 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913099, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/761ff201613496fadfe7955239c10547_86484072.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913101, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/305170bdcda83e837cb9b184c03e847a_62749997.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007668018341064453 Currently in test ! try to remove file 2023/9/1/761ff201613496fadfe7955239c10547_86484072.jpg from ovh : successful delete the file try to remove file 2023/9/1/305170bdcda83e837cb9b184c03e847a_62749997.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913099,1203913101) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.562360, desc_s3 : 0:00:00.571865, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913099","1203913101") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.149071455001831 Starting time : 1769431017.433161 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913102, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bcb40eaa6e3b2976dbabebdb9a68bf5e_17531411.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913110, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6c64602c3c50613c9499ce4c6c9f3f17_75930408.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006770610809326172 Currently in test ! try to remove file 2023/9/1/bcb40eaa6e3b2976dbabebdb9a68bf5e_17531411.jpg from ovh : successful delete the file try to remove file 2023/9/1/6c64602c3c50613c9499ce4c6c9f3f17_75930408.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913102,1203913110) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.889435, desc_s3 : 0:00:00.641336, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913102","1203913110") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.5490520000457764 Starting time : 1769431018.9890137 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913111, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/db394ddf6623aa6c9bed1b921ebd0d8b_46019527.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913185, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f37e828f54f0d9c35d6ca01c9d4ac8de_20335570.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0067615509033203125 Currently in test ! try to remove file 2023/9/1/db394ddf6623aa6c9bed1b921ebd0d8b_46019527.jpg from ovh : successful delete the file try to remove file 2023/9/1/f37e828f54f0d9c35d6ca01c9d4ac8de_20335570.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913111,1203913185) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.512473, desc_s3 : 0:00:00.612030, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913111","1203913185") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.139394998550415 Starting time : 1769431020.1352017 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913186, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/21e81aa87a46d0e87b355961bc8a336f_77943769.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913187, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f657fa8e2c1ee0f49b75633000326288_69896130.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.00654292106628418 Currently in test ! try to remove file 2023/9/1/21e81aa87a46d0e87b355961bc8a336f_77943769.jpg from ovh : successful delete the file try to remove file 2023/9/1/f657fa8e2c1ee0f49b75633000326288_69896130.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913186,1203913187) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.524615, desc_s3 : 0:00:00.488486, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913186","1203913187") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0294020175933838 Starting time : 1769431021.1711786 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913188, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/416a742149528fcec22a4738873427cb_58138138.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913189, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e486a608117b8c28bd636976a6cb2785_96155018.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006597042083740234 Currently in test ! try to remove file 2023/9/1/416a742149528fcec22a4738873427cb_58138138.jpg from ovh : successful delete the file try to remove file 2023/9/1/e486a608117b8c28bd636976a6cb2785_96155018.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913188,1203913189) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.643583, desc_s3 : 0:00:00.427566, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913188","1203913189") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0885438919067383 Starting time : 1769431022.2663531 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913190, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2cdc3f3a5ffe86aaafae770e1d951fe9_49408692.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913197, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/e42369f8f7bfbdefb1f768da425c7f4f_95892072.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.00654292106628418 Currently in test ! try to remove file 2023/9/1/2cdc3f3a5ffe86aaafae770e1d951fe9_49408692.jpg from ovh : successful delete the file try to remove file 2023/9/1/e42369f8f7bfbdefb1f768da425c7f4f_95892072.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913190,1203913197) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.520370, desc_s3 : 0:00:00.503498, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913190","1203913197") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0393261909484863 Starting time : 1769431023.312254 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913198, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/334d735790cc146d84b78c2dffa3fe6b_37443809.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913199, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/143f8d1de53af3ca0b76da18bdeaca32_15704372.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0064470767974853516 Currently in test ! try to remove file 2023/9/1/334d735790cc146d84b78c2dffa3fe6b_37443809.jpg from ovh : successful delete the file try to remove file 2023/9/1/143f8d1de53af3ca0b76da18bdeaca32_15704372.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913198,1203913199) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.573766, desc_s3 : 0:00:00.616455, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913198","1203913199") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2064902782440186 Starting time : 1769431024.5252252 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913201, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/54506377f6337c1de56719e9c89a9eff_74802555.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913338, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/fcf288a09cab89d1563787a9abd55b86_25639360.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006467580795288086 Currently in test ! try to remove file 2023/9/1/54506377f6337c1de56719e9c89a9eff_74802555.jpg from ovh : successful delete the file try to remove file 2023/9/1/fcf288a09cab89d1563787a9abd55b86_25639360.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913201,1203913338) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.611514, desc_s3 : 0:00:00.858844, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913201","1203913338") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.4855613708496094 Starting time : 1769431026.0172853 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913339, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4c5aef6900b84536f2161c69997b8e62_24167250.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913340, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/bd0404d6f185f8228c1d080df5ab1165_86541725.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006623029708862305 Currently in test ! try to remove file 2023/9/1/4c5aef6900b84536f2161c69997b8e62_24167250.jpg from ovh : successful delete the file try to remove file 2023/9/1/bd0404d6f185f8228c1d080df5ab1165_86541725.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913339,1203913340) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.628095, desc_s3 : 0:00:00.484877, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913339","1203913340") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1281700134277344 Starting time : 1769431027.1521094 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913341, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/fed8c04401d9ee2fad5951d6b5a59439_45513969.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913342, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/65cd328dd55cae030b53bf997b4ba01c_28308718.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006808042526245117 Currently in test ! try to remove file 2023/9/1/fed8c04401d9ee2fad5951d6b5a59439_45513969.jpg from ovh : successful delete the file try to remove file 2023/9/1/65cd328dd55cae030b53bf997b4ba01c_28308718.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913341,1203913342) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.686260, desc_s3 : 0:00:00.483125, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913341","1203913342") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1842496395111084 Starting time : 1769431028.3431945 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913343, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/0fb9938fdf14c8f0b97a58d207c5624c_59015100.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913385, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/69d2b9533b720763a6d721a68904190b_22430618.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006713151931762695 Currently in test ! try to remove file 2023/9/1/0fb9938fdf14c8f0b97a58d207c5624c_59015100.jpg from ovh : successful delete the file try to remove file 2023/9/1/69d2b9533b720763a6d721a68904190b_22430618.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913343,1203913385) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.661893, desc_s3 : 0:00:00.607178, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913343","1203913385") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.285475492477417 Starting time : 1769431029.6354134 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913386, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a4a43c6d92a3767dc1493ea76b759578_31855487.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913387, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/4147eb0cb1899c8f4ff0ee39609d8640_81097455.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007408857345581055 Currently in test ! try to remove file 2023/9/1/a4a43c6d92a3767dc1493ea76b759578_31855487.jpg from ovh : successful delete the file try to remove file 2023/9/1/4147eb0cb1899c8f4ff0ee39609d8640_81097455.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913386,1203913387) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.547027, desc_s3 : 0:00:00.556236, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913386","1203913387") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1193699836730957 Starting time : 1769431030.7622247 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913388, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/69e5509b8a7b7e9c5d868d61e0bec6ba_45500266.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913389, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/1f28c3ced48a2c13286fd4131dbd4bf7_30366288.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0067098140716552734 Currently in test ! try to remove file 2023/9/1/69e5509b8a7b7e9c5d868d61e0bec6ba_45500266.jpg from ovh : successful delete the file try to remove file 2023/9/1/1f28c3ced48a2c13286fd4131dbd4bf7_30366288.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913388,1203913389) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.579666, desc_s3 : 0:00:00.683772, sql : 0:00:00.000009 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913388","1203913389") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2791240215301514 Starting time : 1769431032.0480978 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913508, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/752fb2928251aa5613bdee7d249cf362_45178707.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913510, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/0a9ac7f3e88d7d7c9da9dde54fc70713_159940.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006743669509887695 Currently in test ! try to remove file 2023/9/1/752fb2928251aa5613bdee7d249cf362_45178707.jpg from ovh : successful delete the file try to remove file 2023/9/1/0a9ac7f3e88d7d7c9da9dde54fc70713_159940.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913508,1203913510) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.553015, desc_s3 : 0:00:00.486058, sql : 0:00:00.000007 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913508","1203913510") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0544896125793457 Starting time : 1769431033.1093616 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913512, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/341c45edbedef1d66f6fbdcbeae4fbbf_52662043.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913514, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6757ae4baa9f6728e1eddb9eee838485_4674106.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006761789321899414 Currently in test ! try to remove file 2023/9/1/341c45edbedef1d66f6fbdcbeae4fbbf_52662043.jpg from ovh : successful delete the file try to remove file 2023/9/1/6757ae4baa9f6728e1eddb9eee838485_4674106.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913512,1203913514) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.543000, desc_s3 : 0:00:00.497020, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913512","1203913514") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0592949390411377 Starting time : 1769431034.1754503 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913517, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/045146c9ace031e79e7884a1e8fd6300_91306797.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913519, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/f19fbd2ff59d224c033e6f9e269f96f3_9082263.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007630586624145508 Currently in test ! try to remove file 2023/9/1/045146c9ace031e79e7884a1e8fd6300_91306797.jpg from ovh : successful delete the file try to remove file 2023/9/1/f19fbd2ff59d224c033e6f9e269f96f3_9082263.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913517,1203913519) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.645941, desc_s3 : 0:00:00.598469, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913517","1203913519") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2621357440948486 Starting time : 1769431035.445247 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913541, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ddf659e3c8f74963669f566a128a547e_3122544.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913542, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/d35a768d0fb111c9bc54cf29ca4949d5_39309420.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006749629974365234 Currently in test ! try to remove file 2023/9/1/ddf659e3c8f74963669f566a128a547e_3122544.jpg from ovh : successful delete the file try to remove file 2023/9/1/d35a768d0fb111c9bc54cf29ca4949d5_39309420.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913541,1203913542) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.920823, desc_s3 : 0:00:00.459667, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913541","1203913542") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3961281776428223 Starting time : 1769431036.8481581 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913543, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8da1f37fb473b960471ca603dc1f3e15_27931414.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913544, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/a557bd56969e99f6084618198d177e44_847948.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006786823272705078 Currently in test ! try to remove file 2023/9/1/8da1f37fb473b960471ca603dc1f3e15_27931414.jpg from ovh : successful delete the file try to remove file 2023/9/1/a557bd56969e99f6084618198d177e44_847948.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913543,1203913544) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.596079, desc_s3 : 0:00:00.533381, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913543","1203913544") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.147240400314331 Starting time : 1769431038.002213 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913545, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/2a249c5d57e8dc2b920fdd3a9759473e_42489027.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913546, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/fdd61667b728c322dc1a4bfc2b80bf12_60449353.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.0067901611328125 Currently in test ! try to remove file 2023/9/1/2a249c5d57e8dc2b920fdd3a9759473e_42489027.jpg from ovh : successful delete the file try to remove file 2023/9/1/fdd61667b728c322dc1a4bfc2b80bf12_60449353.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913545,1203913546) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.568110, desc_s3 : 0:00:00.522495, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913545","1203913546") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1072742938995361 Starting time : 1769431039.1163068 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913590, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/919c5195608d1ebddaaba3e4d2bfa59f_4015074.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913591, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ba3a3783d1c6e8021f444472655b78ef_76672131.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006841421127319336 Currently in test ! try to remove file 2023/9/1/919c5195608d1ebddaaba3e4d2bfa59f_4015074.jpg from ovh : successful delete the file try to remove file 2023/9/1/ba3a3783d1c6e8021f444472655b78ef_76672131.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913590,1203913591) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.548957, desc_s3 : 0:00:00.719662, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913590","1203913591") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2851004600524902 Starting time : 1769431040.408277 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913592, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/5fd7fe91081e1dbe681cc5ea4b386fed_10367964.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913593, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/843cebd04b12950ea144d0cd0fc4b388_18018820.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006700277328491211 Currently in test ! try to remove file 2023/9/1/5fd7fe91081e1dbe681cc5ea4b386fed_10367964.jpg from ovh : successful delete the file try to remove file 2023/9/1/843cebd04b12950ea144d0cd0fc4b388_18018820.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913592,1203913593) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.513088, desc_s3 : 0:00:00.606795, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913592","1203913593") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.135192632675171 Starting time : 1769431041.550196 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913594, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/69df9e6661fa0e144045650da04b7920_68693534.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913595, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/84ab40d80536ad2008b15782eafe3ad4_23887666.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007241010665893555 Currently in test ! try to remove file 2023/9/1/69df9e6661fa0e144045650da04b7920_68693534.jpg from ovh : successful delete the file try to remove file 2023/9/1/84ab40d80536ad2008b15782eafe3ad4_23887666.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913594,1203913595) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.642076, desc_s3 : 0:00:00.505642, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913594","1203913595") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.1656067371368408 Starting time : 1769431042.7230709 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913609, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ae327779dc4019e5815ed721724812c1_33797408.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913637, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/650602ee90622545b7032860354218d7_32324260.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007702827453613281 Currently in test ! try to remove file 2023/9/1/ae327779dc4019e5815ed721724812c1_33797408.jpg from ovh : successful delete the file try to remove file 2023/9/1/650602ee90622545b7032860354218d7_32324260.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913609,1203913637) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.556945, desc_s3 : 0:00:00.461985, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913609","1203913637") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0353434085845947 Starting time : 1769431043.7661433 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913638, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ab87775650920a48dccfd4014cfce82c_34417639.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913639, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ac4e126ac9f5b18798d97f812087b507_15868576.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007244110107421875 Currently in test ! try to remove file 2023/9/1/ab87775650920a48dccfd4014cfce82c_34417639.jpg from ovh : successful delete the file try to remove file 2023/9/1/ac4e126ac9f5b18798d97f812087b507_15868576.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913638,1203913639) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.697415, desc_s3 : 0:00:00.497562, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913638","1203913639") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.2108337879180908 Starting time : 1769431044.9842465 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913640, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/490232dfc269ce7ab3b8c32d12ed58ad_89465510.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913641, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/8f0fa4c2ab2915116c6dc239367b167a_45983229.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007216453552246094 Currently in test ! try to remove file 2023/9/1/490232dfc269ce7ab3b8c32d12ed58ad_89465510.jpg from ovh : successful delete the file try to remove file 2023/9/1/8f0fa4c2ab2915116c6dc239367b167a_45983229.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913640,1203913641) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.896477, desc_s3 : 0:00:00.718363, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913640","1203913641") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.6298201084136963 Starting time : 1769431046.6213133 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913642, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b696677d0409f08b9ea47d0c83c0b5ac_37129070.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913660, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/655a4a5e80bf48ff11f93cc8ca1f9bc5_29728141.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006683826446533203 Currently in test ! try to remove file 2023/9/1/b696677d0409f08b9ea47d0c83c0b5ac_37129070.jpg from ovh : successful delete the file try to remove file 2023/9/1/655a4a5e80bf48ff11f93cc8ca1f9bc5_29728141.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913642,1203913660) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.529451, desc_s3 : 0:00:00.464096, sql : 0:00:00.000006 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913642","1203913660") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.0113000869750977 Starting time : 1769431047.6393266 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913670, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/23310bbed73ff2ffae8ff50d5c423d42_27132411.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913671, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/b727bd6af2ef79d7ab98844719a6a45c_95989577.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.007021188735961914 Currently in test ! try to remove file 2023/9/1/23310bbed73ff2ffae8ff50d5c423d42_27132411.jpg from ovh : successful delete the file try to remove file 2023/9/1/b727bd6af2ef79d7ab98844719a6a45c_95989577.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913670,1203913671) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.621672, desc_s3 : 0:00:00.729187, sql : 0:00:00.000005 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913670","1203913671") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.3669323921203613 Starting time : 1769431049.0133002 select ph.photo_id, concat(mfp.base_url, "/", replace(replace(mfp.date, "-", "/"), "/0", "/"), "/", lower(HEX(cast(mfp.hash AS CHAR(10000) CHARACTER SET latin1))), (CASE WHEN (mfp.chi_id is null or mfp.chi_id = 0 or mfp.chi_id = 42) THEN "" ELSE concat("_", mfp.chi_id) END), (CASE WHEN INSTR(mfp.type_extension, ".") > 1 THEN "-" ELSE "." END) , mfp.type_extension ) as url, mfp.type_extension FROM MTRUser.mtr_fotonower_photos_opt mfp, MTRBack.photos ph WHERE ph.photo_id=mfp.photo_id and ph.right_categories=13977 and mfp.deleted_at is null -- and ph.timestamp between date_sub('2022-02-02', interval 10 day) and date_add('2022-02-02', interval 10 day) limit 2 photos : [{'photo_id': 1203913672, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/6b4c59dc4db39ffd9057d34a8d2b5333_83191039.jpg', 'type_extension': 'jpg'}, {'photo_id': 1203913673, 'url': 'https://storage.sbg.cloud.ovh.net/v1/AUTH_3b171620e76e4af496c5fd050759c9f0/media.fotonower.com/2023/9/1/ae42d00fcf123b2b4ef9a045ccabf8c9_58637560.jpg', 'type_extension': 'jpg'}] select photos undeleted TO DELETEElapsed time : 0.006833553314208984 Currently in test ! try to remove file 2023/9/1/6b4c59dc4db39ffd9057d34a8d2b5333_83191039.jpg from ovh : successful delete the file try to remove file 2023/9/1/ae42d00fcf123b2b4ef9a045ccabf8c9_58637560.jpg from ovh : successful delete the file select type,photo_id from MTRPhoto.photo_desc_search where photo_id in (1203913672,1203913673) deleted 2 pictures from base. timer : photo_s3 : 0:00:00.729610, desc_s3 : 0:00:00.843382, sql : 0:00:00.000009 update MTRUser.mtr_fotonower_photos_opt set deleted_at=now() where photo_id in ("1203913672","1203913673") 2 TO TEST THOROUGHLY delete_urls timerElapsed time : 1.5914111137390137 Starting time : 1769431050.6115804