Article View: comp.databases.ms-sqlserver
Article #123Severity 19 alert question
From: Asif Bashir
Date: Wed, 08 Mar 2000 00:00
Date: Wed, 08 Mar 2000 00:00
55 lines
2583 bytes
2583 bytes
Hey all,
I received a sql server alert that an error with severity 19 has taken place
in my database. I need help in figuring out what caused this error and how
to fix it. I looked in BOL, and couldn't find anything with the same error
numer (there's plenty on severity 19 but not the error number I received).
Can anyone help? I'm attaching the alert I received, plus some text from
the dump file that was created. Any help will be appreciated.
alert
DESCRIPTION: Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 10 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
COMMENT: (None)
JOB RUN: (None)
text from dump file
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server 1792.623
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Current local time is Wed Mar 08 00:00:08 2000
1 Intel x86 level 6, 399 Mhz processor(s).
Windows NT 4.0 Build 1381 CSD Service Pack 6.
Memory
------
MemoryLoad = 12% TotalPhys = 127 MB AvailPhys = 3 MB
TotalPageFile = 243 MB
Stack Dump being sent to e:\MSSQL7\log\SQL00001.dmp
****************************************************************************
***
*
* BEGIN STACK DUMP:
* 03/08/00 00:00:08 spid 10
*
* Exception Address = 00600966 (setuser + 2d3)
* Exception Code = c0000005 E
* Access Violation occurred reading address 1AFE0000
* Input Buffer 54 bytes -
* S E T U S E R N ' d b o ' W I T H N O R E S E T
*
*
Technical Details
Message-ID:
<38c69d55$1_1@news.ghg.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10f695,8e0eb98a3a773650,start X-Google-Attributes: gid10f695,public X-Google-Thread: 104de1,8e0eb98a3a773650,start X-Google-Attributes: gid104de1,public X-Google-Thread: ff490,8e0eb98a3a773650,start X-Google-Attributes: gidff490,public From: "Asif Bashir" <abashir@ghg.net> Subject: Severity 19 alert question Date: 2000/03/08 Message-ID: <38c69d55$1_1@news.ghg.net> X-Deja-AN: 594808047 X-Trace: 8 Mar 2000 12:35:01 -0600, asifwsk.ghg.com X-MSMail-Priority: Normal X-Priority: 3 Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql,microsoft.public.sqlserver.server X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300