Hangs on 8.1 upgrade

spdd3mn

Problems upgrading to V8.1

I run the config wizard and it hangs on

"executing sql file: on coredbscheme.dbCor"

Find more posts tagged with

db_compact

Accepted answers

All comments

spdd3mn

WOW,

It takes about 20 min for that file to run... before it completes....maybe due to size of the DB?

FormerMember

This is not a hang. We made some major changes to the database for 8.1 in order to improve maintenance. This stage of the config wizard can take a long time. For databases larger than 10GB, it can take over an hour.

Give it a long time to complete.

The payoff is that database maintenance will be much improved.

spdd3mn

thanks for replying so quick it did finish fine. I am looking foward to some of the improvements.

jtimes

it took almost 4 hours to run it on a 33Gig DB, and now the web interface is whacked out, excuse the pun...

FormerMember

John,

Have you upgraded all of your modules? Until you upgrade everything, your web console won't look right. You should be getting a call from Support shortly.

Thanks,

Denny

jtimes

I hope they call soon... I sent you a PM on this, check your inbox.

Thanks

mark_wiggans

John

The web interface will be messed up until you upgrade all of the modules.

patwill66

My database is 45 gigs. Any estimate how long it will take to run? I have am still running 7.8.5.

FormerMember

for one that large, It could be 3 or 4 hours. You should schedule it for a time where you can afford to be down. And then leave it and come back.

Network_Guru

I recommend using the Orion Database Manager to compact & rebuild each table before doing the upgrade.
You may be able to get this down to 25Gb or so.

NB. when doing the compact & rebuild of the indexes, your DB is locked & polling stats are no longer collected, so this should be done during off hours as well.