Re: [U2] INDEX taking forever to rebuild after server upgrade.

Chris Austin <[email protected]> Mon, 21 Apr 2014 11:51:06 -0500
Newsgroups gmane.comp.db.u2.general
Message-ID <[email protected]>
No, we have not since I wasn't sure if it was something on our end or with the new version of UniVerse. Has
this come up with anyone else by chance that you know of?

Chris


> From: [email protected]
> Date: Mon, 21 Apr 2014 09:48:07 -0700
> To: [email protected]
> Subject: Re: [U2] INDEX taking forever to rebuild after server upgrade.
> 
> Chris, did you open a support case with Rocket on this?
> 
> On Apr 21, 2014, at 9:39 AM, Chris Austin <[email protected]> wrote:
> 
> > Hello,
> > 
> > We recently upgraded to a new Windows 2012 R2 server with the latest version of UniVerse (11.2.x). Everything
> > seems to be working great except we noticed that 1 index on 1 record is taking a TON of time to do a rebuild. 
> > 
> > The basic syntax we're using is >
> > 
> > EXECUTE  'CREATE.INDEX ':FILENAME:' ':FIELDNAME
> > EXECUTE  'BUILD.INDEX ':FILENAME:' ':FIELDNAME
> > 
> > The output looks like >
> > 
> > Clearing Index File INDEX.007
> > 
> > Starting DATA processing for index 'OTHER_REF'!
> > ****************************        2251000 processed.
> > ***********
> > 
> > However, this used to finish in a couple minutes and now runs for HOURS without finishing. 
> > 
> > Any ideas what would cause this or how to remedy the situation? Maybe the index is corrupt?
> > 
> > Thanks,
> > 
> > Chris
> > 
> > 		 	   		  
> > _______________________________________________
> > U2-Users mailing list
> > [email protected]
> > http://listserver.u2ug.org/mailman/listinfo/u2-users
> 
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
 		 	   		  
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users