XF 2.2 Upgrade error from CLI ( xf_post: MySQL query error [1878]: Temporary file write failure)

[multibam]

I am somehow getting this error message when upgrading to 2.2.2 from CLI:

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 [1878]: Temporary file write failure


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)

Does anyone know how to fix it? All help is really appreciated

 

[MySiteGuy]

Whatever disk partition you have setup for where MySQL temporary files go isn't large enough to hold a copy of the post table while its being altered.

 

[multibam]

Thanks. That was really helpful