upgrade to vb 4 Module: 400a1, Step 31 Database

[vB-Tr]

Hi l want to upgrade my web site 3.8.4 to 4.2.3

but

• Upgrading to 4.0.0 Alpha 1
• Step 31 - Updating tagcontent table
• An error has occurred with your database. Please contact vBulletin Support for assistance.
  Module: 400a1, Step 31 Database Error:1205
  Lock wait timeout exceeded; try restarting transaction
  Query:
  
  INSERT INTO tagcontent (tagid, contenttypeid, contentid, userid, dateline) SELECT tagid, 2, threadid, userid, dateline FROM tagthread ON DUPLICATE KEY UPDATE contenttypeid = 2 Please help me.

[Mark.B]

What is the "innodb_lock_wait_timeout" set to in the MySQL config?
I suggest increasing that to 500 for the purpose of upgrading.

[vB-Tr]

innodb_lock_wait_timeout 5000

http://prntscr.com/7rqj4d

[Mark.B]

Roughly how many tags do you have in the system?

[vB-Tr]

TRUNCATE tagcontent and Status: Processing 4.0.0 Alpha 1, Step 89 of 110

http://prntscr.com/7rqltq tag information

[Mark.B]

Ok, that's one way round the problem I suppose....as long as you don't value your tags.