New to the community? Start here

Site going down Frequently

I have enabled Jetpack alerts. I keep getting downtime alerts and My CPU is always around 80-100 %.

Tue, 15 Oct 2019 10:03:12
  • Adam
    • Support Gorilla

    Hello Bernd

    I hope you’re well today!

    I checked the site and noticed that the PHP error log is being flooded with error related to missing database table. The table is

    _aff_referrals

    and it’s not in the database indeed. I’m a bit surprised that no plugin is “complaining” about that so I’m not sure which one it is related to but since there are only two affiliate plugins on site so I believe it would be one of them.

    I’m not sure if the table wasn’t migrated properly or it got removed during some development work (unfortunately, I have no way of checking that) but I’d start with this before going any further.

    That said, do you still have either access to original site (before migration – assuming that site was migrated to us) or its backup? If yes, it might be possible to restore the table from there. You might also try to simply re-install these two affiliate plugins instead and that should, at least theoretically, regenerate that missing db table.

    If the site still behaves that way after the table is restored, we’d investigate it further. Usually, if it’s not a particular error (like it might be the db issue mentioned above) it would mean that it’s more of a “sum” of the plugins and theme that put too much “use” on server and it (server) would have to get resources added (so plan would need to be upgraded to higher one) but let’s start with that db table first.

    Looking forward to hear from you,
    Adam

  • Predrag Dubajic
    • Support

    Hi Bernd,

    I can see that the load already dropped to around 50%, while this is still quite high to be on a constant load so something is still affecting it.
    From the tests it’s not clear where the issue is exactly coming from, it seems that there are multilpe plugins involved which increase the load by a certain percentage and then the combination of all of them blows up at one point and starts draining CPU.

    Highest server load is coming from PHP which means that the code from plugins or theme is responsible for this.
    In order to check where this is coming from you would need to perform a full conflict test by disabling your plugins and activating them one by one until you find the combination that is affecting the server.

    Since the issue is because of the resources needed by your setup you can also try upgrading to higher plan so that server has more resources to handle all requests.

    Best regards,
    Predrag