Solved

EXCEPTION_ACCESS_VIOLATION

Posted on 2006-07-21
16
448 Views
Last Modified: 2012-05-05
In SQLDump log file, I got following error. What's wrong?  

* BEGIN STACK DUMP:                                                                                                                                  
*   Exception Address = 004314FA                                              
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION                    
*   Access Violation occurred writing address 8C478C7E                        
...        
0
Comment
Question by:luyan
  • 9
  • 7
16 Comments
 

Author Comment

by:luyan
Comment Utility
It's happen when running stored procedures.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
What version of SQL Server? What service pack?
0
 

Author Comment

by:luyan
Comment Utility
SQL Server 2000 with service pack 4.
Thanks!
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
as you have the lastest service pack, you should contact Microsoft directly with the full dump...
0
 

Author Comment

by:luyan
Comment Utility
You think it's a bug of SQL Server 2000? Sometimes it didn't happen, sometimes it happend. Thanks!
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
There is another possibility: do you have antivirus software running on the server?
0
 

Author Comment

by:luyan
Comment Utility
We have Symantec AntiVirus running on the server.  
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
Aha!!! Please configure the Antivirus to SKIP all the .mdf, .ndf, ldf files in the data folders of the databases !
that should solve the problem.
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:luyan
Comment Utility
Can you tell me how to configure the Antivirus to SKIP all the .mdf, .ndf, ldf files in the data folders of the databases? I want to take a try. Thanks!
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Well, I have no idea as I don't have Symantec Antivirus.
For a check, you might simply disable it completely for a certain time.
say the dump appears every 2-3 times per day, if disabled your sql runs for 2 days, you can assume that it was the issue.
I guess you will find some options to put exclusions or rules or something like that...

0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
See here (simple replace the files/folders of the indicated product by the folders where you have the data and log files):
http://service1.symantec.com/SUPPORT/ent-gate.nsf/docid/2002051710331354?Open&docid=2002020511514548&nsf=ent-security.nsf&view=docid/2002020511514548
0
 

Author Comment

by:luyan
Comment Utility
Thanks angelIII!  I will try it.
0
 

Author Comment

by:luyan
Comment Utility
The problem was still there after the configuration on Symantec Antivirus with SKIP all .mdf, .ndf, .ldf files.  Any other good ideas to solve the problem?   Thanks!
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
no, I have no other ideas.
0
 

Author Comment

by:luyan
Comment Utility
Thanks AngelII!  
Does anyone see the error "EXCEPTION_ACCESS_VIOLATION" before? How to fix it? Thanks!
0
 

Author Comment

by:luyan
Comment Utility
All set now. It's problem of hardware. Thanks for all your help!
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now