 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / May 2007sql 2000 Fulltext hanging on reindex
Hi, when triying to reindex a full text catalog of 25 million rows, the process hangs when reaching the row 7 to 12 million, after 12 hours of runing. its a 4cpu and 4gb server it has 30gb of free disk space. some of the errors are this.... Eventid: 3010 The transaction cannot be appended to the project <SQLServer SQL0000800005> queue. File: F:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000800005\SQL0000800005.Ntfy1.gthr. Error: 80070021 - The process cannot access the file because another process has locked a portion of the file. . Eventid:3011 The transaction cannot be updated in the project <SQLServer SQL0000800005> queue. File: F:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000800005\SQL0000800005.Crwl0.gthr. Error: 8007054e - Unable to complete the requested operation because of either a catastrophic media failure or a data structure corruption on the disk. . Eventid:3015 The transaction file on project <F:\Program Files\Microsoft SQL Server\MSSQL\FTDATA\SQL0000800005\SQL0000800005.Crwl0.gthr> cannot be read. Error: Unable to complete the requested operation because of either a catastrophic media failure or a data structure corruption on the disk. - %4. Eventid: 3025 The critical error 9 occurred in project <SQLServer SQL0000800005>. Error: 8007054e - Unable to complete the requested operation because of either a catastrophic media failure or a data structure corruption on the disk. . The project has been shut down. The system is probably low on the resources. Free up resources and restart the service. any idea? greetings! Sounds like you have disk problems or catalog corruption problems. Can you run a checkdisk on your disk. It if comes back clean can you try to drop and recreate your catalog(s)?  SignatureLooking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi, when triying to reindex a full text catalog of 25 million rows, the > process hangs when reaching the row 7 to 12 million, after 12 hours of [quoted text clipped - 34 lines] > any idea? > greetings! disks already cheked , the catalog was recreated many times, always with the same error. is there any "good practice" on populating large FT indexes? greetings Mauro > Sounds like you have disk problems or catalog corruption problems. Can you > run a checkdisk on your disk. [quoted text clipped - 39 lines] >> any idea? >> greetings! Is it possible you have some antivirus software running on this machine or another process which is accessing some of the catalog files? You may need to run filemon to determine this. SignatureLooking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > disks already cheked , the catalog was recreated many times, always with > the same error. [quoted text clipped - 45 lines] >>> any idea? >>> greetings! Tnks Hilary i ll check that Mauro > Is it possible you have some antivirus software running on this machine or > another process which is accessing some of the catalog files? You may need [quoted text clipped - 49 lines] >>>> any idea? >>>> greetings! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.