EXCEPTION_ACCESS_VIOLATION efter Cumulative Patch MS03-031 ?

http://support.microsoft.com/search/default.aspx?query=EXCEPTION_ACCESS_VIOLATION&catalog=LCID%3D1033&pwt=false&title=false&kt=ALL&mdt=0&cat=true&comm=1&ast=1&ast=2&ast=3&mode=a&x=13&y=9

Har selv været forbi den her fejl tidligere. Generel løsning - Du skal patche - præcis hvad der er galt afhænger af sammenhængen når du får den.

Eksempelvis sådan:
2005-01-10 15:13:05.03 spid202  Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to e:\MSSQL\log\SQLDump0005.txt
2005-01-10 15:13:05.07 spid202  SqlDumpExceptionHandler: Process 2904 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

Har du nogle gode idéer?

Jeg går ud fra at det ikke er en generel patch...der fixer alle AV fejl...?

Præcis hvad forsøger du der trigger fejlen?  Jeg kan umiddelbart ikke regne ud hvad du anvender Windows Image Helper dll'en til - bruger du fx sp_OA funktionerne til at åbne et COM objekt - eller laver du noget i rå sql?

Bemærk i øvrigt denne her note jeg fandt et sted:

"Since DBGHELP.dll is not inherently thread-safe, making calls into it from more than one thread simultaneously may yield undefined behavior. So, if the client using the MiniDump API has multiple threads, or is called by multiple threads in a non-synchronized manner, you must make sure that all calls into DBGHELP.dll are isolated."

Jeg ANER ikke hvilken specifik kommando der forsager fejlen.
Serveren har 4 CPU'er og 4 GB RAM, og servicerer ca. 30 websites (programmeret i Perl via DBI).

Hver website har hver sin database, så der er jo konstant MANGE kald til diverse databaser.

Men det er som om at problemet med at serveren laver fejl er opstået pludseligt. Også selvom der ikke er lavet ændringer af nogen art...?

Jeg "tror" ikke, at jeg på noget tidspunkt (i hvert fald ikke med vilie) laver kald til DBGHELP.dll!

Hmm... prøv lige at geninstallere din SP4.  MS03-031 er en fix til SP3 når man checker den.

Hov vist- træt, ser lige nu at det var Win SP4 og ikke SQL SP4 der var på...  beklager...

Checkede MS - der er 37 artikler som ref. til DBGHELP.DLL og Access Vio.



  FIX: ALTER DATABASE SET READ_ONLY Statement May Lead to an Assertion If the Transaction Log is Full (318878) 
If the following conditions are true, SQL Server may encounter an assertion followed by an Access Violation (AV), which may then cause the server to either shut down or become unresponsive: An ALTER DATABASE Set Read_Only statement has been issued on... 

  FIX: SQL Server Access Violation During SSL Connection (312948) 
SQL Server 2000 may encounter an exception (access violation) during client logons when either the client or the server is configured for encrypted network communications (SSL encryption). 

  FIX: Indexed View May Cause a Handled Access Violation in CIndex::SetLevel1Names (812250) 
A query based on an indexed view may cause a handled access violation exception in the CIndex::SetLevel1Names function and end the connection of the client that submitted the query. Additionally, messages similar to the following are written to the... 

  FIX: Parallel Query May Cause an Access Violation in CBitSet::Incl (318874) 
Running a complex query that results in a parallel plan may cause an Access Violation (AV) to occur. 

  FIX: SQL Server Does Not Start and an Access Violation Occurs After You Install SQL Server 2000 Service Pack 3 (814572) 
After you install Microsoft SQL Server 2000 Service Pack 3 (SP3), Microsoft SQL Server does not start or it starts and then immediately stops, and error messages are logged in various files. For example, SQL Server generates the following access... 

  PRB: An Access Violation Occurs If the Sqlsort.dll Version Is Not Compatible with the SQL Server Version (327424) 
You receive one of the following error messages: Additionally, the Errorlog file in SQL Server 7.0 contains one of the following stack dumps: SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server... 

  PRB: SQL 2000 Server Fails to Start Due to Exception Access Violation After You Configure a High Lock Value (309435) 
After you increase the SQL Server 2000 locks configuration value to a significantly higher value, SQL Server 2000 fails to start due to a fatal Exception Access Violation (AV). The AV may occur on both SQL Server 2000 RTM and SQL Server 2000 Service... 

  FIX: An access violation exception may occur when you try to perform a Bulk Import operation to insert data in a SQL Server table (839458) 
Describes a problem that occurs when you try to perform a Bulk Import operation to transfer data from a file to a SQL Server table, and an access violation exception occurs. Includes a hotfix that you can install to resolve the problem. 

  FIX: A SELECT statement that contains computed columns and invalid filter condition values may cause an access violation (824227) 
When you run a SELECT statement on a table that contains one or more computed columns and the SELECT statement contains invalid parameter values for the filter conditions, an access violation may occur. The SELECT statement that contains the invalid... 

  SMS: Distribution Manager Causes SMS_EXECUTIVE to Stop Working If the Package Source Path Is Too Long (329110) 
After you create a new Systems Management Server (SMS) package or you update an existing package, Distribution Manager (SMS_DISTRIBUTION_MANAGER) may cause the SMS_EXECUTIVE service to stop working. If you created a new package, the last few entries... 

  FIX: A Parallel Query May Generate an Access Violation After You Install SQL Server 2000 SP3 (821548) 
After you install SQL Server 2000 Service Pack 3 (SP3), a query that uses a parallel plan may fail and cause an access violation in the ParallelPageSharedData::AddRef() function. 

  FIX: You receive an EXCEPTION_ACCESS_VIOLATION error message when you try to save a DTS package in SQL Server 2000 (830773) 
When you try to save a Data Transformation Services (DTS) package in DTS Designer as Meta Data Services , SQL Server , or Structured Storage File , you receive an EXCEPTION_ACCESS_VIOLATION error message, and the file is not saved. This problem
does... 

  FIX: Access Violation When Querying a View with a CASE WHEN EXISTS Clause and FORCEPLAN Is ON (172571) 
When querying a view with a CASE WHEN EXISTS clause and FORCEPLAN is ON, an access violation (AV) may occur. The following sample scripts demonstrate this problem: DROP TABLE t GO SELECT c = 1 INTO t UNION SELECT c = 2 DROP VIEW vT GO CREATE VIEW vT... 

  FIX: Access Violation on SELECT Statement with UNION ALL (181986) 
A handled access violation (AV) is generated if all of the following conditions are true: A SELECT statement has two sub-selects that are UNIONed together The second sub-select statement contains a sub-select that is a JOIN. Although the following... 

  PRB: Installing DA SDK Causes SQL Distributed Queries to Fail (196292) 
After installing the Microsoft Data Access 2.0 SDK, the following errors may occur when trying to perform a SQL Server 7.0 distributed query: Server: Msg 7302, Level 16, State 1 Could not create an instance of OLE DB provider '<the_ole_db_provider>'... 

  SMS: SMS Executive Crashes When Enumerating a Non-Microsoft Server (223755) 
The SMS_NT_LOGON_SERVER_MANAGER generates an access violation and causes the SMS_EXECUTIVE service to shut down if the SMS_NT_LOGON_SERVER_MANAGER attempts to enumerate a non-Microsoft server, such as a UNIX or VAX system running Advanced File and... 
  You cannot distribute software packages and the SMS_EXECUTIVE service stops after it is restarted in Systems Management Server 2003 (872779) 
Fixes a SMS 2003 problem where the SMS_DISTRIBUTION_MANAGER thread of the
SMS_EXECUTIVE service cannot process package (.pkg) files that were created in SMS 2.0 prior to an upgrade to SMS 2003. 

  BUG: Update of Text Column Using a JOIN in the UPDATE May Cause an Access Violation (283766) 
When you try to update a Text column in an update that uses a JOIN you may encounter an exception access violation (AV). The AV seems to be reproducible with specific data or a combination of data and other factors. 

  FIX: MDX Queries from Query Analyzer to a Linked Analysis Server Result in Fatal Exception (316295) 
When you execute a Multidimensional Expressions (MDX) query against a SQL Server Linked Analysis Server configured with the AllowInProcess property set to true, an error message similar to the following occurs if there are any syntax errors in the MDX... 

  SMS: SMS_EXECUTIVE Exceptions Occur When Refreshing the Stored Procedure Cache (810465) 
The Systems Management Server (SMS) SMS_EXECUTIVE service may cause an access violation when it is processing stored procedures from the SMS database. This may occur if the SMS site server is in the "(GMT+10:00) Canberra, Melbourne, Sydney" time zone.... 

  FIX: Using xp_sendmail with a COMPUTE Clause Causes an Access Violation (819955) 
A call to the xp_sendmail extended stored procedure might cause a handled Access Violation when all the following conditions are met: The xp_sendmail call must use the @query parameter to send a recordset. The query passed to the @query parameter must... 

  FIX: Invalid TDS Sent to SQL Server Results in Access Violation (818897) 
SQL Server may become unresponsive to existing and new connections. When you open the error log, you might find the following exception access violation: 2003-04-10 02:57:55.16 spid77 SqlDumpExceptionHandler: Process 77 generated fatal exception... 

  FIX: An access violation exception may occur when you run a SELECT statement that contains complex JOIN operations in SQL Server 7.0 (867763) 
An access violation occurs in CValSwitch::GetDataWithBuffer when you run a complex join query in SQL Server 7.0. To work around this behavior, force a new execution plan. To resolve this behavior, apply the hotfix discussed in this article. 

  HOW TO: Install Data Transformation Services (DTS) Event Handlers in Visual Basic (221193) 
The Data Transformation Services (DTS) events are documented in SQL Server Books Online for the package object; however, the documentation does not include the declarations for Microsoft Visual Basic to the events. This article contains a code sample... 

  FIX: Integrated Security Sprocs Have Race Condition Between Threads That Can Result in an Access Violation (238621) 
Integrated security extended stored procedures have a race condition that can result in handled access violations (AVs) within the xproc, server handled exceptions, ODS AVs, and unhandled exceptions. Procedures with this problem include: xp_logininfo... 

  FIX: Possible Denial of Service Attack with Appropriate NULL Bytes in TDS Header (248749) 
Network packets filled with appropriately placed NULL bytes may cause an access violation (AV) within SQL Server, causing the process to terminate. Prior to terminating, SQL Server will print a stack dump to the error log with text similar to the text... 

  DB2OLEDB Provider: Access Violation When Doing INSERT into DB2 Table (306427) 
When you are using the Microsoft OLE DB Provider for DB2 (DB2OLEDB) that is included with Host Integration Server 2000 to do an INSERT into a DB2 table from a SQL linked server and you are doing this by SELECTing data from a Microsoft SQL Server table... 

  FIX: Regression: AV When xp_findnextmsg Is Invoked Against an Empty Inbox (305576) 
You may see a handled access violation (AV) in SQL Server 2000 under the following conditions: A client will receive an error message that resembles the following: ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 51 generated fatal... 

  SMS Executive Causes Access Violation When Processing Prochist.dat File (241419) 
The SMS Executive service may stop responding (hang) or generate an "Access violation" error message during the processing of the Prochist.dat file. 

  BUG: Query Against Linked Server Might Cause Access Violation When the Name of One Unique Index is a Part of Another Unique Clustered Index (262541) 
A SELECT statement that uses the four-part name against a linked server, might generate an access violation if all of the following conditions are met: The OLE DB provider for ODBC Driver is chosen to create the linked server. The name of one unique... 

  BUG: Invalid Style Parameter in CONVERT Function May Cause Access Violation (269884) 
When an invalid style parameter value is used in a CONVERT function, SQL Server may generate an access violation (AV). 

  FIX: Extended Stored Procedure "xp_logevent" Generates an Access Violation When Given Too Large a Parameter (290085) 
Any string that is longer than 8000 bytes that is given as a second parameter to the xp_logevent stored procedure, causes the following error message to occur: ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 51 generated fatal... 

  FIX: xp_enumgroups Generates an Access Violation when Passed a Large Parameter (294338) 
xp_enumgroups provides a list of local Microsoft Windows NT groups or a list of global groups defined in a specified Windows NT domain, provided by the parameter. If a large parameter is passed to the xp_enumgroups stored procedure, an Access... 

  FIX: Access Violation Occurs When You Execute DBCC SHOWCONTIG Followed by Any System Function (308749) 
After SQL Server executes a DBCC SHOWCONTIG statement, a SELECT statement from any SQL Server 2000 system function may generate an Access Violation. The following Transact-SQL command executes DBCC SHOWCONTIG followed by a SELECT from the... 
  FIX: Prepare/Execute on Query May Cause Handled Access Violation in CSsNumeric::ConvertFromStr (314117) 
If you use Prepare or Execute to submit a a query batch that contains numeric constants, a handled access violation may occur that terminates the client connection that submitted the query batch and leaves other clients unaffected. In this case, the... 

  FIX: Memory Leak May Occur When Calling Bulk Insert From a Stored Procedure (246824) 
A memory leak in Sqlservr.exe occurs with each execution of a BULK INSERT that is called from a stored procedure. If the stored procedure is run by a recurring task, it is possible to experience access violations or other errors. 

  FIX: SELECT * FROM SYSINDEXES on a database that is upgraded to SQL Server 2000 may cause an access violation (295114) 
Executing a SELECT * FROM SYSINDEXES query against a database that has been upgraded from Microsoft SQL Server 7.0 may cause an Access Violation. If an Access Violation occurs, an error message similar to the following displays in the query window:... 

--- det er lige i overkanten... prøv at sætte en server-side trace op (via Profiler'en) så du får en ide om hvad pokker den SPID der giver fejlen laver.  Hvis du får identificeret databasen og SQL'en, så kan man spore sig mere præcist ind...

Trer: Smid lige et svar, så får du points!

Nogle af problemerne var grundet af et mismatch mellem RAID FW version og RAID driver version.

Lukker og slukker.