Update to 2.8.4 did not finish database optimization and site went offline

My conflict test still suggests an issue with TranslatePress: The latest minor upgrade from 2.8.2 or 2.8.3 to 2.8.4 crashed my multi-lingual WP site at https://3dlux.art/ on IIS 10 due to never ending database updating/optimization of MySQL 8.4 with the now infamous dots........... I suspect the (new?) trp_slug_original and trp_slug_translated tables.

It totally surprised me that with a minor upgrade (on Thursday just before support closes by the way I learned) one or more tables seems to have changed or somehow need “optimization”. Is collation an issue as I read elsewhere? I have 'utf8mb4_unicode_520_ci' for most tables but the slug tables have 'utf8mb4_general_ci'. The mysql command I used btw:

SHOW TABLE STATUS LIKE '%_trp_%';

Currently, translations are inaccessible. Plugin cannot be installed since re-activation immediately causes 500 Internal Server Errors for all traffic and the following shows in WP's debug.log:

[22-Aug-2024 19:44:04 UTC] PHP Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\includes\Modules\Analytics_4\Report\ReportParsers.php on line 94
[22-Aug-2024 19:44:04 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:04 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:04 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:04 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:06 UTC] PHP Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\includes\Modules\Analytics_4\Report\ReportParsers.php on line 94
[22-Aug-2024 19:44:07 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:12 UTC] PHP Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\includes\Modules\Analytics_4\Report\ReportParsers.php on line 94
[22-Aug-2024 19:44:12 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:13 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:13 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:44:13 UTC] PHP Deprecated: Calling get_class() without arguments is deprecated in D:\Inetpub\wwwroot\press\wp-content\plugins\google-site-kit\third-party\google\apiclient\src\Http\REST.php on line 49
[22-Aug-2024 19:50:38 UTC] PHP Fatal error: Uncaught Error: Call to protected method TRP_Translation_Render::is_admin_link() from scope TRP_IN_SP_Slug_Manager in D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php:1124
Stack trace: 0 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(324): TRP_IN_SP_Slug_Manager->verify_if_is_admin_link_for_slug_translation() 1 D:\Inetpub\wwwroot\press\wp-includes\plugin.php(205): WP_Hook->apply_filters() 2 D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php(1069): apply_filters() 3 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(324): TRP_IN_SP_Slug_Manager->translate_request_uri() 4 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(348): WP_Hook->apply_filters() 5 D:\Inetpub\wwwroot\press\wp-includes\plugin.php(517): WP_Hook->do_action() 6 D:\Inetpub\wwwroot\press\wp-settings.php(550): do_action() 7 D:\Inetpub\wwwroot\press\wp-config.php(104): require_once('…') 8 D:\Inetpub\wwwroot\press\wp-load.php(50): require_once('…') 9 D:\Inetpub\wwwroot\press\wp-admin\admin.php(34): require_once('…') 10 D:\Inetpub\wwwroot\press\wp-admin\options-general.php(10): require_once('…') 11 {main}

thrown in D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php on line 1124
[22-Aug-2024 19:50:38 UTC] PHP Notice: Function is_embed was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in D:\Inetpub\wwwroot\press\wp-includes\functions.php on line 6078
[22-Aug-2024 19:50:38 UTC] PHP Notice: Function is_search was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in D:\Inetpub\wwwroot\press\wp-includes\functions.php on line 6078
[22-Aug-2024 19:50:43 UTC] PHP Fatal error: Uncaught Error: Call to protected method TRP_Translation_Render::is_admin_link() from scope TRP_IN_SP_Slug_Manager in D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php:1124
Stack trace: 0 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(324): TRP_IN_SP_Slug_Manager->verify_if_is_admin_link_for_slug_translation() 1 D:\Inetpub\wwwroot\press\wp-includes\plugin.php(205): WP_Hook->apply_filters() 2 D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php(1069): apply_filters() 3 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(324): TRP_IN_SP_Slug_Manager->translate_request_uri() 4 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(348): WP_Hook->apply_filters() 5 D:\Inetpub\wwwroot\press\wp-includes\plugin.php(517): WP_Hook->do_action() 6 D:\Inetpub\wwwroot\press\wp-settings.php(550): do_action() 7 D:\Inetpub\wwwroot\press\wp-config.php(104): require_once('…') 8 D:\Inetpub\wwwroot\press\wp-load.php(50): require_once('…') 9 D:\Inetpub\wwwroot\press\wp-blog-header.php(13): require_once('…') 10 D:\Inetpub\wwwroot\press\index.php(17): require('…') 11 {main}

