Rather empty gatherer logs

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jack - 15 Feb 2006 16:01 GMT

I noticed that we were getting no results in our search this morning.
The records were in the DB, search terms matched when using "LIKE" but
not CONTAINS. Once I did a repopulation (incremental) all worked fine.
What I don't understand is that the repopulation is actually scheduled
to run each day at 00:00 and according to the gatherer logs, it did
run.

15/02/2006 00:00:06 Add Started Incremental crawl
15/02/2006 00:03:16 Add Completed Incremental crawl
15/02/2006 16:17:02 Add Started Full crawl
15/02/2006 16:23:30 Add Completed Full crawl

It is also puzzling that the manual repopulation (I started) says
"Started Full".

We had no errors or warnings in the application log.

Why are the gatherer logs so small/empty - its that because there were
no errors? If so, why did we get no results - I know the records were
there at 00:00.

Reply to this Message

Hilary Cotter - 15 Feb 2006 16:53 GMT

Perhaps you made a schema change at 4:17 and this triggered a full
population. I can find no record of incremental populations being kicked off
at midnight either.

Are you certain there is no incremental population scheduled at midnight? I
take it this is SQL 2000.

Signature

Hilary 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 noticed that we were getting no results in our search this morning.
> The records were in the DB, search terms matched when using "LIKE" but
[quoted text clipped - 16 lines]
> no errors? If so, why did we get no results - I know the records were
> there at 00:00.

Reply to this Message

Jack - 15 Feb 2006 20:19 GMT

> I can find no record of incremental populations being kicked off at midnight either.

What's this then?
15/02/2006 00:00:06 Add Started Incremental crawl
15/02/2006 00:03:16 Add Completed Incremental crawl

I assumed this was the scheduled midnight incremental?

You may be right about the schema change but then I am still missing my
manual incremental in the log files around this time (16:20)

Reply to this Message

Hilary Cotter - 17 Feb 2006 02:22 GMT

I meant to say, I can find no record of incremental crawls being kicked off
by default on any of my machines:) Sorry for the confusion.

It certainly looks like you somehow have an incremental crawl schededuled
for midnight. I notice that if I schedule an incremental population, by
default it is scheduled for 1 minute before midnight. Check in the
management folder to see if you have it scheduled there. It will be
categorized as Full-Text.

Signature

>> I can find no record of incremental populations being kicked off at
>> midnight either.
[quoted text clipped - 7 lines]
> You may be right about the schema change but then I am still missing my
> manual incremental in the log files around this time (16:20)

Reply to this Message

Jack - 17 Feb 2006 09:28 GMT

I think the orginal problem (no results) must be due to a schema
change. Apparently the FT Catalog gets cleared when this happens. I
still think the "Started Full crawl" is a mystery but sometimes this
happens.
Thanks
Jack

Reply to this Message