The London heat wave caused disruption at our datacentre and the MOSS 2007 database Server (SQL 2005) switched off during a crawl of a large file store.
Since then the file store crawl hasn't stopped and CAN'T be stopped!
When I try to stop/pause the crawl it times out :(
I've rebooted the servers (2 Web servers, 1 SSP server and 1 DB) but it still continues to run.
BUT...
When I check file store logs, it's not actually crawling anything, it's in some sort of sorry state. SQL Server is spewing out loads of SQL dumps like:
SQLDump46311.mdmp
SQLDump46311.txt
SQLDump46312.log (extract below)
Is there a way to kill the index job on the Index server?
(Steve from Combined did state that there is a bug in MOSS2007 using
SQL Server 2005.)
Extract from SQLDump46312.log:
External dump process returned no errors.
10:31:25.32 Server Error: 17310, Severity: 20, State:
1.
10:31:25.32 Server A user request from the session
with SPID
56 generated a fatal exception. SQL Server is terminating this
session.
Contact Product Support Services with the dump produced in the log
directory.
10:31:25.70 spid56 Using 'dbghelp.dll' version '4.0.5'
10:31:25.75 spid56 ***Stack Dump being sent to
D:\Program
Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump46311.txt
10:31:25.75 spid56 SqlDumpExceptionHandler: Process 56
generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL
Server is
terminating this process.