XF 1.3 Stuck on "Running upgrade to 1.3.0 Alpha, step 8" on CLI Upgrade

That step operates on the xf_ip table. How big is that table in your database? How many records?

Maybe your shell session timed out. Try to reconnect and run the upgrade again. It will start where it left off.
 
Screen Shot 2014-03-31 at 11.33.32 PM.webp It is pretty big. Over a million posts. Tables are locked again. Suggest resetting mysql and restarting from cli?

I've done this a couple times over the last few hours when the tables lock, not sure if I'm just spinning in circles :|
 
In that screenshot, the query has only been running for < 20 minutes. If you're killing the process and restarting it, you're potentially just scrapping all of the work.

There's nothing that we can really do to speed up the process. This is internal to how MySQL rebuilds tables. You can potentially look at making sure you have MySQL as optimized as possible with respect to I/O, but otherwise there isn't a ton that can be done.
 
Top Bottom