thrown in D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php on line 1124
[22-Aug-2024 19:50:44 UTC] PHP Notice: é–￠??° is_embed ???èa¤??￡??|?‘???3??o???????????—????€???????????????ˉ??¨??a????????°??ˉ?€???ˉ??¨??a?????????è????????????‰??????ˉ???è????—????????“?€?????????￥?‰???§??ˉ?€??????? false ??’è?”??—???????€? è?3??—?????ˉ WordPress ??????????????°??’??”è|§?????????????€? (??“????????????????????ˉ???????????§??3 3.1.0 ??§è????????????????—???) in D:\Inetpub\wwwroot\press\wp-includes\functions.php on line 6078
[22-Aug-2024 19:50:44 UTC] PHP Notice: é–￠??° is_search ???èa¤??￡??|?‘???3??o???????????—????€???????????????ˉ??¨??a????????°??ˉ?€???ˉ??¨??a?????????è????????????‰??????ˉ???è????—????????“?€?????????￥?‰???§??ˉ?€??????? false ??’è?”??—???????€? è?3??—?????ˉ WordPress ??????????????°??’??”è|§?????????????€? (??“????????????????????ˉ???????????§??3 3.1.0 ??§è????????????????—???) in D:\Inetpub\wwwroot\press\wp-includes\functions.php on line 6078
[22-Aug-2024 19:50:48 UTC] PHP Fatal error: Uncaught Error: Call to protected method TRP_Translation_Render::is_admin_link() from scope TRP_IN_SP_Slug_Manager in D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php:1124
Stack trace: 0 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(324): TRP_IN_SP_Slug_Manager->verify_if_is_admin_link_for_slug_translation() 1 D:\Inetpub\wwwroot\press\wp-includes\plugin.php(205): WP_Hook->apply_filters() 2 D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php(1069): apply_filters() 3 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(324): TRP_IN_SP_Slug_Manager->translate_request_uri() 4 D:\Inetpub\wwwroot\press\wp-includes\class-wp-hook.php(348): WP_Hook->apply_filters() 5 D:\Inetpub\wwwroot\press\wp-includes\plugin.php(517): WP_Hook->do_action() 6 D:\Inetpub\wwwroot\press\wp-settings.php(550): do_action() 7 D:\Inetpub\wwwroot\press\wp-config.php(104): require_once('…') 8 D:\Inetpub\wwwroot\press\wp-load.php(50): require_once('…') 9 D:\Inetpub\wwwroot\press\wp-blog-header.php(13): require_once('…') 10 D:\Inetpub\wwwroot\press\index.php(17): require('…') 11 {main}

thrown in D:\Inetpub\wwwroot\press\wp-content\plugins\translatepress-personal\add-ons-advanced\seo-pack\includes\class-slug-manager.php on line 1124
[22-Aug-2024 19:50:48 UTC] PHP Notice: Function is_embed was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in D:\Inetpub\wwwroot\press\wp-includes\functions.php on line 6078
[22-Aug-2024 19:50:48 UTC] PHP Notice: Function is_search was called incorrectly. Conditional query tags do not work before the query is run. Before then, they always return false. Please see Debugging in WordPress for more information. (This message was added in version 3.1.0.) in D:\Inetpub\wwwroot\press\wp-includes\functions.php on line 6078

Does anyone know what the mimimal set of trp* tables is that can either safely be truncated or dropped in order to restore functioning of the TranslatePress plugin and website.

Thanks in advance!