"Mauro SB." <msbrizuela@gmail.com> wrote in message
news:unyfwJToHHA.588@TK2MSFTNGP06.phx.gbl...
> 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)?
>
> --
> Looking 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
> "Mauro SB." <msbrizuela@gmail.com> wrote in message
> news:unyfwJToHHA.588@TK2MSFTNGP06.phx.gbl...
>> 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!
>
>

"Mauro SB." <msbrizuela@gmail.com> wrote in message
news:%23MmIfrfoHHA.588@TK2MSFTNGP06.phx.gbl...
> 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
> "Hilary Cotter" <hilary.cotter@gmail.com> escribió en el mensaje
> news:O4LTDefoHHA.3660@TK2MSFTNGP04.phx.gbl...
>> 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)?
>>
>> --
>> Looking 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
>> "Mauro SB." <msbrizuela@gmail.com> wrote in message
>> news:unyfwJToHHA.588@TK2MSFTNGP06.phx.gbl...
>>> 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!
>>
>>
>
>

> 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.
>
> --
> Looking 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
> "Mauro SB." <msbrizuela@gmail.com> wrote in message
> news:%23MmIfrfoHHA.588@TK2MSFTNGP06.phx.gbl...
>> 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
>> "Hilary Cotter" <hilary.cotter@gmail.com> escribió en el mensaje
>> news:O4LTDefoHHA.3660@TK2MSFTNGP04.phx.gbl...
>>> 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)?
>>>
>>> --
>>> Looking 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
>>> "Mauro SB." <msbrizuela@gmail.com> wrote in message
>>> news:unyfwJToHHA.588@TK2MSFTNGP06.phx.gbl...
>>>> 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!
>>>
>>>
>>
>>
>
>