SAP Knowledge Base Article - Preview

2526522 - tempdb started receiving 823, 691 and 692 errors - SAP ASE

Symptom

  • sddone error in errorlog:

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=0x
4000100, Buf stat=0x1, size=8192, cid=0 ('default data cache'), Pinned xdes=0x0000000000000000, spid=0.

  • Error 823 followed by Stacktrace containing:

wrongpage
trunc_wktable
getpage_with_validation
pg_get_alloc_page

  • Error 691 followed by Stacktrace containing:

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.

wrongpage
pg_get_alloc_page
pg__allocate_near_target
pg_allocate_from_gam
pg_allocoam
pg__allocate_in_oamcreate

  • Error 692 followed by Stacktrace containing:

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_allocoam
pg__allocate_in_oamcreate
pg_allocate
crt_work
run_crtable

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

  • All errors were on the same tempdb device

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

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 ONE Support launchpad (Login required).

Search for additional results

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