Início > SQL Server > SQL Server: EXCEPTION_ACCESS_VIOLATION when Updating Statistics

SQL Server: EXCEPTION_ACCESS_VIOLATION when Updating Statistics

ISSUE:
Hello everyone, I got an incident when running update statistic on SCCM database.
the UpdateStat was generating lots of dump file with the error bellow:

***Stack Dump being sent to I:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0048.txt
SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*
* BEGIN STACK DUMP:
*   02/29/16 14:38:56 spid 55
*
*
*   Exception Address = 000007FEF15DB985 Module(sqllang+000000000068B985)
*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
*   Access Violation occurred reading address 0000000000000000
* Input Buffer 50 bytes –
*             sp_updatestats

CAUSE:
The issue was caused because database is configured to automatically update statistics and one statistic got corrupted.

RESOLUTION:
– Run sp_updatestats again and check in which table the error is ocurring.

Updating [dbo].[PullDPResponse]

Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.
Msg 0, Level 20, State 0, Line 0
A severe error occurred on the current command.  The results, if any, should be discarded.

– Now we know statistics on [dbo].[PullDPResponse] is corrupted. Lets check stats individually to identify which one is corrupted. That table has two:

DBCC SHOW_STATISTICS(‘PullDPResponse’,’PullDPResponse_PK’);   <– It works
DBCC SHOW_STATISTICS(‘PullDPResponse’,’_WA_Sys_08000002_59A78896′)   <– Not working

– Lets drop corrupted stats:

DROP STATISTICS PullDPResponse._WA_Sys_08000002_59A78896;

– Now we are good need to update all stats to make sure everything is fine.

sp_updatestats

Categorias:SQL Server
  1. Nenhum comentário ainda.
  1. No trackbacks yet.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s

%d blogueiros gostam disto: