Rather empty gatherer logs

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.
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.
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
"Jack" <cawoodm@.gmail.com> wrote in message
news:1140019316.201183.231620@.g43g2000cwa.googlegr oups.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
> 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.
>
|||> 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)
|||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.
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
"Jack" <cawoodm@.gmail.com> wrote in message
news:1140034764.911389.60000@.g44g2000cwa.googlegro ups.com...
> 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)
>
|||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