[Forum] Upgrade to 4.1.10 (Status: Processing 4.0.0 Alpha 1, Step 104 of 109)

[raei]

Dears

Im trying to upgrade my forum from 3.7.3 to 4.1.10, it was moving smoothly until reached to step 104.

It shows (Status: Processing 4.0.0 Alpha 1, Step 104 of 109) since more than 10 hours, tried to refresh the page 2 times and nothing happened.

The Query Status reads the following:

------ Query Status ------ 
Time Elapsed: 00:646:56, State: Repair with keycache, Query:                  ALTER TABLE post                 ADD  INDEX threadid_visible_dateline (threadid,visible,dateline,userid,postid) 
------ Query Status ------ 
Time Elapsed: 00:580:30, State: Locked, Query:                  ALTER TABLE post                 ADD  INDEX threadid_visible_dateline (threadid,visible,dateline,userid,postid) 
------ Query Status ------ 
Time Elapsed: 00:13:54, State: Locked, Query:                  ALTER TABLE post                 ADD  INDEX threadid_visible_dateline (threadid,visible,dateline,userid,postid)

Number of rows in my database in increasing and decreasing by several thousands up and down.



notes:
- im not usung INDEX
- my POST has 1,726,880 rows



Any advice?

[Paul M]

You are better off using the CLI upgrade if you can.

If not, just restart the upgrade and it should carry on from where it got to.

Adding new idexes to that big a Post table is going to take time, so the browser upgrade will timeout.

[raei]

Using the CLI..


I got...


Upgrading to 4.0.0 Alpha 1
----------------------------------
Step 105 -
Creating index ipaddress on post

----------------------------------
137 when fixing table
----------------------------------

### vBulletin Database Alter ###
ALTER TABLE post
ADD INDEX ipaddress (ipaddress)



I have run it again and the same message came

[raei]

I have repaired the table POST, and the same issue came again using CLI


This is what I get:
sudo -u #USERNAME# php -f upgrade.php

Upgrading to 4.0.0 Alpha 1
----------------------------------
Step 105 - Creating index ipaddress on post

----------------------------------
Query execution was interrupted
----------------------------------

### vBulletin Database Alter ###
ALTER TABLE post
ADD INDEX ipaddress

I ran it a second time and got:
sudo -u #USERNAME# php -f upgrade.php

Upgrading to 4.0.0 Alpha 1
----------------------------------
Step 105 - Creating index ipaddress on post

----------------------------------
137 when fixing table
----------------------------------

### vBulletin Database Alter ###
ALTER TABLE post
ADD INDEX ipaddress (ipaddress)


Prior to the second run I ran a repair on the post table:
mysql> repair table post;
+---------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------+--------+----------+----------+
| *#*#*#_*#*#*#.post | repair | status | OK |
+---------------------+--------+----------+----------+
1 row in set (12 min 54.59 sec)

[Wayne Luke]

Increase the amount of RAM available to PHP and the amount of time set for your Wait_timeout for the duration of the upgrade. Set them through the roof if need be. You can lower the values afterwords. Try something like 512 MB for PHP and 8 hours for your wait_timeout.

[raei]

A reply from my host:

"I tried increasing the wait timeout, but it had no impact at all. I also increased the space for the table operations to work with and that didn't help either. Ram for PHP wouldn't matter since it's failing on the mysql server side. Does VB have any other methods for this?"

[Wayne Luke]

Run this query directly in the MySQL command window: ALTER TABLE post ADD INDEX ipaddress;

Rerun the upgrade tool when it completes. Should detect the index and continue.

[raei]

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Wayne Luke]

ALTER TABLE post
ADD INDEX ipaddress (ipaddress);

Should be a valid query. What did you enter?