 |
 | 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 / August 2006Fulltext and cluster - odd problem
-We have a 2 node windows 2003 enterprise edition cluster (S01 and S02). -2 sql servers running in 2 different virtual servers (V01 and V02). -The V01 SQL Server's preferred node is S01 and the V02 SQL Server's preferred node is S02. -On V01 one database has fulltext catalogs. -When the V01 virtual server fails to S02, FULLTEXT will not work. -MSSEARCH is running. -Cluadmin shows FullText resource running -I have NO error messages. -Take note of the [Location of errorlog files] field. In other clusters this field is blank. -When I look at the registry key on S01 HKEY_LOCAL_MACHINE\Software\Microsoft\Search\1.0\SQLServer\SQLServer\STREAMLOGSDIRECTORY I see the path [E:\mssql\ftdata\SQLServer\GatherLogs], but it does not exist in S02 registry. This is the only reference for that path I can find. Observations........... --------------Normal running mode--------------------------------- On V01 running on S01 (V02 is on S02) Support Services - > R-Click - Full-Text Search -> Properties Default location of catalog files = E:\MSSQL\FTDATA Location of Temporary Files = C:\windows\temp\gthsrvc Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs On V02 running on S02 (V01 is on S01) Support Services - > R-Click - Full-Text Search -> Properties Default location of catalog files = F:\MSSQL$V02\FTDATA Location of Temporary Files = C:\windows\temp\gthsrvc Location of errorlog files = ---Field is BLANK--- **************************************************** --------------Failover running mode--------------------------------- On V01 running on S02 (V02 is on S02) Support Services - > R-Click - Full-Text Search -> Properties Default location of catalog files = E:\MSSQL\FTDATA Location of Temporary Files = C:\windows\temp\gthsrvc Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs On V02 running on S02 (V01 is on S02) Support Services - > R-Click - Full-Text Search -> Properties Default location of catalog files = F:\MSSQL$V02\FTDATA Location of Temporary Files = C:\windows\temp\gthsrvc Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs ---------------------------------------------- are there any messages in the error log, event log, or gatherer log?  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 > -We have a 2 node windows 2003 enterprise edition cluster (S01 and S02). > -2 sql servers running in 2 different virtual servers (V01 and V02). [quoted text clipped - 42 lines] > Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs > ---------------------------------------------- I have a guess that the issue may be related to the extraneous path in [Location of errorlog files] and I'm sure how to correct it. --In answer to your question-------------------------------- Error log - nothing Event log - nothing Gatherer Log - nothing - the logs from that date have rolled out (sample output below) 8/23/2006 9:39:46 PM Add The gatherer has started 8/23/2006 9:39:46 PM Add The initialization has completed 8/23/2006 9:59:30 PM Add Started Full crawl 8/23/2006 9:59:32 PM Add Started Full crawl 8/23/2006 9:59:34 PM Add Completed Full crawl 8/23/2006 9:59:34 PM Add Completed Full crawl > are there any messages in the error log, event log, or gatherer log? > [quoted text clipped - 44 lines] >> Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs >> ---------------------------------------------- can you failover to V2 and see if there are any entries in the gatherer log? SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 >I have a guess that the issue may be related to the extraneous path in >[Location of errorlog files] and I'm sure how to correct it. [quoted text clipped - 59 lines] >>> Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs >>> ---------------------------------------------- Not easily - I'll have to wait until either the next maint window or when it fails again. We have over 70 defcon db's on the one virtual server ... don't ask :-( > can you failover to V2 and see if there are any entries in the gatherer > log? [quoted text clipped - 63 lines] >>>> Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs >>>> ---------------------------------------------- Its common to have thousands of databases on a cluster:) SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 > Not easily - I'll have to wait until either the next maint window or when > it fails again. [quoted text clipped - 67 lines] >>>>> Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs >>>>> ---------------------------------------------- Can you tell me how to remove the extraneous entry in the [Location of errorlog files] entry? > Its common to have thousands of databases on a cluster:) > [quoted text clipped - 70 lines] >>>>>> Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs >>>>>> ---------------------------------------------- No and I wouldn't do it. It might be required. You might want to post the clustering newsgroup for more help on this problem. Here is a link to some info on full-text and cluster issues. http://www.indexserverfaq.com/clusterfailure.htm SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 > Can you tell me how to remove the extraneous entry in the > [Location of errorlog files] entry? [quoted text clipped - 73 lines] >>>>>>> Location of errorlog files = E:\mssql\ftdata\SQLServer\GatherLogs >>>>>>> ---------------------------------------------- thanks > No and I wouldn't do it. It might be required. You might want to post the > clustering newsgroup for more help on this problem. [quoted text clipped - 85 lines] >>>>>>>> E:\mssql\ftdata\SQLServer\GatherLogs >>>>>>>> ---------------------------------------------- |
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.