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