Tags: bebypassed, caused, checktable, database, dbcc, exception_access_violation, level, microsoft, mysql, oracle, repair, server, specify, sql, sqldumpexceptionhandler, statement

SqlDumpExceptionHandler: EXCEPTION_ACCESS_VIOLATION

On Database » Microsoft SQL Server

13,546 words with 2 Comments; publish: Mon, 26 May 2008 08:57:00 GMT; (250271.48, « »)

How do i specify a higher repair level with "DBCC CHECKTABLE" '

"The repair level on the DBCC statement caused this repair to be

bypassed."

i seem to be getting the errors described in

http://support.microsoft.com/defaul...kb;en-us;818097

Is that it?

SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005

EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process..

*

****************************************

************************************

***

*

* BEGIN STACK DUMP:

* 07/28/04 13:49:40 spid 55

*

* Exception Address = 00000000

* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

* Access Violation occurred reading address 00000000

* Input Buffer 110 bytes -

* EXECUTE Closer '{C5D614B6-A295-438C-94B0-A0D23F00126D}'

Stack Signature for the dump is 0xC469EEC4

The exception information has been submitted to Watson error reporting.

language_exec: Process 55 generated an access violation. SQL Server is

terminating this process..

Error: 0, Severity: 19, State: 0

> DBCC CHECKDB

Server: Msg 7995, Level 16, State 1, Line 1

Database '%s' consistency errors in sysobjects, sysindexes, syscolumns, or

systypes prevent further CHECKDB processing.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

> DBCC CHECKTABLE('sysindexes')

Server: Msg 2537, Level 16, State 40, Line 1

Table error: Object ID 2, index ID 0, page (1:505), row 5. Record check

