Support » Plugin: Forminator - Contact Form, Payment Form & Custom Form Builder » Google sheets integration causes form submission to take 6 minutes

  • Resolved matt9328

    (@matt9328)


    Hello,

    adding google sheets integration causes form submission to go from taking a few seconds to taking up to six minutes. I previously made a topic about this https://wordpress.org/support/topic/google-sheets-integration-causes-form-submission-to-take-2-minutes/ and thought the issue was resolved by adding ram and vcores to my VPS, however the problem has returned. The problem occurs even with a very simple form with one field that I created as a test case. I’ve tried disabling all other plugins, examined the output of Query Monitor, chrome devtools (screenshot here https://imgur.com/mmJehmw), and the php-fpm slow log, but haven’t managed to track down the problem. I have noticed the message “The scheduled event, forminator_send_export, failed to run. Your site still works, but this may indicate that scheduling posts or automated updates may not work as intended.” in the site health dashboard. Any advice would be appreciated.

    Thanks in advance!

    • This topic was modified 1 year, 6 months ago by matt9328.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    Hi @matt9328,

    Sorry to hear about the issues noticed. I gave a quick test to see whether I could replicate it or not, but it works instantly when tested.

    Could we know the current version of WP you are running on? Is it the latest version? Could we know whether the issue is specific to one website, or are you able to replicate this on every website tested?

    If possible, please go to WordPress > Tools > Site Heath > info, copy the site info, and share it in the next reply.

    I’ve tried disabling all other plugins, examined the output of Query Monitor,

    Was this also tested with a default WordPress? or only with all plugins deactivated?

    chrome devtools (screenshot here https://imgur.com/mmJehmw), and the php-fpm slow log

    Unfortunately, the screenshot doesn’t give much clue other than admin-ajax.php taking time.

    Maybe you could try enabling debug log and see whether it gives more clues regarding the issues.

    You can find more details about enabling debug mode here:

    Debugging in WordPress

    Once the debug mode is enabled, please try replicating the issue and check whether the logs provide any further clues.

    Please do let us know how that goes.

    Kind Regards,
    Nithin

    Thread Starter matt9328

    (@matt9328)

    Hi,

    thanks for your reply. I’m running WordPress 6.0.2. I only have one site to test this on. I tried the troubleshooting mode provided by the plugin you suggested, and had the same problem. There’s nothing in the WP debug log. The problem is intermittent so I understand it will be difficult to debug, so any advice would be appreciated, particularly places where I could insert execution time clocks in the plugin code

    Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    Hi @matt9328,

    Can you please go to WordPress >> Tools >> Site Heath >> info, copy the site info, and share it in the next reply.

    This will help us understand more about the hosting environment and your website.

    We look forward to hearing back from you.

    Kind Regards,
    Nebu John

    Thread Starter matt9328

    (@matt9328)

    
    ### wp-core ###
    
    version: 6.0.2
    site_language: en_US
    user_language: en_US
    timezone: +00:00
    permalink: undefined
    https_status: true
    multisite: false
    user_registration: 0
    blog_public: 1
    default_comment_status: open
    environment_type: production
    user_count: 3
    dotorg_communication: true
    
    ### wp-paths-sizes ###
    
    wordpress_path: /var/www/html
    wordpress_size: 395.99 MB (415229894 bytes)
    uploads_path: /var/www/html/wp-content/uploads
    uploads_size: 344.74 KB (353013 bytes)
    themes_path: /var/www/html/wp-content/themes
    themes_size: 81.32 MB (85269478 bytes)
    plugins_path: /var/www/html/wp-content/plugins
    plugins_size: 245.01 MB (256912988 bytes)
    database_size: 14.61 MB (15319040 bytes)
    total_size: 737.27 MB (773084413 bytes)
    
    ### wp-dropins (1) ###
    
    db.php: true
    
    ### wp-active-theme ###
    
    name: Avada (Avada)
    version: 7.8.2
    author: ThemeFusion
    author_website: https://themeforest.net/user/ThemeFusion
    parent_theme: none
    theme_features: core-block-patterns, fusion-builder-options, widgets-block-editor, title-tag, automatic-feed-links, custom-header, custom-background, woocommerce, wc-product-gallery-zoom, wc-product-gallery-slider, wc-product-gallery-lightbox, post-formats, post-thumbnails, fusion-builder-demos, menus, align-wide, wp-block-styles, editor-styles, dark-editor-style, editor-font-sizes, widgets
    theme_path: /var/www/html/wp-content/themes/Avada
    auto_update: Disabled
    
    ### wp-themes-inactive (4) ###
    
    Twenty Nineteen: version: 2.3, author: the WordPress team, Auto-updates disabled
    Twenty Twenty: version: 2.0, author: the WordPress team, Auto-updates disabled
    Twenty Twenty-One: version: 1.6, author: the WordPress team, Auto-updates disabled
    Twenty Twenty-Two: version: 1.2, author: the WordPress team, Auto-updates disabled
    
    ### wp-mu-plugins (1) ###
    
    Health Check Troubleshooting Mode: author: (undefined), version: 1.8.0
    
    ### wp-plugins-active (8) ###
    
    Avada Builder: version: 3.8.2, author: ThemeFusion, Auto-updates disabled
    Avada Core: version: 5.8.2, author: ThemeFusion, Auto-updates disabled
    Custom PHP settings: version: 1.4.5, author: Cyclonecode, Auto-updates disabled
    Forminator: version: 1.18.1, author: WPMU DEV (latest version: 1.18.2), Auto-updates disabled
    Health Check & Troubleshooting: version: 1.5.0, author: The WordPress.org community, Auto-updates disabled
    Query Monitor: version: 3.10.1, author: John Blackbourn, Auto-updates disabled
    UpdraftPlus - Backup/Restore: version: 1.22.23, author: UpdraftPlus.Com, DavidAnderson, Auto-updates disabled
    WP Crontrol: version: 1.14.0, author: John Blackbourn & crontributors, Auto-updates disabled
    
    ### wp-plugins-inactive (4) ###
    
    Akismet Anti-Spam: version: 5.0.1, author: Automattic, Auto-updates disabled
    Inactive Logout: version: 3.0.7, author: Deepen Bajracharya, Auto-updates disabled
    Jetpack: version: 11.3.2, author: Automattic, Auto-updates disabled
    WP Reset: version: 1.95, author: WebFactory Ltd, Auto-updates disabled
    
    ### wp-media ###
    
    image_editor: WP_Image_Editor_Imagick
    imagick_module_version: 1692
    imagemagick_version: ImageMagick 6.9.12-64 Q16 x86_64 17467 https://legacy.imagemagick.org
    imagick_version: 3.7.0
    file_uploads: File uploads is turned off
    post_max_size: 165M
    upload_max_filesize: 165M
    max_effective_size: 165 MB
    max_file_uploads: 20
    imagick_limits: 
    	imagick::RESOURCETYPE_AREA: 7 GB
    	imagick::RESOURCETYPE_DISK: 9.2233720368548E+18
    	imagick::RESOURCETYPE_FILE: 768
    	imagick::RESOURCETYPE_MAP: 7 GB
    	imagick::RESOURCETYPE_MEMORY: 4 GB
    	imagick::RESOURCETYPE_THREAD: 1
    imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPEG, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV
    gd_version: 2.3.3
    gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM
    ghostscript_version: not available
    
    ### wp-server ###
    
    server_architecture: Linux 3.10.0-1160.76.1.el7.x86_64 x86_64
    httpd_software: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/7.4.32
    php_version: 7.4.32 64bit
    php_sapi: apache2handler
    max_input_variables: 1000
    time_limit: 30
    memory_limit: 256M
    max_input_time: 60
    upload_max_filesize: 165M
    php_post_max_size: 165M
    curl_version: 7.29.0 NSS/3.53.1
    suhosin: false
    imagick_availability: true
    pretty_permalinks: true
    htaccess_extra_rules: true
    
    ### wp-database ###
    
    extension: mysqli
    server_version: 8.0.30
    client_version: mysqlnd 7.4.32
    max_allowed_packet: 67108864
    max_connections: 151
    
    ### wp-constants ###
    
    WP_HOME: undefined
    WP_SITEURL: undefined
    WP_CONTENT_DIR: /var/www/html/wp-content
    WP_PLUGIN_DIR: /var/www/html/wp-content/plugins
    WP_MEMORY_LIMIT: 40M
    WP_MAX_MEMORY_LIMIT: 256M
    WP_DEBUG: true
    WP_DEBUG_DISPLAY: false
    WP_DEBUG_LOG: true
    SCRIPT_DEBUG: false
    WP_CACHE: false
    CONCATENATE_SCRIPTS: undefined
    COMPRESS_SCRIPTS: undefined
    COMPRESS_CSS: undefined
    WP_ENVIRONMENT_TYPE: Undefined
    DB_CHARSET: utf8mb4
    DB_COLLATE: undefined
    
    ### wp-filesystem ###
    
    wordpress: writable
    wp-content: writable
    uploads: writable
    plugins: writable
    themes: writable
    mu-plugins: writable
    
    
    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @matt9328

    Thank you, I see your max execution time is low, so you added more memory to the server but PHP and WP still limiting the usage, also WordPress’s memory limit is still 40M.

    Can you please increase your max execution time to 300, and WordPress memory limit to 128 as you are using 256M in PHP, or increase the PHP to 512M and WP to 256M.

    I would suggest increasing the max input time to 120 too.

    https://wpmudev.com/blog/increase-memory-limit/

    Let us know if this made any difference.
    Best Regards
    Patrick Freitas

    Plugin Support Kasia – WPMU DEV Support

    (@wpmudev-support2)

    Hello @matt9328 ,

    We haven’t heard from you for some time now, so it looks like you don’t need our assistance anymore.

    Feel free to re-open this ticket if needed.

    Kind regards
    Kasia

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Google sheets integration causes form submission to take 6 minutes’ is closed to new replies.