Plugin fails, runs out of memory, if wp_XXX_options table is selected

[damonbeals]

I have a older WP multisite, and this plugin has been so helpful in letting me make some major changes. But several of my sites cause the plugin to fail if wp_XXX_options is selected. I enabled debug and see PHP throws an error because it runs out of memory. I upped the PHP memory to 384M and still the plugin fails.

From the debug.log with 256M
[01-Feb-2019 20:50:50 UTC] PHP Fatal error: Allowed memory size of 268435456 by
tes exhausted (tried to allocate 262144 bytes) in /usr/home/wbcci/public_html/wb
cci.net/wp-content/plugins/search-and-replace/inc/Database/Replace.php on line 337
[01-Feb-2019 20:50:50 UTC] PHP Fatal error: Allowed memory size of 268435456 by
tes exhausted (tried to allocate 262144 bytes) in /usr/home/wbcci/public_html/wb
cci.net/wp-includes/load.php on line 679

Let me know if you need anything further to debug.

[bvdv]

Hi @damonbeals, could you write here what version of WP, S&P plugin do you use?

[bueltge]

Thanks @bvdv for your help! ❤️

[damonbeals]

Wordpress 4.9.9, not updated to 5.X yet. And Version 3.2.0 of Search & Replace.

[damonbeals]

Still having this issue, is there anything I can provide to help debug this further?

[bueltge]

It is also possible to inform us about your items inside this table? How many lines of entries are inside the table? Maybe is really big for your small memory. The plugin have no fall back if the memory is to small.

[brasofilo]

Hi Mister Frank, long time!

I was running in circles with the same issue, unselecting wp_xx_options made the plugin work.
Error was:

Apache SSL/TLS access	500	POST /wp-admin/tools.php?page=search-replace 
Apache error		AH01067: Failed to read FastCGI header, referer: https://.../wp-admin/tools.php?page=search-replace				
Apache error		(104)Connection reset by peer: AH01075: Error dispatching request to : , referer: https://.../wp-admin/tools.php?page=search-replace

The table is really small, 200 items. I'm running on a VPS so I pushed the timeout limits quite high.. Error occurs on main site and subsites.
I'm sending a dump of the SQL table to your bueltge.de email.
Hopefuly it'll be a simple, albeit exotic, fix :)