Failed Backup with All-In-One – Fixed

0  comments

Fixed - Resolved

Thanks to Sam at the Pair.com tech support. This is what was reported back to me.

I think I found the cause of the problem.  First, the backup process is
taking a very long time to complete, primarily because it's also trying to
archive 4.3GB of old backups that were made with Updraft Plus back in
2029-2020 in this directory:

  /usr/home/rauterkus1/public_html/swimisca.org/wp-content/updraft/

Second, your username hadn't been added as an exception to our system
monitor that kills runaway processes.  This is normally for users on
shared servers, but sometimes when users are migrated from shared to
dedicated the exceptions aren't added as they should be.  I've added it
now, so it shouldn't kill any other long-running jobs going forward. 
Please try your backup again, but I would recommend clearing out those old
Updraft Plus backups first.

Please let us know if there is anything else we can do for you.

That directory was part of a backup plugin and it was used by the former webmaster. I have not used the updraft backup plugin so I didn't notice it sitting there hogging up the space. After logging in with PUTTY via SSH, got ride of lots of old backup files. Whew.

Then the backup with All-in-one worked as it should.

March 2024 Problems -- the issue seems to be back again

This is where the program seems to crap out. It stays on this screen for 2 or 3 mintutes then flashes the error message.

Loom of failed backup attempt with All-In-One on March 22, 2024

File: .user.ini reads

#added per R9C8U8W
zlib.output_compression = On
max_execution_time = 120
max_input_time = 120
# MR was 1024M and moved to 2048M
memory_limit = 2048M
Failed backup generates this file

Screen of failed backup output.


All In One fails at making a backup

The process gets to the backing up of database to about 18% then it stops.

So, we turned on the WP log.


// Enable WP_DEBUG mode
define( 'WP_DEBUG', true );
// Enable Debug logging to the /wp-content/debug.log file
define( 'WP_DEBUG_LOG', true );
// Disable display of errors and warnings
define( 'WP_DEBUG_DISPLAY', false );


Then the log says:

