• Since a month, I am experiencing an issue with my website, where the resources used reach their maximum. Specifically, an error message is displayed when visiting my website: “Resource limits reached”. If I open cPanel, I see these statistics:

    1. Number Of Processes: 165?/?165?(100%)
    2. CPU Usage 100?/?100?(100%)
    3. Entry Processes: 150?/?150?(100%)


    To resolve the issue, I have to rename the public_html folder, temporarily replacing it with another one that I use to put my website in maintenance mode. After about two minutes, the website resources return to normal, something like:

    1. Number Of Processes: 11?/?165?(6.67%)
    2. CPU Usage 0?/?100?(0%)
    3. Entry Processes: 0?/?150?(0%)


    When I see these statistics, I can restore the original public_html folder. After restoring the original public_html folder, two things can happen:

    1. The problem doesn’t occur for a couple of days.
    2. The problem occurs again after about 3/4 minutes, and I have to repeat the above-mentioned steps a certain number of times.

    Understanding the cause of this issue has been quite complex. However, during the last two instances, I performed a specific test that shed light on the root of the problem. After facing the problem repeatedly, and after restoring the public_html folder, I immediately disabled the SQLite Object Cache plugin before resources reached their maximum, and the issue stopped happening. I tested this twice in different days and reached the same conclusion each time: the problem is caused by the SQLite Object Cache plugin

    Unfortunately, I am aware that solving such a problem is very complicated, especially when there are no errors present in the log files. I think I also understand the situation of processes, such as process B doesn’t know what process A is doing and when it ends. But I think it was worth noting the existence of this issue. Considering the timeout issues with the past updates, I’ve always suspected that the cause could be SQLite Object Cache. However, I chose to wait a month to conduct the appropriate tests to confirm if it was indeed the cause before reporting it here.

    I believe it’s important to note that this also happens when my website has very low traffic. Despite the plugin having this issue, I remain confident that it is the best option for safeguarding resources. Addressing this problem or implementing specific workarounds could greatly enhance the overall user experience and ensure smoother plugin functionality.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author OllieJones

    (@olliejones)

    Thanks for the defect report. I agree completely that this is hard to track down.

    The latest version of the plugin checkpoints the resource log once in a while, in an attempt to avoid timeouts. It’s possible these checkpoint operations tie up php processes.

    Thread Starter wabetainfo

    (@wabetainfo)


    Hi @olliejones,

    I found some logs when this issue occurred and I wanted to share them with you:


    [20-Feb-2024 01:06:21 UTC] SQLite Object Cache: 3.39.4 igbinary: php 8.0.30: Apache: get_by_name database disk image is malformed (11) Unable to execute statement: database disk image is malformed (0) #0 /home/website/public_html/wp-content/object-cache.php(1386): SQLite3Stmt->execute() #1 /home/website/public_html/wp-content/object-cache.php(1333): WP_Object_Cache->get_by_name() #2 /home/website/public_html/wp-content/object-cache.php(1796): WP_Object_Cache->cache_item_exists() #3 /home/website/public_html/wp-content/object-cache.php(2499): WP_Object_Cache->get() #4 /home/website/public_html/wp-includes/option.php(173): wp_cache_get() #5 /home/website/public_html/wp-content/plugins/jetpack/jetpack_vendor/automattic/jetpack-connection/legacy/class-jetpack-options.php(225): get_option() #6 /home/website/public_html/wp-content/plugins/jetpack/jetpack_vendor/automattic/jetpack-connection/legacy/class-jetpack-options.php(208): Jetpack_Options::get_option_from_database() #7 /home/website/public_html/wp-content/plugins/jetpack/class.jetpack.php(2160): Jetpack_Options::get_option() #8 /home/website/public_html/wp-content/plugins/jetpack/class.jetpack.php(784): Jetpack::get_option() #9 /home/website/public_html/wp-content/plugins/jetpack/class.jetpack.php(498): Jetpack->__construct() #10 /home/website/public_html/wp-content/plugins/jetpack/load-jetpack.php(78): Jetpack::init() #11 /home/website/public_html/wp-content/plugins/jetpack/jetpack.php(201): require_once('/home/website...') #12 /home/website/public_html/wp-settings.php(473): include_once('/home/website...') #13 /home/website/public_html/wp-config.php(100): require_once('/home/website...') #14 /home/website/public_html/wp-load.php(50): require_once('/home/website...') #15 /home/website/public_html/wp-blog-header.php(13): require_once('/home/website...') #16 /home/website/public_html/index.php(17): require('/home/website...') #17 {main} [20-Feb-2024 01:06:21 UTC] sqlite_object_cache failure, deleting sqlite files to retry. 0

    Plugin Author OllieJones

    (@olliejones)

    Thanks. This is helpful.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Resource limits reached’ is closed to new replies.