Support

Account

Home Forums Backend Issues (wp-admin) Error 500 / 504 on update page with a lot of ACF fields

Helping

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.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.