Solved

EXCEPTION_ACCESS_VIOLATION

Posted on 2006-07-21
16
452 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
Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Database maintenance 36 101
sql update 2 37
T-SQL: Need Group By to use "fuzzy logic"?? 3 18
SQL Query Across Multiple Tables - Help 5 17
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

756 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