Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Full Text index

Author  Topic 

Why_gh
Starting Member

3 Posts
Posted - 2007-06-25 : 11:41:33

SQL server 2000 SP4 is running on active/passive clustered nodes. Every node is Windows 2003 64bit 4 CPUs and 8GB Ram.
Pagefile.sys on C:\ Drive minimum 12285MB, maximum : 24000MB
C Drive free space : around 150G
Datafiles and FTData on D:\Drive. D Drive free space: around 400G
Log Fiels on E:\ Drive E Drive : around 200G

SQL Server Configure: see below.
I have a table with about 2100 Rows.
I have a full text search set up on this table and all the columns being indexed are type varchar
Every 2 or 3 days, I got the error, you can see from gatherer log and then SQL Server Services stopped, failed over happened
Millions of Thanks and appreciate any helps.
If you need more info, please let me know



Sp_Configure:

affinity mask -2147483648 2147483647 0 0
allow updates 0 1 0 0
awe enabled 0 1 1 1
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 6144 6144
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 1024 1024
min server memory (MB) 0 2147483647 0 0
nested triggers 0 1 1 1
network packet size (B) 512 32767 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 1 1
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections 0 32767 0 0
user options 0 32767 0 0
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.
6/25/2007 04:00:02 Add Started Incremental crawl
6/25/2007 04:00:10 Add The project has been paused, (80041811 - The disk is full and the specified operation cannot be done. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000dc2 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000005e5 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000512 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c24 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000f19 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000d58 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000d00 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000936 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000ca6 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000cf3 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c5a Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000470 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000f3d Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000004d2 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000644 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000e07 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000ebe Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000ae7 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000e17 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000007f1 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000abb Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000005ee Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000405 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000bd9 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000063a Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c09 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000084d Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000eb5 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000051e Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000064d Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000072f Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000a95 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000077 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000f34 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000ee0 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000008ff Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000009b9 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000726 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000597 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000051b Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c51 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c2d Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000dcb Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000063f Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000cfc Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000004b7 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000005c0 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000821 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000567 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000004c7 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000ab2 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000082a Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000be9 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c34 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000b46 Add Error fetching URL, (80041818 - A document update was rejected because updates were disabled. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/0000095c Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000636 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000009c9 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000e7b Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000c3d Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000008f1 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000ea8 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000515 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000b2c Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000080 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000d6e Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000e72 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000402 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000e8b Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000a00 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000d65 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000d9e Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000b5f Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000438 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000a8e Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000004e2 Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000004eb Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/000006ff Add Error fetching URL, (800704d5 - The operation could not be completed. A retry should be performed. )
6/25/2007 04:00:10 mssql75://sqlserver/6482d9eb/00000e82 Add Error fetching URL, (80070008 - Not enough storage is available to process this command. )
6/25/2007 04:01:10 mssql75://sqlserver/6482d9eb/0000040e Add Error fetching URL, (80070008 - Not enough storage is available to process this command. )
6/25/2007 04:01:10 Add The project has been resumed
6/25/2007 04:07:02 Add The gatherer has started
6/25/2007 04:07:04 Add The recovery has completed
6/25/2007 04:07:22 Add Completed Incremental crawl
6/25/2007 07:50:56 Add Started Incremental crawl
6/25/2007 07:51:22 Add Completed Incremental crawl

rmiao
Master Smack Fu Yak Hacker

7266 Posts
Posted - 2007-06-25 : 22:42:25
Checked free disk space that holds full text catalog?
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site