SAP Knowledge Base Article - Preview

2526522 - Tempdb started receiving 823 and 69x errors - SAP ASE

Symptom

  • The ASE errorlog reports errors including sddone and 823 tempdb device(s):

    sddone: read error on virtual disk 94 block 1163264:
    sddone: 8192 bytes passed, 0 returned on read for virt disk 94 block 1163264

    Error: 823, Severity: 24, State: 1
    I/O error detected during read for BUF=0x0000010478e4e098, MASS=0x0000010478e4e098, Buf#=0, page=0x0000010335a4e000, dbid=2, Mass vdevno=94, vpage=1163264, Buf lpage=816640, Mass stat=0x4000100, Buf stat=0x1, size=8192, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.
  • The 823 may be followed by a stacktrace that can include

    wrongpage
    trunc_wktable
    getpage_with_validation
    pg_get_alloc_page
  • And 69x errors may also follow, also with stack traces

    Error: 691, Severity: 20, State: 1
    Encountered invalid logical page '0' while accessing database 'tempdb' (2), object '' (-70385667), index '<Unknown>' (0), partition '<Unknown>' (-70385667). This is an internal system error. Please contact Sybase Technical Support.

    Error: 692, Severity: 20, State: 1
    Uninitialized logical page '678656' was read while accessing database 'tempdb' (2), object '' (99), index '<Unknown>' (0), partition '<Unknown>' (99). Please contact Sybase Technical Support

    wrongpage
    pg_get_alloc_page
    pg__allocate_near_target
    pg_allocate_from_gam
    pg__allocate_in_oamcreate

    Note: Complete stacktrace is in Attachment section file "stacktrace.txt"


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) - all versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

hardware issue, corruption, temporary database, zombie process, fault, kisignal, stacktrace,  stack, registers , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.