I share with you a problem I had recently on SSIS .
Problem Description: When you start treatments in parallel, your SSIS packages fail error. You have two servers and one reproduces this behavior.
You got the following error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
Cause: We initially verified that the versions of drivers were exactly the same on both servers.
— The server with the issue was in DataAccess64 Sybase build 15.05.00. 9000
— The server without the issue was in DataAccess64 Sybase build 15.05.00. 1015
Resolution: We have copied only directories DataAccesset DataAccess64 Sybase client (build 15.05.00.1015) to the client installed (build 15.05.00.9000).
The problem has been fixed with this workaround.
If you can not fix your problem I invite you to generate a dump, then call MS support.
Michel Degremont | Premier Field Engineer — SQL Server Core Engineer |
I’ve started seeing an AccessViolationException being thrown in my application a several different spots. It never occured on my development pc, our test server. It also only manifested itself on 1 of our 2 production servers. Because it only seemed to happen on one of our production servers, I started looking at the installed .net framework versions on the servers.
I found that (for some strange reason), the production server that was having problems had 2.0 sp2, 3.0 sp2, and 3.5 sp1, while the other production server and the test server had 2.0 sp1.
My app only targets the 2.0 framework, decided to uninstall all the framework versions from the production server and install only 2.0 sp1. So far I have not been able to reproduce the problem. Very interesting.
Development pc: compact 2.0 sp2, compact 3.5, 2.0 sp2, 3.0 sp2, 3.5 sp1 Test server: 2.0 sp1 Production server1: 2.0 sp1 Production server2: 2.0 sp2, 3.0 sp2, 3.5 sp1
Now, why I can’t reproduce the problem on my development pc which has 2.0 sp2 on it, I can’t figure out. I heard rumors that this access violation may happen on some software that utilizes remoting, which mine does, but the access violation never happends when remoting is actually occuring. I’m ok with using only 2.0 sp1 for now, but I’m really interested to know if anyone has had this issue, and if they found a workaround for newer versions of the frameowork.
Here’s a couple of the exceptions and their stack traces:
I’m hoping someone can enlighten me as to what could possibly be causing this error:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
I cannot really post code because this error seems to get thrown in any random area of the application. The application will run anywhere from 12-48 hours before throwing the error. Sometimes it will stop in a seemingly random spot and throw the above error, other times the entire application stops and I get a screen with an error that says something along the lines of «There was a fatal error in. This may be a bug in the CLR or. » something about PInvoke or other non relevant info. When this happens all threads show terminated and there is no debugging information available.
In a nutshell this is what the application does:
Its a multi-threaded server application written in entirely in C#. Clients connect to the server via socket. The server runs a virtual «environment» for the clients where they can interact with each other and the environment. It consumes quite a bit of memory but I do not see it leaking. It typically consumes about 1.5GB. I dont think its leaking because the memory usage stays relatively constant the entire time the application is running. Its constantly running code to maintain the environment even if the clients are not doing anything. It uses no 3rd party software or other APIs. The only outside resources this application uses is socket connections and SQL database connections. Its running on a 64bit server. I have tried debugging this in VS2008 & VS2010 using .net 2.0, 3.5, and 4.0 and on multiple servers and the problem still eventually occurs.
I’ve tried turning off compiler optimizations and several microsoft hot-fixes. Nothing seems to make this issue go away. It would be appreciated if anyone knows any possible causes, or some kind of way to identify whats causing the problem.