Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #148088 Reply
    David Afonso
    Guest

    Error when backingup on the latest WP, running on my VPS server inside of a Docker of coolify.io.
    Need help.

    Fatal error: Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php:185
    Stack trace:
    #0 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-dump.php(124): Ifsnop\Mysqldump\Mysqldump->__construct('mysql:host=mari...', 'tVQGkVDQDhdo07g...', 'Uwes9FjHeblXY3J...', Array)
    #1 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1269): Boldgrid_Backup_Admin_Db_Dump->dump('/var/www/html/w...')
    #2 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1810): Boldgrid_Backup_Admin_Core->backup_database()
    #3 /var/www/html/wp-content/plugins/boldgrid-backup/includes/class-boldgrid-backup-archiver.php(113): Boldgrid_Backup_Admin_Core->archive_files(true)
    #4 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(2763): Boldgrid_Backup_Archiver->run()
    #5 /var/www/html/wp-includes/class-wp-hook.php(324): Boldgrid_Backup_Admin_Core->boldgrid_backup_now_callback('')
    #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
    #7 /var/www/html/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #8 /var/www/html/wp-admin/admin-ajax.php(192): do_action('wp_ajax_boldgri...')
    #9 {main}
      thrown in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php on line 185
    #148113 Reply
    Brandon C
    Keymaster

    Hi David, sorry to hear you’re experiencing this fatal error in Total Upkeep.  Have backups ever worked in the current environment or is this your first time attempting a backup with Total Upkeep? We also need to know exactly when the error is occurring.  Does it happen once you actually click the button to begin the backup, or some time after the backup process has begun?

    Itf the error occurs after the backup has initiated it would be helpful to navigate to Total Upkeep > Tools > Logs and check the log file with a name like archive-XXXXXXX.log with a timestamp corresponding to one of your failed backups.

    You can reply here with the text in that log file, we’ll be able to take a closer look at what’s going on.

    One thing we suggest in these cases is running a sanity check backup to see if the site is allowing you to create backups at all on your server.

    The video below explains how to setup the sanity check:

    I hope this helps David, we look forward to assisting you further!

    #148115 Reply
    David Afonso
    Guest

    Hi.
    I have never been able to do a backup.
    The backup process starts, but fails after fetching DB tables.

    I’m running the WP on a Cloud VPS, running inside of a WP Docker from coolify.io.

    Here is the latest log:

    [2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist.
    [2024-10-27 10:13:24 UTC] Backup process initialized.
    [2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist.
    [2024-10-27 10:13:24 UTC] Backup process initialized.
    [2024-10-27 10:13:24 UTC] Process id: 517358
    [2024-10-27 10:13:24 UTC] Backup triggered by: WP cron
    [2024-10-27 10:13:24 UTC] --------------------------------------------------------------------------------
    [2024-10-27 10:13:24 UTC] Starting dump of database...
    [2024-10-27 10:13:24 UTC] Memory usage - limit / current / peak memory usage: 2048M / 12164464 (11.60 MB) / 12197024 (12 MB)
    [2024-10-27 10:13:24 UTC] Database info: Array
    (
        [wp_cmplz_cookiebanners] => 1
        [wp_cmplz_cookies] => 0
        [wp_cmplz_dnsmpd] => 0
        [wp_cmplz_services] => 0
        [wp_commentmeta] => 0
        [wp_comments] => 1
        [wp_e_events] => 0
        [wp_e_notes] => 0
        [wp_e_notes_users_relations] => 0
        [wp_e_submissions] => 0
        [wp_e_submissions_actions_log] => 0
        [wp_e_submissions_values] => 0
        [wp_links] => 0
        [wp_mb_relationships] => 3
        [wp_nvf_auctioneers] => 1
        [wp_nvf_auctions] => 8
        [wp_nvf_poc] => 1
        [wp_options] => 351
        [wp_postmeta] => 203
        [wp_posts] => 180
        [wp_term_relationships] => 10
        [wp_term_taxonomy] => 113
        [wp_termmeta] => 0
        [wp_terms] => 113
        [wp_usermeta] => 61
        [wp_users] => 2
        [wp_wfblockediplog] => 103
        [wp_wfblocks7] => 108
        [wp_wfconfig] => 270
        [wp_wfcrawlers] => 0
        [wp_wffilechanges] => 0
        [wp_wffilemods] => 13759
        [wp_wfhits] => 138
        [wp_wfhoover] => 0
        [wp_wfissues] => 1
        [wp_wfknownfilelist] => 13760
        [wp_wflivetraffichuman] => 0
        [wp_wflocs] => 3
        [wp_wflogins] => 12
        [wp_wfls_2fa_secrets] => 0
        [wp_wfls_role_counts] => 0
        [wp_wfls_settings] => 30
        [wp_wfnotifications] => 5
        [wp_wfpendingissues] => 0
        [wp_wfreversecache] => 1
        [wp_wfsecurityevents] => 0
        [wp_wfsnipcache] => 0
        [wp_wfstatus] => 978
        [wp_wftrafficrates] => 0
        [wp_wfwaffailures] => 0
    )
    
    [2024-10-27 10:13:24 UTC] Last error: Array
    (
        [type] => 1
        [message] => Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php:185
    Stack trace:
    #0 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-dump.php(124): Ifsnop\Mysqldump\Mysqldump->__construct('mysql:host=mari...', 'tVQGkVDQDhdo07g...', 'Uwes9FjHeblXY3J...', Array)
    #1 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1269): Boldgrid_Backup_Admin_Db_Dump->dump('/var/www/html/w...')
    #2 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1810): Boldgrid_Backup_Admin_Core->backup_database()
    #3 /var/www/html/wp-content/plugins/boldgrid-backup/includes/class-boldgrid-backup-archiver.php(113): Boldgrid_Backup_Admin_Core->archive_files(true)
    #4 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-wp-cron.php(353): Boldgrid_Backup_Archiver->run()
    #5 /var/www/html/wp-includes/class-wp-hook.php(324): Boldgrid_Backup_Admin_WP_Cron->backup()
    #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
    #7 /var/www/html/wp-includes/plugin.php(565): WP_Hook->do_action(Array)
    #8 /var/www/html/wp-cron.php(191): do_action_ref_array('boldgrid_backup...', Array)
    #9 {main}
      thrown
        [file] => /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php
        [line] => 185
    )

    The sanity check worked fine. Here is the log from that:

    [2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist.
    [2024-10-27 10:13:24 UTC] Backup process initialized.
    [2024-10-27 10:13:24 UTC] Cannot add signal handlers, pcntl_async_signals function does not exist.
    [2024-10-27 10:13:24 UTC] Backup process initialized.
    [2024-10-27 10:13:24 UTC] Process id: 517358
    [2024-10-27 10:13:24 UTC] Backup triggered by: WP cron
    [2024-10-27 10:13:24 UTC] --------------------------------------------------------------------------------
    [2024-10-27 10:13:24 UTC] Starting dump of database...
    [2024-10-27 10:13:24 UTC] Memory usage - limit / current / peak memory usage: 2048M / 12164464 (11.60 MB) / 12197024 (12 MB)
    [2024-10-27 10:13:24 UTC] Database info: Array
    (
        [wp_cmplz_cookiebanners] => 1
        [wp_cmplz_cookies] => 0
        [wp_cmplz_dnsmpd] => 0
        [wp_cmplz_services] => 0
        [wp_commentmeta] => 0
        [wp_comments] => 1
        [wp_e_events] => 0
        [wp_e_notes] => 0
        [wp_e_notes_users_relations] => 0
        [wp_e_submissions] => 0
        [wp_e_submissions_actions_log] => 0
        [wp_e_submissions_values] => 0
        [wp_links] => 0
        [wp_mb_relationships] => 3
        [wp_nvf_auctioneers] => 1
        [wp_nvf_auctions] => 8
        [wp_nvf_poc] => 1
        [wp_options] => 351
        [wp_postmeta] => 203
        [wp_posts] => 180
        [wp_term_relationships] => 10
        [wp_term_taxonomy] => 113
        [wp_termmeta] => 0
        [wp_terms] => 113
        [wp_usermeta] => 61
        [wp_users] => 2
        [wp_wfblockediplog] => 103
        [wp_wfblocks7] => 108
        [wp_wfconfig] => 270
        [wp_wfcrawlers] => 0
        [wp_wffilechanges] => 0
        [wp_wffilemods] => 13759
        [wp_wfhits] => 138
        [wp_wfhoover] => 0
        [wp_wfissues] => 1
        [wp_wfknownfilelist] => 13760
        [wp_wflivetraffichuman] => 0
        [wp_wflocs] => 3
        [wp_wflogins] => 12
        [wp_wfls_2fa_secrets] => 0
        [wp_wfls_role_counts] => 0
        [wp_wfls_settings] => 30
        [wp_wfnotifications] => 5
        [wp_wfpendingissues] => 0
        [wp_wfreversecache] => 1
        [wp_wfsecurityevents] => 0
        [wp_wfsnipcache] => 0
        [wp_wfstatus] => 978
        [wp_wftrafficrates] => 0
        [wp_wfwaffailures] => 0
    )
    
    [2024-10-27 10:13:24 UTC] Last error: Array
    (
        [type] => 1
        [message] => Uncaught Error: Undefined constant PDO::MYSQL_ATTR_USE_BUFFERED_QUERY in /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php:185
    Stack trace:
    #0 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-db-dump.php(124): Ifsnop\Mysqldump\Mysqldump->__construct('mysql:host=mari...', 'tVQGkVDQDhdo07g...', 'Uwes9FjHeblXY3J...', Array)
    #1 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1269): Boldgrid_Backup_Admin_Db_Dump->dump('/var/www/html/w...')
    #2 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-core.php(1810): Boldgrid_Backup_Admin_Core->backup_database()
    #3 /var/www/html/wp-content/plugins/boldgrid-backup/includes/class-boldgrid-backup-archiver.php(113): Boldgrid_Backup_Admin_Core->archive_files(true)
    #4 /var/www/html/wp-content/plugins/boldgrid-backup/admin/class-boldgrid-backup-admin-wp-cron.php(353): Boldgrid_Backup_Archiver->run()
    #5 /var/www/html/wp-includes/class-wp-hook.php(324): Boldgrid_Backup_Admin_WP_Cron->backup()
    #6 /var/www/html/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters('', Array)
    #7 /var/www/html/wp-includes/plugin.php(565): WP_Hook->do_action(Array)
    #8 /var/www/html/wp-cron.php(191): do_action_ref_array('boldgrid_backup...', Array)
    #9 {main}
      thrown
        [file] => /var/www/html/wp-content/plugins/boldgrid-backup/vendor/ifsnop/mysqldump-php/src/Ifsnop/Mysqldump/Mysqldump.php
        [line] => 185
    )

    Since I have full root access, how can I debug this scenario?
    Thank you

Viewing 3 posts - 1 through 3 (of 3 total)
Reply To: Fatal error when backing up with Total Upkeep
Your information: