Home › Forums › Backend Issues (wp-admin) › Error 500 / 504 on update page with a lot of ACF fields
We have a page where we use a lot of different ACF custom blocks / fields, including ACF wrappers.
When we click to update this page, the whole website goes down until its fully saved – which takes half a minute to couple of minutes.
While the update-button is loading and I go to console on the edit page it will show:
VM2831:1 GET urlremoved/wp-admin/post.php?post=169&action=edit&message=4 500 (Internal Server Error)
And if I open new window to see the website during this loading, it will show Database not connected. Sometimes 504 Gateway Time-out.
The error logs say:
PHP Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /var/www/urlremoved/wordpress/wp-includes/wp-db.php on line 1753
Im not sure what to do to not have this happen, we tried increasing some php settings but that didnt help.
Server:
File uploads Enabled
Max size of post data allowed 13M
Max size of an uploaded file 256M
Max effective file size 13 MB
Max number of files allowed 20
Server architecture Linux 5.4.0-89-generic x86_64
Web server nginx/1.18.0
PHP version 7.4.3 (Supports 64bit values)
PHP SAPI fpm-fcgi
PHP max input variables 1000
PHP time limit 30
PHP memory limit 516M
Max input time 60
Upload max filesize 256M
PHP post max size 13M
cURL version 7.68.0 OpenSSL/1.1.1f
Is SUHOSIN installed? No
Is the Imagick library available? No
Are pretty permalinks supported? Yes
Database:
Database size 208,80 MB
Extension mysqli
Server version 8.0.30-0ubuntu0.20.04.2
Client version mysqlnd 7.4.3
Database username wp_user
Database host 127.0.0.1
Database name wp_stage_db
Table prefix wp_
Database charset utf8mb4
Database collation utf8mb4_unicode_520_ci
Max allowed packet size 67108864
Max connections number 151
Wordpress constants:
WP_MEMORY_LIMIT 516M
WP_MAX_MEMORY_LIMIT 256M
WP_DEBUG Disabled
WP_DEBUG_DISPLAY Enabled
WP_DEBUG_LOG Disabled
SCRIPT_DEBUG Disabled
WP_CACHE Disabled
CONCATENATE_SCRIPTS Undefined
COMPRESS_SCRIPTS Undefined
COMPRESS_CSS Undefined
WP_ENVIRONMENT_TYPE Undefined
DB_CHARSET utf8mb4
DB_COLLATE
This is something that happens when saving a large number of fields. There are too many DB queries that cause the page to time out. This has been discussed here before, many times.
You must be logged in to reply to this topic.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.