Reindexacion Full Text fallida

28/05/2007 - 16:03 por Mauro SB. | Informe spam
hola gente!

Al tratar de regenerar un indice fulltext sobre un atabla de mas de 20
millones de registros
luego de varias horas mas de 6, llega a procesar de 7 a 12 millones de
registros y luego queda en estado de shutdown.

estos son algunos de los mensajes de error

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.


el espacio en disco es de espacio en disco de 30,8 GB.
es un server con 4 GB de RAM

alguna idea?
saludos a todos

Mauro
 

Leer las respuestas

#1 Mauro SB.
28/05/2007 - 16:15 | Informe spam
me olvide es un 2000 sp4 con 4 procesadores y 4gb en ram!

"Mauro SB." escribió en el mensaje de noticias
news:
hola gente!

Al tratar de regenerar un indice fulltext sobre un atabla de mas de 20
millones de registros
luego de varias horas mas de 6, llega a procesar de 7 a 12 millones de
registros y luego queda en estado de shutdown.

estos son algunos de los mensajes de error

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.


el espacio en disco es de espacio en disco de 30,8 GB.
es un server con 4 GB de RAM

alguna idea?
saludos a todos

Mauro



Preguntas similares