Solved

EXCEPTION_ACCESS_VIOLATION

Posted on 2006-07-21
16
454 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 9
  • 7
16 Comments
 

Author Comment

by:luyan
ID: 17157326
It's happen when running stored procedures.
0
 
LVL 143

Expert Comment

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

Author Comment

by:luyan
ID: 17167441
SQL Server 2000 with service pack 4.
Thanks!
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 
LVL 143

Accepted Solution

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

Author Comment

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

Expert Comment

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

Author Comment

by:luyan
ID: 17177605
We have Symantec AntiVirus running on the server.  
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 500 total points
ID: 17179719
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
 

Author Comment

by:luyan
ID: 17186821
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 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17187652
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 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 500 total points
ID: 17187683
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
ID: 17188146
Thanks angelIII!  I will try it.
0
 

Author Comment

by:luyan
ID: 17192433
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 143

Expert Comment

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

Author Comment

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

Author Comment

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

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

635 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