EXCEPTION_ACCESS_VIOLATION

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                        
...        
luyanAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
as you have the lastest service pack, you should contact Microsoft directly with the full dump...
0
 
luyanAuthor Commented:
It's happen when running stored procedures.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
What version of SQL Server? What service pack?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
luyanAuthor Commented:
SQL Server 2000 with service pack 4.
Thanks!
0
 
luyanAuthor Commented:
You think it's a bug of SQL Server 2000? Sometimes it didn't happen, sometimes it happend. Thanks!
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
There is another possibility: do you have antivirus software running on the server?
0
 
luyanAuthor Commented:
We have Symantec AntiVirus running on the server.  
0
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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
 
luyanAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
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
 
luyanAuthor Commented:
Thanks angelIII!  I will try it.
0
 
luyanAuthor Commented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
no, I have no other ideas.
0
 
luyanAuthor Commented:
Thanks AngelII!  
Does anyone see the error "EXCEPTION_ACCESS_VIOLATION" before? How to fix it? Thanks!
0
 
luyanAuthor Commented:
All set now. It's problem of hardware. Thanks for all your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.