Website goes down when plugin is activated

  • Resolved Sushant Sanjay Khadilkar

    (@skhadilk)


    3 years, 8 months ago

    Hi Support,

    We have our client’s website which is hosted on AWS. We are using Amazon S3 as a storage and Amazon Cloudfront for caching.

    When the plugin is active, the RDS DB connections are increased up to 850 or sometimes more than that and website goes down. We are unable to access admin panel and frontend also when website is down.

    Could you please help here to resolve this issue?

    Thanks,
    Sushant

Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter Sushant Sanjay Khadilkar

    (@skhadilk)

    3 years, 7 months ago

    Any feedback here?

    Plugin Author Delicious Brains

    (@deliciousbrains)

    3 years, 7 months ago

    Hi @skhadilk,

    Please can we see Diagnostic Info from WP Offload Media’s “Support” tab, and any debug.log output captured during reproduction of the issue.

    https://deliciousbrains.com/why-use-wp-debug-log-wordpress-development/

    Please also supply information about the SQL queries that you’re seeing, especially duplicated ones.

    Any information on the page(s) that seem to trigger the problem might be helpful too.

    -IJ

    Thread Starter Sushant Sanjay Khadilkar

    (@skhadilk)

    3 years, 7 months ago

    Hi @deliciousbrains,

    Please find below information from “Support”.

    site_url(): https://www.mcafee.com/blogs
    home_url(): https://www.mcafee.com/blogs
    Database Name: consumerblog
    Table Prefix: m6af33_
    WordPress: 5.9.1
    Web Server: Apache/2.4.6 (CentOS) PHP/8.1.8
    PHP: 8.1.8
    MySQL: 8.0.28
    ext/mysqli: yes
    PHP Memory Limit: 256M
    WP Memory Limit: 256M
    Memory Usage: 77 MB
    Blocked External HTTP Requests: None
    WP Locale: en_US
    Organize offloads by month/year: Enabled
    WP_DEBUG: No
    WP_DEBUG_LOG: No
    WP_DEBUG_DISPLAY: No
    SCRIPT_DEBUG: No
    WP Max Upload Size: 2 MB
    PHP Time Limit: 30
    PHP Error Log:
    WP Cron: Enabled
    fsockopen: Enabled
    allow_url_fopen: Enabled
    OpenSSL: OpenSSL 1.0.2k 26 Jan 2017
    cURL: 7.29.0
    Zlib Compression: Enabled
    PHP GD: 2.3.3
    Imagick: Disabled
    Basic Auth: Disabled
    Proxy: Disabled

    Media Files: 35,674
    Offloaded Media Files: 32,552
    Not Offloaded Media Files: 3,122

    Number of Image Sizes: 12

    Names and Dimensions of Image Sizes:
    thumbnail (150×150)
    medium (300×300)
    large (1024×1024)
    1536×1536 (1536×1536)
    2048×2048 (2048×2048)
    category-listing (205×129)
    profile_24 (24×24)
    profile_48 (48×48)
    profile_96 (96×96)
    profile_150 (150×150)
    profile_300 (300×300)

    WP_CONTENT_DIR: /var/www/html/blogs/wp-content
    WP_CONTENT_URL: https://www.mcafee.com/blogs/wp-content
    UPLOADS: Not defined
    WP_PLUGIN_DIR: /var/www/html/blogs/wp-content/plugins
    WP_PLUGIN_URL: https://www.mcafee.com/blogs/wp-content/plugins

    AS3CF_PROVIDER: Not defined
    AS3CF_BUCKET: Not defined
    AS3CF_REGION: Not defined
    AS3CF_SETTINGS: Not defined

    Local URL:
    https://www.mcafee.com/blogs/wp‑content/uploads/2022/10/photo.jpg
    Offload URL:
    https://www.mcafee.com/blogs/wp‑content/uploads/2022/10/photo.jpg

    OME Metadata Version: 12

    Custom tables:
    m6af33_as3cf_items: Ok

    Storage Provider: Amazon S3
    Use Server Roles: On
    Key File Path: N/A
    Access Keys Set: No
    Access Key ID Define: Not defined
    Secret Access Key Define: Not defined

    Bucket: blogs-prod-s3
    Region: us-west-2
    Block All Public Access: Enabled

    Copy Files to Bucket: On
    Enable Path: On
    Custom Path: blogs/wp-content/uploads/
    Use Year/Month: On
    Object Versioning: Off

    Delivery Provider: Amazon CloudFront
    Rewrite Media URLs: On
    Enable Custom Domain (CNAME): On
    Custom Domain (CNAME): http://www.mcafee.com

    Force HTTPS: On

    Remove Files From Server: On

    Active Theme Name: McAfee Blog | Securing Tomorrow – Brillio
    Active Theme Version: 1.0
    Active Theme Folder: securingtomorrow-brillio

    Active Plugins:
    Activity Log (v2.8.3) by Activity Log Team
    AddFunc Head & Footer Code (v2.3) by AddFunc
    AddToAny Share Buttons (v1.8.4) by AddToAny
    Advanced Custom Fields (v5.11.4) by Delicious Brains
    C3 Cloudfront Cache Controller (v6.1.3) by hideokamoto
    Classic Editor (v1.6.2) by WordPress Contributors
    Co-Authors Plus (v3.4.92) by Mohammad Jangda, Daniel Bachhuber, Automattic
    Disable Comments (v2.3.3) by WPDeveloper
    Highlight Search Terms (v1.8.1) by RavanH
    Image Widget (v4.4.7) by Modern Tribe, Inc.
    Imsanity (v2.7.2) by Exactly WWW
    Limit Post Titles (v1.0.2) by Cocoon Development Ltd
    Reading Time WP (v2.0.10) by Jason Yingling
    Redirection (v5.2.3) by John Godley
    Simple Custom Post Order (v2.5.6) by Colorlib
    User Profile Picture (v2.6.0) by Cozmoslabs
    WP Missed Schedule (The Original) (v2014.1231.2017.12) by sLaNGjIs Team
    WP Offload Media Lite (v2.6.2) by Delicious Brains
    WPML Multilingual CMS (v4.5.5) by OnTheGoSystems
    WPML String Translation (v3.2.1) by OnTheGoSystems
    WPS Hide Login (v1.9.3) by WPServeur, NicolasKulka, wpformation
    Yoast Duplicate Post (v4.4) by Enrico Battocchi & Team Yoast
    Yoast SEO (v18.0) by Team Yoast
    jQuery Updater (v3.6.0.1) by Ramoonus

    Drop-ins:
    advanced-cache.php – advanced-cache.php`

    We can’t find any SQL queries during that period and also doesn’t have debug.log. Also sometimes RDS connections spike goes upto 850, the website goes down. We are unable to access admin and frontend of website.

    Thanks,
    Sushant

    Plugin Author Delicious Brains

    (@deliciousbrains)

    3 years, 7 months ago

    Hi @skhadilk,

    You’re presumably using a CloudFront distribution that is in front of both the site and offload S3 bucket, hopefully with a Behavior with a path pattern of “/blogs/wp-content/uploads/*” for the S3 origin higher in the list than the “Default(*)” Behavior for the site.

    As such, you should turn off the “Rewrite Media URLs” setting. At the moment, WP Offload Media is trying to rewrite local URLs to remote URLs, and (on save) remote URLs to local URLs, where both URLs are the same. That’ll confuse things and be very inefficient.

    Also, somehow the site has http://www.mcafee.com for the “Custom Domain (CNAME)” setting. Please remove the http:// bit, it should just be “www.mcafee.com”.

    -IJ

    • This reply was modified 3 years, 7 months ago by Delicious Brains.
    • This reply was modified 3 years, 7 months ago by Delicious Brains. Reason: Fix path pattern
    Thread Starter Sushant Sanjay Khadilkar

    (@skhadilk)

    3 years, 7 months ago

    Thanks for the feedback. We will try out the recommendations and update you if its resolves the issue or not.

    Regards,
    Sushant

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Website goes down when plugin is activated’ is closed to new replies.