XF 2.2 Upgrade from 2.1 to 2.2 issues

[Stuart Wright]

Running from the CLI on our sandbox (xf2.avforums.com):

Running upgrade to 2.2.0 Alpha, step 9... done.
Running upgrade to 2.2.0 Alpha, step 10...
In AbstractStatement.php line 228:

xf_post: MySQL query error [1034]: Incorrect key file for table 'xf_post'; try to repair it


xf:upgrade [--skip-statistics]

Exception query:

ALTER TABLE xf_post
ADD type_data MEDIUMBLOB NOT NULL AFTER position,
ADD vote_score INT NOT NULL,
ADD vote_count INT UNSIGNED NOT NULL DEFAULT '0',
ADD KEY thread_id_score_date (thread_id, vote_score DESC, post_date)

 

[Mike]

Your post table appears to be corrupt. You can try running REPAIR TABLE xf_post; on it, though you'd want to try why. It's plausible that there might be disk space issues, for example.

This might also imply that your post table is MyISAM which generally isn't correct. If that's the case, you might want to look at why that is (and check that it's not that in production).

 

[Stuart Wright]

The repair didn't work, the table is InnoDB.
Checked disk space and it's 99% full. Good call, Mike.

Ok, so running it again after freeing up some space. 2.2.0 Alpha step 10 has taken 40 minutes so far with 24,706,543 posts.

 

[Lee]

The repair didn't work, the table is InnoDB.
Checked disk space and it's 99% full. Good call, Mike.

Ok, so running it again after freeing up some space. 2.2.0 Alpha step 10 has taken 40 minutes so far with 24,706,543 posts.

How long did your upgrade end up taking?

 

[duderuud]

I upgraded my test vps (with about 30mln posts) to 2.2 b3. Took about 15 minutes.

Test box has 8gb of RAM and 4 cores.

 

[Stuart Wright]

How long did your upgrade end up taking?

A long time. Over 5 hours on our sandbox. I'll probably leave it overnight when I come to upgrade the live server and set the alarm for early.

 

[Lee]

Ouch, rather you that me!

 

[Stuart Wright]

Ouch, rather you that me!

Really? Would you rather have a small forum with just a few members, or a massive one with hundreds of thousands?

 

[Lee]

Really? Would you rather have a small forum with just a few members, or a massive one with hundreds of thousands?

Middle ground for me

I get nervous when upgrading and panic things like backups wont work if I need them haha.

 

[Stuart Wright]

To update this thread, we just migrated to 2.2.2 and the CLI took 32 minutes to complete.
Way quicker than expected. Very happy.

 

[RobParker]

The repair didn't work, the table is InnoDB.
Checked disk space and it's 99% full. Good call, Mike.

Ok, so running it again after freeing up some space. 2.2.0 Alpha step 10 has taken 40 minutes so far with 24,706,543 posts.

Any idea how long this step finally took? I'm testing it now on our dev site and it's been running a while...

 

[Stuart Wright]

Any idea how long this step finally took? I'm testing it now on our dev site and it's been running a while...

It's 6 months ago, so no, I don't remember exactly, but not long once the server had enough space.

 

[RobParker]

Thanks! Mine was hanging for a while but finished in around half an hour.