Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2005-07-12 : 05:18:04
|
| Windows Server 2003, no SP, on 2 node MSCS Cluster, Single instance SQL Server 2K sp3a.Every morning at 06.00 AM a job run "Exec SP_Updatestats" on every database.Sunday morning something was wrong and we received the following errors on the Windows Application Event Log:17066 :SQL Server Assertion: File: <recbase.cpp>, line=1378 Failed Assertion = 'm_offBeginVar < m_SizeRec'.18052 :Error: 3624, Severity: 20, State: 1.17066 :SQL Server Assertion: File: <R:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447 Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.Error: 0, Severity: 19, State: 0SqlDumpExceptionHandler: Process 61 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.Error: 5180, Severity: 22, State: 1Could not open FCB for invalid file ID 65396 in database 'tempdb'.17310 :SqlDumpExceptionHandler: Process 2424 generated fatal exception c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.17310 :process_commands: Process 2424 generated fatal exception c000001d EXCEPTION_ILLEGAL_INSTRUCTION. SQL Server is terminating this process.Error: 0, Severity: 19, State: 0language_exec: Process 62 generated an access violation. SQL Server is terminating this process.Error: 605, Severity: 21, State: 1Attempt to fetch logical page (1:84159) in database 'MulteDisciplinari' belongs to object '-1538627214', not to object 'GeneriTarga'.Error: 605, Severity: 21, State: 1Attempt to fetch logical page (1:84155) in database 'MulteDisciplinari' belongs to object '-1962898688', not to object 'ColoriVeicolo'.The next mornig (yesterday) the same "Update statistics" job succeed, no errors generated.DBCC checkdb do NOT report any errors on Database MulteDisciplinari.SQLdump*.txt are also available to you if you need it.Please advise.CheersFranco |
|
|
|
|
|
|
|
Update statistics - related errors?