2005 FT - Unable to re-populate catalogue

Hi,
I have a clustered 2005 server (build 9.00.1399.06). On the server I have 3
FT catalogues.
When I created the first catalogue everything was fine. The catalogue built
fine and returns results correctly (sooo much quicker than 2000!). Then I
tried to do a full re-population.
The full text service appeared to hang and never re-populate the catalogue.
From various bits of testing I have found this:
Using sp_who and sp_lock I can see that the Gatherer spid is blocked by the
FT Monitor spid. The Gatherer has await resource of MD 24(7:0:0) which the
monitor has Sch-S lock on. Being a system process I cannot kill it. During
this time I cannot access the Full text screen in Man Studio (blocked again),
but I can query other catalogues.
When it appears to hang as above I tried stopping the FT service in cluster
admin. The process would not stop. I have to kill it using task manager.
After a restart of just the full text service I cannot access the FT
catalogue screen, though strangley I can't see any blocking. The catalogue
appears not to be rebuilt. I can query other catalogues fine. I cannot see
any blocking of gatherer (I can't see it in sp_who), or any other blocking
spids for that matter.
Last resort I restart the Full text service and SQL Service. Upon restarting
the catalogue starts repopulating straight away. I can access it in Man
Studio, it completes fine and everything is good. Until I try to start a full
population again. (BTW I've tried incremental and rebuilding - same as above
happens).
So in other words I have to restart the SQL service everytime I want to
re-populate my FT catalogue.
I'm hoping someone can help me. Any form of suggestion welcomed!
Thanks
I just found out that FT keeps a log. Here is part of todays output (it is
repeated several times):
2005-11-17 11:16:06.30 spid13s Warning: Full-text population for table
or indexed view '[IMS].[dbo].[MyTable]' failed to send batch of data to
MSFTESQL service (table or indexed view ID '1253579504', catalog ID '5',
database ID '6'). Error: 0x8001010e(The application called an interface that
was marshalled for a different thread.).
2005-11-17 11:16:16.30 spid12s The full-text catalog health monitor
reported a failure for full-text catalog "FTC_MYCatName" (5) in database
"IMS" (6). Reason code: 0. Error: 0x8001010e(The application called an
interface that was marshalled for a different thread.). The system will
restart any in-progress population from the previous checkpoint. If this
message occurs frequently, consult SQL Server Books Online for
troubleshooting assistance. This is an informational message only. No user
action is required.
2005-11-17 11:22:16.86 spid13s Informational: Reinitialized full-text
Full population for table or indexed view '[IMS].[dbo].[MyTable]' (table or
indexed view ID '1253579504', database ID '6') after a temporary failure.
Prior to error, the number of documents processed: 60800, errors encountered:
0.
"Simon" wrote:

> Hi,
> I have a clustered 2005 server (build 9.00.1399.06). On the server I have 3
> FT catalogues.
> When I created the first catalogue everything was fine. The catalogue built
> fine and returns results correctly (sooo much quicker than 2000!). Then I
> tried to do a full re-population.
> The full text service appeared to hang and never re-populate the catalogue.
> From various bits of testing I have found this:
> Using sp_who and sp_lock I can see that the Gatherer spid is blocked by the
> FT Monitor spid. The Gatherer has await resource of MD 24(7:0:0) which the
> monitor has Sch-S lock on. Being a system process I cannot kill it. During
> this time I cannot access the Full text screen in Man Studio (blocked again),
> but I can query other catalogues.
> When it appears to hang as above I tried stopping the FT service in cluster
> admin. The process would not stop. I have to kill it using task manager.
> After a restart of just the full text service I cannot access the FT
> catalogue screen, though strangley I can't see any blocking. The catalogue
> appears not to be rebuilt. I can query other catalogues fine. I cannot see
> any blocking of gatherer (I can't see it in sp_who), or any other blocking
> spids for that matter.
> Last resort I restart the Full text service and SQL Service. Upon restarting
> the catalogue starts repopulating straight away. I can access it in Man
> Studio, it completes fine and everything is good. Until I try to start a full
> population again. (BTW I've tried incremental and rebuilding - same as above
> happens).
> So in other words I have to restart the SQL service everytime I want to
> re-populate my FT catalogue.
> I'm hoping someone can help me. Any form of suggestion welcomed!
> Thanks
>
>
|||Sounds like Monitor is locking with the population process. The population
does put locks on the rows and table it is indexing to preserve
transactional consistency.
It looks like you have to do a less invasive form of monitoring.
Hilary Cotter
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
"Simon" <Simon@.discussions.microsoft.com> wrote in message
news:3B782A40-FF11-4694-B21A-0EFFBA0F5F02@.microsoft.com...[vbcol=seagreen]
>I just found out that FT keeps a log. Here is part of todays output (it is
> repeated several times):
> 2005-11-17 11:16:06.30 spid13s Warning: Full-text population for table
> or indexed view '[IMS].[dbo].[MyTable]' failed to send batch of data to
> MSFTESQL service (table or indexed view ID '1253579504', catalog ID '5',
> database ID '6'). Error: 0x8001010e(The application called an interface
> that
> was marshalled for a different thread.).
> 2005-11-17 11:16:16.30 spid12s The full-text catalog health monitor
> reported a failure for full-text catalog "FTC_MYCatName" (5) in database
> "IMS" (6). Reason code: 0. Error: 0x8001010e(The application called an
> interface that was marshalled for a different thread.). The system will
> restart any in-progress population from the previous checkpoint. If this
> message occurs frequently, consult SQL Server Books Online for
> troubleshooting assistance. This is an informational message only. No user
> action is required.
> 2005-11-17 11:22:16.86 spid13s Informational: Reinitialized full-text
> Full population for table or indexed view '[IMS].[dbo].[MyTable]' (table
> or
> indexed view ID '1253579504', database ID '6') after a temporary failure.
> Prior to error, the number of documents processed: 60800, errors
> encountered:
> 0.
> "Simon" wrote:
|||Hilary,
Thanks for your reply. I agree with the cause. However the FT Monitor
process is a system process not something I have put in place!!
I don't what it is or what it does but I can't do anything to stop it. Do
you know what this process is?
Thanks
"Hilary Cotter" wrote:

> Sounds like Monitor is locking with the population process. The population
> does put locks on the rows and table it is indexing to preserve
> transactional consistency.
> It looks like you have to do a less invasive form of monitoring.
> --
> Hilary Cotter
> 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
> "Simon" <Simon@.discussions.microsoft.com> wrote in message
> news:3B782A40-FF11-4694-B21A-0EFFBA0F5F02@.microsoft.com...
>
>
|||Is anyone able to help on this?
In short I'm trying to resolve this error:
2005-11-17 11:16:06.30 spid13s Warning: Full-text population for
table
or indexed view '[IMS].[dbo].[MyTable]' failed to send batch of data to
MSFTESQL service (table or indexed view ID '1253579504', catalog ID
'5',
database ID '6'). Error: 0x8001010e(The application called an interface
that
was marshalled for a different thread.).
Which occurs when I populate my catalogue.
Thanks
Simon