Thursday, March 8, 2012

[PRB SQL 2k SP4] SqlMail: fatal exception c0000005

Hello,
on one server that I build to test the SP4, I've got constantly a fatal
exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail (when
it notifies after a job, linked to a maintenance plan).
I did install this server following the rpocedure for our production server,
which does not experiment this error at all.
I've been unable to locate relevant information even after extensive search.
Any thought about it? Any similar experience somebody?
Thanks,
Emmanuel
PS: the beginning of the crash dump text file is as follows (edited):
================================================== ===================
BugCheck Dump
================================================== ===================
This file is generated by Microsoft SQL Server 8.00.2039
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.
Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
Current time is 00:52:46 08/12/05.
1 Intel x86 level 6, 3 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 70%
Total Physical = 1023 MB
Available Physical = 304 MB
Total Page File = 2463 MB
Available Page File = 1424 MB
Total Virtual = 2047 MB
Available Virtual = 931 MB
*Stack Dump being sent to e:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDu
mp0014.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 08/12/05 00:52:46 spid 59
*
* Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
0+000
00000)
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 0864FF90
* Input Buffer 1178 bytes -
* DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a summ
* ary of the automated maintenance carried out for plan ' + datename(dw
* , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
* + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy, ge
* tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients = 'emmanue
* l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
* - SQL-SP4\User Databases (Success)', @.message = @.msg, @.attachments
* = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User Databases4_2005
* 08120045.txt'
*
AV normally means a bug in sqlserver. You might want to contact PSS. This
call should not be charged.
http://support.microsoft.com/oas/def...92&gprid=36498
-oj
"Emmanuel" <Emmanuel@.discussions.microsoft.com> wrote in message
news:291AF677-3E24-49C7-8354-D3675363A55E@.microsoft.com...
> Hello,
> on one server that I build to test the SP4, I've got constantly a fatal
> exception c0000005 EXCEPTION_ACCESS_VIOLATION, which is due to SqlMail
> (when
> it notifies after a job, linked to a maintenance plan).
> I did install this server following the rpocedure for our production
> server,
> which does not experiment this error at all.
> I've been unable to locate relevant information even after extensive
> search.
> Any thought about it? Any similar experience somebody?
> Thanks,
> Emmanuel
> PS: the beginning of the crash dump text file is as follows (edited):
> ================================================== ===================
> BugCheck Dump
> ================================================== ===================
>
> This file is generated by Microsoft SQL Server 8.00.2039
> 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.
> Bios Version is Phoenix ROM BIOS PLUS Version 1.10 A11
> Current time is 00:52:46 08/12/05.
> 1 Intel x86 level 6, 3 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 70%
> Total Physical = 1023 MB
> Available Physical = 304 MB
> Total Page File = 2463 MB
> Available Page File = 1424 MB
> Total Virtual = 2047 MB
> Available Virtual = 931 MB
> *Stack Dump being sent to e:\Program Files\Microsoft SQL
> Server\MSSQL\log\SQLDu
> mp0014.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 08/12/05 00:52:46 spid 59
> *
> * Exception Address = 77F8206B (RtlEnterCriticalSection + 0000000B Line
> 0+000
> 00000)
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 0864FF90
> * Input Buffer 1178 bytes -
> * DECLARE @.msg varchar(255) SELECT @.msg = 'The attached report is a
> summ
> * ary of the automated maintenance carried out for plan ' +
> datename(dw
> * , getdate()) + ' ' + convert(varchar, datepart(dd, getdate())) + ' '
> * + datename(mm, getdate()) + ' ' + convert(varchar, datepart(yy,
> ge
> * tdate())) + ':' + CHAR(13) EXEC xp_sendmail @.recipients =
> 'emmanue
> * l@.mycompany.com', @.subject = 'SQL Server DB Maintenance Report
> * - SQL-SP4\User Databases (Success)', @.message = @.msg,
> @.attachments
> * = 'E:\Program Files\Microsoft SQL Server\MSSQL\LOG\User
> Databases4_2005
> * 08120045.txt'
> *
>

No comments:

Post a Comment