(length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 1120 and

1088.

Server: Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 2. The text, ntext, or image node at page (1:159077),

slot 5, text ID 691178962944 is not referenced.

DBCC results for 'sysindexes'.

There are 308 rows in 18 pages for object 'sysindexes'.

CHECKTABLE found 0 allocation errors and 2 consistency errors in table

'sysindexes' (object ID 2).

> DBCC CHECKTABLE ('sysindexes', REPAIR_ALLOW_DATA_LOSS)

Server: Msg 2537, Level 16, State 40, Line 1

Table error: Object ID 2, index ID 0, page (1:505), row 5. Record check

(length <= colInfo.CbMaxLen () && pCol != NULL) failed. Values are 1120 and

1088.

Server: Msg 8964, Level 16, State 1, Line 1

Table error: Object ID 2. The text, ntext, or image node at page (1:159077),

slot 5, text ID 691178962944 is not referenced.

DBCC results for 'sysindexes'.

The repair level on the DBCC statement caused this repair to be

bypassed.

The repair level on the DBCC statement caused this repair to be

bypassed.

There are 308 rows in 18 pages for object 'sysindexes'.

CHECKTABLE found 0 allocation errors and 2 consistency errors in table

'sysindexes' (object ID 2).

Here's my stored procedure, contains only tables.

CREATE PROCEDURE Closer .sqlserver.questionfor.info.SessionGUID uniqueidentifier AS

DECLARE .sqlserver.questionfor.info.WindowGUID uniqueidentifier

SET .sqlserver.questionfor.info.WindowGUID = (SELECT WindowGUID FROM Sessions

WHERE SessionGUID = .sqlserver.questionfor.info.SessionGUID)

DECLARE .sqlserver.questionfor.info.TotalCanadian money

DECLARE .sqlserver.questionfor.info.TotalUS money

DECLARE .sqlserver.questionfor.info.ImpressmentTotalCanadianLive money

DECLARE .sqlserver.questionfor.info.ImpressmentTotalUSLive money

DECLARE .sqlserver.questionfor.info.MidshiftOutstandingTotalCanadianLive money

DECLARE .sqlserver.questionfor.info.MidshiftOutstandingTotalUSLive money

SET .sqlserver.questionfor.info.TotalCanadian =

(

SELECT SUM(Amount)

FROM Closers

INNER JOIN (CloserDetails

INNER JOIN Currencies

ON CloserDetails.CurrencyGUID = Currencies.CurrencyGUID)

ON Closers.CloserGUID = CloserDetails.CloserGUID

WHERE (Currencies.CurrencyType = 'ctCanadianCash'

OR Currencies.CurrencyType = 'ctMiscellaneous'

OR Currencies.CurrencyType = 'ctTokens'

OR Currencies.CurrencyType = 'ctCanadianCoin' )

AND Closers.SessionGUID = .sqlserver.questionfor.info.SessionGUID

)

SET .sqlserver.questionfor.info.TotalUS =

(

SELECT SUM(Amount)

FROM Closers

INNER JOIN (CloserDetails

INNER JOIN Currencies

ON CloserDetails.CurrencyGUID = Currencies.CurrencyGUID)

ON Closers.CloserGUID = CloserDetails.CloserGUID

WHERE (Currencies.CurrencyType = 'ctUSCash'

OR Currencies.CurrencyType = 'ctMiscellaneousUS'

OR Currencies.CurrencyType = 'ctUSCoin' )

AND Closers.SessionGUID = .sqlserver.questionfor.info.SessionGUID

)

SET .sqlserver.questionfor.info.ImpressmentTotalCanadianLive =

(

SELECT SUM(Impressments.Amount)

FROM Impressments

INNER JOIN Currencies

ON Impressments.CurrencyGUID = Currencies.CurrencyGUID

WHERE Impressments.WindowGUID = .sqlserver.questionfor.info.WindowGUID

AND (CurrencyType = 'ctCanadianCash'

OR CurrencyType = 'ctMiscellaneous'

OR CurrencyType = 'ctTokens'

OR CurrencyType = 'ctCanadianCoin' )

)

SET .sqlserver.questionfor.info.ImpressmentTotalUSLive =

(

SELECT SUM(Impressments.Amount)

FROM Impressments

INNER JOIN Currencies

ON Impressments.CurrencyGUID = Currencies.CurrencyGUID

WHERE Impressments.WindowGUID = .sqlserver.questionfor.info.WindowGUID

AND (CurrencyType = 'ctUSCash'

OR CurrencyType = 'ctMiscellaneousUS'

OR CurrencyType = 'ctUSCoin' )

)

SET .sqlserver.questionfor.info.MidshiftOutstandingTotalCanadianLive =

(

SELECT SUM(FundsTransferDetails.Value)

FROM FundsTransferDetails

INNER JOIN FundsTransfers

ON FundsTransferDetails.FundsTransferGUID =

FundsTransfers.FundsTransferGUID

INNER JOIN Currencies

ON FundsTransferDetails.CurrencyGUID = Currencies.CurrencyGUID

WHERE FundsTransferDetails.FundsTransferMode = 'ftOrder'

AND FundsTransfers.CompletionDate IS NULL

AND FundsTransfers.WindowGUID = .sqlserver.questionfor.info.WindowGUID

AND FundsTransfers.IsVoided = 0

AND FundsTransfers.IsDraft = 0

AND (CurrencyType = 'ctCanadianCash'

OR CurrencyType = 'ctMiscellaneous'

OR CurrencyType = 'ctTokens'

OR CurrencyType = 'ctCanadianCoin' )

)

SET .sqlserver.questionfor.info.MidshiftOutstandingTotalUSLive =

(

SELECT SUM(FundsTransferDetails.Value)

FROM FundsTransferDetails

INNER JOIN FundsTransfers

ON FundsTransferDetails.FundsTransferGUID =

FundsTransfers.FundsTransferGUID

INNER JOIN Currencies

ON FundsTransferDetails.CurrencyGUID = Currencies.CurrencyGUID

WHERE FundsTransferDetails.FundsTransferMode = 'ftOrder'

AND FundsTransfers.CompletionDate IS NULL

AND FundsTransfers.WindowGUID = .sqlserver.questionfor.info.WindowGUID

AND FundsTransfers.IsVoided = 0

AND FundsTransfers.IsDraft = 0

AND (CurrencyType = 'ctUSCash'

OR CurrencyType = 'ctMiscellaneousUS'

OR CurrencyType = 'ctUSCoin' )

)

SELECT Currencies.*,

CloserDetails.Amount AS CloserAmount,

Impressments.Amount AS ImpressmentAmount,

(SELECT SUM(FundsTransferDetails.Value)

FROM FundsTransferDetails

INNER JOIN FundsTransfers

ON FundsTransferDetails.FundsTransferGUID =

FundsTransfers.FundsTransferGUID

WHERE FundsTransfers.CompletionDate IS NULL

AND FundsTransfers.ISVoided = 0

AND FundsTransfers.IsDraft = 0

AND FundsTransfers.WindowGUID = .sqlserver.questionfor.info.WindowGUID

AND FundsTransferDetails.FundsTransferMode = 'ftOrder'

AND FundsTransferDetails.CurrencyGUID = Currencies.CurrencyGUID) AS

MidshiftOutstandingValue,

(SELECT CASE

WHEN CurrencyType = 'ctCanadianCash' THEN 1

WHEN CurrencyType = 'ctMiscellaneous' THEN 2

WHEN CurrencyType = 'ctTokens' THEN 3

WHEN CurrencyType = 'ctCanadianCoin' THEN 4

WHEN CurrencyType = 'ctUSCash' THEN 5

WHEN CurrencyType = 'ctMiscellaneousUS' THEN 6

WHEN CurrencyType = 'ctUSCoin' THEN 7

END) AS CurrencyTypeOrder,

(SELECT CASE

WHEN CurrencyType = 'ctCanadianCash' THEN 0

WHEN CurrencyType = 'ctMiscellaneous' THEN 0

WHEN CurrencyType = 'ctTokens' THEN 0

WHEN CurrencyType = 'ctCanadianCoin' THEN 0

WHEN CurrencyType = 'ctUSCash' THEN 1

WHEN CurrencyType = 'ctMiscellaneousUS' THEN 1

WHEN CurrencyType = 'ctUSCoin' THEN 1 END) AS USCurrency,

.sqlserver.questionfor.info.TotalCanadian AS TotalCanadian,

.sqlserver.questionfor.info.TotalUS AS TotalUS,

.sqlserver.questionfor.info.ImpressmentTotalCanadianLive AS ImpressmentTotalCanadian,

.sqlserver.questionfor.info.ImpressmentTotalUSLive AS ImpressmentTotalUS,

.sqlserver.questionfor.info.MidshiftOutstandingTotalCanadianLive AS MidshiftOutstandingTotalCanadian,

.sqlserver.questionfor.info.MidshiftOutstandingTotalUSLive AS MidshiftOutstandingTotalUS

FROM Currencies

LEFT JOIN Impressments

ON (Impressments.CurrencyGUID = Currencies.CurrencyGUID

AND Impressments.WindowGUID = .sqlserver.questionfor.info.WindowGUID)

LEFT JOIN (Closers

INNER JOIN CloserDetails

ON Closers.CloserGUID = CloserDetails.CloserGUID)

ON (CloserDetails.CurrencyGUID = Currencies.CurrencyGUID

AND Closers.SessionGUID = .sqlserver.questionfor.info.SessionGUID)

WHERE Currencies.IsActive = 1

AND Currencies.OnCloser = 1

AND (Currencies.CurrencyType = 'ctCanadianCash' or

Currencies.CurrencyType = 'ctMiscellaneous' or

Currencies.CurrencyType = 'ctTokens' or

Currencies.CurrencyType = 'ctCanadianCoin' or

Currencies.CurrencyType = 'ctUSCash' or

Currencies.CurrencyType = 'ctMiscellaneousUS' or

Currencies.CurrencyType = 'ctUSCoin')

ORDER BY CurrencyTypeOrder, Currencies.Rank

GO

All Comments

Leave a comment...

  • 2 Comments
    • And my short stack dump

      * ----

      --

      * Short Stack Dump

      * 4589EED9 Module(UNKNOWN+00000000)

      * 004261CE Module(sqlservr+000261CE)

      (CQueryExecContext::~CQueryExecContext+0

      0000118)

      * 004260A5 Module(sqlservr+000260A5)

      (CQueryScan::ShutdownQueryExecContext+00

      00001F)

      * 0042685E Module(sqlservr+0002685E) (CQueryScan::ShutdownNormal+00000088)

      * 0041D813 Module(sqlservr+0001D813) (CStmtQuery::ErsqExecuteQuery+00000893)

      * 0041E09C Module(sqlservr+0001E09C) (CStmtDML::XretExecuteNormal+000002AE)

      * 0041DECA Module(sqlservr+0001DECA) (CStmtDML::XretExecute+0000001C)

      * 0041B442 Module(sqlservr+0001B442)

      (CMsqlExecContext::ExecuteStmts+000003B9

      )

      * 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)

      * 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)

      * 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)

      * 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)

      * 0041B442 Module(sqlservr+0001B442)

      (CMsqlExecContext::ExecuteStmts+000003B9

      )

      * 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)

      * 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)

      * 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)

      * 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)

      * 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)

      * 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)

      * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)

      * 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)

      * ----

      --

      #1; Mon, 26 May 2008 08:59:00 GMT
    • You should call product support. Start here for further info/phone numbers,

      etc... http://support.microsoft.com/defaul...id=fh;EN-US;sql

      Richard Waymire, MCSE, MCDBA

      This posting is provided "AS IS" with no warranties, and confers no rights.

      "Ian Boyd" <ian.msnews010.sqlserver.questionfor.info.avatopia.com> wrote in message

      news:eXLJJ3NdEHA.3512.sqlserver.questionfor.info.TK2MSFTNGP12.phx.gbl...

      > And my short stack dump

      > * ---

      --

      > --

      > * Short Stack Dump

      > * 4589EED9 Module(UNKNOWN+00000000)

      > * 004261CE Module(sqlservr+000261CE)

      > (CQueryExecContext::~CQueryExecContext+0

      0000118)

      > * 004260A5 Module(sqlservr+000260A5)

      > (CQueryScan::ShutdownQueryExecContext+00

      00001F)

      > * 0042685E Module(sqlservr+0002685E) (CQueryScan::ShutdownNormal+00000088)

      > * 0041D813 Module(sqlservr+0001D813)

      > (CStmtQuery::ErsqExecuteQuery+00000893)

      > * 0041E09C Module(sqlservr+0001E09C)

      > (CStmtDML::XretExecuteNormal+000002AE)

      > * 0041DECA Module(sqlservr+0001DECA) (CStmtDML::XretExecute+0000001C)

      > * 0041B442 Module(sqlservr+0001B442)

      > (CMsqlExecContext::ExecuteStmts+000003B9

      )

      > * 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)

      > * 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)

      > * 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)

      > * 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)

      > * 0041B442 Module(sqlservr+0001B442)

      > (CMsqlExecContext::ExecuteStmts+000003B9

      )

      > * 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)

      > * 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)

      > * 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)

      > * 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)

      > * 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)

      > * 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)

      > * 7800C9EB Module(MSVCRT+0000C9EB) (beginthread+000000CE)

      > * 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)

      > * ---

      --

      > --

      >

      #2; Mon, 26 May 2008 09:00:00 GMT