Database gets locked during the upgrade

Hi,

I haven’t seen this happen on any other sites. Can you check if the wfConfig table needs to be repaired?

-Matt R

The table seems to be fine. Could it be interfering with an object cache backed by Redis?

Hi,

I don’t know of anyone else currently using an object cache like that, so that may be a possibility (I’m have never used Redis myself and I’m not sure where this cache is integrated). It’s strange for the Alter statement to take long though. I see one process in the screenshot was in the “rename result table” state which normally shouldn’t last very long at all on the wfConfig table.

You might be able to just reinstall the whole plugin, using the “Delete Wordfence tables and data on deactivation” option (near the bottom of the Wordfence options page) to have the tables re-created — but if there is a bigger issue with the table, that might not work, and the plugin might not be possible to reinstall if there’s an issue creating the table again. Also, that option resets all of your Wordfence settings, blocks, etc. — so you may need to use the Export feature at the bottom of the options page first, to save your settings and re-import them afterward.

-Matt R