WIP: Database connection errors, CPU outages on CW Vultr HF

Bugs
1

I have Vultr HF Server on Cloudways. After a few days of working on the site (and same the happened on another Bricks install) I get errors connecting to the DB. I talked to CW support and they say they cannot identify which process is draining the server resources.

@thomas since Iā€™m not a professional developer nor a server administrator I simply donā€™t know what to do. I canā€™t access the site Iā€™ve been working for weeks now. Any kind of help would be greatly appreciated.

I would paste the system status from Bricks but I canā€™t even access the dashboard.

2

UPDATE: Cloned the site to a second server (Cloudways, Vultr HF, 4GB). Disabled all plugins except Woocommercee and everythingā€™s still the same. As soon as I disable Bricks and use Storefront, the site loads instantly. I turn Bricks on and I get Errors connecting to DB.

I tried PHP 7.4, 8.0 no difference.

3

UPDATE 2:

Installed RC:

Error log:
[Mon Aug 01 21:23:33.196450 2022] [proxy_fcgi:error] [pid 24221:tid 139777135036160] [client 127.0.0.1:14164] AH01071: Got error ā€˜PHP message: PHP Warning: mysqli_select_db(): Error while reading INIT_DBā€™s response packet. PID=27270 in /home/813336ā€¦r_element, Bricks\Element->init, Bricks\Element_Container->render, Bricks\Frontend::render_element, Bricks\Element->init, Bricks\Elementā€¦ā€™, referer: https://woocommerce-813336-2791009.cloudwaysapps.com/wp-content/uploads/2022/07/icon-trial.svg

[Mon Aug 01 21:23:37.253689 2022] [proxy_fcgi:error] [pid 28970:tid 139777940637440] [client 127.0.0.1:18278] AH01071: Got error ā€˜PHP message: objectcache.error: Failed to execute Redis GET commandPHP message: objectcache.error: read error on connection to tcp://127.0.0.1:6379ā€™, referer: https://woocommerce-813336-2791009.cloudwaysapps.com/wp-content/uploads/2022/07/icon-trial.svg

[Mon Aug 01 21:23:40.875557 2022] [proxy_fcgi:error] [pid 28970:tid 139777949030144] [client 127.0.0.1:18268] AH01071: Got error ā€˜PHP message: PHP Warning: Attempt to read property ā€œmenu_classā€ on array in /home/813336.cloudwaysapps.com/wtdrnbcdnr/pā€¦nu_class" on array in /home/813336.cloudwaysapps.com/wtdrnbcdnr/public_html/wp-content/themes/bricks/includes/elements/nav-menu.php on line 1026ā€™, referer: https://woocommerce-813336-2791009.cloudwaysapps.com/wp-content/uploads/2022/07/icon-trial.svg

Anyone having any idea what could be wrong wit nav-menu.php?

At this point all plugins are disabled. All Bricks templates are disabled. Only Bricks is enabled in Appearance > Themes.

4

I kind of resolved the issue:

Bricks was loading a missing SVG file. Looks like Bricks was trying to read a cached SVG file by Redis that didnā€™t exist anymore. Because of this error it the whole site went down.

I wonder how is this even possible - to hang an entire site because of a missing SVG file.

This was the main issue.

When I installed the RC, then Bricksextras was producing error, that disappeared after I updated the plugin.

5

As Bricks uses the built-in WordPress function wp_remote_get to request the file content of an SVG file I donā€™t see how just the fact that the SVG file was missing could have caused a complete meltdown of the site.

But happy to look into this for you. Could you share some temporary admin login details with us (Contact ā€“ Bricks), so we can have a look at your site?

6

I seem to be having database issues as well when cloning from a template install. When I deactivate Bricks, all loads fine.

I use Wordify AWS hosting. Support said this:

"With Theme Bricks and child theme too many database queries are piling up which delays access to the site and errors. "

The original install has no issues, it only seems to happen when the installation is cloned to a new environment.

7

Same issue as above. Terrible database issues when cloned