Full text Index
-
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
-
With this line
6/25/2007 04:00:10 Add The project has been paused, (80041811 - The disk is full and the specified operation cannot be done. )
I would check the free space on all drives especially C and and drives where databases transaction logs and the temp db are located, sounds like the space is choking the process and you may need to do some cleanup or compress some files (website logs, reporting services logs, text files, help files, other things no used often or when used no performance hits would be noticed) to improve the amount of free space.
-
Thanks for your reply.
Thing is geting worse. we lost our Fulltext Function and already open a cast to Microsoft.
I will update this after we fixed problem.
Thanks
-
Root Cause (if known) - Memory resource contention
Resolution: Add more RAM!
A possible work around: Stop the MSSearch service, reconfigure SQL Server to use a maximum of 800 MB of fixed memory, stop the SQL Server service, restart the MSSearch service and restart the SQL Server service.
Configuring SQL Server to use only 800 MB of memory will allow 1.2 GB of memory to be used by the MSSearch service and the operating system.
"Known is a drop, Unknown is an Ocean"
-
This is great! though its been a long gap, this solution worked very well..:hehe:
Thanks a ton Newbie!
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply