Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 456
  • Last Modified:

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                        
...        
0
luyan
Asked:
luyan
  • 9
  • 7
3 Solutions
 
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
 
luyanAuthor Commented:
SQL Server 2000 with service pack 4.
Thanks!
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
as you have the lastest service pack, you should contact Microsoft directly with the full dump...
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]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]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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 9
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now