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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-06-19 : 12:49:08
|
| Hi,Can anyone help me with this! I am concerned about this error msg.*Stack Dump being sent to P:\Program Files\Microsoft SQL Server\MSSQL\log\SQL00010.dmp2003-06-19 07:30:26.78 server process_commands: Process 424 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.* ********************************************************************************* BEGIN STACK DUMP:* 06/19/03 07:30:26 spid 0*process_commands: Process 424 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.* Exception Address = 00BF7331 (ConnectionPreLogin + 000001CB Line 0+00000000)* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION* Access Violation occurred writing address 00202024** MODULE BASE END SIZE* sqlservr 00400000 00B19FFF 0071a000* ntdll 77F80000 77FFAFFF 0007b000-- so on and so forth--Thanks,Sarat**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-19 : 13:42:35
|
| There are lots of reasons why you could get this. You need to search MS' knowledge base to figure out which article matches your environment. Search it on c0000005 EXCEPTION_ACCESS_VIOLATION.Here's the url:[url]http://support.microsoft.com/[/url]Tara |
 |
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-06-19 : 15:09:28
|
| There are so many access violation bugs in SQL Server. As a mater of fact we did go through whole lot mess to correct on one of the prod server. Check outBug # 58179Bug # 54013Bug 350968 |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-20 : 00:08:15
|
| Sarat,Call MS Product support. Access violations are (typically) bugs, and the support fee will be refunded. You may want to make sure you are on the latest SP first.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
chadmat
The Chadinator
1974 Posts |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-06-20 : 14:54:56
|
| Hey Chad, I reviewed the error log thoroughly (I think) and I was also able to reproduce all of the stack dumps (4) which occurred in last 1 yr.We are not on SP3 but we are reviewing SP3a and hopefully we will be comfortable applying sp3a in another month or so.There are 2 types of errors that have occurred.1. Cross database queries using Linked Server setup. I have Production linked to Dev via Local Login (just Windows login doesn't work) with remote user as 'sa'. Whenever this query is run, we get expected output but dump occurs.2. Our ServerAdmin ran vulnerability scanner which caused yesterday's error.So now we know the cause now but don't understand the reason/know the fix.I guess as long as these stack dumps don't bring down the sql server service or affect perfomance, I may not worry about these!Thanks,Sarat.**To be intoxicated is to feel sophisticated, but not be able to say it.** |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-20 : 15:23:44
|
| If they continue after you apply SP3a, then I would contact support.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
|
|
|
|
|
SQL Stack Dump