Fulltext failure on a 2 node cluster

Giganews Newsgroups
Subject: Fulltext failure on a 2 node cluster
Posted by:  frankm (frankm@nospam.postalias)
Date: Fri, 25 Aug 2006

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
----------------------------------------------

Replies