| Author |
Topic |
|
sandlu
Starting Member
17 Posts |
 Posted - 2008-07-01 : 14:52:15
|
| One of our prod server was terminated unexpectly this morning. Could you help me to figure out the problem.here is the log:SQL Server is terminating because of fatal exception e06d7363. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).here is the dump file:===================================================================== BugCheck Dump ===================================================================== This file is generated by Microsoft SQL Server version 9.00.3159.00 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 time is 09:30:12 07/01/08. 4 Unknown CPU 9., 3591 Mhz processor (s). Windows NT 5.2 Build 3790 CSD Service Pack 1. Memory MemoryLoad = 97% Total Physical = 6143 MB Available Physical = 140 MB Total Page File = 9884 MB Available Page File = 3632 MB Total Virtual = 8388607 MB Available Virtual = 8382009 MB **Dump thread - spid = 124, PSS = 0x000000010DCF7BD0, EC = 0x000000010DCF7BE0 ***Stack Dump being sent to F:\MSSQL\MSSQL.1\MSSQL\LOG\SQLDump0003.txt * ******************************************************************************* * * BEGIN STACK DUMP: * 07/01/08 09:30:12 spid 124 * * ex_handle_except encountered exception E06D7363 - Server terminating * * Input Buffer 510 bytes - * -- SQL diagnostic manager -- Copyright © 2005-2006, BBS Tec * hnologies, Inc., All Rights Reserved. -- Portions Copyright © 1995-2004 * , NetIQ Corporation, All Rights Reserved. set transaction isolation l * evel read uncommitted set lock_timeout 20000 set implicit_transact * ions off if @@trancount > 0 commit transaction set language us_eng * lish set cursor_close_on_commit off set query_governor_cost_limit * 0 set numeric_roundabort off --------------------------------------- * ----------------------------------------- -- Batch: Disk Drives -- T * ables: #disk_drives_fileview -- Variables: none --------------------- * ----------------------------------------------------------- declare * @command nvarchar(4000), @dbname varchar(255), @cmptlevel smallint * , @curconfig int if (select isnull(object_id('tempdb..#disk_drive * s_fileview'), 0)) = 0 begin create table #disk_drives_fileview ( * drive_letter char(1), unused_size dec(18,0), total_size dec(18,0 * )) end else truncate table #disk_drives_fileview -- Populate unu * sed disk space stats insert into #disk_drives_fileview(drive_letter, un * used_size) exec master..xp_fixeddrives -- Check for ole automation * select @curconfig = value from master..syscurconfigs where config = 1638 * 8 if (@curconfig is null) select @curconfig = case when object_id * ('master..sp_OACreate') is not null then 1 else 0 end if (isnull(@cur * config,1) > 0) select @curconfig = (isnull(value,0) * -1) + 1 fr * om master..syscurconfigs where config = 1546 if (isnull(@ * curconfig,-1) > 0) begin declare @hr int, @FileSystemObject * int, @FsoDrive int, @driveletter char(1), @totalSize nvarchar(5 * 0) exec @hr=sp_OACreate 'Scripting.FileSystemObject',@FileSystemObj * ect out if (@hr = 0 ) begin declare read_disk_size insensi * tive cursor for select drive_letter from #disk_drives_filevie * w for read only open read_disk_size fetch next from read_dis * k_size into @driveletter while @@fetch_status = 0 begin e * xec sp_OAMethod @FileSystemObject,'GetDrive', @FsoDrive out, @drivelette * r exec sp_OAGetProperty @FsoDrive,'TotalSize', @totalSize out * update #disk_drives_fileview set total_size = convert(dec( * 18,0),@totalSize) where drive_letter = @driveletter fet * ch next from read_disk_size into @driveletter end close read_dis * k_size deallocate read_disk_size end end select * from #disk_d * rives_fileview * |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 14:53:53
|
| Is your Service packs and hot fixes upto date? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sandlu
Starting Member
17 Posts |
Posted - 2008-07-01 : 15:06:40
|
quote:
Originally posted by sodeep
Is your Service packs and hot fixes upto date?
Thank you.Yes, the sql server has sp2 installed, but for hotfix, we only installed when necessary. |
|
|
|
sandlu
Starting Member
17 Posts |
Posted - 2008-07-01 : 15:08:01
|
quote:
Originally posted by tkizer
You'll need to open a case with Microsoft on this.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thanks, Tara, any clue? sql bug or application code problem. we are using the third party application. We may need to contact the vendor?Thanks |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sandlu
Starting Member
17 Posts |
Posted - 2008-07-01 : 15:32:38
|
quote:
Originally posted by tkizer
Access violations are typically sql bugs.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Will microsoft charge for openning a call with this case? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sandlu
Starting Member
17 Posts |
Posted - 2008-07-01 : 16:00:55
|
quote:
Originally posted by tkizer
I've heard that they do not charge when they've found the issue to be a sql bug.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog
Thanks, Tara. |
|
|
|
|
SQL 2005 terminated unexpectly