VMware Cloud Community
tafkin
Contributor
Contributor

VC upgrade 2.0.1 -> 2.5 U3 database upgrade problem

Database is SQL server 2000 standard edition (SP4) and it is running on VC server. The upgrade process run fine until it dbuhelper.exe stated that

Log for VMware VirtualCenter, pid=468, version=2.5.0, build=build-119598, option=Release, section=2

Current working directory: C:\WINDOWS\system32

HOSTINFO: Seeing Intel CPU, numCoresPerCPU 2 numThreadsPerCore 1.

HOSTINFO: This machine has 1 physical CPUS, 2 total cores, and 2 logical CPUs.

Log path: C:\Documents and Settings\All Users\Application Data\VMware\VMware VirtualCenter\Logs

Initializing SSL

Using system libcrypto, version 90709F

Vmacore::InitSSL: doVersionCheck = true, handshakeTimeoutUs = 30000000

Unable to recover from 42000:195

Unable to recover from 42000:8180

Upgrading the VM clobs....

Done upgrading the VM clobs.

Upgrading VirtualHardwareVersionNotSupportedFault's....

I'v been waiting for 2 hours now, but server doesnt seem to do anything, so I think the process is stopped/hanged.

Any suggestion?

Reply
0 Kudos
7 Replies
cfizz34
Contributor
Contributor

Did you ever get your VC upgraded? I am having the same issue.

Reply
0 Kudos
Troy_Clavell
Immortal
Immortal

be patient, get some coffee. that's a huge DB Schema change. For us going from 2.0.2 to 2.5.0U2 it took a little over an hour. Check with you DBA to see if there is activity on the DB instance.

Reply
0 Kudos
cfizz34
Contributor
Contributor

I am going from 2.5 to 2.5 U4 and it has been running over an hour and I am starting to get concerned. So even with all those failure messages yours finally did finish?

Reply
0 Kudos
Troy_Clavell
Immortal
Immortal

yes, U4 requires a DB schmema upgrade as well. Did you find out from your DBA if there is any activity on the instance? All I can say is be patient and hopefully it finishes. Did you take a backup of the DB before you started?

Reply
0 Kudos
cfizz34
Contributor
Contributor

I have a few backups but I do not think I should have keep the option to preserve events and tasks. O well gues I will wait and see what happens. I am still waiting on the DBA to come back to me.

Reply
0 Kudos
cfizz34
Contributor
Contributor

crazy a$$ thing sat at the failure screen for over 3 hours so I got tired and did a CTRL-C and that killed the dialog box and now the installation is moving forward. Not sure what it did or didn't do but at least the progress bar is moving now. BTW, the DBA stated SQL was idle during that whole process. Looks like everything is good. It finally finished.

Reply
0 Kudos
ccastaneda
Contributor
Contributor

Yeah, I had the same concern when moving from 2.5 U3 to 2.5 U4. I waited about 45 mins before it completed. My DB is about 17GB. I guess all I can say as well, is be patient.

Reply
0 Kudos