XF 2.0 2.1.0 Upgrade problem

[zuffenhausen]

I am halfway through the upgrade but keep getting errors on step 18

[~/public_html/community]$ php cmd.php xf:upgrade
Current version: 2010010 (step 17)
Upgrade target: 2010070 (2.1.0)
Are you sure you want to continue with the upgrade? [y/n] y

Running upgrade to 2.1.0 Alpha, step 18...Segmentation fault

or

[~/public_html/community]$ php cmd.php xf:upgrade
Current version: 2010010 (step 17)
Upgrade target: 2010070 (2.1.0)
Are you sure you want to continue with the upgrade? [y/n] y

Running upgrade to 2.1.0 Alpha, step 18...
In AbstractStatement.php line 217:

MySQL query error [1205]: Lock wait timeout exceeded; try restarting transaction

I have been running the command for a few hours now, it always crashes with one of these two errors, any help appreciated.

 

[AndyB]

Did you get this message when you first started?

 

[Slavik]

Did you get this message when you first started?

Considering hes posting the command line readouts, yes....

I have been running the command for a few hours now, it always crashes with one of these two errors, any help appreciated.

Have your host increase the innodb_lock_wait_timeout

 

[zuffenhausen]

Have your host increase the innodb_lock_wait_timeout

They refused.... said it would affect other sites on the shared host.
I took everything local and finished the upgrade but after reuploading there seems to be database issues.
Trying to run an optimise now.

 

[Ozzy47]

Sounds like it is time to look around for a new host.

 

[zuffenhausen]

Sounds like it is time to look around for a new host.

Yes that has already started but my priority is getting back online.

 

[zuffenhausen]

I am getting "An unexpected database error occurred. Please try again later." when hitting the homepage ,I have however got into the ACP. Most things I select in the ACP results in "An error occurred while the page was being generated. Please try again later."
Nothing in the server logs though. Any ideas?

 

[Paul B]

I don't get that error but the CSS is failing to load - the console reports a 500 error.

You will have to get your host to check the server error log to determine what's causing it.

 

[zuffenhausen]

In the end I took all the data locally, ran the upgrade then migrated to a new host and VPS.