Follow up question after reviewing more closely.:

https://deliciousbrains.com/wp-offload-media/doc/background-processes-not-completing/

Basic Authentication
Where would that code snipped be best added for a multisite situation? Should i add it into your plugin’s file: wordpress-s3.php and when the update completes is it necessary to have that code?

Hostname Resolution
I have my dns via cloudflare and have some other security protocols instituted. My websites have no problems being visible via web browsers, but pinging my site for the first time responds with: unknown host

So I am guessing this is a result of cloudflare security measures?

Another note, after turning on the debug logging, I see this related item referenced:

AS3CF: Total file size for the attachment is 0: 131

I’m not sure what to make of that or why issue that would cause.

I deleted that file and restarted, the next file its getting stuck on is a .mov file its getting stuck on is a .mov file that does not exist and is referenced from an older blog id path of a blog that was deleted.

If some other updates didn’t properly finish on previous version for whatever reason from sites that have been using your plugin for a longer time, then perhaps some error checking needs to be done for that and that was overlooked? Thanks Ian, looking forward to your thoughts.

Another update and revealing a possible bug(i replaced my bucketname cname with something generic for this post:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's-Road%' OR post_content LIKE '%//my.cname.bucket100/content/uploads/sites/13/20' at line 1 for query SELECT ID FROM wp_13_posts WHERE ID > 0 AND ID <= 27 AND (post_content LIKE '%//my.cname.bucket100/content/uploads/sites/13/2017/03/29182625/SPC-Painting-St-Mary's-Road%' OR post_content LIKE '%//my.cname.bucket100/content/uploads/sites/13/2017/03/29182625/SPC-Painting-St-Mary%27s-Road%') made by do_action_ref_array('as3cf_cron_update_replace_provider_urls'), WP_Hook->do_action, WP_Hook->apply_filters, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade->do_upgrade, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade->run_upgrade, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade_Content_Replace_URLs->upgrade_blog, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade->upgrade_blog, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade_Filter_Post->upgrade_item, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade_Filter_Post->find_and_replace_attachment_urls, DeliciousBrains\WP_Offload_Media\Upgrades\Upgrade_Filter_Post->process_pair_replacement

and

[22-Jul-2020 21:53:36 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘s-Road-(2)%’ OR items.original_source_path LIKE ‘2017/04/SPC-Painting-St-Mary’s-‘ at line 4 for query
SELECT DISTINCT items.*
FROM wp_13_as3cf_items AS items USE INDEX (uidx_source_path, uidx_original_source_path)
WHERE items.source_type = ‘media-library’
AND items.source_id NOT IN (1957) AND (items.source_path LIKE ‘2017/04/SPC-Painting-St-Mary’s-Road-(2)%’ OR items.original_source_path LIKE ‘2017/04/SPC-Painting-St-Mary’s-Road-(2)%’) made by do_action(‘wp_ajax_delete-post’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_delete_post, wp_delete_post, wp_delete_attachment, do_action(‘delete_attachment’), WP_Hook->do_action, WP_Hook->apply_filters, Amazon_S3_And_CloudFront->delete_attachment, Amazon_S3_And_CloudFront->remove_attachment_files_from_provider, DeliciousBrains\WP_Offload_Media\Items\Media_Library_Item::get_by_source_path
[22-Jul-2020 21:53:41 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘s-Road%’ OR items.original_source_path LIKE ‘2017/03/SPC-Painting-St-Mary’s-Road’ at line 4 for query
SELECT DISTINCT items.*
FROM wp_13_as3cf_items AS items USE INDEX (uidx_source_path, uidx_original_source_path)
WHERE items.source_type = ‘media-library’
AND items.source_id NOT IN (1910) AND (items.source_path LIKE ‘2017/03/SPC-Painting-St-Mary’s-Road%’ OR items.original_source_path LIKE ‘2017/03/SPC-Painting-St-Mary’s-Road%’) made by do_action(‘wp_ajax_delete-post’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_delete_post, wp_delete_post, wp_delete_attachment, do_action(‘delete_attachment’), WP_Hook->do_action, WP_Hook->apply_filters, Amazon_S3_And_CloudFront->delete_attachment, Amazon_S3_And_CloudFront->remove_attachment_files_from_provider, DeliciousBrains\WP_Offload_Media\Items\Media_Library_Item::get_by_source_path

• This reply was modified 1 year, 1 month ago by jiggaman.

Success! Using the the filters as3cf_update_replace_s3_urls_batch_size, as3cf_update_replace_s3_urls_time_limit

I increased the time, and then lowered max attachments to per batch. That got it “unstuck” and then it complete I think. No notification that it did complete but did show controls again. GREAT. Network one completed….now for network 2.

It’s stuck on 0. Its a bigger network and I have beefier settings:
PHP Memory Limit: 256M
WP Memory Limit: 256M
WP Max Upload Size: 200 MB
PHP Time Limit: 300
Media Files: 11,454
Offloaded Media Files: 3,404
Not Offloaded Media Files: 8,050

OME Metadata Version: 1

Whats differeent is the Not Offloaded Media Files seems higher and the OME Metatdata version is on 1 while the other one now says 8, any ideas on how to get this one moving as well?

Just another heads up to the developers:
classes/upgrades/upgrade-filter-post.php

abstract class Upgrade_Filter_Post extends Upgrade {

        /**
         * @var int Time limit in seconds.
         */
        protected $time_limit = 10;

        /**
         * @var int Batch size limit for this request session.
         */
        protected $size_limit = 50;

These numbers aren’t getting over written by mu plugin suggestion for upping the limits.