[Pro] The Grid crashes the server

[magikweb]

Hello Themeco,
We have a photograph that has multiple pictures in the same gallery that we made using The Grid.
When anybody clicks “Add images” (as shown below), the media library opens up with selectable images (to add to The Grid) and crashes the server by taking 100% of the server resources.

Would it be possible to get support about this to help us understand why it would do that?
The developers send the support queries to the theme owners.

It’s a WordPress Multisite, so our guess is that MySQL queries take into account tables they shouldn’t touch (other sites’).

[christian]

Hey @magikweb,

I’d recommend you first meet The Grid’s requirements before we proceed with further investigation.

Please first contact your host if they can meet those requirements. If your allowed, you can ask your host to increase the requirements for you or you can do that yourself by following this article at https://www.wpbeginner.com/wp-tutorials/how-to-increase-the-maximum-file-upload-size-in-wordpress/.

You should also ask your host to do an audit of your site so they could see if you’re current overall setup like all the plugins you use and also taking into account Multisite.

It is also best that you copy your site to a staging server for you to do troubleshooting while your live site continues to operate. We also could not investigate in your live site because of the risks involved in troubleshooting.

You also have 190+ images in your grid, I could not currently easily replicate that setup in my test site so a staging site would be the best way to continue on troubleshooting. Once you’ve setup staging, deactivate all third party plugins to test for a conflict.

Please also understand that the best people that could answer to thisissue is The Grid’s developers as they know the exact process that happens when adding an image to the grid so it would be best that you buy a license from them and also post this issue in their support.

Thanks.

[magikweb]

Thank you for the follow-up!

The requirements are already met, for some reason the page kept a cached version of yesterday’s static content. (see secure note)

We use a VPS / Cloud Hosting with SiteGround, it’s pretty great. The support showed us the slow queries, but it didn’t show us the actual trigger (the first slow query that caused the others), we’re discussing it still.

We are looking into making a staging server right away, we do need that pretty bad…

Yes, that grid has a lot of images and it’s the only one crashing because of that. Still, using AJAX loading it shouldn’t take 7GB of RAM and 300% CPU within 5 seconds. Like a recent bug we found in WooCommerce, we believe it’s highly possible to be connected with WPMU where they check all the sites’ tables instead of one site at a time.

I understand that you didn’t code it, we’ll buy a license if our host doesn’t pinpoint the culprit on the server-side.

I’ll update this if we get a fix.

[mldarshana]

Hi There @magikweb

I have checked your server information through your file above (php info).

I see that your PHP memory limit is set to 256MiB.

Also your PHP max script execution time is set to 30 seconds.

If you have the full access to your server, try increasing your memory limit by editing your PHP.INI file (https://premium.wpmudev.org/blog/increase-memory-limit/). Also increase your max script execution time to 120 (2 mins) by following this guide (https://www.simplified.guide/php/increase-max-execution-time).

Let us know how it goes.
Thanks!

[magikweb]

Thank you for the follow-up. Sadly it didn’t prevent the server’s overload.

We will buy a The Grid license and see if they can help us.

[Prasant]

You are most welcome.