Hello,
I have my website in WpEngine Hosting. Today I tried to continue working in my web site and I get a 502 Error (Bad Gateway). Last time I was working with the website, I was just see the “Clients custom post type” to introduce some clients, but I couldn’t as the website (backend) did not load correctly. The support told this:
# User@Host: testalimmenta[testalimmenta] @ localhost [127.0.0.1]
# Thread_id: 9903261 Schema: wp_testalimmenta Last_errno: 0 Killed: 0
# Query_time: 4.526572 Lock_time: 0.000042 Rows_sent: 363537 Rows_examined: 2557765 Rows_affected: 0 Rows_read: 2557765
SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (81,82,85,89,11062,11233,11234,11245) ORDER BY meta_id ASC /* From [testalimmenta.wpengine.com/] in [/nas/wp/www/cluster-2588/testalimmenta/wp-content/themes/cardinal/swift-framework/content/sf-portfolio.php:81] */;
This is one of the specific queries that is running for a long time, which is the most common cause of 502s. I would recommend switching themes for testing to see if any 502s remain.
It also appears that the wp_postmeta table is very large, at roughly 2 million rows. If any optimization is performed on this table, that should also help.
Now I will load a backup of the site to continue working. And I will check if this problem happens again. If you need further information I can give access to my website and load any backup.
.