v7.9.2 Upgrade Wizard stalls & resets connection

nuke · 27 July 2017 14:53

I’m hoping you can provide some suggestions as to how to fix the non functioning Upgrade Wizard in v7.9.2.

I try to run the Upgrade Wizard and the first step (System Check) starts and then nothing. I get an error “The Connection was reset”. When I return to Suitecrm, I end up at the last page I was working on but not the Admin or Upgrade script.

I’ve done a “Quick Repair and Rebuild” and run the Diagnostics. There is no error in the Diagnostics. The log for upgrade is below. There are no entries after the last line.

The UpgradeWizard.log has following:

Thu, 27 Jul 2017 10:35:52 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:35:52 -0400 [UpgradeWizard] - -----------------------------------------------------------------------------
Thu, 27 Jul 2017 10:35:52 -0400 [UpgradeWizard] - Upgrade started. At start.php
Thu, 27 Jul 2017 10:35:52 -0400 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 27 Jul 2017 10:35:52 -0400 [UpgradeWizard] - finished!
Thu, 27 Jul 2017 10:35:52 -0400 [UpgradeWizard] - resetting $_SESSION
Thu, 27 Jul 2017 10:35:57 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:35:57 -0400 [UpgradeWizard] - [At systemCheck.php]
Thu, 27 Jul 2017 10:35:57 -0400 [UpgradeWizard] - Starting file permission check...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Finished file permission check.
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Starting database permissions check...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking SELECT permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - No permissions errors found!
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Finished database permissions check.
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - [At systemCheck.php]
Thu, 27 Jul 2017 10:36:30 -0400 [UpgradeWizard] - Starting file permission check...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Finished file permission check.
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Starting database permissions check...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking SELECT permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - No permissions errors found!
Thu, 27 Jul 2017 10:37:03 -0400 [UpgradeWizard] - Finished database permissions check.

Past upgrades have moved on from this point to “setting session variables…” and then “At upload.php”

What should I be trying next to upgrade to 7.9.4?

Thanks.

nuke · 27 July 2017 15:07

The most recent time I tried I get following info in the log. It looks like it is looping?

Thu, 27 Jul 2017 10:52:25 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:52:25 -0400 [UpgradeWizard] - -----------------------------------------------------------------------------
Thu, 27 Jul 2017 10:52:25 -0400 [UpgradeWizard] - Upgrade started. At start.php
Thu, 27 Jul 2017 10:52:25 -0400 [UpgradeWizard] - at unlinkUWTempFiles()
Thu, 27 Jul 2017 10:52:25 -0400 [UpgradeWizard] - finished!
Thu, 27 Jul 2017 10:52:25 -0400 [UpgradeWizard] - resetting $_SESSION
Thu, 27 Jul 2017 10:52:29 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:52:29 -0400 [UpgradeWizard] - [At systemCheck.php]
Thu, 27 Jul 2017 10:52:29 -0400 [UpgradeWizard] - Starting file permission check...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Finished file permission check.
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Starting database permissions check...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking SELECT permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - No permissions errors found!
Thu, 27 Jul 2017 10:53:01 -0400 [UpgradeWizard] - Finished database permissions check.
Thu, 27 Jul 2017 10:53:02 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:53:02 -0400 [UpgradeWizard] - [At systemCheck.php]
Thu, 27 Jul 2017 10:53:02 -0400 [UpgradeWizard] - Starting file permission check...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Finished file permission check.
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Starting database permissions check...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking SELECT permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - No permissions errors found!
Thu, 27 Jul 2017 10:53:35 -0400 [UpgradeWizard] - Finished database permissions check.
Thu, 27 Jul 2017 10:53:36 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:53:36 -0400 [UpgradeWizard] - [At systemCheck.php]
Thu, 27 Jul 2017 10:53:36 -0400 [UpgradeWizard] - Starting file permission check...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Finished file permission check.
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Starting database permissions check...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking CREATE TABLE permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking INSERT INTO permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking UPDATE TABLE permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking SELECT permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking DELETE FROM permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking ALTER TABLE ADD COLUMN permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking ALTER TABLE CHANGE COLUMN permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking ALTER TABLE DROP COLUMN permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Checking DROP TABLE permissions...
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - No permissions errors found!
Thu, 27 Jul 2017 10:54:08 -0400 [UpgradeWizard] - Finished database permissions check.
Thu, 27 Jul 2017 10:54:09 -0400 [UpgradeWizard] - setting session variables...
Thu, 27 Jul 2017 10:54:09 -0400 [UpgradeWizard] - [At systemCheck.php]
Thu, 27 Jul 2017 10:54:09 -0400 [UpgradeWizard] - Starting file permission check...

nuke · 28 July 2017 22:03

Help? Can anyone give me some ideas on what to try to get this to work?

I’m stuck on 7.9.2 and can’t downgrade or upgrade.

Thanks in advance.

labanjohnson · 13 January 2021 12:30

I guess no one has an idea. My first guess is something is timing out however the script is still running so how can that be? Anything in your error log?

pgr · 13 January 2021 12:42

This post is 3 years old…

labanjohnson · 13 January 2021 13:14

Yet no one has replied to it.