Page MenuHomePhabricator

Applying patch "phabricator:20161125.search.01.stemmed.sql" takes forever
Closed, WontfixPublic

Description

Hi,

I'm currently upgrading Phabricator and it's stuck in storage upgrade :

+ /home/rd/phabricator/bin/storage upgrade
Before running storage upgrades, you should take down the Phabricator web
interface and stop any running Phabricator daemons (you can disable this
warning with --force).

    Are you ready to continue? [y/N] y

Applying patch "phabricator:20161125.search.01.stemmed.sql" to host "localhost"...

and it does not go through next patch or steps as usually :-(

CPU does nothing so it's seem stuck

According to phabricator/resources/sql/autopatches/20161125.search.01.stemmed.sql a column is added so it should be fast right ?

I currently have this in MySQL :

mysql> DESCRIBE search_documentfield;
+----------+---------------+------+-----+---------+-------+
| Field    | Type          | Null | Key | Default | Extra |
+----------+---------------+------+-----+---------+-------+
| phid     | varbinary(64) | NO   | MUL | NULL    |       |
| phidType | varchar(4)    | NO   |     | NULL    |       |
| field    | varchar(4)    | NO   |     | NULL    |       |
| auxPHID  | varbinary(64) | YES  |     | NULL    |       |
| corpus   | longtext      | YES  | MUL | NULL    |       |
+----------+---------------+------+-----+---------+-------+
5 rows in set (0.00 sec)

mysql>
mysql> SELECT COUNT(*) FROM search_documentfield;
+----------+
| COUNT(*) |
+----------+
|   631044 |
+----------+
1 row in set (0.00 sec)

mysql>

What can I do to troubleshoot this?

Event Timeline

Issue was: no more disk space

Had to:

  • get space
  • drop the column
SHOW databases
USE phabricator_search
DESCRIBE search_documentfield;
ALTER TABLE phabricator_search.search_documentfield DROP COLUMN stemmedCorpus;
  • restart /bin/storage upgrade
chad claimed this task.
chad added a subscriber: chad.

Thanks, glad this all worked out.