Server hangs when I try to reactivate WP-Stateless

So I’ve been using the WP-Stateless plugin for 6+ years and my woocommerce site has several thousands of product images managed by WP-Stateless. I’ve also added the Woocommerce addon for WP Stateless.

I recently tried installing the WP Redis Cache plugin along with the redis-server on my ubuntu server and initially things seem to be working fine. Additionally, I also indexed a few things on the databse using the following commands to speed up the product retrievals for my front end (I only use Woocommerce in Headless mode as the backend):

CREATE INDEX idx_post_type_status ON wp_posts (post_type, post_status);

CREATE INDEX idx_product_search ON wp_posts (post_type, post_status, post_title(191), post_content(191));

CREATE INDEX idx_order_item_order_id ON wp_woocommerce_order_items (order_id);

CREATE INDEX idx_order_itemmeta ON wp_woocommerce_order_itemmeta (order_item_id, meta_key);

CREATE INDEX idx_product_meta_key ON wp_postmeta (post_id, meta_key);

CREATE INDEX idx_product_meta_value ON wp_postmeta (meta_key, meta_value(191));

However, I noticed that the server was timing out quite a bit on api requests and also the admin dashboard wouldn’t load.

So using the SQL command: UPDATE wp_options SET option_value = '' WHERE option_name = 'active_plugins'; , I deactivated all plugins and then the admin dashboard started loading fine.

I went ahead and started activating all plugins one by one and when I tried activating WP-Stateless, the admin dashboard hanged and the server became inaccessible.
So to be sure, I tried the same deactivation + reactivation several times and the server was hanging only when I tried to activate WP-Stateless plugin.

I’ve also deleted the Wp Redis Cache plugin and deleted the object-cache.php file as well as the cache folder from the uploads from the server. Still, I’m not able to get WP-stateless to activate.

Can you please help me out? It’s a live site and without WP Stateless, the frontend images simply don’t seem to work.