|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > EXCEPTION_ACCESS_VIOLATION during Reindex
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
EXCEPTION_ACCESS_VIOLATION during Reindex
|
|
|
| Greetings:
We've encountered the following error when a database
maintenance optimization job runs. During the job, the
command "dbcc dbreindex(N'[dbo].[tablename]', N'', 90,
sorted_data_reorg)" caused several stack dumps. Following
the last dump, I received these lines in the error log
file:
"SQL Server Assertion: File: <"xact">, line = 2149
Failed Assertion = '!m_parNestedXactCnt' Trying to use the
transaction while there are 5 parallel nested xacts
outstanding.
clean_tables_xact: active sdes for tabid 99773475720
clean_tables_xact: active sdes for tabid 99773475720
WaitForChildren: Children persisting. Retry: 2
WaitForChildren: Children persisting. Retry: 3
WaitForChildren: Children persisting. Retry: 4 ...
The "WaitForChildren" messages keep appearing every 20
seconds.
Any suggestions as to what is causing this?
NOTE: The SPID is still open and I have decided not to
kill it until I get some feedback.
Thank you.
Pete
| |
| Vikrant V Dalwale [MS] 2002-10-05, 9:12 pm |
|
Could you please post the entire errorlog ?
Thanks,
Vikrant Dalwale
Microsoft SQL Server Support Professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure ! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.
--------------------
>Content-Class: urn:content-classes:message
>From: "Pete" <powilliams@rehabcare.com>
>Sender: "Pete" <powilliams@rehabcare.com>
>Subject: EXCEPTION_ACCESS_VIOLATION during Reindex
>Date: Wed, 18 Sep 2002 08:05:59 -0700
>Lines: 30
>Message-ID: < 21cc01c25f24$e59f5100$3bef2ecf
@TKMSFTNGXA10>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>Thread-Index: AcJfJOWfPYBweViHS4O9YIdXER6n0g
==
>Newsgroups: microsoft.public.sqlserver.server
>NNTP-Posting-Host: TKMSFTNGXA10 10.201.226.38
>Path: cpmsftngxa07!cpmsftngxa08
>Xref: cpmsftngxa07 microsoft.public.sqlserver.server:3709
>X-Tomcat-NG: microsoft.public.sqlserver.server
>
>Greetings:
>
>We've encountered the following error when a database
>maintenance optimization job runs. During the job, the
>command "dbcc dbreindex(N'[dbo].[tablename]', N'', 90,
>sorted_data_reorg)" caused several stack dumps. Following
>the last dump, I received these lines in the error log
>file:
>
>"SQL Server Assertion: File: <"xact">, line = 2149
>Failed Assertion = '!m_parNestedXactCnt' Trying to use the
>transaction while there are 5 parallel nested xacts
>outstanding.
>
>clean_tables_xact: active sdes for tabid 99773475720
>clean_tables_xact: active sdes for tabid 99773475720
>WaitForChildren: Children persisting. Retry: 2
>WaitForChildren: Children persisting. Retry: 3
>WaitForChildren: Children persisting. Retry: 4 ...
>
>The "WaitForChildren" messages keep appearing every 20
>seconds.
>
>Any suggestions as to what is causing this?
>
>NOTE: The SPID is still open and I have decided not to
>kill it until I get some feedback.
>
>Thank you.
>Pete
>
|
|
|
|
|