August 15, 2003 at 2:54 pm
I have Windows 2000 Server with SQL Server 2000 (SP3), and I'm getting errors like the folowing:
--
Error: 3624, Severity: 20, State: 1.
---
SqlDumpExceptionHandler: Process 1476 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
--
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
--
c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
--------------------------------------------------
etc
I have several large tables, and it seems that if I clear them out, the server runs fine for quite a while. But as the tables start filling up again, I have more and more problems. I don't want to have to remove the data in the tables, but it seems to lock up the SQL process if I don't do it...
Any ideas?
August 16, 2003 at 7:50 am
One thing to do is see if the dump file points to a specific query that is causing the problem, that will give you more to work with. I'd really recommend a support call, $250 cheap compared with possible data loss.
Andy
August 16, 2003 at 12:05 pm
It actually happens on multiple, unrelated queries. It's not just select queries - its' inserts & updates too... It's all over the place. But if I clear out some of the large tables, it seems to be fine (until the tables get large again.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply