`amazonS3_cache` Consistently Referencing Deleted Media Images

  • Resolved cameronkyley

    (@cameronkyley)


    1 month, 2 weeks ago

    Every time I load a media item in my Admin section, there is a new amazonS3_cache entry made in wp_postmeta.

    Each time, the meta_value is the same and these are all media media that have been deleted:

    a:14:{s:79:"//mywebsite.com/wp-content/uploads/2024/06/istockphoto-1190867531-1.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:89:"//mywebsite.com/wp-content/uploads/2024/06/istockphoto-1190867531-2048x2048-1.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:95:"//mywebsite.com/wp-content/uploads/2024/06/unpacked-boxes-in-middle-of-room-4246091.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:104:"//mywebsite.com/wp-content/uploads/2024/06/unpacked-boxes-in-middle-of-room-4246091-1024x683.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:198:"//mywebsite.com/wp-content/uploads/2024/06/cheerful-modern-male-and-female-in-comfortable-casual-clothes-unpacking-car-trunk-in-green-garden-of-new-house-while-moving-in-together-4246266.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:207:"//mywebsite.com/wp-content/uploads/2024/06/cheerful-modern-male-and-female-in-comfortable-casual-clothes-unpacking-car-trunk-in-green-garden-of-new-house-while-moving-in-together-4246266-1024x683.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:108:"//mywebsite.com/wp-content/uploads/2024/06/couple-using-laptop-in-room-with-packed-boxes-4245923.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:117:"//mywebsite.com/wp-content/uploads/2024/06/couple-using-laptop-in-room-with-packed-boxes-4245923-683x1024.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:77:"//mywebsite.com/wp-content/uploads/2024/06/Example-A-Roll-Image-1.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:86:"//mywebsite.com/wp-content/uploads/2024/06/Example-A-Roll-Image-1024x793-1.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:65:"//mywebsite.com/wp-content/uploads/2024/05/natures-02.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:62:"//mywebsite.com/wp-content/uploads/2024/06/default.png";a:1:{s:9:"timestamp";i:1722553136;}s:67:"//mywebsite.com/wp-content/uploads/2024/06/natures-02-1.jpg";a:1:{s:9:"timestamp";i:1722553136;}s:75:"//mywebsite.com/wp-content/uploads/2024/06/natures-02-225x300-1.jpg";a:1:{s:9:"timestamp";i:1722553136;}}

    I am unsure if this is working correctly due to the fact the image have been deleted and looking for guidance in an effort to stop unnecessary database entries.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter cameronkyley

    (@cameronkyley)

    1 month, 2 weeks ago

    I think I may have solved it, these media were being referenced in a Template for the FSE theme I am using even though they were deleted. Once that template itself was deleted, it seems to have stopped those amazonS3_cache entries.

    Plugin Author Delicious Brains

    (@deliciousbrains)

    1 month, 2 weeks ago

    The amazonS3_cache records are a way of caching the local and remote (bucket/CDN) URLs used in a post to make rewriting URLs during save and display of a post quicker by referencing their attachment ID.

    So if posts were being rendered with a template that had some redundant URLs in it, they would still be cached, but because the attachment ID could not be found, that timestamp is added to delay checking for their attachment ID a little while.

    Now that you’ve updated that template, you should find new amazonS3_cache records will not reference those old URLs any longer.

    The amazonS3_cache records are ephemeral, feel free to delete them all to clean out all those old URLs if you like, the amazonS3_cache records will be re-created. However, those old URLs being in the amazonS3_cache records doesn’t really harm anything, they’re just redundant entries that will not be used or re-checked now that no content includes them.

    –IJ

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.