[18-Sep-2023 23:41:16 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:41:16 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:41:30 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:41:30 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:43:59 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7468232 bytes) in /usr/home/rauterkus1/public_html/swimisca.org/wp-content/plugins/all-in-one-wp-migration/lib/vendor/servmask/database/class-ai1wm-database-mysqli.php on line 63
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0bfb05458.75200770|1695080699', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0bfb074e8.52111910|1695080699', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
[18-Sep-2023 23:43:59 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN ('pending') AND a.scheduled_date_gmt <= '2023-09-18 23:43:59' LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions
[18-Sep-2023 23:44:05 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7468232 bytes) in /usr/home/rauterkus1/public_html/swimisca.org/wp-content/plugins/all-in-one-wp-migration/lib/vendor/servmask/database/class-ai1wm-database-mysqli.php on line 63
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0c5f25980.19306381|1695080705', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0c5f277a1.38765671|1695080705', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
[18-Sep-2023 23:44:05 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN ('pending') AND a.scheduled_date_gmt <= '2023-09-18 23:44:05' LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions
[18-Sep-2023 23:44:23 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 6595776 bytes) in /usr/home/rauterkus1/public_html/swimisca.org/wp-content/plugins/all-in-one-wp-migration/lib/vendor/servmask/database/class-ai1wm-database-mysqli.php on line 63
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0d7327282.47011889|1695080723', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0d7328f93.20925950|1695080723', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
[18-Sep-2023 23:44:23 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN ('pending') AND a.scheduled_date_gmt <= '2023-09-18 23:44:23' LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions
[18-Sep-2023 23:44:33 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7468232 bytes) in /usr/home/rauterkus1/public_html/swimisca.org/wp-content/plugins/all-in-one-wp-migration/lib/vendor/servmask/database/class-ai1wm-database-mysqli.php on line 63
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0e1146d46.34057058|1695080733', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0e11485d9.15075898|1695080733', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
[18-Sep-2023 23:44:33 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN ('pending') AND a.scheduled_date_gmt <= '2023-09-18 23:44:33' LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions
[18-Sep-2023 23:44:42 UTC] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 7468232 bytes) in /usr/home/rauterkus1/public_html/swimisca.org/wp-content/plugins/all-in-one-wp-migration/lib/vendor/servmask/database/class-ai1wm-database-mysqli.php on line 63
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0eae14366.18836070|1695080742', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, ActionScheduler_QueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_Lock->is_locked, ActionScheduler_OptionLock->get_expiration, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT option_value FROM wp_options WHERE option_name = 'action_scheduler_lock_async-request-runner' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set, ActionScheduler_OptionLock->get_existing_lock
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES ('action_scheduler_lock_async-request-runner', '6508e0eae15d32.51139513|1695080742', 'no') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_OptionLock->set
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT COUNT(DISTINCT claim_id) FROM wp_actionscheduler_actions WHERE claim_id != 0 AND status IN ( 'pending', 'in-progress') made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Abstract_QueueRunner->has_maximum_concurrent_batches, ActionScheduler_DBStore->get_claim_count
[18-Sep-2023 23:44:42 UTC] WordPress database error Commands out of sync; you can't run this command now for query SELECT a.action_id FROM wp_actionscheduler_actions a WHERE 1=1 AND a.status IN ('pending') AND a.scheduled_date_gmt <= '2023-09-18 23:44:42' LIMIT 0, 5 made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, WP_Rocket\Engine\Common\Queue\RUCSSQueueRunner->maybe_dispatch_async_request, ActionScheduler_AsyncRequest_QueueRunner->maybe_dispatch, ActionScheduler_AsyncRequest_QueueRunner->allow, ActionScheduler_Store->has_pending_actions_due, ActionScheduler_DBStore->query_actions
[18-Sep-2023 23:46:11 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:46:11 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:48:45 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:48:45 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:50:04 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:50:04 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:21 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:21 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:24 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:24 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:27 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:27 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:30 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:30 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:34 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:34 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:35 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:35 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:37 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:37 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:37 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:37 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:38 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:38 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:39 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:39 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:42 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:42 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:43 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:43 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:44 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:44 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:46 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:46 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:52 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:52 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:53 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:53 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:54 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:54 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:55 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:52:55 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:01 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:01 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:03 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:03 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:05 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:05 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:06 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:06 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:08 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:08 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:09 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:09 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:11 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:11 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:12 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:12 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:14 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:14 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:14 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:14 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:16 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:16 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:18 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:18 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:19 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349
[18-Sep-2023 23:53:19 UTC] PHP Notice: ob_end_flush(): failed to send buffer of zlib output compression (1) in /usr/home/rauterkus1/public_html/swimisca.org/wp-includes/functions.php on line 5349


Support at Pair (server host) wrote, in part:

Looking at this I can see that the plugin was meeting the memory_limit directive in php and failing. You can increase this as needed in a .user.ini file at /usr/home/rauterkus1/public_html/swimisca.org/.user.ini with the following line (replacing "X" with the desired limit in)

memory_limit = XM

Currently this is set to 512M based off of the error below.

[18-Sep-2023 23:44:42 UTC] PHP Fatal error: Allowed memory size of
536870912 bytes exhausted (tried to allocate 7468232 bytes) in
/usr/home/rauterkus1/public_html/swimisca.org/wp-content/plugins/all-in-one-wp-migration/lib/vendor/servmask/database/class-ai1wm-database-mysqli.php on line 63

I would recommend increasing this to at least 756M or 1024M.

Please let us know if you have any questions or concerns.

Thank you and have a nice day,
Dominic


This worked!

  • Question: Should I reset the memory back to 512M until the next backup is needed?

Answer from support person at my hosting company, Pair.com:

It's a lot of memory for one site, but if the site needs it to function you
should keep it for now. Then review ways to cut back the memory use/need.

If the memory bump is only needed to run the backup, then you can adjust on the fly provided you want to stay hands on each time the backup runs.

  • Question: Is there harm with having so much memory put onto one site? 

About the author 

Mark Rauterkus

Mark Rauterkus, is the webmaster for ISCA. Also a swim, SKWIM and water polo coach in Pittsburgh, PA, USA.
Cell: 412-298-3432

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}
>