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

[Douglas Taylor]

Has this been a problem with anyone else? Approaching two hours here :/

 

[Jake Bunce]

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.

 

[Douglas Taylor]

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 :|

 

[Douglas Taylor]

Stiiiiiiill going.

Figure I would probably inquire about how to make the process much easier for larger forums.

 

[Mike]

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.