March 8, 2005 at 11:59 am
We have a Windows 2000 server and SQL Server 2000. We are using Full Text indexing and a table with 3,000,000 records. When the population of the catalog is initiated it chugs along, but when we come back it seems to have gone through the rows yet the status says shutdown and not all of the rows were indexed. It stays in this state indefinitely. I had trouble even finding out what each of the status' mean. Any clues?
Thanks,
JimK
March 9, 2005 at 5:14 am
are there any informational messages in the event log from mssearch or mssci?
A population of 30,000,000 rows will take several days.
March 9, 2005 at 9:07 am
Nothing in the application log other than that the crawl started. We are running it now and it should be complete by 12 PST. I'll keep an eye on it and see if it's successful. Thanks.
March 14, 2005 at 9:48 am
OK, when it runs the Incremental population it is bombing. Full population after rebuild works no problems. Application log has many of these error messages.
The transaction cannot be updated in the project <SQLServer SQL0000700005> queue. File: d:\MSSQL\FTDATA\SQL0000700005\SQL0000700005.Crwl2.gthr. Error: 8007054e - Unable to complete the requested operation because of either a catastrophic media failure or a data structure corruption on the disk.
Checked the disk and all are healthy, disk space is not an issue either.
Disk config is RAID 5 W/2 Vol. C: 20Gig(16Free) D:526Gig (473Free)
OS on C:, SQL & Data on D:
Win2k Server sp4, SQL SERVER 2000 SP3
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply