all groups > sql server full text search > july 2003 >
You're in the

sql server full text search

group:

Strange problem Starting/Stopping FTS



Strange problem Starting/Stopping FTS Greg D. Moore (Strider)
7/29/2003 1:22:31 AM
sql server full text search:
Ok, yet another strange FTS problem.

We're still running SQL 7.0 SP2 (can't upgrade yet) under Windows 2000.
We've had more than our share of FTS issues.

So the latest is, on our primary, I build a brand new catalog of our main
table. No problems.

4-5 days later, it finishes.

So then I started the incremental. Ran no problem. (before it appeared to
run, but then never updated the catalog. More on that in a moment.)

Stop the service. Perform a copy of the files to a backup location. (just
in case something happens.)

I restart the service. Next day I check and the incremental has run, but
there is no change in the catalog. (i.e. no new rows added).

Now that I think back, the last two times I rebuilt the catalog I probably
did the backup BEFORE I did my first incremental.

So it looks like somehow stopping and then restarting the MSSearch Service
"breaks" my ability to perform incrementals.

I've rebooted the server this morning and performed another incremental.
Again, no updates.


Errors in the errorlog include:

One or more warnings or errors for Gatherer project <SQLServer
SQL0000700005> logged to file
<e:\SQL_DATA\FTDATA\SQLServer\GatherLogs\SQL0000700005.5.gthr>.

Unable to access crawl seed <MSSQL://LOCALHOST/7.194867811> in project
<SQLServer SQL0000700005>. Error: 8007042b - The process terminated
unexpectedly. .

(those both occurred about 1 hour after the incremental started)

Then several hours when it's done:


The description for Event ID ( 3047 ) in Source ( Microsoft Search ) cannot
be found. The local computer may not have the necessary registry information
or message DLL files to display messages from a remote computer. The
following information is part of the event: SQLServer SQL0000700005,
6575312, 0, 20, 866.

Detected 19 URLs that could not be reached or were denied access in project
<SQLServer SQL0000700005>.

The Gather log is:

d1f7a4bf 1c3550d 4000000f 0 0
578a229b 1c3550f 40000017 0 0
dba48911 1c35516 MSSQL://LOCALHOST/7.194867811 8000000c 0 8007042b
bf04d596 1c35529 mssql://localhost/7.194867811.896/004a6b60 8000000c 1
80041201
bf0e5eea 1c35529 mssql://localhost/7.194867811.896/004a6b5a 8000000c 1
80041201
bf0e5eea 1c35529 mssql://localhost/7.194867811.896/004a6b61 8000000c 1
80041201
bf10c13f 1c35529 mssql://localhost/7.194867811.896/004a6b65 8000000c 1
80041201
3cce1592 1c35538 mssql://localhost/7.194867811.896/004a6b66 8000000c 1
80041201
3cd53c91 1c35538 mssql://localhost/7.194867811.896/004a6b56 8000000c 1
80041201
3cda013b 1c35538 mssql://localhost/7.194867811.896/004a6b68 8000000c 1
80041201
3cda013b 1c35538 mssql://localhost/7.194867811.896/004a6b59 8000000c 1
80041201
3cdec5e5 1c35538 mssql://localhost/7.194867811.896/004a6b58 8000000c 1
80041201
3ce38a8f 1c35538 mssql://localhost/7.194867811.896/004a6b57 8000000c 1
80041201
3ce5ece4 1c35538 mssql://localhost/7.194867811.896/004a6b55 8000000c 1
80041201
3ce5ece4 1c35538 mssql://localhost/7.194867811.896/004a6b62 8000000c 1
80041201
3ce5ece4 1c35538 mssql://localhost/7.194867811.896/004a6b5d 8000000c 1
80041201
3ce84f39 1c35538 mssql://localhost/7.194867811.896/004a6b5c 8000000c 1
80041201
3ce84f39 1c35538 mssql://localhost/7.194867811.896/004a6b64 8000000c 1
80041201
3ce84f39 1c35538 mssql://localhost/7.194867811.896/004a6b63 8000000c 1
80041201
3ceab18e 1c35538 mssql://localhost/7.194867811.896/004a6b5e 8000000c 1
80041201
3ceab18e 1c35538 mssql://localhost/7.194867811.896/004a6b5b 8000000c 1
80041201
3ceab18e 1c35538 mssql://localhost/7.194867811.896/004a6b67 8000000c 1
80041201


Help! I need an effective way to build this, perform backups and continue
to do incrementals.


--
--
Greg D. Moore
President Green Mountain Software
Personal: http://stratton.greenms.com

Strange problem Starting/Stopping FTS Hilary Cotter
7/29/2003 4:49:51 AM
Greg, I tried to replicate your problem on my SQL 7 Sp4
machine and could not seem to do it.

Your gatherer log reflects all successes, run incidentedly
at 12:00 am? I'm not sure if this is correct. Any way to
post the log as an attachement or send it to me offline?

It's also unclear if the error message is relating to a
particular table which your are tyring to index or a row?

How many tables are you FTI'ing?

[quoted text, click to view]
Re: Strange problem Starting/Stopping FTS Greg D. Moore (Strider)
7/29/2003 1:22:34 PM

[quoted text, click to view]

Well, I've never had this happen on my other SP2 machine either. ;-) So I'm
confused. :-)

[quoted text, click to view]

Which log are you looking for? I can send it to you.

[quoted text, click to view]

Beats me. ?:-)

[quoted text, click to view]

Just one.


AddThis Social Bookmark Button